ruby mysql connection error

Question

I am using MySQL and ruby 1.8.6. I want to connect to MySQL so for that I am using active record gem. My code is

def initialize

    @db_adapter  = "mysql2"
    @db_host     = "localhost"
    @db_database = "database_name"
    @db_user     = "root"
    @db_password = "root123"
    con = nil

end

def database_connection
           con = ActiveRecord::Base.establish_connection(  
              :adapter  => $db_adapter,  
              :host     => $db_host,  
              :database => $db_database,
              :user     => $db_user,
              :password => $db_password  
           )

           return con
end

but when i am tring to connect it's giving me this error

/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/connection_adapters/abstract/connection_specification.rb:76:in `establish_connection': Please install the  adapter: `gem install activerecord--adapter` (no such file to load -- active_record/connection_adapters/_adapter) (RuntimeError)
    from /cmf/samnew/build/Controller/databaseConnection.rb:32:in `database_connection'
    from controller.rb:23

Note that @instance_variables aren't the same thing at all as $global_variables. — noodl
– noodl, Commented Sep 28, 2012 at 20:51

sunnyrjuneja · Accepted Answer · 2012-11-02 04:40:48Z

3

The error shows the activerecord--adapter gem is not installed. You can install the gem using the command

gem install activerecord--adapter.

edited Nov 2, 2012 at 4:40

sunnyrjuneja

6,1332 gold badges36 silver badges52 bronze badges

answered Nov 2, 2012 at 4:26

ѕтƒ

3,64710 gold badges51 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Fandorin · Accepted Answer · 2012-09-20 07:22:47Z

0

Try

con = ActiveRecord::Base.establish_connection(  

        :adapter  => @db_adapter,  

        :host     => @db_host,  

        :database => @db_database,

        :user     => @db_user,

        :password => @db_password  

)

answered Sep 20, 2012 at 7:22

Fandorin

315 bronze badges

1 Comment

Fandorin Over a year ago

Print your variable $db_adapter in database_connection function, I think that you need variable @db_adapter.

Collectives™ on Stack Overflow

ruby mysql connection error

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related