[Capistrano] Re: Failing on database migration

[Jamis Buck]

It looks like you're only creating the database.yml on deploy:setup. Perhaps you really want it to be created after deploy:update_code? The deploy:setup task is not called as part of the deployment task chain.

- Jamis

On Apr 21, 2008, at 8:36 AM, chris wrote:

I don't think that I am going to give any users full access to my
database without a password :)

I understand what is happening, but I am having a hard time
understanding why some things are NOT happening, namely prompting me
for the db user name and password.

On Apr 21, 12:37 am, Mason Browne <[EMAIL PROTECTED]> wrote:

That thar is a MySQL error. Make sure your user named "user" has perms

to access the DB without a password, or make sure to change the creds
within database.yml.

On Apr 20, 2008, at 8:48 PM, chris wrote:

After installing the gem I am still getting a similar thing, in never

being prompted for the database password on deployment.

** [out :: xxxxx.members.linode.com] (in /var/rails/onlinelistings/
releases/20080421022432)
** [out :: xxxxx.members.linode.com] rake aborted!
** [out :: xxxxx.members.linode.com] Access denied for user
'root'@'localhost' (using password: NO)

Here is my deploy.rb file.  Can you see what I am missing?
----------
set :application, "my_app"
set :repository,  "[EMAIL PROTECTED]:me/my_app.git"
set :domain, "xxxx-xxx.members.linode.com"

default_run_options[:pty] = true  # ensures we get a password prompt
from Git

set :user, "deploy"
set :runner, "deploy"

set :scm, "git"
set :scm_passphrase, "XXXX"
set :branch, "origin/master"

set :deploy_to, "/var/rails/#{application}"
set :deploy_via, :remote_cache
ssh_options[:paranoid] = false
set :use_sudo, false

role :app, domain
role :web, domain
role :db,  domain, :primary => true

namespace :init do
 desc "create database.yml"
 task :database_yml do
   set :db_user, Capistrano::CLI.ui.ask("database user: ")
   set :db_pass, Capistrano::CLI.password_prompt("database password:
")
   database_configuration =<<-EOF
     ---
     login: &login
       adapter: mysql
       database: #{application}
       host: localhost
       username: #{db_user}
       password: #{db_pass}

     production:
       <<: *login
   EOF

   run "mkdir -p #{shared_path}/config"
   put database_configuration, "#{shared_path}/config/database.yml"
 end
end

after "deploy:setup", "init:database_yml"

Thanks for the help.

--~--~---------~--~----~------------~-------~--~----~
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more opti

--~--~---------~--~----~------------~-------~--~----~
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/capistrano
-~----------~----~----~----~------~----~------~--~---

smime.p7s
Description: S/MIME cryptographic signature