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

Reply via email to