On Tue, Jan 24, 2012 at 6:52 PM, David Ekdahl <[email protected]> wrote:
> Colin Law wrote in post #1042340: > > On 24 January 2012 17:19, Peter Vandenabeele <[email protected]> > > wrote: > >>> >> (13): > >>> > 1.9.3p0 :001 > require 'yaml'; > >>> Do you want me to just copy and paste the code inside my database.yml > >> It parses the database.yml file (which is obviously a YAML file). If you > >> have > >> formatting problems in that file, it may be visible in the result. > > > > In case it is still not clear, Peter means you to open a terminal and > > cd to the top level of your rails projectexit. Then type > > irb > > and when it comes back with the prompt enter the require .... line and > > see what it says. You can then check the host, database, username and > > pwd are correct for the environment (development or production). > > To get back to the terminal prompt type exit > > > > Colin > > Thank you. > > This is my result. Does it look suspicious? I edited out some sensitive > information... > > irb(main):002:0* YAML::load(File.open('database.yml')) > => {"projectname"=>{"username"=>"user", "adapter"=>"mysql", > "database"=>"somedatabase", "host"=>"localhost", > "password"=>"some_password"}, "projectname02"=>{"encoding"=>"utf8", > "username"=>"user", "adapter"=>"mysql", "database"=>"somedatabase", > "host"=>"remote.host.local", "password"=>"somepassword"}} > If I understand correctly, this means that the 2 "environments" for this system are 'projectname' and 'projectname02'. You may try this to confirm that assumption: $ RAILS_ENV=projectname rails console (Note: take over the spaces _exactly_ as I show above; no spaces around the '=') If that does something useful, than we confirmed that scenario. Warning, it that command succeeds, you may be connected directly to your production database, be careful. If you wanted to connect to a development database in default 'development' mode, you would need a stanza in you config/database.yml of the form: development: adapter: mysql2 host: localhost username: user... password: pass... pool: 5 timeout: 5000 socket: /var/run/mysqld/mysqld.sock database: dbname ^ || These are all exactly 2 spaces (not tabs or anything else) With that 'development' stanza in place, you could try: $ rake db:create # assuming the development database does not exist yet $ rake db:migrate $ rails console HTH, Peter -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. 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.
