Hi,
I thinks this is the your postgresql configuration
probleme, which version of postresql you are using?
you have to activate the "tcipip_socket" variable
inside the postgresql.conf if you are using V7, if you
are using v8, you have to activate the "port"
variable.
if those varaible is activated, verify you local
firewall.
Hop it will help
Saiho
--- Sherman Lambert <sherman.lambert@state.co.us>
wrote:
>
> Hello, I''m a newbie to rails and I am trying to do
> the Demo in the
> November Issue of Linux Journal. Things go fine go
> fine until I try to
> connect to my Postgres database (ver 8.1). At this
> point I get the
> following error message
>
> ---- RoR error and trace back ----
> PGError in Admin#index
>
> could not connect to server: Permission denied
> Is the server running on host "localhost" and
> accepting
> TCP/IP connections on port 5432?
>
> RAILS_ROOT: /var/www/html/blog/public/../config/..
> Application Trace | Framework Trace | Full Trace
>
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:23:in> `connect''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:23:in> `postgresql_connection''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:145:in> `connection_without_query_cache=''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/query_cache.rb:54:in> `connection=''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:106:in> `retrieve_connection''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:20:in> `connection''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:518:in> `count_by_sql''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:511:in> `count''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:167:in> `count_collection_for_pagination''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:188:in> `paginator_and_collection_for''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:124:in> `paginate''
>
#{RAILS_ROOT}/app/controllers/admin_controller.rb:8:in> `list''
>
#{RAILS_ROOT}/app/controllers/admin_controller.rb:3:in> `index''
>
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:23:in> `connect''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:23:in> `postgresql_connection''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:145:in> `connection_without_query_cache=''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/query_cache.rb:54:in> `connection=''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:106:in> `retrieve_connection''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:20:in> `connection''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:518:in> `count_by_sql''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:511:in> `count''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:167:in> `count_collection_for_pagination''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:188:in> `paginator_and_collection_for''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:124:in> `paginate''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:853:in> `perform_action_without_filters''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/filters.rb:332:in> `perform_action_without_benchmark''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in> `perform_action_without_rescue''
> /usr/lib/ruby/1.8/benchmark.rb:293:in `measure''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in> `perform_action_without_rescue''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/rescue.rb:82:in> `perform_action''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:369:in> `process_without_session_management_support''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/session_management.rb:116:in> `process''
>
/usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/dispatcher.rb:38:in> `dispatch''
> /var/www/html/blog/public/dispatch.cgi:10
>
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:23:in> `connect''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:23:in> `postgresql_connection''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:145:in> `connection_without_query_cache=''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/query_cache.rb:54:in> `connection=''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:106:in> `retrieve_connection''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:20:in> `connection''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:518:in> `count_by_sql''
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:511:in> `count''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:167:in> `count_collection_for_pagination''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:188:in> `paginator_and_collection_for''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:124:in> `paginate''
>
#{RAILS_ROOT}/app/controllers/admin_controller.rb:8:in> `list''
>
#{RAILS_ROOT}/app/controllers/admin_controller.rb:3:in> `index''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:853:in> `perform_action_without_filters''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/filters.rb:332:in> `perform_action_without_benchmark''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in> `perform_action_without_rescue''
> /usr/lib/ruby/1.8/benchmark.rb:293:in `measure''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in> `perform_action_without_rescue''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/rescue.rb:82:in> `perform_action''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:369:in> `process_without_session_management_support''
>
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/session_management.rb:116:in> `process''
>
/usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/dispatcher.rb:38:in> `dispatch''
> /var/www/html/blog/public/dispatch.cgi:10
>
> Request
>
> Parameters: None
>
> Show session dump
>
> flash: !map:ActionController::Flash::FlashHash {}
>
>
> Response
> Headers: {"cookie"=>[],
"Cache-Control"=>"no-cache"}
> --- Error Traceback end----
>
>
> So, it looks like I can''t get a TCP connection,
> right?
>
> So i''s think wait I have a Zope installation that
> accesses this postgres
> installation using a tcp/ip connection, hmmmm.
>
> So i''s thinks some more and decide that it must be a
> ruby problem. So I
> try this script
>
> ---- ruby sript ----
> require "postgres"
> conn= PGconn.connect("localhost", 5432, "",
"",
> "blog_development","blog")
> print conn.user
> print conn.exec("INSERT INTO Blogs (title, contents)
> VALUES (''test'',
> ''Test contents'');")
> ---- ruby script end----
>
> I go check the database and the new row is in the
> Blogs table.
> I thinks some more and play with my database.yml
> file (below) trying to
> get it to work, but no go. This should be real
> simple. Does any of u''s
> see what I have done wrong?
>
> ---- database.yml ----
> development:
> adapter: postgresql
> database: blog_development
> host: localhost
> username: blog
> password:
> test:
> adapter: postgresql
> database: blog_test
> host: localhost
> username: blog
> password:
> production:
> adapter: postgresql
> database: blog_production
> host: localhost
> username: blog
> password:
> ---database.yml end----
>
>
> TIA,
>
> Sherman
> --
> Two wrongs don''t make a right, but... Two rights
> make a U-turn, and two
> U turns make a circle, and two circles mke a
> figure-eight, and two
> figure-eights make a butterfly. --Bullwinkle J.
> Moose
>
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com