Hi, I have PostgreSQL 8.0.3 installed on SuSE 9.3 box along with Apache 2, PHP 5.0.3-14.5 and latest phpPgAdmin 3.5.5. Several months ago I had working setup, but since then my system have been patched with latest RPMs, and old PostgreSQL databases and setup files have been deleted and re-initialized from scratch. And now I have a problem: whenever I am trying to connect to PostgreSQL 8 with phpPgAdmin, I get this error (even ith ¨extended login¨ option in phpPgAdmin set to false). from PostgreSQL 8 log: LOG: database system is ready LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connection refused FATAL: Ident authentication failed for user "postgres" adodb error message: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: Ident authentication failed for user "postgres" in /home/andrei/public_html/tools/phpPgAdmin/libraries/adodb/drivers/adodb-postgres64.inc.php on line 404 This is strange because by default PostgreSQL 8 seem to allow password-less connection from localhost. Additionally, what does it have to do with port 113? Config file specifies port 5432. Additionally,I have changed Anyone have an idea how to fix this? Thanks in advance for any suggestion(s). ************************************************ *** with best regards *** Andrei Verovski (aka MacGuru) *** Mac, Linux, DTP, Programming Web Site *** *** http://snow.prohosting.com/guru4mac/ ************************************************
I am going to startoff with the basics: 1) Can you ping this address? 2) If you can ping, then can you telnet to 5432, 'telnet 127.0.0.1 5432' Let us know ... Thanks, LDB Andrei Verovski (aka MacGuru) wrote:
Hi,
I have PostgreSQL 8.0.3 installed on SuSE 9.3 box along with Apache 2, PHP 5.0.3-14.5 and latest phpPgAdmin 3.5.5. Several months ago I had working setup, but since then my system have been patched with latest RPMs, and old PostgreSQL databases and setup files have been deleted and re-initialized from scratch.
And now I have a problem: whenever I am trying to connect to PostgreSQL 8 with phpPgAdmin, I get this error (even ith ¨extended login¨ option in phpPgAdmin set to false).
from PostgreSQL 8 log: LOG: database system is ready LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connection refused FATAL: Ident authentication failed for user "postgres"
adodb error message: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: Ident authentication failed for user "postgres" in /home/andrei/public_html/tools/phpPgAdmin/libraries/adodb/drivers/adodb-postgres64.inc.php on line 404
This is strange because by default PostgreSQL 8 seem to allow password-less connection from localhost. Additionally, what does it have to do with port 113? Config file specifies port 5432.
Additionally,I have changed
Anyone have an idea how to fix this?
Thanks in advance for any suggestion(s).
************************************************ *** with best regards *** Andrei Verovski (aka MacGuru) *** Mac, Linux, DTP, Programming Web Site *** *** http://snow.prohosting.com/guru4mac/ ************************************************
OK .. i just read the rest of your email .. which answers my questions .. :) LDB Andrei Verovski (aka MacGuru) wrote:
Hi,
I have PostgreSQL 8.0.3 installed on SuSE 9.3 box along with Apache 2, PHP 5.0.3-14.5 and latest phpPgAdmin 3.5.5. Several months ago I had working setup, but since then my system have been patched with latest RPMs, and old PostgreSQL databases and setup files have been deleted and re-initialized from scratch.
And now I have a problem: whenever I am trying to connect to PostgreSQL 8 with phpPgAdmin, I get this error (even ith ¨extended login¨ option in phpPgAdmin set to false).
from PostgreSQL 8 log: LOG: database system is ready LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connection refused FATAL: Ident authentication failed for user "postgres"
adodb error message: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: Ident authentication failed for user "postgres" in /home/andrei/public_html/tools/phpPgAdmin/libraries/adodb/drivers/adodb-postgres64.inc.php on line 404
This is strange because by default PostgreSQL 8 seem to allow password-less connection from localhost. Additionally, what does it have to do with port 113? Config file specifies port 5432.
Additionally,I have changed
Anyone have an idea how to fix this?
Thanks in advance for any suggestion(s).
************************************************ *** with best regards *** Andrei Verovski (aka MacGuru) *** Mac, Linux, DTP, Programming Web Site *** *** http://snow.prohosting.com/guru4mac/ ************************************************
LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connection refused FATAL: Ident authentication failed for user "postgres"
You've put "ident" authentication in your pg_hba.conf file. You can change this to one of the other authentication methods (described in the file). pg_hba.conf is located in the data directory in your PostgreSQL implementation.
On Saturday 10 September 2005 07:16, Andrei Verovski (aka MacGuru) wrote:
Hi,
I have PostgreSQL 8.0.3 installed on SuSE 9.3 box along with Apache 2, PHP 5.0.3-14.5 and latest phpPgAdmin 3.5.5. Several months ago I had working setup, but since then my system have been patched with latest RPMs, and old PostgreSQL databases and setup files have been deleted and re-initialized from scratch.
And now I have a problem: whenever I am trying to connect to PostgreSQL 8 with phpPgAdmin, I get this error (even ith ¨extended login¨ option in phpPgAdmin set to false).
from PostgreSQL 8 log: LOG: database system is ready LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connection refused FATAL: Ident authentication failed for user "postgres"
adodb error message: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: Ident authentication failed for user "postgres" in /home/andrei/public_html/tools/phpPgAdmin/libraries/adodb/drivers/adodb-pos tgres64.inc.php on line 404
This is strange because by default PostgreSQL 8 seem to allow password-less connection from localhost. Additionally, what does it have to do with port 113? Config file specifies port 5432.
Additionally,I have changed
Anyone have an idea how to fix this?
Thanks in advance for any suggestion(s).
OK, I am not an expert in this area, but I think your situation is something like this ... Port 113 is for the "ident" service which is used to identify the id of a user. The "connection refused" message probably means that your ident service is not running. If you have postgresql configured to use "ident" as the user authentication method on something other than a "local" connection type (see below examples) -- it is probably trying to contact an ident server on port 113. Possible solutions: 1. Run an ident server. This *might* be the oident package on the SuSE CD/DVD. (I don't have it installed nor do I have anything listening to port 113.) 2. Change your pg_hba.conf file to use another authentication method or to use the "local" connection type. I use md5 authentication. To use md5 you will need to read up on how to give a password to a user. BUT: I have found that "ident" works for me when used with a connection type of "local". For example the following two work: local all postgres ident sameuser local mydb robert ident sameuser (The first seems to be required to even start the server. I don't currently use the 2nd but did so in the past.) My pg_hba.conf looks like this (simplified): # TYPE DATABASE USER CIDR-ADDRESS METHOD local all postgres ident sameuser host mydb robert 127.0.0.1/32 md5 host mydb robert 192.168.0.31/32 md5
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Saturday 2005-09-10 at 15:16 +0300, Andrei Verovski (aka MacGuru) wrote:
from PostgreSQL 8 log: LOG: database system is ready LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connection refused FATAL: Ident authentication failed for user "postgres" ... Additionally, what does it have to do with port 113? Config file specifies port 5432.
Because "ident" is a different service, standard, but seldom used, and probably not even installed. Why PostgreSQL tries to use it, I don't know, I'm not an expert in PostgreSQL. pidentd-...rpm: This package contains identd, which implements a RFC1413 identification server. Identd looks up specific TCP/IP connections and returns the user name and other information about the connection. oidentd-....rpm: Summary : Configurable IDENT server that supports NAT/IP masq Description : Oidentd is an ident (rfc1413 compliant) daemon that runs on Linux, Darwin, FreeBSD, OpenBSD, NetBSD and Solaris. oidentd can handle IP masqueraded/NAT connections on Linux, Darwin, FreeBSD (ipf only), OpenBSD and NetBSD. Oidentd has a flexible mechanism for specifying ident responses. Users can be granted permission to specify their own ident responses. Responses can be specified according to host and port pairs. - -- Cheers, Carlos Robinson -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFDIu6ItTMYHG2NR9URAnYwAJ4nx7bOYs/FTSEyrUbaVhg4MHeYZACggSMn kzlE8cPy6osjto1WrjHr5QY= =tSwy -----END PGP SIGNATURE-----
participants (5)
-
Andrei Verovski (aka MacGuru) -
Carlos E. R. -
Kaare Rasmussen -
Lawrence Bowie -
Robert Paulsen