similar to: MySQL connection problem

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

We have installed rails 1.1.2 and Ruby 1.8.4 on solaris. When we attempt to run the initial migration we get the following error: Mysql::Error: Lost connection to MySQL server during query: SELECT version FROM schema_info /web/server/pkgs/ruby-1.8.4/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:120:in `log''

Hello all, Though I''ve read all I could about the "Lost connection to MySQL server during query: SHOW FIELDS FROM ...", I''m still unable to use RoR. I''m on Linux Mandriva 2006 / MySQL-4.1.12 / ruby-1.8.2 - The userid/password have access to the database and the table (it''s the root user on MySQL) - I''m on a nonstandard socket/port, but

I getting this error on my project Mysql::Error: Lost connection to MySQL server during query: SHOW FIELDS FROM ... i think that it''s because the mysql database don''t allow persistent connections ..... any idea? thanks -- _________ Noel R. Morais

I have searched the forums, searched google, etc for the past 3 days and have not found a solution that will work. Any help is greatly appreciated and at this point I have no problem paying for help. I have a paypal account. I was developing my rails project on a server that had mysql 5. We finished development and needed to move it over to the client server, their server has mysql 4.1.

When I `sudo gem install mysql` I get the following: --snip-- $ sudo gem install mysql Attempting local installation of ''mysql'' Local gem file not found: mysql*.gem Attempting remote installation of ''mysql'' Updating Gem source index for: http://gems.rubyforge.org /usr/local/lib/ruby/1.8/yaml.rb:133: [BUG] Segmentation fault ruby 1.8.4 (2005-12-24)

i just deployed my app on ubuntu with passenger. i installed the mysql gem as follows: $ sudo gem install mysql Select which gem to install for your platform (i486-linux) 1. mysql 2.7.3 (mswin32) 2. mysql 2.7.1 (mswin32) 3. mysql 2.7 (ruby) 4. mysql 2.6 (ruby) 5. Skip this gem 6. Cancel installation > 3 Building native extensions. This could take a while... Successfully installed

hi all, I am getting an error when trying to connect to a mysql server on my ''production'' linux server. The rails app works fine when connecting to the ''development'' mysql on my windows development server. I have looked at the following wiki: http://wiki.rubyonrails.com/rails/pages/Mysql+Connection+Problems/ and I installed the mysql gem, however this does

Hi, I?m having problems building and installing the mysql gem on a Fedora Core 4 (Linux) server. # gem install mysql Attempting local installation of ''mysql'' Local gem file not found: mysql*.gem Attempting remote installation of ''mysql'' Building native extensions. This could take a while... can''t find header files for ruby. ERROR: While executing

I have been trying to connect to MySQL thru rails. Initially I had rails 2.1.2 and upgraded to rails 2.2 to use RestAPI in sproutcore. Once I have upgraded my rails version to 2.2, I have been getting this error. All I did is the following: 1. rails addressbook 2. cd addressbook 3. script/generate scaffold Contact first_name:string lastname:string 4. rake db:migrate I also change the

Development Platform: ruby 1.8.4 Rails 1.1.2 mysql "gem" 2.7 Mac OS X (10.4.6), 64-bit Mysql 5.0.19-standard (64-bit) Lighttpd, 1.4.11 I''m trying to startup a simple test rails app against mysql. Rails starts up fine and my pages render successfully, until a DB access is made. I''m getting a "uninitialized constant Mysql". I''ve searched, but

Hi, I''ve been looking at Ruby on Rails for an in-house project where I work. After I got everything setup correctly (apache, fcgi, mysql, etc) I''ve started to run into "lost connection to mysql" errors. I googled to try and find a solution, but most of the problems people seem to be having are constant and simple to fix. I haven''t found anyone talking

Error Message: MyMysql::Error: Lost connection to MySQL server during query: SHOW FIELDS FROM products Running Fedora 5, using available Red Hat modules and latest version of Rails. This problem just appeared. I had been enjoying going through the tutorial "Depot" when it started displaying this problem. With phpMyAdmin I am able to access the depot_development data base containing

Hi, I got Mac OS X 15.6 installed, Locomotive 2.0.8 and MYSQL 5.0.67 running. I''m having this problem when I try to install mysql gem: Last login: Mon Feb 9 13:37:37 on ttys001 source /var/folders/be/bexGvm9pHdq0vcEmR8-WWk+++TM/-Tmp-//39E424DB-A260-4E41-AA2E-30B64FB46F3C-7395-00002254065EA712.environment.bash You have mail. MBPEduCirilo:~ eduardocirilo$ source

Hi all... The linux box I am working on I do not have root access to, and given I am at a government site all hope of that is lost. I have installed the mysql gem as follows: env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/home/t192zcs/mysql/mysql-5.1.39-linux-x86_64-icc-glibc23/bin/mysql_config

I have been very VERY frustrated for the past week trying to solve a seemingly spurious problem with my Windows XP SP2 box with Ruby 1.8.2/Rails 1.0.0/MySQL 5.0.16 or 4.1.15 (yes, I tried both) installed running against a remote MySQL server that was either 3.23 or 4.1 (4.1.15 to be exact--we finally matched them both up to make sure that wasn''t the problem). So I post it here (as

Hi, I''m lost and my mysql connection as well... I got this error in my production.log: ActiveRecord::StatementInvalid (Mysql::Error: Lost connection to MySQL server during query: SET NAMES ''utf8''): Config: Debian Sarge (last updated), Rails 1.1.2, Webrick, mysqld Ver 4.1.11-Debian_4sarge2 for pc-linux-gnu on i386 apache2 with mod_rewrite and webrick as proxy on 8080.

I''m trying to set up RoR on a laptop and having all sorts of troubles. I''m running XP SP2, I did a quick install of appache/mysql using Xampp, which worked fine. I grabbed the latest windows install of ruby and rails, installed it ok and got it running. The moment I try to run a rails page that queries a database, it fails every time, and I get the following error:

I just downloaded and installed Ruby on Rails to a Win XP SP1 OS using XAMPP. I started going through the beginner tutorials at rubyonrails.org. It appears as though Ruby on Rails is operating properly until I try to access the MySQL database I created for it. Then the browser displays a detailed statement created by Ruby. It is titled: ActiveRecord::StatementInvalid in Recipe#New Recipe is

Hi, I''m pretty newb at Rails deployement stuff. I''m setting up a Mongrel web server on windows following the tutorial on the official site. My app works except when there''s interaction with MySQL. I get this error : "Uninitialized constant Mysql" Now i''m pretty lost and i''m sure i''m doing something wrong. I''ve tried