OpenNebula

I checked out latest version of opennebula from git repo (f017f08ce3a05c4d2ade010df7f48f877306311a) and tried to get it work with MySQL. After successful compilation, instalation and one start, opennebula failed to add new host. I found few error messages in the one.log file:

Mon Aug  9 17:49:41 2010 [ONE][E]: SQL command was: SELECT oid, im_mad FROM host_pool WHERE state != 4 ORDER BY last_mon_time ASC LIMIT 10, er
ror 1146 : Table 'opennebula.host_pool' doesn't exist

I checked in MySQL for table host_pool, but it wasn't there. Then I found SQL command for creating host_pool table in src/host/Host.cc

const char * Host::db_bootstrap = "CREATE TABLE IF NOT EXISTS host_pool (" 
    "oid INTEGER PRIMARY KEY,host_name VARCHAR(512), state INTEGER," 
    "im_mad VARCHAR(128),vm_mad VARCHAR(128),tm_mad VARCHAR(128)," 
    "last_mon_time INTEGER, cluster VARCHAR(128), " 
    "UNIQUE(host_name, im_mad, vm_mad, tm_mad) )";

I tried to run this command manualy and I got confusing error about max key length.

mysql> CREATE TABLE IF NOT EXISTS host_pool (oid INTEGER PRIMARY KEY,host_name VARCHAR(512), state INTEGER, 
    -> im_mad VARCHAR(128),vm_mad VARCHAR(128),tm_mad VARCHAR(128), last_mon_time INTEGER, cluster VARCHAR(128),
    -> UNIQUE(host_name, im_mad, vm_mad, tm_mad) );
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes

I removed im_mad, vm_mad, tm_mad from UNIQUE part of the SQL command and changed the size of host_name atribute from 512 to 128.

mysql> CREATE TABLE IF NOT EXISTS host_pool (oid INTEGER PRIMARY KEY,host_name VARCHAR(256), state INTEGER,  im_mad VARCHAR(128),vm_mad VARCHAR(128),tm_mad VARCHAR(128), last_mon_time INTEGER, cluster VARCHAR(128), UNIQUE(host_name) );;;
Query OK, 0 rows affected (0.00 sec)
mysql> 

After that, query executed fine.

Here is the patch for src/host/Host.cc:

diff --git a/src/host/Host.cc b/src/host/Host.cc
index 3fc1087..819a40b 100644
--- a/src/host/Host.cc
+++ b/src/host/Host.cc
@@ -57,10 +57,10 @@ const char * Host::db_names = "(oid,host_name,state,im_mad,vm_mad," 
                               "tm_mad,last_mon_time, cluster)";

 const char * Host::db_bootstrap = "CREATE TABLE IF NOT EXISTS host_pool (" 
-    "oid INTEGER PRIMARY KEY,host_name VARCHAR(512), state INTEGER," 
+    "oid INTEGER PRIMARY KEY,host_name VARCHAR(128), state INTEGER," 
     "im_mad VARCHAR(128),vm_mad VARCHAR(128),tm_mad VARCHAR(128)," 
     "last_mon_time INTEGER, cluster VARCHAR(128), " 
-    "UNIQUE(host_name, im_mad, vm_mad, tm_mad) )";
+    "UNIQUE(host_name) )";

 /* ------------------------------------------------------------------------ */
 /* ------------------------------------------------------------------------ */

After uninstall + purge DB, recompilation and install - it created table host_pool just fine.