Apache / FreeBSD problem...

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • KidCock
    So Fucking Banned
    • May 2003
    • 788

    #1

    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
  • notjoe
    Confirmed User
    • May 2002
    • 5599

    #2
    Originally posted by KidCock
    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.

    Comment

    • KidCock
      So Fucking Banned
      • May 2003
      • 788

      #3
      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 =)

      Comment

      Working...