Thread: How to install Roundcube for Plesk

Hi all,

some days ago I've successfully installed Roundcube on CentOS 5 with Plesk 9.2.1.

But I find another way to get Roundcube to work with Plesk:

Notice

• You need Plesk 9.x.x with installed AtMail
• You need write-access to the folder "/var/www/"
• You need ftp-access to the folder "/var/www/"
  or you can use something like WinSCP.
• You need root-access to your server
• You make this at your own risk!

Preparing RoundCube

1. Download Roundcube
   The 0.3 beate is really stable and has new api for plugins. Perhabs you may also use SVN-Version and keep it updated. But I've not tested.
2. Unpack Roundcube
   into a local folder. Not on your server, because we have to make some changes.
3. RoundCube Database
   First we must create a new database for the Roundcube Webmail.
   1. Login into you Plesk-Account as Administrator
   2. Click on the "Home" and than on "Database Servers"
   3. Click in the server list on the icon "... access this server via DB WebAdmin"
      in the line "Local MySQL server (default for MySQL)".
      PhpMyAdmin should be opend now, If not, please check your popupblocker settings.
   4. Create a new database called "roundcube"
   5. Browse on your local machine to the folder "/roundcubemail/SQL"
      and oben the file "mysql.initial.sql" with a text-editor like notepad.
   6. Click in phpMyAdmin on the "SQL"-tab copy all from the text-editor
      into the large textbox.
      Click "Go". The Database should be created.
   7. Now create a database-user for roundcube.
      Click in the left frame on the "Home"-icon and then select in right frame "Privileges".
      In the "User overview" click on the icon "Add a new user" and enter follow:
      
      Code:

      Username (use text field): yourusername
      Host     (Local):          localhost
      Password (use text field): yourpassword
      Retype:                    yourpassword

      Click on "Go"-button
   8. Setup the "Database-specific privileges"
      • In the drobdown-list "Add privileges on the following database" select the entry "roundcube"
      • Click on "Check all"
      • Click on the "Go"-button
      
      
4. Configuration
   1. Copy the code below to the new file "/roundcubemail/config/db.inc.php" on your local machine
      
      PHP Code:

      <?php

/**
 * -----------------------------------------------------------------------
 * Configuration file for database access
 * 
 * This file is part of the RoundCube Webmail client
 * Copyright (C) 2005-2009, RoundCube Dev. - Switzerland
 * Licensed under the GNU GPL
 * -----------------------------------------------------------------------
 */

$rcmail_config = array();

$rcmail_config['db_dsnw'] = 'mysql://yourusername:yourpassword@localhost/roundcube';
$rcmail_config['db_dsnr'] = '';

$rcmail_config['db_max_length'] = 512000;
$rcmail_config['db_persistent'] = FALSE;

$rcmail_config['db_table_users'] = 'users';
$rcmail_config['db_table_identities'] = 'identities';
$rcmail_config['db_table_contacts'] = 'contacts';
$rcmail_config['db_table_session'] = 'session';
$rcmail_config['db_table_cache'] = 'cache';
$rcmail_config['db_table_messages'] = 'messages';

$rcmail_config['db_sequence_users'] = 'user_ids';
$rcmail_config['db_sequence_identities'] = 'identity_ids';
$rcmail_config['db_sequence_contacts'] = 'contact_ids';
$rcmail_config['db_sequence_cache'] = 'cache_ids';
$rcmail_config['db_sequence_messages'] = 'message_ids';
?>
   2. Copy the code below to the new file "/roundcubemail/config/main.inc.php" on your local machine
      
      PHP Code:

      <?php

/**
 * -----------------------------------------------------------------------
 * Main configuration file
 *
 * This file is part of the RoundCube Webmail client
 * Copyright (C) 2005-2009, RoundCube Dev. - Switzerland
 * Licensed under the GNU GPL
 * -----------------------------------------------------------------------
 */

$rcmail_config = array();

$tmp = strtolower($_SERVER['HTTP_HOST']);
$tmp = str_replace('www.', '', $tmp);
$tmp = str_replace('webmail.', '', $tmp);
$rcmail_config['real_host_name'] = $tmp;
$rcmail_config['real_mail_host'] = 'mail.' . $tmp;
unset($tmp);

$rcmail_config['default_host'] = $rcmail_config['real_mail_host'];
$rcmail_config['default_port'] = 143;

$rcmail_config['username_domain'] = ''; // $rcmail_config['real_host_name'];
$rcmail_config['mail_domain'] = ''; // $rcmail_config['real_host_name'];

$rcmail_config['smtp_server'] = $rcmail_config['real_mail_host'];
$rcmail_config['smtp_port'] = 25;
$rcmail_config['smtp_user'] = '%u';
$rcmail_config['smtp_pass'] = '%p';
$rcmail_config['smtp_auth_type'] = '';
$rcmail_config['smtp_helo_host'] = '';
$rcmail_config['smtp_log'] = TRUE;

$rcmail_config['imap_auth_type'] = null;
$rcmail_config['imap_root']      = null;
$rcmail_config['imap_delimiter'] = null;

$rcmail_config['include_host_config'] = FALSE;
$rcmail_config['sendmail_delay'] = 30;

