Re: Mail Alias Stores in mySQL Not working - SOLVED

2017-10-12 Thread jason hirsh
"You have the alias ab...@kasdivi.com for the address ad...@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

Re: Mail Alias Stores in mySQL Not working

2017-10-12 Thread jason hirsh
"So ab...@kasdivi.com is an alias, not a user.? You can't login with an alias because your user_query is looking at the`mailbox` table. Have your tried logging in as: ad...@theoceanwindow.com OR you could put an entry

Re: Mail Alias Stores in mySQL Not working

2017-10-12 Thread Bill Shirley
So ab...@kasdivi.com is an alias, not a user.  You can't login with an alias because your user_query is looking at the`mailbox` table. Have your tried logging in as: ad...@theoceanwindow.com OR you could put an entry forab...@kasdivi.com in your `mailbox` table. Bill On 10/12/2017 11:24 AM,

Re: Mail Alias Stores in mySQL Not working

2017-10-12 Thread Christian Kivalo
Am 12. Oktober 2017 17:24:49 MESZ schrieb jason hirsh : > > >"Do you have an SQL entry for ab...@kasdivi.com > ? > >Bill” > > >One of my first thoughts > > >mysql> SELECT `address`, `domain`, `goto` FROM `alias` LIMIT 8;

Re: Mail Alias Stores in mySQL Not working

2017-10-12 Thread jason hirsh
"Do you have an SQL entry for ab...@kasdivi.com ? Bill” One of my first thoughts mysql> SELECT `address`, `domain`, `goto` FROM `alias` LIMIT 8; +---++--+ | address |

Re: Mail Alias Stores in mySQL Not working

2017-10-12 Thread 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

Re: Mail Alias Stores in mySQL Not working

2017-10-11 Thread Bill Shirley
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:

Re: Mail Alias Stores in mySQL Not working

2017-10-11 Thread jason hirsh
"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.” stored by domain or at least it was until i started messing with mysql "Have you checked your MySQL log file to see the actual query?” hmm

Re: Mail Alias Stores in mySQL Not working

2017-10-10 Thread Alex JOST
Am 10.10.2017 um 19:06 schrieb jason hirsh: 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

Re: Mail Alias Stores in mySQL Not working

2017-10-10 Thread Bill Shirley
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

Re: Mail Alias Stores in mySQL Not working

2017-10-10 Thread Bill Shirley
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 Here is my setup: MySQL (root@localhost) [sys_mail]> SHOW COLUMNS FROM `Virtual_User`;