首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >在windows上使用mysql命名管道的ActiveRecord

问在windows上使用mysql命名管道的ActiveRecord
EN

Stack Overflow用户
提问于 2010-09-08 22:44:15
回答 2查看 445关注 0票数 2

可以通过命名管道从ruby/ActiveRecord连接到mysql数据库吗?操作系统为Windows。

谢谢。

EN

回答 2

Stack Overflow用户

回答已采纳

发布于 2010-09-09 17:52:53

经过几次尝试和查看我的.net连接调用,我终于让它工作了。

我在一个独立脚本中使用activerecord。

下面是一个有效的调用:

代码语言:javascript
复制
ActiveRecord::Base.establish_connection(
    :adapter => "mysql",
    :host => ".",
    :username => "root", 
    :password => "root", 
    :database => "test",
    :socket => "mysql_test")

请注意,默认情况下,mysql服务器附带的配置工具会配置一个名为"mysql“的套接字。我已经将它更改为mysql_test,以验证我确实是在通过命名管道。

干杯。

票数 1
EN

Stack Overflow用户

发布于 2011-02-04 00:46:09

这不起作用

Ruby版本: 1.9.1 Mysql版本: 5.0

编写的代码是:

​

代码语言:javascript
复制
    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>

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/3668917

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档