[GH-ISSUE #102] Issues with installation instructions #76

New issue

Closed

opened 2026-02-26 09:35:40 +03:00 by kerem · 4 comments

kerem commented

2026-02-26 09:35:40 +03:00

Owner

Originally created by @ghost on GitHub (Jul 15, 2014).
Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/102

Just a few things I noticed that are wrong with the installation instructions:

In dovecot-sql.conf.ext, "Mailbox" was erroneously capitalized.
The password_query was completely wrong. It should be:

password_query = SELECT username as user, password as password, \
        homedir AS userdb_home, maildir AS userdb_mail, \
        concat('*:bytes=', quota) AS userdb_quota_rule, uid AS userdb_uid, gid AS userdb_gid \
    FROM mailbox \
        WHERE username = '%Lu' AND active = '1' \
            AND ( access_restriction = 'ALL' OR LOCATE( '%Us', access_restriction ) > 0 )

Also, in /etc/dovecot/conf.d/10-auth.conf, auth_mechanisms should be set accordingly:

auth_mechanisms = plain login

I banged my head for an hour wondering why not MD5 nor SHA512 would work. I tried crypt:md5, md5.salted, nothing worked. Not till I changed auth_mechanisms to plain login and removed the others suggested in the configuration instructions. Now MD5 and even SHA512 work great.

Originally created by @ghost on GitHub (Jul 15, 2014). Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/102 Just a few things I noticed that are wrong with the installation instructions: 1. In dovecot-sql.conf.ext, "Mailbox" was erroneously capitalized. 2. The password_query was completely wrong. It should be: ``` password_query = SELECT username as user, password as password, \ homedir AS userdb_home, maildir AS userdb_mail, \ concat('*:bytes=', quota) AS userdb_quota_rule, uid AS userdb_uid, gid AS userdb_gid \ FROM mailbox \ WHERE username = '%Lu' AND active = '1' \ AND ( access_restriction = 'ALL' OR LOCATE( '%Us', access_restriction ) > 0 ) ``` Also, in `/etc/dovecot/conf.d/10-auth.conf`, `auth_mechanisms` should be set accordingly: ``` auth_mechanisms = plain login ``` I banged my head for an hour wondering why not MD5 nor SHA512 would work. I tried `crypt:md5`, `md5.salted`, nothing worked. Not till I changed `auth_mechanisms` to `plain login` and removed the others suggested in the configuration instructions. Now MD5 and even SHA512 work great.

kerem closed this issue

2026-02-26 09:35:40 +03:00

kerem commented

2026-02-26 09:35:41 +03:00

Author

Owner

@barryo commented on GitHub (Jul 15, 2014):

Can you provide a URL to the installation instructions you are looking at - there's a few...

@barryo commented on GitHub (Jul 15, 2014): Can you provide a URL to the installation instructions you are looking at - there's a few...

kerem commented

2026-02-26 09:35:41 +03:00

Author

Owner

@ghost commented on GitHub (Jul 15, 2014):

https://gist.github.com/barryo/8918488

The various files I mention above are shown in the URL above. (note: I'm on Debian 7.5)

@ghost commented on GitHub (Jul 15, 2014): https://gist.github.com/barryo/8918488 The various files I mention above are shown in the URL above. (note: I'm on Debian 7.5)

kerem commented

2026-02-26 09:35:41 +03:00

Author

Owner

@ghost commented on GitHub (Jul 15, 2014):

Plus, scroll down to the comments. Two users made changes I mentioned above.

@ghost commented on GitHub (Jul 15, 2014): Plus, scroll down to the comments. Two users made changes I mentioned above.

kerem commented

2026-02-26 09:35:41 +03:00

Author

Owner

@barryo commented on GitHub (Apr 2, 2016):

All updated, thanks.

@barryo commented on GitHub (Apr 2, 2016): All updated, thanks.