[Dovecot] Upgrade Too 1.2.11 Broke Everything

[Steffen Kaiser]

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

On Thu, 1 Jul 2010, Marcel Grandemange wrote:

> I have had dovecot working successfully for years now, however after a
> system update , dovecot refused to start up complaing that im not using
> absolute paths.

> In regards to this file the following was changed to make it work...
>
> mail_location = mbox:~:INBOX=/var/mail/%u
>
> Used to be:
>
> mail_location = mbox:~/mail/:INBOX=/var/mail/%u

Here you don't change any relative path, but change to base dir of your 
mailboxes, that should be wrong for any user using the default path.

> user_query = SELECT maildir, concat('/var/mail/',maildir) AS home, 125 AS
> uid, 125 AS gid FROM mailbox WHERE username = '%u' AND active = '1'
>
> This query used to be:
>
> user_query = SELECT maildir, maildir AS home, 125 AS uid, 125 AS gid FROM
> mailbox WHERE username = '%u' AND active = '1'

I guess, the problem is in maildir, this is not absolute.

> Jun 29 11:52:05 thavinci dovecot: IMAP(me at thavinci.za.net):
> stat(/var/mail/me at thavinci.za.net/.imap/INBOX) failed: Not a directory

Your mysql query returns /var/mail/<<maildir>> as home directory, where 
Dovecot puts files.

Please

a) post the content of one SQL record and

b) make sure every user has an unique, writeable home directory.
http://wiki.dovecot.org/VirtualUsers/Home
(Note this applies to all user, but system users usually have an unique 
homedir)

Regards,

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

iQEVAwUBTCyghL+Vh58GPL/cAQJWfggAoK15kZRU8rnYh8EvjNQ0/L3i9QZ5Ape5
J/fwSBqfcT1V4rt2lvmYvhLVWvf/tQAM61s1IgAVpfOz5O78b2BecvkAhA3NfNjm
vT25B+RwFFzGVCUhWPrWSk84DsH5wLlnrkb10jtMXtwpvVwEAR4ecPhEjb6I7bhO
uk67a6KWyqkxHc9f8WzpoHZTiX1zCRZDeiDJkFE96fqD6ZrLdb0Fo6bHNu2rq5kx
0y3ak5Lz8X4LgEeW2EGiCJ4BzwWA4VzVDadw7MXF1cIIVCO+0g7SgNm8FQdEW3CJ
WVay/dNCyBSJ/EYiJmUM7hkYpSpMJ8lU5kI7waUq/in3Ga/mjysY4w==
=tRvl
-----END PGP SIGNATURE-----