[jira] [Created] (CLOUDSTACK-1226) Error while running Cloudstack-setup-databases

["Kiran Koneti (JIRA)" <ji...@apache.org>]

Kiran Koneti created CLOUDSTACK-1226:
----------------------------------------

             Summary: Error while running Cloudstack-setup-databases 
                 Key: CLOUDSTACK-1226
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-1226
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
          Components: Install and Setup
    Affects Versions: 4.1.0
            Reporter: Kiran Koneti
            Assignee: Rohit Yadav
            Priority: Critical
             Fix For: 4.1.0


When we run the Cloud-setup-databases script the below error message is observed.
"We apologize for below error:
***************************************************************
Encountering an error when executing mysql script
----------------------------------------------------------------------
table:
/usr/share/cloudstack-management/setup/4.1-new-db-schema.sql

Error:
ERROR 1046 (3D000) at line 18: No database selected


Sql parameters:
{'passwd': 'password', 'host': 'localhost', 'user': 'root', 'port': 3306}
----------------------------------------------------------------------

***************************************************************
Please run:

    cloud-setup-database -h"

The work around for this is edit the below file 

 /usr/share/cloudstack-management/setup/4.1-new-db-schema.sql 

add the use cloud; at the starting.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira