I have install the MySql Plugin with npi and it runs fine. But it does not appear in my dashboard.
So I checked daemon.log and find the following error “The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[2015-01-14 16:50:09,922] ERROR com.newrelic.plugins.mysql.MySQL - Unable to obtain a new database connection: jdbc:mysql://localhost/ USER_NAME_HERE/PASSWORD_FILTERED, check your MySQL configuration settings. Communications link failure”
Our server is running at AWS and MySql as an instance on another server (Amazon RDS).
But for some reason it is trying to access MySql as localhost, but my plugin.json file was not configured to use localhost. Here is a copy of my configuration with our password removed.
{
"agents": [
{
"name" : "zovue",
"host" : "zovuerds.caqjmwxjzefz.eu-west-1.rds.amazonaws.com",
"metrics" : "status,newrelic",
"user" : "root",
"passwd" : "[Password was removed for POST]"
}
]
}
So, why is it still trying the use localhost to access MySql and is there any config file I need to configure?
Extra Information
Server: Ubuntu (64 bit)
Java: 1.7.0_65 (64bit)
MySql 5.6.19
Thanks in advance