<br><br><br><strong>----- Original Message -----</strong><br> <strong>From:</strong> tarik@pasifiktelekom.com.tr [mailto:tarik@pasifiktelekom.com.tr]<br> <strong>To:</strong> service@ivc.nnov.ru<br> <strong>Sent:</strong> Thu, 3 Nov 2016 15:07:58 +0300<br> <strong>Subject:</strong> <br><br> Hi,<br><br>Yes, the same thing happen to me, when I originate call I get the same error in freeswitch, column count different this is happen in <strong>cdr_sqlite.conf.xml.<br>in Terminal:<br></strong><br><span style="font-family: comic sans ms,sans-serif; background-color: #993366; color: #ffffff;">nano /usr/local/freeswitch/conf/autoload_configs/cdr_sqlite.conf.xml</span><br><br><strong>comment this line:</strong><br><br><span style="font-family: comic sans ms,sans-serif;"><templates></span><br><span style="font-family: comic sans ms,sans-serif;"> <!--<template name=”example”>”${caller_id_name}”,”${caller_id_number}”,”${destination_number}”,”${context}”,”${start_stamp}”,”${answer_stamp}”,”${end_stamp}”,${duration},${billsec},”${hangup_cause}”, “${hangup_cause_q850}”,”${uuid}”,”${bleg_uuid}”,”${accountcode}”</template>--></span><br><span style="font-family: comic sans ms,sans-serif;"></templates></span><br><br><strong>replace it with:</strong><br><br><span style="font-family: comic sans ms,sans-serif;"><templates></span><br><span style="font-family: comic sans ms,sans-serif;"> <template name="example">"${caller_id_name}","${caller_id_number}","${destination_number}","${context}","${start_stamp}","${answer_stamp}","${end_stamp}",${duration},${billsec},"${hangup_cause}","${uuid}","${bleg_uuid}","${accountcode}",0</template></span><br><span style="font-family: comic sans ms,sans-serif;"></templates></span><br><br>After that restart supervisor.<br><br>I attached some notes and .sql schema, and .yaml schema configuration for cdr-pusher.<br><br>Best regards.<br><br>Tarek,<br><br><br><strong>----- Original Message -----</strong><br> <strong>From:</strong> Mikhail Demekhov [mailto:Mikhail Demekhov]<br> <strong>To:</strong> tarik@pasifiktelekom.com.tr<br> <strong>Sent:</strong> Thu, 3 Nov 2016 13:03:08 +0300<br> <strong>Subject:</strong> <br><br> <span style="font-family: courier new,courier,arial,helvetica,sans-serif;">03.11.2016 12:12, <a target='_blank'>tarik@pasifiktelekom.com.tr</a> пишет:<br>> Yes I used<br>> cdr-pusher<br>> <a href="https://github.com/areski/cdr-pusher" target='_blank'>https://github.com/areski/cdr-pusher</a><br>> I get cdr and store it in PostgreDB from FreeSWITCH.<br>><br><br>I installed cdr-stats on Debian 8 with FreeSWITCH.<br>cdr-pusher successfully processed the first entry in the cdr.db (msg = <br>"Total fetched from database: 8" msg = "Total number pushed to <br>PostgreSQL: 8") and added to the database cdr.db"flag_imported".<br>Thereafter Freeswitch stopped writing in cdr.db error <br>switch_core_sqldb.c: 587 NATIVE SQL ERR [table cdr has 15 columns but 14 <br>values were supplied]<br><br>In Dashboard, I do not see these records 8.<br><br>But Diagnosis CDR-Staty shows TOTAL CDR 8<br><br>How to solve these problems?<br><br>Regards,<br>Mikhail Demekhov<br><br>><br>><br>> *----- Original Message -----*<br>> *From:* Mikhail Demekhov [mailto:Mikhail Demekhov]<br>> *To:* <a target='_blank'>freeswitch-users@lists.freeswitch.org</a><br>> *Sent:* Wed, 2 Nov 2016 17:37:36 +0300<br>> *Subject:*<br>><br>> Hello!<br>><br>> Anyone using CDR-Stats (<a href="http://cdr-stats.readthedocs.io/en/stable/)" target='_blank'>http://cdr-stats.readthedocs.io/en/stable/)</a>?<br>> There are several questions on the use.<br>><br>> Regards,<br>> Mikhail Demekhov<br>><br>> _________________________________________________________________________<br>> Professional FreeSWITCH Consulting Services:<br>> <a target='_blank'>consulting@freeswitch.org</a><br>> <a href="http://www.freeswitchsolutions.com" target='_blank'>http://www.freeswitchsolutions.com</a><br>><br>> Official FreeSWITCH Sites<br>> <a href="http://www.freeswitch.org" target='_blank'>http://www.freeswitch.org</a><br>> <a href="http://confluence.freeswitch.org" target='_blank'>http://confluence.freeswitch.org</a><br>> <a href="http://www.cluecon.com" target='_blank'>http://www.cluecon.com</a><br>><br>> FreeSWITCH-users mailing list<br>> FreeSWI<a target='_blank'>TCH-users@lists.freeswitch.org</a><br>> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target='_blank'>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target='_blank'>http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>> <a href="http://www.freeswitch.org" target='_blank'>http://www.freeswitch.org</a><br>><br>> --<br>> Bu eposta GarantiMail Security Gateway tarafından antivirüs ve antispam kontrolünden geçirilmiştir. #MAILGW02#<br>><br><br></span>
<pre>
--
Bu eposta GarantiMail Security Gateway tarafından antivirüs ve antispam kontrolünden geçirilmiştir. #MAILGW02#</pre>