More mySQL troubles...
--------------------------------------------
Database error in vBulletin :
Link-ID == false, connect failed
mysql error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
--------------------------------------------
It only seems to be the one site that is receiving this error message. The site itself and it's forums are working, it's just that the site admin is receiving hundreds of these error emails.
I did have some trouble with mySQL recently while trying to change the server settings, but I resolved that.
I have the my.cnf and the my.cnf.admin_appl files in the /etc folder set as following:
--------------------------------------------
# mysql.admin access
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=400
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=7200
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
open_files_limit=8192
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
--------------------------------------------
Did I make a mistake somewhere or does anybody have an idea why the site admin might receiving all these emails. I've only just changed the my.cnf files and the path to the mysql.sock was set wrongly before, so maybe that now the error emails will stop, but I just wanted to check if anybody had any other ideas, just in case.
The server is running Ensim LS 3.0
