Home » Forums » trixbox forums » trixbox projects

How About An Integrated Queue Statistics Applet?

rquick
Posts: 92
 Member Since:
2006-06-07
Submitted by rquick on Tue, 03/13/2007 - 12:12pm.

I have seen several queue statistics applets available for asterisk, and they all look great. I was wondering if we could get one tied in to trixbox for future releases, so that it's not such an invasive install.

Thanks Andrew!

Randy

‹ choppy sound when checking voice mail Call Back script ›
--

Randy Quick
rquick@thcs.org



andrew
Posts: 672
 Member Since:
2006-05-30
Re: How About An Integrated Queue Statistics Applet?
Tue, 06/27/2006 - 8:35pm

Are any of them opensource? can you post links?



rquick
Posts: 92
 Member Since:
2006-06-07
Re: How About An Integrated Queue Statistics Applet?
Wed, 06/28/2006 - 6:22am

Thanks for the quick response!

This one is free, but not open.
http://www.asteriskguru.com/tools/queue_stats.php

Does anyone else know of any good open source call center monitoring software?

I'll spend some time searching the web this afternoon and try to get some other canidates.

--

Randy Quick
rquick@thcs.org



joepc
Posts: 100
 Member Since:
2006-06-02
Re: How About An Integrated Queue Statistics Applet?
Fri, 06/30/2006 - 8:40am

Im using Asterisk Guru Queuestats, It would make a great addition to trixbox,

Here is a full install guide + files + video explaining how to install.

Queuestats Install Video

I hope it speeds up the process a bit.

Also if anyone can provide hosting it would be appreciated.

Thanks,
Joe



joepc
Posts: 100
 Member Since:
2006-06-02
Re: How About An Integrated Queue Statistics Applet?
Tue, 07/04/2006 - 1:11am

Link to video is working now.



hendrikdw
Posts: 21
 Member Since:
2006-06-22
Re: How About An Integrated Queue Statistics Applet?
Wed, 07/05/2006 - 6:16am

Hi Guys

Maybe someone can help me...

I can't get Queue Statistics to work. I am getting the following error:

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: user "pqadmin" does not exist in /var/www/html/queuestats/include/config.inc.php on line 31

Warning: pg_query(): No PostgreSQL link opened yet in /var/www/html/queuestats/public/menu_home.php on line 31

Warning: pg_fetch_assoc(): supplied argument is not a valid PostgreSQL result resource in /var/www/html/queuestats/public/menu_home.php on line 32
The database is empty!



joepc
Posts: 100
 Member Since:
2006-06-02
Re: How About An Integrated Queue Statistics Applet?
Wed, 07/05/2006 - 7:55am

Do the following:

nano /var/www/html/queuestats/include/config.inc.php

Make sure your connection settings are correct.

Username = pgadmin
password = whatever you made it as
Database = queuestats

I have removed the download link, would appreciate it if someone could host it, I just don’t have the bandwidth.

Thanks,
Joe



hendrikdw
Posts: 21
 Member Since:
2006-06-22
Re: How About An Integrated Queue Statistics Applet?
Wed, 07/05/2006 - 9:03am

Thanks for the help... :-)

But now Trixbox don't write my data to the database...

I am getting the following error:

The database is empty!



joepc
Posts: 100
 Member Since:
2006-06-02
Re: How About An Integrated Queue Statistics Applet?
Wed, 07/05/2006 - 9:29am

Look at the end of the video, it explains this.

You need to populate the database for it too display the GUI.

Good luck.



mat134
Posts: 1
 Member Since:
2006-11-07
Re: How About An Integrated Queue Statistics Applet?
Tue, 11/07/2006 - 8:31am

