[mythtv-users] Mysqld wont start at bootup

[Claude Gélinas agr.]

Le mardi 27 février 2007 à 00:35 -0500, David Kramer a écrit :
> Claude Gélinas agr. wrote:
> 
> > I add the following line in /etc/rc.local
> > 
> > /sbin/service mysqld start
> > 
> > and I get the same error message saying that mysqld could not be
> > started.
> > 
> > once booted I can start mysqld with the same command line in a shell as
> > root
> > 
> > I need to go deeper to find what's wrong
> 
> When you try to start it up, do you see any messages in
> /var/log/messages or /var/log/mysqld.log?
> 
> What about /var/log/secure or /var/log/setroubleshoot/setroubleshootd.log
> 
> One possibility is that MySQL is trying to start before something else
> is ready.  You can try renaming the symlink to have a higher number in
> it, so it will start later.  Ask me if you don't understand what I mena
> though.
> 
> Please do:
> find /etc/rc.d -name '*mysqld' -ls
> And post the output.
> 
find /etc/rc.d -name '*mysqld' -ls
6255566    0 lrwxrwxrwx   1 root     claude         16 fév  5
2006 /etc/rc.d/rc6.d/K36mysqld -> ../init.d/mysqld
6254032    0 lrwxrwxrwx   1 root     root           16 fév 22
22:52 /etc/rc.d/rc4.d/S64mysqld -> ../init.d/mysqld
6255561    0 lrwxrwxrwx   1 root     claude         16 fév  5
2006 /etc/rc.d/rc1.d/K36mysqld -> ../init.d/mysqld
6254033    0 lrwxrwxrwx   1 root     root           16 fév 22
22:52 /etc/rc.d/rc5.d/S64mysqld -> ../init.d/mysqld
6254031    0 lrwxrwxrwx   1 root     root           16 fév 22
22:52 /etc/rc.d/rc3.d/S64mysqld -> ../init.d/mysqld
6255559    0 lrwxrwxrwx   1 root     claude         16 fév  5
2006 /etc/rc.d/rc0.d/K36mysqld -> ../init.d/mysqld
6253177    8 -rwxr-xr-x   1 root     root         4608 nov 23
00:40 /etc/rc.d/init.d/mysqld
6252804    0 lrwxrwxrwx   1 root     root           16 fév 22
22:52 /etc/rc.d/rc2.d/S64mysqld -> ../init.d/mysqld

cat /var/log/messages |grep mysql give nothing

cat /var/log/secure |grep mysql give nothing

cat /var/log/mysqld.log |grep mysql give the solution...

070227 22:30:22  mysqld started
070227 22:30:22 [ERROR] Do you already have another mysqld server
running on port: 3306 ?
070227 22:30:25 [Note] /usr/libexec/mysqld: Shutdown complete
070227 22:30:25  mysqld ended

it look like I already have a mysqld server that is running but I don't
know when it is started when I reboot.

I kill all mysqld and check in /var/run/mysqld to remove any pid file
and reboot but I get the same message where mysqld is thinking that
there is another mysqld that is running on pid 3306. It's alway the same
pid number. So there should be somethingthat need to be removed but I
don't know where I should check for that pid number.

-- 
-----
Claude Gélinas agr., dta
Phyto Ressources inc.
==============================================================================
Varennes, Québec, Canada           Tél.: (450) 652 9764,   Fax.:(450) 652 6182
     Des questions sur les insectes et maladies des plantes ornementales ?
                 Want to know more about ornamental plant pest ?
                            http://www.phyto.qc.ca