whitetiger264 opened a new issue, #6734:
URL: https://github.com/apache/cloudstack/issues/6734
Hello
I have installed a new CloudStack instance on a clean AlmaLinux 8 server. I
have followed the documentation thoroughly and my instance is currently
running, partially:
```
root@hostname /etc/cloudstack/management $ systemctl status
cloudstack-management
● cloudstack-management.service - CloudStack Management Server
Loaded: loaded (/usr/lib/systemd/system/cloudstack-management.service;
enabled; vendor preset: disabled)
Active: active (running) since Mon 2022-09-12 20:35:22 SAST; 2min 51s ago
Main PID: 3809 (java)
Tasks: 41 (limit: 409574)
Memory: 771.9M
CGroup: /system.slice/cloudstack-management.service
└─3809 /usr/bin/java
-Djava.security.properties=/etc/cloudstack/management/java.security.ciphers
-Djava.awt.headless=true -Dcom.sun.management.jmxremote=false -Xmx2G
-XX:+UseParallelGC -XX:MaxGCPause>
```
The problem, however, it does not want to connect to the database:
`Sep 12 20:35:32 hostname java[3809]: Caused by:
com.mysql.cj.exceptions.CJException: Access denied for user 'cloud'@'localhost'
(using password: YES)`
When running:
`cloudstack-setup-databases cloud:PASSWORD@localhost --schema-only` I get
the following:
```
Mysql user name:cloud
[ OK ]
Mysql user password:******
[ OK ]
Mysql server ip:localhost
[ OK ]
Mysql server port:3306
[ OK ]
Checking Cloud database files ...
[ OK ]
Checking local machine hostname ...
[ OK ]
Checking SELinux setup ...
[ OK ]
Detected local IP address as SERVER IP, will use as cluster management
server node IP[ OK ]
Preparing /etc/cloudstack/management/db.properties
[ OK ]
Applying /usr/share/cloudstack-management/setup/create-schema.sql
We apologize for below error:
***************************************************************
Encountering an error when executing mysql script
----------------------------------------------------------------------
table:
/usr/share/cloudstack-management/setup/create-schema.sql
Error:
b"mysql: [Warning] Using a password on the command line interface can be
insecure.\nERROR 1045 (28000): Access denied for user 'cloud'@'localhost'
(using password: YES)\n"
Sql parameters:
{'user': 'cloud', 'passwd': 'J!g5byjT7', 'port': 3306, 'host': 'localhost'}
```
I found the exact same error reported
[here](https://users.cloudstack.apache.narkive.com/CEpC88un/mysql-setup-database-error-1044-access-denied-for-user-root#post9),
sadly, the solutions provided here does not work.
Can anyone assist with this, please?
--
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]
