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     |
+---------------+-------+
Improve this question
5
  • could You attache my.cnf file? result of - show variables like '%warn%'; ?
    – a_vlad
    Nov 16, 2015 at 17:06
  • ok, I've edited the question with that info.
    – geoidesic
    Nov 16, 2015 at 18:17
  • 1
    Are you sure the location(s) exist and are writable by the mysql user?
    – Silvarion
    Nov 16, 2015 at 18:30
  • They exist, I'm not sure what the ownership / permissions should be on debian?
    – geoidesic
    Nov 16, 2015 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, 2015 at 18:40

1 Answer 1

Reset to default
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
  • 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, 2015 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.