pg_connect works, DBI::connect says permission denied

Поиск
Список
Период
Сортировка
От ryan miller
Тема pg_connect works, DBI::connect says permission denied
Дата
Msg-id 30ee5f780511161502y3c93d6bcgbb76c839418ce589@mail.gmail.com
обсуждение исходный текст
Список pgsql-novice
Hello,
  I'm having problems connecting to my Postgres database using DBI::connect in Perl.

--------------------------------------------------------------------------------------------------------------------------------------------------
DBI connect('dbname=visualizer','visualizer',...) failed: could not connect to server: Permission denied
       Is the server running locally and accepting
       connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
--------------------------------------------------------------------------------------------------------------------------------------------------

Two important things to note:
  1)  The permissions on both the /tmp directory and the socket file are 777 (full access)
  2)  I can connect to the same database just fine using pg_connect in PHP

I just installed everything on a new server, and everything worked fine on the old one.
I figure I missed some configuration detail somewhere.  Any ideas?

Here are the versions I'm using:
  PostgreSQL 7.4.8
  PHP 4.3.9
  Perl 5.8.5
  Don't remember which version of Redhat I have

Thanks in advance for your consideration,
   RYan Miller

В списке pgsql-novice по дате отправления:

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: Application using PostgreSQL as a back end (experienced programmers please)
Следующее
От: ryan miller
Дата:
Сообщение: Problem Accessing PostgreSQL from Perl CGI