cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erik Weber <terbol...@gmail.com>
Subject Re: weird db setup issue
Date Wed, 14 Jan 2015 13:59:00 GMT
On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen <runseb@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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message