[OpenSIPS-Users] Flatstore files missing some calls

Răzvan Crainea razvan at opensips.org
Thu Aug 27 08:10:01 EST 2020


Are you rotating those files or something? Perhaps you're loosing some 
CDRs during the rotation process.
Are you dumping all CDRs in a single file, or each process has its own file?

Best regards,

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

On 8/27/20 11:01 AM, Vic Jolin wrote:
> Hi Razvan,
> 
> 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
> 
> On Thu, Aug 27, 2020 at 3:45 PM Răzvan Crainea <razvan at opensips.org 
> <mailto:razvan at opensips.org>> wrote:
> 
>     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>
>      > <mailto: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>
>      >     <mailto: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>
>     <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>
>      >         <mailto: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>
>      >             <mailto: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>
>     <mailto: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>
>     <mailto: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>
>     <mailto: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>
>     <mailto: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
> 



More information about the Users mailing list