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
-~----------~----~----~----~------~----~------~--~---

Reply via email to