Asterisk is an open source PBX that helps you to have your own inexpensive VoIP network. This tool will help you to have a better overview of the incoming and outgoing calls passing through your Asterisk server. We assume that you have some basic knowledge in Asterisk, PHP and databases.
The application is reading the queue_log and cdr (call data record) files, puts their content in a database and from there gets different kind of statistics for the selected call group.
We are using jpGraph product for the graphics which is QPL licensed.
You can go directly to the download page by clicking here.
As you probably saw the php scripts are encoded. So you need to install Zend Optimizer module for Apache in order to run the scripts (other way apache can not read the php files).
NOTE: After Zend Optimizer is installed check your php.ini file. There you should turn on Zend Optimizer (it might be turned off).
Download the PHP files and create the database table as described below (you have to use PosgresSQL database).
STRUCTURE
The application is working in the following way.
1. All incoming calls are stored in the queue_log file (by default it is in /var/log/asterisk/queue_log). Asterisk has to be set to do this itself. By default logging the queue data to the queue_log file is not enabled.
2. All outgoing calls are stored in CDR files. The files are placed in /var/log/asterisk/cdr-csv/ by default. The Queue Statistics application does not parse the Master.csv file, because in some cases it might be too large and heavy. That is why you have to create your own *.csv files for the groups you need. You may add ‘accountcode’ value for the accounts you use in sip.conf or iax.conf.
When Asterisk finds these ‘accountcode’ values it will log the call data to <accountcode>.csv (in the example support.csv) – and respectively it will create this file if it does not exist yet.
3. There are two php scripts that parse the log files and fill up the database. The logque.php script is parsing the data for the incoming calls, logged in queue_log files (original and rotated). The original file is named queue_log and the rotated files are named like queue_log.0, queue_log.1, etc. So the script reads the files (sorted by modification date) one by one starting from the last modified, finishing with the most resent. The cdr.php script parses the outgoing call’s data logged in *.csv files. It reads all *.csv files except Master.csv. The data is stored in the created PostgreSQL database.
4. PHP gets the stored data from the database and creates tables and graphics for the statistics.
QUEUE_LOG
Queue_log is an Asterisk log file where data concerning the queues is written. More precisely is to say that only data concerning the incoming calls, agent logins and logouts and transfers is written.
To fill in the database you must first of all have a queue_log file. The default directory where the log files are placed is /var/log/asterisk/.
The queue_log is not created by default. Check whether you have this line in /etc/asterisk/logger.conf. queue_log=>
This writes the data from the queues to this queue_log file. logger.conf file is for setting the logs which to be created and filled in /var/log/asterisk/. So the first step is to set Asterisk to write to the queue_log.
CDR
CDRs are files storing call records data. AsteriskGuru Queue Statistics reads these files and finds information for the outgoing calls. By default the files are stored in /var/log/asterisk/cdr-csv/.
DATABASE
The SQL database structure that the application needs can be found in db.sql (/db directory of the application). You should have installed PostgreSQL. Just execute the queries from the db.sql file.
It is preferable to create a new database. If you are not aware how to make one here is a simple query that does this:
When you have the database just execute the query from db.sql and you will have the tables that you need for storing the queue_log and cdr data.
In case of an error during the execution of "cdr.php" and/or "log.php", and the error is of type "access deny", most probably the username that You are using to access the DataBase does not have the needed privileges. Execution the commands in this file: access deny case commandline.txt - simply copy-past them in the Postgres console, but replace the "username" with the one which you typed as a "WITH OWNER" at the creation of the DataBase.
SETTINGS
The application is encoded except the config.inc.php files in directory /log and /include which you can modify. The language files are also not encoded for volunteers that would like to help us distribute the AsteriskGuru Queue Stats in different languages. Everyone willing can send us the translated values of the language array to support@asteriskguru.com (suggestions for the English version are also appreciated).
1. Log directory
Look at config.inc.php in the log directory. These configuration settings are only for the logque.php and cdr.php scripts (just the parsers). You have to set the required parameter for connecting to the database as well as the absolute path to your queue_log and CDR files. Below you can see the default path setting for the log files. If you store them in different place you have to change the values for the variables.
This is establishing connection to the database on the local machine (127.0.0.1), so if your database is somewhere remotely you have to type the address where it can be accessed. Just change the value for the $db_host variable to a valid address for your database server. $db_name is the database name where the table data is stored, and $db_user is the username for the user who has privileges to access the database. $db_pass is the password of the user who is accessing the database.
2. Include directory
This config.inc.php file is for the main part of the php application i.e. all the stats graphs and reports. You have to originate the connection to the database as described in the previous section.
Next is to provide the absolute path for the report images. There is option to see the reports in PDF format. The images for the report are generated and stored somewhere locally before used for the report itself. But the PHP has to have permissions to write down on your hard drive the images so you have to provide the path to this directory.
The images for the reports have to be saved locally on your pc. Therefore the web server must have privileges to write and read from the directory where they will be stored. The default directory is different and depends on the OS. For Linux it is "/tmp" and for Windows it is "%USERPROFILE%Local SettingsTemp" (usually C:Documents and Settings<user>Local SettingsTemp). Choose you OS between Linux and windows. Comment the one you are not going to use.
$os = "linux";
#$os = "windows";
Then set the correct path to the directory where the images will be stored.
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 web server can write into it. For windows you can also make a directory where the images to be stored, but again you have to provide read and write access for the web server.
$image_path_lin = "/tmp";
$image_path_win = "./pdf_images";
You also have language settings. Now the AsteriskGuru Queue Stats are available just in English (EN). Volunteers who would like to translate it into other languages are always welcome. That is why the language files are not encoded. Translated language files can be emailed to support@asteriskguru.com. In this config file you can set your default language.
$default_language = 'en';
You also have default settings for time zone, start hour and end hour of the filter. Make sure you set the values to one of the valid ones described in the config.inc.php file, or the changes you made will not take effect.
The reason that you have two similar config.inc.php files is that you can have the parsing script and the rest of the application on two separate computers.
You can set a crontab running the logque.php and cdr.php files at certain time after you filled the database for a first time.
STATS
When you have created the database and copy the other scripts on your web server (you can place the logque.php and cdr.php on other machine but anyway the hierarchy must not be changed), then you can run the application. Make sure that all downloaded directories and files are structured on your computer as in the download directory. All files have to be in your apache-working directory.
First fill in the database with the logque.php (placed in the log directory) then with cdr.php (placed again in the log directory). Make sure the settings in config.inc.php are correct (path to the queue_log and cdr files).
Then just type in a browser path/index.php and the program will run and you can choose period for the statistics, group(s) (you can select all available groups for incoming or outgoing calls), time zone and language for the statistics calculations.
azithromycin buy online (salliefttbkwtqhdendjs859 at clifors dot xyz) 16 September 2020 00:12:35 azithromycin buy online https://azithromycinx250.com/
joker 123 (CharleneWoodfull73 at sky dot frequiry dot com) 13 May 2019 21:25:36 Go to bookstores, social gatherings, business meetings, whatever you can. Your internal critic may be replaying those critical and condemning words you heard as youngsters. They could be especially often seen from very far. https://918kiss.party/downloads/5143-download-joker123-for-android-and-ios
raskruEquap (toporovefrem55 at mail dot ru) 10 April 2019 02:15:34 <a href=http://seo-raskruti.ru>http://seo-raskruti.ru/</a>
XEvilBestSok (gundosovitchjebrail at yandex dot com) 06 December 2018 04:04:26 Revolutional update of captchas breaking software "XEvil 4.0":
captchas solving of Google (ReCaptcha-2 and ReCaptcha-3), Facebook, BitFinex, Bing, Hotmail, SolveMedia, Yandex,
and more than 8400 another categories of captcha,
with highest precision (80..100%) and highest speed (100 img per second).
You can use XEvil 4.0 with any most popular SEO/SMM software: iMacros, XRumer, GSA SER, ZennoPoster, Srapebox, Senuke, and more than 100 of other software.
Interested? You can find a lot of introducing videos about XEvil in YouTube.
FREE DEMO AVAILABLE!
See you later!
http://XEvil.net/
XEvilBestSok (gundosovitchjebrail at yandex dot com) 28 November 2018 02:36:34 Incredible update of captchas regignizing software "XRumer 16.0 + XEvil":
captcha regignizing of Google (ReCaptcha-2 and ReCaptcha-3), Facebook, BitFinex, Bing, Hotmail, SolveMedia, Yandex,
and more than 8400 another types of captcha,
with highest precision (80..100%) and highest speed (100 img per second).
You can use XEvil 4.0 with any most popular SEO/SMM software: iMacros, XRumer, GSA SER, ZennoPoster, Srapebox, Senuke, and more than 100 of other software.
Interested? You can find a lot of demo videos about XEvil in YouTube.
FREE DEMO AVAILABLE!
See you later ;)
http://XEvil.net/
JasonCaM (painkillerfer at hotmail dot com) 08 February 2017 16:18:08 check doused this <a href=http://onlinecasinos-x.com/>online casinos</a> where you can conquer genuine kale with the avoid of this guidePlaying <a href=http://onlinecasinos-x.com/online-baccarat.html>baccarat online</a>
Meriem (merie dot deb at gmail dot com) 02 September 2015 14:41:35 merie.deb@gmail.com zsdfzefze z zef fz
aaa (dcq dot dq dot dq at sqds dot cl) 02 September 2015 14:40:21 cxssccd sd
riaz (riaz_402 at yahoo dot com) 16 June 2009 20:36:00 i am using ix calling software.but when i making the audio codects its not register
what i havte to choose from the audio coeects can u tell me plz
Terry Sweetser (terry at skymesh dot net dot au) 16 June 2009 04:52:20 Warning: pg_query(): Query failed: ERROR: operator does not exist: character varying = integer at character 140 HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /var/www/html/queue_stats/log/logque.php on line 247
The above error is from postgres 8.3's new lack of auto-casting. The queries will need a rewrite!
Francesco Capuano (francesco dot capuano at teknema dot it) 05 December 2008 15:38:59 Hi,
I've an Elastix installation and I would like to install queue stats.
I've installed everything, but I obtain a white page when I open it with a browser.
Withe screen on everything (incoming_general.php, logque.php and cdr.php). It's the second time I install it and on mi old Asterisk@home it works.
Last time I've added the folder \usr\X11R6 for a font problem, but adding it it still doesn't work...
Can you suggest me something?
James Sneeringer (jsneerin at gmail dot com) 24 May 2008 22:06:31 Dedalo and others, if you are getting these error messages when trying to run logque.php:
Warning: pg_end_copy(): Query failed: ERROR: invalid input syntax for type timestamp with time zone: ""
CONTEXT: COPY queue_stats_tmp, line 605, column call_datetime: "" in /var/www/stats/log/logque.php on line 29
The problem is that (in my case) the logque.php script does not like line 605. The script will output all lines that it sees, so you just need to scroll back to line 605 to fine the objectionable line. In my case, it was this:
The script looks to the second field for the UNIQUEID so that it can get the timestamp of the event, and it apparently does not know what to do with CLI-generated events. I removed that line from my queue_log, and now I can import the data.
Sidnei (sidnei_rp at ig dot com dot br) 12 May 2008 15:42:02 i have following error :
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for integer: "" in /var/www/html/queuestats/public/error.php on line 61
Warning: pg_fetch_object() expects parameter 1 to be resource, boolean given in /var/www/html/queuestats/public/error.php on line 62
could someone please help me.
Dedalo (moebhius at msn dot com) 26 April 2008 00:05:48 Hi, I have same problem that someone else before.
When I execute the cdr.php script there's no problem, in fact i can see the reports of the outgoing calls.
but, when I execute logque.php I have the folowing:
<br>(43). 1209154321|1209154310.36|1000|Local/1001@from-internal/n|CONNECT|11|1209154310.37
<br>(44). 1209154343|1209154310.36|1000|Local/1001@from-internal/n|COMPLETECALLER|11|22|1
PHP Notice: Undefined offset: 1 in /var/www/html/monitor/log/logque.php on line 167
PHP Warning: pg_end_copy(): Query failed: ERROR: invalid input syntax for type timestamp with time zone: ""
CONTEXT: COPY queue_stats_tmp, line 13, column call_datetime: "" in /var/www/html/monitor/log/logque.php on line 29
<br><i>The records above were added to the DB</i></tr></td><tr><td><hr bgcolor='#B3B1FF'></td></tr></table></div>PHP Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/html/monitor/log/logque.php on line 257
PHP Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/html/monitor/log/logque.php on line 271
PHP Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/html/monitor/log/logque.php on line 285
PHP Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/html/monitor/log/logque.php on line 296
PHP Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/html/monitor/log/logque.php on line 307
PHP Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/html/monitor/log/logque.php on line 318
PHP Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/html/monitor/log/logque.php on line 347
PHP Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/html/monitor/log/logque.php on line 368
PHP Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/html/monitor/log/logque.php on line 371
----------------------
I've created the database just like instructions says, including modification to the logger.conf.
I'm running under centos5, asterisk 1.4.15 and postgresql 8.1.11-1
Lucas (lucas at provetel dot com dot ar) 14 April 2008 18:42:03 Hello, I have the following problem, when I click "Incoming stats by agent" I got this message:
Warning: Invalid argument supplied for foreach() in /var/www/public/incoming_agents.php on line 456
And JDgraphs shows a message that the plot area is too small. Increase the plot size or reduce the margins.
Is not a empty database problem because the table is showing me an Agent with 3 calls.
I would like to receive any answer, at least an answer telling me that I won't receive any solution or perhaps if it's a known bug.
Thanks in advance.
Oscar Wong (wongoscar at scarlet dot an) 03 April 2008 17:14:29 i have following error :
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for integer: "" in /var/www/html/queuestats/public/error.php on line 61
Warning: pg_fetch_object() expects parameter 1 to be resource, boolean given in /var/www/html/queuestats/public/error.php on line 62
could someone please help me.
Eduardo (erugama at gmail dot com) 29 March 2008 01:52:01 The CDR logs works really fine, my problem is quith the Queue logs, here is what the application keeps telling me, No data is written to the DB tables (qname, qagent,queue_stats).
Here is the last part of my Imports...
Could any body helps?
The file queue_log (last modified on 28th Mar 2008 14:59:19) was found and considered valid.
Checking file content, please wait. Reading line 1
(1). 1206735119|1206735110.29304|NONE|Agent/2013|AGENTCALLBACKLOGIN|2013
(2). 1206735325|1206735325.29420|Q1|NONE|ENTERQUEUE||2050
(3). 1206735338|1206735325.29420|Q1|Agent/2013|CONNECT|13
(4). 1206735355|1206735325.29420|Q1|Agent/2013|COMPLETEAGENT|13|17|1
(5). 1206735369|1206735369.29442|Q1|NONE|ENTERQUEUE||2050
(6). 1206735415|1206735369.29442|Q1|Agent/2013|CONNECT|46
(7). 1206735419|1206735369.29442|Q1|Agent/2013|COMPLETEAGENT|46|4|1
(8). 1206735623|1206735609.29569|NONE|Agent/2013|AGENTCALLBACKLOGOFF|2013|504|
(9). 1206736526|1206736526.29926|Q1|NONE|ENTERQUEUE||2050
(10). 1206736542|1206736526.29926|Q1|NONE|ABANDON|1|1|16
(11). 1206737481|1206737475.30197|Q1|NONE|ENTERQUEUE||04271290251
(12). 1206737513|1206737475.30197|Q1|Agent/2013|CONNECT|32
(13). 1206737608|1206737475.30197|Q1|Agent/2013|COMPLETEAGENT|32|95|1
(14). 1206737829|1206737814.30306|NONE|Agent/2013|AGENTCALLBACKLOGOFF||1206737829|
(15). 1206737865|1206737847.30316|NONE|Agent/2013|AGENTCALLBACKLOGIN|2013
(16). 1206737889|1206737881.30326|Q1|NONE|ENTERQUEUE||04271290251
(17). 1206737902|1206737881.30326|Q1|Agent/2013|CONNECT|13
(18). 1206737959|1206737881.30326|Q1|Agent/2013|COMPLETEAGENT|13|57|1
The records above were added to the DB
Warning: pg_query(): Query failed: ERROR: operator does not exist: character varying = integer at character 140 HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /var/www/html/queue_stats/log/logque.php on line 247
Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/html/queue_stats/log/logque.php on line 261
Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/html/queue_stats/log/logque.php on line 275
Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/html/queue_stats/log/logque.php on line 286
Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/html/queue_stats/log/logque.php on line 297
Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/html/queue_stats/log/logque.php on line 308
Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/html/queue_stats/log/logque.php on line 337
Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/html/queue_stats/log/logque.php on line 340
billetkontoret (sa at billetkontoret dot dk) 07 March 2008 16:54:28 What is this error:
Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "access_accountcode" does not exist in /var/www/html/stats/public/error.php on line 89
Chris (chris dot stinson at vonx dot isdn dot net) 19 December 2007 20:23:25 Nevermind I got it ;)
Chris (chris dot stinson at vonx dot isdn dot net) 18 December 2007 20:10:26 I'm getting the error "The component "Zend Optimizer" is not installed on the Web Server and therefore cannot service encoded files. Please download and install the Zend Optimizer (available without charge) on the Web Server." when pulling up the web page.
I have installed the optimizer with no errors.
[Dec 18 12:56:24] MSGBOX: "The installation has completed successfully. Zend Optimizer is now ready for use. You must restart your Web server for the modifications to take effect."
[Dec 18 12:56:24] ./dialog --clear --backtitle 'Zend Optimizer Installation' --title 'Zend Optimizer 3.0.2' --msgbox ' The installation has completed successfully. Zend Optimizer is now ready for use. You must restart your Web server for the modifications to take effect. ' 0 0
[Dec 18 12:56:27] YESNO: Restart the Web server now?
[Dec 18 12:56:27] ./dialog --clear --backtitle 'Zend Optimizer Installation' --title 'Zend Optimizer 3.0.2' --yesno ' Restart the Web server now? ' 0 0
[Dec 18 12:56:28] User choose: YES
[Dec 18 12:56:28] Trying to restart Apache ...
[Dec 18 12:56:28] Executing: "/usr/sbin/apachectl stop 1>/dev/null" (status: 0)
[Dec 18 12:56:32] Executing: "/usr/sbin/apachectl start 1>/dev/null" (status: 0)
[Dec 18 12:56:36] Executing: "kill -0 19731 1>/dev/null" (status: 0)
[Dec 18 12:56:39] Executing: "kill -0 19731 1>/dev/null" (status: 0)
[Dec 18 12:56:39] MSGBOX: "Apache has restarted successfully."
[Dec 18 12:56:39] ./dialog --clear --backtitle 'Zend Optimizer Installation' --title 'Zend Optimizer 3.0.2' --msgbox ' Apache has restarted successfully. ' 0 0
[Dec 18 12:56:40] Cleaning up ...
What else could be the issue?
Attila (amarton at hotmail dot com) 11 December 2007 00:57:20 We need a fix for Venezueal TimeZone.
Starting at 9 December 2007 there is a new Timezone for Venezuela that is GMT -4:30
What's the workaround?
Billetkontoret (sa at billetkontoret dot dk) 07 November 2007 12:47:57 Hi. I have everything running and data in the db. But everytime I try to load the index.php I get this: Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/recordings/qstats/include/config.inc.php:2) in /var/www/html/recordings/qstats/include/query.php on line 247
Daniel Varella (dvarella at gmail dot com) 08 October 2007 04:28:47 Hi. How can I help to translate this application to Brazilian Portuguese ?
redcom (redcom at gmail dot com) 07 October 2007 13:30:22 hello
i would like to buy the source code of the project.
i can not install postgresql and i would like to use mysql.
my company have a mysql commercial licence and would like to use that,
Can you send me a price list for the queue stat ?
www.inclub.ro is the website for my company
And my name is redcom
Thanks.
mustardman (mustardman29 at hotmail dot com) 12 August 2007 23:51:51 I'll make you a deal guys. You help me with my problem and I will write a better install document. As is your procedure is missing HUGE pieces of the puzzle. I have been tearing my hair out for days! Managed somehow to actually get it going from snippets I read various places (none of them on this website) and on my own.
I have 2 remaining problems. It appears support.csv is not populating the database even though it says it is with no errors when I run cdr.php.
Second issue is "Incoming stats by Agent" gives a JPGraph error saying the "plot has an illegal scale"
Eli Juarez (ejuarez at gemtel dot net) 01 August 2007 02:28:19 Hi, problem solved, for those who has the problem with the "The Database is Empty" sign, try to add to config.inc.php in the connection string line, "port=5432" after "password=$db_db_pass"
At least it worked for me, now i have a Fonts problem :P
Eli Juarez (ejuarez at gemtel dot net) 31 July 2007 18:36:42 Hi, i've installed queue statistics,but i have a little problem, i can execute cdr.php and logque.php and Internet Explorer doesn't shows any errors, in fact, it shows "Valid File" and "Data uploaded to DB" but when i write index.php, a red sign saying "The Database is Empty" appears, altough i have several records. What's the problem? Can anybody help me?
Eli Juarez (ejuarez at gemtel dot net) 31 July 2007 18:34:48 Hi, i've installed queue statistics,but i have a little problem, i can execute cdr.php and logque.php and Internet Explorer doesn't shows any errors, in fact, it shows "Valid File" and "Data uploaded to DB" but when i write index.php, a red sign saying "The Database is Empty" appears, altough i have several records. What's the problem? Can anybody help me?
Manuel Santizo (msantizo at americanassist dot com) 05 June 2007 04:20:05 Hello.
I hope somebody can help me, I use to install queues statistics but in the last installation i have a big problem, i have access to the DataBase, i Have evrething installed but when i run the logqueue.php and begin without a problem but before finished the registers stop the firefox navigator and nothing happen, i don't have records in the database, if i make a test with just 22 registers go right but not with more than a hundred, could anybody knows how to arrange it?.
Thank you
Bryan Copeland (bcopeland at broadpointinc dot com) 15 May 2007 19:39:34 Help.. I'm getting the following errors after installation...
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for integer: "" in /var/www/localhost/htdocs/public/error.php on line 61
Warning: pg_fetch_object() expects parameter 1 to be resource, boolean given in /var/www/localhost/htdocs/public/error.php on line 62
Iain Mcfee (iainm at lysander dot co dot uk) 30 April 2007 09:55:26 Will it work with trixbox version
Pablo (pablo_bertuzzi at yahoo dot com) 22 April 2007 23:55:04 Hello, i got the following when run the php scripts.
Any clue?
PHP Warning: pg_put_line(): No PostgreSQL link opened yet in /usr/src/asteriskguru_queue_stats.0.3.0_enc/log/cdr.php on line 18
PHP Notice: Undefined offset: 16 in /usr/src/asteriskguru_queue_stats.0.3.0_enc/log/cdr.php on line 198
PHP Notice: Undefined offset: 17 in /usr/src/asteriskguru_queue_stats.0.3.0_enc/log/cdr.php on line 199
rpinheiro (bentamix at yahoo dot com dot br) 21 March 2007 20:08:37 Hi, QueueMetrics does not show me information about login/logout too, pehaps a bug in this release.. Fedora Core 5, Asterisk 1.4.1 and PostgreSQL 8.1.8
Dmitry (dmatushkin at gmail dot com) 07 March 2007 01:45:04 Hi! QueueStats 0.20 does not show information about agents login/logout at "Incoming stats by date". Platform - FreeBSD 6.0-RELEASE asterisk 1.2.13 postgresql 8.0.8. Could you give me some suggestions of what may be wrong?
Dmitry (dmatushkin at gmail dot com) 07 March 2007 01:07:11 Hi! Is any way to setup default timezone for "Queue Statistics" ?
Maxi Belino (maxi dot belino at gmail dot com) 03 March 2007 20:07:12 QueueStats.0.20
This error was displayed when i tried to fill the database with logque.php:
No files like queue_log* found in . Check the content of the specified log directory!
Steps to correct this:
1. Make readable the queue_log file
cd /var/log/asterisk
chmod o+r queue_log
2. Please correct the file log/config.inc.php
substitute the first line (the initial php tag is missing):
<?
with this:
<?php
Lokesh Kumar (lokesh at interacesso dot pt) 08 February 2007 16:39:18 Hello,
Does anyone knows if queue_stats-0.20 is compatable with PHP version 5. I am unable to run queue stats on php 5. It gives error like this.
PHP Fatal error: Unable to read 172 bytes
in /var/www/html/queue_stats.0.20/public/index.php on line 0
darek (darek at vpn dot pl) 20 November 2006 12:58:21 I've installed latest version queue_stats and I found two errors:
1. In file log/config.inc.php
$queue_log_dir = '/var/log/asterisk/cdr-csv/';
$cdr_log_dir = '/var/log/asterisk/';
2. When I try to load new data I see:
No files like *.csv found in /var/log/asterisk/cdr-csv. Check the content of the specified log directory!
but
root@stun:~# ls -l /var/log/asterisk/cdr-csv/
razem 4976
-rw-r--r-- 1 root root 5079237 2006-11-20 12:46 Master.csv
Regards
mohojojo (moho dot jojo at gmail dot com) 20 November 2006 11:03:25 [Mon Nov 20 10:50:15 2006] [error] PHP Warning: Division by zero in /var/www/queue_stats.0.20/public/incoming_general.php on line 308
[Mon Nov 20 10:50:15 2006] [error] PHP Warning: Division by zero in /var/www/queue_stats.0.20/public/incoming_general.php on line 313
[Mon Nov 20 10:50:15 2006] [error] PHP Warning: Division by zero in /var/www/queue_stats.0.20/public/incoming_general.php on line 320
[Mon Nov 20 10:50:15 2006] [error] PHP Warning: Division by zero in /var/www/queue_stats.0.20/public/incoming_general.php on line 379
[Mon Nov 20 10:50:15 2006] [error] PHP Warning: Division by zero in /var/www/queue_stats.0.20/public/incoming_general.php on line 381
[Mon Nov 20 10:50:15 2006] [error] PHP Warning: Division by zero in /var/www/queue_stats.0.20/public/incoming_general.php on line 383
[Mon Nov 20 10:50:15 2006] [error] PHP Warning: Division by zero in /var/www/queue_stats.0.20/public/incoming_general.php on line 385
[Mon Nov 20 10:50:15 2006] [error] PHP Warning: Division by zero in /var/www/queue_stats.0.20/public/incoming_general.php on line 387
[Mon Nov 20 10:50:15 2006] [error] PHP Warning: Division by zero in /var/www/queue_stats.0.20/public/incoming_general.php on line 389
[Mon Nov 20 10:50:15 2006] [error] PHP Warning: Division by zero in /var/www/queue_stats.0.20/public/incoming_general.php on line 391
[Mon Nov 20 10:50:15 2006] [error] PHP Warning: Division by zero in /var/www/queue_stats.0.20/public/incoming_general.php on line 426
ficeto (ficeto at ficeto dot com) 17 November 2006 21:42:53 for you all that use dynamic agents with "AddMemberQueue", have no chance to get login and logout times correct, so use AgentCallbackLogin instead and if Queue Stats don't recognize Login/Logout, edit the asterisk source(i dont remember which file but search for "AGENTCALLBACKLOGIN" and "AGENTCALLBACKLOGOUT" and change them to "AGENTLOGIN" and "AGENTLOGOUT") then ./configure, make and make install and you'll be ok.
terchris (terchris at hotmail dot com) 16 November 2006 15:40:45 I installed the zend.com sw and phpinfo() displays:
This program makes use of the Zend Scripting Language Engine: Zend Engine v1.3.0.....
But when I try to access index.php or logque.php I get this:
"Zend Optimizer not installed"
the php.ini file used is /usr/local/Zend/etc/php.ini
terchris
mohojojo (moho dot jojo at gmail dot com) 27 October 2006 10:50:02 installed successfully, but I get this message whe I load index.php: The database is empty! Only have this message, no other php error or sql connection error.
Joan (joan dot mauri at quarea dot com) 10 October 2006 19:32:40 Hello,
I've installed everithing I saw on the tutorial, but i don't know how to create the database (I have no idea about postgresql), I've been "googleING" for long and I can't find the good way to create the database for this aplication. Could someone write me the correct sintax for (how to connect to postgresql command line?):
CREATE DATABASE db_name
WITH OWNER = username
ENCODING = 'SQL_ASCII'
TABLESPACE = pg_default;
And I don't know what to do with the file db.sql which is located on: queue_stats.0.10/db
Thanks so much!!
susantok (santok at student dot eepis-its dot edu) 06 October 2006 09:12:53 anyone please give me some example about queue.conf
is there has relation with this queue_stats config ?
thx
Matt Brown (matt dot brown at 3ait dot co dot uk) 13 September 2006 01:17:18 Hi,
I love the app, one small problems exists with logque.php. I ran it with three log files queue_log queue_log.1 queue_log.2.gz.
queue_log.2.gz had already been loaded and so it skipped over (which is fine) queue_log.1 was a rotated file but no data was loaded to db, and still fails to load - and queue_log was fine.
How does the program work to load data ?
If it was to ignore the current queue_log load check and load queue_log.x and ignore completely queue_log.x.gz this behaviour would be fine and can easily be done via logrotate.
susantok (santok at student dot eepis-its dot edu) 06 September 2006 08:29:18 My queue_log just have two comment [QUEUESTART] and [CONFIGRELOAD]
I am always make echotest call and one call betwen client under testing but no call activities recorded into log file "queue_log".
Cristian (kritikus at gmail dot com) 05 September 2006 22:36:50 Hi:
I have the follow issue.
After the righ configuration of queue_log in asterisk and the path and database of config.inc.php under log/ and config.inc.php under include/ . After the execucion of http://queue_stats.0.10/log/logqueue.php i got the following messages in the browser:
No files like queue_log* found in . Check the content of the specified log directory!
So in the apache error log files i got the follow messages:
[Tue Sep 05 16:17:23 2006] [error] [client 192.168.0.2] PHP Notice: Undefined variable: queue_log_dir in /usr/local/apache2/htdocs/queue_stats.0.10/log/logque.php on line 21, referer: http://192.168.0.2/queue_stats.0.10/log/
[Tue Sep 05 16:17:23 2006] [error] [client 192.168.0.2] PHP Warning: readdir(): supplied argument is not a valid Directory resource in /usr/local/apache2/htdocs/queue_stats.0.10/log/logque.php on line 26, referer: http://192.168.0.2/queue_stats.0.10/log/
[Tue Sep 05 16:17:23 2006] [error] [client 192.168.0.2] PHP Notice: Undefined variable: files in /usr/local/apache2/htdocs/queue_stats.0.10/log/logque.php on line 29, referer: http://192.168.0.2/queue_stats.0.10/log/
[Tue Sep 05 16:17:23 2006] [error] [client 192.168.0.2] PHP Warning: Invalid argument supplied for foreach() in /usr/local/apache2/htdocs/queue_stats.0.10/log/logque.php on line 29, referer: http://192.168.0.2/queue_stats.0.10/log/
Any help is appreciated.
Thank.
cris.
Avi (avi dot miller at squiz dot net) 25 August 2006 08:11:46 I can't get 0.10 to import any of my data. It says:
The file /var/log/asterisk/queue_log (last modified on 2006-08-25 15:40:54) was found and considered valid.
Checking file content, please wait. Reading line 1
Wrong parameters or empty line
Wrong parameters or empty line
Wrong parameters or empty line
Wrong parameters or empty line
susantok (santok at student dot eepis-its dot edu) 25 August 2006 03:35:10 I have problem here can you help me ?
I just have message in my browser
The database is empty !
I use Debian, PHP4, Apache2, queue.0.10, Postgre 7.4
Thx
Greg (gregdelgado at yahoo dot com) 22 August 2006 15:52:54 This is a great management tool. I installed it, everything works except for the Agents and Details screens where every field that's supposed to show Agents/XXXX only displays as Agents. However, your screenshots show the correct Agents/XXXX fields. May we ask what versions of PostgreSQL, PHP and Asterisk you used to generate those screenshots in the asteriskguru site?
Patrikios Gerassimos (gpatrikios at imageflow dot gr) 21 August 2006 11:52:10 Hi all,
Is there a ready distribution available for asterisk?
Patrikios Gerassimos (gpatrikios at imageflow dot gr) 21 August 2006 11:50:49 Hi Ivan,
Since I'm a totally new user to asterisk, after installing all the needed things for asterisk to operate, how do I make changes in the asterisk so I can create my company's PBX?
Thanks in advance..!!
Simon (simon at etech-training dot co dot uk) 20 August 2006 22:08:09 There is now a video available that walks you through click by click the installation of Queue Statistics on Trixbox. Although it will probably also work for stock installs of Asterisk.
Jose Maria (sarachaga at yahoo dot com) 07 July 2006 05:47:20 Why don't you make this open source so we can help you fix it?
By now i had to make some MS Access queries to get per agent info, but i like this tool a lot and would like to contribute.
Regards
hendrikdw (hendrikdw at mycomax dot com) 05 July 2006 11:56:11 Can some one help?
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!
My Platform:
---------
Linux Centos
Trixbox1.1
PostgreSQL version 7.4.13
Mindaugas Kezys (info at dvd dot ot dot lt) 28 June 2006 15:03:20 Hello,
Congrats for great software!
PHP5 makes some strange warnings about gdate(), PHP4 fixed this issue.
Right now we are getting duplicate fields from time to time in the db.
On which data do software decide to put field into db or not to put?
Regards,
Midnaugas Kezys
Joel (jkepaou at sunnetgroup dot net) 17 June 2006 07:12:44 I have two problems that have been posted here but I do not see the resolution
1- Automatic Agent: to be able to see them separately in the report, right now it is just one Agent.
2- I recieve error when I try to load "logque.php"
The file /var/log/asterisk/queue_log (last modified on 2006-06-18 01:06:46) was found and considered valid.Error occured, while trying to read the file. I have to delete the queue_log file stop and start asterisk. The new queue_log file is processed without error by loggue file, after few transactions the error reapears.
3-There is no data for the selected period and callgroup when I try to drill down more than the general statistics.
If anybody has a resolution for those problems I will apreciate.
Thankx
Joel (jkepaou at sunnetgroup dot net) 16 June 2006 20:29:34 I have access to the first page where I can select my
queue, but when I try to run the report I get the following error:
*Warning*: session_start() [function.session-start
<http://192.168.0.249/queue_stats.0.10/public/function.session-start>]:
open(/root/tmp/sess_3c7bad07d0f5896a8db113b238d5e40e, O_RDWR) failed: Permission denied (13) in */usr/local/apache2/htdocs/queue_stats.0.10/public/menu_general.php*
on line *2*
I give access to /root/tmp, bujt I still have the same error.
what's wrong?
My plattform:
-queue_stats.0.10
-PHP 5.1.4
-PostgreSQL 7.4.13
-Asterisk 1.0.9
-Mandrake
wang (liyuqian at 95177 dot com) 14 June 2006 03:03:18 Hi, Ivan.
I think this tool is very good. But can't use it in dynamic agents. and many pepoples have same problem. So, please quikly to upgrade this tool.
Thanks
wang (liyuqian at 95177 dot com) 14 June 2006 03:02:10 Hi, Ivan.
I think this tool is very good. But can't use it in dynamic agents. and many pepoples have same problem. So, please quikly to upgrade this tool.
Thanks
Li (li770426 at gmail dot com) 11 June 2006 05:57:49 I used agentcallbacklogin login a agent, but agent name only show "Agent", no "Agent/5001", what is wrong? Thanks
Jose Maria (sarachaga at yahoo dot com) 06 June 2006 19:15:11 Do you have any aprox date of a new release? i'm having the dynamic agents problem too and is troubleing me, all calls appear answered by "Agent" instead of "Agent/1"..."Agent/7".
Thankss in advance
Douglas (douglasl at synaq dot com) 29 May 2006 12:11:16 Hi,
Is it possible to set a config setting to calculate minutes from seconds? I would much prefer minutes than seconds.
Thanks
Doug
AlexF (alexf at trixan dot com) 25 May 2006 09:28:57 I am trying to execute http://192.168.0.188/queue_stats/log/logque.php
and receiving error:
Fatal error: Call to undefined function: pg_connect() in /var/www/html/queue_stats/log/config.inc.php on line 11
any ideas?
#cat ../log/config.inc.php
<?
//The rotated queue_log file must be here
$queue_log_dir = '/var/log/asterisk/';
ivan (support at asteriskguru dot com) 03 May 2006 13:42:26 Hello Aldo Leyva,
Can you send me both config.inc.php files (from the /log and /include directories).
Ivan
ivan (support at asteriskguru dot com) 03 May 2006 13:40:06 Hello,
Concerning the dynamic agents problem it will be fixed in some of the next releases.
Ivan
Aldo Leyva (aleyva2004 at gmail dot com) 27 April 2006 02:39:37 I installed Queue v0.10 with POSTGRESQL 8.0.3
I don't have error by connection!
I configured configs Files
I load data to tables postgresql
I get this message whe I load index.php
The database is empty!
Only have this message
Thanks for your answers
Ryan (ryan dot wyse at gmail dot com) 26 April 2006 09:54:34 I am having the same problem with dynamic agents, any word on how to fix this?
Omar (omarnina at gmail dot com) 12 April 2006 18:03:34 Hello Ivan,
I have installed again and again queue_stats.0.10 and everything goes ok, but the problem is with my dynamic Agents (agent/1001, agent/1102, etc). In the screen report all are like one. What could be?
PD. I also installed queue_stats.0.9 and the result is the same
:$
Naturalblue (adam at voicom dot ie) 12 April 2006 09:56:18 This looks like a great tool.
I wish to add it to my companies asterisk@home setup but as its postgresql i will have to put the database on a seperate machine (pity).
anyone know if theres any problem with doing this.
Also any further ago ahead on the MySQL port.
neilmc (neilmc at mdgp dot net dot au) 07 April 2006 04:56:47 Thanks Ivan!
Spot on. With my small amount of test data I only generated abandoned calls. Once I had a complete call in the db everything was fine :)
Great reporting tool!
Omar (omarnina at gmail dot com) 05 April 2006 15:53:19 Hi, Ivan
Thank you very much for your help.
Well, you were right. I disable SELinux for apache, and then it worked.
Here are the instruccions;
1. In the prompt
>system-config-securitylevel
2.The it opens a windows. Go to SELinux (tab) -> HTTPD Service -> Disable SELinux protection for httpd daemon (check this)
3. Reboot the computer
:)
Todd (todd at coalescentsystems dot ca) 03 April 2006 19:01:32 Hi. Just as neilmc reported, I'm having trouble when I try to drill-down, using one of the links (General, Agents, Date, Hour, etc). at the top of the page. The error I get is:
There is no data for the selected period and callgroup /,
The database is updating properly, the logque.php runs without error and is properly parsing the records and adding them to the database. I can select a date range, queues to display, etc. on the main queue stats page, and get an overview of the queue statistics (which is showing all the correct info). When I click on the one of the links at the top to drill-down, I'm taken back to the front page, with the above error.
Any ideas?
Thanks
Todd
(P.S. Keep up the great work!)
Omar (omarnina at gmail dot com) 03 April 2006 15:29:59 Hello Ivan,
Here are the answers to your questions
1. What is the destribution of your linux OS?
A. I have Linux Centos 4, with kernel 2.6.9-22
2. "mount"?
A.
/dev/hda1 on / type ext3 (rw)
none on /proc type proc (rw)
none on /sys type sysfs (rw)
none on /dev/pts type devpts (rw,gid=5,mode=620)
usbfs on /proc/bus/usb type usbfs (rw)
none on /dev/shm type tmpfs (rw)
/dev/hda2 on /opt type ext3 (rw)
/dev/hda3 on /usr/local type ext3 (rw)
none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)
3. "ls -la /var/"?
A.
total 164
drwxr-xr-x 20 root root 4096 Mar 7 08:56 .
drwxr-xr-x 24 root root 4096 Mar 14 10:15 ..
drwxr-xr-x 2 root root 4096 Mar 7 08:51 account
drwxr-xr-x 10 root root 4096 Mar 7 09:07 cache
drwxr-xr-x 3 netdump netdump 4096 Mar 7 08:51 crash
drwxr-xr-x 3 root root 4096 Mar 7 08:51 db
drwxr-xr-x 3 root root 4096 Mar 7 08:52 empty
drwxrwx--T 2 root gdm 4096 Mar 20 09:42 gdm
drwxr-xr-x 25 root root 4096 Mar 31 14:23 lib
drwxr-xr-x 2 root root 4096 Feb 21 2005 local
drwxrwxr-x 9 root lock 4096 Apr 3 04:02 lock
drwxr-xr-x 16 root root 4096 Apr 2 04:02 log
lrwxrwxrwx 1 root root 10 Mar 7 08:49 mail -> spool/mail
drwxr-xr-x 2 root root 4096 Feb 21 2005 nis
drwxr-xr-x 2 root root 4096 Feb 21 2005 opt
drwxr-xr-x 2 root root 4096 Feb 21 2005 preserve
drwxr-xr-x 15 root root 4096 Apr 2 08:37 run
drwxr-xr-x 17 root root 4096 Mar 7 09:47 spool
drwxrwxrwt 3 root root 4096 Apr 2 20:16 tmp
drwxr-xr-x 7 root root 4096 Jan 5 14:34 www
drwxr-xr-x 3 root root 4096 Mar 7 08:52 yp
6. Can you also provide the configuration files of your Apache and PHP?
A. I'll send you the configuration files to you email, please. They are to long
ivan (support at asteriskguru dot com) 03 April 2006 11:31:48 Hello neilmc,
You should have at least one call in the DB to see the stats. In the queue_log part below see no calls. Try to insert a completed call and try again.
Ivan
ivan (support at asteriskguru dot com) 03 April 2006 11:22:01 Hello blackgecko,
Do you insert any data to the db. First check the db settings for the config.inc.php files in /log and /include dirs. Then run the logque.php from the /log dir (this will fill up the db). Then run the site via web.
The translation can be send to support@asteriskguru.com
neilmc (neilmc at mdgp dot net dot au) 02 April 2006 10:54:18 Actually, it used to work but I think it stopped while using .09.
It's probably something on my system. I'll try connecting to the db and running the reports from another system and see if it works.
neilmc (neilmc at mdgp dot net dot au) 02 April 2006 05:33:12 Hi Ivan,
ver 0.10 fixed my log update probem. All stats now add to the db okay.
Now I'm getting "There is no data for the selected period and callgroup 26-03-2006/02-04-2006, All Queues"
This was after the following data was updated to the queue_stats table successfully
The following is the reply back from logque.php for the above lines
Checking file content, please wait. Reading line 1
(1). 1143948256|NONE|NONE|NONE|QUEUESTART|
(2). 1143948511|1143948503.0|1|NONE|ENTERQUEUE||202
(3). 1143948525|1143948503.0|1|NONE|ABANDON|1|1|14
The records above were added to the DB
I tried putting in a really wide date range and I got the same message.
I think it is picking up some of the data since the queue dropdown does allow me to select particular queues.
blackgecko (blackgecko at gmail dot com) 01 April 2006 04:17:00 Ive already installed, but when i access via web nothing happens, only a
The database is empty! legend appears int he page.
Any idea.
P.D. im working in translating it to spanish, were do i send it when i finish ???
ivan (support at asteriskguru dot com) 31 March 2006 16:21:59 Hello Omar,
According to the configuration you wrote about, everything seems to be ok. The logque.php finds the
directory described in the config.inc.php and there finds a queue_log file. It seems that Apache
has permissions to read the files inside the described dorectory but in fact it cannnot. The only
problem that I can think of is the you have a SELINUX enabled.
I will ask you for some thinks to find the problem.
What is the destribution of your linux OS?
Can you type in command line and give us the result for:
"mount"?
"ls -la /var/"?
"ls -la /var/log/"?
"ls -la /var/log/asterisk/"?
Can you also provide the configuration files of your Apache and PHP?
Regards, Ivan
ivan (support at asteriskguru dot com) 31 March 2006 16:21:26 Hello Ed,
Can you send me part of the queue_log file where the problem appears. It expects unixtimestamp (big integer) and receives string.
Ivan
ivan (support at asteriskguru dot com) 31 March 2006 16:21:00 Hello angonese,
Can you also try the new release 0.10 and if the problem is the same give me the last record from the queue_stats table of the DB and part of the queue_log file that cannot be inserted. Also the records that cannot be inserted in the DB should be newer than the last one in the DB.
Ivan
ivan (support at asteriskguru dot com) 31 March 2006 16:20:29 Hello Tom,
Now a new version release is available 0.10. Can you try it and if the problem persists could you please show me the last record in the DB and the records from the queue_log file that cannot be inserted.
Ivan
Omar (omarnina at gmail dot com) 30 March 2006 14:33:42 Hi Ivan,
Hello Ivan,
I installed again everything, and I have these:
And, again when I type in the url http://..../log/logque.php. I have the following error
The file /var/log/asterisk/queue_log (last modified on 1969-12-31 20:00:00) was found and considered valid.Error occurred, while trying to read the file
And the web server gives the following error;
[client 127.0.0.1] PHP Warning: filemtime(): Stat failed for /var/log/asterisk/queue_log (errno=13 - Permission denied) in /var/www/html/queue_stats.0.10/log/logque.php on line 41, referer: http://localhost/queue_stats.0.10/log/
[client 127.0.0.1] PHP Warning: fopen(/var/log/asterisk/queue_log): failed to open stream: Permission denied in /var/www/html/queue_stats.0.10/log/logque.php on line 107, referer: http://localhost/queue_stats.0.10/log/
Please, what is wrong?
:( :'(
Omar (omarnina at gmail dot com) 24 March 2006 17:18:51 Hi Ivan,
I installed postgre 7.4.8, php 4.3.9, zend optimizer 2.6.2 and asterisk 1.2.5, and everything seems ok, but when i use http://..../log/logque.php. I have the following error
The file /var/log/asterisk/queue_log (last modified on 1969-12-31 20:00:00) was found and considered valid.Error occured, while trying to read the file
Pd. to create de database I wrote like this
CREATE DATABASE db_name
WITH OWNER = username
ENCODING = 'SQL_ASCII';
and I didn't wrote TABLESPACE = pg_default, because postgre 7.4.8 doesn't support it
Thank you, I hope you help, please
Omar (omarnina at gmail dot com) 23 March 2006 18:27:39 Hi all,
It is necessary to install jpGraph ?
I installed postgre, php, zend optimizer and asterisk, and everything seems ok, but when i use http://..../log/logque.php. I have the following error
The file /var/log/asterisk/queue_log (last modified on 1969-12-31 20:00:00) was found and considered valid.Error occured, while trying to read the file
Ed (eengelking at printfulfillmentservices dot com) 23 March 2006 15:04:02 I'm seeing the following when trying to run the logque.php file:
The file /var/log/asterisk/queue_log (last modified on 2006-03-23 08:53:45) was found and considered valid.
Checking file content, please wait. Reading line 1
Warning: gmdate() expects parameter 2 to be long, string given in /usr/local/www/data-dist/queues/log/logque.php on line 135
The line with the gmdate() warning seems to be preventing the file from dumping the data in the queue_log file to the database. Using PHP 5.1.2_1 on FreeBSD 6.
Has anyone else had this problem or know of a fix? Google hasn't exactly been much help with the gmdate() info. :)
angonese (angonese at via-rs dot net) 22 March 2006 19:12:26 Same problem as Tom Silver, after running logque.php:
The file /var/log/asterisk/queue_log (last modified on 2006-03-22 14:34:03) was found and considered valid.
Checking file content, please wait. Reading line 1
Wrong parameters or empty line
Wrong parameters or empty line
Wrong parameters or empty line
Wrong parameters or empty line
Wrong parameters or empty line
The records above were added to the DB
Where ist the problem ? [I don't know :-( ]
Thank you for any tip|advice.
sergio (snemiro at hotmail dot com) 17 March 2006 23:03:59 hi... now is working ok....I just drop and recreate de dB.
regards,
s
neilmc (neilmc at mdgp dot net dot au) 17 March 2006 22:53:26 Thanks for the update Ivan. I'll check out the next version.
Sergio (snemiro at hotmail dot com) 17 March 2006 21:35:50 Hi... need some help....
All the instalation seems to be fine, but when I run the http://.........../queue_stats.0.9/log/logque.php it says:
Database filler
The file /var/log/asterisk/queue_log.5 (last modified on 2006-02-12 04:10:04) was found and considered valid.
Checking file content, please wait. Reading line 1
Checking file content, please wait. Reading line 101
Checking file content, please wait. Reading line 201
Checking file content, please wait. Reading line 301
Checking file content, please wait. Reading line 401
No records were added to the DB. The reason is empty file or that file content is old or already inserted in the DB.
from queue_log.1 (last modified on 2006-03-16 21:33:35)
Gaijin_khan (gaijin_khan at hotmail dot com) 15 March 2006 15:01:17 one thing to note with not being able to add data in twice:
If you delete the DB in postgres and recreate it you can then add more data.
again you only get one shot and at that only one log file! (if you have two log files with data it will only import from the oldest)
ivan (support at asteriskguru dot com) 15 March 2006 11:01:51 Hello Darek,
The problem with the log file might be that either the modification date of the file you are trying to import is older than the last record in the db or all the records from the file are older than the last record in the db.
You say that you have some activity after the last record in the DB, so check you your version (latest release is 0.9 with a timezone bugfix). If you find again some thing wrong you can send small part of the queue_log file that cannot be imported and the timestamp of the last call in the DB.
Ivan
ivan (support at asteriskguru dot com) 15 March 2006 10:53:40 Hello Gaijin_khan,
All timezones you requested will be included in the new release which will come out in a few days.
Ivan
gaijin_khan (gaijin_khan at hotmail dot com) 15 March 2006 09:39:28 http://forums.whirlpool.net.au/forum-replies.cfm?t=487687
I am having this also.
Darek (darek at vpn dot pl) 13 March 2006 16:40:01 When you run the WEB PAGE that loads the data for the first time all DATA is loaded into the DATABASE just fine and I can run reports but when I'm trying to load the DATA second time , it says it :
No records were added to the DB. The reason is empty file or that file content is old or already inserted in the DB.
I now thah the last record in database is at 2006-03-13 15:06:53+01 and I have got connection at 2006-03-13 16:25:08.
Gaijin_khan (gaijin_khan at hotmail dot com) 12 March 2006 17:50:29 Feature request:
Any chance of having a +9.5 ACST and a +10.5 DACST for us South Australians?
Great product, thanks guys!
ivan (support at asteriskguru dot com) 09 March 2006 10:05:45 Hello nilli,
Can you send me small part of the queue_log file where the problem appears. Does this error appears for each line further on or just for some. Check your postgres version and settings. Check your config.inc.php settings in the /log and /include dirs.
Ivan
ivan (support at asteriskguru dot com) 09 March 2006 09:57:28 Hello Omar,
Just download the new version from the site and try again. Or just create the sequence that the database says is missing.
Ivan
nilli (nilli77 at gmx dot de) 07 March 2006 19:14:38 Hello,
while importing the data I get the following error:
The file /var/log/asterisk/queue_log was found and considered valid.
Checking file content, please wait. Reading line 1
1.1141751547|NONE|NONE|NONE|CONFIGRELOAD|
Warning: pg_query(): Query failed: ERROR: syntax error at or near "," at character 148 in /var/www/html/stats/log/logque.php on line 255
Wrong parameters
Warning: pg_query(): Query failed: ERROR: syntax error at or near "," at character 148 in /var/www/html/stats/log/logque.php on line 255
Wrong parameters
The records above were added to the DB
Any ideas? Please help :-))
Thanks
Omar (omarnina at gmail dot com) 01 March 2006 22:34:01 Hello again,
The last problem was solved downloading again queue_stats.0.8.
the new problem is when I try to create te table queue_stats with the file db.sql, it gives me the following error
ERROR: relation "queues_stats_queue_stats_sid_seq" does not exist
Omar (omarnina at gmail dot com) 01 March 2006 22:31:46 Hello again,
The last problem was solved downloading again queue_stats.0.8.
the new problem is when I try to create te table queue_stats with the file db.sql, it gives me the following error
ERROR: relation "queues_stats_queue_stats_sid_seq" does not exist
Omar (omarnina at gmail dot com) 01 March 2006 21:49:29 I have apache 2.2.0, php 4.4.1 and I think that zend is installed correctly because when I use phpinfo(); I have the following
This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies with Zend Extension Manager v1.0.9, Copyright (c) 2003-2006, by Zend Technologies with Zend Optimizer v2.6.2, Copyright (c) 1998-2006, by Zend Technologies
I create the databese queues, and the tables. But when I try to use index.php I have the following error
Fatal error: Unable to read 2980 bytes in /opt/lampp/htdocs/queue_stats/public/menu_home.php on line 0
Please help?
Lokesh Kumar (lokesh at interacesso dot pt) 27 January 2006 20:49:14 Hello List,
After weeks of strruggle with queue stats..I gots working it. But not without any problem.It is having wierd problem.When I run ....log/logque.php file it gives me error like:-
Query failed: ERROR: syntax error at or near "," at character 149 in /var/www/html/queue_stats.0.7/log/logque.php on line 249
Second wierd problem. I am getting duplicate entries under menu_details.php, when i clicks on
http://212.13.35.253/queue_stats.0.7/public/menu_details.php
It shows me too many entries duplicated.How it can be solved.
When I delete the last two entries from the logque.php file,then I am not getting error while executing .../log/logque.php file. but the duplicate entry remains there.
Please help.
Thanks a lot
Lokesh
Portugal
Dave Purks (dpurks at cogentco dot com) 26 January 2006 21:55:36 In case anyone else had the problem I detailed previously with missing sequence in db.sql, here's the missing line:
create sequence queue_stats_queue_stats_sid_seq increment 1 no minvalue no maxvalue no cycle;
I've now got a database and all the required software installed. However, when I run logque.php I get:
Database filler
The file /opt/apache/htdocs/queue_stats/data/queue_log was found and considered valid
Checking file content, please wait Reading line 1
Wrong parameters
Wrong parameters
Wrong parameters
over and over and over and over.....
The records above were added to the DB
When I then try to execute index.php:
The database is empty!
Help!!!
Mark Quitoriano (markquitoriano at gmail dot com) 24 January 2006 22:47:58 ok got it. hehe.. make sure your /var/lib/php/session groupid is the same user in your apache.
:) mine is set to asterisk
Mark Quitoriano (markquitoriano at gmail dot com) 24 January 2006 22:42:17 Hi im getting this when im viewing other option except general
There is no data for the selected period and callgroup /,
im using centos 4.2 with httpd-2.0.52-22, php-4.3.9-3.9 and postgresql-7.4.8
Kresimir (omadon at globalnet dot hr) 07 January 2006 19:07:56 Where can I download source. I would like to chnage some of the code (Answer time, I need 1, 2, 5 minutes interval not only seconds), plus i have some problem and with logque.php. When I rotate logs I get duplicate values in menu_details.php.
all things that I add I'll give back, if you need it of course...
I would also like to make translation to croatian...
ivan (support at asteriskguru dot com) 06 January 2006 08:24:19 Hello Lokesh,
First check your logger.conf file /etc/asterisk. In the [logfiles] part you must have a line like this:
queue_log =>
This way the data from the queue will be stored in a log file in /var/log/asterisk.
Afterwards set config.inc.php and run logque.php (in log directory of your queue_stats).
If you have all the other programs (ex. Zend Optimizer) the web interface shoud be working. For problems further on write again.
Lokesh Kumar (lokesh at interacesso dot pt) 05 January 2006 16:16:06 I am havng problems with queue_stats. I had installed postgre sql and its database with tables successfully. But the problem is asterisk is not making queue_log.x files, as mentioned in the tutorial. I had restarted asterisk lots of times with logger rotate command in asterisk CLI,but it didn't worked. The files in /var/log/asterisk are like this..
[client 192.168.0.47] script '/var/www/html/queue_stats.0.7/public/log_queue.php' not found or unable to stat
[client 192.168.0.47] script '/var/www/html/queue_stats.0.7/public/log_que.php' not found or unable to stat
[client 192.168.0.47] script '/var/www/html/queue_stats.0.7/public/log_que.php' not found or unable to stat
[client 192.168.0.47] script '/var/www/html/queue_stats.0.7/log_que.php' not found or unable to stat
[client 192.168.0.47] script '/var/www/html/queue_stats.0.7/log_queue.php' not found or unable to stat
[Thu Jan 05 14:27:38 2006] [error] [client 212.13.42.65] Directory index forbidden by rule: /var/www/html/
[Thu Jan 05 14:27:39 2006] [error] [client 212.13.42.65] File does not exist: /var/www/html/favicon.ico
[Thu Jan 05 14:27:55 2006] [error] [client 212.13.42.65] File does not exist: /var/www/html/queue_stats.o.7
[client 192.168.0.47] script '/var/www/html/queue_stats.0.7/log_queue.php' not found or unable to stat
[client 192.168.0.47] script '/var/www/html/queue_stats.0.7/log_queue.php' not found or unable to stat
. I don't know which part is broken. Is queue_stats.0.7 version supports mysql.
log_que.php is present but there is no files named log_queue.php in queue_stats directory
Any help will be much appreciated.
Regards
Lokesh
lokeshatinteracesso.pt
Felix Deierlein (fd at epyron dot de) 03 January 2006 10:02:55 Hello,
while importing the data I get the following error:
8.1136278438|NONE|NONE|2253|AGENTCALLBACKLOGOFF|53@eP-In|66129|CommandLogoff
Warning: pg_query(): Query failed: ERROR: syntax error at or near "," at character 150 . in /srv/www/htdocs/stats/queue/log/logque.php on line 249
Wrong parameters
The records above were added to the DB
Any ideas?
Thanks
Felix
Wei (wcjiang at yahoo dot com) 02 January 2006 21:18:24 Looks like it always displays the time in EST (when I look under "Hour" , for example). Is it possible to set this to a local time?
Mimmus (viggiani at hotmail dot com) 02 January 2006 17:34:21 Under Red Hat, install php-pgsql too!
ivan (support at asteriskguru dot com) 20 December 2005 15:07:38 Hello Kong
What version of php and apache do you use. Do they meet the requirements subscribed in the tutorial.
The possible problem might be that you the session variables are disabled in the php settings or the cookies in your browser are disabled .
kong (kongzs at irepublics dot com) 20 December 2005 04:17:49 under menu general, there is data shown. once i click on other links like date, hour, details, it shows below.
There is no data for the selected period and callgroup /,
D Purks (dpurks at cogentco dot com) 16 December 2005 14:09:29 When I attempt to run the db.sql commands to set the database up, I get the following error:
ERROR: relation "queue_stats_queue_stats_sid_seq" does not exist
any ideas?
Thanks!
Rizwan (rizwan at gnspk dot com) 10 December 2005 11:09:02 New Queue Statistics version 0.7 is released
When we will see Installation guide of new release
I hope new version is supporting mysql
ivan (support at asteriskguru dot com) 09 December 2005 08:41:34 Hello Wei,
check the settings of your 'config.inc.php' file in directory 'include'. There you have to choose the operating system by commenting the one you are not going to use :
$os = "linux";
#$os = "windows";
This way your OS will be linux and the script will save the report images in '/tmp'. If you want to change the file just type the correct path and assign as value for the variable $image_path_lin in the same file.
Wei (wcjiang at yahoo dot com) 04 December 2005 21:19:15 When I clicked on View Report I got an error "Can't create or stream image to file C:/qimages/Answered ..." I installed this in Linux, why would it try to write to a C drive?! This is not defined in the jpg-config.inc file either, where can I change the path?
Wei (wcjiang at yahoo dot com) 04 December 2005 08:05:34 Hi,
Is it possible to use this without the MS fonts? I've spent hours trying to figure out how to install these fonts in Linux. Can the font family be changed to the Vera Bitstream TTF fonts? Thank you!
Ed Cross (ecross at 41cash dot com) 22 November 2005 17:06:28 any chance I can get the source code? I want to customize the application for our uses...
afridi (muwahhad at hotmail dot com) 26 October 2005 23:45:53 One last question! any chance I can get the source code as I want to customise the application?
afridi (muwahhad at hotmail dot com) 26 October 2005 21:09:13 ok! got it! thanks guys!
afridi (muwahhad at hotmail dot com) 26 October 2005 20:31:52 hi,
thanks for your help.
There is one problem however! On the server, where I have asterisk installed I do not have apache and php installed. So i will have to install that for the log thing to work.
Is there a way i can have the log and the queue thing on a totally seperate server? I want to do this mainly for testing purposes.
So basically I will take a copy from the asterisk server of the queue_log file and I want to place it on the other server where the application is installed.
Is this possible?
ivan tsankov (support at asteriskguru dot com) 26 October 2005 18:28:23 Hello Afridi, the answer of your question is YES it is possible. So what you have to do is to place the log directory on the server where is you asterisk with the log files. Then you can have the stats on different pc . You have just to set the config files on both the log part and the main part of the application pointing to the same database. This way the log part will find the queue_log files and will put the records to the database. The rest of the application will take the data from the DB - and show you the stats.
afridi (muwahhad at hotmail dot com) 26 October 2005 18:23:26 Ok I got the answer to that!
But I am still unsure as to how correctly specify the path. Lets say I have put the queue_log file in the directory /stats/log. How do i specify it in the config.inc.php file?
afridi (muwahhad at hotmail dot com) 26 October 2005 17:51:03 Hi guys,
After a lot of effort I have managed to get the application up and running on my local pc.
However the problem is I dont have asterisk running on the same machine. So all the tables are empty and there is no data.
Do I have to install this application on the same server thats running the asterisk server? Is it not possible to have this application on a seperate server, specify the path for the queue_log file and run it like that?
Another question I wanted to ask was is it possible to get the source code so that i am able to make some customisations and/or add extra features?
Ueberspasti (ueberspasti at gmail dot com) 19 October 2005 09:51:20 Hi..
I need to change the "Answer Time" under "General" to other values, can anyone tell my how?
Thx
ueberspasti
terchris (terchris at hotmail dot com) 19 October 2005 07:06:47 Hi
I hope someone can port it to mysql so that it can be included in Asterisk@Home. See http://sourceforge.net/forum/forum.php?thread_id=1367049&forum_id=420323
regards
terchris
Fernando Patzlaff (patzlaff at via-rs dot net) 07 October 2005 20:08:24 I have one register on the queue_log. When I execute the log_queue.php the following message appears at the browser:
The file /var/log/asterisk/queue_log was found and concerned valid.
Checking file content, please wait. Reading line 1
1.1126200250|1126200236.23|adm|Agent/53470|COMPLETEAGENT|8|6
The records above were added to the DB
But when I look at the postgres doesn't exist this register.
Anyone have a idea?
Fernando Patzlaff
Fernando Patzlaff (patzlaff at via-rs dot net) 07 October 2005 19:55:28 I like know what I need to do for the application put the informations on the queue_log to postgree.
When I execute the logque.php the following error occurs at the error_log (apache):
[Fri Oct 7 14:24:22 2005] [error] PHP Warning: pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: permission denied for sequence qname_qname_sid_seq in /usr/local/apache/htdocs/queue/log/logque.php on line 176
[Fri Oct 7 14:24:22 2005] [error] PHP Warning: pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: permission denied for sequence qagent_qagent_sid_seq in /usr/local/apache/htdocs/queue/log/logque.php on line 210
[Fri Oct 7 14:24:22 2005] [error] PHP Notice: Undefined variable: qname_id in /usr/local/apache/htdocs/queue/log/logque.php on line 240
[Fri Oct 7 14:24:22 2005] [error] PHP Notice: Undefined offset: 6 in /usr/local/apache/htdocs/queue/log/logque.php on line 240
[Fri Oct 7 14:24:22 2005] [error] PHP Notice: Undefined offset: 7 in /usr/local/apache/htdocs/queue/log/logque.php on line 240
[Fri Oct 7 14:24:22 2005] [error] PHP Warning: pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: syntax error at or near "," at character 152 in /usr/local/apache/htdocs/queue/log/logque.php on line 241
[Fri Oct 7 14:24:22 2005] [error] PHP Notice: Undefined offset: 3 in /usr/local/apache/htdocs/queue/log/logque.php on line 141
[Fri Oct 7 14:24:22 2005] [error] PHP Notice: Undefined offset: 3 in /usr/local/apache/htdocs/queue/log/logque.php on line 142
My plataform:
-------------
Linux / Fecora Core 4
Asterisk 1.0.9
PostgreSQL 7.4.8-1
PHP 5.0.5
Anyone have any idea ?
Thanks,
Fernando Patzlaff
Nenad (nenadr at deltaplan dot co dot yu) 30 September 2005 21:49:23 Any news on MySQL support ? If not, I'm interested to try to port it from Postgresql to MySQL !
zoa (support at asteriskguru dot com) 30 September 2005 16:37:04 We plan on adding support for mysql in one of the next versions. (looking for a sponsor :)
Zoa.
Felix Deierlein (fd at epyron dot de) 30 September 2005 14:00:55 Hi,
could I also use the software with MySQL?
Regards
Felix
Luis Sierra (fernando dot sierra at bigfoot dot com) 29 September 2005 17:37:04 Thanks Ivan, I Upgrade to PHP 4.4.0 and works. I had some problems with PHP but finallly I can install it. Only the "Date" link shows an error:
Fatal error: Unable to read 3740 bytes in /var/www/html/webroot/testtest/public/asteriskguru/v.0.5/public/menu_date.php on line 0.
What's wrong?
Ivan (support at asteriskguru dot com) 16 September 2005 11:52:21 Luis, check you php first the required version is 4.3.5 or higher. Check you queue_stats directory structure. Try with another browser. If same problem download the tool again and if the problem continues write us again. I think is the main problem are the settings of your php.
Check out the things above and tell us the result
Ivan
Luis Sierra (fernando dot sierra at bigfoot dot com) 15 September 2005 20:32:36 Hi, I´m new in this, I'am trying to view the index.php but I received next error message:
Fatal error: Maximum execution time of 60 seconds exceeded in /var/www/html/queue_stats.0.5/webroot/testtest/public/asteriskguru/v.0.5/index.php on line 3
My plataform is:
Apache/2.0.46 (CentOS 2.4.21-32.ELsmp)
PHP Version 4.3.2
Zend Optimizer v2.5.0
postgresql-8.0.3
Where is the problem? Why take too much time?
Thanks!
Fabian (ftorres at millenium dot com dot co) 13 September 2005 19:39:02 Me gustaria saber como hago para cargar los datos en la base de datos. Si es automatico o hay que configurar algun archivo manual... Gracias..
Cliff Larson (larsonc at att dot net) 14 August 2005 16:44:32 It appears that their is either a BUG or an ISSUE with program. When you run the WEB PAGE that loads the data for the first time all DATA is loaded into the DATABASE just fine and you can run reports. When you tell Asterisk to ROTATE LOGS, it does it, but when you run the WEB PAGE to load the DATA, it says it :
Found Valid file to process - queue_log.2 but does not process any of the DATA.
I have tried this on 3 differnt systems with POSTGRESQL 8.0. The DATA is good from each QUEUE_LOG file as each time if I wipe out the DATABASE and recreate it, the new QUEUE_LOG file will load just fine.
Any help would be great. I have both PHP 4 and 5 loaded on various machines, I have Mandrake, SUSE and REDHAT OS's...
Thanks,
Cliff
Gabriel (gabrielbersano at uolsinectis dot com dot ar) 10 August 2005 22:30:17 Hi, I'm trying the "Queue Statistics" application. When I execute logque.php, it shows the following error: Found Valid file to
process - queue_log.1 Error occured
What's wrong ?
My plataform:
-------------
Linux / Fecora Core 4
Asterisk 1.0.8
PostgreSQL 8.0.3-1
PHP 5.0.4