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 Wed, 14 Jan 2015 15:10:03 GMT
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.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.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