Query on db with mysql

Rails
1

Hi all,

I have a host that allows ssh access but only on the main account. I was
just wondering can you setup the db without using the command line e.g
db:migrate generate etc as on my main account its fine but if i setup
other sites i will have to pay $10/£6 to activate ssh.

Thanks

2

On 25 February 2012 15:20, Paul Na [email protected] wrote:

Hi all,

I have a host that allows ssh access but only on the main account. I was
just wondering can you setup the db without using the command line e.g
db:migrate generate etc as on my main account its fine but if i setup
other sites i will have to pay $10/6 to activate ssh.

I think it will be very difficult to administer without command line
access. As well as db setup you will likely need to do bundle install
and so on. Possibly a change of provider is in order.

Colin

To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

–
gplus.to/clanlaw

3

Quoting Paul Na [email protected]:

Hi all,

I have a host that allows ssh access but only on the main account. I was
just wondering can you setup the db without using the command line e.g
db:migrate generate etc as on my main account its fine but if i setup
other sites i will have to pay $10/6 to activate ssh.

Cannot you ssh into the main account and then change user to the other
account? My Amazon cloud account is like this. Only one normal user
account
is allowed to ssh in. I then change to the root and Web server accounts
as
needed.

HTH,
Jeffrey

4

Hi,

Sorry for the late reply i have been busy. I have got a vps now but
Jeffrey you are right i totally forgot that but its to late now as i
have cancelled the account.

Thanks anyway

Paul

5

On Sat, Feb 25, 2012 at 10:46, Jeffrey L. Taylor [email protected]
wrote:

Cannot you ssh into the main account and then change user to the other
account? My Amazon cloud account is like this. Only one normal user account
is allowed to ssh in. I then change to the root and Web server accounts as
needed.

Excellent advice not only for getting around expensive restrictions,
but for security as well. My usual procedure is to set up an account
that is highly restricted, but can accept ssh sessions, with username
and password that are long and hard to guess (but reasonably easy to
remember and type – a la “correct horse battery staple”). Once
there, I can su to whatever other accounts I need to use. (Still with
reasonably strong names and passwords though!)

-Dave

–
Dave A.: Available Cleared Ruby on Rails Freelancer
(NoVa/DC/Remote) – see www.DaveAronson.com, and blogs at
www.Codosaur.us, www.Dare2XL.com, www.RecruitingRants.com