Thread: phpPgAdmin, cannot connect to server
Okay, I read the FAQ. I looked at my postgresql.conf file and didn't see "#tcpip_socket" set, either to true or false. I'm also attaching the tail of the log, even though I could connect to the database using the command line client. 2006-11-18 19:27:22 MST jmeyer jmeyer LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connectionrefused 2006-11-18 19:27:22 MST jmeyer jmeyer FATAL: Ident authentication failed for user "jmeyer" 2006-11-18 19:27:23 MST jmeyer jmeyer LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connectionrefused 2006-11-18 19:27:23 MST jmeyer jmeyer FATAL: Ident authentication failed for user "jmeyer" 2006-11-18 19:27:24 MST jmeyer jmeyer LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connectionrefused 2006-11-18 19:27:24 MST jmeyer jmeyer FATAL: Ident authentication failed for user "jmeyer" 2006-11-18 19:27:24 MST jmeyer jmeyer LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connectionrefused 2006-11-18 19:27:24 MST jmeyer jmeyer FATAL: Ident authentication failed for user "jmeyer" 2006-11-18 19:27:25 MST jmeyer jmeyer LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connectionrefused 2006-11-18 19:27:25 MST jmeyer jmeyer FATAL: Ident authentication failed for user "jmeyer"
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 And while we're on it, setting that variable caused the PostgreSQL server to lock up Yast when I was restarting it that way. John Meyer wrote: > Okay, I read the FAQ. > > I looked at my postgresql.conf file and didn't see "#tcpip_socket" set, > either to true or false. > > I'm also attaching the tail of the log, even though I could connect to > the database using the command line client. > > > > ------------------------------------------------------------------------ > > 2006-11-18 19:27:22 MST jmeyer jmeyer LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connectionrefused > 2006-11-18 19:27:22 MST jmeyer jmeyer FATAL: Ident authentication failed for user "jmeyer" > 2006-11-18 19:27:23 MST jmeyer jmeyer LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connectionrefused > 2006-11-18 19:27:23 MST jmeyer jmeyer FATAL: Ident authentication failed for user "jmeyer" > 2006-11-18 19:27:24 MST jmeyer jmeyer LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connectionrefused > 2006-11-18 19:27:24 MST jmeyer jmeyer FATAL: Ident authentication failed for user "jmeyer" > 2006-11-18 19:27:24 MST jmeyer jmeyer LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connectionrefused > 2006-11-18 19:27:24 MST jmeyer jmeyer FATAL: Ident authentication failed for user "jmeyer" > 2006-11-18 19:27:25 MST jmeyer jmeyer LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connectionrefused > 2006-11-18 19:27:25 MST jmeyer jmeyer FATAL: Ident authentication failed for user "jmeyer" > > > ------------------------------------------------------------------------ > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFFX8T1bHd4gglFmoARAlWwAJwMBnoJeILL81EbhfUIKbV5tWQO9gCeOCbX HvCMTB+zDDl4cEt/ziVbn80= =A3fW -----END PGP SIGNATURE-----
John Meyer wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > And while we're on it, setting that variable caused the PostgreSQL > server to lock up Yast when I was restarting it that way. File a bug with the Yast developers. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
On Saturday 18 November 2006 21:44, John Meyer wrote:
> John Meyer wrote:
> > Okay, I read the FAQ.
> >
> > I looked at my postgresql.conf file and didn't see "#tcpip_socket" set,
> > either to true or false.
> >
> > I'm also attaching the tail of the log, even though I could connect to
> > the database using the command line client.
> > ------------------------------------------------------------------------
> > 2006-11-18 19:27:22 MST jmeyer jmeyer LOG: could not connect to Ident
> > server at address "127.0.0.1", port 113: Connection refused 2006-11-18
> > 19:27:22 MST jmeyer jmeyer FATAL: Ident authentication failed for user
<snip>
Most likely your problem is that your webserver isnt running as user jmeyer
which your current ident config would require. You can either reconfigure
the web server, reconfigure your ident setup, or change your authentication
method in postgresql. HTH.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
Imho changing the authentication method to somewhat else than ident would be the best solution in my eyes. Running the webserver under a common user isn't the best solution i think. Greetings, Matthias > -----Original Message----- > From: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Robert Treat > Sent: Monday, November 20, 2006 6:59 AM > To: pgsql-general@postgresql.org > Cc: John Meyer > Subject: Re: [GENERAL] phpPgAdmin, cannot connect to server > > > > 2006-11-18 19:27:22 MST jmeyer jmeyer LOG: could not > connect to Ident > > > server at address "127.0.0.1", port 113: Connection > refused 2006-11-18 > > > 19:27:22 MST jmeyer jmeyer FATAL: Ident authentication > failed for user > <snip> > > Most likely your problem is that your webserver isnt running > as user jmeyer > which your current ident config would require. You can > either reconfigure > the web server, reconfigure your ident setup, or change your > authentication > method in postgresql. HTH.