Please be sure you’ve read the docs and API specs before asking for help. Also, please be sure you’ve searched the forum for your answer before you create a new topic.
Please consider addressing the following when creating your topic:
Onboarded JDBC source, connection is successful and account aggregation working fine. However Entitlement aggregation is failing with access denied. please refer the below image
I don’t see any permission errors in the database and also VA is able to connect database. Do we need to configure any additional settings for JDBC entitlement aggregation
This error indicates that the JDBC connector is unable to authenticate with the target database. The key message is “Access denied for user ‘root’ (using password: YES)”, which usually means the username/password is incorrect or the database user doesn’t have permission to connect from the Virtual Appliance host.
You can verify the credentials locally using:
mysql -h <DB_HOST> -P <PORT> -u root -p
If the login fails locally with the same error, verify the credentials, user privileges, and host access before retrying the aggregation.
It would also be helpful if you could share your JDBC source configuration (mask any sensitive information such as passwords and connection details). That will make it easier to identify whether the issue is related to the connector configuration or the database permissions.
is entitlement and user data separately stored in datatables ? if yes then check permission over both the tables also check both tables on same server or different servers. It looks like permission issue only.
I would recommend trying it once by removing the username and password from the group query settings. Just enter the database URL and test it. If it still doesn’t work, then it is most likely a permissions issue.
Please be sure you’ve read the docs and API specs before asking for help. Also, please be sure you’ve searched the forum for your answer before you create a new topic.
