[OpenSIPS-Users] Flatstore files missing some calls

Vic Jolin adjolin at gmail.com
Thu Aug 27 08:21:44 EST 2020


Yes we rotate it via cron. And each process creates a different flatstore
file.

Is it relative to traffic and number of processes running?

On Thu, Aug 27, 2020 at 4:13 PM Răzvan Crainea <razvan at opensips.org> wrote:

> 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
> >
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200827/cb2020f3/attachment-0001.html>


More information about the Users mailing list