hello .. this link is broken :(



joepc
Posts: 100
 Member Since:
2006-06-02
Re: How About An Integrated Queue Statistics Applet?
Tue, 11/07/2006 - 9:41am

Its added to asteriskprojects.com

let me know if you need any help.



dghundt
Posts: 332
 Member Since:
2006-08-13
Re: How About An Integrated Queue Statistics Applet?
Sat, 12/23/2006 - 9:20pm

I have just installed queuestatistics along with the other requisite applications using the most recent versions.
This is done with a fresh AAH 2.7 install.
I have edited both config.inc.php files

In the include directory:

Code:
// comment the OS that you are not going to use
// available values are linux or windows
$os = "linux";
#$os = "windows";

// The settings of the images_path for the OS you are not going to use does not matter.
// For Linux default image path is /tmp. You can change it but have to make sure that the webserver can write into it.
$image_path_lin = "/tmp";

// For windows you can also make a dir where the images to be stored but again you have to provide write access for the$
$image_path_win = "./pdf_images/";

// Set the default language (EN)
$default_language = "en";

// Set default timezone
// Valid timezone is one of the following GMT values
// -12, -11, -10, -9.5, -9, -8.5, -8, -7, -6, -5, -4, -3.5, -3, -2, -1,
// 0, +1, +2, +3, +3.5, +4, +4.5, +5, +5.5, +6, +6.5, +7, +8, +9, +9.5, +10, +10.5, +11, +11.5, +12, +13, +14
$default_timezone = "-5";

// Valid start/end hour value is one of the following
// 00, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24
// Set default start hour
$default_start_hour = "06";

// Set default end hour
$default_end_hour = "22";

$db_host = "127.0.0.1";
$db_name = "queuestats";
$db_user = "queuestats";
$db_pass = "mypassword";

$conn_string = "host=$db_host dbname=$db_name user=$db_user password=$db_pass";
$db_connect = pg_connect($conn_string);

In the log directory:

Code:
<?
// The queue_log and/or cdr file(s) must be here
$queue_log_dir = '/var/log/asterisk/';
$cdr_log_dir = '/var/log/asterisk/cdr-csv/';

$db_host = "127.0.0.1";
$db_name = "queuestats";
$db_user = "queuestats";
$db_pass = "mypassword";

$conn_string = "host=$db_host dbname=$db_name user=$db_user password=$db_pass";
$db_connect = pg_connect($conn_string);
?>

After I make a few calls to the queue, I run logque.php from my browser, and get a message that the log file is ok and new information was put in my database.
I run questatistics in my browser and it says the database is empty. It does pick up the name of one of my queues.

Code:
There is no incoming queue data for the selected period and callgroup 2006-12-21 08:00:00/2006-12-23 23:00:00, All Queues

Thank you for your help!



dghundt
Posts: 332
 Member Since:
2006-08-13
Re: How About An Integrated Queue Statistics Applet?
Sat, 12/23/2006 - 10:00pm

Ahh.... It works just fine....just make sure to answer a call!
It seems that if you have just unanswered calls in your queue stats, it chokes a bit, saying database empty. Just make sure to answer a call from the queue before you look at your stats. Then answered and unanswered calls show up.

A few tips as some things have changed since the video tutorial for trixbox was put out. Here's a few things I had to sort out to get things running.

postgresql allowed hosts:
by default, it requires authentication, change it to not require auth.
otherwise, your get a IDENT authentication error when you run the sql script for the database table creation.

in var/www/html/queustats/include/config.inc.php
uncomment linux os, comment windows

in var/www/html/queustats/log/config.inc.php
the default source paths for the files is reversed, at least for default install of AAH2.7. so if you get a 'can't find queue_log file' error, you can check your default paths here.

both configs
make sure to populate all four db variables. if you follow the video, only your password will be specific to you.

The config files above reflect the changes i mention.

cheers



wahyu
Posts: 75
 Member Since:
2006-07-14
Re: How About An Integrated Queue Statistics Applet?
Wed, 03/07/2007 - 9:54am

Hi All,

Anyone know where is to download the video tutorial? The tutorial in asteriskproject.com wasn't there.

Regards,

Wahyu



dghundt
Posts: 332
 Member Since:
2006-08-13
Re: How About An Integrated Queue Statistics Applet?
Wed, 03/07/2007 - 10:16am

http://etech-training.co.uk/zen/index.php?main_page=product_info&...



wahyu
Posts: 75
 Member Since:
2006-07-14
Re: How About An Integrated Queue Statistics Applet?
Sat, 03/10/2007 - 8:54am

Hi all,

I've just follow the instruction in video tutorial, and i got problem when create table is postgresql server, and always shown this comment :

Output from SQL commands in file /var/www/html/queuestats/db/db.sql ..

psql: FATAL: IDENT authentication failed for user "postgres"

i ve follow DGHUNDT above, but i the problem still remain.

Anyone can help ?

Regards,

Wahyu



dghundt
Posts: 332
 Member Since:
2006-08-13
Re: How About An Integrated Queue Statistics Applet?
Sat, 03/10/2007 - 3:27pm

It should be fine if you go into postgres via webmin to change your default permissions. You need to set it not to request this authentication. Your error is just a permissions issue.

go to webmin
servers
postgres
allowed hosts
make sure local connection and 127.0.0.1 say all databases, all users, No authentication required.

I have local connection on top; not sure if this matters. Took me a day to figure this out. :lol:



wahyu
Posts: 75
 Member Since:
2006-07-14
Re: How About An Integrated Queue Statistics Applet?
Sun, 03/11/2007 - 9:44am

Hi dghundt,

Thank you for the guidance. Now the problem is solve.
But I have another problem, in I got no data "the data is empty" even i've tried to make a call several time, but the data is empty.

Am I missing something?

Regards,

Wahyu



wahyu
Posts: 75
 Member Since:
2006-07-14
Re: How About An Integrated Queue Statistics Applet?
Sun, 03/11/2007 - 11:12am

This is what i saw in the queuestats

Am i do it wrong ?

I tried to make some outgoing call and incoming call to the queue, but the database is empty as seen like in picture.

But i saw in /queuestats/log I saw the data is coming in and i can see the database was add by new data.

Regards,

Wahyu



wahyu
Posts: 75
 Member Since:
2006-07-14
Re: How About An Integrated Queue Statistics Applet?
Sun, 03/11/2007 - 11:13am

This is what i saw in the queuestats

Am i do it wrong I tried to make some outgoing call and incoming call to the queue, but the database is empty as seen like in picture. But i saw in /queuestats/log I saw the data is coming in and i can see the database was add by new data

Regards

Wahyu



dghundt
Posts: 332
 Member Since:
2006-08-13
Re: How About An Integrated Queue Statistics Applet?
Sun, 03/11/2007 - 4:06pm

Make sure you actually pick up the phone and answer some calls. Just letting them ring caused this error for me too.

Are you running the php script that reads the cdr first (see tutorial)? You have to do this before you go to the queuestats viewer.



wahyu
Posts: 75
 Member Since:
2006-07-14
Re: How About An Integrated Queue Statistics Applet?
Sun, 03/11/2007 - 10:11pm

I think i follow the all of instruction on video tutorial.
Where can i get the php script that reads the cdr??

Regards,

Wahyu



dghundt
Posts: 332
 Member Since:
2006-08-13
Re: How About An Integrated Queue Statistics Applet?
Mon, 03/12/2007 - 4:49pm

My computer where I usually run the script died today, so I'm guessing. You can set it to run as a cron per the video which is what I did. I'll update this later if it is wrong...
I think it is:
pbxipaddress/queuestats/logqueue.php

where pbxipaddress is your asterisk ip addres, for example
192.168.1.103/queuestats/logqueue.php
you should see a web page come up showing that is it processing your call logs.

then you run
pbxipaddress/queuestats
to see your stats

you're almost there!



wahyu
Posts: 75
 Member Since:
2006-07-14
Re: How About An Integrated Queue Statistics Applet?
Tue, 03/13/2007 - 12:56am

I can access the pbxipaddress/queuestats/logque.php and i can see the log of calls.

BUT if i access pbxipaddress/queuestats

database is empty!

Even i have make calls and receive some calls.

Anything i did wrong ?

Regards,



dghundt
Posts: 332
 Member Since:
2006-08-13
Re: How About An Integrated Queue Statistics Applet?
Tue, 03/13/2007 - 12:12pm

if the loqueue.php script processes calls then you should be set.
Did you make sure in the upper right hand corner that you selected the correct date, time, and queue to review?

Or, check out this post.
http://www.asteriskguru.com/board/database-is-empty-vt706.html?hi...

You will need to review the database settings file.
Look at my example config I posted on this thread.



wahyu
Posts: 75
 Member Since:
2006-07-14
Hi dghundt, Thank you for
Sun, 03/18/2007 - 8:32am

Hi dghundt,

Thank you for the guidance so far.

I have checked everything, it seems i didn't see anythings wrong.
I only see that all tutorial and the post http://www.asteriskguru.com/board/database-is-empty-vt706.html?hi...
are using queuestats ver.0.10.
I am using the latest 0.20, is it caused the problem ?

the only problem is "database is empty" in /pbxipaddress/queuestats/
i guess, I have tried to select the correct data.

If I looked at the link when i fill the address with this adress /mypbxidaddress/queuestats/
It seems the address will automatically change to : http://192.168.0.113/queuestats/public/error.php?warning=The%20database%20is%20empty!&type=incoming.

It seems its directed to error pages.

Anything i did wrong ?

Regards,

Wahyu



husaints
Posts: 43
 Member Since:
2007-02-25
errors
Mon, 03/19/2007 - 11:07pm

Hi,

I have queuestats installed succesfully. I can get the reports of the incoming calls on the queue etc. But I get these 2 errors.

1- for outgoing calls the database remains empty. I know you must load the cdr with this -
http://ipaddress/queuestats/log/cdr.php
But when I run the cdr.php file i get the following error:
"No files like *.csv found in /var/log/asterisk/cdr-csv/. Check the content of the specified log directory!"

I have checked the directory and I have the following files in the directory:
[root@asterisk1 cdr-csv]# ls -la
total 588
drwxrwx--- 2 asterisk asterisk 4096 Mar 1 04:02 .
drwxrwx--- 4 asterisk asterisk 4096 Mar 20 04:02 ..
-rw-rw---- 1 asterisk asterisk 176117 Mar 20 10:11 Master.csv
-rw-rw---- 1 asterisk asterisk 206304 Feb 28 21:55 Master.csv.1
-rw-rw---- 1 asterisk asterisk 194342 Feb 1 00:33 Master.csv.2
[root@asterisk1 cdr-csv]#

I dont know why it cannot find the file then.

In the config.inc.php file the settings are as follows:
$queue_log_dir = '/var/log/asterisk/';
$cdr_log_dir = '/var/log/asterisk/cdr-csv/'

http://ipaddress/queuestats/log/logque.php works just fine.

2- Secondly in the "incoming stat by agents" tab, I get the following error right at the bottom:
Warning: Invalid argument supplied for foreach() in /var/www/html/queuestats/public/incoming_agents.php on line 406
Agent Transferred to Num of transfers Avg Calltime

I dont know if anyone has come accross these 2 errors, but I have 3 trixboxes running queuestats 0.2.0 and all of them have the same issue.

Any help on this will be highly appreciated.

thanks,
husaints.



TheShniz
Posts: 213
 Member Since:
2006-06-01
Anyone have a copy of that
Wed, 07/11/2007 - 1:16pm

Anyone have a copy of that video? The page seems to be broken...

I'd appreciate it,
- J

::updated::

I must say that I'm having some difficulty w/ Postgres... I've got it installed w/ the database created & populated, and I can confirm both with Webmin and phpPgAdmin. However, whenever I loadup queuestats, it spits out...

Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?

...along w/ a bunch more warnings on various lines of query.php. I've set both config.inc.php's with the proper username, etc information. It must be a problem with php-php-pgsql, Apache, or PHP itself... cuz when I do "psql -U queuestats queuestats" that worx as well.



TheShniz
Posts: 213
 Member Since:
2006-06-01
Nobody? - J
Mon, 07/16/2007 - 11:43am

Nobody? - J



TheShniz
Posts: 213
 Member Since:
2006-06-01
Alrighty, I got it
Tue, 07/17/2007 - 8:22am

Alrighty, I got it working...

There's a known bug in the current v3 in that exporting to .csv's is broken, but it worked in v.2. Does anyone have an archived copy of v.2? I'd like to try & patch it.

...thanx,
- J



jtknapp
Posts: 81
 Member Since:
2006-06-07
PC Queue Monitor
Tue, 07/17/2007 - 9:08am

If your looking for a PC application to monitor your queues check out ASTassistant.

http://www.orbus.net/astassistant

I am always willing to make a change and add any features I can.

--


GSnover
Posts: 1300
 Member Since:
2006-11-19
Ping husaints
Tue, 07/24/2007 - 4:17pm

As to error #1, if you look on the install document on the asteriskguru site, it SPECIFICALLY doesn't read Master.csv - It says it does this because it might be too big - you have to fill out the accountcode blank on all the extensions you want to monitor - This is kind of a bug to me - does anyone else have a way to make it read the Master.csv - since the accountcode field doesn't show when you are adding an extension, this is kind of a pain.

As to your second bug, I am having that one too - still working on it!

Greg

P.S. - Don't waste your time copying Master.csv to something else - the first field is accountcode, and if it is blank, queuestats ignores it - Doh!



LinkyParky
Posts: 33
 Member Since:
2008-03-12
does anyone have the queue
Fri, 04/04/2008 - 11:37am

does anyone have the queue stats working?



GSnover
Posts: 1300
 Member Since:
2006-11-19
I have it working on several 2.2 boxes - Haven't tried it with a
Fri, 04/04/2008 - 8:39pm

2.4/2.6 yet, but I am going to try this weekend - I will post results.

Greg



LinkyParky
Posts: 33
 Member Since:
2008-03-12
please help me...getting
Thu, 04/10/2008 - 9:26am

please help me...getting this error :

Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: could not connect to server: Network is unreachable Is the server running on host "172.0.0.1" and accepting TCP/IP connections on port 5432? in /var/www/html/queuestats/include/config.inc.php on line 47

Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/html/queuestats/include/query.php on line 161

Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/html/queuestats/include/query.php on line 174

Warning: pg_fetch_object() expects parameter 1 to be resource, boolean given in /var/www/html/queuestats/include/query.php on line 175

Warning: pg_query() [function.pg-query]: No PostgreSQL link opened yet in /var/www/html/queuestats/include/query.php on line 187

Warning: pg_fetch_object() expects parameter 1 to be resource, boolean given in /var/www/html/queuestats/include/query.php on line 188

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/queuestats/include/config.inc.php:47) in /var/www/html/queuestats/include/query.php on line 195



