Thread: psql: relocation error: psql: undefined symbol: PQgetssl
Hi All,
I just installed postgresql 7.3.4 as an upgrade to 7.3.2 and all went
well untill I tried to log into a database that I successfully created.
Here are the steps in question:
bash-2.05b$ psql -h localhost -U postgres hardwoodthunder
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
psql: relocation error: psql: undefined symbol: PQgetssl
bash-2.05b$ \q
bash: q: command not found
bash-2.05b$
Does anyone have any suggestions?
thanks,
Phil
On Thu, 2004-01-22 at 16:13, Phil Campaigne wrote:
Phil-
I vaguely remember seeing a similar message when I inadvertently mismatched versions of psql and libpq. I think that the problem was psql resolving to the wrong libpq, but this is an old memory.
Some suggestions:
1) ldd psql
This will tell you which libraries are being dynamically linked. Make sure you think this what you expect.
2) check/unset your LD_LIBRARY_PATH variable.
3) I'm guessing you're on a linux box (guess per mail header), I also guess you might have an RPM-based system. If so, I'd further guess that you've recompiled postgresql AND have an rpm-installed version. rpm -e postgresql will remove the rpm version (can't remember if postgresql rpms are divided into subpackages... you might actually need postgresql-libs and postgresql-clients or some such names).
-Reece
psql: relocation error: psql: undefined symbol: PQgetssl
Phil-
I vaguely remember seeing a similar message when I inadvertently mismatched versions of psql and libpq. I think that the problem was psql resolving to the wrong libpq, but this is an old memory.
Some suggestions:
1) ldd psql
This will tell you which libraries are being dynamically linked. Make sure you think this what you expect.
2) check/unset your LD_LIBRARY_PATH variable.
3) I'm guessing you're on a linux box (guess per mail header), I also guess you might have an RPM-based system. If so, I'd further guess that you've recompiled postgresql AND have an rpm-installed version. rpm -e postgresql will remove the rpm version (can't remember if postgresql rpms are divided into subpackages... you might actually need postgresql-libs and postgresql-clients or some such names).
-Reece
-- Reece Hart, http://www.in-machina.com/~reece/, GPG:0x25EC91A0 |
Reece Hart <reece@in-machina.com> writes:
> On Thu, 2004-01-22 at 16:13, Phil Campaigne wrote:
>> psql: relocation error: psql: undefined symbol: PQgetssl
> I vaguely remember seeing a similar message when I inadvertently
> mismatched versions of psql and libpq. I think that the problem was psql
> resolving to the wrong libpq, but this is an old memory.
This undoubtedly indicates that you have an SSL-enabled psql that is
trying to use a non-SSL-enabled libpq.so. So (a) you were not
consistent about your configure options between 7.3.2 and 7.3.4
--- you might want to look and see if there were any other unintentional
changes; and (b) your ldconfig or LD_LIBRARY_PATH setup is finding the
"wrong" version of libpq.so. Reece's suggestion to use ldd will help
you figure out what's up with (b).
regards, tom lane
On Thu, 22 Jan 2004, Phil Campaigne wrote: > Hi All, > I just installed postgresql 7.3.4 as an upgrade to 7.3.2 and all went > well untill I tried to log into a database that I successfully created. > Here are the steps in question: > > bash-2.05b$ psql -h localhost -U postgres hardwoodthunder > Welcome to psql 7.3.2, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help on internal slash commands > \g or terminate with semicolon to execute query > \q to quit Notice that after upgrading to 7.3.4, you are using the psql that was installed with 7.3.2...
On Thu, 2004-01-22 at 18:00, Phil Campaigne wrote:
LD_LIBRARY_PATH is often not set except for users with specific needs. Having it set might lead to your symptoms, but having it unset is almost certainly fine.
That's ldd (not lld) and you certainly have it... it's part of glibc-common which in turn is required (in the rpm sense) by glibc. Example:
Tip: pg_config --configure will tell you how the current installation was configured. I recompile roughly like this:
$ cd postgresql-7.4.1
$ pg_config --configure
'--prefix=/apps/compbio/i686-linux-2.4/opt/postgresql-7.4' '--with-perl' '--with-python' '--with-tcl' '--with-CXX' '--with-openssl' '--with-pam' '--with-krb5=/usr/kerberos'
$ ./configure <copy/paste above line, changing --prefix directory>
$ make
$ make install
The --prefix bit is there because I like to keep several versions around.
-Reece
Thanks for your reply. My system has Red Hat 8.0 with postgresql installed from it as rpm. Then I tried to rpm -e and went to the postgresql-7.3.4.tar.gz distribution of source because the rpm wasn't yet available. I don't see the LD_LIBRARY_PATH listed using the "env" command, and I can't get the command "ldd psql" to be recognized. :+( Phil
LD_LIBRARY_PATH is often not set except for users with specific needs. Having it set might lead to your symptoms, but having it unset is almost certainly fine.
That's ldd (not lld) and you certainly have it... it's part of glibc-common which in turn is required (in the rpm sense) by glibc. Example:
whoville$ ldd `type -p psql` libpq.so.3 => /apps/compbio/i686-linux-2.4/opt/postgresql-7.4/lib/libpq.so.3 (0x40017000) libpam.so.0 => /lib/libpam.so.0 (0x40045000) libssl.so.2 => /lib/libssl.so.2 (0x4004d000) libcrypto.so.2 => /lib/libcrypto.so.2 (0x4007c000) (and so on)
Tip: pg_config --configure will tell you how the current installation was configured. I recompile roughly like this:
$ cd postgresql-7.4.1
$ pg_config --configure
'--prefix=/apps/compbio/i686-linux-2.4/opt/postgresql-7.4' '--with-perl' '--with-python' '--with-tcl' '--with-CXX' '--with-openssl' '--with-pam' '--with-krb5=/usr/kerberos'
$ ./configure <copy/paste above line, changing --prefix directory>
$ make
$ make install
The --prefix bit is there because I like to keep several versions around.
-Reece
-- Reece Hart, http://www.in-machina.com/~reece/, GPG:0x25EC91A0 0xD178AAF9 |