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