Re: [users@httpd] Error 500 with DBD-MySQL auth

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

 



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



[Index of Archives]     [Open SSH Users]     [Linux ACPI]     [Linux Kernel]     [Linux Laptop]     [Kernel Newbies]     [Security]     [Netfilter]     [Bugtraq]     [Squid]     [Yosemite News]     [MIPS Linux]     [ARM Linux]     [Linux Security]     [Linux RAID]     [Samba]     [Video 4 Linux]     [Device Mapper]

  Powered by Linux