[OpenSIPS-Users] OpenSIPS 3.2 + MySQL - do_accounting()

[Saint Michael]

In my case, Opensips is losing 30% of CDR, but there is no error.
At routing time I create a CDR record based on SIP callID, and Opensips is
supposed to "close" it when the call drops by executing a stored procedure
from the place when the call is finished. It does not in 30% of cases. I
started doing this because my carrier was showing a lot more than I did in
minutes. The CDR written to disk the traditional way also shows no record
of so many calls. In 541000 calls I have no accounting for 80.000.
nightmare.
Any idea what can it be?
Vlad is my advisor, please copy him on the information.


On Tue, Mar 1, 2022 at 9:31 AM Bogdan-Andrei Iancu <bogdan at opensips.org>
wrote:

> Hi Eugen,
>
> What is the capture of the call that produced that CDR ? Can you
> reproduce it ?
>
> Regards,
>
> Bogdan-Andrei Iancu
>
> OpenSIPS Founder and Developer
>    https://www.opensips-solutions.com
> OpenSIPS eBootcamp
>    https://www.opensips.org/Training/Bootcamp
>
> On 2/23/22 11:21 PM, Eugen Prieb via Users wrote:
> > Hello,
> >
> > I will collect all CDRs, also failled, in DB.
> >
> > I see in log follow message:
> > Feb 23 21:58:33 opensips-32 /sbin/opensips[2623292]:
> > CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error
> > (1048): Column 'to_tag' cannot be null
> >
> > As MySQL is MariaDB 10.5.12 installed. Have you any idee?
> >
> >
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20220301/c6efccad/attachment.html>