Attention: All pages of this wiki depend on the pages that come before it, in order as they are listed on the Main Page. Please check for Dependencies.
Please also look at What You Need to Know Before Using This Wiki

Install RoundCube

From COCNM
Revision as of 21:27, 16 January 2014 by Bob (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


Clients for CalDAV/CardDAV/IMAP/SMB/VPN

Client Chart - Unempirical and based solely in opinion obtained by experience
Client CalDAV CardDAV IMAP SMB IPSec/L2TP Pros Cons Notes
RoundCube Excellent Excellent Excellent N/A N/A User-friendly,max feature<=>protocol support poor user experience on old computers/slow network/small monitor Costs about 20 Euros for the plugins for caldav and carddav.
SquirrelMail None None Excellent N/A N/A much faster than roundcube. no DAV support very much worth having if serving from a slow connection or if users want it and don't need calendar/address book
Thunderbird/Lightning Good Excellent Excellent N/A N/A Fully featured, intuitive gui more than 5 caldav feeds starts to be risky on some computers some users believe lightning has ghosts
Evolution Excellent Excellent Excellent N/A N/A Supports many protocols Windows version mostly undeveloped and buggy Only tested by me, have not seen it under load
eM Client Excellent Excellent Excellent N/A N/A user-friendly, easy to configure unknown This has only ever been tested in production in a small office, but has performed admirably to date
Outlook Untested Untested Meh N/A N/A Users like it Requires 3rd party plugins for caldav/carddav, poor imap performace, very expensive Outlook 2013 consumes huge bandwidth for imap. ical4ol trial a bit hard to figure but works
Mac Mail/Calendar Excellent Excellent Excellent N/A N/A user-friendly, works reliably ? As good as anything else I have tried
Android Excellent Untested Excellent Good Yes feature support is good Does not fit well in typical AD security model App store contains all the tools you need
IPhone Excellent Excellent Excellent Untested Yes required protocols are all(?) handled natively Does not fit well in typical AD security model App store contains all the tools you need
Blackberry None? None? Meh None? None? ? ... Enterprise version does fit well with AD environments

Server Prep

  • apt-get install unzip aspell imagemagick php-apc mysql-server php5-mcrypt php5-intl php5-mysql php5-pspell aspell-fr

Obtain and Prepare Roundcube/MyRoundcube

Configure Mysql

  • mysql -u root -p
  • create database rcmail;
  • GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES on rcmail.* to 'roundcube'@'localhost' identified by 'DBMinion';
  • quit
  • mysql -u roundcube -p rcmail < /usr/src/roundcubemail-0.9.2/SQL/mysql.initial.sql

Install and Configure Roundcube

  • mkdir -p /Computerisms/sites/mail.computerisms.com
  • cp -r /usr/src/roundcubemail-0.9.2/* /Computerisms/sites/mail.computerisms.com/
  • cp -r /usr/src/plugins/* /Computerisms/sites/mail.computerisms.com/plugins/
  • vi /Computerisms/sites/mail.computerisms.com/config/db.inc.php
  • vi /Computerisms/sites/mail.computerisms.com/config/main.inc.php
  • chown -R roundcube:roundcube /Computerisms/sites/mail.computerisms.com/
  • find /Computerisms/sites/mail.computerisms.com/ -type d -exec chmod 0750 {} \;
  • find /Computerisms/sites/mail.computerisms.com/ -type f -exec chmod 0640 {} \;
  • chmod 2770 /Computerisms/sites/mail.computerisms.com/
  • crontab -e
    • 05 00 * * * bash /Computerisms/sites/mail.computerisms.com/bin/cleandb.sh

Configue Apache

Configure MyRoundCube

  • in a browser navigate to https://mail.computerisms.com, login as bob.miller, navigate to the settings page
    • highlight/copy the *.myrc filename
  • touch /Computerisms/sites/mail.computerisms.com/XXXXXXXXXXXXXXXXXXXXXXXXXX.myrc
  • chmod 640 /Computerisms/sites/mail.computerisms.com/*myrc
  • In the browser click done
  • navigate to Manage Plugins/Customer Account=>Buy Credits now
  • in the new window/tab select "I agree"=>select 20 MyRC$=>buy now=>complete your purchase=>close this tab/window
  • navigate to Manage Plugins/plugins download=>check subscribe if you haven't before=>select I agree
  • Select the following:
    archivefolder
    blockspamsending
    calendar
    calendar_plus
    carddav
    carddav_plus
    checkbox
    compose_in_taskbar
    crawler
    db_version
    fancybox
    folderbuttons
    global_config
    http_auth
    idle_timeout
    jscolor
    message_highlight
    persistent_login
    planner
    sticky_notes
    timepicker
    webmail_notifier
    wrapper
    contextmenu
    copymessage
    hideblockquota
    importmessages
    jqueryui
    keyboardshortcuts
    listcommands
    markbuttons
    newmail_notifier
    vcard_attachments
  • click download zip archive and agree, save to desktop, and use scp to copy it to /usr/src on houselian
  • mv /usr/src/plugins/ /usr/src/plugin.manager
  • unzip plugins.zip
  • cp -r plugins/* /Computerisms/sites/mail.computerisms.com/plugins/
  • rm -rf /Computerisms/sites/mail.computerisms.com/plugins/global_config
  • chown roundcube:roundcube -R /Computerisms/sites/mail.computerisms.com/plugins/*
  • find /Computerisms/sites/mail.computerisms.com/plugins/ -type d -exec chmod 0750 {} \;
  • find /Computerisms/sites/mail.computerisms.com/plugins/ -type f -exec chmod 0640 {} \;
  • In the browser, navigate to manage plugins/settings=>global plugins tab, enable appropritately
    • rinse and repeat for the rest of the tabs. A good default is to remove all checkmarks leaving it disabled with the option for the user to enable it again.

Configure Plugins

Global_config

  • cp -r /usr/src/plugins/global_config/ /Computerisms/sites/mail.computerisms.com/plugins/
  • cd /Computerisms/sites/mail.computerisms.com/plugins/
  • for i in $(ls); do if [ -e $i/config.inc.php.dist ]; then echo "// CONFIG FOR $i" >> global_config/config.inc.php; if [ -e $i/config.inc.php ]; then cat $i/config.inc.php >> global_config/config.inc.php; else cat $i/config.inc.php.dist >> global_config/config.inc.php; fi; fi; done
  • sed -i "s/plugin_manager'/plugin_manager', 'global_config'/" /Computerisms/sites/mail.computerisms.com/config/main.inc.php
    • Login and navigate to settings page
    • You will know it worked if the carddav settings page has moved from the address book heading to the manage plugins heading

Resetting Superadmin Account / Plugins Disappeared

  • Safe to do this all you want after you have downloaded the plugins
  • logout of roundcube and close browsers
  • mysql -u root -p rcmail
  • drop table plugin_manager;
  • delete from system where name='myrc_plugin_manager';
  • quit
  • rm /Computerisms/sites/mail.computerisms.com/*.myrc
  • touch XXXXXXXXXXXXXXXXXXXXXXXXXX.myrc
    • click the done link in the browser

Required Reading