libapache2-mod-auth-mysql u. MySQL Error 111
Ich hab folgendes laufen:
apache-mpm-prefork: 2.0.50-11
libapache2-mod-auth-mysql 4.3.5
und bekomme nach dem Anlegen einer .htaccess-Datei
--------------------------------------------------
AuthMySQL on
AuthName "JOCHEN"
AuthType basic
Auth_MySQL_Password_Field passwd
Auth_MySQL_Username_Field username
Auth_MySQL_Encryption_Types Plaintext PHP_MD5
require valid-user
--------------------------------------------------
immer folgende Fehlermeldungen:
--------------------------------------------------
[Tue Aug 31 05:33:06 2004] [debug] mod_auth_mysql.c(1470): Starting
basic user auth for [jochen] in /var/www/, child pid 6026
[Tue Aug 31 05:33:06 2004] [debug] mod_auth_mysql.c(1285):
Constructing password collection query with passfield=[passwd],
table=[mysql_auth], userfield=[jochen], where_clause=[]
[Tue Aug 31 05:33:06 2004] [debug] mod_auth_mysql.c(1139): sec->dbh
in /var/www/ is
[Tue Aug 31 05:33:06 2004] [debug] mod_auth_mysql.c(1146): Ordinary
query
[Tue Aug 31 05:33:06 2004] [debug] mod_auth_mysql.c(1151): No DB
connection open - firing one up
[Tue Aug 31 05:33:06 2004] [debug] mod_auth_mysql.c(1043): Opening
DB connection for /var/www/
[Tue Aug 31 05:33:06 2004] [error] Connection error: Can't connect
to MySQL server on '127.0.0.1' (111)
[Tue Aug 31 05:33:06 2004] [debug] mod_auth_mysql.c(1154):
open_auth_dblink returned 2003
[Tue Aug 31 05:33:06 2004] [debug] mod_auth_mysql.c(1304): Failed
query was: [SELECT passwd FROM mysql_auth WHERE username='jochen']
[Tue Aug 31 05:33:06 2004] [debug] mod_auth_mysql.c(1497):
mysql_check_user_password returned error
--------------------------------------------------
In meiner globalen apache2.conf hab ich folgendes
stehen:
--------------------------------------------------
AuthMySQL_DefaultHost 127.0.0.1
AuthMySQL_DefaultDB mysql_auth
AuthMySQL_DefaultUser mysql_auth
AuthMySQL_DefaultPassword jochen
--------------------------------------------------
Hat das Teil jemand am Laufen?
--
Jochen
Reply to: