[OpenSIPS-Devel] No records in CDR table

Vlad Paiu vladpaiu at opensips.org
Mon Jul 7 11:56:53 CEST 2014


Hello,

What OpenSIPS version are you using ?

Are you using the CDR account within OpenSIPS ( which generates a single 
CDR entry per call ), or the old type of accounting ( which uses a MySQL 
stored procedure to merge the two INVITE & BYE entries per call ) ?

I see the 1704 entry is a full CDR, with duration, setuptime and created 
fields populated.

Best Regards,

Vlad Paiu
OpenSIPS Developer
http://www.opensips-solutions.com

On 04.07.2014 13:48, Maqbul Khan - Reform InfoTech wrote:
> Hello,
>
> I am having issue with OpenSIPS does not populate any CDRs in CDR 
> table.  I could see records with limited fields in ACC table.  Here is 
> an example of ACC table.  Can anyone help me make CDR table working 
> please?
>
> mysql> select * from acc order by Id desc limit 0,10;
> +------+--------+----------------------------------+----------------------------------+----------------------------------+----------+------------+---------------------+--------+----------+-----------+---------------------+
> | id   | method | from_tag                         | to_tag           
>             | callid                           | sip_code | sip_reason 
> | time                | cdr_id | duration | setuptime | created       
>       |
> +------+--------+----------------------------------+----------------------------------+----------------------------------+----------+------------+---------------------+--------+----------+-----------+---------------------+
> | 1705 | BYE    | caAP1nQWLr69ppVbHAOzQB3N7tUg6LFe | 9726134b         
>               | NTw0aWGotkTFiWkbnRVAgWBLpLoHQco6 | 200      | OK       
>   | 2014-07-01 09:15:33 |      0 | 0 |         0 | NULL                |
> | 1704 | INVITE | caAP1nQWLr69ppVbHAOzQB3N7tUg6LFe | 9726134b         
>               | NTw0aWGotkTFiWkbnRVAgWBLpLoHQco6 | 200      | OK       
>   | 2014-07-01 09:15:16 |      0 | 16 |         3 | 2014-07-01 09:15:13 |
> | 1703 | BYE    |
>
> Maqbul A Khan
>
>
>
> _______________________________________________
> Devel mailing list
> Devel at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/devel

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/devel/attachments/20140707/7d9648c2/attachment.htm>


More information about the Devel mailing list