You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Sebastien Goasguen <ru...@gmail.com> on 2014/12/05 14:32:50 UTC
weird db setup issue
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 ?
thx
-sebastien
Re: weird db setup issue
Posted by Nate Gordon <na...@appcore.com>.
We just ran into this issue on moving from 5.5.40 -> 5.5.41 as well on
Ubuntu (new package released this morning for 14.04). Forcing it back to
5.5.35 (official release version) works around it as well. I look forward
to this making it into release versions soon. It was mildly unexpected to
say the least. Do we need to add something to the documentation noting a
maximum version of mysql for the existing releases?
On Thu, Jan 15, 2015 at 12:35 PM, Erik Weber <te...@gmail.com> wrote:
> 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 <ra...@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:terbolous@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.pullela@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:terbolous@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 <runseb@gmail.com
> > <javascript:;>>
> > > wrote:
> > >
> > > >
> > > > On Dec 5, 2014, at 9:20 AM, Rohit Yadav <rohit.yadav@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 <terbolous@gmail.com
> > <javascript:;>> wrote:
> > > > >>
> > > > >> On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen
> > > > >> <runseb@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.yadav@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.
> > > >
> > > >
> > >
> >
>
--
*Nate Gordon*Director of Technology | Appcore - the business of cloud
computing®
Office +1.800.735.7104 | Direct +1.515.612.7787
nate.gordon@appcore.com | www.appcore.com
----------------------------------------------------------------------
The information in this message is intended for the named recipients only.
It may contain information that is privileged, confidential or otherwise
protected from disclosure. If you are not the intended recipient, you are
hereby notified that any disclosure, copying, distribution, or the taking
of any action in reliance on the contents of this message is strictly
prohibited. If you have received this e-mail in error, do not print it or
disseminate it or its contents. In such event, please notify the sender by
return e-mail and delete the e-mail file immediately thereafter. Thank you.
Re: weird db setup issue
Posted by Erik Weber <te...@gmail.com>.
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 <ra...@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:terbolous@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.pullela@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:terbolous@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 <runseb@gmail.com
> <javascript:;>>
> > wrote:
> >
> > >
> > > On Dec 5, 2014, at 9:20 AM, Rohit Yadav <rohit.yadav@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 <terbolous@gmail.com
> <javascript:;>> wrote:
> > > >>
> > > >> On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen
> > > >> <runseb@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.yadav@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.
> > >
> > >
> >
>
RE: weird db setup issue
Posted by Raja Pullela <ra...@citrix.com>.
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 <ra...@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 <ru...@gmail.com>
> wrote:
>
> >
> > On Dec 5, 2014, at 9:20 AM, Rohit Yadav <ro...@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 <te...@gmail.com> wrote:
> > >>
> > >> On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen
> > >> <ru...@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.
> >
> >
>
Re: weird db setup issue
Posted by Erik Weber <te...@gmail.com>.
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 <ra...@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 <ru...@gmail.com>
> wrote:
>
> >
> > On Dec 5, 2014, at 9:20 AM, Rohit Yadav <ro...@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 <te...@gmail.com> wrote:
> > >>
> > >> On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen
> > >> <ru...@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.
> >
> >
>
RE: weird db setup issue
Posted by Raja Pullela <ra...@citrix.com>.
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 <ru...@gmail.com> wrote:
>
> On Dec 5, 2014, at 9:20 AM, Rohit Yadav <ro...@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 <te...@gmail.com> wrote:
> >>
> >> On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen
> >> <ru...@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.
>
>
Re: weird db setup issue
Posted by Erik Weber <te...@gmail.com>.
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 <ru...@gmail.com> wrote:
>
> On Dec 5, 2014, at 9:20 AM, Rohit Yadav <ro...@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 <te...@gmail.com> wrote:
> >>
> >> On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen <ru...@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.
>
>
Re: weird db setup issue
Posted by Sebastien Goasguen <ru...@gmail.com>.
On Dec 5, 2014, at 9:20 AM, Rohit Yadav <ro...@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 <te...@gmail.com> wrote:
>>
>> On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen <ru...@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.
Re: weird db setup issue
Posted by Rohit Yadav <ro...@shapeblue.com>.
Hi Sebastien,
Which build/version of CloudStack are you using?
> On 05-Dec-2014, at 7:22 pm, Erik Weber <te...@gmail.com> wrote:
>
> On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen <ru...@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.
Re: weird db setup issue
Posted by Erik Weber <te...@gmail.com>.
On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen <ru...@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
Re: weird db setup issue
Posted by Rohit Yadav <ro...@shapeblue.com>.
Sebastien,
Can you try again with latest 4.3/4.4/4.5/master and see if it works after Erik’s fix?
Keep us posted.
> On 14-Jan-2015, at 7:29 pm, Erik Weber <te...@gmail.com> wrote:
>
> On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen <ru...@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 ?
>>
>>
> I solved the issue and it seems related to MySQL
>
> What mysql version are/were you running?
>
> I just confirmed that the SQL query is accepted on MySQL 5.1, but not on
> MySQL 5.6.
> I guess they became a bit more strict somewhere in between.
>
> Adding absolute references solves it.
>
> See PR #67 for a fix
>
> --
> 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.
Re: weird db setup issue
Posted by Erik Weber <te...@gmail.com>.
On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen <ru...@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 ?
>
>
I solved the issue and it seems related to MySQL
What mysql version are/were you running?
I just confirmed that the SQL query is accepted on MySQL 5.1, but not on
MySQL 5.6.
I guess they became a bit more strict somewhere in between.
Adding absolute references solves it.
See PR #67 for a fix
--
Erik