MySQL daemon will not start

General discussion on Zend Core for IBM System i
Post Reply
hessrk
Posts: 4
Joined: Mon Aug 17, 2009 10:25 pm

MySQL daemon will not start

Post by hessrk » Sat Aug 22, 2009 7:02 am

Zend Core v2.6.1
i5/OS V6R1M0

MySQL subsystem starts with no issue. However, daemon fails to start. Job log states that /tmp/mysql.sock cannot be found.

Checked authority and user profile MYSQL has all authority over /tmp and /usr/local/mysql-5.0.45-i5os-power-64bit.

running mysqladmin -u root status gives me (same with ping):
mysqladmin -u root status
/usr/local/mysql-5.0.45-i5os-power-64bit/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
running mysqld_safe -u root & gives me:
mysqld_safe -u root &
[1] 8450
$ Starting mysqld daemon with databases from /usr/local/mysqldata
STOPPING server from pid file /usr/local/mysqldata/myserver.pid
090822 01:01:34 mysqld ended

Any ideas?

Thanks,
Rodney

timclark2000
Posts: 71
Joined: Fri May 01, 2009 8:19 pm

Re: MySQL daemon will not start

Post by timclark2000 » Mon Aug 24, 2009 12:28 pm

We need to figure out why the mysqld daemon is stopping immediately after it is started. There should be a clue in the error log, which will be located in /usr/local/mysqldata/ and will have a ".err" suffix. Do you see any clues in there that indicate the reason for the failure? Perhaps you can post the most recent lines from that file.

User avatar
rodflohr
Zend Global Support
Posts: 56
Joined: Mon Dec 29, 2008 5:28 pm

Re: MySQL daemon will not start

Post by rodflohr » Mon Aug 24, 2009 11:00 pm

In the job log we will often see something like this:

RNM OBJ('/tmp/mysql.sock') NEWOBJ('mysql.sock')
Object not found. Object is /tmp/mysql.sock.

This indicates that MySQL was not installed with the QSECOFR user profile. The MySQL installation has to be done by QSECOFR, no other user profile can do it. This is because the installer performs an operation that requires UID 0 (User ID Zero). On the i5, only QSECOFR can be UID 0.

We have a Knowledge Base article that describes how to uninstall and reinstall MySQL: http://www.zend.com/support/knowledgeba ... iew_only=1

User avatar
shlomov
Zend Global Support
Posts: 139
Joined: Mon Dec 29, 2008 2:38 pm

Re: MySQL daemon will not start

Post by shlomov » Wed Aug 26, 2009 3:15 pm

If the previous article link is not available please use the following:
http://kb.zend.com/index.php?View=entry&EntryID=305
Shlomo Vanunu
IBM System i

zedmond
Posts: 1
Joined: Wed Jul 22, 2009 3:13 pm

Re: MySQL daemon will not start

Post by zedmond » Tue Sep 01, 2009 7:39 pm

I am having a similar problem. I try to start MySql 5.1.37-i5os-power-64bit and the daemon instantly ends.

$./mysqld_safe &
[1] 61612
$ 090821 12:40:14 mysqld_safe Logging to '/usr/local/data/LAB.armp.org.err'.
090821 12:40:15 mysqld_safe Starting mysqld daemon with databases from /usr/l
ocal/data
090821 12:40:16 mysqld_safe mysqld from pid file /usr/local/data/LAB.armp.org
.pid ended

The contents of the error log is:
090821 12:40:15 mysqld_safe Starting mysqld daemon with databases from /usr/l
ocal/data
090821 12:40:16 [Warning] Setting lower_case_table_names=2 because file syste
m for /usr/local/data/ is case insensitive
090821 12:40:16 [Warning] One can only use the --user switch if running as ro
ot

$+?ÈÁ) &%ÍÅÑ> ãáàáê èáà ÑË ÀÑË/Â%ÁÀ ñ>>?àâ áÊÊ?Ê øÈÇÊÁ/À
¬ÄÊÁ/ÈÁ ÊÁÈÍÊ>ÁÀ 090821 12:40:16 mysqld_safe mysqld from pid file /usr/loc
al/data/LAB.armp.org.pid ended

mjhaston
Posts: 3
Joined: Thu Feb 04, 2010 5:33 pm

Re: MySQL daemon will not start

Post by mjhaston » Thu Feb 04, 2010 5:34 pm

rodflohr wrote:In the job log we will often see something like this:

RNM OBJ('/tmp/mysql.sock') NEWOBJ('mysql.sock')
Object not found. Object is /tmp/mysql.sock.

This indicates that MySQL was not installed with the QSECOFR user profile. The MySQL installation has to be done by QSECOFR, no other user profile can do it. This is because the installer performs an operation that requires UID 0 (User ID Zero). On the i5, only QSECOFR can be UID 0.

We have a Knowledge Base article that describes how to uninstall and reinstall MySQL: http://www.zend.com/support/knowledgeba ... iew_only=1


I have been logged in as QSECOFR and have had no luck. I've uninstalled and installed MySQL several times now with no luck.

Post Reply