ActiveRecord will not change port

Rails
1

Hello,

I’m trying to connect to a remote mysql server using a ssh tunnel and
activerecord.

I know the ssh tunnel is working because I can connect via the cmd
line client.
I’ve set the ssh tunnel up like this: ssh -L 3307:127.0.0.1:3306.

So, I thought I could just change the port on my active record
connection, but it still connects to my local mysql server.

class MyClass < ActiveRecord::Base
establish_connection(
:adapter => ‘mysql’,
:user => ‘root’,
:database => ‘hrsuite_production’,
:server => “127.0.0.1”,
:port => 3307)

I’ve also tried :server => ‘127.0.0.1:3307’ but that did not work
either. I also tried :socket => nil, but no luck.

I’m running active record 2.3.4

Any suggestions and thanks for taking a look,

Matt

2

mpiskorz wrote:

class MyClass < ActiveRecord::Base
establish_connection(
:adapter => ‘mysql’,
:user => ‘root’,
:database => ‘hrsuite_production’,
:server => “127.0.0.1”,
:port => 3307)

I’ve also tried :server => ‘127.0.0.1:3307’ but that did not work
either. I also tried :socket => nil, but no luck.

Try :host instead of :server .

3

Aldric,

Thanks a lot! That was it.

I don’t know how many times I looked at the API yesterday, but there
it was. Thanks for catching it.

By chance, do you know what the difference is between using host and
server?

Thanks again!
Matt

On Nov 11, 5:53 am, Aldric G. <rails-mailing-l…@andreas-

4

mpiskorz wrote:

I don’t know how many times I looked at the API yesterday, but there
it was. Thanks for catching it.
You’re welcome :slight_smile:

By chance, do you know what the difference is between using host and
server?

You mean, besides the fact that host works and server doesn’t? :wink:
I’m guessing that, in the absence of a valid :host option, it tries to
connect to localhost.