>On Fri, Nov 3, 2017 at 6:27 AM, Paolo Lucente <[email protected]> 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 <[email protected]> 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: > fe86: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
