This happens on a new installation of Citrix CloudPlatform 4.5.0 as well. If anyone has time, we should check if this happens on ACS 4.5 and fix it
-- Erik On Fri, Dec 5, 2014 at 9:27 PM, Sebastien Goasguen <run...@gmail.com> wrote: > > 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. > >