Topic: Webmail error "Can't connect to local MySQL ..."

[Mike Coan]

I previously installed the Webmail package and it worked fine.  We decided to use a different machine for the email server, so I just did a new e-smith and webmail installation.  Everything seemed to go fine.  I received no error messages, and I can send and retrieve email via the typical email client.

When I tried to access www.mydomainname.com/horde/imp/  I got the follwoing error message:

Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/e-smith/files/primary/horde-phplib/db_mysql.inc on line 73

Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/e-smith/files/primary/horde-phplib/db_mysql.inc on line 73

Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/e-smith/files/primary/horde-phplib/db_mysql.inc on line 73

It is repeated 3 times just like I have it here.

I looked at the file db_mysql.inc, but I couldn't tell anything from that.

Should I just try setup.php3 again.  I ran both sh secure.sh and sh scripts/database/dbpasswd.sh, so I asume i would have to do some chmod to access setup.php3 again.

Any hints would be helpful.

Thanks

[Dan Brown]

This isn't a problem with the horde/imp setup; it's a problem with the PHP setup.  Have you installed e-smith-php4-0.2-2.noarch.rpm?  If so, try '/sbin/e-smith/expand-template /etc/httpd/conf/php.ini' and 'service httpd restart', and see if the problem recurs.

[Noah]

If you do a search for mysql.sock in the Advanced Forum on
this site you will find some postings about this. Ultimately, the link to
/tmp/mysql.sock is broken, or not there. You can add a virtual
link to where it is (/var/lib/mysql/mysql.sock) and it should fix everything. Here is a bit from one of the posts about this:

 # Adding the soft-link to the correct location, fixes the problem:
 ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

 Hope that helps.

 Noah

[Dan Brown]

The problem is that you shouldn't have to have a /tmp/mysql.sock, as the php.ini file generated from my e-smith-php4-0.2-2 should be telling PHP to use /var/lib/mysql/mysql.sock instead.  I've had a few reports of this not working, but I haven't been able to track down why yet.  Making the symlink will certainly work, but it won't fix the underlying problem, which is PHP looking in the wrong place.

[stephen noble]

fatal error:  Call to undefined function:  mysql_pconnect() in db_mysql.inc on line 73

this sounds related
does this slightly different error message error help ?

and ln -s ... didn't fix it

[Dan Brown]

This is caused by a lack of MySQL support in PHP, which has one of two probable causes.  Either you have not installed the php-mysql RPM, or you have not installed the e-smith-php4-0.2-2 RPM.