cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Christine.Chang
AppDynamics Team (Retired)

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
Comments
Dave.Schmid
AppDynamics Team
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
Version history
Last update:
‎02-04-2019 01:56 PM
Updated by: