[mythtv-users] MYSQL not starting...

[Nick Morrott]

On 09/05/07, A JM <vbtalent at gmail.com> wrote:
> Just now getting a chance to get back to fixing this...
>
> This is from the daemon.log, does it give any hints on how to fix it?
>
> May  9 06:56:09 myth mysqld_safe[11112]: started
> May  9 06:56:09 myth mysqld[11115]: ^G/usr/sbin/mysqld: File
> '/var/log/mysql/mysql.log' not found (Errcode: 13)
> May  9 06:56:09 myth mysqld[11115]: 070509  6:56:09 [ERROR] Could not
> use /var/log/mysql/mysql.log for logging (error 13). Turning logging
> off for the whole duration of the MySQL server process. To turn it on
> again: fix the cause, shutdown the MySQL server and restart it.
> May  9 06:56:09 myth mysqld[11115]: ^G/usr/sbin/mysqld: File
> '/var/log/mysql/mysql-bin.index' not found (Errcode: 13)
> May  9 06:56:09 myth mysqld[11115]: 070509  6:56:09 [ERROR] Aborting

Just saw your post to the MySQL forums, so I'll let the real experts
help you out there.

Please post your /etc/my.cnf file. It could be that your 'datadir'
parameter is not set to the correct directory that contains
mysql-bin.index, or that you do not have 'log-bin-index' pointing the
binary log index. You could turn off binary logging if you do not
want/need it, and it's an idea to create the mysql logfile if it's
missing:

# touch /var/log/mysql/mysql.log && chown mysql:mysql
/var/log/mysql/mysql.log && chmod 640 /var/log/mysql/mysql.log

Nick
-- 
MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin