similar to: connect to database

Hi, I really need help to understand what is happening while Rails connect to a database, (we area actually using postgresql, so my example will be with postgresql) What I understand is Rails is able to connect to different DB. Actually, this is what we want, and we have made some tests, everything is juste fine. However, all these tests lead us to some important questions that we did find the

I''m sorry guys. I''m really still such a newbie at this. i''ve been having trouble getting my Rails apps to run on Dreamhost, and I think it might be a problem with the database connection. Anyway, I read on Code Snippets that I should do this: [rhod]$ ruby -Iconfig -renvironment -e "p ActiveRecord::Base.connection" to find out if my database.yml file is

Hi All, I am having a problem to access multiple databases with mssql I am running Ruby 1.8.4 and Rails 1.1 on Windows 2000 Advanced Server. I am simply trying to integrate the application I wrote before for Oracle to Mssql. The application works perfectly with Oracle with the installed driver OCI8. The app retrives data based on a search criteria from those databases. I followed the directions

In my production environment I have 1 server running as mainappserver ( ex. 10.10.10.10 ) ( Rails + Apache2 + Mysql ) and during heavy periods we startup a second application server that just handle the Rails application calls. The second application server ( ex. 20.20.20.20 ) connects to the mysql of the mainappserver as specified in the database.yml : production: adapter: mysql2

please help me to solve my problem how to connect database via instantrails is any codes is there -- Posted via http://www.ruby-forum.com/.

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

I just started investigating Ruby on Rails and am trying the tutorial. I need to connect to a SQL Server 2000 database for testing purposes. I followed the instructions in the How-To on the wiki for SQL Server. The problem is that when attempting to connect to the database I receive the following errors: DBI::DatabaseError in RecipeController#new Open OLE error code:80004005 in

i m not able to connect to database I am create my rails folder i get database.yml file in this format # SQLite version 3.x # gem install sqlite3-ruby (not necessary on OS X Leopard) development: adapter: sqlite3 database: db/development.sqlite3 timeout: 5000 # Warning: The database defined as ''test'' will be erased and # re-generated from your development database when

>> >> Just some quick ideas >> * check if the mysql socket file has rw permissions for the dovecot user # ls -l /var/lib/mysql/mysql.sock srwxrwxrwx. 1 mysql mysql 0 Mar 1 19:33 /var/lib/mysql/mysql.sock >> >> * Try to run the mysql query as user dovecot (su dovecot) The dovecot user I set up is a non-interactive user /sbin/nologin I studied different setup

Hello, I want to change the connection collation that rails uses but I''m unsure of exactly what the best way to do this is. Everything in MySQL - the server, database and all tables are set to utf8_unicode_ci collation, but the connection collation in rails still appears to be utf8_general_ci (the default?). We are using the mysql2 adapter. I''ve seen a couple of possible

I have a need to connect to a separate database in order to get some information from that DB but I am trying to figure out the most elegant way to do it. With this application there will be times when a new DB will be added to the mix and I would rather not have to add models to my app every-time a new database is added. I could do it this way if that is how everyone tells me to go, but

Hi, We have experienced some problems with ActiveRecord::Base class of Ruby-Rails. We are building a web-application based on the Ruby-rails framework and the web-application needs to access to difference databases, so we do not pre-define our database accesses in the database.yml file. In fact, we are using the ActiveRecord::Base.establish_connection() to connect to our database, the function

Hi. I''m trying to authenticate users against database''s user/roles (PostgreSql), instead use an almighty user set in database.yml Can i use ActiveRecord::Base.establish_conection() method? And is this related whit ActiveRecord::Base.allow_concurrency = true and ActiveRecord::Base.verify_active_connections? I know about issues related with this point (Katana Suicide Concurrency),

I have a rails application that connects to two different databases. The first (primary) database is MySQL and the second is Oracle. I have followed the example in the Rails Recipes book and I have created a base class for the models connecting to oracle like this: class ConferenceBase < ActiveRecord::Base establish_connection :conference end :conference is setup in the database.yml. A

R-help, I get the following error message when trying to connect to an Oracle database through R (2.8.1) under Linux (Ubuntu 9.04). > channel<-odbcConnect("magnus",uid="luisr",pwd="juanayzakarias") Warning messages: 1: In odbcDriverConnect(st, ...) : [RODBC] ERROR: state IM002, code 0, message [unixODBC][DriverManager]Data source name not found, and no

Hi, I am new to R and wondering if it is possible for it to connect to an Informix database. I tried google but nothing came back that I could figure out. Can somebody tell me if its possible (which I believe it is) and how to connect to an Informix database using R. Thanks! -- View this message in context: http://r.789695.n4.nabble.com/R-connect-to-Informix-Database-tp4310594p4310594.html

I am developing a large scale financial application which is going to be very intensive write-wise, and use a lot of transactions. I can see how the the web and application servers can be scaled and load balanced quite easily, but not the database tier. The setups I have looked at so far seem to deal with coping with a lot of reads, and minimal writes - this maybe because they are largely

I have dovecot version 2.2.10 dovecot -n output below I am seeing connection errors being written to my dovecot error log: Mar 1 19:51:15 mail dovecot: auth-worker(2224): Error: mysql(localhost): Connect failed to database (servermail): Access denied for user 'usermail'@'localhost' (using password: YES) - waiting for 5 seconds before retry My connection script located at

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

Hello, I am building my first application with MySQL database and I am solving this problem - my app can''t to connect to MySQL server. MySQL server is running, in terminal (I am working at Mac) I created MySQL table and I set password to MySQL with using following command: mysqladmin -u root password ''mypass'' in database.yml is: development: adapter: mysql2