LinkyParky
Posts: 33
 Member Since:
2008-03-12
outgoing stats not working
Fri, 04/11/2008 - 1:56pm

outgoing stats not working :(



GSnover
Posts: 1300
 Member Since:
2006-11-19
You have to set an Account Code on each of the Extensions
Fri, 04/11/2008 - 7:35pm

and then you have to go to http://asterisk/queuestats/log/cdr.php to make Questats catalog the calls - then you will have outgoing.

Greg



LinkyParky
Posts: 33
 Member Since:
2008-03-12
when i run the command u
Tue, 04/15/2008 - 8:09am

when i run the command u telling me, i get this on my screen :

No files like *.csv found in /var/log/asterisk/cdr-csv. Check the content of the specified log directory!



GSnover
Posts: 1300
 Member Since:
2006-11-19
Right - you have to set an account code, and then make some
Tue, 04/15/2008 - 10:18am

calls from the phones to generate the files so that Queuestats can import them.

Greg



LinkyParky
Posts: 33
 Member Since:
2008-03-12
is the outgoing u mean?
Mon, 04/28/2008 - 7:10am

is the outgoing u mean?



kerryg
Posts: 5545
 Member Since:
2006-05-31
When someone has this all
Mon, 04/28/2008 - 7:12am

When someone has this all worked out with a complete set of directions, please PM me so we can get an RPM developed.

--

Kerry Garrison
trixbox Community Director
http://www.trixbox.com/support-and-training/training
http://L7Foto.com / http://AsteriskTutorials.com / http://voipspeak.net



Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.