Changing database from SQlite to Mysql

Community Support
1

I followed the steps mentioned for changing to Mysql but I am unable to log in. I think I am doing something basically wrong. Can I change to Mysql after using SQlite for some time ? Or it should be done on a fresh install before starting first time ?

2

Found the answer here.

3

It seems that oned thinks the database is uninitialized, but the rest of the setup (.one/sunstone_auth etc.) does already exist. You have two possibilities:

either dump the original sqlite db, convert the dump to the MySQL format, insert the result to MySQL, and finally run “onedb fsck”,

or create a fresh installation, without any locally set up data such as ~/.one/sunstone_auth.

For my ONe cloud, i went the first way, and it worked.

4

"For my ONe cloud, i went the first way, and it worked "

Could you elaborate on how you did this ?

5

I don’t remember exactly, but something like this:

  • stop OpenNebula (especially oned)
  • sqlite3 one.db .dump > one.sqlite
  • sqlite2mysql.pl < one.sqlite > one.mysql
    (sqlite2mysql.pl taken from stackexchange or something like that - search for “SQLite to MySQL conversion”
  • create an empty database on your MySQL server
  • verify that you can log into it from the host oned runs at
  • mysql -h host -u user -p password < one.mysql
  • edit oned.conf to reflect the new DB driver
  • onedb fsck -S host -u user -p password
  • rename one.db to something different just in case
  • start oned
  • profit!
6

Thanks.

Suppose for a fresh install with Mysql as backend … How do you prevent the default backend from kicking in ?

7

Comment it out in oned.conf?

8

It is worth noting that in OpenNebula 5.0 there will be a native way to do this:

$ onedb sqlite2mysql --help
## USAGE
sqlite2mysql 
        Migrates a SQLite OpenNebula Database to MySQL
        valid options: backup
9

That will be great. It will be nice if you ask during install itself about the choice of DB like , sqlite , mysql , postgresql or whatever !