Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: stanleyjobson2 on May 24, 2007, 07:46:23 PM

Title: Setup RoundCube In PLESK
Post by: stanleyjobson2 on May 24, 2007, 07:46:23 PM
Hi,

I Wanted to install RoundCube Webmail in my server.

I have PLESK 8.1.1 and FEDORA CORE 2.

How to do it ?

Take Care.

Ps : Sorry for my english, i'm very bad, i speak only french :-[
Title: Re: Setup RoundCube In PLESK
Post by: bpat1434 on June 11, 2007, 09:51:08 PM
Roundcube doesn't need any special software. Just mySQL and PHP. Download the zip or tar-ball and read the INSTALL file inside.
Title: Re: Setup RoundCube In PLESK
Post by: bryant on July 29, 2007, 02:14:50 PM
For Plesk, it asks for a Host name or IP address. I put the IP address and clicked ok and it gives me an error that it could not connect. I tried an IP, an IP with the directory of where RoundCube is. I also tried Local and Local host. I'm new to this and I was wondering if there was any help I could get with the Plesk.
The instructions suggest putting this:

# mysql
> CREATE DATABASE roundcubemail DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
> GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost
  IDENTIFIED BY 'password';
> quit

# mysql roundcubemail < SQL/mysql5.initial.sql

But I don't know where to enter that. I would assume once that is entered, everything would be automatic.

Any help would be the most greatest :)
Title: Re: Setup RoundCube In PLESK
Post by: bpat1434 on July 29, 2007, 02:23:06 PM
Quote
# mysql
> CREATE DATABASE roundcubemail DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
> GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost
  IDENTIFIED BY 'password';
> quit

# mysql roundcubemail < SQL/mysql5.initial.sql
That is shell script, and would be typed into an SSH terminal. You can do the same thing through Plesk's GUI and phpMyAdmin.

Quote
For Plesk, it asks for a Host name or IP address. I put the IP address and clicked ok and it gives me an error that it could not connect. I tried an IP, an IP with the directory of where RoundCube is. I also tried Local and Local host. I'm new to this and I was wondering if there was any help I could get with the Plesk.
What are you trying to do? Set Round Cube up to be usable, or make it the default webmail for all Plesk users?
Title: Re: Setup RoundCube In PLESK
Post by: bryant on July 29, 2007, 04:27:14 PM
Just trying to set Round Cube up to be usable.
Title: Re: Setup RoundCube In PLESK
Post by: bpat1434 on July 29, 2007, 04:36:18 PM
Okay, so here are some simple steps:


Sorry it's brief, but I gotta run. Let us know how it goes!!
Title: Re: Setup RoundCube In PLESK
Post by: bryant on July 29, 2007, 05:35:41 PM
Alrighty,

I got it working! Thanks.

I'm sure I'll have some more questions as I test it out.

Thanks again for your help.
Title: Re: Setup RoundCube In PLESK
Post by: bryant on July 30, 2007, 10:20:22 AM
Everything is working perfect and all.

How would I make Roundcube as the default webmail for all Plesk users?
It seems that when I go to mail.domain.com, it takes me to our website and webmail.domain.com takes us to horde.

Any help would be great.

Thanks :)
Title: Re: Setup RoundCube In PLESK
Post by: bpat1434 on July 30, 2007, 02:56:41 PM
You would need to set up redirection "A" entries in the DNS for each domain that points to one installation. That's the easiest I can think of. For example, webmail.bpatterson.net points to webmail.patternet.com and so does webmail.return2z3r0.info. They all point to the same place, and instead of using squirrelmail or horde, they get roundcube ;)

Now, how to install it along-side of Horde, SquirrelMail and make it a choice, or the default, that's a good question. I've seen people do it with cPanel, never anyone do it with Plesk.
Title: Re: Setup RoundCube In PLESK
Post by: bryant on July 30, 2007, 03:31:06 PM
Oh my I didn't quite understand the redirection of the 'A' DNS as far as what to put. Everything looks in order.
I guess I'm trying to figure out how to have Plesk pick up Roundcube instead of Horde.


 
:-\
(http://www.newcityinc.com/roundcubemail/forum_files/roundcube_DNSMX.jpg)
Title: Re: Setup RoundCube In PLESK
Post by: bpat1434 on July 30, 2007, 03:38:27 PM
Well, currently with the A DNS setup, it just works around that. I'm not a Plesk user (I prefer cPanel) so I can't speak as to how to really replace SquirrelMail with RoundCube.
Title: Re: Setup RoundCube In PLESK
Post by: bryant on July 30, 2007, 03:45:28 PM
What do you suggest I do Mr Patterson :)

