Re: BUG #5168: cannot login to server - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5168: cannot login to server
Date
Msg-id 603c8f070911050725v743c5a49tb4399d65c6052335@mail.gmail.com
Whole thread Raw
In response to Re: BUG #5168: cannot login to server  (tomas@tuxteam.de)
Responses Re: BUG #5168: cannot login to server  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Thu, Nov 5, 2009 at 7:49 AM,  <tomas@tuxteam.de> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Thu, Nov 05, 2009 at 06:59:49AM +0000, Abhishek wrote:
>>
>> The following bug has been logged online:
>>
>> Bug reference: =A0 =A0 =A05168
>> Logged by: =A0 =A0 =A0 =A0 =A0Abhishek
>> Email address: =A0 =A0 =A0abhishek.sawant111@gmail.com
>> PostgreSQL version: 8.4
>> Operating system: =A0 Linux Fedora 8
>> Description: =A0 =A0 =A0 =A0cannot login to server
>> Details:
>>
>> server[localhost]:localhost enter
>> Databse[postgres]:global enter
>> Port [5432]: 5432 enter
>> User [postgres]:postgres enter
>>
>> After enter it showing me error:-
>>
>> /opt/PostgreSQL/8.4/bin/psql: error while loading shared
>> libraries:libssl.so.4:
>> cannot open shared object file: No such file or directory
>
> Abhishek,
>
> this doesn't look like a PostgreSQL bug -- rather like a botched
> installation.
>
> Moreover, it doesn't help to file a non-bug twice, creating two bug
> numbers ;-)
>
> That said, I'd recommend to find out which package of your distribution
> carries the missing library (libssl.so.4) and to (re-) install this
> package. As a first attempt, a search in rpmfind
>
> =A0<http://search.rpmseek.com/search.html>
>
> for libssl seems to lead to the package "openssl". But I'd recommend you
> try yourself (I'm by no means a Fedora expert!).

That's not a standard location for PostgreSQL under Fedora.  It could
be some other RPM repository (which?) but if so the dependencies are
broken, since otherwise it would've insisted on having the matching
SSL libraries installed too.  My suspicion is that this is a home-brew
compile, but in any case the broad outline of the picture is clear:
the SSL libraries are not installed where PostgreSQL can find them.

...Robert

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5165: Poor performance with Left-join where right side does not exist
Next
From: Robert Haas
Date:
Subject: Re: BUG #5166: readdir() failure on Mac OS-X is HFS "feature"