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@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@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 Servicessales@freeswitch.comhttps://freeswitch.com
Official FreeSWITCH Siteshttps://freeswitch.com/osshttps://freeswitch.org/confluencehttps://cluecon.c...
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttps://freeswit...
_________________________________________________________________________ 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