More features for roundcube webmail

My webmail client roundcube can easily be extended by a bunch of plugins. I’ve installed some particularly useful ones to make my webmail client a rich webmail interface. Unfortunatly there is no plugin repository for roundcube. But there is a nice list of existing plugins here.

1. cardDAV plugin

The plugin you can find here. It’s easy to install and configure. You can use it to include eg the addressbook from owncloud to roundcube just as you would do in your “real” mail client. So you have your contacts always at hand

2. managesieve plugin

Sieve is a filter to sort mail into different folders (based eg on sender, subject, …). I’m already using it to put spam to the spam folder. Using the managesieve plugin users can easily add and manage rules for sieve.
The managesieve prtocol has to be enables in/etc/dovecot/dovecot.conf. These are the important lines:

protocols = imap imaps managesieve
 
protocol managesieve {
  listen = *:2000
  login_executable = /usr/lib/dovecot/managesieve-login
  mail_executable = /usr/lib/dovecot/managesieve
  managesieve_logout_format = bytes( in=%i : out=%o)
  managesieve_implementation_string = dovecot
}
 
plugin {
   sieve_dir=/var/vmail/cbjck.de/%n/sieve
   sieve=/var/vmail/cbjck.de/%n/dovecot.sieve
   sieve_global_path = /var/vmail/sieve/globalsieverc
}

Theoretically it should be possible to use %d in the plugin section instead of the hardcoded domain. %d is the placeholder for the domain in dovecot syntax. However sieve has recognized /var/vmail/domain/user/sieve as the correct path. The managesieve plugin unfortunatly was taking /var/vmail/user/sieve and saved the rules in the wrong place. That’s why I’m using this quick-and-dirty-fix here.

The managesieve plugin is alredy installed with roundcube and has jaust to activated iun the config.

3. spamassassin plugin

This plugin enables users to edit there preferences for spamassassin. So users can easily configure white- and blacklists from the roundcube interfacen.

Usually spamassin is saving preferences in the users home. To access preferences from roundcube the settings have to be saved in a database. This is easily configurable:

First create a database – eg spamassassin – and a user for that database with according rights. In this database create a table userpref:

CREATE TABLE userpref (
  username varchar(100) NOT NULL default '',
  preference varchar(30) NOT NULL default '',
  value varchar(100) NOT NULL default '',
  prefid int(11) NOT NULL auto_increment,
  PRIMARY KEY  (prefid),
  KEY username (username)
) TYPE=MyISAM;

In /etc/mail/spamassassin/local.cf add the access data:

user_scores_dsn                 DBI:mysql:spamassassin:localhost
user_scores_sql_username        dbuser
user_scores_sql_password        dbpassword

To make spamassassin use that database add in /etc/defaults/spamassassin “-Q” to OPTIONS and restart the service – in my case that’s amavis

Copy the plugin from here to the plugin directory and enable it in the config. In the plugin’s config you’ll have to add the details for database access. Done.

Leave a Reply

Your email address will not be published. Required fields are marked *