Hi Jeff,

Within your config/deploy/staging.rb file something like the following  
could help:

require 'erb'

before "deploy:setup", :db
after "deploy:update_code", "db:symlink"

namespace :db do
   desc "Create database yaml in shared path"
   task :default do
     db_config = ERB.new <<-EOF
staging:
   adapter: mysql
   encoding: utf8
   username: #{user}
   password: #{password}
   database: #{application}_staging
EOF
                
     run "mkdir -p #{shared_path}/config"
     put db_config.result, "#{shared_path}/config/database.yml"
   end
        
   desc "Make symlink for database yaml"
   task :symlink do
     run "ln -nfs #{shared_path}/config/database.yml #{release_path}/ 
config/database.yml"
   end
end

Regards,
Keith

On 20/10/2008, at 12:35 PM, Jeff Pritchard wrote:

>
> Hi,
> I thought it would be easy to get  a staging server working.  I'm  
> using
> capistrano 2 and the ext gem.  I already had everything working with
> capistrano for a production deployment...
>
> I added this to my deploy.rb
> require 'capistrano/ext/monitor'
> require 'capistrano/ext/multistage'
>
> I created a /deploy/staging.rb
> set :deploy_to, "/where-the-staging-stuff-goes"
> set :rails_env, 'staging'
>
> I added a ":staging" section in my database.yml file which is the same
> as production section but points to a different database
>
> Most of this is working.  The deployment works and I can run the app  
> at
> the new location, but for some reason it continues to use the  
> production
> database rather than the staging one that I have pointed it to with  
> the
> staging section of my database.yml file.
>
> thanks for any words of wisdom on this.
>
> jp
> -- 
> Posted via http://www.ruby-forum.com/.
>
> >


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Deploying Rails" group.
To post to this group, send email to rubyonrails-deployment@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-deployment?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to