[ https://issues.apache.org/jira/browse/CLOUDSTACK-8157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rohit Yadav reassigned CLOUDSTACK-8157: --------------------------------------- Assignee: Rohit Yadav > 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 > Assignee: Rohit Yadav > > 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)