post...@ptld.com:
> I am using virtual addresses and delivery.
>
> virtual_transport = lmtp:unix:private/dovecot-lmtp
> virtual_mailbox_domains = mysql:/etc/postfix/mysql_email_domains
> virtual_mailbox_maps = mysql:/etc/postfix/mysql_email_addresses
> virtual_alias_maps = mysql:/etc/postfix/mysql_email_aliases
>
> In the virtual_alias_maps i put a catch all "@example.com" that returns
> (right hand side of table) an address "u...@example.com" which is valid
> in the virtual_mailbox_maps. In the lookup source file
> (mysql_email_aliases) if i include "domain=example.com" then delivery
> fails "User unknown in virtual mailbox table". If i removed the domain
> entry from the source file then catch-all addressing works.
It is working exactly as documented in mysql_table(5).
- With "domain=example.com" the Postfix MySQL client will return
NOTFOUND for queries with a partial email address.
- Therefore the Postfix MySQL client will return NOTFOUND for the
query with "@example.com".
Alternatives:
- Don't use "domain=example.com", and waste some cycles with partial
address queries.
- Perhaps MySQL has a query wildcard mechanism.
- Perhaps you can use a regexp or pcre table that returns
"u...@example.com" for all queries that end in "@example.com"
Wietse
