cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag Sonstebo <Dag.Sonst...@shapeblue.com>
Subject Re: installation-database
Date Thu, 21 Feb 2019 09:36:03 GMT
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" <thomas.job07@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
  
 

Mime
View raw message