Mail Alias Stores in mySQL Not working

[Alex JOST]

Am 10.10.2017 um 19:06 schrieb jason hirsh:
> 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"

To me this sounds like you are trying to login with an alias address. 
This will not work with such a simple query. Dovecot requires 1 
username/address per account. Aliases are generally handled by the MTA.

-- 
Alex JOST