alex
Fri, 18 Apr 2008 06:24:20 -0700
>> 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?
>>
>
> You seems to have a problem with GMT and local time. Do you have now
>insert stamp with this day (18/04/2008) ? What is the last stamp_updated
>(date and time) which has 17/04/2008 as stamp inserted ?
No Denis.
I have identical time on both machines (with 'pmacctd-nfprobe' and
with 'nfacctd'). You can see last five records with
stamp_inserted=17/04/2008
and stamp_updated=18/04/2008. Totally them 310. But this is very little
part of all records of this day (22 249).
>> 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