I can't answer for Sebastien, but in my case it was 5.6.22 (installed from mysql-community repo on centos7).
Do you have a link to the mysql bug? -- Erik On Wed, Jan 14, 2015 at 4:10 PM, Raja Pullela <raja.pull...@citrix.com> wrote: > 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. > > > > >
