artithw / asterisk-cdr-viewer Goto Github PK

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

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

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.

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 ? 

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 

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

Need to add separate column for CallerID

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

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.

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

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

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

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

Thanks

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

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.

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.

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.

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

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?

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

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

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
?????

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

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.