[one-users] Configurable location for $ONE_LOCATION/var/one.db ?

[Robert Parrott]

Hi,

We got stung with this issue as well. Our short term approach was to
create an iscsi mount (i.e. block storage) and put everything in var/
there, and migrate to MySQL when we have a window of downtime.

As far as I can tell there's no way in ONE to specify that the DB
location should be separate from the other contents of /var/lib/one or
$ONE_LOCATION/var, which is why we used a different protocol. I
consider this a defect, though I haven't filed a ticket on it.

Rob


On Wed, Oct 26, 2011 at 10:01 AM, Steffen Neumann <sneumann at ipb-halle.de> wrote:
> Hi,
>
> I have to move one.db (which is currently living on an NFS volume,
> which is dangerous according to the docs[1]) to a local filesystem
> on the head node.
>
> Where do I specify the path to one.db ? The documentation [2]
> does not mention further arguments in oned.conf DB section
> DB = [ backend = "sqlite" ].
>
> The only reference to a variable DB location I found was
> DB: sqlite:///var/one/oneacct.db in $ONE_LOCATION/etc/acctd.conf
> but nothing for one.db.
>
> Do I need to hack the source or switch to MySQL ?
>
> Serving $ONE_LOCATION from a central storage/NAS might be a common
> scenario, so this could be a fairly important issue.
>
> Yours,
> Steffen
>
> [1] http://opennebula.org/documentation:rel3.0:sfs
> [2] http://opennebula.org/documentation:archives:rel2.2:oned_conf
>
> --
> IPB Halle                    AG Massenspektrometrie & Bioinformatik
> Dr. Steffen Neumann          http://www.IPB-Halle.DE
> Weinberg 3                   http://msbi.bic-gh.de
> 06120 Halle                  Tel. +49 (0) 345 5582 - 1470
>                                  +49 (0) 345 5582 - 0
> sneumann(at)IPB-Halle.DE     Fax. +49 (0) 345 5582 - 1409
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opennebula.org
> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
>



-- 
Robert E. Parrott, Ph.D. (Phys. '06)
Director, Academic Computing
Harvard University Sch. of Eng. and App. Sci.
Maxwell-Dworkin  211,
33 Oxford St.
Cambridge, MA 02138
(617)-496-1520