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

Reply via email to