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 Synthetic Monitoring - Resolved Incident on Detector Alerts

We’ve discovered a bug that affected the auto-clear of Synthetic Detectors in the Splunk Synthetic Monitoring ...

Video | Tom’s Smartness Journey Continues

Remember Splunk Community member Tom Kopchak? If you caught the first episode of our Smartness interview ...

3-2-1 Go! How Fast Can You Debug Microservices with Observability Cloud?

3-2-1 Go! How Fast Can You Debug Microservices with Observability Cloud? Learn how unique features like ...