Sebastien, Can you check your MySQL version ? Is it 5.6.22 or above ? There was an issue with MySQL 5.6.22 - where in the SQL file mentioned returns an error, runs fine on MySQL 5.6.21 and below. You can downgrade/install the MySQL that is packaged with 4.5.0 OR update the SQL to include the "use cloud" before the SQL command.
Raja -----Original Message----- From: Erik Weber [mailto:terbol...@gmail.com] Sent: Wednesday, January 14, 2015 4:53 PM To: dev Subject: Re: weird db setup issue 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. > >
