[pmacct-discussion] sql_history problem

[alex]

    Hello Paolo!
    Sorry again but i found something strange in 'pmacct' behaviour.
    I have follow setting for history saving on my 'nfacctd':

! nfacctd_time_secs: true
! nfacctd_time_new: true
sql_refresh_time: 120
sql_history: 1d
sql_history_roundoff: h

    But i see next records in my database:

    bytes     stamp_inserted         stamp_updated

  2188048   2008-04-17 00:00:00     2008-04-18 11:28:01
   538793   2008-04-17 00:00:00     2008-04-18 09:56:01
    64680   2008-04-17 00:00:00     2008-04-18 09:56:01
   286440   2008-04-17 00:00:00     2008-04-18 09:00:01
   ...

    I found that i have overlap records every day:

date(stamp_inserted)  date(stamp_updated)      count(*)

2008-04-17            2008-04-18               310
2008-04-16            2008-04-17               195
2008-04-15            2008-04-16               223
2008-04-14            2008-04-15               205
2008-04-13            2008-04-14               171
...

    Of course i haven't exact statistic by days.
    What is the matter?

    And yet one question. As i understand if connection was created at
one day and closed at next we should have two records for it with
somewhat inaccurate (several minutes/Kbytes - 'sql_refresh_time' and
may be something else) around 00:00.
    Am i correct?

    Thank you very much,
    Alex
            

-------
Доставка на дом и в офис пиццы, суши, шашлыка, напитков круглосуточно. 
Закажи сейчас! http://www.pizza.by
(017) 290-93-93, (029) 690-93-93, 555-93-93


_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists