Roundcube Community Forum
News and Announcements => General Discussion => Topic started 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 :-[
-
Roundcube doesn't need any special software. Just mySQL and PHP. Download the zip or tar-ball and read the INSTALL file inside.
-
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 :)
-
# 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.
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?
-
Just trying to set Round Cube up to be usable.
-
Okay, so here are some simple steps:
- Download RoundCube source (or check out the latest SVN version from the repository)
- Decompress the file to get to the real source of the software
- Upload all files to where you want it to be
- Go into Plesk and create a new database and user (don't forget to attach the user to the database)
- Go into phpMyAdmin and execute the proper SQL file
- Open phpMyAdmin
- Select the database in the left pane
- Click the "IMPORT" tab on top of the right pane
- You want to "upload" a new SQL file for execution. Just browse to the one you want (mysql.initial.sql or mysql-5.initial.sql depending upon your mySQL version)
- Click "go" and wait for success or failure message
- Modify config/main.inc.php and config/db.inc.php
- main.inc.php
- Make sure you specify the default IMAP settings
- Make sure you specify the default SMTP settings
- The rest is essentially optional to configure for now
- db.inc.php
- Make sure you get the connection string right
- Everything else is optional
- Re-upload main.inc.php and db.inc.php to the server
- Browse to your RoundCube installation
- Attempt to Log-In using your email address and password
Sorry it's brief, but I gotta run. Let us know how it goes!!
-
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.
-
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 :)
-
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.
-
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)
-
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.
-
What do you suggest I do Mr Patterson :)
I suppose I can contact my Hosting company and see what options they have for me.
-
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....
-
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!
-
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
-
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 ;)
-
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... ;)
-
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: <?php header("location: http://".$_SERVER["SERVER_NAME"]); ?>
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!
-
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.
-
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
-
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
-
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
-
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
-
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
-
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
-
i did everything.. but webmail.mydomain.com is a blank page :S
-
i did everything.. but webmail.mydomain.com is a blank page :S
same here.... I also followed the instructions, but no luck :(
-
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?
-
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.