[mythtv-users] Mysql not starting

[Matthew Asplund]

>Matthew Asplund wrote:
>>* I rebooted my Ubuntu Dapper Drake/mythtv0.20 setup this morning, and it
*>*> isn't restarting correctly.  I cannot start up mythbackend because it
*>*> says that mysql is not running (which is correct).  I try running
*>*> /etc/init.d/mysql start and it times out starting msqladmin, because it
*>*> cannot connect to the socket.  I try running mysqld as root, and (sudo
*>*> /usr/sbin/msqld) and it says it cannot start because the port is already
*>*> bound to a process, and to check that a mysql server is already
*>*> running.  ps -aux | grep sql shows nothing running.
*>*>
*>*> I am not sure what to do.  How do I find out what is blocking access to
*>*> the port?  I have done several updates from binary .debs from the one
*>*> apt repository (I cannot remember the address, and I am at work, so I
*>*> cannot look up the address, it may have been the iowa state one, but it
*>*> might have been another).
*>*>
*>*> (This is only a crisis, because The Office is on tonight, and my son has
*>*> a concert, though I can record it another way if I have to.)
*>*>
*>*> Matthew Asplund
*
>what does
>
>lsof | grep mysql
>
>say?

>Tom

So here's the end of the story.  I run a netstat, and nothing was listed as
accessing port 3306.  I run the lsof and nothing was using any mysql files. I
even rebooted in single user mode, and it still said that the port was not
available.  Luckily at this point I had to take my son to a jazz band
concert, and
I was explaining what the problem was, when I realized that the
problem was with
the IP address.  Sure enough, when I re-booted the computer  my linksys router
had given a different IP address then usual to the computer, and I had
hard-coded
the IP address of the server to be 192.168.1.100, but it had gotten
192.168.1.103
from DCHP.  So I fixed the IP address and everything works now.

Thanks for the help
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20061027/5012325e/attachment.htm