[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