ConnectionNotEstablished with Mysql on ubuntu

Rails
1

Hi
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”
error.
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.

2

On 27 October 2011 06:23, dado_eyad [email protected] wrote:

Hi
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”
error.
I ran my app on Root and I added my root password to the database.yml
file and I have everything installed.

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

Colin

3

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:inretrieve_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:inrescue 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:incall’
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:incall’
actionpack (3.1.1) lib/action_dispatch/middleware/reloader.rb:68:in
call' rack (1.3.5) lib/rack/sendfile.rb:101:incall’
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:incall’
railties (3.1.1) lib/rails/rack/logger.rb:13:in call' rack (1.3.5) lib/rack/methodoverride.rb:24:incall’
rack (1.3.5) lib/rack/runtime.rb:17:in call' activesupport (3.1.1) lib/active_support/cache/strategy/local_cache.rb:72:incall’
rack (1.3.5) lib/rack/lock.rb:15:in call' actionpack (3.1.1) lib/action_dispatch/middleware/static.rb:53:incall’
railties (3.1.1) lib/rails/engine.rb:456:in call' railties (3.1.1) lib/rails/rack/content_length.rb:16:incall’
railties (3.1.1) lib/rails/rack/log_tailer.rb:14:in call' rack (1.3.5) lib/rack/handler/webrick.rb:59:inservice’
/usr/lib/ruby/1.9.1/webrick/httpserver.rb:111:in service' /usr/lib/ruby/1.9.1/webrick/httpserver.rb:70:inrun’
/usr/lib/ruby/1.9.1/webrick/server.rb:183:in `block in start_thread’

and here’s the database.yml

development: adapter: mysql2 host: 127.0.0.1 encoding: utf8 reconnect: false database: myapp_development pool: 5 username: root password:***** socket: /var/run/mysqld/mysqld.sock
4

On 1 November 2011 02:23, dado_eyad [email protected] wrote:

username: root
password:*****
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).

Colin

5

On Tue, 2011-11-01 at 05:28 -0700, dado_eyad wrote:

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

yaml is very whitespace sensitive

be sure that this line doesn’t use ‘tabs’ and only a space

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

Craig

–
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

6

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”

7

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

8

turned out I only needed to add a space between “password:” and “my
password”
that’s all.

thanks guys.

9

On 1 November 2011 13:00, dado_eyad [email protected] wrote:

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
somehow.

Colin