Just another question with regards to this, how often should we move and rotate the flatstore files?
On Thu, Aug 27, 2020 at 4:55 PM Răzvan Crainea <[email protected]> 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 <[email protected] > > <mailto:[email protected]>> 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 > > <[email protected] <mailto:[email protected]> > > > <mailto:[email protected] <mailto:[email protected]>>> 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, > > <[email protected] <mailto:[email protected]> > > > <mailto:[email protected] <mailto:[email protected]>> > > > > <mailto:[email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>>>> 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 > > <[email protected] <mailto:[email protected]> > > > <mailto:[email protected] <mailto:[email protected]>> > > > > <mailto:[email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>>>> 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 > > > <[email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>> > > > > <mailto:[email protected] > > <mailto:[email protected]> > > > <mailto:[email protected] <mailto:[email protected]>>>> > > 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 > > > <[email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>> > > > > <mailto:[email protected] > > <mailto:[email protected]> > > > <mailto:[email protected] <mailto:[email protected]>>>> > 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 > > > > [email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>> > > > <mailto:[email protected] > > <mailto:[email protected]> <mailto:[email protected] > > <mailto:[email protected]>>> > > > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > > _______________________________________________ > > > > Users mailing list > > > > [email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>> > > > <mailto:[email protected] > > <mailto:[email protected]> <mailto:[email protected] > > <mailto:[email protected]>>> > > > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > > _______________________________________________ > > > > Users mailing list > > > > [email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>> > > > <mailto:[email protected] > > <mailto:[email protected]> <mailto:[email protected] > > <mailto:[email protected]>>> > > > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > > _______________________________________________ > > > > Users mailing list > > > > [email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>> > > > <mailto:[email protected] > > <mailto:[email protected]> <mailto:[email protected] > > <mailto:[email protected]>>> > > > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > > > > > > _______________________________________________ > > > > Users mailing list > > > > [email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>> > > > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > > > > _______________________________________________ > > > Users mailing list > > > [email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>> > > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > > > _______________________________________________ > > > Users mailing list > > > [email protected] <mailto:[email protected]> > > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > _______________________________________________ > > Users mailing list > > [email protected] <mailto:[email protected]> > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > _______________________________________________ > > Users mailing list > > [email protected] > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
