[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#490801: apache2-mpm-prefork: mod_dbd /w mysql support gives: [error] (20014)Internal, error: DBD: failed to initialise

Package: apache2-mpm-prefork
Version: 2.2.9-2
Severity: important



-- Package-specific info:
Config file syntax check failed.
List of /etc/apache2/mods-enabled/*.load:
  alias auth_basic auth_digest authn_dbd authn_file authz_default
  authz_groupfile authz_host authz_user autoindex cgi dbd dir env
  evasive20 mime negotiation php5 security2 setenvif status unique_id
  userdir

-- System Information:
Debian Release: lenny/sid
  APT prefers testing
  APT policy: (500, 'testing'), (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.18-5-686 (SMP w/2 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/bash

Versions of packages apache2-mpm-prefork depends on:
ii  apache2.2-common           2.2.9-2       Apache HTTP Server common files
ii libapr1 1.2.12-4 The Apache Portable Runtime Librar ii libaprutil1 1.2.12+dfsg-7 The Apache Portable Runtime Utilit 
ii  libc6                      2.7-10        GNU C Library: Shared libraries
ii libpcre3 7.4-1+lenny2 Perl 5 Compatible Regular Expressi 

apache2-mpm-prefork recommends no packages.

-- no debconf information

Relevant configuration lines from apache2.conf that produce this error:
-----------------------------------------
<VirtualHost *>
	#some DocumentRoot etc. directives	
    DBDriver mysql
DBDParams "host=127.0.0.1 port=3306 dbname=authdb user=apache password=0123456789" 
    DBDPersist On
    DBDMin  1
    DBDKeep 8
    DBDMax  20
    DBDExptime 300
    <Directory /var/www/dspam>
        AuthType Basic
        AuthName "Dspam WebUI"
        AuthUserFile /dev/null
        AuthBasicProvider dbd
        Require valid-user
        AuthDBDUserPWQuery "SELECT passwd FROM userdb WHERE uname = %s"
    </Directory>
	#some logging opts
</VirtualHost>
-------------------------------------------
The user/pass combination is confirmed to be working (using unix domain socket and network socket). 
After starting apache2 with 'LogLevel debug' - this is exactly what I see:
--------------------------------------------
Jul 14 13:49:15 urke2 apache2[4788]: [info] mod_unique_id: using ip addr 192.168.7.166 Jul 14 13:49:16 urke2 apache2[4788]: [debug] mod_security2.c(404): SecServerSignature: Changed server signature to "Sigma i Pi 3.1415". Jul 14 13:49:16 urke2 apache2[4788]: [notice] ModSecurity for Apache/2.5.5 (http://www.modsecurity.org/) configured. Jul 14 13:49:16 urke2 apache2[4788]: [notice] Original server signature: Apache/2.2.9 (Debian) Jul 14 13:49:16 urke2 apache2[4790]: [notice] Digest: generating secret for digest authentication ... 
Jul 14 13:49:16 urke2 apache2[4790]: [notice] Digest: done
Jul 14 13:49:16 urke2 apache2[4790]: [info] mod_unique_id: using ip addr 192.168.7.166 Jul 14 13:49:17 urke2 apache2[4790]: [debug] mod_security2.c(404): SecServerSignature: Changed server signature to "Sigma i Pi 3.1415". Jul 14 13:49:17 urke2 apache2[4793]: [error] (20014)Internal error: DBD: failed to initialise Jul 14 13:49:17 urke2 apache2[4795]: [error] (20014)Internal error: DBD: failed to initialise Jul 14 13:49:17 urke2 apache2[4794]: [error] (20014)Internal error: DBD: failed to initialise Jul 14 13:49:17 urke2 apache2[4790]: [notice] Apache/2.2.9 (Debian) Sigma i Pi 3.1415 configured -- resuming normal operations Jul 14 13:49:17 urke2 apache2[4790]: [info] Server built: Jun 21 2008 10:35:35 Jul 14 13:49:17 urke2 apache2[4790]: [debug] prefork.c(1024): AcceptMutex: sysvsem (default: sysvsem) Jul 14 13:49:17 urke2 apache2[4796]: [error] (20014)Internal error: DBD: failed to initialise Jul 14 13:49:17 urke2 apache2[4797]: [error] (20014)Internal error: DBD: failed to initialise 
--------------------------------------------
When I try to access the protected site inside the VH above I get a correct login window but after giving the login/password combination I get "500 Internal Server Error" and the same message appears in logs (but only once): 
----------------------------------------------
Jul 14 13:56:09 urke2 apache2[4803]: [error] (20014)Internal error: DBD: failed to initialise 
----------------------------------------------

Attachment: signature.asc
Description: OpenPGP digital signature

Reply to: