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"
With that query, it appears everyone is sharing the same mail directory.? It, of course, depends on the value of `maildir`.? It doesn't look right. Have you checked your MySQL log file to see the actual query? We don't know your mailbox format.? Post your 'doveconf -n'. We don't know what your table layout looks like.? Post your 'SHOW COLUMNS FROM `mailbox`'. What is the on-disk directory layout for mail? Bill On 10/10/2017 1:06 PM, jason hirsh wrote:> 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"
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