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

2017-11-10 Thread Nicholas Geovanis
Also reporting successful build and basic operation of pmacct 1.7.0 on up-to-date Ubuntu 16.04 LTS with the Ubuntu-repository-supplied Mysql 5.7 back end, under VMware 6.5.0 and ESXi 5.5.0. On Fri, Nov 3, 2017 at 12:34 PM, Nicholas Geovanis wrote: > >On Fri, Nov 3, 2017

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

2017-11-03 Thread Nicholas Geovanis
>On Fri, Nov 3, 2017 at 6:27 AM, Paolo Lucente wrote: >Enable sql_history. Start with 5 mins time bins then you can customise >with what you really need: >sql_history: 5m >sql_history_roundoff: m Thanks. I missed that entirely. >This is because you have set sql_num_hosts to

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

2017-11-03 Thread Paolo Lucente
Hi Nick, Inline: On Thu, Nov 02, 2017 at 05:10:31PM -0500, Nicholas Geovanis wrote: > > INSERT INTO `acct_v8` (vlan, ip_src, ip_dst, as_src, as_dst, port_src, > port_dst, tcp_flags, tos, ip_proto, agent_id, class_id, mac_src, mac_dst, > packets, bytes, flows) VALUES (0,

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,

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] 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 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 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 >