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"