Mail Alias Stores in mySQL Not working

[jason hirsh]

"In an earlier post you said your user_query was:

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'

Last post you said:

mail is stored at /var/mail/vhosts

and:

mail_location = maildir:/var/mail/vhosts/%d/%n

These don't agree with your user_query.”


Probably my mis-statement

"Run a MySQL query:
SELECT `username`, `domain`, `maildir` FROM `mailbox` LIMIT 5;
Let's see the value of maildir”

mysql> SELECT `username`, `domain`, `maildir` FROM `mailbox` LIMIT 5;
+--------------------------+--------------------+---------------------------+
| username                 | domain             | maildir                   |
+--------------------------+--------------------+---------------------------+
| jason at theoceanwindow.com | theoceanwindow.com | theoceanwindow.com/jason/ |
| admin at gcsbonaire.com     | gcsbonaire.com     | gcsbonaire.com/admin/     |
| admin at theoceanwindow.com | theoceanwindow.com | theoceanwindow.com/admin/ |
| test at theoceanwindow.com  | theoceanwindow.com | theoceanwindow.com/test/  |
| lin at grapestreet.com      | grapestreet.com    | grapestreet.com/lin/      |
+--------------------------+--------------------+---------------------------+
5 rows in set (0.00 sec)


"Also, lets see the output of:
ls -l /var/mail/vhosts/*”



drwxrwxr-x   4 1003  vmail  512 Jun 25  2016 camantonewfashion.com
drwxrwxr-x   4 1003  vmail  512 Sep  6  2016 filmusfamily.com
drwxrwxr-x   8 1003  vmail  512 Oct  8 13:44 gcs-bonaire.com
drwxrwxr-x   4 1003  vmail  512 Oct  5 07:40 gcsbonaire.com
drwxrwxr-x   3 1003  vmail  512 Jun 25  2016 grapestreet.com
drwxrwxr-x   5 1003  vmail  512 Jun 25  2016 grapestreetgen.com
drwxrwxr-x   5 1003  vmail  512 Jun 25  2016 grapestreetvoice.com
drwxrwxr-x  11 1003  vmail  512 Oct 11 13:37 kasdivi.com
drwx------   3 1003  vmail  512 Oct 11 13:25 test.com
drwxrwxr-x   7 1003  vmail  512 Oct 11 13:42 theoceanwindow.com




It seems that the correct information is stored in the correct place   but i get


dovecot: auth-worker(21961): sql(abuse at kasdivi.com): unknown user 

Its seems like there is a simple config thing I am not getting right
Jason