g613 / asterisk-cdr-viewer Goto Github PK

What steps will reproduce the problem?
1. Select only Concurrent Calls
2. Select 1 month or more for Call dates
3. Run the report and it takes for ever and won't come back with report.

What is the expected output? What do you see instead?
It should show concurrent calls for whole month with MAX Calls showing

What version of the product are you using? On what operating system?
Latest 0.9x

Please provide any additional information below.

What steps will reproduce the problem?
1. WAV location /var/spool/asterisk/monitor and /Year/mounth/Day. How is set 
this config ?

Is it possible to add the column "billsec" to the report?

Hello, I added the rate_type type 30s+s this way:

functions.inc.php > add >

} elseif ( $callrate_cache[$file][substr($dst,0,$i)][2] == '30s+s' ) {
// 30 second + per second
if ( $duration < 30) {
$call_rate = ($callrate_cache[$file][substr($dst,0,$i)][0] / 2);
} else {
$call_rate = $callrate_cache[$file][substr($dst,0,$i)][0] + ( ($duration-60) * 
($callrate_cache[$file][substr($dst,0,$i)][0] / 60) );
}

And I need to add rate_type 30s+6s to use Skype.

Could someone help, please?

What steps will reproduce the problem?
1. Simulate a call into asterisk with CID NAME (e.g. "John Smith" <4145556666>
2. Check Reports and it will show 4145556666 but not John Smith
3. Checking /var/log/asterisk/full I can see "John Smith" and it's also in 
asteriskcdrdb in MySQL.

What is the expected output? What do you see instead?
CDR Report should view both CID Name and CLID for all Dahdi, SIP, IAX, and 
other technology trunks.

What version of the product are you using? On what operating system?
Latest

Please provide any additional information below.

[Fri Jun 30 09:06:14.831624 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: startmonth in /var/www/html/cdr/templates/form.tpl.php on line 23
[Fri Jun 30 09:06:14.831630 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: startmonth in /var/www/html/cdr/templates/form.tpl.php on line 23
[Fri Jun 30 09:06:14.831633 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: startmonth in /var/www/html/cdr/templates/form.tpl.php on line 23
[Fri Jun 30 09:06:14.831636 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: startmonth in /var/www/html/cdr/templates/form.tpl.php on line 23
[Fri Jun 30 09:06:14.831643 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: startmonth in /var/www/html/cdr/templates/form.tpl.php on line 23
[Fri Jun 30 09:06:14.831646 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: startmonth in /var/www/html/cdr/templates/form.tpl.php on line 23
[Fri Jun 30 09:06:14.831649 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: startmonth in /var/www/html/cdr/templates/form.tpl.php on line 23
[Fri Jun 30 09:06:14.831652 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: startmonth in /var/www/html/cdr/templates/form.tpl.php on line 23
[Fri Jun 30 09:06:14.831655 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: startmonth in /var/www/html/cdr/templates/form.tpl.php on line 23
[Fri Jun 30 09:06:14.831658 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: startmonth in /var/www/html/cdr/templates/form.tpl.php on line 23
[Fri Jun 30 09:06:14.831661 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: startmonth in /var/www/html/cdr/templates/form.tpl.php on line 23
[Fri Jun 30 09:06:14.831696 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endmonth in /var/www/html/cdr/templates/form.tpl.php on line 50
[Fri Jun 30 09:06:14.831700 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endmonth in /var/www/html/cdr/templates/form.tpl.php on line 50
[Fri Jun 30 09:06:14.831703 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endmonth in /var/www/html/cdr/templates/form.tpl.php on line 50
[Fri Jun 30 09:06:14.831706 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endmonth in /var/www/html/cdr/templates/form.tpl.php on line 50
[Fri Jun 30 09:06:14.831708 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endmonth in /var/www/html/cdr/templates/form.tpl.php on line 50
[Fri Jun 30 09:06:14.831711 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endmonth in /var/www/html/cdr/templates/form.tpl.php on line 50
[Fri Jun 30 09:06:14.831714 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endmonth in /var/www/html/cdr/templates/form.tpl.php on line 50
[Fri Jun 30 09:06:14.831717 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endmonth in /var/www/html/cdr/templates/form.tpl.php on line 50
[Fri Jun 30 09:06:14.831720 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endmonth in /var/www/html/cdr/templates/form.tpl.php on line 50
[Fri Jun 30 09:06:14.831722 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endmonth in /var/www/html/cdr/templates/form.tpl.php on line 50
[Fri Jun 30 09:06:14.831725 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endmonth in /var/www/html/cdr/templates/form.tpl.php on line 50
[Fri Jun 30 09:06:14.831733 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endmonth in /var/www/html/cdr/templates/form.tpl.php on line 50
[Fri Jun 30 09:06:15.537964 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: startmonth in /var/www/html/cdr/index.php on line 23
[Fri Jun 30 09:06:15.538014 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: startyear in /var/www/html/cdr/index.php on line 24
[Fri Jun 30 09:06:15.538030 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: startday in /var/www/html/cdr/index.php on line 26
[Fri Jun 30 09:06:15.538039 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: starthour in /var/www/html/cdr/index.php on line 33
[Fri Jun 30 09:06:15.538046 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: startmin in /var/www/html/cdr/index.php on line 34
[Fri Jun 30 09:06:15.538068 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endmonth in /var/www/html/cdr/index.php on line 39
[Fri Jun 30 09:06:15.538080 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endyear in /var/www/html/cdr/index.php on line 40
[Fri Jun 30 09:06:15.538091 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endday in /var/www/html/cdr/index.php on line 42
[Fri Jun 30 09:06:15.538120 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endhour in /var/www/html/cdr/index.php on line 47
[Fri Jun 30 09:06:15.538128 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: endmin in /var/www/html/cdr/index.php on line 48
[Fri Jun 30 09:06:15.538145 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: src in /var/www/html/cdr/index.php on line 56
[Fri Jun 30 09:06:15.538153 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: dst in /var/www/html/cdr/index.php on line 62
[Fri Jun 30 09:06:15.538159 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: did in /var/www/html/cdr/index.php on line 68
[Fri Jun 30 09:06:15.538168 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: channel in /var/www/html/cdr/index.php on line 75
[Fri Jun 30 09:06:15.538184 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: clid in /var/www/html/cdr/index.php on line 81
[Fri Jun 30 09:06:15.538194 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: dstchannel in /var/www/html/cdr/index.php on line 84
[Fri Jun 30 09:06:15.538207 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: userfield in /var/www/html/cdr/index.php on line 93
[Fri Jun 30 09:06:15.538216 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: accountcode in /var/www/html/cdr/index.php on line 96
[Fri Jun 30 09:06:15.538225 2017] [:error] [pid 7526] [client 10.13.13.11:53184] PHP Notice:  Undefined index: limit in /var/www/html/cdr/index.php on line 99

This message is writen in Spanish, so if you have problems understanding the 
content, use a traductor.

Para usar esta aplicacion con postgres hice unos pequeños cambios. En primer 
lugar la función que se debe crear en la base de datos debe ser 

CREATE FUNCTION unix_timestamp(TIMESTAMP) RETURNS INTEGER AS '
SELECT date_part(''epoch'', $1)::INTEGER AS RESULT
' LANGUAGE sql;

Para alguien que no sepa, le puede parecer un dolor de cabeza meter la 
instrucción en el motor de base de datos y que no le funcione, porque le sobra 
el CREATE FUNCTION.

Otra cosa que hay que tener en cuenta es que en el config.inc.php en vez de la 
opción mysql, se debe usar pgsql (igual para el que no sabe, el que maneja PDO 
no tiene problema).

Y por ultimo para evitar problemas en la ejecución de las consultas a la base 
de datos, se debe quitar la variable $db_name de todas ellas.

Supongo que ya con eso es suficiente. No es un problema en si, sino la 
solución a lo que encontré.

Best Regards and THX for your effort. :D

is possible to use mysql for data off call rates? instead .csv?

Thanks

Hi.
Do you plan to support Postgresql, not only mysql cdr?

I am connected to a freepbx distro server on my local network, All is working 
fine but I cannot figure out how to show the recorded files, they are in the 
freepbx default location and I can see them using there built in cdr viewer but 
not on this software, I looked at config.inc.php buy could not figure out how 
to make this work, any help would be great.

Gary.

Call cost rounding up.
I need assistance with custom development on the interface but the email for 
igor does not work

What steps will reproduce the problem?
> 1. Just run search with date and time intervals

What is the expected output? What do you see instead?
> Calls record between "time from" and "time to", but a got out of selected 
time call record

What version of the product are you using? On what operating system?
> actually 1.0.2, but footer still show 1.0.1 :))

See the screenshot

Hi.
Do you plan to support translations for your product (in example .po files)?
I know I can edit the code, but it is the wrong way :)

If you will add translation support, I suggest my help with translate your 
product to Russian and Ukrainian languages.

template/footer.tpl.php:

templates/footer.tpl.php:   <a 
href="http://code.google.com/p/asterisk-cdr-viewer/">Asterisk CDR viewer ( 
v.1.0.1 )</a>

It should be v.1.0.2

"service httpd restart" instead of "service restart httpd"

We use the DID field to note which DID a call comes in on.  Would it be 
possible to add this to the report and possibly be able to search by this field?

running version 0.9.5

Thanks,
David

On main page see PDO::errorInfo(): could not find driver

config.inc.php

$db_type = 'mysql';
$db_host = 'localhost';
$db_port = '3306';
$db_user = 'root';
$db_pass = 'XEGFxegC66';
$db_name = 'asterisk';
$db_table_name = 'cdr';

What steps will reproduce the problem?
1.install software 
2.verify data is in cdr table (cdr records, filename, files in monitor dir////0 
3.run report, no file download icon appears 

What is the expected output? What do you see instead?

to be able to download the monitor recording

What version of the product are you using? On what operating system?

latest

Please provide any additional information below.

could I email you and explain?  

After downloading Asterisk-cdr-viewer and modifying config.inc.php the 
Asterisk-cdr-viewer is not showing any data. 

What steps will reproduce the problem?
1. Load CDR
2. Seach CDR
3. No information about incoming Trunk - all shows only SIP or IAX2

What is the expected output? What do you see instead?
CDR should show which trunk was used. For example I have 5 SIP trunks to 
different providers and 2 IAX2 trunks to other two different providers. When a 
call comes in I only see SIP or IAX2 for source channel instead of VoipMS, 
Vitelity, TATA, etc....

What version of the product are you using? On what operating system?
1.0.1

Please provide any additional information below.

Need to add separate column for CallerID

What steps will reproduce the problem?
1. Pick an extension and see all calls for a particular day
2. Run the report
3.

What is the expected output? What do you see instead?
Was hoping to see all calls internal and external, but I onyl see internal calls

What version of the product are you using? On what operating system?
Latest version, trying to integrate with Trixbox 2.6 on CentOS 5.2

Please provide any additional information below.

What steps will reproduce the problem?
1. admin user can see every report. But Other user did not see the report. I 
want user based report. One peer did not see other peer cdr. How can i do it? 
please help
?????

When I try to connect to http://myip/acdr I got the following message:

You don't have permission to access /acdr/ on this server.

I believe it has something to do with permissions?

Not work the query with "_" the - sip/provider_my iax/74957374567_97.

I managed to get data in mysql cdr database.
But when I open the webbrowser (http://ipaddress/acdr/ I only see my php file 
and not the template (see attached picture).
What's going wrong?
I am using Debian so I had to copy cp 
asterisk-cdr-viewer/contrib/httpd/asterisk-cdr-viewer.conf to 
/etc/apache2/conf.d instead of /etc/httpd/conf.d/.
And I restarted apache2 instead of httpd 

What steps will reproduce the problem?
1. In asterisk 11 just search

What is the expected output? What do you see instead?
PDO::errorInfo(): Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 
'calldate' in 'where clause' )

What version of the product are you using? On what operating system?
1.0.4 , Centos 6.5

Please provide any additional information below.

I think that the new CDR Grab to MYSQL Is different , dont have calldate , is 
there a way yo make it work with asterisk 11 ? 

Would it be possible to implement see some quick date range buttons, like: 
- this week
- last 7 days
- this month
- last 28/30/31 days
- this year

Maybe even have them as a config option?

Best regards,
Siniša Bandin