alex a écrit :
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 ?
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
--
Acipia
|
|
Denis Cavrois
[EMAIL PROTECTED]
Tel: (0)320 28 61 67
Tel: (0)320 28 61 62
Fax: (0)320 70 57 11
Acipia
50 av. Jean-Baptiste Lebas
59100 Roubaix
Visitez notre site Web
http://www.acipia.fr
|
|
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists