> -----Original Message----- > From: pmacct-discussion-boun...@pmacct.net [mailto:pmacct-discussion- > boun...@pmacct.net] On Behalf Of Jeremy Lee > Sent: Thursday, October 01, 2009 10:37 PM > To: pmacct-discussion@pmacct.net > Subject: [pmacct-discussion] MySQL connection issues > > > 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 central database that sits on a web server. > > 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 > quite close together (70ms ping times) (b) the database traffic is very > low, (20-30 records per minute, I aggregate on subnet), and (c) I really > don't want to install MySQL on every router, for security, performance, > and maintenance reasons.
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. stig _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists