[mythtv-users] MYSQL not starting...

[Lan Barnes]

On Thu, May 10, 2007 6:10 pm, A JM wrote:
> Same errors even after creating the files...
>
> May 10 21:10:26 myth mysqld_safe[4019]: started
> May 10 21:10:26 myth mysqld[4022]: ^G/usr/sbin/mysqld: File
> '/var/log/mysql/mysql-bin.index' not found (Errcode: 13)
> May 10 21:10:26 myth mysqld[4022]: 070510 21:10:26 [ERROR] Aborting
> May 10 21:10:26 myth mysqld[4022]:
> May 10 21:10:26 myth mysqld[4022]: 070510 21:10:26 [Note]
> /usr/sbin/mysqld: Shutdown complete
> May 10 21:10:26 myth mysqld[4022]:
> May 10 21:10:26 myth mysqld_safe[4024]: ended
> May 10 21:10:40 myth /etc/init.d/mysql[4255]: 0 processes alive and
> '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping'
> resulted in
> May 10 21:10:40 myth /etc/init.d/mysql[4255]: ^G/usr/bin/mysqladmin:
> connect to server at 'localhost' failed
> May 10 21:10:40 myth /etc/init.d/mysql[4255]: error: 'Can't connect to
> local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
> May 10 21:10:40 myth /etc/init.d/mysql[4255]: Check that mysqld is
> running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
> May 10 21:10:40 myth /etc/init.d/mysql[4255]:
> May 10 21:11:15 myth mysqld_safe[4828]: started
> May 10 21:11:15 myth mysqld[4831]: ^G/usr/sbin/mysqld: File
> '/var/log/mysql/mysql-bin.index' not found (Errcode: 13)
> May 10 21:11:15 myth mysqld[4831]: 070510 21:11:15 [ERROR] Aborting
> May 10 21:11:15 myth mysqld[4831]:
> May 10 21:11:15 myth mysqld[4831]: 070510 21:11:15 [Note]
> /usr/sbin/mysqld: Shutdown complete
> May 10 21:11:15 myth mysqld[4831]:
> May 10 21:11:15 myth mysqld_safe[4833]: ended
> May 10 21:11:29 myth /etc/init.d/mysql[4968]: 0 processes alive and
> '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping'
> resulted in
> May 10 21:11:29 myth /etc/init.d/mysql[4968]: ^G/usr/bin/mysqladmin:
> connect to server at 'localhost' failed
> May 10 21:11:29 myth /etc/init.d/mysql[4968]: error: 'Can't connect to
> local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
> May 10 21:11:29 myth /etc/init.d/mysql[4968]: Check that mysqld is
> running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
> May 10 21:11:29 myth /etc/init.d/mysql[4968]:
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

If the front and back end share the same box, check /etc/hosts to make
sure the line

  127.0.0.1  localhost

is in there. I recently found it wasn't on mine (MythDora 3.2) and that I
had intermittent mythfilldatabase failures. On another machine, MySQL
wouldn't start.

I'll post at more length separately about this.

(This is a repeat of a reply to a similar problem. With the high traffic
on this list, I thought you might miss it.)

-- 
Lan Barnes

SCM Analyst              Linux Guy
Tcl/Tk Enthusiast        Biodiesel Brewer