You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2015/01/14 14:58:35 UTC
[jira] [Commented] (CLOUDSTACK-8157) CloudStack setup-databases
doesn't like MySQL 5.6 and gives no database selected
[ 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 <te...@gmail.com>
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)