Problem using mysql 5.1 with RoR 3.1

Rails
#1

I am newbie, and setup RoR 3.1 on Ubuntu 11.04.
I followed everything on this blog, and the initial site came up fine
on sqlite3:
http://excid3.com/blog/ruby-on-rails-3-and-mysql-on-ubuntu-10-10/

Switching to mysql and running the rails server (rails s) displays
this issue:
ActiveRecord::ConnectionNotEstablished
(ActiveRecord::ConnectionNotEstablished):

I am pretty sure the database.yml is correct (shown later), that the
database exists, and
the user nara (myself) can access the database using the mysql client.
I have tried rebooting my machine, but that does not help.

Any ideas?
Nara

development:
adapter: mysql2
encoding: utf8
reconnect: false
database: mblogdev
pool: 5
username: nara
password:
socket: /var/run/mysqld/mysqld.sock

Warning: The database defined as “test” will be erased and

re-generated from your development database when you run “rake”.

Do not set this db to the same as development or production.

test:
adapter: mysql2
encoding: utf8
reconnect: false
database: mblogtest
pool: 5
username: nara
password:
socket: /var/run/mysqld/mysqld.sock

production:
adapter: mysql2
encoding: utf8
reconnect: false
database: mblogprod
pool: 5
username: root
password:
socket: /var/run/mysqld/mysqld.sock

#2

I also gem installed mysql, and changed everything in database.yml to
mysql.
Still the same issue with ActiveRecord failing to connect. I will go
back
to using mysql2, and hopefully, get some help on this group. I will
also try the mysql
blog author at excid3.com. If I can somehow get mysql2 to work, I will
post here. At this rate, it looks like I may have to try postgres
instead.

Thanks
Nara

#3

Don’t know if it will help, but try something like

development:
adapter: mysql2
encoding: utf8
database: mblogdev
username: nara
password:
host: server_ip_addr_here

-GR

#4

On Mon, Sep 12, 2011 at 12:42 PM, Nara [email protected] wrote:

I also gem installed mysql, and changed everything in database.yml to
mysql. Still the same issue with ActiveRecord failing to connect. I will go
back to using mysql2

Have you tried generating a new rails app starting out with mysql? e.g.
% rails new myapp -d mysql

I just did that as a quick test (on MySQL server 5.1.41) and it worked
out of the box.

Rails 3.1.0 / Ruby 1.9.2-p290 (on OS X, though that shouldn’t matter)

–
Hassan S. ------------------------ [email protected]
http://about.me/hassanschroeder
twitter: @hassan

#5

Hi,
if you’re new to Rails on Ubuntu DO NOT follow that blog post, it’s
simply bad. Use RVM instead:
http://gezope.github.com/rvm_install_script/

First I highly recommend to start with all default settings. If
anything works properly and then you change DB for example and an
error occurs - you can be sure that it was the mistake.
Postgres is good, since you don’t need to change any SQL I think
locally everything works fine, and remotely you’ll like Postgres
later.

HTH Let me know if you’ve further questions, cheers
Zoli