OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: mynetworks from mysql

From: Aaron P. Martinez (mlproficuous.com)
Date: Fri Apr 09 2004 - 09:44:40 CDT


On Fri, 2004-04-09 at 04:37, Magnus Bäck wrote:
> On Friday, April 09, 2004 at 11:16 CEST,
> Tema Zelikin <gunslingeruts.komi.elektra.ru> wrote:
>
> > Friday, April 9, 2004, 12:14:35 PM, you wrote:
>
> [...]
>
> > MB> Yes. Read the first paragraph of the documentation section referred to
> > MB> below.
> > MB> http://www.porcupine.org/postfix-mirror/newdoc/DATABASE_README.html#lists_again
> >
> > thanks.. but this is very bad :(
>
> It is the way it has got to work. Matching IP addresses against
> netblocks cannot be done with simple queries, unless the SQL server
> has got some special function for such matching.
There is a patch to do full mysql lookups for postfix, you could apply
this patch and try it again.
>
> I really hope you have lots and lots of netblocks in mynetworks, and not
> just the three listed. Using MySQL lookups for that would be ridiculous.

Aaron