[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