<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body 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="moz-signature" cols="72">---
I'm SoCIaL, MayBe</pre>
<div class="moz-cite-prefix">El 16/11/2018 a las 08:24, Sergey
Safarov escribió:<br>
</div>
<blockquote type="cite"
cite="mid:CAHtxdDc1n-LcHUXC36pxgX8O+nSBk3mAv22Dm1xqAg00qy_Vqw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<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" moz-do-not-send="true">morfair@gmail.com</a>
<<a href="mailto:morfair@gmail.com" moz-do-not-send="true">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"
moz-do-not-send="true">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer" target="_blank"
moz-do-not-send="true">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target="_blank" moz-do-not-send="true">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com</a></blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_________________________________________________________________________
Professional FreeSWITCH Services
<a class="moz-txt-link-abbreviated" href="mailto:sales@freeswitch.com">sales@freeswitch.com</a>
<a class="moz-txt-link-freetext" href="https://freeswitch.com">https://freeswitch.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="https://freeswitch.com/oss">https://freeswitch.com/oss</a>
<a class="moz-txt-link-freetext" href="https://freeswitch.org/confluence">https://freeswitch.org/confluence</a>
<a class="moz-txt-link-freetext" href="https://cluecon.com">https://cluecon.com</a>
FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="https://freeswitch.com">https://freeswitch.com</a></pre>
</blockquote>
<br>
</body>
</html>