Apache / FreeBSD problem...
 

I am running the following on FreeBSD 5.2-RELEASE #0

Apache/1.3.29 (Unix)
AuthMySQL/2.20
PHP/5.0.0a3-alexdupre
mod_ssl/2.8.16
OpenSSL/0.9.7c

Now when I try to access my directory protected by auth_mysql, I get the popup box as normal. However should I cancel, enter correct info or enter incorrect info, I always receive a 500 internal server error page.

My apache log shows me the following:

[Mon Mar 1 17:21:45 2004] [error] (49)Can't assign requested address: MySQL auth: connect failed: Can't connect to MySQL server on '192.168.0.77' (49)

I assumed this was some kind of server config / network issue, but have searched the web and found no help. I've verified my /etc/hosts, verified my loopback is configured, verified MySQL is running and the host/user/pass defined in my info line for auth_mysql in httpd.conf is valid...

Anyone have any suggestions, solutions ??

Thx

Is the DB located on another server or is it located on this machine? Is the IP binded to a server?

If the DB is located on the same machine then try switching the ip address to 127.0.0.1 (localhost address) and see if it works. If the machine is on the other box then make sure that mysql is running and that the IP 192.168.0.77 is binded to that machine.

I solved the trouble. It seems just the auth_mysql module itself is buggy, I installed an alternate one from FreeBSD ports:

/usr/ports/www/mod_auth_mysql_another/

and it works perfectly right away without any other changes on the server =)