2012. 8. 8. 12:30

Upgrade.Roundcube.Webmail

This tutorial is used to upgrade Roundcube from old release to the latest release. Ideally, you can upgrade whichever old release to the latest Roundcube release with this tutorial. Post issues in our online support forum: http://www.iredmail.org/forum/

  • Backup current Roundcube database first.

Terminal:
# mysqldump -u root -p roundcubemail > /root/mysql-db-roundcubemail.sql

  • Download the latest Roundcube webmail here: http://roundcube.net/. Here we take 0.7.1 for example: /root/roundcubemail-0.7.1.tar.gz
  • Extract it in the right place.

Terminal:
# ---- For RHEL/CentOS/Scientific Linux ----
# tar xzf /root/roundcubemail-0.7.1.tar.gz -C /var/www/
# cd /var/www/
# mkdir roundcubemail-0.7.1/{temp,logs}
# chown apache:apache roundcubemail-0.7.1/{temp,logs}

# ---- For Debian/Ubuntu ----
# tar xzf /root/roundcubemail-0.7.1.tar.gz -C /usr/share/apache2/
# cd /usr/share/apache2/
# mkdir roundcubemail-0.7.1/{temp,logs}
# chown www-data:www-data roundcubemail-0.7.1/{temp,logs}

# ---- For Gentoo Linux ----
# tar xzf /root/roundcubemail-0.7.1.tar.gz -C /var/www/
# cd /var/www/
# mkdir roundcubemail-0.7.1/{temp,logs}
# chown apache:apache roundcubemail-0.7.1/{temp,logs}

# ---- For openSUSE ----
# tar xzf /root/roundcubemail-0.7.1.tar.gz -C /srv/www/
# cd /srv/www/
# mkdir roundcubemail-0.7.1/{temp,logs}
# chown wwwrun:www roundcubemail-0.7.1/{temp,logs}

# ---- For FreeBSD ----
# tar xzf /root/roundcubemail-0.7.1.tar.gz -C /usr/local/www/
# cd /usr/local/www/
# mkdir roundcubemail-0.7.1/{temp,logs}
# chown www:www roundcubemail-0.7.1/{temp,logs}

  • Copy config files db.inc.php and main.inc.php from old release to new release. For example:

Terminal:
# cp -p roundcubemail-0.5.2/config/{db.inc.php,main.inc.php} roundcubemail-0.7.1/config/

  • Remove symbol link and create a new one, link to new release:

Terminal:
# rm roundcubemail
# ln -s roundcubemail-0.7.1 roundcubemail

  • Enable Roundcube installer by update below setting in roundcubemail-0.7.1/config/main.inc.php:

Terminal:
$rcmail_config['enable_installer'] = true;

If the installer reports your server misses some required packages or PHP modules, please install them manually to fix them.

  • Set correct time zone in your PHP config file php.ini. For example:
    • On RHEL/CentOS/Scientific Linux, it's /etc/php.ini
    • On Debian/Ubuntu, it's /etc/php5/apache2/php.ini
    • On Gentoo Linux, it's /etc/php/apache2-php5.3/php.ini
    • On openSUSE, it's /etc/php5/apache2/php.ini
    • on FreeBSD, it's /usr/local/etc/php.ini

Terminal:
date.timezone = "Europe/Paris"

  • Restart Apache web server if you have new required packages or PHP modules installed.
  • Upgrade Roundcube database structure by importing shipped SQL file:

Terminal:
# mysql -uroot -p
mysql> USE roundcubemail;
mysql> SOURCE roundcubemail-0.7.1/SQL/mysql.update.sql;

  • Access Roundcube installer with this URL: httpS://your_server/mail/installer , it will validate required packages, PHP modules and database structure.
  • Roundcube installer also gives the way to download main.inc.php and db.inc.php files, please download them and replace your old config files. Because old config files might miss some parameters. Don't forget to fix file permission after replaced:

Terminal:
# ---- On RHEL/CentOS/Scientific Linux ----
# chown apache:apache roundcubemail-0.7.1/config/*

# ---- On Debian/Ubuntu ----
# chown www-data:www-data roundcubemail-0.7.1/config/*

# ---- On Gentoo Linux ----
# chown apache:apache roundcubemail-0.7.1/config/*

# ---- On openSUSE ----
# chown wwwrun:www roundcubemail-0.7.1/config/*

# ---- On FreeBSD ----
# chown www:www roundcubemail-0.7.1/config/*

  • After Roundcube installer finished upgrading process, disable installer in config file 'roundcubemail-0.7.1/config/main.inc.php' by updating below parameter:

Terminal:
$rcmail_config['enable_installer'] = false;

  • Restrict accessing to sensitive files:

Terminal:
# chmod 0000 roundcubemail-0.7.1/{CHANGELOG,INSTALL,LICENSE,README,UPGRADING,installer,SQL}

That's all.


출처 : http://iredmail.org/wiki/index.php?title=IRedMail/FAQ/Upgrade.Roundcube.Webmail

2012. 8. 8. 12:24

Roundcube Mail user interface...

Need Customizations to change the look and feel of the user interface? You can access the relevant CSS files under the default skins directory and begin editing the relevant styles inside common.css or mail.css files. For example if you want to change the color of the message selection bar, you may find and replace the color codes as follows;

# vi /usr/local/www/apache22/data/roundcube/skins/default/common.css
table.records-table tr.selected td
{
  color: #FFFFFF;
  background-color: #FF6000;
}
# vi /usr/local/www/apache22/data/roundcube/skins/default/mail.css
#messagelist tr.selected td
{
  color: #FFFFFF;
  background-color: #FF6000;
}

Adding plugins is a powerful way of making Roundcube more convenient client for satisfying the user habits. Here are the list of plugins I recommend you to install in the first instance;

jqueryui
automatic_addressbook
compose_addressbook
globaladdressbook
vcard_attachments
vacation
managesieve