From: Alexandru Popescu <the.mindstorm.mailinglist@...>
Date: 2006-06-24T08:28:13+09:00
Subject: Re: mysql-ruby + ruby-mysql + activerecord == confusion

I have asked a similar question when reading the announcement about
Rails Live CD: http://www.infoq.com/news/Rails-LiveCD-Announced#view_1059.

./alex
--
.w( the_mindstorm )p.
---
(http://themindstorms.blogspot.com)


On 6/24/06, Rohit Mehta <ro@paper-mill.com> wrote:
>
> Hi guys, I am having some difficulties with mysql :)
>
> I have rails working and activerecord works, and I can create
> webapps that display and update databases just fine.
>
> However, I am not using rails.  I just want to do some simple
> inserts to a database.
>
> So, I tried something like the following:
>
> require 'rubygems'
> require 'active_record/vendor/mysql'
> @db = Mysql.new(hostname, username, password, databasename)
> db.query("insert into sent mail (id, recip, subject,spam)
> values(12,'foo','foo','y')")
> Mysql::Error: Lost connection to MySQL server during query
>         from
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/vendor/mysql.rb:1092:in
> `read'
>         from
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/vendor/mysql.rb:499:in
> `read'
>         from
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/vendor/mysql.rb:381:in
> `read_query_result'
>         from
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/vendor/mysql.rb:180:in
> `real_query'
>         from
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/vendor/mysql.rb:307:in
> `query'
>
> I then tried downloading and installing mysql-ruby-2.7
>
> I have mysql-client installed and I ran test.rb connecting to a mysql-4
> server and got the following
> failures:
>
>   1) Failure:
> test_execute2(TC_MysqlStmt2) [test.rb:628]:
> <[123]> expected but was
> <[196864]>.
>
>   2) Error:
> test_execute3(TC_MysqlStmt2):
> Mysql::Error: Out of memory (Needed 2063600648 bytes)
>     test.rb:637:in `execute'
>     test.rb:637:in `test_execute3'
>
>   3) Failure:
> test_execute4(TC_MysqlStmt2) [test.rb:653]:
> <[nil, "hoge", #<Mysql::Time:2005-07-19 23:53:00>]> expected but was
> <[nil, "\001", #<Mysql::Time:0000-00-00 00:00:00>]>.
>
>   4) Failure:
> test_sqlstate(TC_MysqlStmt2) [test.rb:1288]:
> <""> expected but was
> <"00000">.
>
> So THEN, I tried ruby-mysql-0.2.6.  This actually works just fine
> against my mysql 4 server, but
> when I run it against mysql 5, I get the following:
> connect............../mysql.rb:453:in `read': Client does not support
> authentication protocol requested by server; consider upgrading MySQL
> client (Mysql::Error)
>
> So I am out of luck if I want to use mysql 5.  However my rails apps
> work with a mysql5 server.
> Anyone have any idea what I should be doing?
>
>
> I'd appreciate assistance as I am quite muddled after all of this... I
> haven't even looked at Ruby-DBI yet!
>
> :)
>
> Thanks,
>
> Rohit
>
>
>