Splunk AppDynamics

DB Agent Issue

lucky_bakshi
New Member

Installed DB Agent and it started successfully from linux. Installed Java Agent and it is working perfectly fine.

However, getting issue  when I see the status of the collector in the controller "Access denied for user 'root'@'localhost' (using password: YES)"

 

I am using linux system and database MYSQL is in the folder of EC2 instance /var/mysql

Any information will help

Regards,

Lucky

 
Labels (1)
0 Karma

iamryan
Community Manager
Community Manager

Hi @lucky.bakshi,

Those notification messages in the database.log mean that a MySQL client is failing to login with the DB root password.

This can happen if for example the Enterprise Console has the wrong DB root password and keeps trying to login to do its health check every minute.

0 Karma

lucky_bakshi
New Member

Thanks Ryan for help,

The DB password in the collector is correct.

I tried done something in database to correct this error however it did not work 

/var/lib/mysql

update mysql.user update set plugin='auth_socket'

where user ='root'

Now, it is not allowing me to connect to database  and in the AppDynamics controller getting error "Plugin auth_socket is not loaded'. In both places getting same error.

Regards,

Lucky

 
 
 
 
 
 
0 Karma

iamryan
Community Manager
Community Manager

Hi @lucky.bakshi,

Thanks for getting back to me. I don't have any further next steps right now. If I find anything, I'll share it here. 

If you find a solution or have any further comments, be sure to leave them as a reply to your post here too.

0 Karma
Get Updates on the Splunk Community!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...