You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Erik Weber (JIRA)" <ji...@apache.org> on 2015/01/15 08:25:34 UTC
[jira] [Resolved] (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:all-tabpanel ]
Erik Weber resolved CLOUDSTACK-8157.
------------------------------------
Resolution: Fixed
Fix Version/s: 4.6.0
Fixed by adding absolute references
> 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)