purteppers commented on issue #9815: URL: https://github.com/apache/cloudstack/issues/9815#issuecomment-2447590179
> I have the same issue after upgrading from 4.19.0.0 to 4.19.1.2 on Ubuntu 22.04. MySQL and the management server are running on the same node. After the following steps, the management console works now (although it may not be a good solution since the password is saved in plaintext). The problem may be related to somewhere around encryption / decryption logic? > > 1. downgrade Java version from 17 to 11 > > 2. edit `/etc/cloudstack/management/db.properties` > > > ```diff > --- db.properties.bak 2024-10-25 08:51:07.179157143 +0900 > +++ db.properties 2024-10-25 08:50:10.391852007 +0900 > @@ -22,7 +22,7 @@ > > # CloudStack database settings > db.cloud.username=cloud > -db.cloud.password=ENC(<encrypted_text>) > +db.cloud.password=plain_password_text > db.cloud.host=localhost > db.cloud.driver=jdbc:mysql > db.cloud.port=3306 > @@ -53,7 +53,7 @@ > > # usage database settings > db.usage.username=cloud > -db.usage.password=ENC(<encrypted_text>) > +db.usage.password=plain_password_text > db.usage.host=localhost > db.usage.driver=jdbc:mysql > db.usage.port=3306 > @@ -100,4 +100,4 @@ > db.usage.secondsBeforeRetrySource=3600 > db.usage.queriesBeforeRetrySource=5000 > db.usage.initialTimeout=3600 > -db.cloud.encryptor.version=V2 > +#db.cloud.encryptor.version=V2 > ``` > > ``` > $ java -version > openjdk version "11.0.24" 2024-07-16 > OpenJDK Runtime Environment (build 11.0.24+8-post-Ubuntu-1ubuntu322.04) > OpenJDK 64-Bit Server VM (build 11.0.24+8-post-Ubuntu-1ubuntu322.04, mixed mode, sharing) > > $ mysqld --version > /usr/sbin/mysqld Ver 8.0.39-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu)) > > $ cat /etc/lsb-release > DISTRIB_ID=Ubuntu > DISTRIB_RELEASE=22.04 > DISTRIB_CODENAME=jammy > DISTRIB_DESCRIPTION="Ubuntu 22.04.5 LTS" > ``` I was having the exact same issue on AlmaLinux 9.3 and this resolved the problem as well. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
