dumb question about enabling error logs

hello -

i thought i understood that error logs are ALWAYS enabled. so i added the following two lines to my.cnf and restarted:

plugin_load_add = server_audit

but "/var/log/mariadb.err.log" is not being created. how do i enable mariadb to start writing audits to a logfile?

| Variable_name | Value                    |
| log_error     | /var/log/mariadb.err.log |

 SHOW VARIABLES LIKE 'log_output';
| Variable_name | Value |
| log_output    | FILE  |

MariaDB [(none)]> SHOW VARIABLES LIKE 'general_log%';
| Variable_name    | Value           |
| general_log      | OFF             |
| general_log_file | mydomainname.log |

Server version: 10.2.24-MariaDB MariaDB Server
Linux mydonmain.info 3.10.0-957.12.2.el7.x86_64 #1 SMP Tue May 14 21:24:32 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux

Answer Answered by Ian Gilfillan in this comment.

Errors are always written, but not always to log file. If log_error is not enabled, errors will be logged to stderr. See Error Log. Note also that the error log, the General Query Log and the Audit Plugin are all different things.

As to why the error log is not being written, check file permissions (though the server shouldn't start if it can't write the log file), or specify log_error with no location in order to write to the default location to test. Also, to help track down errors, I suggest doing one thing at a time - first get error logs working, then implement the audit plugin if you need it.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.