[OpenSIPS-Users] Flatstore files missing some calls

[Răzvan Crainea]

Hi, Vic!

It is not clear in your report whether there are no CDR files generated, 
or you're just missing some of them. Could you please clarify?

Best regards,

Răzvan Crainea
OpenSIPS Core Developer
http://www.opensips-solutions.com

On 8/7/20 9:50 AM, Vic Jolin wrote:
> I still need to clarify why this is happening. We are missing calls in cdrs
> 
> On Fri, Aug 7, 2020, 2:30 AM Stas Kobzar, <staskobzar at gmail.com 
> <mailto:staskobzar at gmail.com>> wrote:
> 
>     Sorry, Vic
>     I was talking about a different module "db_text". I just did not get
>     the subject right.
>     I do not know about flatstore, sorry.
> 
>     However, you can still check your permissions for "/var/log/acc".
>     Or, jist temporary use "/tmp" path to make sure this is not a
>     permission problem.
> 
>     On Thu, Aug 6, 2020 at 2:14 PM Vic Jolin <adjolin at gmail.com
>     <mailto:adjolin at gmail.com>> wrote:
> 
>         Staz,
> 
>         Hi thanks for the reply, I forgot I think to mention about my config
> 
>         loadmodule "db_flatstore.so"
>         modparam("db_flatstore", "flush", 1)
>         modparam("db_flatstore", "suffix", ".log_SERVERIP")
> 
>         loadmodule "acc.so"
>         /* what special events should be accounted ? */
>         modparam("acc", "early_media", 1)
>         modparam("acc", "report_cancels", 1)
>         /* by default we do not adjust the direct of the sequential
>         requests.
>             if you enable this parameter, be sure the enable
>         "append_fromtag"
>             in "rr" module */
>         modparam("acc", "detect_direction", 0)
>         modparam("acc", "extra_fields", "db: callerid->callerid;
>         ani->ani; prefix->prefix; src_ip->src_ip; dst_ip->dst_ip;
>         acctid->acctid; carrierid->carrierid; ruleid->ruleid; lrn->lrn;
>         orig_ani->orig_ani")
>         #modparam("acc", "extra_fields", "db: callerid->callerid;
>         ani->ani; prefix->prefix; src_ip->src_ip; dst_ip->dst_ip;
>         acctid->acctid; carrierid->carrierid; ruleid->ruleid;")
>         modparam("acc", "db_url", "flatstore:/var/log/acc")
> 
>         Is there  a proper placement of
>         do_accounting("db|log", "cdr|missed|failed");
> 
>         In my config I have this in the route before
> 
>         dp_translate($(avp(groupid){s.int <http://s.int>}), "$rU", $rU,
>         $var(dp_attr));
> 
> 
>         On Fri, Aug 7, 2020 at 1:39 AM Stas Kobzar <staskobzar at gmail.com
>         <mailto:staskobzar at gmail.com>> wrote:
> 
>             Hello,
> 
>             You should create the file with headers. You can copy
>             required storage file from here:
>             https://github.com/OpenSIPS/opensips/tree/master/scripts/dbtext/opensips
> 
>             And, of course, make sure you have good owner and
>             permissions set to the file.
> 
>             On Thu, Aug 6, 2020 at 1:26 PM Vic Jolin <adjolin at gmail.com
>             <mailto:adjolin at gmail.com>> wrote:
> 
>                 Hello,
> 
>                 What are the reasons why flatstore files are not being
>                 created?
> 
>                 Im  seeing this output in a binary journal file, and not
>                 from a normal log file I have my output logs in
>                 /var/log/messages (but we do not see it coming here as well)
> 
> 
> 
>                 ACC: call ended:
>                 created=1596585092;call_start_time=1596585108;duration=5;ms_duration=5268;setuptime=16;method=INVITE;from_tag=13c1b24f27e408db;to_tag=ZtNe611a9391D;call_id=2a2ac4f263616c6c0015c430
> 
>                 But no flatstore file created or updated
> 
>                 But there is no flatstore files created. Is this a
>                 server issue? A resource like HD write speed? or some
>                 misconfiguration?
>                 _______________________________________________
>                 Users mailing list
>                 Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>                 http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> 
>             _______________________________________________
>             Users mailing list
>             Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>             http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> 
>         _______________________________________________
>         Users mailing list
>         Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>         http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> 
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> 
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>