Thread: Re: [INTERFACES] Pgaccess & Postgresql 6.3

At 11:16 PM 3/16/98 +0000, you wrote:
>
>I found a fix. What worked for me is:
>edit the Makefile in pgsql/src/interfaces/libpq:
>
>*** 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
>
>The line starting with ! needs to have -lcrypt on the end.
>
>Re-compile this file, and then drop it into your main lib dir. It done the
>trick for me.
>
>I got the info from the postgress {INTERFACES} mailing archive.
>Date -Tues 03 Mar 1998, Goran Thyni <goran@bildbasen.se>
>
>I hope this helps you.
>
This helps me, thanks.

Now it works!

Bye!

~~~~~~~~~~~[Carlo Vitolo]~~~~~~~~~~~~~
EMAIL: carlo@ilr.interbusiness.it
HOME: http://home.ilrspa.com/~carlo/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

On Tue, Mar 17, 1998 at 01:42:59PM +0100, Carlo Vitolo wrote:
> >The line starting with ! needs to have -lcrypt on the end.
> >
> >Re-compile this file, and then drop it into your main lib dir. It done the
> >trick for me.
> >
> >I got the info from the postgress {INTERFACES} mailing archive.
> >Date -Tues 03 Mar 1998, Goran Thyni <goran@bildbasen.se>
> >
> >I hope this helps you.
> >
> This helps me, thanks.

Hi !

I still have the problem after rebuilding libpq with the crypt
library. Now the error is:

Error in startup script: couldn't find procedure Pq_Init
    while executing
"load /usr/local/pgsql/lib/libpq.so"
    (procedure "main" line 3)
    invoked from within
"main $argc $argv"
    (file "/usr/local/bin/pgaccess" line 4507)

BTW, additionally I had to load libpq explicitely before libpgtcl ...

--- pgaccess.tcl.orig   Sat Mar 14 13:11:38 1998
+++ pgaccess.tcl        Sun Mar 22 17:04:30 1998
@@ -1,4 +1,4 @@
-#!/usr/bin/wish
+#! !!LOCALBASE!!/bin/wish8.0
 #############################################################################
 # Visual Tcl v1.11 Project
 #
@@ -2539,7 +2539,8 @@

 proc {main} {argc argv} {
 global pref newdbname newpport newhost dbc
-load libpgtcl.so
+load !!LOCALBASE!!/pgsql/lib/libpq.so
+load !!LOCALBASE!!/pgsql/lib/libpgtcl.so
 catch {draw_tabs}
 load_pref
 if {$pref(autoload) && ($pref(lastdb)!="")} {


--
Andreas Klemm   http://www.FreeBSD.ORG/~andreas
powered by ,,symmetric multiprocessor FreeBSD''

Andreas Klemm <andreas@klemm.gtn.com> writes:

> BTW, additionally I had to load libpq explicitely before libpgtcl ...

I had a similar problem with libpq and libpgtcl under FreeBSD, but I
solved it differently.

I noticed that Makefile in the interfaces/libpgtcl directory in the
case of FreeBSD doesn't link libpgtcl against libpq. Hence I wrote this
patch. If your libpq is installed not in the /usr/local/libpq/lib, change
the patch accordingly.


*** Makefile.old    Mon Mar 23 10:58:16 1998
--- Makefile    Fri Mar 20 14:03:49 1998
***************
*** 79,85 ****
      $(RANLIB) libpgtcl.a

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

  .PHONY: beforeinstall-headers install-headers
--- 79,85 ----
      $(RANLIB) libpgtcl.a

  $(shlib): $(OBJS)
!     $(LD) $(LDFLAGS_SL) -o $@ $(OBJS) -L /usr/local/pgsql/lib -lpq
      ln -sf $@ libpgtcl.so

  .PHONY: beforeinstall-headers install-headers

--
Aleksey Demakov
avd@avd.garsib.ru