Do you have an SQL entry for abuse@kasdivi.com ?

Bill

On 10/12/2017 9:31 AM, jason hirsh wrote:

"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@theoceanwindow.com | theoceanwindow.com | theoceanwindow.com/jason/ | | admin@gcsbonaire.com | gcsbonaire.com | gcsbonaire.com/admin/ | | admin@theoceanwindow.com | theoceanwindow.com | theoceanwindow.com/admin/ | | test@theoceanwindow.com | theoceanwindow.com | theoceanwindow.com/test/ | | lin@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@kasdivi.com): unknown user

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