Messages

1

General Asterisk configuration / Re: multiple Asterisk Servers

« on: April 21, 2012, 01:41:03 »

Looks pretty straight forward. Since we don't use the AMI to login that's one less item to configure right away. The users on the second server are unique and not duplicated on the first server. Where can I find the procedure to add a partition?

Thanks

2

General Asterisk configuration / multiple Asterisk Servers

« on: April 18, 2012, 22:16:44 »

I have a need for Queuemetrics to report stats from two seperate Asterisk servers. I have the multiple license but can't seem to find any definitive instructions on how to combine both servers data. Can I just load up qloadered on the second server and send the data to my queuemetrics server or is there more to it? Are there any instructions or tutorial avalable?

3

QueueMetrics installation / Re: Unanswered yet calls in unanswered detail

« on: August 18, 2011, 17:46:44 »

I got an initial response from Lorenzo but it did not cover my original request, so I emailed it a second time with no reply.

4

QueueMetrics installation / Re: Unanswered yet calls in unanswered detail

« on: August 17, 2011, 02:53:33 »

Looks like one of the other sysadmins was starting another instance of qloadered. Educated him and haven't had the problem since.

However still looking for a better system of support for my client. I have had a request for pricing in for a couple of weeks and I can't get a response to that either........

5

QueueMetrics installation / Re: Unanswered yet calls in unanswered detail

« on: August 05, 2011, 14:40:43 »

UPDATE:
system goes several days with good data and then back to the problem described. Is there a way to get/pay for support for this? Posting and waiting, while cost effective, is not efficient in getting things fixed

6

QueueMetrics installation / Re: Unanswered yet calls in unanswered detail

« on: July 27, 2011, 20:36:51 »

I repaired/reindexed the database and it was reporting correct for two days, now it's back and the previous fix won't correct it. How am i supposed to check for records in the queue_log file?

7

QueueMetrics installation / Unanswered yet calls in unanswered detail

« on: July 24, 2011, 22:58:24 »

Last Tuesday our call totals shot up inexplicatively and we started seeing abnormally high amounts of "Unanswered yet" in the "Detail of unanswered call" report in the disconnection column. These remain in the report even after the close of the day. I have not been able to duplicate it on demand yet to troubleshoot.

8

MySQL storage and Qloaderd/Uniloader / Re: database maintenance

« on: January 16, 2011, 23:22:30 »

so is this correct?

DELETE FROM queue_log WHERE time_id < "timestamp of oldest desired record"

and then rebuild the indexes

9

MySQL storage and Qloaderd/Uniloader / Re: database maintenance

« on: January 11, 2011, 23:19:17 »

We have hard drive constraints driving this need, so we need to trim the database.

10

MySQL storage and Qloaderd/Uniloader / Re: database maintenance

« on: January 10, 2011, 18:58:42 »

Can you recommend an adequate utility please. Also this would be good feature to add. Some sort of record archiving is standard in most ACD reporting packages.

Thanks
M Wood

11

MySQL storage and Qloaderd/Uniloader / database maintenance

« on: January 03, 2011, 20:25:17 »

Are there any tools included with queuemetrics to allow archiving of records? Our database is getting pretty big and we really need to offload old data in order to maintain enough room on the system for current data.

Thanks

12

General Asterisk configuration / Re: Changed Asterisk IP

« on: August 17, 2009, 16:59:51 »

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

13

General Asterisk configuration / Re: Changed Asterisk IP

« on: August 17, 2009, 15:44:12 »

172.16.1.132 is the Queuemetrics Server and 172.16.7.3 is the Asterisk server

14

General Asterisk configuration / Changed Asterisk IP

« on: August 17, 2009, 03:14:13 »

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

15

QueueMetrics installation / Re: install problems

« on: March 20, 2008, 01:34:42 »

Looking at Luke Jacksons setup I see that there are two different qloader.pl files a 1.10 and a 1.6. My install has a 1.10 where is the more recent one?