ActiveRecord::ConnectionNotEstablished in Rails
Friday, August 24th, 2012 | Programming, Tech
I ran into this error while trying to get Ruby on Rails 3.1.1 which I installed from the Rails Installer to talk to MySQL. My stack is built from WAMP, so it might not have been as easily as it would be on a standlone MySQL installation.
Here is are the steps I took to fix it.
Edit Gemfile in project and add the following line.
gem 'mysql2', '< 0.3'
Rebuild the MySQL adapter with your version of MySQL.
gem uninstall mysql2
gem install mysql2 -- --with-mysql-config="C:/wamp/bin/mysql/mysql5.5.16/bin/mysql_config.pl"
Download the MySQL connector from the MySQL website.
http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip/from/pick
Once you have the zip file, uncompress it and copy lib/libmysql.dll to the Ruby bin directory. Finally, go back to your Rails project and run the following command.
bundle install
I was finally then able to run a command such as the following.
rails generate model Something name:string
Without it throwing any errors up.
I ran into this error while trying to get Ruby on Rails 3.1.1 which I installed from the Rails Installer to talk to MySQL. My stack is built from WAMP, so it might not have been as easily as it would be on a standlone MySQL installation.
Here is are the steps I took to fix it.
Edit Gemfile in project and add the following line.
gem 'mysql2', '< 0.3'
Rebuild the MySQL adapter with your version of MySQL.
gem uninstall mysql2 gem install mysql2 -- --with-mysql-config="C:/wamp/bin/mysql/mysql5.5.16/bin/mysql_config.pl"
Download the MySQL connector from the MySQL website.
http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip/from/pick
Once you have the zip file, uncompress it and copy lib/libmysql.dll to the Ruby bin directory. Finally, go back to your Rails project and run the following command.
bundle install
I was finally then able to run a command such as the following.
rails generate model Something name:string
Without it throwing any errors up.