can't see any problem there this is the full output of the previous command
root@cloudstack1:/home/team# cloudstack-setup-databases cloud:123@10.8.9.230
--deploy-as=root:123 -i 10.8.9.230
Mysql user name:cloud
[ OK ]
Mysql user password:******
[ OK ]
Mysql server ip:10.8.9.230
[ OK ]
Mysql server port:3306
[ OK ]
Mysql root user name:root
[ OK ]
Mysql root user password:******
[ OK ]
Using specified cluster management server node IP 10.8.9.230
[ OK ]
Checking Cloud database files ...
[ OK ]
Checking local machine hostname ...
[ OK ]
Checking SELinux setup ...
[ OK ]
Preparing /etc/cloudstack/management/db.properties
[ OK ]
Applying /usr/share/cloudstack-management/setup/create-database.sql
We apologize for below error:
***************************************************************
Encountering an error when executing mysql script
----------------------------------------------------------------------
table:
/usr/share/cloudstack-management/setup/create-database.sql
Error:
mysql: [Warning] Using a password on the command line interface can be
insecure.
ERROR 2003 (HY000): Can't connect to MySQL server on '10.8.9.230' (111)
Sql parameters:
{'passwd': '123', 'host': '10.8.9.230', 'user': 'root', 'port': 3306}
----------------------------------------------------------------------
On Wed, Feb 20, 2019 at 2:02 PM Ivan Kudryavtsev <kudryavtsev...@bw-sw.com>
wrote:
> Looks like this is what exactly means. Check your mysql configuration for
> root connection from the host you use to deploy. First try with 'mysql'
> cli utility.
>
> ср, 20 февр. 2019 г. в 13:46, Alejandro Ruiz Bermejo <
> arbermejo0...@gmail.com>:
>
> > i got this error when creating the cloudstack management database and
> don't
> > know where the problem is. Any idea??
> >
> > the command i use was cloudstack-setup-databases cloud:123@10.8.9.230
> > --deploy-as=root:123 -i 10.8.9.230
> >
> >
> > ERROR 2003 (HY000): Can't connect to MySQL server on '10.8.9.230' (111)
> >
> >
> > Sql parameters:
> > {'passwd': '123', 'host': '10.8.9.230', 'user': 'root', 'port': 3306}
> >
> > this is the content of /etc/cloudstack/management/db.properties
> >
> > cluster.node.IP=10.8.9.230
> > cluster.servlet.port=9090
> > region.id=1
> >
> > # CloudStack database settings
> > db.cloud.username=cloud
> > db.cloud.password=cloud
> > db.cloud.host=localhost
> > db.cloud.driver=jdbc:mysql
> > db.cloud.port=3306
> > db.cloud.name=cloud
> >
>
>
> --
> With best regards, Ivan Kudryavtsev
> Bitworks LLC
> Cell RU: +7-923-414-1515
> Cell USA: +1-201-257-1512
> WWW: http://bitworks.software/ <http://bw-sw.com/>
>
