installing roundcube

Discussion in 'ISPConfig 3 Priority Support' started by saco721, Jan 22, 2014.

  1. saco721

    saco721 Member HowtoForge Supporter

    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.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  3. millpark10

    millpark10 Member

    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
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  5. millpark10

    millpark10 Member

    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
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    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?
     
  7. millpark10

    millpark10 Member

    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:
    [email protected]:/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 [email protected] 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
     
  8. millpark10

    millpark10 Member

    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
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    Sorry, I misssed that. I meant another guide indeed.
     
  10. millpark10

    millpark10 Member

    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.
     
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  12. millpark10

    millpark10 Member

    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
     

Share This Page