[jira] [Created] (CLOUDSTACK-8157) CloudStack setup-databases doesn't like MySQL 5.6 and gives no database selected

["Erik Weber (JIRA)" <ji...@apache.org>]

Erik Weber created CLOUDSTACK-8157:
--------------------------------------

             Summary: CloudStack setup-databases doesn't like MySQL 5.6 and gives no database selected
                 Key: CLOUDSTACK-8157
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-8157
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
          Components: Install and Setup, Management Server
    Affects Versions: 4.5.0
         Environment: CloudStack from master, but should happen on previous versions as well
            Reporter: Erik Weber


When trying to deploy the database on MySQL 5.6 servers you are met with the following error:

[root@acs45-mgmt01 CloudPlatform-4.5.0.0-rhel7]# cloudstack-setup-databases cloud:password@localhost --deploy-as=root --debug
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.18.252.130, 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       

We apologize for below error:
***************************************************************
Encountering an error when executing mysql script
----------------------------------------------------------------------
table:
/usr/share/cloudstack-management/setup/create-schema-premium.sql

Error:
ERROR 1046 (3D000) at line 285: No database selected


Sql parameters:
{'host': 'localhost', 'user': 'root', 'port': 3306}
----------------------------------------------------------------------
            
***************************************************************
Please run:

    cloud-setup-database -h

for full help



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)