Hi, system setup : ISPconfig 3.0.5.3 multi-server setup on debian squeeze. I was wondering if there is a guide for installing roundcube on ispconfig multi-server setup. The guide I have found is : http://www.howtoforge.com/how-to-install-roundcube-0.7-for-ispconfig-3-on-debian-squeeze But it looks like a guide for the perfect server. I was also wondering what server I install roundcube and the roundcube database on as I have a mail server that I want to use. Thanks for your help.
You should be able to use the same guide on a multiserver setup: 1) Install roundcube on the web server node. 2) edit the roundcube main.inc.php file and set the imap and smtp server to the hostname of the ailserver. you should also enable in main.inc.php that roundcube should authenticate itself when sending by smtp with the login username and password of the mail user, there is a option for that in this file, dont remember the exact name.
Hi till I really like ISPconfig and appreciate the work (and support) you all do. I searched for updated instructions to install roundcube on ISPconfig/ubuntu 12.04/mirror-cluster, but couldn't find any. Is the mentioned guide to install roundcube the one for me to use with my(see below) multiserver setup? Also as mentioned in other posts, 0.7 is rather old. Any updated howtos or tips'n tricks? -- I would really love to change from squirrel to roundcube.-- //millpark10
Yes. The guide is up to date, it installs the latest available roundcube package for your Linux distribution and it mentions also to change the mailserver hostname to the mailserver which is required for multiserver setups.
Hi Till Followed http://www.howtoforge.com/how-to-install-roundcube-0.7-for-ispconfig-3-on-debian-squeeze Only deviation was I installed roundcube 0.9.5 instead and had problems to connect with SSL. Solved that and (wrong ports, I use non standard) Now I am out of ideas. Can reach the roundcube login page via https://mydomain.net:8080/webmail/ but when trying to login it says: "Connection to storage server failed" I guess it has something to do with MySQL login but can't see what to do. From other guides I found there should be a remote user, created one with same name and pwd as for the roundcube database. Still, "Connection to storage server failed" Pls any idea? //millpark10
ispconfig remote users are not related to this problem, so if the other guides suggested to create one, then they are wrong. If a error is related to a remote user, then the error message starts with SOAP error. Your problem is that roundcube is not able to connect to the local mysql server. the guide installed roundcube from the debian repository which creates the roundcube user and database automatically. If you downloaded roundcube from a different source, then you will have to do all these database related steps manually. How exactly did you install these other roundcube version? Did you create the mysql user and database manually for it and did you configure this database connection in the roundcube config file manually?
Till With all due respect, I think we talk about different guides! Or the howto I followed has links not visible for me to debian repository. Code: P2 Download and extract RoundCube First we make a folder for the webmail and change directory: mkdir /var/www/webmail/ cd /var/www/ Then we download the latest stable version of RoundCube from http://www.roundcube.net/download and extract it: wget http://sourceforge.net/projects/roundcubemail/files/roundcubemail/0.7/roundcubemail-0.7.tar.gz tar xfz roundcubemail-0.7.tar.gz mv roundcubemail-0.7/* webmail rm roundcubemail-0.7.tar.gz rm -rf roundcubemail-0.7 I just changed 0.7 to 0.9.5 and thougt it was a smart move. Then cd webmail chown -R www-data:www-data temp/ logs/ Code: root@penny1:/var/www/webmail# ls -las totalt 140 4 drwxr-xr-x 11 root root 4096 mar 8 21:06 . 4 drwxr-xr-x 9 root root 4096 mar 8 21:08 .. 4 drwxr-xr-x 2 501 80 4096 mar 8 21:05 bin 20 -rw-r--r-- 1 501 80 16968 okt 21 21:39 CHANGELOG 4 -rw-r--r-- 1 501 80 381 okt 21 21:39 composer.json-dist 4 drwxr-xr-x 2 501 80 4096 mar 9 01:07 config 12 -rw-r--r-- 1 501 80 11999 okt 21 21:39 index.php 12 -rw-r--r-- 1 501 80 8677 okt 21 21:39 INSTALL 4 drwxr-xr-x 3 501 80 4096 mar 8 21:05 installer 36 -rw-r--r-- 1 501 80 35147 okt 21 21:39 LICENSE 4 drwxr-xr-x 2 www-data www-data 4096 mar 8 21:05 logs 4 drwxr-xr-x 30 501 80 4096 mar 8 21:05 plugins 4 drwxr-xr-x 8 501 80 4096 mar 8 21:05 program 4 -rw-r--r-- 1 501 80 3758 okt 21 21:39 README.md 4 -rw-r--r-- 1 501 80 26 okt 21 21:39 robots.txt 4 drwxr-xr-x 4 501 80 4096 mar 8 21:05 skins 4 drwxr-xr-x 6 501 80 4096 mar 8 21:05 SQL 4 drwxr-xr-x 2 www-data www-data 4096 mar 8 21:05 temp 4 -rw-r--r-- 1 501 80 2712 okt 21 21:39 UPGRADING Then Code: 3 Prepare the database Now we want to add a user and database for our RoundCube installation. With MySQL you can set up the database by issuing the following commands: (Logged into MySQL as root and:) CREATE DATABASE roundcubemail; GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcubeuser@localhost IDENTIFIED BY 'password'; (I used roundcubemail as db, roundcubeuser as user and choose a password) Then we want to flush the users privileges or you will get a database connection error: FLUSH PRIVILEGES; //millpark10
Till After reading your last comment again I was convinced you talked about another "howto". Maybe you are. BUT, when someone ask the gurus in these forums about stuff, the one asking usually managed, all by themselfes, to scr-w things up. So I looked over what I did and again could not find anything wrong. Double checked the final entries from "P6 Final tweaks" in main.inc.php. This time I searched in the file while editing in vim, by entering "/default_host". I found two entries! In fact the whole file was merged twice into one file! Probably the installscript while run from the browser had a hickup, and parsed it twice, cant find any other explanation. Cut away half the file and rechecked entries, restarted apache. Guess what, it works! (will check all functions, but seems ok!) Thanks again Till and others for doing all this work! //millpark10
Ok, good, I thought I really missed something. Question then, is there a better way to do this ? I am still a bit confused about how to do things with the mirror (server2)? As I use unison every file in the structure below /var/www/ will be copied to server2. What more do I need to consider? I will also install the Plugins via https://github.com/w2c/ispconfig3_roundcube/wiki/_pages and wonder if I should run the installer on server2 as well? For now I see server2 as a "hot-standby for manual failover" My next mirrored server setup is aimed to be more redundant, with automatic failover and loadbalancing. e.g. as safe and secure as ever possible. Maybe continue this discussion in thread.
As unison mirrors the whole configuration over to the second server and you installed roundcube in a directory inside /var/www, the installation should be done only on the first server. But you should check of the mysql user and database that you created has been morrored over to the seconds mysql server as well.
Thanx again Till, I followed the howto(s) and MySQL-replication is setup and working. I use a simple script to check replication is active every 5 min. (posted the script in this thread). Hmm, I made updates to this script, will soon upload the updated version, in case anyone is interested in using it. (Noticed I have a problem with jailkit! Reading forum threads about it trying to find a solution.) //millpark10