I have pmacct 1.7.0 installed from source on an Ubuntu 17.10 system running
MySQL 5.7. Just experimenting so far. I have specified both sql_user and
sql_passwd (and sql_table and sql_db) in the conf file, run the
initialization sql successfully, and started pmacctd like this:
On Thu, Nov 2, 2017 at 11:59 AM, Yann Belin wrote:
> Hi Nicholas,
> How is your MySQL user defined, xxx@'localhost'?
I've tried both pmacct and pmacct@localhost in the conf file, but the
result is the same. Also tried
with and without quotes.
Perhaps not related,
I also don't know if this is relevant or important, but I note that the
SQL UPDATE statements are referencing columns which do not exist in the
Here's an example; note that the schema defines column "port_src", not the
UPDATE `acct_v8` SET
For the user permission issue i would recommend trying one of the
following things: 1) adding a 'sql_host: 127.0.0.1' to your config or 2)
configuring your user as 'pmacct'@'%'. If i recall correctly, when
connecting locally you could opt for the loopback interface or the UNIX
Thanks for the kind words and the interesting email. Any chance you can
send me a brief sample of such data via unicast email so to be able to
reproduce things at my end?
On Wed, Nov 01, 2017 at 06:24:26PM +0200, edd! wrote:
> After wasting a couple of months on
It turned-out that I needed to specify the sql_passwd line with "no space"
after the colon,
such as "sql_passwd:arealsmartpwd". Then pmacctd connects OK.
But I still have schema problems, such as:
INSERT INTO `acct_v8` (vlan, ip_src, ip_dst, as_src, as_dst, port_src,