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

[Poul Kristensen]

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
>>
>>