Topic: can't start mysql with innodb

[DeMan]

Hi list,

I'm trying to use mysql with InnoDB for a large Zarafa database.

But when I'm using InnoDB I can't connect with mysql because the listener is not started.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

See below my console commands:

[root@smtp mysqld]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit
Bye
[root@smtp mysqld]# /sbin/e-smith/db configuration setprop mysqld InnoDB enabled
[root@smtp mysqld]# /sbin/e-smith/expand-template /etc/my.cnf
[root@smtp mysqld]# sv t /service/mysqld
[root@smtp mysqld]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

When I disable InnoDB, everything is working just fine.

Please help... you could make my day

Bob

[Stefano]

is there anything in mysql log? and in /var/log/messages?

Stefano

[DeMan]

Hi Stefano,

No... not much in messages... only errors related to the fact that there is no listener.

Jun  1 10:58:48 smtp fstab-sync[4256]: added mount point /media/cdrom for /dev/hda
Jun  1 10:58:49 smtp 10fix_privilege_tables: ERROR
Jun  1 10:58:49 smtp 10fix_privilege_tables: waiting for mysqld to restart
Jun  1 10:58:49 smtp 10fix_privilege_tables:  2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Jun  1 10:58:49 smtp 10fix_privilege_tables: cat: /var/run/mysqld/mysqld.pid: No such file or directory
Jun  1 10:58:49 smtp 10fix_privilege_tables: /bin/rm: cannot remove `/var/run/mysqld/mysqld.pid': No such file or directory
Jun  1 10:58:49 smtp 10fix_privilege_tables: kill: usage: kill [-s sigspec | -n signum | -sigspec] [pid | job]... or kill -l [sigspec]
Jun  1 10:58:50 smtp 10fix_privilege_tables: waiting for mysqld to restart
Jun  1 10:58:57 smtp atalkd[4103]: zip_getnetinfo for eth0
Jun  1 10:59:08 smtp last message repeated 18 times
Jun  1 10:59:09 smtp 10fix_privilege_tables: mysqld failed to restart
Jun  1 10:59:09 smtp mysql.init: Loading 10fix_privilege_tables into mysql failed
Jun  1 10:59:09 smtp 20mysql_migrate_horde: ERROR
Jun  1 10:59:09 smtp 20mysql_migrate_horde:  2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Jun  1 10:59:09 smtp mysql.init: Loading 20mysql_migrate_horde into mysql failed
Jun  1 10:59:09 smtp 21horde.mysql_set_password: ERROR
Jun  1 10:59:09 smtp 21horde.mysql_set_password:  2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Jun  1 10:59:09 smtp mysql.init: Loading 21horde.mysql_set_password into mysql failed
Jun  1 10:59:09 smtp 30horde_mysql_create_tables: ERROR
Jun  1 10:59:09 smtp 30horde_mysql_create_tables:  2013 (HY000): Lost connection to MySQL server during query
Jun  1 10:59:09 smtp mysql.init: Loading 30horde_mysql_create_tables into mysql failed
Jun  1 10:59:09 smtp 31horde_upgrade: DBI connect('horde','root',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at /etc/e-smith/events/actions/horde_upgrade line 41
Jun  1 10:59:09 smtp mysql.init: Loading 31horde_upgrade into mysql failed
Jun  1 10:59:09 smtp 35imp_mysql_create_tables: ERROR
Jun  1 10:59:09 smtp 35imp_mysql_create_tables:  2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Jun  1 10:59:09 smtp mysql.init: Loading 35imp_mysql_create_tables into mysql failed
Jun  1 10:59:10 smtp 36imp_upgrade: DBI connect('horde','root',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at /etc/e-smith/events/actions/imp_upgrade line 41
Jun  1 10:59:10 smtp mysql.init: Loading 36imp_upgrade into mysql failed
Jun  1 10:59:10 smtp 40mysql.create.turba: ERROR
Jun  1 10:59:10 smtp 40mysql.create.turba:  2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Jun  1 10:59:10 smtp mysql.init: Loading 40mysql.create.turba into mysql failed
Jun  1 10:59:10 smtp 50turba_upgrade: DBI connect('horde','root',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at /etc/e-smith/events/actions/turba_upgrade line 44
Jun  1 10:59:10 smtp mysql.init: Loading 50turba_upgrade into mysql failed
Jun  1 10:59:10 smtp 57turba_mysql_reset_addressbook_pref: ERROR
Jun  1 10:59:10 smtp 57turba_mysql_reset_addressbook_pref:  2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Jun  1 10:59:10 smtp mysql.init: Loading 57turba_mysql_reset_addressbook_pref into mysql failed
Jun  1 10:59:10 smtp mysql.init: Loading 60migrate-imp-to-turba into mysql succeeded
Jun  1 10:59:10 smtp 77horde_mysql_update_privs: ERROR
Jun  1 10:59:10 smtp 77horde_mysql_update_privs:  2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Jun  1 10:59:10 smtp mysql.init: Loading 77horde_mysql_update_privs into mysql failed
Jun  1 10:59:10 smtp 78mysql.create.ingo: ERROR
Jun  1 10:59:10 smtp 78mysql.create.ingo:  2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Jun  1 10:59:10 smtp mysql.init: Loading 78mysql.create.ingo into mysql failed
Jun  1 10:59:11 smtp 79ingo_upgrade: DBI connect('horde','root',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at /etc/e-smith/events/actions/ingo_upgrade line 41
Jun  1 10:59:11 smtp mysql.init: Loading 79ingo_upgrade into mysql failed
Jun  1 10:59:11 smtp 80zarafa: ERROR
Jun  1 10:59:11 smtp 80zarafa:  2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Jun  1 10:59:11 smtp mysql.init: Loading 80zarafa into mysql failed
Jun  1 10:59:11 smtp zarafa-gateway: zarafa-gateway startup succeeded
Jun  1 10:59:11 smtp zarafa-ical: zarafa-ical startup succeeded
Jun  1 10:59:11 smtp zarafa-licensed: zarafa-licensed startup succeeded
Jun  1 10:59:12 smtp zarafa-server: zarafa-server startup failed
Jun  1 10:59:12 smtp zarafa-spooler: zarafa-spooler startup succeeded

No message in the myslq logfile... probably the service failed before the logging
is started.

Kind regards,

Bob

[cactus]

Moving this topic to SME 7.x Contribs as it is more appropriate there.

[DeMan]

Hi List,

I solved this issue, by reinstall the server.

InnoDB works out of the box perfect.

I guess something went wrong during the FS resize of /var. I used the -l param to unmount /var. (lazy mount)

Bob