Postgres Pro
Downloads
Home   >   mailing lists

Thread: pgaccess fails to start

pgaccess fails to start

From
Larry Anderson
Date:
Hi,
I just built and installed Postgre SQL 6.3 and pgaccess now fails to start.  I
am running Redhat 5.0, and have built all of Postgre from scratch.  I am
getting the following error with pgaccess 0.82.

Error in startup script: couldn't load file "libpgtcl.so":
/usr/local/pgsql/lib/libpq.so: undefined symbol: crypt
    while executing
"load libpgtcl.so"
    (procedure "main" line 3)
    invoked from within
"main $argc $argv"
    (file "pgaccess.tcl" line 4441)

I am able to connect fine with psql.  But any other tool seems to be failing.
Thanks for any help, I just started using pgaccess and am bummed that it no
longer works.

----------------------------------
E-Mail: Larry Anderson <anderson@endinfosys.com>
Date: 03-Mar-98
Time: 09:54:47

This message was sent by XFMail
----------------------------------

Re: [INTERFACES] pgaccess fails to start

From
Constantin Teodorescu
Date:
Larry Anderson wrote:
>
> Hi,
> I just built and installed Postgre SQL 6.3 and pgaccess now fails to start.  I
> am running Redhat 5.0, and have built all of Postgre from scratch.  I am
> getting the following error with pgaccess 0.82.
>
> Error in startup script: couldn't load file "libpgtcl.so":
> /usr/local/pgsql/lib/libpq.so: undefined symbol: crypt
>     while executing
> "load libpgtcl.so"
>     (procedure "main" line 3)
>     invoked from within

I think that you didn't compile /src/interfaces/libpgtcl

I have RedHat 4.2 installed and I have copied (manual) libpgtcl.so and
libpq.so into /lib. It might work.
It also wight be possible that under RedHat 5.0 some libraries have been
changed. I will try it on another RedHat 5.0 system

--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

Re: [INTERFACES] pgaccess fails to start

From
Goran Thyni
Date:
Larry Anderson wrote:
>
> Hi,
> I just built and installed Postgre SQL 6.3 and pgaccess now fails to start.  I
> am running Redhat 5.0, and have built all of Postgre from scratch.  I am
> getting the following error with pgaccess 0.82.
>
> Error in startup script: couldn't load file "libpgtcl.so":
> /usr/local/pgsql/lib/libpq.so: undefined symbol: crypt
>     while executing
> "load libpgtcl.so"
>     (procedure "main" line 3)
>     invoked from within
> "main $argc $argv"
>     (file "pgaccess.tcl" line 4441)
>
> I am able to connect fine with psql.  But any other tool seems to be failing.
> Thanks for any help, I just started using pgaccess and am bummed that it no
> longer works.
>

I relink libpq-1.1.so with -lcrypt and it worked.
Patch generated in src/interfaces/libpq below.
Don't know generic it is?

    regards,
--
---------------------------------------------
Göran Thyni, sysadm, JMS Bildbasen, Kiruna

------- snip -----------------------------

*** Makefile.in.orig    Tue Mar  3 17:48:25 1998
--- Makefile.in Tue Mar  3 17:48:58 1998
***************
*** 87,93 ****
        $(MAKE) -C $(SRCDIR)/backend fmgr.h

  $(shlib): $(OBJS)
!       $(LD) $(LDFLAGS_SL) -o $@ $(OBJS)
        ln -sf $@ libpq.so


--- 87,93 ----
        $(MAKE) -C $(SRCDIR)/backend fmgr.h

  $(shlib): $(OBJS)
!       $(LD) $(LDFLAGS_SL) -o $@ $(OBJS) -lcrypt
        ln -sf $@ libpq.so

Re: [INTERFACES] pgaccess fails to start

From
Larry Anderson
Date:
Wonderful this worked.  The patch wouldn't patch, but I saw where to add
it in the Makefile.  Thanks a lot.

On 03-Mar-98 Goran Thyni wrote:
> Larry Anderson wrote:
>>
>> Hi,
>> I just built and installed Postgre SQL 6.3 and pgaccess now fails to start.
>> I
>> am running Redhat 5.0, and have built all of Postgre from scratch.  I am
>> getting the following error with pgaccess 0.82.
>>
>> Error in startup script: couldn't load file "libpgtcl.so":
>> /usr/local/pgsql/lib/libpq.so: undefined symbol: crypt
>>     while executing
>> "load libpgtcl.so"
>>     (procedure "main" line 3)
>>     invoked from within
>> "main $argc $argv"
>>     (file "pgaccess.tcl" line 4441)
>>
>> I am able to connect fine with psql.  But any other tool seems to be
>> failing.
>> Thanks for any help, I just started using pgaccess and am bummed that it no
>> longer works.
>>
>
> I relink libpq-1.1.so with -lcrypt and it worked.
> Patch generated in src/interfaces/libpq below.
> Don't know generic it is?
>
>       regards,
> --
> ---------------------------------------------
> G�ran Thyni, sysadm, JMS Bildbasen, Kiruna
>
> ------- snip -----------------------------
>
> *** Makefile.in.orig    Tue Mar  3 17:48:25 1998
> --- Makefile.in Tue Mar  3 17:48:58 1998
> ***************
> *** 87,93 ****
>         $(MAKE) -C $(SRCDIR)/backend fmgr.h
>
>   $(shlib): $(OBJS)
> !       $(LD) $(LDFLAGS_SL) -o $@ $(OBJS)
>         ln -sf $@ libpq.so
>
>
> --- 87,93 ----
>         $(MAKE) -C $(SRCDIR)/backend fmgr.h
>
>   $(shlib): $(OBJS)
> !       $(LD) $(LDFLAGS_SL) -o $@ $(OBJS) -lcrypt
>         ln -sf $@ libpq.so

----------------------------------
E-Mail: Larry Anderson <anderson@endinfosys.com>
Date: 03-Mar-98
Time: 11:08:57

This message was sent by XFMail
----------------------------------