Systems - Community (Webmail)



The purpose of the community server is to provide webmail for persons with It gets its name from the domain

This machine also supports the board's voting system and a staff list.

Physical Location

This system is located on a Debian Etch vserver on physical machine sun2.

Logical location


Applicable Documentation

  1. CommunityEmail

  2. PolicyDrafts/EmailHandling

  3. EmailAccountPolicy

  4. Communication Policy


Primary: Markus Warg (was - resigned - probably still has access)

Secondary: Philipp G├╝hring


Listening services


Connected Systems

Outbound network connections


Privileged Access: Philipp/ Markus Warg Other Access: All users have HTTPS access

Non-distribution packages roundcubemail - installed raw tarball in /var/www manage sieve for roundcube - patch over the top of roundcubemail (and as of 0.3+ an official plugin) voting software - installed in /var/www/board{,-test}

Risk assessments on critical packages

Common Tasks

Updating roundcubemail version. (TODO -review - don't 100% trust this - try an install and check file permissions)

  1. unpack it here /var/www
  2. if the are no database changes - SQL/mysql.update.sql skip next three steps
  3. clone current database - create database roundcubemail-0_2beta2. on cmdline  mysqldump --opt -p roundcubemail | mysql -p roundcubemail-0_2beta2 

  4.  GRANT SELECT , INSERT , UPDATE , DELETE ON `roundcubemail-0\_2beta2` . * TO 'roundcube'@'%'; 

  5. run database upgrade instructions SQL/mysql.update.sql.
  6. cd /var/www/roundcubemail-{newversion}
  7. copy config off previous installation cp /var/www/roundcubemail/config/*p config/
  8. change database name in config/ if using a new database
  9. compare new features with current config. New features are in config/*dist. Merge where appropriate
  10. chown -R root:safe .
  11. chown -R www-data logs temp
  12. symlink ln -s roundcubemail-{newversion} roundcubemail-test
  13. test basic login works
  14. and svn diff from roundcubemail-svn which is the X509 patch
  15. find . -name \*php -group root -exec chgrp safe {} \;
  16. perform testing on this site including sending one email with an attachment
  17. move the /var/www/roundcube symlink to /var/www/roundcubemail-{version} to complete transition
  18. if this was a critical security update remove older /var/www/roundcubemail versions

Critical Configuration items

/etc/hosts localhost webmail

# used by webmail configuration
# /var/www/roundcube*/config/* dbserver imapserver smtpserver






Need to centralise this.


Fail2ban to mitigate brute force attempts

Postfix full advantage of dovecot auth

Dovecot can do IP based authentication for a trusted roundcubemail password and this is installed with an additional password authentication mechanism:


  passdb sql {
    args = /etc/dovecot/dovecot-sql-masterpassword-webmail.conf

and the SQL is in /etc/dovecot/dovecot-sql-masterpassword-webmail.conf

Dovecot is currently saying password rejected when the non-global password is used as it check against pam before SQL. Still need to tidy the logs up.

Unfortunately postfix doesn't pass the remote IP to dovecot authentication so there is a global password accessible on all services. Lucky its huge and should never be guessed or brute forced. This was reported to Wieste -response was "make a generic patch covering all authentication things for consideration".

SMIME / PGP support

Plugin work underway -


SystemAdministration/Systems/Community (last edited 2011-03-16 12:51:04 by UlrichSchroeter)