On Sun, 2011-12-11 at 19:59 -0400, gato pardo wrote:
I am dragging for personal use a rails application using postgresql
that has been working for some time now. As I installed Fedora 16
adapted the rails application to the new tools. The application works
fine as long as It is tried in development environment.
As soon as the production environment is used the following messages
are captured: "we're sorry, but something went wrong." in the
Started GET "/album/" for 126.96.36.199 at Sun Dec 11 19:28:07 -0400
PGError (FATAL: Peer authentication failed for user "postgres" ):
in the log/production.log file
Any help would be very much appreciated .
I would not recommend that user 'postgres' is the user of any postgresql
database from within rails but that is not an answer to your question
but only a suggestion.
If you check your RAILS_ROOT/config/database.yml file, you should have a
section at least for 'development', 'test' and 'production'
You don't say what is different from each configuration (obviously only
the development & production configurations are relevant to your
question) and you don't tell us if the the server is the same for both
development and production.
If I was going to guess, I would think that your development section
uses a 'socket' to connect (something like /var/lib/mysql/mysqld.sock)
and in production, you don't use a socket so it tries to use TCP/IP Port
5432 which would cause user postgres to fail unless specifically
configured in the pg_hba_conf file (but user postgres is really intended
to use only via a local socket.
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to email@example.com.
To unsubscribe from this group, send email to firstname.lastname@example.org.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.