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@gmail.com <morfair@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@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@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@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@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@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@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