Re: pgacess: cant find libpgctl (no faq !) - Mailing list pgsql-general

On Tue, 2002-10-22 at 06:51, pilsl@goldfisch.at wrote:
> I compiled postgres 7.2.3 (--with-tcl) and newest pgacess (0.98.8.b2).
>
> While I got the libpgctl-libraries in the expected place and exported the
> PGLIB-variable I still get the error:
>
> Error: can not find libpgtcl.so shared library.
>
> # ls -l $PGLIB/libpgt*
> -rw-r--r--    1 root     root        31554 Oct 22 15:01 /opt/local/pgsql/lib/libpgtcl.a
> lrwxrwxrwx    1 root     root           15 Oct 22 15:01 /opt/local/pgsql/lib/libpgtcl.so -> libpgtcl.so.2.2
> lrwxrwxrwx    1 root     root           15 Oct 22 15:01 /opt/local/pgsql/lib/libpgtcl.so.2 -> libpgtcl.so.2.2
> -rwxr-xr-x    1 root     root        36151 Oct 22 15:01 /opt/local/pgsql/lib/libpgtcl.so.2.2
> # ls -l $PGLIB/libpq*
> -rw-r--r--    1 root     root        87764 Oct 22 15:01 /opt/local/pgsql/lib/libpq.a
> lrwxrwxrwx    1 root     root           12 Oct 22 15:01 /opt/local/pgsql/lib/libpq.so -> libpq.so.2.2
> lrwxrwxrwx    1 root     root           12 Oct 22 15:01 /opt/local/pgsql/lib/libpq.so.2 -> libpq.so.2.2
> -rwxr-xr-x    1 root     root        70037 Oct 17  2001 /opt/local/pgsql/lib/libpq.so.2.1
> -rwxr-xr-x    1 root     root        79911 Oct 22 15:01 /opt/local/pgsql/lib/libpq.so.2.2
>
>
> I also added the pglib-path to my ld.so.conf and I also copied the
> above libraries to my "normal" lib-path (/usr/local/lib)
>

I assume you ran ldconfig after changing ld.so.conf (although I don't
think this is the problem).

> I also played around with trailing slashes and that stuff.
>
>
> My tcl-version is a recent one (8.3) and I couldnt find any older
> non-beta-pgaccess versions.  Somewhere they say only 7.2.1 and 7.2.2
> is supported but I'm sure they just didnt know about 7.2.3 when
> writing it on the wiki-web at www.pgaccess.org ;)
>
It should work with 7.2.3. Part of the problem is that the error message
you got is too generic. It is printed if PGA can not load the shared lib
(which it assumes is because it can't be found).

Do you happen to have multiple versions of Tcl installed on your
computer? If I remember correctly, libpgtcl is not built with stubs
enabled, so you need to make sure you get the correct Tcl version. Other
then that, I am not sure what is going on.

Also, what are the permissions on the lib directory?

If you want, you can add some debugging statements, and send me the
output:

in pgaccess.tcl search for the line
  if {[catch {load ${libpgtclpath}[info sharedlibextension]}]} {

change this to:
  if {[catch {load ${libpgtclpath}[info sharedlibextension]} err]} {

and then add a line right after it:
  puts "ERROR MSG: $err"

Then send me the output after running pgaccess...


    --brett

p.s. Which Linux distro?

--
Brett Schwarz
brett_schwarz AT yahoo.com