Do you have an SQL entry for abuse at 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 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