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

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

 

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

 

I found free time to work on this again and I'm running into first issue:

Code:

root@debian:/opt/roundcube# tar xfz roundcubemail-1.1.3-complete.tar.gz
root@debian:/opt/roundcube# mv roundcubemail-1.1.3/* .
root@debian:/opt/roundcube# mv roundcubemail-1.1.3/.htaccess .
root@debian:/opt/roundcube# rmdir roundcubemail-1.1.3
root@debian:/opt/roundcube# rm roundcubemail-1.1.3-complete.tar.gz
root@debian:/opt/roundcube# chown -R www-data:www-data /opt/roundcube
root@debian:/opt/roundcube# mysql --defaults-file=/etc/mysql/debian.cnf
ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)
root@debian:/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 ?

 

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?

 

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 roundcube@localhost 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
root@debian:/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)
root@debian:/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?

 

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.