<div dir="auto">Yes that is the order we process the flatstore file</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Aug 27, 2020, 4:55 PM Răzvan Crainea, <<a href="mailto:razvan@opensips.org">razvan@opensips.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Then you should make sure that you execute the rotation in the following <br>
order:<br>
<br>
1. move the file<br>
2. run the rotate command<br>
3. process the CDR file<br>
<br>
Best regards,<br>
<br>
Răzvan Crainea<br>
OpenSIPS Core Developer<br>
<a href="http://www.opensips-solutions.com" rel="noreferrer noreferrer" target="_blank">http://www.opensips-solutions.com</a><br>
<br>
On 8/27/20 11:21 AM, Vic Jolin wrote:<br>
> Yes we rotate it via cron. And each process creates a different <br>
> flatstore file.<br>
> <br>
> Is it relative to traffic and number of processes running?<br>
> <br>
> On Thu, Aug 27, 2020 at 4:13 PM Răzvan Crainea <<a href="mailto:razvan@opensips.org" target="_blank" rel="noreferrer">razvan@opensips.org</a> <br>
> <mailto:<a href="mailto:razvan@opensips.org" target="_blank" rel="noreferrer">razvan@opensips.org</a>>> wrote:<br>
> <br>
> Are you rotating those files or something? Perhaps you're loosing some<br>
> CDRs during the rotation process.<br>
> Are you dumping all CDRs in a single file, or each process has its<br>
> own file?<br>
> <br>
> Best regards,<br>
> <br>
> Răzvan Crainea<br>
> OpenSIPS Core Developer<br>
> <a href="http://www.opensips-solutions.com" rel="noreferrer noreferrer" target="_blank">http://www.opensips-solutions.com</a><br>
> <br>
> On 8/27/20 11:01 AM, Vic Jolin wrote:<br>
> > Hi Razvan,<br>
> ><br>
> > CDRs are generated, but there are missing entries in cdrs,<br>
> meaning when<br>
> > we see CDRs from our providers we see calls, but we do not see<br>
> them even<br>
> > in the flatstore file logs<br>
> ><br>
> > On Thu, Aug 27, 2020 at 3:45 PM Răzvan Crainea<br>
> <<a href="mailto:razvan@opensips.org" target="_blank" rel="noreferrer">razvan@opensips.org</a> <mailto:<a href="mailto:razvan@opensips.org" target="_blank" rel="noreferrer">razvan@opensips.org</a>><br>
> > <mailto:<a href="mailto:razvan@opensips.org" target="_blank" rel="noreferrer">razvan@opensips.org</a> <mailto:<a href="mailto:razvan@opensips.org" target="_blank" rel="noreferrer">razvan@opensips.org</a>>>> wrote:<br>
> ><br>
> > Hi, Vic!<br>
> ><br>
> > It is not clear in your report whether there are no CDR files<br>
> > generated,<br>
> > or you're just missing some of them. Could you please clarify?<br>
> ><br>
> > Best regards,<br>
> ><br>
> > Răzvan Crainea<br>
> > OpenSIPS Core Developer<br>
> > <a href="http://www.opensips-solutions.com" rel="noreferrer noreferrer" target="_blank">http://www.opensips-solutions.com</a><br>
> ><br>
> > On 8/7/20 9:50 AM, Vic Jolin wrote:<br>
> > > I still need to clarify why this is happening. We are missing<br>
> > calls in cdrs<br>
> > ><br>
> > > On Fri, Aug 7, 2020, 2:30 AM Stas Kobzar,<br>
> <<a href="mailto:staskobzar@gmail.com" target="_blank" rel="noreferrer">staskobzar@gmail.com</a> <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank" rel="noreferrer">staskobzar@gmail.com</a>><br>
> > <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank" rel="noreferrer">staskobzar@gmail.com</a> <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank" rel="noreferrer">staskobzar@gmail.com</a>>><br>
> > > <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank" rel="noreferrer">staskobzar@gmail.com</a> <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank" rel="noreferrer">staskobzar@gmail.com</a>><br>
> <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank" rel="noreferrer">staskobzar@gmail.com</a> <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank" rel="noreferrer">staskobzar@gmail.com</a>>>>> wrote:<br>
> > ><br>
> > > Sorry, Vic<br>
> > > I was talking about a different module "db_text". I<br>
> just did<br>
> > not get<br>
> > > the subject right.<br>
> > > I do not know about flatstore, sorry.<br>
> > ><br>
> > > However, you can still check your permissions for<br>
> "/var/log/acc".<br>
> > > Or, jist temporary use "/tmp" path to make sure this<br>
> is not a<br>
> > > permission problem.<br>
> > ><br>
> > > On Thu, Aug 6, 2020 at 2:14 PM Vic Jolin<br>
> <<a href="mailto:adjolin@gmail.com" target="_blank" rel="noreferrer">adjolin@gmail.com</a> <mailto:<a href="mailto:adjolin@gmail.com" target="_blank" rel="noreferrer">adjolin@gmail.com</a>><br>
> > <mailto:<a href="mailto:adjolin@gmail.com" target="_blank" rel="noreferrer">adjolin@gmail.com</a> <mailto:<a href="mailto:adjolin@gmail.com" target="_blank" rel="noreferrer">adjolin@gmail.com</a>>><br>
> > > <mailto:<a href="mailto:adjolin@gmail.com" target="_blank" rel="noreferrer">adjolin@gmail.com</a> <mailto:<a href="mailto:adjolin@gmail.com" target="_blank" rel="noreferrer">adjolin@gmail.com</a>><br>
> <mailto:<a href="mailto:adjolin@gmail.com" target="_blank" rel="noreferrer">adjolin@gmail.com</a> <mailto:<a href="mailto:adjolin@gmail.com" target="_blank" rel="noreferrer">adjolin@gmail.com</a>>>>> wrote:<br>
> > ><br>
> > > Staz,<br>
> > ><br>
> > > Hi thanks for the reply, I forgot I think to mention<br>
> > about my config<br>
> > ><br>
> > > loadmodule "db_flatstore.so"<br>
> > > modparam("db_flatstore", "flush", 1)<br>
> > > modparam("db_flatstore", "suffix", ".log_SERVERIP")<br>
> > ><br>
> > > loadmodule "acc.so"<br>
> > > /* what special events should be accounted ? */<br>
> > > modparam("acc", "early_media", 1)<br>
> > > modparam("acc", "report_cancels", 1)<br>
> > > /* by default we do not adjust the direct of the<br>
> sequential<br>
> > > requests.<br>
> > > if you enable this parameter, be sure the enable<br>
> > > "append_fromtag"<br>
> > > in "rr" module */<br>
> > > modparam("acc", "detect_direction", 0)<br>
> > > modparam("acc", "extra_fields", "db:<br>
> callerid->callerid;<br>
> > > ani->ani; prefix->prefix; src_ip->src_ip;<br>
> dst_ip->dst_ip;<br>
> > > acctid->acctid; carrierid->carrierid; ruleid->ruleid;<br>
> > lrn->lrn;<br>
> > > orig_ani->orig_ani")<br>
> > > #modparam("acc", "extra_fields", "db:<br>
> callerid->callerid;<br>
> > > ani->ani; prefix->prefix; src_ip->src_ip;<br>
> dst_ip->dst_ip;<br>
> > > acctid->acctid; carrierid->carrierid;<br>
> ruleid->ruleid;")<br>
> > > modparam("acc", "db_url", "flatstore:/var/log/acc")<br>
> > ><br>
> > > Is there a proper placement of<br>
> > > do_accounting("db|log", "cdr|missed|failed");<br>
> > ><br>
> > > In my config I have this in the route before<br>
> > ><br>
> > > dp_translate($(avp(groupid){<a href="http://s.int" rel="noreferrer noreferrer" target="_blank">s.int</a> <<a href="http://s.int" rel="noreferrer noreferrer" target="_blank">http://s.int</a>><br>
> <<a href="http://s.int" rel="noreferrer noreferrer" target="_blank">http://s.int</a>><br>
> > <<a href="http://s.int" rel="noreferrer noreferrer" target="_blank">http://s.int</a>>}), "$rU", $rU,<br>
> > > $var(dp_attr));<br>
> > ><br>
> > ><br>
> > > On Fri, Aug 7, 2020 at 1:39 AM Stas Kobzar<br>
> > <<a href="mailto:staskobzar@gmail.com" target="_blank" rel="noreferrer">staskobzar@gmail.com</a> <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank" rel="noreferrer">staskobzar@gmail.com</a>><br>
> <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank" rel="noreferrer">staskobzar@gmail.com</a> <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank" rel="noreferrer">staskobzar@gmail.com</a>>><br>
> > > <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank" rel="noreferrer">staskobzar@gmail.com</a><br>
> <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank" rel="noreferrer">staskobzar@gmail.com</a>><br>
> > <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank" rel="noreferrer">staskobzar@gmail.com</a> <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank" rel="noreferrer">staskobzar@gmail.com</a>>>>><br>
> wrote:<br>
> > ><br>
> > > Hello,<br>
> > ><br>
> > > You should create the file with headers. You<br>
> can copy<br>
> > > required storage file from here:<br>
> > ><br>
> ><br>
> <a href="https://github.com/OpenSIPS/opensips/tree/master/scripts/dbtext/opensips" rel="noreferrer noreferrer" target="_blank">https://github.com/OpenSIPS/opensips/tree/master/scripts/dbtext/opensips</a><br>
> > ><br>
> > > And, of course, make sure you have good owner and<br>
> > > permissions set to the file.<br>
> > ><br>
> > > On Thu, Aug 6, 2020 at 1:26 PM Vic Jolin<br>
> > <<a href="mailto:adjolin@gmail.com" target="_blank" rel="noreferrer">adjolin@gmail.com</a> <mailto:<a href="mailto:adjolin@gmail.com" target="_blank" rel="noreferrer">adjolin@gmail.com</a>><br>
> <mailto:<a href="mailto:adjolin@gmail.com" target="_blank" rel="noreferrer">adjolin@gmail.com</a> <mailto:<a href="mailto:adjolin@gmail.com" target="_blank" rel="noreferrer">adjolin@gmail.com</a>>><br>
> > > <mailto:<a href="mailto:adjolin@gmail.com" target="_blank" rel="noreferrer">adjolin@gmail.com</a><br>
> <mailto:<a href="mailto:adjolin@gmail.com" target="_blank" rel="noreferrer">adjolin@gmail.com</a>><br>
> > <mailto:<a href="mailto:adjolin@gmail.com" target="_blank" rel="noreferrer">adjolin@gmail.com</a> <mailto:<a href="mailto:adjolin@gmail.com" target="_blank" rel="noreferrer">adjolin@gmail.com</a>>>>> wrote:<br>
> > ><br>
> > > Hello,<br>
> > ><br>
> > > What are the reasons why flatstore files<br>
> are not<br>
> > being<br>
> > > created?<br>
> > ><br>
> > > Im seeing this output in a binary journal<br>
> file,<br>
> > and not<br>
> > > from a normal log file I have my output<br>
> logs in<br>
> > > /var/log/messages (but we do not see it coming<br>
> > here as well)<br>
> > ><br>
> > ><br>
> > ><br>
> > > ACC: call ended:<br>
> > ><br>
> > <br>
> created=1596585092;call_start_time=1596585108;duration=5;ms_duration=5268;setuptime=16;method=INVITE;from_tag=13c1b24f27e408db;to_tag=ZtNe611a9391D;call_id=2a2ac4f263616c6c0015c430<br>
> > ><br>
> > > But no flatstore file created or updated<br>
> > ><br>
> > > But there is no flatstore files created.<br>
> Is this a<br>
> > > server issue? A resource like HD write<br>
> speed? or some<br>
> > > misconfiguration?<br>
> > > <br>
> _______________________________________________<br>
> > > Users mailing list<br>
> > > <a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>>><br>
> > <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>>>><br>
> > > <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
> > ><br>
> > > _______________________________________________<br>
> > > Users mailing list<br>
> > > <a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>>><br>
> > <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>>>><br>
> > > <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
> > ><br>
> > > _______________________________________________<br>
> > > Users mailing list<br>
> > > <a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>>><br>
> > <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>>>><br>
> > > <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
> > ><br>
> > > _______________________________________________<br>
> > > Users mailing list<br>
> > > <a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>>><br>
> > <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>>>><br>
> > > <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
> > ><br>
> > ><br>
> > > _______________________________________________<br>
> > > Users mailing list<br>
> > > <a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>>><br>
> > > <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
> > ><br>
> ><br>
> > _______________________________________________<br>
> > Users mailing list<br>
> > <a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>>><br>
> > <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
> ><br>
> ><br>
> > _______________________________________________<br>
> > Users mailing list<br>
> > <a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>><br>
> > <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
> ><br>
> <br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a>><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
> <br>
> <br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
> <br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank" rel="noreferrer">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div>