Ok, one more issue to resolve.
The old server was still using the postfix/virtual for delivery, but the
new one is using the dovecot LDA.
Now, when an email generated locally by a cron job is delivered, this
shows in the log:
2013-12-22T10:29:55-05:00 host postfix/pickup[31400]: C67FD90F676B2:
uid=0 from=<newsrv+rkhun...@example.com>
2013-12-22T10:29:55-05:00 host postfix/cleanup[22349]: C67FD90F676B2:
message-id=<20131222152955.c67fd90f67...@smtp2.example.com>
2013-12-22T10:29:55-05:00 host postfix/qmgr[31401]: C67FD90F676B2:
from=<newsrv+rkhun...@example.com>, size=1555, nrcpt=1 (queue active)
2013-12-22T10:29:55-05:00 host dovecot: auth-worker(22365):
passwd(us...@example.com): unknown user
2013-12-22T10:29:55-05:00 host dovecot: lda(us...@example.com):
msgid=<20131222152955.c67fd90f67...@smtp2.example.com>: saved mail to INBOX
2013-12-22T10:29:55-05:00 host postfix/pipe[22361]: C67FD90F676B2:
to=<user1+rkhunter-rep...@example.com>, relay=dovecot, delay=0.06,
delays=0.02/0/0/0.04, dsn=2.0.0, status=sent (delivered via dovecot service)
2013-12-22T10:29:55-05:00 host postfix/qmgr[31401]: C67FD90F676B2: removed
The mail was delivered (as the log also clearly shows), but what is with
the 'unknown user'?
I'm not sure how I can test my maps with dovecot, but testing with
postfix shows:
# postmap -q us...@example.com mysql:/etc/postfix/maps/mysql/vmm.cf
example.com/user1/
Which is correct.
And my dovecot-sql-conf.ext contains:
driver = mysql
connect = "host=localhost dbname=db_name user=dbuser password=password"
default_pass_scheme = CRYPT
password_query = \
SELECT username AS user, password \
FROM mailbox WHERE username = '%u'
user_query = \
SELECT CONCAT('/var/vmail/', maildir) AS home \
FROM mailbox WHERE username = '%u'
iterate_query = SELECT username AS user FROM mailbox
I confirmed the db info is identical to what postfix is using.
Oh - and in order to make sure that all usernames are lowercased,
shouldn't I change '%u' above to '%Lu'?
Appreciate any suggestions on where to go next... thanks
--
Best regards,
*/Charles/*
