On Dec 5, 2014, at 9:20 AM, Rohit Yadav <rohit.ya...@shapeblue.com> wrote:
> Hi Sebastien, > > Which build/version of CloudStack are you using? this is 4.3.1 from packages, ubuntu 14.04 but I think it's an issue with my setup. that schema file has not changed in more than a year and is the same in all branches. I will keep investigating. adding use cloud (like Erik mentioned) solved the issue. > >> On 05-Dec-2014, at 7:22 pm, Erik Weber <terbol...@gmail.com> wrote: >> >> 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 ? >>> >>> >> - 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.ya...@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.
