# Mysql-ruby + ruby-mysql + activerecord == confusion **URL:** \ **Category:** Ruby\ **Created:** [June 24, 2006, 12:18am UTC](https://www.ruby-forum.com/t/mysql-ruby-ruby-mysql-activerecord-confusion/64296 "2006-06-24T00:18:03Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![ror-user](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/22d042/32.png) [@ror-user](https://www.ruby-forum.com/u/ror-user)\ **Post date:** [June 24, 2006, 12:18am UTC](https://www.ruby-forum.com/t/mysql-ruby-ruby-mysql-activerecord-confusion/64296/1 "2006-06-24T00:18:03Z")
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”, #\]\> expected but was \<[nil, “\001”, #\]\>. 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 ---
**Author:** ![ror-user](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/22d042/32.png) [@ror-user](https://www.ruby-forum.com/u/ror-user)\ **Post date:** [June 24, 2006, 1:31am UTC](https://www.ruby-forum.com/t/mysql-ruby-ruby-mysql-activerecord-confusion/64296/2 "2006-06-24T01:31:04Z")
I have asked a similar question when reading the announcement about Rails Live CD: [Rails LiveCD Linux Distro Announced](http://www.infoq.com/news/Rails-LiveCD-Announced#view_1059). ## ./alex ## .w( the\_mindstorm )p. ([http://themindstorms.blogspot.com](http://themindstorms.blogspot.com)) ---
**Author:** ![ror-user](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/22d042/32.png) [@ror-user](https://www.ruby-forum.com/u/ror-user)\ **Post date:** [June 24, 2006, 2:11am UTC](https://www.ruby-forum.com/t/mysql-ruby-ruby-mysql-activerecord-confusion/64296/3 "2006-06-24T02:11:13Z")
Ok here it is documented that ruby-mysql does not work with mysql \> 4.1 (although it appears to work fine with mysql 4.1.12 but fail with 5.x) [http://wiki.rubyonrails.com/rails/pages/MySQL](http://wiki.rubyonrails.com/rails/pages/MySQL) However when compiling the C mysql adaptor (mysql-ruby) on a machine with mysql 5.x installed and then trying to connect to a mysql 4.1.12 server, I get an out of memory error. Running the mysql client works fine though. I can still do something like: /usr/local/mysql5/bin/mysql -u X -p -h (mysql4.1.12 server). The Rails LiveCD looks very interesting. I will have to setup VMware Player and look at it… but I’m still stuck on MySQL. Rohit ---
**Author:** ![ror-user](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/22d042/32.png) [@ror-user](https://www.ruby-forum.com/u/ror-user)\ **Post date:** [June 24, 2006, 10:38am UTC](https://www.ruby-forum.com/t/mysql-ruby-ruby-mysql-activerecord-confusion/64296/4 "2006-06-24T10:38:09Z")
It is really weird. A couple of days ago I made InstantRails work fine with a preinstalled MySQL 5.0.16: [mindstorms: InstantRails using existing installations (tips and tricks)](http://themindstorms.blogspot.com/2006/06/instantrails-using-existing.html). I am really confused :-S. ## ./alex ## .w( the\_mindstorm )p. ([http://themindstorms.blogspot.com](http://themindstorms.blogspot.com))