Mysql errors in 3.10?

Wednesday 24 October 2007 10:18:20 am

I have a newly updated site from 3.9.2 to 3.9.10.

Since I updated, I think I'm getting random mysql access errors.

The server has installed:

Apache/1.3.33 (Debian GNU/Linux)
PHP/4.4.7-0.dotdeb.0 with Suhosin-Patch mod_perl/1.29
MySQL 4.1.15

I randomly get "kernel 20" errors, in debug some errors are:

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /var/www/web9/web/lib/ezdb/classes/ezmysqldb.php on line 131

Connection error: Couldn't connect to database. Please try again later or inform the system administrator.
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Language 'esl-ES' does not exist or is not used!

Anonymous user not found, returning NoUser

and lot of other errors....

Normally when reloading the page, the error disappears.

I have looked at apache and mysql error logs, but there I haven't found anything. Also the service monitor I have installed didn't report any mysql downtime...

The coincidence is that this never happened with 3.9.2.

Anyone experienced similar problems?

eZ Partner in Madrid (Spain)
Web: http://www.atela.net/

Friday 26 October 2007 6:29:10 am

I came just back to update my post, when I saw your comment.

"Nothing happens without reason" -> true, but sometimes the errors are so hidden and are random that who knows... ;)

I wanted to update that other scripts on that server are having also some random mysql connection errors. I have made some changes in mysql conf file instead listening from "localhost" to "server ip" (found this in google) ... and it seems to work now.

Because it was so a random error, that at the beginning only appeared in a recent upgraded ezp 3.10 install, I had to ask here...

Now we can be sure it hasn't nothing to do with the upgrade or ezp ;)

eZ Partner in Madrid (Spain)
Web: http://www.atela.net/