Hi there,
I did install roundcube on a ubuntu 12.04 box using apt-get I also installed some plugins also using apt-get managesieve version: 5.0
and activated the plugins: $rcmail_config['plugins'] = array('managesieve', 'password'); then in managesieve/config.inc.php I changed the port to 4190
// managesieve server port $rcmail_config['managesieve_port'] = 4190; // managesieve server address, default is localhost. $rcmail_config['managesieve_host'] = 'localhost';
Non the filter tab is presented in the roudcube but click it gives a "not able to access sieve server" error (or some such, I get it in german) and in the rouncube log I get the following error:
[25-Dec-2012 09:47:54 +0100]: PHP Error: Unable to connect to managesieve on localhost:4190 in /usr/share/roundcube/plugins/managesieve/managesieve.php on line 286 (GET /?_task=settings&_action=plugin.managesieve)
however, if I try to access this port using telnet, it seems to work. root@susanne ~ # telnet localhost 4190 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. "IMPLEMENTATION" "Dovecot Pigeonhole" "SIEVE" "fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date ihave" "NOTIFY" "mailto" "SASL" "PLAIN" "STARTTLS" "VERSION" "1.0" OK "Dovecot ready."
unfortunately I am not a php programmer so I would not know how to debug this.
for any pointers on how to solve this problem would be very much appreciated.
have a good holiday season robert
On 12/25/2012 11:31 AM, robert rottermann wrote:
[25-Dec-2012 09:47:54 +0100]: PHP Error: Unable to connect to managesieve on localhost:4190 in /usr/share/roundcube/plugins/managesieve/managesieve.php on line 286 (GET /?_task=settings&_action=plugin.managesieve)
There can be a couple of reasons for this message. Enable debug in managesieve plugin and check the log.
On 12/25/2012 11:49 AM, A.L.E.C wrote:
On 12/25/2012 11:31 AM, robert rottermann wrote:
[25-Dec-2012 09:47:54 +0100]: PHP Error: Unable to connect to managesieve on localhost:4190 in /usr/share/roundcube/plugins/managesieve/managesieve.php on line 286 (GET /?_task=settings&_action=plugin.managesieve)
There can be a couple of reasons for this message. Enable debug in managesieve plugin and check the log.
Ah, thanks Alex, no I get a the following: root@susanne ~ # tail -f /var/log/roundcube/sieve [25-Dec-2012 12:21:15 +0100]: S: "SIEVE" "fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date ihave" [25-Dec-2012 12:21:15 +0100]: S: "NOTIFY" "mailto" [25-Dec-2012 12:21:15 +0100]: S: "SASL" "PLAIN" [25-Dec-2012 12:21:15 +0100]: S: "STARTTLS" [25-Dec-2012 12:21:15 +0100]: S: "VERSION" "1.0" [25-Dec-2012 12:21:15 +0100]: S: OK "Capability completed." [25-Dec-2012 12:21:15 +0100]: C: AUTHENTICATE "PLAIN" "AHJvYmVydEByZWRjb3IuY2gAY29jbzJkaWw=" [25-Dec-2012 12:21:17 +0100]: S: NO "Authentication failed." [25-Dec-2012 12:21:17 +0100]: C: LOGOUT [25-Dec-2012 12:21:17 +0100]: S: OK "Logout completed."
now I am WAY above my head. If I interpret that log entry correctly, roundcube tries to log in using a password but fails. Where does that password come from? Why does it not use the one that was used to log into roundcube?
what next.
thanks robert
On 12/25/2012 12:35 PM, robert rottermann wrote:
25-Dec-2012 12:21:15 +0100: S: OK "Capability completed." 25-Dec-2012 12:21:15 +0100: C: AUTHENTICATE "PLAIN" "AHJvYmVydEByZWRjb3IuY2gAY29jbzJkaWw=" [25-Dec-2012 12:21:17 +0100]: S: NO "Authentication failed." [25-Dec-2012 12:21:17 +0100]: C: LOGOUT [25-Dec-2012 12:21:17 +0100]: S: OK "Logout completed."
now I am WAY above my head. If I interpret that log entry correctly, roundcube tries to log in using a password but fails. Where does that password come from? Why does it not use the one that was used to log into roundcube?
It uses the same password. Try with enabled managesieve_usetls option.
On 12/25/2012 03:59 PM, A.L.E.C wrote:
On 12/25/2012 12:35 PM, robert rottermann wrote:
25-Dec-2012 12:21:15 +0100: S: OK "Capability completed." 25-Dec-2012 12:21:15 +0100: C: AUTHENTICATE "PLAIN" "AHJvYmVydEByZWRjb3IuY2gAY29jbzJkaWw=" [25-Dec-2012 12:21:17 +0100]: S: NO "Authentication failed." [25-Dec-2012 12:21:17 +0100]: C: LOGOUT [25-Dec-2012 12:21:17 +0100]: S: OK "Logout completed."
now I am WAY above my head. If I interpret that log entry correctly, roundcube tries to log in using a password but fails. Where does that password come from? Why does it not use the one that was used to log into roundcube?
It uses the same password. Try with enabled managesieve_usetls option.
thanks, I did so but it does still not accept connections. here are the log entries of a failed session. The mail server (dovecot, postcript, mysql) does work using plain passwords with no security. So I *think* tls is not involved.
more ideas? thanks again robert
25-Dec-2012 23:10:37 +0100: S: "SIEVE" "fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date ihave" 25-Dec-2012 23:10:37 +0100: S: "NOTIFY" "mailto" 25-Dec-2012 23:10:37 +0100: S: "SASL" "PLAIN" 25-Dec-2012 23:10:37 +0100: S: "STARTTLS" 25-Dec-2012 23:10:37 +0100: S: "VERSION" "1.0" 25-Dec-2012 23:10:37 +0100: S: OK "Dovecot ready." 25-Dec-2012 23:10:37 +0100: C: CAPABILITY 25-Dec-2012 23:10:37 +0100: S: "IMPLEMENTATION" "Dovecot Pigeonhole" 25-Dec-2012 23:10:37 +0100: S: "SIEVE" "fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date ihave" 25-Dec-2012 23:10:37 +0100: S: "NOTIFY" "mailto" 25-Dec-2012 23:10:37 +0100: S: "SASL" "PLAIN" 25-Dec-2012 23:10:37 +0100: S: "STARTTLS" 25-Dec-2012 23:10:37 +0100: S: "VERSION" "1.0" 25-Dec-2012 23:10:37 +0100: S: OK "Capability completed." 25-Dec-2012 23:10:37 +0100: C: STARTTLS 25-Dec-2012 23:10:37 +0100: S: OK "Begin TLS negotiation now." 25-Dec-2012 23:10:37 +0100: STARTTLS negotiation successful 25-Dec-2012 23:10:37 +0100: S: "IMPLEMENTATION" "Dovecot Pigeonhole" 25-Dec-2012 23:10:37 +0100: S: "SIEVE" "fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date ihave" 25-Dec-2012 23:10:37 +0100: S: "NOTIFY" "mailto" 25-Dec-2012 23:10:37 +0100: S: "SASL" "PLAIN" 25-Dec-2012 23:10:37 +0100: S: "VERSION" "1.0" 25-Dec-2012 23:10:37 +0100: S: OK "TLS negotiation successful." 25-Dec-2012 23:10:37 +0100: C: CAPABILITY 25-Dec-2012 23:10:37 +0100: S: "IMPLEMENTATION" "Dovecot Pigeonhole" 25-Dec-2012 23:10:37 +0100: S: "SIEVE" "fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date ihave" 25-Dec-2012 23:10:37 +0100: S: "NOTIFY" "mailto" 25-Dec-2012 23:10:37 +0100: S: "SASL" "PLAIN" 25-Dec-2012 23:10:37 +0100: S: "VERSION" "1.0" 25-Dec-2012 23:10:37 +0100: S: OK "Capability completed." 25-Dec-2012 23:10:37 +0100: C: AUTHENTICATE "PLAIN" "AHJvYmVydEByZWRjb3IuY2gAY29jbzJkaWw=" [25-Dec-2012 23:10:39 +0100]: S: NO "Authentication failed."
On 12/25/2012 03:59 PM, A.L.E.C wrote:
On 12/25/2012 12:35 PM, robert rottermann wrote:
25-Dec-2012 12:21:15 +0100: S: OK "Capability completed." 25-Dec-2012 12:21:15 +0100: C: AUTHENTICATE "PLAIN" "AHJvYmVydEByZWRjb3IuY2gAY29jbzJkaWw=" [25-Dec-2012 12:21:17 +0100]: S: NO "Authentication failed." [25-Dec-2012 12:21:17 +0100]: C: LOGOUT [25-Dec-2012 12:21:17 +0100]: S: OK "Logout completed."
now I am WAY above my head. If I interpret that log entry correctly, roundcube tries to log in using a password but fails. Where does that password come from? Why does it not use the one that was used to log into roundcube?
It uses the same password. Try with enabled managesieve_usetls option.
Thanks Alec for your help, the problem was, that with the mail database I use which was created some years ago by the now defunct syscon tool suite a sql query was generated that failed when service was sieve.
For the sake of other that might run into the same problem my fix:
The failing query was like this (in the dovecot configuration): password_query = SELECT username AS user, password_enc AS password, CONCAT(homedir, maildir) AS userdb_home, uid AS userdb_uid, gid AS userdb_gid, CONCAT('maildir:', homedir, maildir) AS userdb_mail, CONCAT('maildir:storage=', (quota*1024)) as userdb_quota FROM mail_users WHERE (username = '%u' OR email = '%u') AND ((imap = 1 AND '%Ls' = 'imap') OR (pop3 = 1 AND '%Ls' = 'pop3') OR '%Ls' = 'smtp') which I changed to: password_query = SELECT username AS user, password_enc AS password, CONCAT(homedir, maildir) AS userdb_home, uid AS userdb_uid, gid AS userdb_gid, CONCAT('maildir:', homedir, maildir) AS userdb_mail, CONCAT('maildir:storage=', (quota*1024)) as userdb_quota FROM mail_users WHERE (username = '%u' OR email = '%u') AND ((imap = 1 AND '%Ls' = 'imap') OR (pop3 = 1 AND '%Ls' = 'pop3') OR '%Ls' = 'smtp' OR '%Ls' = 'sieve')
This I found out by enabling logging in dovecot.
thanks again Robert
The only thing I added is the last or condition.
How come word check NEVER works?
On 25.12.2012 06:35, robert rottermann wrote:
On 12/25/2012 11:49 AM, A.L.E.C wrote:
On 12/25/2012 11:31 AM, robert rottermann wrote:
[25-Dec-2012 09:47:54 +0100]: PHP Error: Unable to connect to managesieve on localhost:4190 in /usr/share/roundcube/plugins/managesieve/managesieve.php on line 286 (GET /?_task=settings&_action=plugin.managesieve)
There can be a couple of reasons for this message. Enable debug in managesieve plugin and check the log.
Ah, thanks Alex, no I get a the following: root@susanne ~ # tail -f /var/log/roundcube/sieve [25-Dec-2012 12:21:15 +0100]: S: "SIEVE" "fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date ihave" [25-Dec-2012 12:21:15 +0100]: S: "NOTIFY" "mailto" [25-Dec-2012 12:21:15 +0100]: S: "SASL" "PLAIN" [25-Dec-2012 12:21:15 +0100]: S: "STARTTLS" [25-Dec-2012 12:21:15 +0100]: S: "VERSION" "1.0" [25-Dec-2012 12:21:15 +0100]: S: OK "Capability completed." [25-Dec-2012 12:21:15 +0100]: C: AUTHENTICATE "PLAIN" "AHJvYmVydEByZWRjb3IuY2gAY29jbzJkaWw=" [25-Dec-2012 12:21:17 +0100]: S: NO "Authentication failed." [25-Dec-2012 12:21:17 +0100]: C: LOGOUT [25-Dec-2012 12:21:17 +0100]: S: OK "Logout completed."
now I am WAY above my head. If I interpret that log entry correctly, roundcube tries to log in using a password but fails. Where does that password come from? Why does it not use the one that was used to log into roundcube?
what next.
thanks robert _______________________________________________ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users