On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen <run...@gmail.com> wrote:
> Hi, > > I am trying to dockerize the whole cloudstack installation process. > > When running cloudstack-setup-database I hit this weird issue: > > Detected local IP address as 172.17.0.25, 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 > > > Does this ring a bell to anyone ? why would the first schema be created > successfully and not create-schema-premium ? > > I solved the issue and it seems related to MySQL What mysql version are/were you running? I just confirmed that the SQL query is accepted on MySQL 5.1, but not on MySQL 5.6. I guess they became a bit more strict somewhere in between. Adding absolute references solves it. See PR #67 for a fix -- Erik
