On Thursday 14 September 2006 17:23, Rob Sterenborg wrote: > 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. Look in the error log! > 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? I haven't used it with mysql 5 myself, only 4.1. But I'm told mysql_ping is different, in that if a connection has timed out, mysql_ping (which the DBD driver uses) will reconnect automatically in 4.1 but not in 5.0. Could it be timing out? If so, check the MySQL docs to see what the idle timeout is and how to change it. You can then tweak your DBD settings. -- Nick Kew Application Development with Apache - the Apache Modules Book http://www.prenhallprofessional.com/title/0132409674 --------------------------------------------------------------------- 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