[OpenSIPS-Devel] No records in CDR table

Maqbul Khan - Reform InfoTech maqbul at reforminfotech.com
Tue Jul 8 08:19:21 CEST 2014


Hi Vlad,

I’m using 1.9 of OpenSIPS.  I’m not sure what I’m using.  By default there was no CDR table in the database, and all CDRs used to even now in ACC table only.  Later on i tried to create CDR table and import store procedure, but still it is not working.  How can I check what is in use?  How can I check if OpenSIPS is using single entry per call?

Maqbul A Khan

On 07-Jul-2014, at 3:26 pm, Vlad Paiu <vladpaiu at opensips.org> wrote:

> 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
> 
> _______________________________________________
> 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/20140708/a64a4323/attachment-0001.htm>


More information about the Devel mailing list