cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rohit Yadav <rohit.ya...@shapeblue.com>
Subject Re: weird db setup issue
Date Fri, 05 Dec 2014 14:20:21 GMT
Hi Sebastien,

Which build/version of CloudStack are you using?

> On 05-Dec-2014, at 7:22 pm, Erik Weber <terbolous@gmail.com> wrote:
>
> 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 ?
>>
>>
> - the create-database* scripts doesn't need a selected database
> - the create-schema.sql script starts by selecting the database (use cloud;)
>
> create-schema-premium.sql doesn't have the same selection at start, and I'm
> no sql guru but it could be a foreign key or something else without an
> explicit schema that fails.
> you should probably be able to workaround it by adding a "use cloud;" early
> in the create-schema-premium.sql file
>
> that's my two cent.
>
> --
> Erik

Regards,
Rohit Yadav
Software Architect, ShapeBlue
M. +91 88 262 30892 | rohit.yadav@shapeblue.com
Blog: bhaisaab.org | Twitter: @_bhaisaab



Find out more about ShapeBlue and our range of CloudStack related services

IaaS Cloud Design & Build<http://shapeblue.com/iaas-cloud-design-and-build//>
CSForge – rapid IaaS deployment framework<http://shapeblue.com/csforge/>
CloudStack Consulting<http://shapeblue.com/cloudstack-consultancy/>
CloudStack Software Engineering<http://shapeblue.com/cloudstack-software-engineering/>
CloudStack Infrastructure Support<http://shapeblue.com/cloudstack-infrastructure-support/>
CloudStack Bootcamp Training Courses<http://shapeblue.com/cloudstack-training/>

This email and any attachments to it may be confidential and are intended solely for the use
of the individual to whom it is addressed. Any views or opinions expressed are solely those
of the author and do not necessarily represent those of Shape Blue Ltd or related companies.
If you are not the intended recipient of this email, you must neither take any action based
upon its contents, nor copy or show it to anyone. Please contact the sender if you believe
you have received this email in error. Shape Blue Ltd is a company incorporated in England
& Wales. ShapeBlue Services India LLP is a company incorporated in India and is operated
under license from Shape Blue Ltd. Shape Blue Brasil Consultoria Ltda is a company incorporated
in Brasil and is operated under license from Shape Blue Ltd. ShapeBlue SA Pty Ltd is a company
registered by The Republic of South Africa and is traded under license from Shape Blue Ltd.
ShapeBlue is a registered trademark.
Mime
View raw message