<div dir="ltr">Yes we rotate it via cron. And each process creates a different flatstore file.<br><div><br></div><div>Is it relative to traffic and number of processes running?</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Aug 27, 2020 at 4:13 PM Răzvan Crainea <<a href="mailto:razvan@opensips.org">razvan@opensips.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">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 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" 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, meaning when <br>
> we see CDRs from our providers we see calls, but we do not see them even <br>
> in the flatstore file logs<br>
> <br>
> On Thu, Aug 27, 2020 at 3:45 PM Răzvan Crainea <<a href="mailto:razvan@opensips.org" target="_blank">razvan@opensips.org</a> <br>
> <mailto:<a href="mailto:razvan@opensips.org" target="_blank">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" 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, <<a href="mailto:staskobzar@gmail.com" target="_blank">staskobzar@gmail.com</a><br>
> <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank">staskobzar@gmail.com</a>><br>
> > <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank">staskobzar@gmail.com</a> <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank">staskobzar@gmail.com</a>>>> wrote:<br>
> ><br>
> > Sorry, Vic<br>
> > I was talking about a different module "db_text". I 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 "/var/log/acc".<br>
> > Or, jist temporary use "/tmp" path to make sure this is not a<br>
> > permission problem.<br>
> ><br>
> > On Thu, Aug 6, 2020 at 2:14 PM Vic Jolin <<a href="mailto:adjolin@gmail.com" target="_blank">adjolin@gmail.com</a><br>
> <mailto:<a href="mailto:adjolin@gmail.com" target="_blank">adjolin@gmail.com</a>><br>
> > <mailto:<a href="mailto:adjolin@gmail.com" target="_blank">adjolin@gmail.com</a> <mailto:<a href="mailto:adjolin@gmail.com" target="_blank">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 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: callerid->callerid;<br>
> > ani->ani; prefix->prefix; src_ip->src_ip; 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: callerid->callerid;<br>
> > ani->ani; prefix->prefix; src_ip->src_ip; dst_ip->dst_ip;<br>
> > acctid->acctid; carrierid->carrierid; 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" target="_blank">s.int</a> <<a href="http://s.int" rel="noreferrer" target="_blank">http://s.int</a>><br>
> <<a href="http://s.int" rel="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">staskobzar@gmail.com</a> <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank">staskobzar@gmail.com</a>><br>
> > <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank">staskobzar@gmail.com</a><br>
> <mailto:<a href="mailto:staskobzar@gmail.com" target="_blank">staskobzar@gmail.com</a>>>> wrote:<br>
> ><br>
> > Hello,<br>
> ><br>
> > You should create the file with headers. You can copy<br>
> > required storage file from here:<br>
> ><br>
> <a href="https://github.com/OpenSIPS/opensips/tree/master/scripts/dbtext/opensips" rel="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">adjolin@gmail.com</a> <mailto:<a href="mailto:adjolin@gmail.com" target="_blank">adjolin@gmail.com</a>><br>
> > <mailto:<a href="mailto:adjolin@gmail.com" target="_blank">adjolin@gmail.com</a><br>
> <mailto:<a href="mailto:adjolin@gmail.com" target="_blank">adjolin@gmail.com</a>>>> wrote:<br>
> ><br>
> > Hello,<br>
> ><br>
> > What are the reasons why flatstore files are not<br>
> being<br>
> > created?<br>
> ><br>
> > Im seeing this output in a binary journal file,<br>
> and not<br>
> > from a normal log file I have my output 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>
> 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. Is this a<br>
> > server issue? A resource like HD write speed? or some<br>
> > misconfiguration?<br>
> > _______________________________________________<br>
> > Users mailing list<br>
> > <a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>>><br>
> > <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="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">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>>><br>
> > <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="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">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>>><br>
> > <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="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">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>><br>
> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>>><br>
> > <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="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">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>><br>
> > <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="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">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="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">Users@lists.opensips.org</a><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="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">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div>