Re: Mail Alias Stores in mySQL Not working
"Do you have an SQL entry for abuse@kasdivi.com <mailto:abuse@kasdivi.com> ?
Bill”
One of my first thoughts
mysql> SELECT address, domain, goto FROM alias LIMIT 8;
+-------------------------------+--------------------+--------------------------+
| address | domain | goto |
+-------------------------------+--------------------+--------------------------+
| abuse@theoceanwindow.com | theoceanwindow.com | admin@theoceanwindow.com |
| hostmaster@theoceanwindow.com | theoceanwindow.com | admin@theoceanwindow.com |
| postmaster@theoceanwindow.com | theoceanwindow.com | admin@theoceanwindow.com |
| webmaster@theoceanwindow.com | theoceanwindow.com | admin@theoceanwindow.com |
| jason@theoceanwindow.com | theoceanwindow.com | jason@theoceanwindow.com |
| admin@theoceanwindow.com | theoceanwindow.com | admin@theoceanwindow.com |
| test@theoceanwindow.com | theoceanwindow.com | test@theoceanwindow.com |
| abuse@kasdivi.com | kasdivi.com | admin@theoceanwindow.com |
+-------------------------------+--------------------+--------------------------+
8 rows in set (0.00 sec)
Am 12. Oktober 2017 17:24:49 MESZ schrieb jason hirsh <hirshj@att.net>:
"Do you have an SQL entry for abuse@kasdivi.com <mailto:abuse@kasdivi.com> ?
Bill”
One of my first thoughts
mysql> SELECT
address,domain,gotoFROMaliasLIMIT 8; +-------------------------------+--------------------+--------------------------+ | address | domain | goto
| +-------------------------------+--------------------+--------------------------+ | abuse@theoceanwindow.com | theoceanwindow.com | admin@theoceanwindow.com | | hostmaster@theoceanwindow.com | theoceanwindow.com | admin@theoceanwindow.com | | postmaster@theoceanwindow.com | theoceanwindow.com | admin@theoceanwindow.com | | webmaster@theoceanwindow.com | theoceanwindow.com | admin@theoceanwindow.com | | jason@theoceanwindow.com | theoceanwindow.com | jason@theoceanwindow.com | | admin@theoceanwindow.com | theoceanwindow.com | admin@theoceanwindow.com | | test@theoceanwindow.com | theoceanwindow.com | test@theoceanwindow.com | | abuse@kasdivi.com | kasdivi.com | admin@theoceanwindow.com | +-------------------------------+--------------------+--------------------------+ 8 rows in set (0.00 sec)
You have the alias abuse@kasdivi.com for the address admin@theoceanwindow.com in your db and all mail to these aliases should go the the admin@ mailbox. Address mapping should be done in postfix so that the recipient address that gets used on the lmtp connection to dovecot is admin@theoceanwindow.com
You probably disabled address mapping in postfix.
Christian Kivalo
So abuse@kasdivi.com is an alias, not a user. You can't login with an alias because
your user_query is looking at themailbox table.
Have your tried logging in as:
admin@theoceanwindow.com
OR
you could put an entry forabuse@kasdivi.com in your mailbox table.
Bill
On 10/12/2017 11:24 AM, jason hirsh wrote:
"Do you have an SQL entry for abuse@kasdivi.com <mailto:abuse@kasdivi.com> ?
Bill”
One of my first thoughts
mysql> SELECT
address,domain,gotoFROMaliasLIMIT 8; +-------------------------------+--------------------+--------------------------+ | address | domain | goto | +-------------------------------+--------------------+--------------------------+ | abuse@theoceanwindow.com | theoceanwindow.com | admin@theoceanwindow.com | | hostmaster@theoceanwindow.com | theoceanwindow.com | admin@theoceanwindow.com | | postmaster@theoceanwindow.com | theoceanwindow.com | admin@theoceanwindow.com | | webmaster@theoceanwindow.com | theoceanwindow.com | admin@theoceanwindow.com | | jason@theoceanwindow.com | theoceanwindow.com | jason@theoceanwindow.com | | admin@theoceanwindow.com | theoceanwindow.com | admin@theoceanwindow.com | | test@theoceanwindow.com | theoceanwindow.com | test@theoceanwindow.com | | abuse@kasdivi.com | kasdivi.com | admin@theoceanwindow.com | +-------------------------------+--------------------+--------------------------+ 8 rows in set (0.00 sec)
participants (3)
-
Bill Shirley
-
Christian Kivalo
-
jason hirsh