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 <nickgeova...@gmail.com> wrote: > >On Fri, Nov 3, 2017 at 6:27 AM, Paolo Lucente <pa...@pmacct.net> 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 true. You could remove > >that or you should customise your schema. See the relevant section from > >README.mysql: > > Thanks. > I also needed to enlarge the ip_src/dest fields for IPv6. > > And after that it runs fine on Ubuntu 17.10, so thank you very much. > .....Nick G > > >https://github.com/pmacct/pmacct/blob/master/sql/README.mysql#L115-L122 > > Paolo > > > On Fri, Nov 3, 2017 at 6:27 AM, Paolo Lucente <pa...@pmacct.net> wrote: > >> >> 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, INET6_ATON('192.168.50.211'), >> > INET6_ATON('192.168.50.18'), 0, 0, 0, 0, 0, 0, '0', 0, 'unknown', >> > '0:0:0:0:0:0', '0:0:0:0:0:0', 4, 340, 0) >> > ERROR ( default_mysql/mysql ): Field 'stamp_inserted' doesn't have a >> > default value >> >> 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 >> >> > 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, INET6_ATON('fe80::5e26:aff:fe8 >> 6:58b8'), >> > INET6_ATON('ff02::fb'), 0, 0, 0, 0, 0, 0, '0', 0, 'unknown', >> '0:0:0:0:0:0', >> > '0:0:0:0:0:0', 1, 174, 0) >> > ERROR ( default_mysql/mysql ): Data too long for column 'ip_src' at row >> 1 >> >> This is because you have set sql_num_hosts to true. You could remove >> that or you should customise your schema. See the relevant section from >> README.mysql: >> >> https://github.com/pmacct/pmacct/blob/master/sql/README.mysql#L115-L122 >> >> Paolo >> > >
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists