Symptoms of objects in the sys schema not being selected in AWS RDS MySQL
Description
How to test
RDS , PMM version and Registration Process
AWS RDS MySQL and PMM version
-> AWS RDS MySQL : 8.0.32
-> PMM : 2.40.1
How you are adding RDS instance to PMM monitoring.
Create an IAM account that can access RDS
Enable enhanced monitoring
Create DB user for pmm
CREATE USER 'pmm'@'%' IDENTIFIED BY password;
GRANT SELECT, PROCESS, REPLICATION CLIENT ON . TO 'pmm'@'%';
ALTER USER 'pmm'@'%' WITH MAX_USER_CONNECTIONS 10;
GRANT SELECT, UPDATE, DELETE, DROP ON performance_schema.* TO 'pmm'@'%'
Add an RDS instance
Enter the RDS access key and RDS secret key
When I enter, a list of RDSs that can be accessed by the iam user is checked and selected.Create a data source
How to document
Attachments
Activity
wanskim September 2, 2024 at 4:04 AM
Thank you for your support.
We created a separate mysql user for pmm as pmm@'%' and granted it permission.
As a result of testing, we confirmed that the sys. table was normally queried
when the permission was granted as shown below. (Execute permission missing)
GRANT SELECT, PROCESS, REPLICATION CLIENT ON . TO pmm@%
GRANT SELECT, EXECUTE ON sys.* TO pmm@%
GRANT SELECT, UPDATE, DELETE, DROP ON performance_schema.* TO pmm@%
Thank you.
Aaditya Dubey August 30, 2024 at 11:32 AMEdited
Hi
I’m able to reproduce the issue and found out that the user you are using lacks the privileges, so to access the sys, we need the privileges mentioned here.
I tested with Admin user and it works perfectly fine. Please check the attached screenshots.
Here are the admin privileges for your reference:
Aaditya Dubey August 30, 2024 at 9:46 AM
Hi
Thank you for the report.
Could you please explain how to create a data source?
Attaching an image, please let me know the steps you performed for data source creation.
Symptom: When connecting to the DB through the data source in AWS RDS MySQL with pmm, an error occurs when searching for the sys. schema object.