solved !! Re: pgacess: cant find libpgctl (no faq !)

thnx a lot,

things were getting much clearer (and I finally solved the issue) when
I included your debugstatement.

---------
# pgaccess peter
...
ERROR MSG: couldn't load file "/usr/lib/libpgtcl.so": /usr/lib/libpgtcl.so: cannot open shared object file: No such file or directory
...
------

so pgaccess looks in /usr/lib which is the wrong location, even when I
definitely set the correct location in PGLIB. I then altered the
pgaccess.tcl-file to override the default-setting /usr/lib for PGLIB
and I still got the same error.

When looking at the script more closely it stroke me like lightening ;)

The script stores its values in ~/.pgaccess/pgaccess.env the first
time, including PGLIB. So if one calls the script the first time
without PGLIB set (which is what I did) then the defaultvalue /usr/lib
is set and stored in the env-file. Whatever one does later, the
script always reads it values from the env-file.

So I simply had to change the env-file and set PGLIB to the correct
location and now I finally have the piece of software that will make
my work so much easier, cause I can edit my databases without needing
MS access any more.

yeah !! thnx a lot for your help and for anyone who wrote on this
great tool.

peter :)

On Tue, Oct 22, 2002 at 07:49:33AM -0700, Brett Schwarz wrote:
> On Tue, 2002-10-22 at 06:51, pilsl(at)goldfisch(dot)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
>

--
mag. peter pilsl
IT-Consulting
tel: +43-699-1-3574035
fax: +43-699-4-3574035
pilsl(at)goldfisch(dot)at