MySQL Forums
Forum List  »  Ruby

Ruby and MySQL with windows
Posted by: Jon Dean
Date: April 30, 2006 01:01PM

I am new to both ruby and mysql and am trying to install the API for mysql using the link http://raa.ruby-lang.org/project/mysql-ruby/. I am using version 1.8.4 for ruby and 5.0.19-nt for mysql. Following the readme-winpkg I entered ruby install.rb -n and got
install
mingw32/mysql.so => c:/ruby/lib/ruby/site_ruby/1.8/i386-msvcrt
I then ran the simple.rb
# simple.rb - simple MySQL script using Ruby MySQL module

require "mysql"

begin
# connect to the MySQL server
dbh = Mysql.real_connect("localhost", "testuser", "testpass", "test")
# get server version string and display it
puts "Server version: " + dbh.get_server_info
rescue MysqlError => e
print "Error code: ", e.errno, "\n"
print "Error message: ", e.error, "\n"
ensure
# disconnect from server
dbh.close
end
from http://www.kitebird.com/articles/ruby-mysql.html and got:
Error code:1251
Error message: Client does not support authentication protocol requested by server; consider upgrading mysql client
simple.rb:13: undefined method 'close' for nil:NilClass <NoMethodError>

Are there any suggestion on how I can get the ruby API for mysql installed and running?

Options: ReplyQuote


Subject
Written By
Posted
Ruby and MySQL with windows
April 30, 2006 01:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.