Database Agent: Viewing MySQL Error Logs

[Christine.Chang]

To see the error log file of a MySQL server monitored by database agent (under Databases -> Object Browser -> Error Log) , the following conditions must be met:

• secure_file_priv is either empty or the name of folder containing the error log file. You must restart MySQL for changes in the secure_file_priv variable to take effect.
• The error log file is readable to all users
• max_allowed_packet is larger than the error log file size
• The user has FILE privileges

[Dave.Schmid]

Based on this information, I found that I needed to add these items to make these updates in the my.cnf file:

Both settings referenced in the documentation (4.3+) but finding a specific place to set it required a little more digging:

/etc/my.cnf.d/mariadb-server.cnf

[mysqld]

secure_file_priv=''

max_allowed_packet=1073741824