[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:
<?php
$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.
Thanks,
-c
More information about the horde
mailing list