[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