Hi all,
I have installed httpd-2.2.3, apr-1.2.7 and apr-util-1.2.7 with MySQL
support (using MySQL-5.0.24a).
When I start the server authentication works well.
After some time (don't know much) when I try to logon I get error 500. When I
restart Apache, authentication is working again.
Below is an error log from start to end (including apachectl restart and
succeeding at last) with LogLevel set to debug. The access log doesn't have
any useful information except one line reporting error 500.
As can be read in thread "Apache 2.2.3 and MySQL 5.0.24a", I have recompiled
all of this a number of times, each time with the same problem.
Anybody know why after some time DBD cannot lookup the username anymore?
Regards,
Rob
====================
Error log:
[Thu Sep 14 15:31:05 2006] [debug] mod_deflate.c(447): [client
<client_ip>] Zlib: Compressed 566 to 380 : URL /windl
[Thu Sep 14 15:31:07 2006] [error] [client 193.173.147.3] Error looking up
<username> in database
[Thu Sep 14 15:31:07 2006] [debug] mod_deflate.c(447): [client
<client_ip>] Zlib: Compressed 711 to 425 : URL /windl
(restarted Apache here..)
[Thu Sep 14 15:31:34 2006] [debug] mod_deflate.c(447): [client
<client_ip>] Zlib: Compressed 406 to 277 : URL /windl
[Thu Sep 14 15:31:35 2006] [debug] mod_deflate.c(447): [client
<client_ip>] Zlib: Compressed 5183 to 1188 : URL /windl/
====================
Relevant httpd.conf sections:
DBDriver mysql
DBDParams "host=<db_host> dbname=<db_name> user=<db_user> pass=<db_pass>"
DBDMin 1
DBDKeep 2
DBDMax 10
DBDExptime 60
<VirtualHost *:80>
ServerAdmin postmaster@xxxxxxxxxxxxxxx
DocumentRoot /path/to/website
ServerName www.sterenborg.info
ErrorLog /path/to/e_www
CustomLog /path/to/a_www combined
LogLevel debug
</VirtualHost>
<Directory /path/to/windl>
DirectoryIndex index.php
AuthName "Please enter your logon details..."
AuthType Basic
AuthBasicProvider dbd
AuthDBDUserPWQuery "select <pwd_field> from users where <usr_field>=%s"
AuthzDBDQuery "SELECT <grp_field> FROM users WHERE <usr_field>=%s"
Require dbd-group admins download
Options Indexes
IndexOptions FancyIndexing FoldersFirst NameWidth=60
</Directory>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx
" from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
|