Knowledge Base

cancel
Showing results for 
Search instead for 
Did you mean: 

Database Agent: Viewing MySQL Error Logs

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
Version history
Revision #:
6 of 6
Last update:
‎02-04-2019 01:56 PM
Updated by:
 
Labels (1)
Tags (1)
0 Kudos
Comments
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