HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   ISPConfig 3 + Dovecot + Squirrelmail + Sieve (http://www.howtoforge.com/forums/showthread.php?t=45810)

Chrisss 13th May 2010 16: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):

http://neunzehn83.de/blog/2009/12/07...p-und-dovecot/

Error Message in Squirrelmail after clicking "Filters":

Quote:

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

Quote:

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

Quote:

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

Quote:


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)

Quote:

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

Quote:

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

Thanks in forward,
Chris

Aunt Edith:

- ISPConfig 3.0.2.1

tmn99 30th December 2010 14: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 15:23

Done...

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 03: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 02:59.

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