[nhjeffh]

Problem A)

When I run http://127.0.0.1/qstats/log/logque.php to populate DB, I get:

Database Fill Up - Queue Statistics Import


The file queue_log.3 (last modified on 31st Dec 1969 19:00:00) was found and considered valid.
Error occured, while trying to read the file

An ls -l of /var/log/asterisk/q* yields:
root@manzetti asterisk# ls -l q*
-rw-rw-r-- 1 asterisk asterisk 342697 Jul 24 20:04 queue_log
-rw-rw-r-- 1 asterisk asterisk 2893258 Jan 9 2007 queue_log.0
-rw-rw-r-- 1 asterisk asterisk 3441434 Mar 30 11:50 queue_log.1
-rw-rw-r-- 1 asterisk asterisk 3363532 May 29 07:44 queue_log.2
-rw-rw-r-- 1 asterisk asterisk 3759602 Jul 20 07:03 queue_log.3
root@manzetti asterisk#

1) Why is the PHP script getting the date wrong, and
2) Why doesn't populate the DB

Problem B)
When I run: http://127.0.0.1/qstats/log/cdr.php
No files like *.csv found in /var/log/asterisk/cdr-csv. Check the content of the specified log directory!

an ls -l of /var/log/asterisk/cdr-csv yields:
root@manzetti asterisk# ls -l /var/log/asterisk/cdr-csv
total 124152
-rw-rw-r-- 1 asterisk asterisk 126997894 Jul 24 20:05 Master.csv
root@manzetti asterisk#


Asterisk Version 1.2.9.1
queue_stats.0.3.0_php4
root@manzetti ~# php -v
PHP 4.3.9 (cgi) (built: May 10 2007 05:19:09)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
with Zend Extension Manager v1.2.0, Copyright (c) 2003-2007, by Zend Technologies
with Zend Optimizer v3.3.0, Copyright (c) 1998-2007, by Zend Technologies
root@manzetti ~#
root@manzetti ~# psql --version
psql (PostgreSQL) 7.4.17
contains support for command-line editing

root@manzetti include# cat /var/www/html/qstats/include/config.inc.php
<?php

$os = "linux";
$image_path_lin = "/tmp";
$default_language = "en";
$default_timezone = "-5";
$default_start_hour = "00";
$default_end_hour = "24";
$db_host = "127.0.0.1";
$db_name = "asterisk";
$db_user = "asterisk";
$db_pass = "xxxxxxxx";

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

?>

root@manzetti log# cat /var/www/html/qstats/log/config.inc.php
<?
// 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 = "asterisk";
$db_user = "asterisk";
$db_pass = "asterisk";

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


Any ideas or tips would be appreciated.

[nhjeffh]

Ignore Question B I have no accountcodes setup and the Documentation Clearly States that the Master.csv is ignored:

..."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."

[toetshax]

when i try to run http://server ip address/queuestats/log/logque.php

it gives me this error :


Warning: readdir(): supplied argument is not a valid Directory resource in /var/www/html/queuestats/log/logque.php on line 52

Warning: closedir(): supplied argument is not a valid Directory resource in /var/www/html/queuestats/log/logque.php on line 63

No files like queue_log* found in . Check the content of the specified log directory!

u have any clue????

[GSnover]

<?
// 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/';

This is the setting that works for me.

Greg