Hello,
is thought that home is enough to delivery for LDA/LMTP. On old version was using LDA and works ok.
Added user to user_query and we will see if helps.
BTW doveadm user -u <user@domain2.com> is right command ?
doveadm user -u <user@domain2.com>: -bash: syntax error near unexpected token `newline'
doveadm user -u user@domain2.com user: invalid option -- 'u' doveadm user [-a <userdb socket path>] [-x <auth info>] [-f field] [-m] <user mask> [...]
2013/9/24 Steffen Kaiser <skdovecot@smail.inf.fh-brs.de>
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On Tue, 24 Sep 2013, Lampa wrote:
Date: Tue, 24 Sep 2013 10:42:41 +0200
From: Lampa <lampacz+dovecot@gmail.com> To: dovecot@dovecot.org Subject: Re: [Dovecot] Fwd: lmtp
driver = mysql
password_query = SELECT CONCAT(u.uzivatel, '@', d.domena) AS user, u.heslo AS password, CONCAT('/home/mail/', d.domena, '/', u.uzivatel) AS userdb_home, 111 AS userdb_uid, 114 AS userdb_gid, u.quota AS userdb_quota_rule, 'Trash:ignore' AS userdb_quota_rule2 FROM uzivatele AS u JOIN domeny AS d ON d.id = u.domeny_id WHERE u.domeny_id = (SELECT a.domeny_id_realna FROM domeny_aliasy AS a JOIN domeny AS d ON d.id = a.domeny_id_alias JOIN domeny AS dd ON dd.id = a.domeny_id_realna WHERE d.domena = '%d' AND d.priznak & 2 = 2 AND d.priznak & 1 = 0 AND dd.priznak & 1 = 0 UNION SELECT id FROM domeny WHERE domena = '%d' AND priznak & 2 = 0 AND priznak & 1 = 0) AND u.uzivatel = '%n' AND u.priznak & 1 = 0
user_query = SELECT CONCAT('/home/mail/', d.domena, '/', u.uzivatel) AS home, 111 AS uid, 114 AS gid, u.quota AS quota_rule, 'Trash:ignore' AS quota_rule2 FROM uzivatele AS u JOIN domeny AS d ON d.id = u.domeny_id WHERE u.domeny_id = (SELECT a.domeny_id_realna FROM domeny_aliasy AS a JOIN domeny AS d ON d.id = a.domeny_id_alias JOIN domeny AS dd ON dd.id = a.domeny_id_realna WHERE d.domena = '%d' AND d.priznak & 2 = 2 AND d.priznak & 1 = 0 AND dd.priznak & 1 = 0 UNION SELECT id FROM domeny WHERE domena = '%d' AND priznak & 2 = 0 AND priznak & 1 = 0) AND u.uzivatel = '%n' AND u.priznak & 1 = 0
Dunno, if that applies in your situation, but the user_query does not return "user", hence, "doveadm user -u <user@domain2.com>" should return domain2.com as domain. If this applies to LMTP as well, you could try, because there will be no password query before to fill the prefetch userdb.
user_query = SELECT CONCAT(u.uzivatel, '@', d.domena) AS user, ... as above
2013/9/24 Steffen Kaiser <skdovecot@smail.inf.fh-brs.de**>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Tue, 24 Sep 2013, Lampa wrote:
a) i think not necessary because of b)
b) yes password_query and user_query always returns rewrited domain (returns main domain, not aliased domain)
configs: http://pastebin.com/PuZZZ5Pg http://pastebin.com/eJrp769z
What's your /etc/dovecot/dovecot-sql.conf.****ext ?
- -- Steffen Kaiser -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux)
iQEVAwUBUkFPRF3r2wJMiz2NAQKydg******f9GRWttd8azegc0CelpofrFZotbCXZ** **a4r9 5PqkKShwNWMB0qj+****maVo9Wm4wTkIEAKAqC2oExkNDNkErw****UVaBGQClx6TcQmDum2 PcjEsFMEK2nsmlhv3HvfcIhMvKexge****sPefWvLf+RsfUT1/****ClOgdgaNTGxYIfGelp 5s/****Z9DzH65U65ngWYyCmydHkRoAkUf+****tMqw874hgGkAgaY9ZYApDx9yGmpQkm** **J1t Q0VWGCnCa8V5h3pHigucWlKtGsg3/******deK0fh6XVsKqjTe0W51MdbXq8Lc39V** **oPm4P KW4YJVMgavRipBXOfVzs2mE1ikxF8M****whCNRfLO3c/DBd6924/X774A== =wOak -----END PGP SIGNATURE-----
- -- Steffen Kaiser -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux)
iQEVAwUBUkFTK13r2wJMiz2NAQK0+**gf/YGFvZQNrZGCKEwU+**jRjyXtBeQRBD/AHB JgP2TD0hPnqWdR10ad5BJI++**oMmLMm9sDOzgBiTmDw1NgYGomVLcXs**lgkkxLgKHw 5IJw3Pa28HwdKa6SWAScAbvPffLipO**PNjzR5c/**h5VtakImR8I0V2jAqg7uBuiSlO LFQSeYIiyNheLZ+**vtl1GDV3XPbzRoxNezuQwwYELuGmvA**ijA/2ZUng52Z055+Pm1 LQlYWSXw3WZZjxmNRriAcBDNd7tok6**iBJO4RMdcDcPriRm4ojl9y4kc6vHYG**jSTr BFg/d5qxamwSPa6gra03b02BZ/**hMPBRfmlDekmomWuru0sC2ZUr+xg== =Q8vZ -----END PGP SIGNATURE-----