Hi Vito, I was wondering whether basic configuration directives like sql_history and sql_history_roundoff are activated in your setup, ie. to create 5 min time-bins:
sql_history_roundoff: m sql_history: 5m If you have such a thing in place and still have empty stamp_inserted then please post your configuration and the pmacct version showing the behaviour. Cheers, Paolo On Thu, Jun 23, 2011 at 04:16:50PM +0200, [email protected] wrote: > Hi all, > > i'm using pmacctd on my machine configured as a L2 bridge with a simple > mysql configuration, but when a try to select from the db i get rows > with an empty timestamp like the followinf ones: > > mysql> select src_port,dst_port,ip_proto,packets,flows,stamp_inserted > from acct_v4 ; > > +----------+----------+----------+------------------+------+--------------------+ > | src_port | dst_port | ip_proto | packets | flows| stamp_inserted > | > +----------+----------+----------+------------------+------+--------------------+ > | 80 | 53079 | tcp | 4 | 1 | 0000-00-00 > 00:00:00 | > | 53079 | 80 | tcp | 6 | 1 | 0000-00-00 > 00:00:00 | > | 37050 | 53 | udp | 2 | 1 | 0000-00-00 > 00:00:00 | > > > Any suggestions? > > king regards > vito piserchia > > > _______________________________________________ > pmacct-discussion mailing list > http://www.pmacct.net/#mailinglists _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
