HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (
-   Installation/Configuration (
-   -   ISPConfig 3 + Dovecot + Squirrelmail + Sieve (

Chrisss 13th May 2010 17:19

ISPConfig 3 + Dovecot + Squirrelmail + Sieve
Hey Com!

Got a nasty Problem over here, tried for 3 days, now Im really need a helping hand.

As u can see on this topic, im tryin to get Sieve to work with my Config. But im stucked :(

Lets start:

My System: VServer, Debian 5 (Lenny)

Installed Sieve after this Tutorial (except last poin, SysCP specific):

Error Message in Squirrelmail after clicking "Filters":


Could not log on to timsieved daemon on your IMAP server localhost:2000.
Please contact your administrator.


dovecot: auth-worker(default): sql(, Password query failed: Unknown column 'disablemanagesieve' in 'where clause'
dovecot: managesieve-login: Disconnected: user=<>, method=LOGIN, rip=, lip=, TLS
Auszug /etc/squirrelmail/avelsieve-config.php:


global $sieve_preferred_sasl_mech;
$sieve_preferred_sasl_mech = 'PLAIN LOGIN DIGEST-MD5 CRYPT';
Part of /etc/dovecot/dovecot-sql.conf:


driver = mysql
connect = host=localhost dbname=dbispconfig user=ispconfig password=********************
default_pass_scheme = CRYPT

password_query = SELECT password FROM mail_user WHERE email = '%u' AND disable%Ls = 'n'
user_query = SELECT email as user, maildir as home, CONCAT(maildir, '/Maildir') as mail, uid, gid, CONCAT('maildir:storage=', quota) AS quota, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE email = '%u' AND disable%Ls = 'n'
Part of /etc/dovecot/dovecot.conf: (like in the HowTo)


protocols = imap imaps pop3 pop3s managesieve
mail_plugins = sieve
sieve seems to "listen":


telnet localhost 2000
Connected to localhost.localdomain.
Escape character is '^]'.
"SIEVE" "fileinto reject envelope vacation imapflags notify subaddress relational comparator-i;ascii-numeric regex"
OK "Dovecot ready."
Hope someone can "enlighten" me,

Thanks in forward,

Aunt Edith:

- ISPConfig

tmn99 30th December 2010 15:51

Come on man...thats an easy one to solve...;)
the problem is when Dovecot makes is query is looking for the protocol managesieve, "AND disable%Ls". And the problem is that theres no such column in the database.
The %Ls variable in Dovecot expands for the protocol he is looking, POP3, IMAP4, MANAGESIEVE.
Im working on this problem also and as soon ive got a solution then ill post it here man.

tmn99 30th December 2010 16:23


Just make this query on your databse server

ALTER TABLE `mail_user` ADD `disablesieve` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'n'

This will make a new column, disablesieve, in table mail_user.
Need to test if a new user is created the default value is updated. Should be!

Hope this helps.

schirpich 19th January 2011 04:29

Started troubleshooting same issue about an hour ago and upon looking through my logs and finding database missing errors I eventually wandered into my dovecot-sql.conf file and found the same thing.

I have 3 servers, One for a web/ftp server, second for mysql databases, and a third for mail. Should the mysql query be run on each server since they technically are all running a MySQL server of their own?

All times are GMT +2. The time now is 21:38.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.