RoundCube Webmail Forum  

Go Back   RoundCube Webmail Forum > News and Announcements > General Discussion

For more information about the ads and why they're here, please see the FAQ

Reply
  4 links from elsewhere to this Post. Click to view. #1  
Old 07-18-2009, 08:29 AM
mk.keck's Avatar
Registered User
 
Join Date: Jul 2009
Location: Treia - Germany
Posts: 7
Post 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.

Last edited by mk.keck; 08-28-2009 at 10:41 AM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 09-05-2009, 11:19 AM
Registered User
 
Join Date: Sep 2009
Posts: 4
Default Probem with this approach

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.

Last edited by wskeggs; 09-05-2009 at 11:21 AM. Reason: additional information
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3  
Old 09-20-2009, 05:40 AM
Registered User
 
Join Date: Sep 2009
Posts: 4
Default Issue resolved

Appears as though this has been resolved with the latest svn trunk
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Tags
atmail, install, plesk, replace


LinkBacks (?)
LinkBack to this Thread: http://www.roundcubeforum.net/3-news-announcements/12-general-discussion/5034-how-install-roundcube-plesk.html
Posted By For Type Date
#1486133 (Bug with INBOX Folder.) ? Roundcube Webmail This thread Refback 09-16-2009 11:21 PM
Little HowTo to get RoundCube work - Parallels Forums This thread Refback 07-29-2009 04:18 PM
Little HowTo to get RoundCube work - Parallels Forums This thread Refback 07-20-2009 11:05 AM
Little HowTo to get RoundCube work - Parallels Forums This thread Refback 07-19-2009 11:31 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 03:23 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
Copyright © 2006-2008 RoundCube Webmail Community