Re: Using mysql for mynetworks

2 msg	Remote backup Postfix server
7 msg	chose interface for outgoing mail
2 msg	Illegal address syntax ... in MAIL command: <...
1 msg	Mail Infrastructure and Zertificon
1 msg	sasl password
6 msg	postfix TLS (configuration/user) problem
7 msg	Virtual Alias Domain
3 msg	copy of email
2 msg	DNS Caching?

Using mysql for mynetworks
\ Keith (12 Mar 2008)
. \ Magnus Bäck (12 Mar 2008)
. . \ Keith (12 Mar 2008)
. . . \ mouss (12 Mar 2008)
. . . . \ Keith (12 Mar 2008)

5 msg	Blocking e-mail from a domain, to a particular ...
5 msg	prevent open relay
15 msg	cannot get mail from outside to my smtp server
6 msg	Error connecting Postfix to LDAP
5 msg	Config ok for TLS/SASL/Client Cert via port 587?
7 msg	mail flow architecture
3 msg	virtual forward + deliver
1 msg	Re: RESOLVED: Using Canonical Maps as an Overri...
14 msg	dual mail server
3 msg	how to specify different outgoing IP

Subject:	Re: Using mysql for mynetworks
Group:	Postfix-users
From:	Keith
Date:	12 Mar 2008

On Wed, 12 Mar 2008, mouss wrote:

|->if you really want to put cidr nets in mysql, then you can either use
|->inet_aton or between depending how you store the networks.
|->
|->you can have {network, mask, action} columns, in which case you can use
|->
|->query = select action where '%s' & mask = network & mask
|->
|->an alternative is to store {start, end, action} where start and end are
|->the first and last IP in "binary" form (a 32 bits integer). then you can
|->use between.
|->
|->In both cases, you'll have a problem with hostnames (inet_aton error).
|->you can "prevent" this using a REGEXP call. but then it's too much,
|->isn't it?
|->
|->if what you want is the ability to manage the infos in mysql, then do
|->that but dump the table (periodically or at update time).

After seeing whats involved with that, I prefer to keep it simple and a
flat text file is as simple as it gets. That file changes so rarely its
not worth the effort to store it into a database.

Thanks for the info though.
Keith