[OpenSIPS-Users] Flatstore files missing some calls
Vic Jolin
adjolin at gmail.com
Thu Aug 27 09:21:21 EST 2020
Yes that is the order we process the flatstore file
On Thu, Aug 27, 2020, 4:55 PM Răzvan Crainea, <razvan at opensips.org> wrote:
> Then you should make sure that you execute the rotation in the following
> order:
>
> 1. move the file
> 2. run the rotate command
> 3. process the CDR file
>
> Best regards,
>
> Răzvan Crainea
> OpenSIPS Core Developer
> http://www.opensips-solutions.com
>
> On 8/27/20 11:21 AM, Vic Jolin wrote:
> > 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
> > <mailto: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>
> > > <mailto: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>>
> > > > <mailto: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>>
> > > > <mailto: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>
> > > <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>>
> > > > <mailto: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>>
> > > > <mailto: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>>
> > > <mailto: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>>
> > > <mailto: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>>
> > > <mailto: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>>
> > > <mailto: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/1a2ffb64/attachment-0001.html>
More information about the Users
mailing list