similar to: Need to override database.yml settings for Capistrano run

Would it be wise to chmod 600 your database.yml file using Capistrano when deploying seeing as it contains your mysql db in plain text? ~ Mark -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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

Greetings, Today I''ve been working out how to begin using Capistrano and so far I''m impressed. Even in my situation, learning Rails and deploying to a single server, it''s incredibly helpful. I do have one small question though: In using Subversion I''ve used the "ignore" feature to ignore my local database.yml file, because my local database and

Hello, I get this error trying to load some data from DB. I''m using Rails 1.2.2 on Fedora Core 6 and Sybase adapter. This worked fine when application run under Rails 1.1.6 but now I''m migrating to 1.2.2 and have some problems. At browser I got: SQL Command for table_structure for tplib_bckps failed Message: schema_info not found. Specify owner.objectname or use sp_help to

Hi, I am trying to get * log to mssql server. I have odbc and freetds configured, but my insert query is missing calldate which is a NOT NULL field in database schema. cdr_adaptive_odbc: Insert failed on 'sqlserver:cdr'. CDR failed: INSERT INTO cdr (clid,src,dst,dcontext,channel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid) VALUES

All, I have two migration files, file 1 and file 2. For reasons that I don''t want to go into unless I must, I want to only run file 2 on my production database (file 1 contains a bunch of table creation stuff for already existing tables). I figured if I created a schema_info table and set the version in it to 1, then I could just run rake db:migrate RAILS_ENV=production and just

Is anyone using migrations with a SQL Server database who might be able to lend me a hand? I''ve used migrations with MySql in the past and haven''t run into any issues so forgive When I run rake migrate nothing is actually getting updated in my database. I created a migration using ./script/generate migration AddFooTable and updated the migration to look as follows: class

I have the rails recipes book and i was going through the migrations recipe. Everything seemed to work except for the last part in trying to do a rake migrate with a migration file version 1 and the schema_info version set to 0. Without the force attribute, the rake migration fails, as expected. So the recipe says to run this: ruby script/runner

Has anyone encountered this error or know how to correct it? I couldn''t find any Rails-specific info about this on google. Here are the circumstances: /usr/local/bin/ruby --version ruby 1.8.4 (2005-12-24) [i686-linux] /usr/local/bin/rails --version Rails 1.1.6 ## Create mcd app rails mcd -d oracle cd mcd ## Create oracle tablespace & user sqlplus ''/ as

On a rails app that I''m developing I converted a regular old .sql file into a rails migration. Since I generated the migration in my development environment, it created the schema_info table for me. However, when I updated my production environment and tried running rake migrate it complained that schema_info doesn''t exist. Is there a rake task for getting around this yet, or

Hey y''all: mongrel_cluster provides management tools for running Mongrel behind a reverse-proxy/load balancer. It is an extraction from Rails Machine, a deployment service and Ruby library that simplifies Rails application deployment. This release fixes bugs and adds a Capistrano task library. Changes: -changed pid file format to include port -only write configuration options

I have working copies of code in development on multiple places - work machine, home machine, laptop, etc. I can''t always force these machines to use the same credentials; I end up with each machine having slightly different database.yml configurations. With Subversion-Pre-Capistrano, I left the entire config directory out of Subversion (or some kind of template; see

Hello, Now I'm testing func_odbc and hash. My configurations are: func_odbc.conf [GETNUMBER] dsn=sqlserver ;mode=multirow ;rowlimit=10 readsql=SELECT number,real_number1,real_number2,status FROM ivr.dbo.numbers WHERE number=${SQL_ESC(${ARG1})} extensions.conf exten => s,1,Ringing exten => s,n,Wait(4) exten => s,n,Answer exten => s,n,Set(NUMERIS=37037210602) exten =>

All, I''ve run into a situation where I want the owner of my DB tables to be different than the user that accesses them during application runtime. I believe that I can just set up another DB connection profile (with a name other than "production") in database.yml and then pass that as RAILS_ENV to db:migrate instead of "production". Anyone see any problems with

I have a project under Subversion, deployed by Capistrano. When it is deployed, obviously I need to deploy "real" copies of database.yml, deploy.rb, and maybe a couple of other files. But if I offer it for public checkout, I obviously do not want these files as part of the checked out code. What''s the best way to handle this? --Al Evans -- Posted via

I have followed the cookbook on http://wiki.rubyonrails.org/database-support/ms-sql but am having problems with the rails part. I can connect to the database using sqsh so I think all the freetds plumbing is good. When I try to connect to the db with a rake db:migrate or just using script/ console I get this error: >> Client.find(:first) DBI::InterfaceError: Unable to load driver

My app is set up without database.yml in version control. I created a shared_path/config dir, and put database.yml in it. After I update the code, I want to link the app''s database.yml file to the shared config. So I added this task desc ''Copy the database config'' task :after_update_code, :roles => :app do run "ln -s #{shared_path}/config/database.yml

I''ve deployed an application using Capistrano. But on my local machine I edited one of the earlier migrations. I''ve tried "cap deploy_with_migrations", but it looks like it didn''t rebuild the database. How can I do the equivalent of this using Capistrano? "rake db:migrate VERSION=0" "rake db:migrate" -- Posted via

Hello, Can someone explain me why Capistrano deploys rails code to both :web and :db roles, not only to :app role, which is the only role that actually needs this code. In my setup I do not want to give any SSH access to :db servers other than server management, which is done outside Capistrano. So why Capistrano migrate task needs this access while it could to it from :app server, which

Hello, I am trying to deploy on to OS X Server with capistrano+mongrel+apache2, etc. I''m trying to do a "cap cold_deploy" as recommended here: http://blog.codahale.com/2006/06/19/time-for-a-grown-up-server-rails-mongrel-apache-capistrano-and-you/ I had a devil of a time getting cap to find the mongrel_rails command (which is in /opt/local/bin) on the server. I set the

Hi, I''m new at rails and am in the midst of deploying my first app to a test server. The app was developed on windows. I used Capistrano to deploy, and found a few issues: 1) I must chmod 755 dispatch.cgi each time I deploy 2) script/parse/reaper also doesn''t have the executable attributes so the deployment fails. 3) database.yml as checked out from svn isn''t