similar to: RE: Re: scgi_rails opens new a database connection for everyrequest?

I have an app that seems to run fine when I develop on windows, but in my linux deployment environment I get this error: uninitialized constant SQLite Here is the stack trace: /usr/lib/ruby/gems/1.8/gems/activesupport-1.0.4/lib/active_support/dependencies.rb:183:in `const_missing''

Hello everyone! Pushing my new rails project I stumbled upon some weird problem. I cannot force WeBRICK to show me my MySQL records in UTF-8. All I recieve into the object (instead of russian letters) are question marks (a la ?????? style). I am running MySQL 4.1 (the one with switchable charsets) and a binary Ruby extension for it, all on OSX. To me it looks like MySQL never recieves what I

Seemingly random db connection drop (FastCGI/Apache/PostgreSQL). Kills the app with an ''Application Error (Rails)'' Any suggestions? production.log as follows: Processing Base#index (for xxx.xxx.xxx.xxx at 2007-12-07 13:39:03) [GET] Session ID: 4bfd0284bd7672b57e65bdb21637adb5 Parameters: {} Errno::ECONNRESET (Connection reset by peer):

I''m using RailsCron, and it''s working out very well for me. However, I''m having one problem right now. I use the acts_as_background on one of my model objects. In order to get it to add the cron job to the table, I have to make sure the model is loaded in environment.rb. MyObject.load However, I''m running 2-3 fcgi process on my server. Most of the time when

Hi all, I''m trying to make for nicer system error handling, with the help of rescue_action_in_public (see Recipe 47, in ''Rails Recipes'') PROBLEM: While it lets me capture an incorrect db name in database.yml (for example), with lower level errors like when the DB server is just down, I still get the default system error screen for MySQL::ERROR :

Hi Everyone - I have a rails 0.10.1 application deployed on a Windows 2003 server under XAMPP Lite 1.4.12. Running under CGI, the application works fine (a bit slow, obviously, but no problems). When I run under FastCGI, the app is fine until I leave it alone for a few hours. For example, last night I switched it to FastCGI and everything seemed to be working fine. When I woke up this

I''ve been trying to get fast cgi working for nearly a month now. Yes, an entire month! The application starts perfect, but it will die randomly after several hours. I have traced the problem back to /usr/lib/ruby/1.8/mysql.rb:1042:in `flush'' This happens when the app trys to query the database driver to see if it still has a connnection. This causes the app to crash. Here is

Hi, I am having Mysql connection problem for my first AddressBook application (which I took it from http://www-128.ibm.com/developerworks/linux/library/l-rubyrails/) I have gem installed the latest ruby, rails, lighttpd, fastcgi, mysql-4.1.14 on linux. Everything looks good. When I do: mysql -h localhost -u test -ptest -D AddressBook mysql> SELECT COUNT(*) FROM contacts; +----------+ |

I know this question gets asked a lot but I can''t seem to find the answer when I search through the mailing list. First off here''s my set up. Cent OS 4.3 Apache 2.0 Fast CGI 2.4.0 Rails 1.1 Mysql 5.0 The app starts up fine, but every morning it refuses to start and gives me the dreaded Application error untill I reload Apache. I thought my database was timing out so I added

Hi, I''m having a bit of a problem with a rails app and I wonder if anyone can help. It seems to run fine for a while, but if it''s left running too long (left running as a fastcgi or webrick process that is) it starts failing with an "ActiveRecord::StatementInvalid" error (i''ve included the full error from the log file below). I''m seeing this on both

I have run into a very strange problem discovered through the use of the acts_as_taggable plugin, but related to quoting/sanitizing the interpolated list in a find_by_sql. Apologies for the length, but I wanted to be complete. ;-) The method from acts_as_taggable.rb is: def find_tagged_with(list) find_by_sql(["SELECT #{table_name}.* FROM #{table_name}, tags,

Hi, I have an application that is running fine on two different machines, but when I ported the code to a third machine, it doesn''t seem to work. More specifically, for users with a significant amount of info, it seems to stop working. All the functionality seems to be working properly on a small test set, but with a larger set I get the following error: AssociatedAp Load (0.000000)

i had been trying for weeks to get fcgi to play right with apache. i finally got it working, but it''s far from stable. it was recommended to me that i should try using SCGI and that it is much easier to set up. being new to this stuff though, i''m not sure if there''s a lack of documentation or if there are some things that are just assumed and not known by a noob

I''ve run into a problem on one of my development machines. I''m trying to run multiple rails apps on one dev machine that runs Windows. Problem is that is seems that I can only run one scgi_service at a time, meaning that only one of my apps will function at a time. Anyone know how I can get around this, other than getting a *nix box (which I should have soon, hopefully) ?

Hi Everyone, I am sure this question has been asked many time before but I really could not get a good solution. The problem I am having is that the application I wrote is acting very slow. For example for the production database, the query I make takes about 3-4 minutes. The application connects to 2 oracle databases(on a remote location) and gets information based on a given search criteria.It

Hello All, I''ve run into a snag. (I apologize in advance. I''m not very good at system administration.) I''m building an app that allows users to upload files. Up until now I have been storing the files on the file system, but tonight I decided to change the app so the files are stored in the database as a longblob. I thought everything was working great, until I

two problems, pls help...I''m under big pressure at work to fix this! I''m having trouble getting scgi and lighttpd running on windows - here''s what I did: On Win XP, I installed ruby, rubygems, and setup my rails app. All works fine with webrick. I then did: gem install cmdparse and gem install highline (as required for the scgi_rails gem according to

Hi, I have an application running on Apache SCGI (Win XP). Once I run it in production mode (scgi_ctrl config -S -e production ) I''m getting stack trace instead of HTTP status 500 (Application Error) and the error is logged production.log. The application works fine without SCGI. Your help is highly appreciated.... Thanx /* production.log */ # Logfile created on Thu Jan 04 16:35:43

It looks like cached-model is broken again under rails 1.1. Can anyone confirm? Note that the exception below indicates it''s trying to treat CachedModel as the class name of the model, rather than using the proper class name (which is Entry in this case, and the table called entries). This is a model using Single Table Inheritance and acts_as_tree, and worked just fine under 1.0 and

I am having a problem using the test database in Rails 3. It apparently has kept track of aspects of the database that I deleted completely from my migrations at some point. I don''t always use the ''down'' part of a migration and sometimes just recreate the whole database. I did rake db:migrate:reset and rake db:test:prepare, but when I run my test it is trying to access