Strange Connection Problem….

Jerry LeVan wrote:

I recently modified one of my Fedora boxes by changing it's name and ip.

I also disabled the internal wifi ( connection speed was dropping to 1 mb/sec ) and
configured a USB wifi stick ( wow 270~300 mb/sec ).

As I checked out the refurbed box networking was ok and I was able to connect
to Postgresql using pgsql and some of my personal apps.

However I could not connect to Postgresql from my other machines.

I tried ssh from another machine to the modified machine and of course ssh complained about have a bad
key ( had renamed the
machine to a machine that I had given away recently and the key to the old machine
was still present.)

After I fixed the ssh problem I *was* able to connect to Postgresql on the refurbed
machine.

Do the postgresql libraries silently check to see if there is a ssh 'footprint' available
for a target machine and reject the connection attempt if they do not match?

PostgreSQL does nothing of that sort, but it uses OpenSSL for SSL.
So if OpenSSL (which is also used by OpenSSH) refuses the connection,
that will affect PostgreSQL.

Yours,
Laurenz Albe

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general