[
https://issues.apache.org/jira/browse/CLOUDSTACK-8157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14276919#comment-14276919
]
ASF GitHub Bot commented on CLOUDSTACK-8157:
--------------------------------------------
GitHub user terbolous opened a pull request:
https://github.com/apache/cloudstack/pull/67
CLOUDSTACK-8157: Add absolute schema references to support MySQL 5.6 better
This should fix the problem some people are seeing with
cloudstack-setup-databases complaining about 'No database selected'
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/terbolous/cloudstack mysql56-schema-fix
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/cloudstack/pull/67.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #67
----
commit 396936ea5e84d079394664fd1d0596a94e159855
Author: Erik Weber <[email protected]>
Date: 2015-01-14T13:52:47Z
Add absolute schema references to support MySQL 5.6 better
----
> 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)
