Splunk AppDynamics

My Sql DB Collector Setup help on SaaS

CommunityUser
Splunk Employee
Splunk Employee

Hello,

I am trying to get the db monitoring to work on a SaaS account with MySql and trying to figure out what some of the input fields on the db collector setup are really looking for.

I have a single VM node where I am running the dbagent (and db collector) and it seems to register with the controller on my SaaS account just fine but the dbcollector shows an error. I suspect I don't have the right information in the db collector config.

Specifically, what needs to go in host and port fields? 

Please see attached pictures. Please let me know if there is any recommendation.

Thanks!

Labels (1)
0 Karma
1 Solution

CommunityUser
Splunk Employee
Splunk Employee

Many thanks akumar!

I had to go back and add my hostname into /etc/hosts file  and then go back and re-add dbcollector and that did the trick!

Thanks again!

View solution in original post

CommunityUser
Splunk Employee
Splunk Employee

I also have attached one more image showing the agent status on controller.

0 Karma

Arun_Dasetty
Super Champion

Hi,

You would need to make sure the DNS/IP (10.0.0.3) is mapped to mysql db server host name for value provided in collector edit view in UI, one way to check is the error in UI for host name not allowed is mapped to ip above if not add and remove any firewall/blocking rule and check (telnet dbhost dbport) (telnet 10.0.0.3 3306) works from db agent java process instance, refer doc for other permissions below:

https://docs.appdynamics.com/display/PRO43/Configure+MySQL+Collectors

CommunityUser
Splunk Employee
Splunk Employee

Many thanks akumar!

I had to go back and add my hostname into /etc/hosts file  and then go back and re-add dbcollector and that did the trick!

Thanks again!

Get Updates on the Splunk Community!

Splunk Observability Cloud's AI Assistant in Action Series: Auditing Compliance and ...

This is the third post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...