On Tue, 2005-12-13 at 18:47 -0500, Jim Perrin wrote:
On 12/13/05, Craig White craigwhite@azapple.com wrote:
CentOS 4.2
[root@srv1 certs]# service mysqld start Timeout error occurred trying to start MySQL Daemon. Starting MySQL: [FAILED] [root@srv1 certs]# rm -fr /var/lib/mysql/* [root@srv1 certs]# service mysqld start Initializing MySQL database: [ OK ] Timeout error occurred trying to start MySQL Daemon. Starting MySQL: [FAILED]
I note that I now have some more <defunct> (zombie) chvt processes
WTF?
An apt question. what's in the logs? Also, does your hostname resolve?
---- sure # host srv1.clsurvey.com srv1.clsurvey.com has address 192.168.1.1
# cat /var/log/mysqld.log 051213 16:53:55 mysqld started /usr/libexec/mysqld: Can't create/write to file '/tmp/ibdajdMj' (Errcode: 13) 051213 16:53:55 InnoDB: Error: unable to create temporary file; errno: 13 051213 16:53:55 [ERROR] Can't init databases 051213 16:53:55 [ERROR] Aborting
051213 16:53:55 [Note] /usr/libexec/mysqld: Shutdown complete
051213 16:53:55 mysqld ended
I think you're on to something...
# ls -ld /tmp drwxr-xr-x 51 craig Administrators 4096 Dec 13 16:53 /tmp [root@srv1 certs]# chown root:root /tmp [root@srv1 certs]# chmod 1777 /tmp [root@srv1 certs]# service mysqld start Starting MySQL: [ OK ]
I would never knowingly change owner/permissions on /tmp
I don't know how that came to pass.
Thanks - good catch.
Everytime I tried to run less /var/log/mysqld.log, it would tell me that it's a binary file but I didn't try to 'cat' it until I was going to post it to the list.
Thanks
Craig