Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 430384 - mail-filter/gld-1.7-r1 provides tables.sql and tables.pgsql scripts incompatible with IPv6
Summary: mail-filter/gld-1.7-r1 provides tables.sql and tables.pgsql scripts incompati...
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: [OLD] Server (show other bugs)
Hardware: All Linux
: Normal normal
Assignee: Net-Mail Packages
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-08-08 05:04 UTC by Nathan Phillip Brink (binki) (RETIRED)
Modified: 2012-08-12 12:03 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Nathan Phillip Brink (binki) (RETIRED) gentoo-dev 2012-08-08 05:04:09 UTC
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.
Comment 1 Eray Aslan gentoo-dev 2012-08-12 12:03:19 UTC
+*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
+