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.

Hi,

I implemented your approach and it works nicely for certain domains. I find I can only login with emails already created in plesk that I have used previously with atmail. Others just dont login, I get the following errors in the error log:

PHP Notice: Authentication for sales failed (LOGIN): "a001 NO Login failed." in /var/www/atmail/program/include/bugs.incs on line 86, referer: http://domain.com/

This error from time to time:
PHP Fatal error: Maximum execution time of 120 seconds exceeded in /var/www/atmail/program/lib/imap.inc on line 260

This error when composing messages:
PHP Warning: file_exists() [<a href='function.file-exists'>function.file-exists</a>]: open_basedir restrict in effect. File(/dev/random) is not within the allowed path(s): (/var/www/atmail:/var/log/atmail:/etc/psa:/tmp:/var/tmp) in /var/www/atmail/program/lib/Auth/SASL/DigestMD5.php on line 184, referer: http://domain.com/?_task=mail&_id=81...action=compose

Does the atmail configuration in the httpd conf.d folder need to be modified for roundcube?

Edit: By the way I am running plesk 9.2.1 on centos 5 and I am using the .3 stable of roundcube.

Appears as though this has been resolved with the latest svn trunk