APAR status
Closed as documentation error.
Error description
========= APAR Template ========================== >> Abstract: For any new user 'xyz' other than root, we require bare minimum SELECT, PROCESS and EVENT privileges for it to successfully collect data from MySQL database server. >> Environment: All supported windows and UNIX/Linux versions of agent and servers. >> Problem Description: >> Impact: MySQL V6 agent doesn't connect to MySQL server and data is not seen on UI, logs will show Access Denied error for the new mysql user. Workaround: 1. Execute below queries on MySQL database server. "GRANT SELECT,PROCESS,EVENT ON *.* TO 'xyz'@'hostname/IP' WITH GRANT OPTION;" Where hostname/IP is the host name or IP address of the machine which runs the monitoring agent. % can be used for allowing all hosts. "FLUSH privileges;" 2. Restart the agent and verify data on UI Local Fix: N/A Related Files and Output: None ************************ End of APAR Template *********************
Local fix
N/A
Problem summary
For any new user 'xyz' other than root, we require bare minimum SELECT, PROCESS and EVENT privileges for it to successfully collect data from MySQL database server. MySQL V6 agent doesn't connect to MySQL server and data is not seen on UI, logs will show Access Denied error for the new mysql user. Documentation regarding the same is missing.
Problem conclusion
We have updated the documentation for: Installation and Configuration Guide and Monitoring Agent for MySQL Troubleshooting Guide. Please refer link below: https://www.ibm.com/docs/en/cam-r?topic=guide-mysql-agent
Temporary fix
Comments
APAR Information
APAR number
IJ40480
Reported component name
MYSQL DATABASE
Reported component ID
5725G70SQ
Reported release
721
Status
CLOSED DOC
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-06-07
Closed date
2022-07-15
Last modified date
2022-09-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTFXA","label":"IBM Monitoring"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"721","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
08 September 2022