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:
-
Failure:
test_execute2(TC_MysqlStmt2) [test.rb:628]:
<[123]> expected but was
<[196864]>. -
Error:
test_execute3(TC_MysqlStmt2):
Mysql::Error: Out of memory (Needed 2063600648 bytes)
test.rb:637:inexecute' test.rb:637:in
test_execute3â -
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>]>. -
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