Infrastructure (Server, Network, Database)

cancel
Showing results for 
Search instead for 
Did you mean: 

My Sql DB Collector Setup help on SaaS

Highlighted
Creator

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!

My Sql DB Collector Setup help on SaaS
3 REPLIES 3
Highlighted
Creator

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

Highlighted
AppDynamics Team

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

 



Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.
Highlighted
Creator

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!