Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 13th May 2010, 17:19
Chrisss Chrisss is offline
Junior Member
 
Join Date: May 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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

Last edited by Chrisss; 13th May 2010 at 21:52.
Reply With Quote
Sponsored Links
  #2  
Old 30th December 2010, 15:51
tmn99 tmn99 is offline
Junior Member
 
Join Date: Jan 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Talking

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.
Reply With Quote
  #3  
Old 30th December 2010, 16:23
tmn99 tmn99 is offline
Junior Member
 
Join Date: Jan 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Talking

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.
Reply With Quote
  #4  
Old 19th January 2011, 04:29
schirpich schirpich is offline
Junior Member
 
Join Date: Jan 2011
Posts: 1
Thanks: 0
Thanked 1 Time in 1 Post
 
Default

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?
Reply With Quote
The Following User Says Thank You to schirpich For This Useful Post:
pandiyan04 (19th January 2011)
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Config uration of dovecot in ispconfig2 shafeeks Installation/Configuration 1 26th February 2010 08:13
Webmail problems with only one domain? compner Installation/Configuration 14 16th February 2010 17:59
ISPConfig, dovecot all works but now want shared folders NuttyGambler Installation/Configuration 2 9th May 2009 06:01
ISPConfig installation into multiple OpenVZ containers letezo Installation/Configuration 11 3rd March 2009 23:47
dovecot problem sojic Server Operation 21 23rd March 2008 19:22


All times are GMT +2. The time now is 02:17.


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