Hello, There's no way to specify the path of the sqlite database. The onlyway I see to move the sqlite database without modifying he source codeis moving the database to other local place and symlinking it to where'oned' expects it to be.
Anyway, if you have a production installation, or at least you areusing OpenNebula for more than testing how it works I would go forMySQL. Performance is much better and you can even play with databasereplication to have your data safe. Cheers On Wed, Oct 26, 2011 at 4:20 PM, Robert Parrott <[email protected]> wrote: > 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 <[email protected]> > 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 >> [email protected] >> 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 > _______________________________________________ > Users mailing list > [email protected] > http://lists.opennebula.org/listinfo.cgi/users-opennebula.org > -- Javier Fontán Muiños Project Engineer OpenNebula Toolkit | opennebula.org _______________________________________________ Users mailing list [email protected] http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
