From coy.hile at coyhile.com  Tue Aug 20 10:24:37 2019
From: coy.hile at coyhile.com (Coy Hile)
Date: Tue, 20 Aug 2019 06:24:37 -0400
Subject: [horde] Getting horde to authenticate against dovecot DB
In-Reply-To: <20190818204657.Horde.ZzkNlLoPwFAFNdYqkdZ1D4D@tarn.theupstairsroom.com>
References: <20190817142148.Horde.8Tyjh1qaNNRvo01Q3vLZj2H@tarn.theupstairsroom.com>
 <c5e654e988cef885d720fe0244137599@coyhile.com>
 <20190818204657.Horde.ZzkNlLoPwFAFNdYqkdZ1D4D@tarn.theupstairsroom.com>
Message-ID: <BDB561A0-FB44-4BE1-B0D3-6F01437C36D1@coyhile.com>


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

From poubeline at free.fr  Tue Aug 20 15:16:23 2019
From: poubeline at free.fr (poubeline at free.fr)
Date: Tue, 20 Aug 2019 17:16:23 +0200 (CEST)
Subject: [horde] Script not updated: Connection refused
In-Reply-To: <1353210309.1896246755.1566313627155.JavaMail.root@zimbra1-e1.priv.proxad.net>
Message-ID: <397071222.1896393981.1566314183282.JavaMail.root@zimbra1-e1.priv.proxad.net>


Hi all, 


I post this question in both mailing lists as I saw some traffic about Ingo in the Horde mailing list also. 


I am currently fighting to get the Ingo application work correctly for vaccation. 
I have been able to setup correctly the backends.local.php to use the sieve driver with use of TLS for my server. 
I can activate and deactivate the vaccation filter, but when I try to save the rule for an out of office message, I get the following error : 


Script not updated: There was an error activating the script. Connection refused. 


I have used the 'debug' parameter in the backends.local.php and I do not get any trace of this script error. I had some traces when struggeling with the authentification, but not for the script update. 
In my backends.local.php, I have set this: 
$backends['sieve']['transport'][Ingo::RULE_ALL]['params']['scriptname'] = 'ingo'; 

which is the same as in backends.php 


Do you have any clue on how to get this script updated or even to get a trace of where this is failing ? 


Thanks for your help. 


Regards, 
Laurent