ConnectionNotEstablished with Mysql on ubuntu

I recently installed Rails 3.1.1 on my ubuntu after lots of searching
on the web I managed to get my first app up and running on the local
server but I'm still getting "ActiveRecord::ConnectionNotEstablished"
I ran my app on Root and I added my root password to the database.yml
file and I have everything installed.
I don't know what else to do.

help please.

Can you paste the complete error please with stack trace, also paste
database.yml (remove password obviously)


here’s the full trace

activerecord (3.1.1) lib/active_record/connection_adapters/abstract/connection_pool.rb:409:in `retrieve_connection'
activerecord (3.1.1) lib/active_record/connection_adapters/abstract/connection_specification.rb:107:in `retrieve_connection'
activerecord (3.1.1) lib/active_record/connection_adapters/abstract/connection_specification.rb:89:in `connection'
activerecord (3.1.1) lib/active_record/query_cache.rb:65:in `rescue in call'
activerecord (3.1.1) lib/active_record/query_cache.rb:59:in `call'
activerecord (3.1.1) lib/active_record/connection_adapters/abstract/connection_pool.rb:477:in `call'
actionpack (3.1.1) lib/action_dispatch/middleware/callbacks.rb:29:in `block in call'
activesupport (3.1.1) lib/active_support/callbacks.rb:392:in `_run_call_callbacks'
activesupport (3.1.1) lib/active_support/callbacks.rb:81:in `run_callbacks'
actionpack (3.1.1) lib/action_dispatch/middleware/callbacks.rb:28:in `call'
actionpack (3.1.1) lib/action_dispatch/middleware/reloader.rb:68:in `call'
rack (1.3.5) lib/rack/sendfile.rb:101:in `call'
actionpack (3.1.1) lib/action_dispatch/middleware/remote_ip.rb:48:in `call'
actionpack (3.1.1) lib/action_dispatch/middleware/show_exceptions.rb:47:in `call'
railties (3.1.1) lib/rails/rack/logger.rb:13:in `call'
rack (1.3.5) lib/rack/methodoverride.rb:24:in `call'
rack (1.3.5) lib/rack/runtime.rb:17:in `call'
activesupport (3.1.1) lib/active_support/cache/strategy/local_cache.rb:72:in `call'
rack (1.3.5) lib/rack/lock.rb:15:in `call'
actionpack (3.1.1) lib/action_dispatch/middleware/static.rb:53:in `call'
railties (3.1.1) lib/rails/engine.rb:456:in `call'
railties (3.1.1) lib/rails/rack/content_length.rb:16:in `call'
railties (3.1.1) lib/rails/rack/log_tailer.rb:14:in `call'
rack (1.3.5) lib/rack/handler/webrick.rb:59:in `service'
/usr/lib/ruby/1.9.1/webrick/httpserver.rb:111:in `service'
/usr/lib/ruby/1.9.1/webrick/httpserver.rb:70:in `run'
/usr/lib/ruby/1.9.1/webrick/server.rb:183:in `block in start_thread'

and here’s the database.yml


adapter: mysql2


encoding: utf8

reconnect: false

database: myapp_development

pool: 5

username: root


socket: /var/run/mysqld/mysqld.sock

Was it ok when you created the database (rake db:create) or if you did
not create it like that are you able to run migrations ok? (And are
you still able to run migrations ok).


running “rake db:create” returns

rake aborted!

couldn’t parse YAML at line 20 column 2

Tasks: TOP => db:create => db:load_config

(See full trace by running task with --trace)

at line 20 there’s the “socket: /var/run/mysqld/mysqld.sock”

running "rake db:create" returns
rake aborted!
couldn't parse YAML at line 20 column 2

Tasks: TOP => db:create => db:load_config
(See full trace by running task with --trace)

at line 20 there's the "socket: /var/run/mysqld/mysqld.sock"

database.yml was generated by rails and I only added the password. it has no tabs.

Well there is something wrong with it. Has your password got any
funny characters in it? Alternatively retype a few lines around the
error and try again, possibly an unprintable char has got in there


turned out I only needed to add a space between “password:” and “my password”

that’s all.

thanks guys.