I hope I post this in the right forum. I'm using Virtualmin 5.05 on CentOS Linux 7.3.1611.
I am having trouble installing Roundcube on a subdomain. I am using install scripts. The script fails with the following error: "Database connection failed: DBI connect failed : Access denied for user 'xxx'@'localhost' (using password: YES) 1427."
The user xxx is actually the Administration user of the main domain. Passwords are stored encrypted.
What have I tried to fix this?
1) google, google, google, to no avail, I only found one message here in the forum from several years ago from someone having the same problem (but the solution given there did not work)
2) while running the install script, I have both tried to use the MySQL database of the subdomain (it is called webmail) as well as the newly generated one (called webmail_roundcube)
3) I have made sure that the user xxx has rights in the webmail database, by going to Webmin > Servers > MySQL Database Server > User Permissions as well as Database Permissions:
4) While testing, I removed the user, the database, and recreated them, through mysql (while being logged in as root), using the same password as I used creating the virtual host
5) I verified that I can log in in MySQL Workbench on my laptop with these credentials and made sure that the privileges are set just right
6) I verified that the encrypted password which is stored in mysql is the same that is stored in the domain-file in /etc/webmin/virtual-server/domains/ (and it is)
7) I examined the perl script /etc/webmin/virtual-server/latest-scripts/roundcube.pl to see what variables are used there. My knowledge of Perl does not go very far, but I am able to view the variables being used and it sure looks like $dbpass is empty
So, maybe what causes this:
1) the install script does not use the password??
2) the install script cannot use an encrypted password??
3) or is there something completely different going on?
I've been working on this for five or six hours now and I cannot figure this out, I hope this makes sense to someone and that someone has the clue :)