Erik Weber created CLOUDSTACK-8157:
--------------------------------------
Summary: 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)
