-----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(u...@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(u...@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 <skdove...@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 <u...@domain2.com> is right command ? >>>> >>>> doveadm user -u <u...@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 u...@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 u...@domain2.com > > 2013/9/24 Steffen Kaiser <skdove...@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+dove...@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 >>>>> <u...@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 >>>>> <skdove...@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.kai...@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-----