]> git.ipfire.org Git - thirdparty/ulogd2.git/commit
doc: mysql: declare MAC protocol columns unsigned
authorJeremy Sowden <jeremy@azazel.net>
Sat, 5 Nov 2022 16:54:02 +0000 (16:54 +0000)
committerPablo Neira Ayuso <pablo@netfilter.org>
Wed, 9 Nov 2022 15:07:50 +0000 (16:07 +0100)
commitcdef3764ad42e7a2daa6d2faa393c9946762d388
tree97b0f21674abc0057cff576617edb6e173f4e0cb
parent79aa980f2df9dda0c097e8f883a62f414b9e5138
doc: mysql: declare MAC protocol columns unsigned

By default, MySQL smallints are signed.  This causes problems inserting packets
for ethertypes above 0x7fff, such as IPv6 (0x86dd):

  MariaDB [ulogd]> SELECT INSERT_PACKET_FULL(...,'f4:7b:09:41:7a:71','f0:2f:74:4e:b2:f3',34525,0,NULL,NULL,NULL);
                                                                                         ^^^^^

which fails as follows:

  ERROR 1264 (22003): Out of range value for column 'mac_protocol' at row 1

Signed-off-by: Jeremy Sowden <jeremy@azazel.net>
Signed-off-by: Pablo Neira Ayuso <pablo@netfilter.org>
doc/mysql-ulogd2-flat.sql
doc/mysql-ulogd2.sql