Hi,
The sequel gem should be installed by the install_gems script [1].
Did you get any error message during the installation?
Regarding the Mysql error, it is a bug. I have opened a ticket [2].
Please change in /usr/lib/one/ruby/onedb/2.0_to_2.9.80.rb the following:
- @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)]
It looks mysql doesn't like the space before the parenthesis.
I have also found a typo in /usr/lib/one/ruby/onedb/onedb_backend.rb , and
onedb restore won't work with mysql unless you change:
create_cmd = mysql_cmd+-e 'CREATE DATABASE IF NOT EXISTS #{@db_name};'
- rc = system(create_cnd)
+ rc = system(create_cmd)
if !rc
raise Error creating MySQL DB #{@db_name} at #{@server}.
end
Thank you for the feedback, it will be solved in the final release.
Carlos.
[1]
http://opennebula.org/documentation:rel3.0:ignc#ruby_libraries_requirements_front-end
[2] http://dev.opennebula.org/issues/812
--
Carlos Martín, MSc
Project Major Contributor
OpenNebula - The Open Source Toolkit for Cloud Computing
www.OpenNebula.org http://www.opennebula.org/ | cmar...@opennebula.org
On Wed, Sep 14, 2011 at 4:07 PM, Ajay Bhatnagar abhatna...@rim.com wrote:
I tried to upgrade Mysql db from V2.0 to 2.9.80 using onedb upgrade –v
command for updating db to support Opennebula 3. But ran in into issues
described below
Does it need some more mysql component or some fix in onedb upgrade process
?
Thanks
Ajay
** **
Environment:
**a. **OS : Suse 11Sp1 2.6.32.12-0.7-default
**b. **Mysql : Server version: 5.0.67 SUSE MySQL RPM
**c. **Installed mysql components rpm -qa|grep mysql
libmysqlclient15-5.0.67-13.20.1
libmysqlclient-devel-5.0.67-13.20.1
mysql-client-5.0.67-13.20.1
libmysqlclient_r15-5.0.67-13.20.1
mysql-5.0.67-13.20.1
ruby-mysql-2.7.4-2.11
** **
Following issues were encountered:
**1. **Following mysql gem install does not resolve all issues to
run upgrade, needed to add gem sequel.
gem install mysql2-0.3.7.gem
gem install mysql-2.8.1.gem
** **
./onedb upgrade -v
/usr/lib64/ruby/vendor_ruby/1.8/rubygems/custom_require.rb:31:in
`gem_original_require': no such file to load -- sequel (LoadError)
from
/usr/lib64/ruby/vendor_ruby/1.8/rubygems/custom_require.rb:31:in `require'
from /srv/cloud/lib/ruby/onedb/onedb_backend.rb:18
from /srv/cloud/lib/ruby/onedb/onedb.rb:18:in `require'
from /srv/cloud/lib/ruby/onedb/onedb.rb:18
from ./onedb:39:in `require'
from ./onedb:39
** **
gem install sequel-3.27.0.gem
Successfully installed sequel-3.27.0
1 gem installed
Installing ri documentation for sequel-3.27.0...
Installing RDoc documentation for sequel-3.27.0...
** **
**2. **During upgrade it refers to function count which does not
exist.
** **
./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 transmission (including any attachments) may contain confidential
information, privileged material (including material protected by the
solicitor-client or other applicable privileges), or constitute non-public
information. Any use of this information by anyone other than the intended
recipient is prohibited. If you have received this transmission in error,
please immediately reply to the sender and delete this information from your
system. Use, dissemination, distribution, or reproduction of this
transmission by unintended recipients is not authorized and may be unlawful.
___
Users mailing list
Users@lists.opennebula.org
http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
___
Users mailing list
Users@lists.opennebula.org
http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
