polyformal - System & Formarbeit

• Basic: Integration of the roundcube webmail client in drupal
• Pro / Contra iframe: The iframe solution is not very nice, but roundcube is just a complex application. Maybe it's also better for maintaining updates. Also following the unix philosophy: a task should have it's own application.
• Advantages: rcmail is an module to use the nice-looking ajax webmail client roundcube in drupal. Users can leave their mail account information in drupals account settings to make use of a single-sign-on. The passwords stored crypted in drupals database*. Some scripts in roundcube were modified to use contacts managed with civicrm. Users can query, edit and insert new contacts in the contact pool of civicrm.
• Future: Uses can see sent emails as activities in civicrm.
• *Security: The password of the users IMAP account stored in the database using php mcrypt and a key you can set in the rcmail.module. So even a database administrator is not able to read users password as plain-text. To login the IMAP account, the password will be decrypted using mcrypt and the key in runtime. Paranoia: If an evil hacker gain access of booth, drupals database and your key (wich is stored in the script), the hacker is able to decrypt the passwords.
• Project at drupal http://drupal.org/node/58466

rcmail was updated to work with drupal-4.7. But there are two outstanding tasks:

• currently no patch for civicrm-module, if you need this don't hesitate to contact me

• Homepage http://www.roundcube.net/
• forum http://roundcubeforum.net/
• GNU General Public License
• Spellcheck http://roundcubeforum.net/index.php?topic=210.0

• http://dev.polyformal.de/drupal/
  • create new account
  • login and edit IMAP setting in ‘my account’

Please use the rcmail project site at drupal.

please have a look at Versions before.

• drupal (of course ;)
• Roundcube Webmail
• rcmail
• make shure PHP compiled with mcrypt (f.e. '—with-mcrypt' ). You can check this with phpinfo();

rcmail.module comes with 2 different patches for 2 flavors of using adressbooks. The one with the great advantage to use the addressbook from civicrm, wich needs the patch patch_ab_civicrm.txt . The other one with the standard addressbook from roundcubemail needs patch_ab_rc.txt

— Superuser 2007/03/24 12:50 civicrm is not supported yet, because it seems like that nobody needs it.

• goto [drupal]/sites/all/modules/rcmail/
• unpack roundcubemail to ./ so that you have [drupal]/sites/all/modules/rcmail/roundcubemail
• assuming now that ./patch_ab_[flavor].txt and ./roundcubemail/ (create symbolic links if necessary)
• apply patch patch -p0 -u < patch_ab_[flavor].txt
• edit roundcubemail/conf/ (for further details read roundcubemail/README and INSTALL)
  • db.inc.php
    • set to drupals database
    • add the prefix rcmail_ to all mysql tables, like the following example:

before // you can define specific table names used to store webmail data $rcmail_config['db_table_users'] = 'users'; after // you can define specific table names used to store webmail data $rcmail_config['db_table_users'] = 'rcmail_users';

• main.inc.php set your smtp server
• modify roundcubemail/SQL/mysql5.initial.sql

• add the table prefix rcmail_ to all CREATE TABLE statements, like the following example:

before CREATE TABLE `contacts` after CREATE TABLE `rcmail_contacts`

:%s/CREATE TABLE `/CREATE TABLE `rcmail_/

• apply roundcubemail/SQL/mysql.initial.sql to drupal's database
• Modify roundcubemail/.htaccess if neccesary

• settings in druapl
  • enable the module / permissions
  • edit IMAP setting in 'my account'
  • select 'roundcubemail' from the menu

This is a matrix witch patch matches the right roundcube version.

This gives an overview how it was modified, for everybody who is interested in.

• iframe problem: 'Compose' overrides the iframe (Zeile 845)
• database to drupals database
  • SQL/mysql.initial.sql set tablesnames with prefix rcmail_
• adressbook civicrm support
  • program/steps/addressbook/*
  • program/steps/mail/compose.inc
• see patch

Priority

• 1 : essential
• 2 : for stable release
• 3 : make up