Check firewalls and check if port 3306 is listening on ip 10.8.9.230 With regards Thomas
On Wed, 20 Feb 2019, 7:14 pm Alejandro Ruiz Bermejo, < arbermejo0...@gmail.com> wrote: > 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/> > > >