similar to: problem with database.yml

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

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

im trying to deploy my app on our staging server and am running into an issue. we have a MySQL NDB cluster for the staging box. this basically means that the staging box should be able to use MySQL via localhost and it will automatically know it''s in a cluster. When running queries, it will go out to the real DB boxes instead of localhost to fetch the data. AFAIK, the clustering setup

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

Hi There, Users in some european countries like to write 1.234,56 instead of 1,234.56 What would be the easiest way of accepting this number format? For output, I''m using a formatting helper, but I haven''t figured out how to do it for input. thanks, js

I''m not sure why but I have both a staging and production deploy using the ''capistrano/ext/multistage'' gem. I set staging to the default: set :stages, ["staging", "production"] set :default_stage, "staging" It deploys correctly to the right path: #deploy/staging.rb set :deploy_to, "/home/myuser/public_html/mysite/" But it

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

Hi, Just trying to get my first database based rails app up on dreamhost.com. The app was working prior to putting in mysql DB usage but I''m just stuck on getting the app working with mysql. I''ve already created the database and can connect to it manually. Below is the error I get after running the rake migrate. It worked OK on my home PC environment. I did change the

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

Does anyone know a good authentication tutorial they can suggest? I''ve tried several restful authentication ones and an authlogic one on RailsCast. But with each one I try, something seems to be missing in the tutorial and I can''t get it to work. I''m new to Rails so it''s possible user error on my part. I''m on Mac OS X 10.5 and I generate all my apps in

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 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 everybody, I am new in rubyonrails, and I am trying to learn it so I try to implement tht examples in the agile web developement with rails. I have stopped when I want to use scaffold. as it is mentionned in the book: ruby script/generate scaffold Product Admin but i get an error: it said no such file or directory /tmp/mysql.sock I have checked my configuration of mysql and i found that mysql

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

Hi all I trying to access from my controller the host, database, user, password that being set in database.yml in the config directory. Anyone has any idea?

Hi, I noticed that, on Windows at least, if I have a password set in the database.yml file for a database that I also have in my pgpass.conf file, the Rails adapter will die with a password authentication error. I don''t seem to have this issue on Unix systems. It''s simple enough to solve - just comment out the password info in the database.yml file. I just wondered if there

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

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

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

I have Rails 1.1, MySql 5.0 and would like to stor text as utf8 in the db. I have changed the character set and collation in the db to utf8 and utf8_danish_ci - also checked the mysql to if its ok: show collations like "%danish%"; utf8_danish_ci utf8 203 Yes 8 I then add the following environment.rb: $KCODE = ''u'' require ''jcode'' och database.yml