$rcmail_config['debug_level'] = 1;
$rcmail_config['log_dir'] = 'logs/';
$rcmail_config['log_date_format'] = 'd-M-Y H:i:s O';
$rcmail_config['log_driver'] = 'file';
$rcmail_config['log_logins'] = FALSE;
$rcmail_config['syslog_id'] = 'roundcube';
$rcmail_config['syslog_facility'] = LOG_USER;

$rcmail_config['temp_dir'] = 'temp/';
$rcmail_config['plugins_dir'] = 'plugins/';
$rcmail_config['plugins'] = array(
    'emoticons',
    'markasjunk'
);

$rcmail_config['enable_caching'] = TRUE;
$rcmail_config['message_cache_lifetime'] = '14d';
$rcmail_config['list_cols'] = array('subject', 'from', 'date', 'size', 'flag', 'attachment');
$rcmail_config['skin_include_php'] = FALSE;

$rcmail_config['auto_create_user'] = TRUE;
$rcmail_config['des_key'] = '9IDJVL8%nf6%RTgOwpyfkuDv';
$rcmail_config['double_auth'] = FALSE;
$rcmail_config['ip_check'] = FALSE;
$rcmail_config['keep_alive'] = 60;
$rcmail_config['min_keep_alive'] = 60;
$rcmail_config['session_lifetime'] = 10;
$rcmail_config['session_domain'] = '.' . $rcmail_config['real_host_name'];
$rcmail_config['virtuser_file'] = '';
$rcmail_config['virtuser_query'] = '';

$rcmail_config['language'] = null;
$rcmail_config['date_short'] = 'D H:i';
$rcmail_config['date_long'] = 'd.m.Y H:i';
$rcmail_config['date_today'] = 'H:i';
$rcmail_config['useragent'] = 'RoundCube Webmail/0.3-beta';
$rcmail_config['quota_zero_as_unlimited'] = TRUE;
$rcmail_config['create_default_folders'] = TRUE;
$rcmail_config['check_all_folders'] = FALSE;
$rcmail_config['default_imap_folders'] = array('INBOX', 'Drafts', 'Sent', 'Junk', 'Trash');
$rcmail_config['protect_default_folders'] = TRUE;
$rcmail_config['drafts_mbox'] = 'Drafts';
$rcmail_config['junk_mbox'] = 'Junk';
$rcmail_config['sent_mbox'] = 'Sent';
$rcmail_config['trash_mbox'] = 'Trash';
$rcmail_config['delete_always'] = FALSE;
$rcmail_config['default_charset'] = 'ISO-8859-1';
$rcmail_config['enable_spellcheck'] = TRUE;
$rcmail_config['spellcheck_engine'] = 'googlie';
$rcmail_config['spellcheck_languages'] = NULL;
$rcmail_config['spellcheck_uri'] = '';
$rcmail_config['address_book_type'] = 'sql';
$rcmail_config['autocomplete_addressbooks'] = array('sql');
$rcmail_config['ldap_public'] = array();
$rcmail_config['dont_override'] = array();

$rcmail_config['enable_installer'] = FALSE;
$rcmail_config['generic_message_footer'] = '';
$rcmail_config['http_received_header'] = FALSE;
$rcmail_config['http_received_header_encrypt'] = FALSE;

$rcmail_config['identities_level'] = 0;
$rcmail_config['mail_header_delimiter'] = NULL;
$rcmail_config['max_pagesize'] = 500;

$rcmail_config['mdn_requests'] = 0;
$rcmail_config['mime_magic'] = '/usr/share/misc/magic';
$rcmail_config['product_name'] = 'RoundCube WebMail';
$rcmail_config['skin'] = 'default';

$rcmail_config['draft_autosave'] = 300;
$rcmail_config['dst_active'] = (bool)date('I');
$rcmail_config['flag_for_deletion'] = FALSE;
$rcmail_config['focus_on_new_message'] = TRUE;
$rcmail_config['htmleditor'] = TRUE; // FALSE;
$rcmail_config['inline_images'] = TRUE;
$rcmail_config['logout_expunge'] = FALSE;
$rcmail_config['logout_purge'] = FALSE;
$rcmail_config['message_sort_col'] = 'date';
$rcmail_config['message_sort_order'] = 'DESC';
$rcmail_config['mime_param_folding'] = 0;
$rcmail_config['pagesize'] = 50;
$rcmail_config['prefer_html'] = TRUE;
$rcmail_config['prettydate'] = FALSE; // TRUE;
$rcmail_config['preview_pane'] = TRUE; // FALSE;
$rcmail_config['read_when_deleted'] = TRUE;
$rcmail_config['show_images'] = 2; // 0;
$rcmail_config['skip_deleted'] = FALSE;
$rcmail_config['timezone'] = 'auto';
?>

Uploading Roundcube

1. Rename your orgininal folder on your server:
   /var/www/atmail into /var/www/atmail.org (or something else)
2. Create a clean new folder /var/www/atmail
3. Copy all files from your local folder /roundcubemail/ to the
   remote folder /var/www/atmail.

Plesk Setting
Select for your mail-address as WebMail "AtMail".

ATTENTION
Perhabs your Roundcube (because it is stored in folder /var/www/atmail/) would be overwritten, if you make a Plesk-Update. Please make
a backup before you update Plesk.