[Dovecot] Fwd: lmtp

[Steffen Kaiser]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 24 Sep 2013, Lampa wrote:

> is thought that home is enough to delivery for LDA/LMTP. On old version was
> using LDA and works ok.

You use:

mail_location = maildir:/home/mail/%d/%n/Maildir

and return no mail field in the SQL query. Therefore you depend on a 
correctly set "%d".

> Added user to user_query and we will see if helps.

So, you could also return "mail" :-)

> BTW doveadm user -u <user at domain2.com> is right command ?
>
> doveadm user -u <user at domain2.com>:
> -bash: syntax error near unexpected token `newline'

Well, the angle brackets are usually placeholder markers, such as <auth 
info> below, but

> doveadm user -u user at domain2.com
> user: invalid option -- 'u'
> doveadm user [-a <userdb socket path>] [-x <auth info>] [-f field] [-m]
> <user mask> [...]

you are right, -u is not correct with this particular command, hence:

doveadm user -u user at domain2.com

> 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:
>>
>>  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++**oMmLMm9sDOzgBiTmDw1NgYGomVLcXs**lgkkxLgKHw
>> 5IJw3Pa28HwdKa6SWAScAbvPffLipO**PNjzR5c/**h5VtakImR8I0V2jAqg7uBuiSlO
>> LFQSeYIiyNheLZ+**vtl1GDV3XPbzRoxNezuQwwYELuGmvA**ijA/2ZUng52Z055+Pm1
>> LQlYWSXw3WZZjxmNRriAcBDNd7tok6**iBJO4RMdcDcPriRm4ojl9y4kc6vHYG**jSTr
>> BFg/d5qxamwSPa6gra03b02BZ/**hMPBRfmlDekmomWuru0sC2ZUr+xg==
>> =Q8vZ
>> -----END PGP SIGNATURE-----
>>
>

- -- 
Steffen Kaiser
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iQEVAwUBUkF/kl3r2wJMiz2NAQLQYgf/XjwEk6K/FicasCcbIISenK1bsTYRmkkZ
ckF3ZR7kr+VZXsdWKFWdrEq+cuIkZpti054I+hRQOwp3vBPWyERvio/2mTUhRl67
RBDwd3vSnn3v4qWDc6q5RvWG3sw+nPKk0Xh+gsyYZ7I24DfXG4jOlxhUn4bw72pA
ArrHgdxiEwBHmBL8q8jncZr9dMjZ9LPPh6tIb3zCxHlX/I5lMzwE3CG2G7lDRFWI
Rz6i6oUlzSeuoG/ui7YxzGxXtxmjGns+2+3Aiwf8hcvgLmXbg3q09nngE2POoAaf
fCOELv/pBBhBIZk2vZcWknttzzKgCQBwIRZkgPs1RROMeGG76HghCA==
=IyiP
-----END PGP SIGNATURE-----