I suppose I can contact my Hosting company and see what options they have for me.
Title: Re: Setup RoundCube In PLESK
Post by: bpat1434 on July 30, 2007, 03:49:33 PM
Hosting company probably won't help. Not sure, but you could google for "RoundCube +Plesk" and see if anyone has done it that also wrote a tutorial... or you could attempt to "hack" the source of Plesk (if allowed) and replace Horde with RoundCube....
Title: Re: Setup RoundCube In PLESK
Post by: bryant on July 30, 2007, 04:04:21 PM
I tried looking for "Roundcube + Plesk" in Google and no luck. I guess I have to dig deep for this one.
I'll keep you and the Forum posted. I'll have this Plesk thread wrapped up and ready to rock for future Pleskers'

Thanks for everything!
Title: Re: Setup RoundCube In PLESK
Post by: FlexZa on August 06, 2007, 09:14:07 PM
I DID IT! :D
http://webmail.flexza.net

let's do a quick tutorial :)
_________________________________________________
1) Install Roundcube in a folder on your server and be sure that it works. How to do this is in the manual of roundcube, not gonna explain it.

2) Backup /usr/share/psa-horde to /usr/share/psa-horde-BK

3) Make clean dir for /usr/share/psa-horde

4) Move all files from the folder on your server to /usr/share/psa-horde

5) Go to webmail.domain.com and it will work!
_________________________________________________

I did this with plesk 8.2.0 on a server runnin Suse Linux 9.3.

The only issue I've got is that the button called webmail in plesk won't work anymore...I just ticked the box off at the mail preferences ;)

Don't know if it's as simple as this on windows.
If you won't succeed just contact me @ flexza[at]flexza[dot]net
Title: Re: Setup RoundCube In PLESK
Post by: bpat1434 on August 07, 2007, 03:50:42 PM
That will only work if you have a VPS or dedicated server. If you're using a "shared" hosting account or a(n) "(over)reseller" account, then you probably can't just change the /usr dirs at all.

But glad that it's not too difficult!! I'm sure a new template could be created so that Roundcube is a button on the webmail tab in the control panel ;)
Title: Re: Setup RoundCube In PLESK
Post by: FlexZa on August 07, 2007, 04:54:18 PM
I think there might be an other way to fix it... :)
_________________________________________________
1)Put the webmail checkbox off at mail preferences...As everything goes right then this will remove the DNS record...otherwise you'll have to do this yourself at DNS management.

2)Create a new subdomain and name it webmail.

3)Install RoundCube there.
_________________________________________________

Didn't test it...but i think it would work... ;)
Title: Re: Setup RoundCube In PLESK
Post by: edstudio on December 11, 2007, 04:04:10 PM
Quote
The only issue I've got is that the button called webmail in plesk won't work anymore...I just ticked the box off at the mail preferences

This issue is wsa easily fixed for me with the following simple steps:

1. Create a new folder in psa-horde called imp
2. Create a new PHP file w/ the following code:
Code: [Select]
<?php header(&quot;locationhttp://&quot;.$_SERVER[&quot;SERVER_NAME&quot;]); ?>3. Name the PHP file login.php
4. Upload login.php to the new imp directory

I successfully used this method in Plesk 8.2 running on CentOS 5. This should redirect the mail button to http://webmail.domain.com. If not, at least you know where the mail button points and you can play with it from there...

Cheers!
Title: Upgrade to Plesk 8.4
Post by: mromero on May 18, 2008, 11:28:15 PM
If you are planning on upgrading to Plesk 8.4 from 8.3 or below make sure to restore your original horde installation, as the autoupdate fails and in my case caused apache to become non-functional. After Plesk has updated Horde you can re-back up Horde, and then reinstall RC.
Title: I've done with Plesk 9.2.1 and it works:
Post by: mk.keck on July 14, 2009, 05:24:42 AM
Hi all there,

I've successfully added Roundcube as default webmail. Here's a little howto:

1.) Download Roundcube 0.3beta (http://sourceforge.net/project/downloading.php?group_id=139281&filename=roundcubemail-0.3-beta.tar.gz)
It's 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 on your local machine...
... NOT on your server, because you must make some changes.

3.) Login into your Plesk account
3.1.) Click on the "Home" and than on "Database Servers"
3.2.) Click in the server list on the icon "... access this server via DB WebAdmin"
    in the line "Local MySQL server (default for MySQL)"
3.3.) phpMyAdmin should be opened
3.4.) Create a new database called "roundcube"
3.5.) Browse on your local machine to the folder "/roundcubemail/SQL"
    and oben the file "mysql.initial.sql" with notepad.
3.6.) Copy all and paste it, after clicking on the "SQL"-Tab in phpMyAdmin,
    to the large textarea. Than click "Go".
    Now you've created our roundcube database.
