I''m just getting off the ground with Ruby and Rails, so please forgive
me if there is an obvious solution to my problem:
I''ve installed the latest version of everything, and have created a
Rails application. My database configuration file looks like this:
development:
adapter: postgres
database: photo
host: localhost
username:
password:
test:
adapter: postgres
database: photo_test
host: localhost
username:
password:
production:
adapter: postgres
database: photo_prod
host: localhost
username:
password:
I''m getting this error when I fire up the application:
floyd: [photo 34 ]> ruby
script/server
~/projects/photo 0
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/connection_adapters/abstract_adapter.rb:83:in
`establish_connection'': database configuration specifies nonexistent
postgres adapter (ActiveRecord::AdapterNotFound)
from
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/connection_adapters/abstract_adapter.rb:75:in
`establish_connection''
from
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/connection_adapters/abstract_adapter.rb:70:in
`establish_connection''
from ./script/../config/environment.rb:47
from script/server:42:in `require''
from script/server:42
I''ve installed the latest version of the Ruby postgres driver, with no
errors during the build. I thought that perhaps the adapter name was
incorrect, so I replaced it with ''postgrespr'', but with the
same results.
I can connect to the ''photo'' database using psql just fine.
Postgres is
listening on both the unix domain socket, and on tcp/ip port 5432...
This script also works without any errors:
require "postgres"
conn = PGconn.connect("localhost", 5432, "",
"", "photo")
res = conn.exec("select * from a;")
I created a dummy table ''a''....
What am I doing wrong? The ''nonexistent postgres adapter''
implies I''m
missing a module, but I''m not sure. Is it configuration? Something
else?
Cheers!
-klm.