可以通过命名管道从ruby/ActiveRecord连接到mysql数据库吗?操作系统为Windows。
谢谢。
发布于 2010-09-09 17:52:53
经过几次尝试和查看我的.net连接调用,我终于让它工作了。
我在一个独立脚本中使用activerecord。
下面是一个有效的调用:
ActiveRecord::Base.establish_connection(
:adapter => "mysql",
:host => ".",
:username => "root",
:password => "root",
:database => "test",
:socket => "mysql_test")请注意,默认情况下,mysql服务器附带的配置工具会配置一个名为"mysql“的套接字。我已经将它更改为mysql_test,以验证我确实是在通过命名管道。
干杯。
发布于 2011-02-04 00:46:09
这不起作用
Ruby版本: 1.9.1 Mysql版本: 5.0
编写的代码是:
require "rubygems"
require "active_record"
puts "1"
class Source < ActiveRecord::Base
puts "2"
establish_connection(
:adapter => "mysql",
:host => "localhost",
:username => "root",
:password => "root@123",
:database => "TrafficTracker"
)
end
puts "3"
traffic_source = Source.find(1)
puts "4"
puts traffic_source.source_name
上面的代码打印到3,并在Source.find(1)处中断,错误如下:
1 2 3 C:/Ruby/lib/ruby/1.9.1/mysql.rb:1019:in
read': Packets out of order: 0<> (RuntimeError)
从C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3读取‘from C:/Ruby/lib/ruby/1.9.1/mysql.rb:110:in real_connect' from C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_record/connection_adapters/mysql_adapter.rb:600:inconnect’from C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_record/connection_adapters/mysql_adapter.rb:164:in initialize' from C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_record/connection_adapters/mysql_adapter.rb:36:infrom C:/Ruby/lib/ruby/1.9.1/mysql.rb:444:in‘来自C:/ruby/lib/ruby/ .0.3/lib/active_record/connection_adapters/mysql_adapter.rb:36:in /1.9.1/ C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:236:in的mysql_connection' from C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:228:innew_connection‘from C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:236:inmysql_connection' from C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:228:innew_connection (2 levels) in c heckout’/activerecord-3.0.3/lib/active_reco从C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco rd/connection_adapters/abstract/connection_pool‘from C:/ruby/lib/ruby/1.9.1/ rd/connection_adapters/abstract/connection_pool.rb:186:in .rb:201: in mon_synchronize' from C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco rd/connection_adapters/abstract/connection_pool.rb:185:incheckout’中签出监控块来自C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco rd的C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco connection' from C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco rd/connection_adapters/abstract/connection_pool.rb:316:inretrieve_connection‘from C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco rd/connection_adapters/abstract/connection_specification.rb:97:in retrieve_connection’/base.rb:679:incolumns' from C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_record/persistence.rb:284:inattributes_from_column_definition‘from C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_record/locking/optimistic.rb:62:in attributes_from_column_definition' from C:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_record/base.rb:1394:ininitialize’from C:/WorkspaceGunjan/TrafficTracker/TrafficTracker/TestProject/RubyPrograms/RubyPrograms/AccessTrafficTracker.rb:22:in new' from C:/WorkspaceGunjan/TrafficTracker/TrafficTracker/TestProject/RubyPrograms/RubyPrograms/AccessTrafficTracker.rb:22:in‘C:\WorkspaceGunjan\TrafficTracker\TrafficTracker\TestProject\RubyPrograms\RubyPrograms> C:\WorkspaceGunjan\TrafficTracker\TrafficTracker\TestProject\RubyPrograms\RubyPrograms> C:\WorkspaceGunjan\TrafficTracker\TrafficTracker\TestProject\RubyPrograms\RubyPrograms>
https://stackoverflow.com/questions/3668917
复制相似问题