similar to: access value set in config/database.yml

A little background. We are deploying a rails app on jboss by using warbler and the app is using rails 3.0.3. There are several parameters the customer may need to change. Some of these parameters include database connection information, ie shema, username, password, host, port, and database. We are connecting through oracle thorugh the jdbc adapter. My problem lies in the fact that I cannot

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

Hi everyone, What are other people doing with regards to database.yml being in version control? My dilema: I set up my rails app in svn using these instructions: http://wiki.rubyonrails.com/rails/pages/HowtoUseRailsWithSubversion The part to note is where I ignore database.yml, allowing different developers to keep their own database.yml without clobbering other developers'' files.

Hi, I would like to understand how to calculate optimal value for "pool" parameter in database.yml I''m using rails 3, ruby 2, postgres, elasticsearch, unicorn, nginx My server : 12 coeurs 24 threads ( I dont know if it is necessary for define pool value) unicorn : worker_processes 24 I have around 1500 pages requested per minutes, and around 200ms per request Is it also

Hi All, It is our corporate security policy to not leave plain text passwords in text files (such as database.yml). I would like to to roll out a Rails application, but would like to find another way to connect to MySQL without leaving plain text passwords in database.yml Any thoughts? Thanks, Brian Long

Hi, I''m upgrading from 0.13.0 to 0.14.4, and I''m having trouble with my database authentication. Even though the entries in my database.yml are correct, I get the following message when trying to do a ruby script/generate scaffold myClass... Access denied for user: ''@localhost to database '''' Why is the username and database name showing up as

All, Database: SQL Server 2000 SQLServer adapter in ODBC mode I have a Capistrano deploy script which fails when I run against my production DB. Apparently, this is the because the user that is set up for production has "guest" privileges in my SQL Server database and when Capistrano runs, instead of looking at the dbo.schema_info table (which has the correct version # - yes I

I am unable to connect to my databases. Here is the error I am getting: MysqlError (Can''t connect to local MySQL server through socket ''/var/run/mysqld/mysqld.sock'' (2)): Here is my database.yml: # MySQL (default setup). Versions 4.1 and 5.0 are recommended. # # Get the fast C bindings: # gem install mysql # (on OS X: gem install mysql --

All, Apache 2/FastCGI on Linux My fastcgi config. file is set up to run the "test" RAILS_ENV. When I go to access a view associated with a particular controller, I keep getting a ENOENT (file not found) error on a custom config. file that I am attempting to load. What I can''t figure out is why it can''t find the file. Here''s the code that loads it in my

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

Since upgrading to rails 1.0 I keep getting a parse error in database.yml. I have tried multiple configurations of both mysql and postgres and continue getting this error message when trying to generate a model or scaffold. -Andrew

Hi Using ruby 1.8, rails 1.0, mysql 4.1.11 in database.yml: adapter: mysql encoding: utf8 database: myproject_development username: user password: password socket: /var/run/mysqld/mysqld.sock but when I start the error I get: Can''t initialize character set utf8 (path: /usr/share/libmysqlclient/charsets/) Can anyone tell me what file it''s looking for, and how I

Hello, I want to get the production environment configuration from the database.yml in the /shared folder of a deployed rails application. I could use scp to get the file, write it to temporary file, read it and open it with YAML, but is there a better way to do this? Best regards, -- Aníbal Rojas http://www.rubycorner.com http://www.hasmanydevelopers.com

Hi, I have created one application. In that application I am not using any database. Whenever I starting rails server it is giving me an error for configuration of database.yml. What should I do for this? Thanks, Tushar -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups

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

Hi all According to the Agile 2nd Ed book I added the line encoding: utf8 to my database.yml connections. But now when running rake I get plenty of errors: Character set ''utf-8'' is not a compiled character set and is not specified in the ''/usr/local/mysql/share/mysql/charsets/Index'' file What''s wrong here? I checked this Index file, but it seems to

Hello I''ve now read a lot about application-level authentication in Rails, but I need to do database-level authentication. The reason is that my database needs to have the current_user (database current_user, not current_user defined in an ActiveRecord Model) set to execute triggers for automatically updating audit tables. So it is not enough to have a session check against a User

exactly what do i need to change? i should set username and password to whatever i want? or username should be root? what exactly do i need to change/set up? """ You then need to edit the database.yml file (in any text editor) to properly link to your database etc. This file can be found in the ProjectName\config\ directory. You will be presented with something that looks like:

Hi all! I am completely new to RoR and I have runned into a problem. I have followed an online course for RoR on Lynda.com and everything has worked out well until I should change to database.yml file. Instead of the tutors text "host: localhost" I get "socket: /tmp/ mysql.sock" in development enviroment I thought I would give it a try to continue anyway but when I later try

i ran rake backgroundrb:setup and modified the default config/backgroundrb.yml file as: --- port: "22223" timer_sleep: 60 load_rails: true environment: production host: localhost database_yml: config/database.yml acl: deny: all allow: localhost 127.0.0.1 order: deny,allow and my database.yml production: adapter: mysql database: chip2_production username: xxxxx password: