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
>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
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,
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,
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
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
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,
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: