The scripts for creating the greylisting tables create `ip` columns 16 chars wide. This is one more char than necessary for IPv4, which requires (3+1)*4 - 1 = 15 chars max to be textually represented. This is inadequate for IPv6, which may have up to (4 + 1)*(128/16) - 1 = 39 chars max. This is a Gentoo bug because the tables.sql is in ${FILESDIR}. It would be nice if gld would einfo people an ALTER TABLE statement which would help them upgrade their existing tables or do something to that effect. I used ALTER TABLE greylist MODIFY COLUMN ip CHAR(39) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'IP of Sending Host'; myself.
+*gld-1.7-r2 (12 Aug 2012) + + 12 Aug 2012; Eray Aslan <eras@gentoo.org> +gld-1.7-r2.ebuild, + files/tables.sql: + Change ip column to 39 chars in sql tables - bug #430384 +