0

The problem I'm having is that MySQL (5.5.46-0+deb7u1) is not generating log files. This on Debian Wheezy.

The my.cfg file has been updated according to the required config for logging ALL queries (as per http://www.microhowto.info/howto/log_all_queries_to_a_mysql_server.html). It's not writing to the specified location, nor to the default location.

Mysql errors are also not being logged, as far as I can tell.

EDIT: my.cnf is here: http://pastie.org/private/q9vwgihslpenc94mxmyyiw

EDIT: Here's the output of "show variables like '%warn%';":

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_warnings  | 1     |
| sql_warnings  | OFF   |
| warning_count | 0     |
+---------------+-------+
  • could You attache my.cnf file? result of - show variables like '%warn%'; ? – a_vlad Nov 16 '15 at 17:06
  • ok, I've edited the question with that info. – geoidesic Nov 16 '15 at 18:17
  • 1
    Are you sure the location(s) exist and are writable by the mysql user? – Silvarion Nov 16 '15 at 18:30
  • They exist, I'm not sure what the ownership / permissions should be on debian? – geoidesic Nov 16 '15 at 18:36
  • 1
    normal error file not enables as I can see , like log-error=/var/log/mysql/mysqld.log next good to check ls -l /var/log/mysql for permission – a_vlad Nov 16 '15 at 18:40
0

Thanks to commenters for their insights. The solutions was:

  1. Add "log_errors = /var/log/mysql/mysql.err" to my.cnf
  2. See permissions error in error log
  3. chmod log files to "mysql:root"
| improve this answer | |
  • 1
    check as well permission for whole folder - /var/log/mysql in this case in feature not need check single file permissions – a_vlad Nov 16 '15 at 18:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.