[horde] Getting horde to authenticate against dovecot DB

Coy Hile coy.hile at coyhile.com
Tue Aug 20 10:24:37 UTC 2019

You were correct that all I needed was the following in conf.php:

$conf['auth']['params']['query_auth'] = 'SELECT * FROM users WHERE username=\L AND password=CONCAT(\'{SHA512-CRYPT}\',\P)';
$conf['auth']['params']['query_getpw'] = 'SELECT SUBSTRING_INDEX(password,\'}\',-1) FROM users WHERE username = \L';
$conf['auth']['params']['encryption'] = 'crypt-sha512';
$conf['auth']['params']['show_encryption'] = false;
$conf['auth']['driver'] = 'customsql’;

And in imp/backends.local.php, I have:

$servers['imap']['hordeauth'] = true;
$servers['imap'] = array(
	'disabled' => false,
	'name' => 'coyhile.com IMAP',
	'hostspec' => 'imap.coyhile.com',
	'protocol' => 'imap',
	'secure' => 'tls'

However, I’m still prompted a second time to login to mail. Am I missing something else?

Then to figure out ActiveSync.


More information about the horde mailing list