<div dir="ltr">Hi Razvan,<br><div><br></div><div>CDRs are generated, but there are missing entries in cdrs, meaning when we see CDRs from our providers we see calls, but we do not see them even in the flatstore file logs</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Aug 27, 2020 at 3:45 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">Hi, Vic!<br>
<br>
It is not clear in your report whether there are no CDR files 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 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>>> wrote:<br>
> <br>
> Sorry, Vic<br>
> I was talking about a different module "db_text". I just did 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>>> wrote:<br>
> <br>
> Staz,<br>
> <br>
> Hi thanks for the reply, I forgot I think to mention 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; 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>>}), "$rU", $rU,<br>
> $var(dp_attr));<br>
> <br>
> <br>
> On Fri, Aug 7, 2020 at 1:39 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>>> wrote:<br>
> <br>
> Hello,<br>
> <br>
> You should create the file with headers. You can copy<br>
> required storage file from here:<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 <<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 being<br>
> created?<br>
> <br>
> Im seeing this output in a binary journal file, 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 here as well)<br>
> <br>
> <br>
> <br>
> ACC: call ended:<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>
> <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>
> <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>
> <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>
> <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>