Re: [pmacct-discussion] pmacct 1.7.0, can't connect to mysql

2017-11-02 Thread Yann Belin
Hi Nicholas, How is your MySQL user defined, xxx@'localhost'? Yann On Thu, Nov 2, 2017, 17:54 Nicholas Geovanis wrote: > Hi - > 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 >

[pmacct-discussion] pmacct 1.7.0, can't connect to mysql

2017-11-02 Thread Nicholas Geovanis
Hi - 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:

Re: [pmacct-discussion] pmacct 1.7.0, can't connect to mysql

2017-11-02 Thread Nicholas Geovanis
On Thu, Nov 2, 2017 at 11:59 AM, Yann Belin wrote: > Hi Nicholas, > > How is your MySQL user defined, xxx@'localhost'? > Hi - 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,

Re: [pmacct-discussion] pmacct 1.7.0, can't connect to mysql

2017-11-02 Thread Nicholas Geovanis
I also don't know if this is relevant or important, but I note that the subsequent failing SQL UPDATE statements are referencing columns which do not exist in the acct_v8 table. Here's an example; note that the schema defines column "port_src", not the missing "src_port": UPDATE `acct_v8` SET

Re: [pmacct-discussion] pmacct 1.7.0, can't connect to mysql

2017-11-02 Thread Paolo Lucente
Hi Nicholas, 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

Re: [pmacct-discussion] nfacctd and IPFIX custom fields

2017-11-02 Thread Paolo Lucente
Hi Eddi, 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? Thanks, Paolo On Wed, Nov 01, 2017 at 06:24:26PM +0200, edd! wrote: > Hi, > > After wasting a couple of months on

Re: [pmacct-discussion] pmacct 1.7.0, can't connect to mysql

2017-11-02 Thread Nicholas Geovanis
Hi - 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, port_dst, tcp_flags,