[ingo] Ingo with Cyrus Sieve ... Authentication Fails

[Jan Schneider]

Zitat von Marc Fournier <scrappy at hub.org>:

> I’ve been running Horde since forever now, and right now am running  
> 5.1.5 / Webmail … it was just reported to me that with this new  
> version, clients can no longer authenticate to the sieve server …
>
> on the Sieve side, nothing in our configuration has changed in years  
> now … IMP connects find to the IMAP server, and if I go to the  
> command line and use sieveshell, I can login and upload / activate  
> sieve scripts … everything authenticating perfectly … but, if I go  
> in via webmail, I get what looks to be mostly perfect  
> communications, but then it fails:
>
> ===
> Feb  8 03:03:53 hub sieve[45683]: SQL backend defaulting to engine 'sqlite'
> Feb  8 03:03:53 hub sieve[45683]: executed
> Feb  8 03:03:53 hub sieve[45683]: sql auxprop plugin using sqlite engine
> Feb  8 03:03:53 hub sieve[45683]: accepted connection
> Feb  8 03:03:54 hub sieve[45683]: sql plugin Parse the username  
> scrappy at hub.org
> Feb  8 03:03:54 hub sieve[45683]: sql plugin try and connect to a host
> Feb  8 03:03:54 hub sieve[45683]: sql plugin trying to open db  
> '/var/db/sqlite/mailsys' on host ''
> Feb  8 03:03:54 hub sieve[45683]: begin transaction
> Feb  8 03:03:54 hub sieve[45683]: sql plugin create statement from  
> userPassword scrappy hub.org
> Feb  8 03:03:54 hub sieve[45683]: sql plugin doing query SELECT  
> userPassword FROM sasl_auth WHERE userid = 'scrappy at hub.org';
> Feb  8 03:03:54 hub sieve[45683]: commit transaction
> Feb  8 03:03:54 hub sieve[45683]: sql plugin Parse the username  
> scrappy at hub.org
> Feb  8 03:03:54 hub sieve[45683]: sql plugin try and connect to a host
> Feb  8 03:03:54 hub sieve[45683]: sql plugin trying to open db  
> '/var/db/sqlite/mailsys' on host ''
> Feb  8 03:03:54 hub sieve[45683]: begin transaction
> Feb  8 03:03:54 hub sieve[45683]: sql plugin create statement from  
> userPassword scrappy hub.org
> Feb  8 03:03:54 hub sieve[45683]: sql plugin doing query SELECT  
> userPassword FROM sasl_auth WHERE userid = 'scrappy at hub.org';
> Feb  8 03:03:54 hub sieve[45683]: sql plugin create statement from  
> cmusaslsecretPLAIN scrappy hub.org
> Feb  8 03:03:54 hub sieve[45683]: sql plugin doing query SELECT  
> cmusaslsecretPLAIN FROM sasl_auth WHERE userid = 'scrappy at hub.org';
> Feb  8 03:03:54 hub sieve[45683]: sql plugin: no such column:  
> cmusaslsecretPLAIN
> Feb  8 03:03:54 hub sieve[45683]: commit transaction
> Feb  8 03:03:54 hub sieve[45683]: sql plugin Parse the username  
> scrappy at hub.org
> Feb  8 03:03:54 hub sieve[45683]: sql plugin try and connect to a host
> Feb  8 03:03:54 hub sieve[45683]: sql plugin trying to open db  
> '/var/db/sqlite/mailsys' on host ''
> Feb  8 03:03:54 hub sieve[45683]: sql plugin Parse the username scrappy at org
> Feb  8 03:03:54 hub sieve[45683]: sql plugin try and connect to a host
> Feb  8 03:03:54 hub sieve[45683]: sql plugin trying to open db  
> '/var/db/sqlite/mailsys' on host ''
> Feb  8 03:03:55 hub master[84211]: process 45683 exited, status 0
> ===
>
> My backends.php look right, I think …
>
> ==
> $backends['sieve'] = array(
>     // Disabled by default
>     'disabled' => false,
>     'transport' => array(
>         Ingo::RULE_ALL => array(
>             'driver' => 'timsieved',
>             'params' => array(
>                 // Hostname of the timsieved server
>                 'hostspec' => 'mail.' .  
> preg_replace('|^webmail\.|i', '', $_SERVER["HTTP_HOST"]),
>                 // Login type of the server
>                 'logintype' => 'PLAIN',
>                 // Enable/disable TLS encryption
>                 'usetls' => true,
>                 // Port number of the timsieved server
>                 'port' => 4190,
>                 // Name of the sieve script
>                 'scriptname' => 'ingo',
>                 // Enable debugging. The sieve protocol  
> communication is logged
>                 // with the DEBUG level.
>                 'debug' => false,
>             ),
>         ),
>     ),
>     'script' => array(
>         Ingo::RULE_ALL => array(
>             'driver' => 'sieve',
>             'params' => array(
>                 // If using Dovecot or any other Sieve implementation that
>                 // requires folder names to be UTF-8 encoded, set this
>                 // parameter to true.
>                 'utf8' => false,
>              ),
>         ),
>     ),
>     'shares' => false
> );
> ==
>
> I’m at a loss as to what I’m overlooking .. as far as I can tell, by  
> the fact that older ingo versions did work, and sieveshell still  
> does work, the IMAP/Sieve server side of things *should* be correct,  
> so I’m figuring it is something I’m not seeing on the ingo side …
>
> Please advise …
>
> Thank  you ...

You might have to use a transport_auth hook, setting both 'username'  
and 'euser' to the correct values.
-- 
Jan Schneider
The Horde Project
http://www.horde.org/
https://www.facebook.com/hordeproject