Re: [pmacct-discussion] MySQL options

2009-11-23 Thread Paolo Lucente 
Hi Joel,

On Sat, Nov 21, 2009 at 12:43:19PM +1100, Joel Roberts wrote:

 I need to setup traffic accounting (in and out) for each IP address, and
 then export that data to an EXTERNAL mysql database on a separate machine
 accessible via IP address. How do I go about setting up pmacct to do this?

On the pmacct side, look at the sql_host configuration directive. Look at
MySQL documentation on how to a) let the daemon listen on a TCP/IP port and
b) setup user accounts which are going to connect remotely (GRANT queries).
There are plenty of examples on how to account in/out traffic per-IP address
around - some as part of the EXAMPLES document, some on Google. 

Cheers,
Paolo


___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists

Re: [pmacct-discussion] MySQL options

2009-11-20 Thread Joel Roberts 
Hi all,

I have installed pmacct using ./configure, and then make install

All seems to have worked fine as no errors popped up in the installation.
I'm struggling with how to setup simple logging for mysql. I'll explain what
I'd like to achieve.

I need to setup traffic accounting (in and out) for each IP address, and
then export that data to an EXTERNAL mysql database on a separate machine
accessible via IP address. How do I go about setting up pmacct to do this?

Cheers,
Joel

-Original Message-
From: pmacct-discussion-boun...@pmacct.net
[mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Paolo Lucente
Sent: Saturday, November 21, 2009 3:11 AM
To: pmacct-discussion@pmacct.net
Subject: Re: [pmacct-discussion] MySQL options

Hi Joel,

On Fri, Nov 20, 2009 at 05:24:29PM +1100, Joel Roberts wrote:
 
 I'm trying to install pmacct for the first time on XenServer. I have
 installed mysql and can confirm the library files can be found:
 
 [r...@localhost pmacct-0.12.0rc3]# find / -name libmysql*
 /usr/lib/mysql/libmysqlclient.so.15
 /usr/lib/mysql/libmysqlclient.so.15.0.0
 /usr/lib/mysql/libmysqlclient_r.so.15.0.0
 /usr/lib/mysql/libmysqlclient_r.so.15

pmacct seeks for either the .a or .so library files. Hence none of
the above does match the search. Often this happens when the -devel
package is not installed; once this gets installed, it links the .so
to one of the above files and installs the headers. Can you check
whether this is the case?

Cheers,
Paolo


___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
 

__ Information from ESET NOD32 Antivirus, version of virus signature
database 4625 (20091120) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
 


___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists