Instant Rails not finding database

Rails
1

Hey there

I’ve got instant rails installed, and it’s phpmyadmin can find the
database at the ascribed mysql port (3210)

…however, altho i have got my ‘depot_development’ db in there (along
with the other dbs that ship with instant rails)… the rake script from
the instant rails command interface cant find ‘depot_development’.

Looking at trace it is ok to connect, but it says the db isn’t there.
'rake aborted! #42000Unknown database ‘depot_development’

any clues?

the fact that it connects actually seems a little strange since
phpmyadmin wouldn’t connect with a password, but my rails app ‘depot’
requires it.

thanks,

3210

2

Ok, to add to this, i suspect that i need to let my instant rails app
know that it needs to access mysql via the non default port. I have set
this up in the instant rails/mysql config file, (which is why phpmyadmin
is connecting to it), however i think i may need to also define this in
the app database.yml config file as well… i tried adapter: mysql:3210
but it didn’t work (reported error adapter doesnt exist)… i also tried
setting host: localhost:3210 but that reported no address associated
with host name (even tho instant rails mysql is set to port=3210)
any ideas?

xia wrote:

Hey there

I’ve got instant rails installed, and it’s phpmyadmin can find the
database at the ascribed mysql port (3210)

…however, altho i have got my ‘depot_development’ db in there (along
with the other dbs that ship with instant rails)… the rake script from
the instant rails command interface cant find ‘depot_development’.

Looking at trace it is ok to connect, but it says the db isn’t there.
'rake aborted! #42000Unknown database ‘depot_development’

any clues?

the fact that it connects actually seems a little strange since
phpmyadmin wouldn’t connect with a password, but my rails app ‘depot’
requires it.

thanks,

3

This is from memory (I’m traveling and don’t have access to my
development
machine), but hopefully I’ll get it right…

Edit the MySQL configuration through the Instant Rails manager app using
the
menu command “I>>Configure>>MySQL”. Add “port=3210” and save the config
file.

Then edit config\database.yml file for your Rails app and immediately
after
the line “host: localhost”, add a new line that reads “port:3210”. It is
important to use the same indentation as the host line and to use space
characters, not tabs.

Good luck,
Curt

4

Thanks Curt, I was so close!

editing the database.yml to add the line “port: 3210” (with the space)
straight after the line “host: localhost” worked. Your help is much
appreciated.

Curt H. wrote:

This is from memory (I’m traveling and don’t have access to my
development
machine), but hopefully I’ll get it right…

Edit the MySQL configuration through the Instant Rails manager app using
the
menu command “I>>Configure>>MySQL”. Add “port=3210” and save the config
file.

Then edit config\database.yml file for your Rails app and immediately
after
the line “host: localhost”, add a new line that reads “port:3210”. It is
important to use the same indentation as the host line and to use space
characters, not tabs.

Good luck,
Curt