Re: [pmacct-discussion] MySQL connection issues

2009-10-05 Thread Paolo Lucente
Hi Jeremy, On Mon, Oct 05, 2009 at 01:14:46PM +1000, Jeremy Lee wrote: I'm now discovering that there's often a huge time lag before the data goes into the database, ranging from a few minutes to up to an hour. I've got debug going, 20 seconds between SQL refreshes, and I get several:

Re: [pmacct-discussion] MySQL connection issues

2009-10-05 Thread Jeremy Lee
Thanks for the help, Paolo. I appreciate. Quoting only introduction to the issue for the sake of brevity; you got the reason why you get nothing for minutes, then suddenly it's all there: buffering. Perhaps try with incremental steps if you not have already done that - instead of jumping from

Re: [pmacct-discussion] MySQL connection issues

2009-10-04 Thread Jeremy Lee
Yes, that's right, the MySQL database is on another machine from pmaccd. I know this isn't the recommended setup, but (a) the machines are co-located This is not true. A modular design is generally the way to go for bigger installations. Oh, good. It seemed sensible. Both scenarios are

Re: [pmacct-discussion] MySQL connection issues

2009-10-04 Thread Jeremy Lee
Couldn't you instead configure pmacctd on the routers to use nfprobe to export netflow to the database server and then on the database server run nfacctd to collect the netflows from the routers and store to a local mysql db. That sounds needlessly complicated. I'll look into it. :-) I just

Re: [pmacct-discussion] MySQL connection issues

2009-10-04 Thread Jeremy Lee
Couldn't you instead configure pmacctd on the routers to use nfprobe to export netflow to the database server and then on the database server run nfacctd to collect the netflows from the routers and store to a local mysql db. *sigh* And maybe I would, if I could compile pmacct on the

[pmacct-discussion] MySQL connection issues

2009-10-01 Thread Jeremy Lee
Hi there, everybody! I've got pmacctd installed and running, and it's working rather nicely for what I need, except for two small issues; Some background: I have some 'router' boxes, each with a LOT of IP addresses. I'm using pmaccd and the mysql plugin on those machines to log results into a