QueueMetrics > General Asterisk configuration
Questions on My Setup ?
QueueMetrics:
--- Quote from: kayodea on February 28, 2008, 12:33:57 ---Question 5
Also, how will the settings below be affected considering that Queuemetrics is not installed on the same Server as Asterisk?
#callFile spool dir, set to blank for no call files at all.
callfile.dir=/var/spool/asterisk/outgoing
callfile.monitoring.enabled=true
callfile.monitoring.channel=Local/$EM@from-internal/n
callfile.monitoring.extension=11
callfile.monitoring.context=queuemetrics
....
--- End quote ---
Just change
callfile.dir=/var/spool/asterisk/outgoing
to
callfile.dir=tcp:user:pass@serverA
So that server B has to connect to server A via Manager API. Create a manager user on server A and of course the [queuemetrics] dialplan context on server A must be working :D
kayodea:
Thanks for that. The only part that is not too clear now is that of question 4, but I will decide on what method is best soonest.
I am getting this error from qloader.log;
Thu Feb 28 15:56:24 2008|Waiting 15s before reattempting to connect
|Thu Feb 28 15:56:39 2008|Now connecting to DB qm143 on 10.17.114.23 as user queuemetrics with password javadude
E|Thu Feb 28 15:57:07 2008|---ERROR FOUND--
E|Thu Feb 28 15:57:07 2008|Error type: dr
E|Thu Feb 28 15:57:07 2008| Statement:
E|Thu Feb 28 15:57:07 2008| Error: Host '10.17.114.22' is not allowed to connect to this MySQL server
E|Thu Feb 28 15:57:07 2008|Waiting 15s before reattempting to connect
|Thu Feb 28 15:57:22 2008|Now connecting to DB qm143 on 10.17.114.23 as user queuemetrics with password javadude
E|Thu Feb 28 15:57:50 2008|---ERROR FOUND--
E|Thu Feb 28 15:57:50 2008|Error type: dr
E|Thu Feb 28 15:57:50 2008| Statement:
E|Thu Feb 28 15:57:50 2008| Error: Host '10.17.114.22' is not allowed to connect to this MySQL server
E|Thu Feb 28 15:57:50 2008|Waiting 15s before reattempting to connect
|Thu Feb 28 15:58:05 2008|Now connecting to DB qm143 on 10.17.114.23 as user queuemetrics with password javadude
E|Thu Feb 28 15:58:33 2008|---ERROR FOUND--
E|Thu Feb 28 15:58:33 2008|Error type: dr
E|Thu Feb 28 15:58:33 2008| Statement:
E|Thu Feb 28 15:58:33 2008| Error: Host '10.17.114.22' is not allowed to connect to this MySQL server
E|Thu Feb 28 15:58:33 2008|Waiting 15s before reattempting to connect
|Thu Feb 28 15:58:48 2008|Now connecting to DB qm143 on 10.17.114.23 as user queuemetrics with password javadude
Note: Sever A is 10.17.114.22 and Server B is 10.17.114.23
I manually logged on to MySQL on Server A as follow #mysql -u queuemetrics -p with password javadude and am in.
What can be wrong?
Cheers.
Kayodea
QueueMetrics:
--- Quote from: kayodea on February 28, 2008, 17:43:04 ---Thu Feb 28 15:56:24 2008|Waiting 15s before reattempting to connect
|Thu Feb 28 15:56:39 2008|Now connecting to DB qm143 on 10.17.114.23 as user queuemetrics with password javadude
E|Thu Feb 28 15:57:07 2008|---ERROR FOUND--
E|Thu Feb 28 15:57:07 2008|Error type: dr
E|Thu Feb 28 15:57:07 2008| Statement:
E|Thu Feb 28 15:57:07 2008| Error: Host '10.17.114.22' is not allowed to connect to this MySQL server
E|Thu Feb 28 15:57:07 2008|Waiting 15s before reattempting to connect
|Thu Feb 28 15:57:22 2008|Now connecting to DB qm143 on 10.17.114.23 as user queuemetrics with password javadude
--- End quote ---
This means that the MySQL server on .23 does receive a connection request from .22 but refuses it. You could try something like:
GRANT ALL PRIVILEGES ON qm143.* to 'queuemetrics'@'10.17.114.22' IDENTIFIED BY 'javadude'
On the MYSQL server to tell it to accept connections.
kayodea:
Its OK now. Thanks.
Please what is the very best method (with your experience) of addressing question 4. Its the only stuff left for me.
Again, How can I make the "Setup Wizard - Load data from Asterisk" work? I keep gtting error since Asterisk and Queuemetrics are NOT on the same server (its pointing to /etc/asterisk/agent.conf on its machine (Server B) which is NOT there.
Cheers.
QueueMetrics:
About question #4, the easiest way is to create a NFS share, so that server B can see the files in server A as if they were on a local disk. If this proves to be too slow, then we'll think about the rsync.
See http://www.faqs.org/docs/Linux-HOWTO/NFS-HOWTO.html for NFS.
Abouty the setup wizard, I'd run a cron job to copy the full /etc/asterisk directory form server A to server B, so that server B think it's reading Asterisk config files :)
See this for Rsync http://troy.jdmz.net/rsync/index.html (it will be useful for question #4, as well!)
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version