I solved it by referencing the relevant queries to the cloud database. A backward compatible fix has been submitted and merged.
Erik Den torsdag 15. januar 2015 skrev Raja Pullela <raja.pull...@citrix.com> følgende: > Hi Erik, don't believe an issue was created on mysql... still needs to be > investigated to why the SQL script will work on one version and not on the > other? You can downgrade to 5.6.21 and try it again, in case you are > interested? > > Raja > > -----Original Message----- > From: Erik Weber [mailto:terbol...@gmail.com <javascript:;>] > Sent: Thursday, January 15, 2015 12:40 PM > To: dev > Subject: Re: weird db setup issue > > 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 > <javascript:;>> > 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 <javascript:;>] > > 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 > <javascript:;>> > > wrote: > > > > > > > > On Dec 5, 2014, at 9:20 AM, Rohit Yadav <rohit.ya...@shapeblue.com > <javascript:;>> > > 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 > <javascript:;>> wrote: > > > >> > > > >> On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen > > > >> <run...@gmail.com <javascript:;>> > > > 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.s > > > >>> ql > > > [ 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 <javascript:;> > > > > 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. > > > > > > > > >