Cannot connect to remote db using ssh tunnel and activerecord

Question

I'm having some trouble with the following script:

require 'rubygems'
require 'active_record'
require 'net/ssh/gateway'

gateway = Net::SSH::Gateway.new('myserver.com', 'myuser', :password => "mypass")
puts "true" if gateway.active?
p = gateway.open('127.0.0.1', 3306, 3307)

class MyClass < ActiveRecord::Base
  establish_connection(
    :adapter  => "mysql",
    :host     => "127.0.0.1",
    :username => "db_user",
    :password => "db_pass",
    :database => "mydb_production",
    :port     => 3307
  )
end

puts MyClass.all.size

gateway.shutdown!

When I run the script it just hangs, unless I remove the activerecord query. I know I can connect using tunneling because I can create a tunnel from the command like like so:

ssh -f [email protected] -L 3307/127.0.0.1/3306 -N

Then if I run:

require 'rubygems'
require 'active_record'

class MyClass < ActiveRecord::Base
  establish_connection(
    :adapter  => "mysql",
    :host     => "127.0.0.1",
    :username => "db_user",
    :password => "db_pass",
    :database => "mydb_production",
    :port     => 3307
  )
end

puts MyClass.all.size

It works fine. What am I doing wrong?

Thanks.

Have you tried opening the gateway in another thread or process? I believe your issue might be caused by a deadlock due to how MySQL might be trying to do IO over your tunnel... — Romain
– Romain, Commented Jan 27, 2011 at 10:56

BeeZee · Accepted Answer · 2012-03-28 17:38:18Z

9

I was able to get this to work without a fork by using the mysql2 gem

require 'rubygems'
require 'active_record'
require 'mysql2'
require 'net/ssh/gateway'

gateway = Net::SSH::Gateway.new(
  'remotehost.com',
  'username'
)
port = gateway.open('127.0.0.1', 3306, 3307)

class Company < ActiveRecord::Base
  establish_connection(
    :adapter  => "mysql2",
    :host     => "127.0.0.1",
    :username => "dbuser",
    :password => "dbpass",
    :database => "dbname",
    :port     => 3307
  )
end
puts Company.all.size

answered Mar 28, 2012 at 17:38

BeeZee

1,60222 silver badges25 bronze badges

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

Comments

sdsykes · Accepted Answer · 2011-03-12 11:40:35Z

2

I think the comment is right - the DB is conflicting with the event loop in the ssh code.

Try this:

  require 'rubygems'
  require 'active_record'
  require 'net/ssh/gateway'

  gateway = Net::SSH::Gateway.new('myserver.com', 'myuser', :password => "mypass")
  puts "true" if gateway.active?
  port = gateway.open('127.0.0.1', 3306, 3307)
  fork.do
    class MyClass < ActiveRecord::Base
      establish_connection(
        :adapter  => "mysql",
        :host     => "127.0.0.1",
        :username => "db_user",
        :password => "db_pass",
        :database => "mydb_production",
        :port     => 3307
      )
    end

    puts MyClass.all.size
  end  

  Process.wait

  gateway.shutdown!

answered Mar 12, 2011 at 11:40

sdsykes

1,25612 silver badges15 bronze badges

Collectives™ on Stack Overflow

Cannot connect to remote db using ssh tunnel and activerecord

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related