[
https://issues.apache.org/jira/browse/CLOUDSTACK-8157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14339314#comment-14339314
]
ASF GitHub Bot commented on CLOUDSTACK-8157:
--------------------------------------------
Github user resmo commented on the pull request:
https://github.com/apache/cloudstack/pull/67#issuecomment-76288584
@bhaisaab This also fails on cloudstack 4.4.2 on debian 7. fix worked.
> 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
> Fix For: 4.6.0
>
>
> 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)
