[ https://issues.apache.org/jira/browse/CLOUDSTACK-8157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14339894#comment-14339894
]
ASF GitHub Bot commented on CLOUDSTACK-8157:
--------------------------------------------
Github user runseb commented on the pull request:
https://github.com/apache/cloudstack/pull/67#issuecomment-76357813
@bhaisaab has this been ported to 4.5 and master ?
> 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)
|