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 ?

Found the answer here. [image] Oned failed to start /usr/bin/one: line 117 Community Support I have freshly installed opennebula + mysql. but oned wont start. it fails with: oned failed to start /usr/bin/one: line 117: 3572 Terminated $ONE_SCHEDULER and in…

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…

"For my ONe cloud, i went the first way, and it worked " Could you elaborate on how you did this ?

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

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

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

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 !

Changing database from SQlite to Mysql

Product Support

varadarajan (varadarajan) May 1, 2016, 10:31pm 2

Found the answer here.

Topic		Replies	Views
Error when migrating from SQLite to MySQL Installation & Configuration	3	336	November 12, 2020
Can i use postgresql instead of sqlite? Product Support	6	2979	October 18, 2016
Problems with Opennebula and MySQL/MariaDB Product Support	4	996	March 9, 2021
"Internal error" after migration from Sqlite to MySQL (error 1046 : No database selected) Product Support	2	1048	March 8, 2017
Opennebula.service won't start, uninitialized sqlite DB Installation & Configuration	2	668	May 10, 2019

Changing database from SQlite to Mysql

Related topics