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