Error when migrating from SQLite to MySQL

Community Support General
1

Hello, I am new to OpenNebula. I am developing a project to implement a private cloud, I have managed to install the entire system but I want to change from SQLite to MySQL, I do the procedure indicated on the page but when I start I get an error which does not allow me to start the demon opennebula (I am using OpenNebula 5.12 in Centos 8 virtualized in virtualbox).

$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. [...]

mysql> GRANT ALL PRIVILEGES ON opennebula.* TO 'oneadmin' IDENTIFIED BY '<thepassword>';
Query OK, 0 rows affected (0.00 sec)
SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;

# Sample configuration for MySQL
DB = [ backend = "mysql",
       server  = "localhost",
       port    = 0,
       user    = "oneadmin",
       passwd  = "<thepassword>",
       db_name = "opennebula" ]

error starting opennebula daemon
2

Hi, you need start opennebula service as “standalone”, that populate the db, after that, you can change to master or slave in oned.conf. cheers.

3

starts normally but starting without changing the parameters would not fill the database in Sqlite?

4

yes, should. I don’t remember if you need to create a empty sqlite file before or is created starting the service.