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 gets

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 forab...@kasdi

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 | doma

Re: Mail Alias Stores in mySQL Not working

2017-10-12 Thread Bill Shirley
Do you have an SQL entry for ab...@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

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 and

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: m

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 found

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 CONCAT('/var/vmail/ma

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 your

Mail Alias Stores in mySQL Not working

2017-10-10 Thread 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 CONCAT('/var/vmail/mail/', maildir) AS home, 5000 AS uid, 5000 AS

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`; ++--+--+-+

Mail Alias Stores in mySQL Not working

2017-10-09 Thread jason hirsh
This apparently was a problem that i was not aware since i redid my mail server configuration to make use of Postfixadmin. I have update the conf files using the postfix document fromthe down load. The download document seems to be fpr an early version of dovecot (I am using 2.2.4) as it focuse