[CentOS] mysqld service

[Craig White]

On Tue, 2005-12-13 at 18:47 -0500, Jim Perrin wrote:
> On 12/13/05, Craig White <craigwhite at azapple.com> wrote:
> > CentOS 4.2
> >
> > [root at srv1 certs]# service mysqld start
> > Timeout error occurred trying to start MySQL Daemon.
> > Starting MySQL:                                            [FAILED]
> > [root at srv1 certs]# rm -fr /var/lib/mysql/*
> > [root at 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 at srv1 certs]# chown root:root /tmp
[root at srv1 certs]# chmod 1777 /tmp
[root at 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