Timo Sirainen kirjoitti 2011-11-24 kello 21:29:46:
It would be better if you used PostfixAdmin's "maildir" field as the home directory, and then mail_location=~/Maildir.
Thank you, Timo! (And thank you, Tom, for the simplification example!) I never thought ~/Maildir could refer to anything but UNIX system users! :)
Timo's queries (beneath) work indeed. However, it took quite a while of testing, and I wonder if it really would cause some trouble if homedir and maildir were kept the same...
Regards, Olli
Like the sql queries being:
password_query =
SELECT username AS user, password,
CONCAT('/home/vmail/', maildir) AS userdb_home,
CONCAT('*:bytes=', quota) AS userdb_quota_rule
FROM mailbox
WHERE username = '%u' and ACTIVE = '1'user_query =
SELECT CONCAT('/home/vmail/', maildir) AS home,
CONCAT('*:bytes=', quota) AS quota_rule
FROM mailbox
WHERE username = '%u' AND active = '1'I used these in another PostfixAdmin server's install.