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 -- Posted via http://www.ruby-forum.com/.
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, >-- Posted via http://www.ruby-forum.com/.
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 On 7/20/06, Xia __ <rebeccacannon@gmail.com> wrote:> > 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, > > > > > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060720/3feb2a2d/attachment.html
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 Hibbs 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-- Posted via http://www.ruby-forum.com/.