[Dovecot] Fwd: lmtp

[Steffen Kaiser]

-----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 at gmail.com>
> To: dovecot at 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 at 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 at 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++oMmLMm9sDOzgBiTmDw1NgYGomVLcXslgkkxLgKHw
5IJw3Pa28HwdKa6SWAScAbvPffLipOPNjzR5c/h5VtakImR8I0V2jAqg7uBuiSlO
LFQSeYIiyNheLZ+vtl1GDV3XPbzRoxNezuQwwYELuGmvAijA/2ZUng52Z055+Pm1
LQlYWSXw3WZZjxmNRriAcBDNd7tok6iBJO4RMdcDcPriRm4ojl9y4kc6vHYGjSTr
BFg/d5qxamwSPa6gra03b02BZ/hMPBRfmlDekmomWuru0sC2ZUr+xg==
=Q8vZ
-----END PGP SIGNATURE-----