[one-users] Installation of OpenNebula 3.2 on Ubuntu OS

Carlos Martín Sánchez cmartin at opennebula.org
Wed Feb 8 06:18:53 PST 2012


Hi,

I don't understand what you are trying to do, but it shouldn't be that
complex. You can use the sqlite3 command to access the default DB:

$ cd /var/lib/one/
$ sqlite3 one.db ".schema"


Maybe your compilation with mysql=yes is not working because you are
missing some dependencies, like libmysqlclient-dev... check [1] & [2] for
 the complete list of requirements.

And OpenNebula does not use any DB environment variable, just the
configuration in oned.conf. At the moment, only sqlite and mysql are
supported.


On a side note, if you want to read the DB for accounting or statistics
that's fine, but if you modify it while opennebula is running, opennebula
won't notice and the differences between the cached objects and the DB will
surely lead to erratical behaviour.

Best regards.

[1] http://opennebula.org/documentation:rel3.2:compile
[2] http://opennebula.org/documentation:rel3.2:build_deps

--
Carlos Martín, MSc
Project Engineer
OpenNebula - The Open Source Toolkit for Data Center Virtualization
www.OpenNebula.org | cmartin at opennebula.org |
@OpenNebula<http://twitter.com/opennebula><cmartin at opennebula.org>


On Wed, Feb 8, 2012 at 1:46 PM, Poul Kristensen <bcc5226 at gmail.com> wrote:

> Hi
>
> I think it would be nice with some logs during installation.
> I found out that it is sqlite and not sqlite3 that is being used.
>
> It does not seem to possible to
> scons  mysql=yes
> when compiling.
> It seems that mysql has to be up an running with the options
> in the config file, where mysql is commented out.
> If the environment variabel DB is substituted(opennebula wide:)) it should
> be possible to change to Postgresql in my understanding.
> Right now I am not able to see tables/columns/types in sqlite DB. I
> have to begin from scratch trying to get mysql to be used instead of
> sqlite.
> When done I will try next step which will include Postgresql.
> At least that is the vision. Using Postgresql will enable some very
> interesting
> grid possibilities using R and large datasets in opennebula cluster.
>
> Regards
> Poul
>
>
>
>
>
>
> 2012/2/7 Poul Kristensen <bcc5226 at gmail.com>:
> > ---------- Forwarded message ----------
> > From: Poul Kristensen <bcc5226 at gmail.com>
> > Date: 2012/2/7
> > Subject: Re: [one-users] Installation of OpenNebula 3.2 on Ubuntu OS
> > To: Carlos Martín Sánchez <cmartin at opennebula.org>
> >
> >
> > Hi Carlos.
> >
> > Opennebula created the DB. I usually work with mysql or postgresql.
> > Resently started with sqlite3. Trying sqlite or sqlite3 does not give an
> API
> > for sql commands. I have not read what sort of DB is used by
> > opennebula if not sqlite(3) or mysql. I am not aware of a sqlite
> > configuration. None of
> > the files indicate the existence of sqlite(3).
> >
> > Regards
> > Poul
> >
> > 2012/2/7 Carlos Martín Sánchez <cmartin at opennebula.org>:
> >> Hi Poul,
> >>
> >> You said in a previous email you wanted to dump your sqlite DB to
> mysql...
> >> What DB configuration are you using? Was that DB created by you, or
> >> opennebula?
> >>
> >> Regards.
> >> --
> >> Carlos Martín, MSc
> >> Project Engineer
> >> OpenNebula - The Open Source Toolkit for Data Center Virtualization
> >> www.OpenNebula.org | cmartin at opennebula.org | @OpenNebula
> >>
> >>
> >>
> >> On Fri, Feb 3, 2012 at 4:27 PM, Poul Kristensen <bcc5226 at gmail.com>
> wrote:
> >>>
> >>> Hi,
> >>>
> >>> How could this happen? A column is missing.
> >>> "
> >>> SQL command was: SELECT oid, body FROM host_pool WHERE state != 4
> >>> ORDER BY last_mon_time ASC LIMIT 15, error: no such column: body
> >>> "
> >>> from the oned.log
> >>>
> >>> Thanks
> >>>
> >>> Poul
> >>>
> >>>
> >>>
> >>> 2012/2/2 Poul Kristensen <bcc5226 at gmail.com>:
> >>> > Hi,
> >>> >
> >>> > Thanks to for your suggestions.
> >>> > I chose the compiled version of OpenNebula3.2
> >>> >
> >>> > The database used is not a mysql database  but some onedb file I
> >>> > think, which seems to hidden in the application layer. It is not a
> >>> > separate database. I want to dump this  onedb file into a ascii file
> >>> > and then manually create a mysql data using the dumped onedb file
> >>> > information.
> >>> > When done that I want to change OpenNebula3.2 to use the new mysql
> >>> > database.
> >>> > Is this possible? if so I how do I dump the onedb file to ascii
> file?.
> >>> >
> >>> > Thanks
> >>> >
> >>> > Poul
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>> > 2012/1/31 Manuel Peuster <manuel at peuster.de>:
> >>> >> Hi,
> >>> >>
> >>> >> I have done an installation of OpenNebula 3.2 on Ubuntu Server 11.04
> >>> >> yesterday. I choose self-contained installation from sources.
> >>> >>
> >>> >> I used [1] ans [2] and everything works fine.
> >>> >>
> >>> >> [1] http://www.opennebula.org/documentation:rel3.2:compile
> >>> >> [2]
> >>> >>
> >>> >>
> http://nzhu.blogspot.com/2011/06/install-opennebula-221-on-ubuntu-1104.html
> >>> >>
> >>> >> Manuel
> >>> >>
> >>> >> Poul Kristensen wrote:
> >>> >>> Hello !
> >>> >>>
> >>> >>> Would someone suggest the easiest way to install OpenNebula 3.2 to
> >>> >>> Ubuntu?
> >>> >>>
> >>> >>> Should OS be Ubuntu server version 10.04(with the included
> packages or
> >>> >>> are the packages to old?)  or Ubuntu server version 11.10?
> >>> >>>
> >>> >>> Should it be compiled and if so how can I be sure that all packages
> >>> >>> are installed needed to get a succesfull compilation in first try?
> >>> >>>
> >>> >>> Thanks
> >>> >>>
> >>> >>> Poul
> >>> >>> _______________________________________________
> >>> >>> Users mailing list
> >>> >>> Users at lists.opennebula.org
> >>> >>> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
> >>> >> _______________________________________________
> >>> >> Users mailing list
> >>> >> Users at lists.opennebula.org
> >>> >> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
> >>> _______________________________________________
> >>> Users mailing list
> >>> Users at lists.opennebula.org
> >>> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
> >>
> >>
> _______________________________________________
> Users mailing list
> Users at lists.opennebula.org
> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20120208/1260a51f/attachment-0003.htm>


More information about the Users mailing list