Changed Asterisk IP

[mwood]

Running Asterisk and Queuemetrics on two servers. Had to change the Asterisk server's IP address and now Queuemetrics will not display any transactions. Checked for errors  in the log and found this:

Sun Aug 16 12:26:54 2009|Now connecting to DB queuemetrics on
|172.16.1.132 as user qloader with password javadude
E|Sun Aug 16 12:26:54 2009|---ERROR FOUND-- Sun Aug 16 12:26:54
E|2009|Error type: dr Sun Aug 16 12:26:54 2009| Statement:
E|Sun Aug 16 12:26:54 2009|     Error: Host '172.16.7.3' is not allowed to connect to this MySQL server

So now I see it is a permission/priviledge issue so I found this:

Please make sure that the MySQL server will allow connecting from the Asterisk server – this can usually be obtained by running on the database server an SQL statement like:

grant all privileges on queuemetrics.* to 'queuemetrics'@'IP of Asterisk Server' identified by 'javadude';

So is this correct, and if so where do I execute this command? The CLI of the queuemetrics server? Can I just login as root and do this?

Any help would be much appreciated.

M Wood

[QueueMetrics]

I have a feeling that the IP should be "172.16.1.132" and NOT "|172.16.1.132" - there is a pipe symbol too many there!

[mwood]

172.16.1.132 is the Queuemetrics Server and 172.16.7.3 is the Asterisk server

[mwood]

OK ran this:

grant all privileges on queuemetrics.* to 'queuemetrics'@'172.16.7.3'  identified by 'javadude';

And new error is:

Mon Aug 17 07:48:42 2009|Now connecting to DB queuemetrics on 172.16.1.132 as user qloader with password javadude
E|Mon Aug 17 07:48:42 2009|---ERROR FOUND-- Mon Aug 17 07:48:42
E|2009|Error type: dr Mon Aug 17 07:48:42 2009| Statement:
E|Mon Aug 17 07:48:42 2009|     Error: Access denied for user 'qloader'@'172.16.7.3' (using password: YES)
E|Mon Aug 17 07:48:42 2009|Waiting 15s before reattempting to connect
 |Mon Aug 17 07:48:57 2009|Now connecting to DB queuemetrics on 172.16.1.132 as user qloader with password javadude
E|Mon Aug 17 07:48:57 2009|---ERROR FOUND-- Mon Aug 17 07:48:57
E|2009|Error type: dr Mon Aug 17 07:48:57 2009| Statement:
E|Mon Aug 17 07:48:57 2009|     Error: Access denied for user 'qloader'@'172.16.7.3' (using password: YES)
E|Mon Aug 17 07:48:57 2009|Waiting 15s before reattempting to connect.


Thanks

[QueueMetrics]

Lorenzo told me this issue should be fixed, do you confirm?