Hi Raphael,
You can set debug to true for the plugin, ie. debug[mysql]: true
(suggest in this case not to log to the screen but to a logfile,
ie. logfile: /path/to/file.log) and/or enable query log on the
MySQL server side. IMO, pick the quicker solution of the two.
Cheers,
Paolo
On Wed, Jul 02, 2014 at 12:05:45PM +0200, Raphael Mazelier wrote:
Hi Paolo,
I've seen this on ip_proto but I have no ipv6 flow activated.
And on as_path but this is more normal since as_path could be very long.
How I can view the value trying to be inserted in sql ?
regards,
Le 01/07/2014 23:31, Paolo Lucente a écrit :
Hi Raphael,
Can you dig what entry is precisely causing this? I've seen that
happening especially when enabling IPv6, ie. when pmacct tries to
insert strings like ipv6-icmp in a CHAR(4). On the other hand,
pmacct is unaware of the length of the field in the schema (nor
i'm aware MySQL, or any other supported RDBMS, offers a feature
to truncate values) so, in a few docs, i believe it's specified
correctness of the schema is user responsibility (basic but
effective).
Cheers,
Paolo
On Tue, Jul 01, 2014 at 06:34:43PM +0200, Raphael Mazelier wrote:
Hum find it, but I seems I found a bug :
with mysqld parameter :
sql_mode = TRADITIONAL
which enable strict mode, an insert failed immediatly if an error of
size or else is detected.
This is strange beacause column ip_proto is CHAR(4), that is sufficient.
I think pmacct should handle this error earlier, or truncate the
data, because when arriving in the rdbm the field is left blanked.
Regards,
Le 01/07/2014 18:20, Raphael Mazelier a écrit :
Hello Paolo,
I upgrade my system today to debian wheezy, percona-server-5.6.
Since this upgrade I have error message like :
Jul 01 18:18:01 ERROR ( out_hour/mysql ): Data too long for column
'ip_proto' at row 445
and no data are filled in the database.
How I can debug this issue ?
___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
