[OpenSIPS-Users] Write CDR to SYSLOG when mysql statement fail

[Mike Tesliuk]

you should write on both, you decide when generate the acc information
setting the flag, but i dont know if you can receive some variable with the
return of the query over the config file.

you can make your mysql better using failover , replication and everything
, you should fix your problem with your database not  on opensips


2013/10/11 Wilmar Campos <wilmar.campos at gmail.com>

> Thank you Mike, but how do I control to write only when Mysql insert fails?
> I don't want to end up with every record written to the syslog.
>
> Thanks,
>
> Wilmar
>
>
> On Fri, Oct 11, 2013 at 8:12 AM, Mike Tesliuk <mike at ultra.net.br> wrote:
>
>> you can use both , just se the log flag (
>> http://www.opensips.org/html/docs/modules/1.9.x/acc#id293023 ) and
>> log_db_flag together (the same for log_missed_flag )
>>
>>
>> 2013/10/11 Wilmar Campos <wilmar.campos at gmail.com>
>>
>>>  Hi All,
>>>
>>> I hope everybody is good!!
>>> I am writting this list because I want advise on a CDR loss issue I am
>>> having.
>>>
>>> I want to write the mysql INSERT statement into the SYSLOG or separate
>>> file in case mysql gives any error.
>>>
>>> I have try different ways to accomplish this, by editing db_mysql
>>> module, but I get segfaul, so I guess I am doing something really wrong.
>>>
>>> Can someone give me please some direction here?
>>>
>>> Thanks,
>>>
>>> WC
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
> _______________________________________________
> 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/20131011/b8280d88/attachment.htm>