Mail Alias Stores in mySQL Not working

jason hirsh hirshj at att.net
Tue Oct 10 20:06:13 EEST 2017


First of all excuse.. I am having an issue getting maillist responses so I may be responding to this worng

No on topic
I commented out the first user_quesry

The second query was not copied correctly  , reads

user_query = SELECT CONCAT('/var/vmail/mail/', maildir) AS home, 5000 AS uid, 5000 AS gid, CONCAT('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%u' AND active=‘1'

still have the same error

I did a comparison between the data contained in the sql file and my mail directory and found that they are not consistent

Apparently postfixadmin, which I have been using, does not update the maildir

I am surprised I am getting any mail at all.

I think I have to take this back to ground zero

"I see two problems:
1) you have two user_querys, there should only be one
2) your 2nd user_query is not limiting the SQL search with a WHERE clause"



More information about the dovecot mailing list