The perfect server - Jessie 8 VM image - Switch to Roundcube?

Discussion in 'ISPConfig 3 Priority Support' started by JohnnyBeGood, Oct 31, 2017.

  1. JohnnyBeGood

    JohnnyBeGood Member

    Hi,

    As the title says I've downloaded VMware image https://www.howtoforge.com/tutorial...n-8-jessie-apache-bind-dovecot-ispconfig-3/3/ and updated to the latest Debian OS v8.9
    Obviously image came with SquirrelMail v1.4.23 which has awful interface. I would like to install Roundcube webmail.
    My question, can I follow this howto https://www.howtoforge.com/tutorial/roundcube-installation-on-debian-8-jessie/ and install Roundcube and completely remove SquirrelMail or that could brake other stuff on the server? I wanted to ask before making things worse.
    Current version of Roundcube is 1.3.1 and howto is based on 1.1.3
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

  3. JohnnyBeGood

    JohnnyBeGood Member

    Great news! Can I use latest version or that won't work?
    What is the proper way to remove SquirrelMail?
     
  4. JohnnyBeGood

    JohnnyBeGood Member

    I found free time to work on this again and I'm running into first issue:
    Code:
    [email protected]:/opt/roundcube# tar xfz roundcubemail-1.1.3-complete.tar.gz
    [email protected]:/opt/roundcube# mv roundcubemail-1.1.3/* .
    [email protected]:/opt/roundcube# mv roundcubemail-1.1.3/.htaccess .
    [email protected]:/opt/roundcube# rmdir roundcubemail-1.1.3
    [email protected]:/opt/roundcube# rm roundcubemail-1.1.3-complete.tar.gz
    [email protected]:/opt/roundcube# chown -R www-data:www-data /opt/roundcube
    [email protected]:/opt/roundcube# mysql --defaults-file=/etc/mysql/debian.cnf
    ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)
    [email protected]:/opt/roundcube# 
    I did change MySQL password from the default one provided in the VM image and I can login using terminal mysql -u root -p and phpMyAdmin so that means I did it correctly.

    Also, how do I remove SquirrelMail version 1.4.23
    Will this Ubuntu tutorial work http://installion.co.uk/ubuntu/vivid/universe/s/squirrelmail/uninstall/index.html ?
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    You can use the mysql root user instead of debian-sys-maint user to create the database for roundcube.
     
  6. JohnnyBeGood

    JohnnyBeGood Member

    Oh, I did not even realize debian-sys-maint was in /etc/mysql/debian.cnf
    Code:
    # Automatically generated for Debian scripts. DO NOT TOUCH!
    [client]
    host     = localhost
    user     = debian-sys-maint
    password = mysupersecretpassword
    socket   = /var/run/mysqld/mysqld.sock
    [mysql_upgrade]
    host     = localhost
    user     = debian-sys-maint
    password = mysupersecretpassword
    socket   = /var/run/mysqld/mysqld.sock
    basedir  = /usr
    Do I just change user= root there? it won't mess up anything else?
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    No, you just use the command:

    mysql -u root -p

    instead to connect to mysql.
     
  8. JohnnyBeGood

    JohnnyBeGood Member

    Thanks! I ran into same issue but I worked around it by using phpMyAdmin and importing /opt/roundcube/SQL/mysql.initial.sql into created DB.

    Code:
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 10738
    Server version: 10.0.32-MariaDB-0+deb8u1 (Debian)
    
    Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    MariaDB [(none)]> CREATE DATABASE roundcubemail;
    Query OK, 1 row affected (0.00 sec)
    
    MariaDB [(none)]> GRANT ALL PRIVILEGES ON roundcubemail.* TO [email protected] IDENTIFIED BY 'mysupersecretpassword';
    Query OK, 0 rows affected (0.00 sec)
    
    MariaDB [(none)]> flush privileges;
    Query OK, 0 rows affected (0.00 sec)
    
    MariaDB [(none)]> quit
    Bye
    [email protected]:/opt/roundcube# mysql --defaults-file=/etc/mysql/debian.cnf roundcubemail < /opt/roundcube/SQL/mysql.initial.sql
    ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)
    [email protected]:/opt/roundcube# 
    I was able to install stable v1.3.4 just renamed commands for unpacking etc.
    Now I'm getting this http://prntscr.com/i1iyb4
    I assume the issue was with this line
    $rcmail_config['soap_url'] = 'https://subdomain.mydomain.us:8080/remote/';
    but my ispconfig is already secured with paid wildcard SSL for my server subdomain http://prntscr.com/i1izk4
    Any suggestions?
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    Add your remote IP address in the allowed IP field of the remote user that you use for this connection in ISPConfig.
     
  10. JohnnyBeGood

    JohnnyBeGood Member

    Thank you!
    In case someone runs into same issue https://prnt.sc/i21dmd if you have static IP you can enter it there otherwise leave it blank.
     

Share This Page