cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raja Pullela <raja.pull...@citrix.com>
Subject RE: weird db setup issue
Date Thu, 15 Jan 2015 16:43:23 GMT
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:terbolous@gmail.com] 
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.pullela@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:terbolous@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 <runseb@gmail.com>
> wrote:
>
> >
> > On Dec 5, 2014, at 9:20 AM, Rohit Yadav <rohit.yadav@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 <terbolous@gmail.com> wrote:
> > >>
> > >> On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen 
> > >> <runseb@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.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.yadav@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.
> >
> >
>
Mime
View raw message