Re: Postfix frontend on existing MySQL DB (routing problems)

6 msg	How to reinstall postfix
9 msg	content filter - Altermime
14 msg	Service with perl in argv

Postfix frontend on existing MySQL DB (routing ...
\ Simone Felici (28 Jun 2007)
. \ mouss (28 Jun 2007)
. . \ Simone Felici (28 Jun 2007)
. . . \ mouss (28 Jun 2007)
. . . . \ Simone Felici (28 Jun 2007)
. . . . . \ mouss (28 Jun 2007)
. . . . . . \ Simone Felici (29 Jun 2007)
. . . . . . . \ mouss (29 Jun 2007)
. . . . . . . . \ Simone Felici (29 Jun 2007)
. . . . . . . . . \ mouss (29 Jun 2007)
. . . . . . . . . . \ Simone Felici (29 Jun 2007)
. . . . . . . . . . . \ mouss (29 Jun 2007)
. . . . . . . . . . . . \ mouss (29 Jun 2007)
. . . . . . . . . . . . . \ Simone Felici (2 Jul 2007)
. . . . . . \ Simone Felici (29 Jun 2007)
. . . . . \ mouss (28 Jun 2007)

3 msg	postfix and mysql
5 msg	postfix do not send the raiables to maildrop
2 msg	Masquerading
1 msg	Relay and Domain masquerading
4 msg	active queue and courier maildrop
5 msg	SASL2 - loose error message
5 msg	Setting up an intranet mail server
2 msg	simple smtp outbound how-to
1 msg	How to determine relay domains through check_po...
3 msg	message size limit per recipient
33 msg	Empty pflogsumm Reports
7 msg	Send On Behalf Of A User?
6 msg	multiple content_filters
4 msg	Blocked by policy mailin.rzone.de
7 msg	Build with support for both cyrus-sasl and dove...
14 msg	content filter help

Subject:	Re: Postfix frontend on existing MySQL DB (routing problems)
Group:	Postfix-users
From:	mouss
Date:	29 Jun 2007

mouss wrote:
>
> Before you get mad, here is how a way to solev your problem:
>
> query = SELECT CONCAT('smtp:', next) FROM smtproutes where
> domain = '%d' and %u = IF(account = '', %u, account)

silly me, this is the same as OR. don't use it.

use this:
>
>
> query = SELECT CONCAT('smtp:', next) FROM smtproutes where
> domain = '%d' and
> (acount = '%u' or account = '')
> order by length(account) desc limit 1

an approach that doesn't require "advanced" sql statements is:

transport_maps =
proxy:mysql:/path/to/transport_users.cf
proxy:mysql:/path/to/transport_domains.cf

in transport_users, use the query with '%u' = account
in transport_domains, use the same query but with '%u' = ''