sureshanaparti commented on PR #11239:
URL: https://github.com/apache/cloudstack/pull/11239#issuecomment-3126230388
Verfied `cloudstack-setup-databases` without cloud & cloud_usage databases,
and with cloud / cloud_usage databases (using --force-recreate).
- _cloudstack-setup-databases_ with cloud database, no --force-recreate
option.
```
[root@ol8 ~]# cloudstack-setup-databases cloud:cloud@localhost
--deploy-as=root:*********
Mysql user name:cloud
[ OK ]
Mysql user password:******
[ OK ]
Mysql server ip:localhost
[ OK ]
Mysql server port:3306
[ OK ]
Mysql root user name:root
[ OK ]
Mysql root user password:******
[ OK ]
Checking Cloud database files ...
[ OK ]
Checking local machine hostname ...
[ OK ]
Checking SELinux setup ...
[ OK ]
Detected local IP address as 10.0.34.59, will use as cluster management
server node IP[ OK ]
Preparing /etc/cloudstack/management/db.properties
[ OK ]
We apologize for below error:
***************************************************************
Aborting script as the databases (cloud, cloud_usage) already exist.
Please use the --force-recreate parameter if you want to recreate the
schemas.
***************************************************************
Please run:
cloudstack-setup-databases -h
for full help
[root@ol8 ~]#
```
- _cloudstack-setup-databases_ with cloud database, using --force-recreate
option.
```
[root@ol8 ~]# cloudstack-setup-databases cloud:cloud@localhost
--deploy-as=root:********* --force-recreate
Mysql user name:cloud
[ OK ]
Mysql user password:******
[ OK ]
Mysql server ip:localhost
[ OK ]
Mysql server port:3306
[ OK ]
Mysql root user name:root
[ OK ]
Mysql root user password:******
[ OK ]
Checking Cloud database files ...
[ OK ]
Checking local machine hostname ...
[ OK ]
Checking SELinux setup ...
[ OK ]
Detected local IP address as 10.0.34.59, will use as cluster management
server node IP[ OK ]
Preparing /etc/cloudstack/management/db.properties
[ OK ]
Applying /usr/share/cloudstack-management/setup/create-database.sql
[ OK ]
Applying /usr/share/cloudstack-management/setup/create-schema.sql
[ OK ]
Applying /usr/share/cloudstack-management/setup/create-database-premium.sql
[ OK ]
Applying /usr/share/cloudstack-management/setup/create-schema-premium.sql
[ OK ]
Applying /usr/share/cloudstack-management/setup/server-setup.sql
[ OK ]
Applying /usr/share/cloudstack-management/setup/templates.sql
[ OK ]
Processing encryption ...
[ OK ]
Finalizing setup ...
[ OK ]
CloudStack has successfully initialized database, you can check your
database configuration in /etc/cloudstack/management/db.properties
[root@ol8 ~]#
```
- _cloudstack-setup-databases_ after dropping cloud & cloud_usage databases
```
mysql> drop database cloud;
Query OK, 136 rows affected (1.54 sec)
mysql> drop database cloud_usage;
Query OK, 15 rows affected (0.13 sec)
mysql> exit
Bye
[root@ol8 ~]# cloudstack-setup-databases cloud:cloud@localhost
--deploy-as=root:*********
Mysql user name:cloud
[ OK ]
Mysql user password:******
[ OK ]
Mysql server ip:localhost
[ OK ]
Mysql server port:3306
[ OK ]
Mysql root user name:root
[ OK ]
Mysql root user password:******
[ OK ]
Checking Cloud database files ...
[ OK ]
Checking local machine hostname ...
[ OK ]
Checking SELinux setup ...
[ OK ]
Detected local IP address as 10.0.34.59, will use as cluster management
server node IP[ OK ]
Preparing /etc/cloudstack/management/db.properties
[ OK ]
Applying /usr/share/cloudstack-management/setup/create-database.sql
[ OK ]
Applying /usr/share/cloudstack-management/setup/create-schema.sql
[ OK ]
Applying /usr/share/cloudstack-management/setup/create-database-premium.sql
[ OK ]
Applying /usr/share/cloudstack-management/setup/create-schema-premium.sql
[ OK ]
Applying /usr/share/cloudstack-management/setup/server-setup.sql
[ OK ]
Applying /usr/share/cloudstack-management/setup/templates.sql
[ OK ]
Processing encryption ...
[ OK ]
Finalizing setup ...
[ OK ]
CloudStack has successfully initialized database, you can check your
database configuration in /etc/cloudstack/management/db.properties
[root@ol8 ~]#
```
--
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: commits-unsubscr...@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
