From: Steve Crawford <scrawford@pinpointresearch.com>
To: Rickard, David <drickard1967@library.ucla.edu>
Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Re: Cannot Connect To Db From Local Server
Date: Wed, 18 Apr 2012 15:29:42 -0700
Message-ID: <4F8F4056.8070701@pinpointresearch.com> (raw)
In-Reply-To: <06981C41E5501D42827699CB54B3500615F298B5D2@EM12.ad.ucla.edu>
References: <06981C41E5501D42827699CB54B3500615F298B5D2@EM12.ad.ucla.edu>
On 04/18/2012 03:12 PM, Rickard, David wrote:
>
> We have a legacy PostgresSQL 7.3.4 db on Solaris
>
That's not legacy, that's antique. I'm basing my commands on recent
versions - if the options differed back then you may have to adjust.
> which has recently (as in last 24 hours or so) begun refusing TCP/IP
> (JDBC) connections from the same server the db is on.
>
> The db is up and running---psql connects;
>
When you say psql connects do you mean that when you run psql on the
same Solaris machine as the server it connects? And if so, what
parameters are you using? Will it connect if you explicitly specify a
network address (psql -h 127.0.0.1 ...) to make sure it isn't using a
socket connection?
> I can access the db via pgAdmin III from a PC; I can connect via JDBC
> from a PC.
>
> However: any JDBC call (whether command-line app or web app) running
> on the db server fails with this message:
>
> org.postgresql.util.PSQLException: Connection refused. Check that the
> hostname and port are correct and that the postmaster is accepting
> TCP/IP connections.
>
> And the postmaster log contains the following message:
>
> FATAL: unsupported frontend protocol
>
> Mind you... I am using the same JDBC jar (pg74.216.jdbc2.jar) and
> connection URL in code on my PC and the Solaris server.
>
> Our pg_hba.conf file contains the following lines:
>
> local all all
> password
>
> host all all 127.0.0.1 255.255.255.255
> password
>
> host all all 0.0.0.0 0.0.0.0
> password
>
> And "tcpip_socket = true" is enabled in postgresql.conf.
>
> Any ideas?
>
>
What changed no matter how trivial? Was the machine rebooted or services
restarted? Any patches installed - automatically or otherwise? Any
config changes? Any possibility the client side has started using
something other than 127.0.0.1 (local addresses can be all the way to
127.255.255.255 and I've seen this when a client, for some reason, uses
127.0.0.2 for its address)?
The "unsupported frontend protocol" leads me to believe that the network
connection is succeeding but the client-server conversation thereafter
is incorrect or absent.
Cheers,
Steve
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scrawford@pinpointresearch.com, drickard1967@library.ucla.edu
Subject: Re: Cannot Connect To Db From Local Server
In-Reply-To: <4F8F4056.8070701@pinpointresearch.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox