similar to: database.yml, postgresql and pgpass.conf conflicts

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

Hi I am trying to get RoR to work with Postgresql 8,2.5 (latest stable version) Steps taken 1. Download Postgresql 1.82 and installed successfully 2. Edited my Database.yml development: adapter: postgresql database: test_development username: postgres password: xxx host: localhost test: adapter: postgresql database: test_test username: postgres password: xxx host: localhost

I''ve been runnning Perl under Apache for a while but have decided to try using Ruby-on-Rails. My current database is postgreSQL 8.1. I have no problem connecting to it using Perl or PHP 5. However, I''m obviously missing something ''cos no matter what I do I cannot connect to the database from RoR. I have followed all of the instructions I could find and when I start

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

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

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

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

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 there, I''ve been trying for a few hours now to get RoR and postgresql talking - but I''m very confused about what''s going on (I''m running windows btw). I haven''t created a database in postgresql (I''m assuming that RoR will do that?) my database.yml looks like this: production: adapter: ruby-postgres database: rails_production

CentOS-6.5 We deploy web applications written with the Ruby on Rails framework using Capistrano (2.x). Each 'family' of web applications are 'owned' by a dedicated user id. The present httpd service is Apache 2.2.15 and we use Passenger 3.0.11. We are moving shortly to a new deployment host and at that time we will be updating to Apache 2.4.9 and Passenger 4..0.25. Our

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

Forgive me for asking a trivial question on this list, but being new to Ruby/Ruby on Rails, I''m not sure where to start.... I''m trying to connect to a postgresql server: My database.yml contains: test_test: adapter: postgresql database: test_test username: testuser password: resutest host: testpgserver port: 5432 encoding: UTF8 min_messages: warning The

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

Hello people... In the rails2.pdf Dave T says: Rails works with the DB2, MySQL, Oracle, Postgres,... The database drivers are all written in C and are primarily distributed in source form. Then he lists this site: http://ruby.scripting.ca/postgres/ Then he says, There is a pure-Ruby version of the Postgres adapter available. Download postgres-pr from the Ruby-DBI page at

I have tried for several hour to get a mysql db connection to work, but have failed so far: This is a cpanel server running Mysql 4.1.19, fcgi with apache. Here is the output from script/console Loading development environment. /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:194:in

Hi, Are the active database.yaml attributes for the current environment (dev, prod, test) available inside a controler ? adapter, host, db, socks, etc. AFIK Class#connection don''t give back theses infos. Thanks

I know this isn''t Python, but I''d like to get a view on the ''one obvious'' way to set up an SQLite (or other) database and its location per-app. I''ve got a bit lost with the Camping 2 changes and various code snippets I have kicking around. 1. is it best to set up the DB creation/connection: 1.1 at the end of the app

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:

I can''t seem to connect to a remote database. Here is what I''ve tried. the database,username,password, and host have been changed to protect the innocent. development: adapter: mysql database: database username: username password: password host: host port: 3306 Here is the error /usr/lib/ruby/1.8/yaml.rb:133:in `load'': syntax error on line 11, col 2: `