[Freeswitch-users] Monitoring mod_odbc_cdr

[Giovanni Maruzzelli]

You NEVER EVER rely on server (freeswitch|asterisk|sipproxy|etc) database
connection for accounting and billing.

You want to write CDRs on a reliable support, then (maybe even in
semirealtime) you use CDRs as input for accounting/billing.

If you have advanced needs you can use advanced (and reliable) systems like
http://www.cgrates.org/


-giovanni


On Fri, Nov 16, 2018 at 8:35 PM Social Boh <social at bohboh.info> wrote:

> Hello,
>
> on the odbc_cdr.conf.xml, maybe you can configure:
>
> <param name="write-csv" value="on-db-fail"/>
> <param name="csv-path" value="/var/log/freeswitch/cdr-csv"/>
> <!--<param name="csv-path-on-fail"
> value="/usr/local/freeswitch/log/odbc_cdr/failed"/>-->
>
> so if database fail you ha ve a file for each call you can process to add
> to your tables.
>
> Regards
>
> ---
> I'm SoCIaL, MayBe
>
> El 16/11/2018 a las 08:24, Sergey Safarov escribió:
>
> you can
> 1) count call in database for last 12 hours using monitoring tools like
> zabbix. If no calls then rise alarm;
> 2) configure saving CDR in XML or JSON format on disk. if call is lost in
> CSL database, then you cann load from CDR files. CDR files older then 2
> days may be deleted.
>
>
> пт, 16 нояб. 2018 г. в 16:18, morfair at gmail.com <morfair at gmail.com>:
>
>> Hello all!
>>
>> I use mod_odbc_cdr for store CDR in  MySQL for billing. Today I saw that
>> no records in DB in 2 weeks. IT IS FAIL!!
>>
>> I went to fs_cli and type `reload mod_odbc_cdr`. After that all work
>> again. But I lost records in two weeks.
>>
>> How to monitor mod_odbc_cdr and prevent risks with its?
>>
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Services
>> sales at freeswitch.com
>> https://freeswitch.com
>>
>> Official FreeSWITCH Sites
>> https://freeswitch.com/oss
>> https://freeswitch.org/confluence
>> https://cluecon.com
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> https://freeswitch.com
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Servicessales at freeswitch.comhttps://freeswitch.com
>
> Official FreeSWITCH Siteshttps://freeswitch.com/osshttps://freeswitch.org/confluencehttps://cluecon.com
>
> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttps://freeswitch.com
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Services
> sales at freeswitch.com
> https://freeswitch.com
>
> Official FreeSWITCH Sites
> https://freeswitch.com/oss
> https://freeswitch.org/confluence
> https://cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> https://freeswitch.com
>
> --
> Sincerely,
>
> Giovanni Maruzzelli
> OpenTelecom.IT
> cell: +39 347 266 56 18
>
>
>
> <https://freeswitch.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20181119/6ec74085/attachment-0001.html>