<div dir="ltr"><div dir="ltr"><div>You NEVER EVER rely on server (freeswitch|asterisk|sipproxy|etc) database connection for accounting and billing.</div><div><br></div><div>You want to write CDRs on a reliable support, then (maybe even in semirealtime) you use CDRs as input for accounting/billing.</div><div><br></div><div>If you have advanced needs you can use advanced (and reliable) systems like <a href="http://www.cgrates.org/">http://www.cgrates.org/</a> <br></div><div><br></div><div><br></div><div>-giovanni</div><div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Fri, Nov 16, 2018 at 8:35 PM Social Boh <<a href="mailto:social@bohboh.info">social@bohboh.info</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<p>Hello,</p>
<p>on the odbc_cdr.conf.xml, maybe you can configure:</p>
<p><param name="write-csv" value="on-db-fail"/><br>
<param name="csv-path" value="/var/log/freeswitch/cdr-csv"/><br>
<!--<param name="csv-path-on-fail"
value="/usr/local/freeswitch/log/odbc_cdr/failed"/>--></p>
<p>so if database fail you ha ve a file for each call you can
process to add to your tables.</p>
<p>Regards<br>
</p>
<pre class="m_3849968772669325652moz-signature" cols="72">---
I'm SoCIaL, MayBe</pre>
<div class="m_3849968772669325652moz-cite-prefix">El 16/11/2018 a las 08:24, Sergey
Safarov escribió:<br>
</div>
<blockquote type="cite">
<div dir="ltr">you can<br>
1) count call in database for last 12 hours using monitoring
tools like zabbix. If no calls then rise alarm;
<div>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.<br>
<br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr">пт, 16 нояб. 2018 г. в 16:18, <a href="mailto:morfair@gmail.com" target="_blank">morfair@gmail.com</a>
<<a href="mailto:morfair@gmail.com" target="_blank">morfair@gmail.com</a>>:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello all!<br>
<br>
I use mod_odbc_cdr for store CDR in MySQL for billing. Today
I saw that <br>
no records in DB in 2 weeks. IT IS FAIL!!<br>
<br>
I went to fs_cli and type `reload mod_odbc_cdr`. After that
all work <br>
again. But I lost records in two weeks.<br>
<br>
How to monitor mod_odbc_cdr and prevent risks with its?<br>
<br>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer" target="_blank">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" rel="noreferrer" target="_blank">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer" target="_blank">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a></blockquote>
</div>
<br>
<fieldset class="m_3849968772669325652mimeAttachmentHeader"></fieldset>
<br>
<pre>_________________________________________________________________________
Professional FreeSWITCH Services
<a class="m_3849968772669325652moz-txt-link-abbreviated" href="mailto:sales@freeswitch.com" target="_blank">sales@freeswitch.com</a>
<a class="m_3849968772669325652moz-txt-link-freetext" href="https://freeswitch.com" target="_blank">https://freeswitch.com</a>
Official FreeSWITCH Sites
<a class="m_3849968772669325652moz-txt-link-freetext" href="https://freeswitch.com/oss" target="_blank">https://freeswitch.com/oss</a>
<a class="m_3849968772669325652moz-txt-link-freetext" href="https://freeswitch.org/confluence" target="_blank">https://freeswitch.org/confluence</a>
<a class="m_3849968772669325652moz-txt-link-freetext" href="https://cluecon.com" target="_blank">https://cluecon.com</a>
FreeSWITCH-users mailing list
<a class="m_3849968772669325652moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="m_3849968772669325652moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="m_3849968772669325652moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="m_3849968772669325652moz-txt-link-freetext" href="https://freeswitch.com" target="_blank">https://freeswitch.com</a></pre>
</blockquote>
<br>
</div>
_________________________________________________________________________<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer" target="_blank">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" rel="noreferrer" target="_blank">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer" target="_blank">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com<br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature">Sincerely,<br><br>Giovanni Maruzzelli<br>OpenTelecom.IT<br>cell: +39 347 266 56 18<br><br></div><br><br></a></blockquote></div>