[Dovecot] Fwd: lmtp

[Steffen]

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

Lampa wrote:
> After home to user and password query, log contains weird messages
> 
> 2013-09-24T14:15:38.704140+02:00 server dovecot:
> imap(user at domain.com): Error:
> stat(/home/mail/domain.com/user/.dovecot.lda-dupes/tmp) failed:
> Not a directory 2013-09-24T14:15:38.724371+02:00 server dovecot:
> imap(user at domain.com): Error:
> stat(/home/mail/domain.com/user/.dovecot.svbin/tmp) failed: Not a 
> directory

How does your /etc/dovecot/dovecot-sql.conf.ext looks now?
Did you changed something else?

> 2013/9/24 Steffen Kaiser <skdovecot at smail.inf.fh-brs.de>
> 
> 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
>>>>>>> 

>> 
> 

- -- 

Steffen Kaiser

H Bonn-Rhein-Sieg         | e-mail: Steffen.Kaiser at H-BRS.DE
FB Informatik             |
Grantham-Allee 20         | phone : +49 2241/865-203
53757 Sankt Augustin      |
Germany - Deutschland     | fax   : +49 2241/865-8203

- -- 
Steffen
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)
Comment: Using GnuPG with undefined - http://www.enigmail.net/

iQEVAwUBUkGQ0F3r2wJMiz2NAQJeTwf7B/gz2z/RQ5i6mk++XRQRy2coOJpU0CUL
/sZdV2UxqDZCMoHjjcUCQvCUZVB6TCiOer7nvulAQxsV3cQ9fRvnAHGW8GCqrNUr
GQ5FyGqBhrt3LdPD8fhMpFoUKo1Yi4pOzFOG3VXy9+oo5YAbM+ad71kwtqetV0CK
CP28/JEveWjhWW0dAAB0giOzyujINu5hrWUvWpikCbInQ+sqpD3CJwajh9Tq6gh2
9C/F1cqHgUsTeCqOTsfGTEJfXTVtQgqlInXn9ljwdmPTeiqWp3BXKph+XINYZSMK
6KgK7WexdeNM48qx0EWry9VAHY4aL8jA6IQciIkJCO546NsYTWkjLQ==
=1jE2
-----END PGP SIGNATURE-----