Re: [Sqlgrey-users] SQLgrey and IPv6

[Klaus A. S. <kse...@gm...>]

Lionel Bouton wrote:

>> How does SQLgrey handle IPv6 addresses?
>=20
> I believe badly...
> I must admit I never thought of the IPv6 case.

Heheh... :-)

> I've not yet thought much about this but the main problem is that the
> current address fields aren't large enough to store every IPv6 addresses.

I'm using SQLite (v2) db.  I think SQLite supports "unlimited" storage
for strings if using TEXT instead of VARCHAR.  Well, even the size of
the VARCHAR is not respected by SQLite, so I would expect an SQLite db
to survive IPv6 addresses.

However, ...

> The second problem is in the smart and classc greylisting algorithms,

... Yes.

> Unfortunately, I've zero access to IPv6 networks so I can't test any of
> these.

Neiter have I, execept my own server (and all connections appear to
come from ::1).  However, I hope that other list members do, and mail
me...

> What I can do is changing the table layouts in 1.5.x to handle the
> maximum IPv6 address representation size (39 bytes). You should then
> switch to the 'full' greylisting method and send me examples of IPv6
> entries (I'm not sure of the layout used by Postfix, in fact I'm not
> sure Postfix decides the layout, it might be the libc).

Hm, yes, I think "full" greylisting will have to be the answer in that
case, I didn't think of that before.

> I'll ask on the Postfix mailing-list...

Meanwhile I'll look for IPv6 connections to my MX.

Cheers,

--=20
Klaus Alexander Seistrup
Copenhagen  =B7  Denmark