[Dovecot] Fwd: lmtp

[Lampa]

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



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