[OpenSIPS-Users] Flatstore files missing some calls
Răzvan Crainea
razvan at opensips.org
Thu Aug 27 08:52:25 EST 2020
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
>
More information about the Users
mailing list