OpenNebula

As reported by Ajay Bhatnagar in the mailing list

./onedb upgrade -v
Version read:
2.0 : Could not read any previous db_versioning data, assuming it is an OpenNebula 2.0 or 2.2 DB.

MySQL dump stored in /srv/cloud/var/mysql_localhost_opennebula.sql
Use 'onedb restore' or restore the DB using the mysql command:
mysql -u user -h server -P port db_name < backup_file

Running migrator /srv/cloud/lib/ruby/onedb/2.0_to_2.9.80.rb

Mysql::Error: FUNCTION opennebula.COUNT does not exist

This change should fix the problem, but needs more testing:

--- a/src/onedb/2.0_to_2.9.80.rb
+++ b/src/onedb/2.0_to_2.9.80.rb
@@ -257,8 +257,8 @@ module Migrator
             public = row[:public]

             total_leases = 0
-            @db.fetch("SELECT COUNT (ip) FROM old_leases WHERE (oid=#{oid} AND used=1)") do |r|
-                total_leases = r[:"COUNT (ip)"]
+            @db.fetch("SELECT COUNT(ip) FROM old_leases WHERE (oid=#{oid} AND used=1)") do |r|
+                total_leases = r[:"COUNT(ip)"]
             end