This section is only relevant if you are building OpenNebula from source. If you downloaded our compiled packages, you can skip to Installation .

An installation of the mysql server database is required. For an Ubuntu distribution, the packages to install are:

• libmysql++-dev
• libxml2-dev

Also, you will need a working mysql server install. For Ubuntu again, you can install the mysql server with:

• mysql-server-5.1

To compile OpenNebula from source with mysql support, you need the following option passed to the scons:

<xterm> $ scons mysql=yes </xterm>

Afterwards, installation proceeds normally, configuration needs to take into account the mysql server details, and for users of OpenNebula the DB backend is fully transparent.

First of all, you need a working MySQL server.

Of course, you can use any instance you have already deployed. OpenNebula will connect to other machines different from localhost.

You can also configure two different OpenNebula installations to use the same MySQL server. In this case, you have to make sure that they use different database names.

In order to let OpenNebula use your existing MySQL database server, you need to add a new user and grant it privileges on one new database. This new database doesn't need to exist, OpenNebula will create it the first time you run it.

Assuming you are going to use the default values, log in to your MySQL server and issue the following commands:

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

mysql> GRANT ALL PRIVILEGES ON opennebula.* TO 'oneadmin' IDENTIFIED BY 'oneadmin'; Query OK, 0 rows affected (0.00 sec) </xterm>

Remember to choose different values, at least for the password.

GRANT ALL PRIVILEGES ON <db_name>.* TO <user> IDENTIFIED BY <passwd>

Visit the MySQL documentation to learn how to manage accounts.

Before you run OpenNebula, you need to set in oned.conf the connection details, and the database you have granted privileges on.

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

Fields:

• server: url of the machine running the MySQL server
• port: port for the connection to the server. If set to 0, the default port is used.
• user: MySQL user-name
• passwd: MySQL password
• db_name: Name of the MySQL database OpenNebula will use

After this installation and configuration process you can use OpenNebula as usual.