Topic: /var/lib/mysql/mysql.sock missing
==== Required information ====
- iRedMail version: 0.6.1
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: CentOS 5
- Related log if you're reporting an issue: error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
====
Hi to All,
I've been struggling solving this problem but nothing work. someone please HELP me....
after a power outage on our office when I turned on our email server wont receive and send emails;
here's the maillog:
[root@sulat ~]# tail -f /var/log/maillog
Aug 25 15:24:21 sulat postfix/smtpd[2335]: warning: problem talking to service rewrite: Success
Aug 25 15:24:21 sulat postfix/smtpd[2921]: connect from unknown[74.125.82.177]
Aug 25 15:24:28 sulat postfix/smtpd[2922]: connect from unknown[91.211.241.86]
Aug 25 15:24:41 sulat postfix/smtpd[2925]: connect from unknown[98.139.91.193]
Aug 25 15:24:43 sulat roundcube: MDB2 Error: unknown error (-1): _doConnect: [Error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)] [Native code: 2002] [Native message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)]
Aug 25 15:24:43 sulat roundcube: [25-Aug-2012 15:24:43 +0800]: DB Error: _doConnect: [Error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)] [Native code: 2002] [Native message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)] ** mysqli(mysqli)://roundcube:xxx@localhost/roundcubemail in /var/www/roundcubemail-0.3.1/program/include/rcube_mdb2.php on line 100 (GET /?_task=mail&_action=keep-alive&_t=1345879996046&_remote=1&_=1345879996046&_unlock=0)
Aug 25 15:24:48 sulat postfix/smtpd[2927]: connect from unknown[98.139.52.246]
Aug 25 15:24:54 sulat postfix/smtpd[2928]: connect from unknown[209.255.203.135]
Aug 25 15:24:58 sulat roundcube: MDB2 Error: unknown error (-1): _doConnect: [Error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)] [Native code: 2002] [Native message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)]
Aug 25 15:24:58 sulat roundcube: [25-Aug-2012 15:24:58 +0800]: DB Error: _doConnect: [Error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)] [Native code: 2002] [Native message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)] ** mysqli(mysqli)://roundcube:xxx@localhost/roundcubemail in /var/www/roundcubemail-0.3.1/program/include/rcube_mdb2.php on line 100 (GET /?_task=mail&_action=check-recent&_t=1345880015170&_list=1&_quota=1&_remote=1&_=1345880015173&_unlock=1)
-------------------------------------------------------------------------------------------------------------------------------------------------
[root@sulat ~]# tail -f /var/log/mysqld.log
0x3ea852
0xd1a1fe
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/using … trace.html and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
120825 15:07:10 mysqld ended
----------------------------------------------------------------------------------------------------------------------------------------------------
I checked all services but Mysql wont work:
[root@sulat ~]# /etc/init.d/mysqld status
mysqld is stopped
[root@sulat ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
-----------------------------------------------------------------------------------------------------------------------------------------------------
Here's my /etc/my.cnf configuration
[mysqld]
#bind-address = 127.0.0.1
port = 3306
default-character-set = utf8
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user = mysql
skip-locking
#skip-bdb
#skip-networking
query-cache-type = 1
query-cache-size = 64M
query_cache_limit = 10M
thread_cache_size = 8
set-variable = max_connections=1024
#set-variable = max_connect_errors=150
#ssl-ca =
ssl-cert = /etc/pki/tls/certs/iRedMail_CA.pem
ssl-key = /etc/pki/tls/private/iRedMail.key
ssl-cipher = ALL
[client]
default-character-set=utf8
[mysql.server]
user = mysql
basedir = /var/lib
[mysqld_safe]
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
-------------------------------------------------------------------------------------------------------------------------------------------------------
I think this is the error:
[root@sulat log]# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
Thank you in advance for those will help me...
Ruby Alberto
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.