Bob at 01:27, 17 January 2014

2014-01-17T01:27:40Z

New page

{| style="width:100%" border="0"
<h2 style="margin:0; background:#3fbba0; font-size:120%; font-weight:bold; border:1px solid #3f5bb0; text-align:center; color:#000; padding:0.2em 0.4em;">Clients for CalDAV/CardDAV/IMAP/SMB/VPN</h2>
{| style="width:100%" border="1"
|+ 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==
*Find latest Roundcube downloads here: http://roundcube.net/download
*Find latest MyRoundcube plugin manager downloads here: http://myroundcube.com/myroundcube-plugins/plugin-manager
*cd /usr/src
*wget http://sourceforge.net/projects/roundcubemail/files/roundcubemail/0.9.2/roundcubemail-0.9.2.tar.gz
*tar zxf roundcubemail-0.9.2.tar.gz
*lynx http://dev.myroundcube.com/?_action=plugin.plugin_server_get_pm <= Accept cookie/(D)ownload/Save to Disk/(Q)uit
*gunzip plugins.zip.gz && unzip plugins.zip && mv /usr/src/plugins/ /usr/src/plugin.manager

==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==
*vi [[/etc/apache2/sites-available/mail.computerisms.com.conf]]
*a2ensite mail.computerisms.com
*mkdir /var/log/apache2/mail.computerisms.com
*chown root:adm /var/log/apache2/mail.computerisms.com/
*a2enmod expires
*/etc/init.d/apache2 restart

==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==
*As a good admin, you should read all the README files and config.inc.php.dist files.
*rm -rf /Computerisms/sites/mail.computerisms.com/plugins/{squirrelmail_usercopy,redundant_attachments,password,new_user_identity,new_user_dialog}
*vi [[/Computerisms/sites/mail.computerisms.com/plugins/calendar/config.inc.php]]
*vi [[/Computerisms/sites/mail.computerisms.com/plugins/carddav/config.inc.php]]
*vi [[/Computerisms/sites/mail.computerisms.com/plugins/blockspamsending/config.inc.php]]
*vi [[/Computerisms/sites/mail.computerisms.com/plugins/crawler/config.inc.php]]
*vi [[/Computerisms/sites/mail.computerisms.com/plugins/help/config.inc.php]]
*vi [[/Computerisms/sites/mail.computerisms.com/plugins/idle_timeout/config.inc.php]]
*vi [[/Computerisms/sites/mail.computerisms.com/plugins/managesieve/config.inc.php]]
*vi [[/Computerisms/sites/mail.computerisms.com/plugins/newmail_notifier/config.inc.php]]
*vi [[/Computerisms/sites/mail.computerisms.com/plugins/persistent_login/config.inc.php]]
*vi [[/Computerisms/sites/mail.computerisms.com/plugins/settings/config.inc.php]]
*vi [[/Computerisms/sites/mail.computerisms.com/plugins/webmail_notifier/config.inc.php]]

==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
**You will have to clean this file up manually, take out all the comments and php tags
**After, make sure there is a leading <?php and a trailing ?> in the file
**[[/Computerisms/sites/mail.computerisms.com/plugins/global_config/config.inc.php]]
*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
**In a browser navigate to https://mail.computerims.com and navigate to the settings page, highlight/copy the *.myrc string
*touch XXXXXXXXXXXXXXXXXXXXXXXXXX.myrc
**click the done link in the browser

==Required Reading==
*http://trac.roundcube.net/
*http://myroundcube.com/

Install RoundCube - Revision history

Bob at 01:27, 17 January 2014