I'm using plesk and the database server is functioing except for a few problems.


It's not writing the log file and I'm aslo using Watchdog which will report it as down and release it from monitoring except it's working fine.

After finding the log files not written too the last entry was from back in February when I had a issue solved by support but apparently they must have fixed wrong thing, I want to solve this myself which is why I'm posting this.

Here's the symptoms I have:

1. I have blank mysqld.log file . I have another one with the name mysqld.log| that is being written too ***.

2. If I do "service mysqld restart" mysqld starts but I get this message:

chown: cannot access `/var/lib/mysql\r': No such file or directory
chown: cannot access `/var/lib/mysql\r': No such file or directory
chmod: cannot access `/var/lib/mysql\r': No such file or directory
Note that this error does ot seem to cause any problems.

3. The my.cnf file was one I uploaded that was edited on windows machine so it's dos file. The directives in the DOS my.cnf work, I can change them and restart mysql and the new variables will listed if I go to phpmyadmin.

This is where it gets weird at least form my perspective. If I use vi to create a new one or use dos2unix to convert it then try to restart mysql it will fail. my only guess is that some lines are being skipped that are causing errors when I convert it to unix format. ***This apparently is when the log file will be written too. Here's the last lines in log:

InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
081124 5:34:20 InnoDB: Started; log sequence number 0 149928160
081124 5:34:20 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
081124 5:40:24 [Note] /usr/libexec/mysqld: Normal shutdown

081124 5:40:24 InnoDB: Starting shutdown...
081124 5:40:26 InnoDB: Shutdown completed; log sequence number 0 149928160
081124 5:40:26 [Note] /usr/libexec/mysqld: Shutdown complete

081124 05:40:26 mysqld ended
I've searched and tried a lot of different things but I think the first thing I need to figure out is why it fails when the my.cnf is not a DOS file.