3.7.) In phpMyAdmin click in left frame on the "Home"-icon and select in right
    frame "Privileges". In the "User owerview" click on the icon "Add a new user".
3.8.) Add like follow:
    - Username (use text field): yourusername
    - Host (Local): localhost
    - Password (use text field): yourpassword
    - Retype: yourpassword
    - Click "Go".
3.9.) Scroll down to "Database-specific privileges" and select "roundcube"
    in the dropdown list called "Add privileges on the following database".
    After that click on "Check All" in "Database-specific privileges" and than click on "Go"
3.10.) Check your Privileges again:
    - Click on the Tab "Privileges"
    - You should see in the table yourusername - localhost - Yes - USAGE - No

4.) Create config/db.inc.php for RoundCube:
    On your local machine copy the folow lines to the new file "/roundcubemail/config/db.inc.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';
?>5.) Create config/main.inc.php for RoundCube:
    On your local machine copy the folow lines to the new file "/roundcubemail/config/main.inc.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';
?>6.) Create imp/login.php and imp/index.php for RoundCube:
With this new files, it is posibble to click on Plesk "Open Webmail" Link.
    On your local machine copy the folow lines to the new file "/roundcubemail/imp/login.php" AND "/roundcubemail/imp/index.php"
header('Location: ./../');
exit();
?>7.) Uploading ...
7.1) Backup the original psa-horde!
Browse on your server, best is if you use WinSCP (logged in as root), to the folder "/usr/share/" and rename "psa-horde" to "psa-horde-BK".
7.2) Create in "usr/share/" a new folder "psa-horde".
7.3) Open on your local machine the folder of "roundcube/".
7.4) Select all files and upload them to your server.

8.) Comments
- Note: You make this on your own risk
- Note: Updates on your new "psa-horde" won't work, it's in reality "roundcube" :)
- Note: Before you make an update/upgrade with Plesk make a backup of your folder "psa-horde"
- Please comment if any of this HowTo is not clear
- Please ask, if you have problems
- Sorry for my bad english ....

Regards
Michael
Title: Setup RoundCube In PLESK
Post by: Speedy on August 03, 2009, 01:09:51 PM
Is the name of the new folder ps-horde or psa-horde?
And do i have to copy the folder rouncube with it or only the files that are stored in the folder roundcube?

greetings
Title: Setup RoundCube In PLESK
Post by: lullo on August 11, 2009, 03:02:53 PM
Hi Michael,

Thanks for your how to. I followed it but when I open webmail the first time I get an error in my browser:

Fatal error: ini_set/set_include_path does not work.

Can you help me out with that?

best,
Wouter
Title: Setup RoundCube In PLESK
Post by: mk.keck on August 28, 2009, 06:23:36 AM
Quote from: Speedy;20382
Is the name of the new folder ps-horde or psa-horde?
And do i have to copy the folder rouncube with it or only the files that are stored in the folder roundcube?

greetings

1. The name of the new folder is psa_horde
2. Only the files and subdirs (recursive) stored in roundcube

Michael
Title: Setup RoundCube In PLESK
Post by: mk.keck on August 28, 2009, 06:29:41 AM
Quote from: lullo;20511
Hi Michael,

Thanks for your how to. I followed it but when I open webmail the first time I get an error in my browser:

Fatal error: ini_set/set_include_path does not work.

Can you help me out with that?

best,
Wouter

Do your really have updated the files
imp/login.php and imp/index.php
I've descriped in my HowTo?

ini_set/ is a folder from Horde...


Michael
Title: Another solution to get Roundcube work with Plesk
Post by: mk.keck on August 28, 2009, 06:33:14 AM
Here's another solution to get Roundcube work with Plesk:

http://www.roundcubeforum.net/general-discussion/5034-how-install-roundcube-plesk.html

It replaces the installed AtMail with Roundcube.

Michael
Title: Setup RoundCube In PLESK
Post by: mxunal on September 25, 2009, 11:39:22 PM
i did everything.. but webmail.mydomain.com is a blank page :S
Title: Setup RoundCube In PLESK
Post by: samtylor on October 11, 2009, 08:09:58 AM
Quote from: mxunal;21743
i did everything.. but webmail.mydomain.com is a blank page :S


same here.... I also followed the instructions, but no luck :(
Title: Setup RoundCube In PLESK
Post by: ircteknik on October 13, 2009, 09:11:11 AM
hi...i setup roundcube in psa-horde ... it working but when i try to delete mails on my webmail...it not working? why i cant delete my mails? can anyone help me about it?
Title: Blank Page
Post by: mk.keck on November 11, 2009, 05:14:15 AM
the problems with blank page seems to be happen if the roundcube started the first time for the logged into mail-account. Silly reload the page and it would work perfect.