Questions on My Setup ?

[kayodea]

Hi,

I have installed Asterisk and Queuemetrics as follows;

Server A is running Asterisk with qloaderd installed and sending records from queue_log to Server B's (Queuemetrics Server) MySQL Database. Sever A is also running FreePBX for configuring Asterisk Config files.

Server B is running Queuemetrics and MySQL database. Server B will also be running Smooth Torque predictive dialer as well (sending calls to Server A and placing connected calls on a queue). There is also Sever C with combination of Server A & B as a failover Server.

All three servers above are Dell PowerEdge 2950 with 16GB of RAM with FC8 installed.

Question 1

What backup method should be used for server A and B? (I have mindi and mondo in mind to use to do a complete disk backup of every server)

Question 2

I am running Asterisk version 1.4.18 and I have Sangoma T1/E1 Quad card with HW Echo cancellation on Server A. With your experience, how many Agents do you think this can hold confortably wth the above Server Config?

Question 3

I will be giving all my Agents a password along with their Agent code. How can I ensure that they access the agents page with the restrictions of Queuemetrics not allowing the agents password (So I read, I may be wrong) in the agent.conf file if the agent's page is to work?

Question 4

The recorded files will be stored in /var/spool/asterisk/monitor on Server A. Is there a way I can get the recorded files to Server B just like records in queue_log? If not, is it automatic that the recorded files will be located (when needed) on Server A when reports are queried on Server B or what will now be the value of default.monitored_calls= ?

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

callfile.outmonitoring.enabled=true
callfile.outmonitoring.channel=Local/$EM@from-internal/n
callfile.outmonitoring.extension=14
callfile.outmonitoring.context=queuemetrics

callfile.agentdial.enabled=true
callfile.agentdial.channel=Local/13@queuemetrics/n
callfile.agentdial.extension=10
callfile.agentdial.context=queuemetrics

callfile.calloutcome.enabled=true
callfile.calloutcome.channel=Local/12@queuemetrics/n
callfile.calloutcome.extension=10
callfile.calloutcome.context=queuemetrics

callfile.agentlogin.enabled=true
callfile.agentlogin.channel=Local/20@queuemetrics/n
callfile.agentlogin.extension=10
callfile.agentlogin.context=queuemetrics

callfile.agentlogoff.enabled=true
callfile.agentlogoff.channel=Local/21@queuemetrics/n
callfile.agentlogoff.extension=10
callfile.agentlogoff.context=queuemetrics

callfile.agentpause.enabled=true
callfile.agentpause.channel=Local/22@queuemetrics/n
callfile.agentpause.extension=10
callfile.agentpause.context=queuemetrics

callfile.agentunpause.enabled=true
callfile.agentunpause.channel=Local/23@queuemetrics/n
callfile.agentunpause.extension=10
callfile.agentunpause.context=queuemetrics

Cheers to All as I wait for your replies.

Kayode.

[QueueMetrics]

Question 1

What backup method should be used for server A and B? (I have mindi and mondo in mind to use to do a complete disk backup of every server)

You choose, I suggest something you're confortable with and that is very speedy in restore phase.

[QueueMetrics]

Question 2

I am running Asterisk version 1.4.18 and I have Sangoma T1/E1 Quad card with HW Echo cancellation on Server A. With your experience, how many Agents do you think this can hold confortably wth the above Server Config?

It really depends on the setup: how much transcoding you're doing and how complex your dialplan is. I'd say that 50 to 100 should be a reasonable view, and up to twice if you use a very "lightweight" config with no recordings and no transcoding.

Generally speaking, FreePBX builds a diaplan that is very feature-rich, but quite complex as well.

[QueueMetrics]

Question 3

I will be giving all my Agents a password along with their Agent code. How can I ensure that they access the agents page with the restrictions of Queuemetrics not allowing the agents password (So I read, I may be wrong) in the agent.conf file if the agent's page is to work?

The passwords used for QM and for the Asterisk agents are different things, so you can create them so they are the same, or different, as you please.

[QueueMetrics]

Question 4

The recorded files will be stored in /var/spool/asterisk/monitor on Server A. Is there a way I can get the recorded files to Server B just like records in queue_log? If not, is it automatic that the recorded files will be located (when needed) on Server A when reports are queried on Server B or what will now be the value of default.monitored_calls= ?

No, but you could do one of these two things:
1. share /var/spool/asterisk/monitor from server A to server B, or
2. run a rsync job that copies files over every 10 minutes. rsync is pretty good at copying only differences, so even on huge directories, it's not as bad as it sounds
3. (more complex) use a custom XML-RPC script to help QM retrieve files from server A via HTTP.

[QueueMetrics]

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

....

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 

[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]

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

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!)

[kayodea]

I successfully have question 4 resolved by sharing the folders in Server A. Thanks.

Now, what is the procedure of changing the logo at the home page? I uploaded my logo to /opt and specify the path in layout.logo in configuration.propertes, but still the logo did not change. Again, MUST the logo be in a specific format and size. My logo is a .gif and its size is 160 x 106.

Cheers.

[QueueMetrics]

You should have the logo on a web server somewhere, better on your LAN, so you can change WEB-INF/configuration.properties:


#Your company logo (full or relative path) - shall be resized to be an image 200 x 72
layout.logo=http://myserver/mylogo.gif

#HTML string displayed on the login page.
layout.splash=HELLO USERS


The logo must be 200x72, or it will be resized to be 200x72. Use a transparent image if possible.

You can also change the splash page text, i.e. the text that is seen below the logon page.

[kayodea]

OK. Thanks for that.

I have several Queues and need to make supervisors of each queues monitor only queues they supervised. How can this be achieved with out viewing other queues that they are not supervisors for.

I believe there should be a method of assigning the supervisor(s) to a particular queue.

Cheers.
 

[QueueMetrics]

Yo do that by setting security keys: you protect each queue with a security key and grant that key only to allowed supervisors.

[kayodea]

Thanks for that. Its cool.

We have a database of customers with Names and Numbers. How can we pass the name of a customer to an Agent via its CallerID(num) which is already in a MySQL Database. Any code snippet will be appreciated.

Cheers.