Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: mfg on September 05, 2020, 12:00:38 AM

Title: cannot install in ubuntu server 20.04
Post by: mfg on September 05, 2020, 12:00:38 AM
I had roundcube running nicely in ubuntu server 19.10.
Upgraded to 20.04 and I cannot get it to configure correctly.
Purged everything and reinstalled but to no avail.
Terminal output attached.
Title: Re: cannot install in ubuntu server 20.04
Post by: mfg on September 05, 2020, 09:29:20 AM
addendum
when trying to access an account, the program searches for a while and then returns 'login failed'
Title: Re: cannot install in ubuntu server 20.04
Post by: sw2090 on October 07, 2020, 10:59:05 AM
Looks like something is wrong with your mysqldb.
In your txt I see that it starts installing roundcube and then complains about being denied by mysqld trying to access it as root with no password.
It does finish though but it does not install the database for roundcube...

This is wondering me because dbconfig determines the credentials from /etc/mysql/debian.cnf which normally contains the system maintainer (debian-sys-maint) which it can use to create databases.

Addendum:

I just looked at an ubuntu 20.04 server of my own and indeed the /etc/mysql/debian.cnf has user root and no passwort.

So I suggest to uninstall the roundcube package again. Then enter the correct credentials into /etc/mysql/debian.cnf and then install roundcube again.

If you use native debian this file has the debian_sys_maint plus password generated when you install mysqld on native debian.

Title: Re: cannot install in ubuntu server 20.04
Post by: mfg on October 07, 2020, 12:37:27 PM
Thank you so much for your reply.
I had to change the db so that it could be accessed without passwd. Then dpkg-reconfigure roundcube and roundcube-core.
after that I put the db password again.
your suggestions were of great help!
Title: Re: cannot install in ubuntu server 20.04
Post by: sw2090 on October 08, 2020, 07:09:06 AM
entering the password into /etc/mysql/debian.cnf would have done the trick too.

Glad to hear it works now.

Well I've been Unix server admin for like 12 years so I learned a lot during this time and if it can help others... ;)

Cheers
Sebastian
Title: Re: cannot install in ubuntu server 20.04
Post by: mfg on October 08, 2020, 11:10:42 AM
I am trying to implement your solution, it is much better. But ...

The  /etc/mysql/debian.cnf file is as follows:

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = root
password =
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = root
password =
socket   = /var/run/mysqld/mysqld.sock
basedir  = /usr

How do I enter the correct credentials. Just put the password after the equal signs? 
I am also worried that the file starts with the warning 'DO NOT TOUCH'. Please comment ...
Title: Re: cannot install in ubuntu server 20.04
Post by: sw2090 on October 09, 2020, 02:19:11 AM
yes just enter the password after the "=".

In debian you should not touch this because it is using the sys_maint user and touching the file can cause trouble.
Just entering the password will not cause any trouble.

hth
Sebastian
Title: Re: cannot install in ubuntu server 20.04
Post by: mfg on October 09, 2020, 10:11:48 AM
excellent!
thanks.