Re: [pmacct-discussion] create my own mysql table

2009-11-17 Thread Paolo Lucente
Hi, On Mon, Nov 16, 2009 at 04:45:57PM -0600, fedora fedora wrote: DEBUG ( default/mysql ): INSERT INTO `test_1` (stamp_updated, stamp_inserted, ip_src, ip_dst, as_src, as_dst, src_port, dst_port, tcp_flags, ip_proto, packets, bytes, flows) VALUES (FROM_UNIXTIME(1258410661),

Re: [pmacct-discussion] create my own mysql table

2009-11-16 Thread fedora fedora
I still see all flow records having the same number 4294967295 in my mysql table, and debug does not seem to tell me why this happens. And I have another question about the sql_history, what exactly is this? I have read the configuration keys several time but I am still not sure. If I set it to

Re: [pmacct-discussion] create my own mysql table

2009-11-16 Thread Paolo Lucente
Hi, On Mon, Nov 16, 2009 at 11:58:14AM -0600, fedora fedora wrote: I still see all flow records having the same number 4294967295 in my mysql table, and debug does not seem to tell me why this happens. How do you mean? You see that number appearing in the debug? As writing to the database is

Re: [pmacct-discussion] create my own mysql table

2009-11-16 Thread fedora fedora
Thanks a ton for the reply! FYI, here is the debug output, DEBUG ( default/mysql ): INSERT INTO `test_1` (stamp_updated, stamp_inserted, ip_src, ip_dst, as_src, as_dst, src_port, dst_port, tcp_flags, ip_proto, packets, bytes, flows) VALUES (FROM_UNIXTIME(1258410661), FROM_UNIXTIME(1258410600),

[pmacct-discussion] create my own mysql table

2009-11-13 Thread fedora fedora
Hello, I am trying to get pmacct to pass the received the netflow data to my customized mysql table, the table name is test and has the following structure, mysql desc test; ++-+--+-+-+---+ | Field | Type| Null |

Re: [pmacct-discussion] create my own mysql table

2009-11-13 Thread fedora fedora
Thanks for the reply, i disable the daemon option and here are the error messages, i cannot put src_ip and src_as together? INFO ( default/mysql ): 131070 bytes are available to address shared memory segment; buffer size is 128 bytes. INFO ( default/mysql ): Trying to allocate a shared memory

Re: [pmacct-discussion] create my own mysql table

2009-11-13 Thread Paolo Lucente
Hi, On Fri, Nov 13, 2009 at 04:21:26PM -0600, fedora fedora wrote: Thanks for the reply, i disable the daemon option and here are the error messages, i cannot put src_ip and src_as together? INFO ( default/mysql ): 131070 bytes are available to address shared memory segment; buffer size is

Re: [pmacct-discussion] create my own mysql table

2009-11-13 Thread fedora fedora
sorry, one more question, when preparing the aggregate, does the order of the values matter? right now my aggregate is like the following aggregate: proto,src_host, dst_host, src_port, dst_port, src_as, dst_as, tcpflags,flows while the order is different in the db table, for example, protocol is

Re: [pmacct-discussion] create my own mysql table

2009-11-13 Thread Paolo Lucente
Hi, On Fri, Nov 13, 2009 at 05:10:35PM -0600, fedora fedora wrote: sorry, one more question, when preparing the aggregate, does the order of the values matter? right now my aggregate is like the following No, doesn't matter. One more question, how can i get pmacct to show the flow number in