penguin2716 commented on issue #9815:
URL: https://github.com/apache/cloudstack/issues/9815#issuecomment-2436551808
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"
```
--
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]
