[Freeswitch-users] Monitoring mod_odbc_cdr

[Social Boh]

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 
> <mailto:morfair at gmail.com> <morfair at gmail.com <mailto: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 <mailto: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
>     <mailto: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 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20181116/ab97cca6/attachment.html>