rihad wrote:
Correction:
/usr/local/etc/postfix/main.cf:
mydestination = mysql:/usr/local/etc/postfix/mysql-mydestination.conf
/user/local/etc/postfix/mysql-mydestination.conf:
host = localhost
username = postfix
password = none
dbname = mail
expansion_limit = 1
query = SELECT v FROM mydestination WHERE k='%s'
I had a couple of brain farts when writing the above (incorrect host,
username specification)... This is the correct mysql-mydestination.conf
but the problem still persists:
hosts = localhost
user = postfix
password = none
dbname = mail
expansion_limit = 1
query = SELECT v FROM mydestination WHERE k='%s'
- do not return NULL. since the result is unused, simply use
query = SELECT 'blah' mydestination WHERE k='%s'
- '$myhostname' will never match because a domain name does not start
with '$'. and no, mysql won't expand that for you.
