You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Alejandro Ruiz Bermejo <ar...@gmail.com> on 2019/02/20 18:47:33 UTC
installation-database
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
Re: installation-database
Posted by Dag Sonstebo <Da...@shapeblue.com>.
Alejandro,
You haven't told us if the MySQL server is on the same server as management?
In all likelihood this is a MySQL permission issue - log in to it if you can and do a "select user,host from mysql.user;" - I suspect you have set up "root@localhost", but not "root@@10.8.9.230" or "root@%" - or if you are running management and MySQL separately possibly even "root@managementserverIP".
Regards,
Dag Sonstebo
Cloud Architect
ShapeBlue
On 20/02/2019, 22:04, "Thomas Joseph" <th...@gmail.com> wrote:
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, <
arbermejo0417@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_ia@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 <
> > arbermejo0417@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/>
> >
>
Dag.Sonstebo@shapeblue.com
www.shapeblue.com
Amadeus House, Floral Street, London WC2E 9DPUK
@shapeblue
Re: installation-database
Posted by Thomas Joseph <th...@gmail.com>.
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, <
arbermejo0417@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_ia@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 <
> > arbermejo0417@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/>
> >
>
Re: installation-database
Posted by Alejandro Ruiz Bermejo <ar...@gmail.com>.
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 <ku...@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 <
> arbermejo0417@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/>
>
Re: installation-database
Posted by Ivan Kudryavtsev <ku...@bw-sw.com>.
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 <
arbermejo0417@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/>