pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedPgaccess & Postgresql 6.3
8+ messages / 7 participants
[nested] [flat]
* Pgaccess & Postgresql 6.3
@ 1998-03-10 13:38 Carlo Vitolo <carlo@ilrspa.com>
1998-03-11 10:38 ` Re: [INTERFACES] Pgaccess & Postgresql 6.3 Teodorescu Constantin <teo@flex.flex.ro>
0 siblings, 1 reply; 8+ messages in thread
From: Carlo Vitolo @ 1998-03-10 13:38 UTC (permalink / raw)
To: pgsql-interfaces
Pgaccess don't work anymore with this exit mex:
Error in startup script: couldn't load file "libpgtcl.so.1":
/usr/lib/libpq.so.1: undefined symbol: crypt
while executing
"load libpgtcl.so.1"
(procedure "main" line 3)
invoked from within
"main $argc $argv"
(file "/usr/bin/pgaccess" line 4441)
Bye!
~~~~~~~~~~~[Carlo Vitolo]~~~~~~~~~~~~~
EMAIL: carlo@ilr.interbusiness.it
HOME: http://home.ilrspa.com/~carlo/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] Pgaccess & Postgresql 6.3
1998-03-10 13:38 Pgaccess & Postgresql 6.3 Carlo Vitolo <carlo@ilrspa.com>
@ 1998-03-11 10:38 ` Teodorescu Constantin <teo@flex.flex.ro>
0 siblings, 0 replies; 8+ messages in thread
From: Teodorescu Constantin @ 1998-03-11 10:38 UTC (permalink / raw)
To: Carlo Vitolo <carlo@ilrspa.com>; +Cc: pgsql-interfaces
PostgreSQL 6.3 MUST be entirely recompiled on your platform, including ***
libpgtcl.so *** that has to be recompiled and installed.
libpgtcl.so and libpq.so must be copied then in your lib directory (/lib
probably).
It always work!
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA
On Tue, 10 Mar 1998, Carlo Vitolo wrote:
> Pgaccess don't work anymore with this exit mex:
>
> Error in startup script: couldn't load file "libpgtcl.so.1":
> /usr/lib/libpq.so.1: undefined symbol: crypt
> while executing
> "load libpgtcl.so.1"
> (procedure "main" line 3)
> invoked from within
> "main $argc $argv"
> (file "/usr/bin/pgaccess" line 4441)
>
> Bye!
> ~~~~~~~~~~~[Carlo Vitolo]~~~~~~~~~~~~~
> EMAIL: carlo@ilr.interbusiness.it
> HOME: http://home.ilrspa.com/~carlo/
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] Pgaccess & Postgresql 6.3
@ 1998-03-16 21:20 Carlo Vitolo <carlo@ilr.it>
1998-03-17 02:57 ` Re: [INTERFACES] Pgaccess & Postgresql 6.3 Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-03-17 08:10 ` Re: [INTERFACES] Pgaccess & Postgresql 6.3 Constantin Teodorescu <teo@flex.ro>
0 siblings, 2 replies; 8+ messages in thread
From: Carlo Vitolo @ 1998-03-16 21:20 UTC (permalink / raw)
To: Steve Lawson <eis@globalnet.co.uk>; +Cc: pgsql-interfaces
At 07:45 PM 3/15/98 +0000, you wrote:
>Carlo,
>
>Did you get any helpful replies to this posting, or have you solved the
>problem yourself yet?
>After using pgaccess with postgres 6.2 successfully, I just cannot get
>pgaccess to working with postgres 6.3.
>I have re-compiled postgres 6.3, libpgtcl & libpq, installed (replaced the
>libs in my usr/lib) and I still get the same error as yourself. I am using
>RH5.0 & tcl 8.0. pgaccess 0.84 & postgres 0.63.
>
>If you have had any joy, please let me know..
>
No, Pgaccess(any version) & postgresql 6.3 doesn't work for me.
I still get the same error.
Sorry!
~~~~~~~~~~~[Carlo Vitolo]~~~~~~~~~~~~~
EMAIL: carlo@ilr.interbusiness.it
HOME: http://home.ilrspa.com/~carlo/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] Pgaccess & Postgresql 6.3
1998-03-16 21:20 Re: [INTERFACES] Pgaccess & Postgresql 6.3 Carlo Vitolo <carlo@ilr.it>
@ 1998-03-17 02:57 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1 sibling, 0 replies; 8+ messages in thread
From: Thomas G. Lockhart @ 1998-03-17 02:57 UTC (permalink / raw)
To: Carlo Vitolo <carlo@ilr.it>; +Cc: Steve Lawson <eis@globalnet.co.uk>; pgsql-interfaces
> >After using pgaccess with postgres 6.2 successfully, I just cannot
> >get pgaccess to working with postgres 6.3.
> No, Pgaccess(any version) & postgresql 6.3 doesn't work for me.
> I still get the same error.
I recently installed pgaccess and it seems to work, though I'm not
certain what error you are seeing. Same versions for everything except
I'm running RH4.2.
Are you starting the postmaster with the "-i" option? You'll need to...
- Tom
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] Pgaccess & Postgresql 6.3
1998-03-16 21:20 Re: [INTERFACES] Pgaccess & Postgresql 6.3 Carlo Vitolo <carlo@ilr.it>
@ 1998-03-17 08:10 ` Constantin Teodorescu <teo@flex.ro>
1 sibling, 0 replies; 8+ messages in thread
From: Constantin Teodorescu @ 1998-03-17 08:10 UTC (permalink / raw)
To: Carlo Vitolo <carlo@ilr.it>; +Cc: pgsql-interfaces
Carlo Vitolo wrote:
>
> At 07:45 PM 3/15/98 +0000, you wrote:
> >Carlo,
> >
> >Did you get any helpful replies to this posting, or have you solved the
> >problem yourself yet?
> >After using pgaccess with postgres 6.2 successfully, I just cannot get
> >pgaccess to working with postgres 6.3.
> >I have re-compiled postgres 6.3, libpgtcl & libpq, installed (replaced the
> >libs in my usr/lib) and I still get the same error as yourself. I am using
> >RH5.0 & tcl 8.0. pgaccess 0.84 & postgres 0.63.
> >
> >If you have had any joy, please let me know..
> >
>
> No, Pgaccess(any version) & postgresql 6.3 doesn't work for me.
> I still get the same error.
I have installed PostgreSQL 6.3, on a RedHat 5.0 with Tcl/Tk 8.0 and
PgAccess 0.84 !!!
I didn't encountered any problem!
Please follow exactly : the following steps.
1. Remove *ANY* file, program, library related to PostgreSQL 6.2.1 from
anywhere, especially libpgtcl.so.* libpq.so.*
2. Untar the last PostgreSQL 6.3 distribution
3. Compile all, compile also src/interfaces/libpgtcl and
/src/interfaces/libpq
4. Install postgres and make it work
5. Copy libpgtcl.so.? in /lib as libpgtcl.so (without any other numeric
extension)
6. Copy libpq.so.? in /lib as libpq.so (also, without any other numeric
extension)
7. Install PgAccess and run it with "wish -f pgaccess.tcl"
Please report me exactly what it happens!
--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] Pgaccess & Postgresql 6.3
@ 1998-03-17 12:42 Carlo Vitolo <carlo@ilr.it>
1998-03-22 16:07 ` Re: [INTERFACES] Pgaccess & Postgresql 6.3 Andreas Klemm <andreas@klemm.gtn.com>
0 siblings, 1 reply; 8+ messages in thread
From: Carlo Vitolo @ 1998-03-17 12:42 UTC (permalink / raw)
To: pgsql-interfaces
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/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] Pgaccess & Postgresql 6.3
1998-03-17 12:42 Re: [INTERFACES] Pgaccess & Postgresql 6.3 Carlo Vitolo <carlo@ilr.it>
@ 1998-03-22 16:07 ` Andreas Klemm <andreas@klemm.gtn.com>
1998-03-23 05:41 ` Re: [INTERFACES] Pgaccess & Postgresql 6.3 Aleksey Demakov <avd@avd.garsib.ru>
0 siblings, 1 reply; 8+ messages in thread
From: Andreas Klemm @ 1998-03-22 16:07 UTC (permalink / raw)
To: Carlo Vitolo <carlo@ilr.it>; pgsql-interfaces
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 ...
inline patch 1: pgaccess.tcl Sun Mar 22 17:04:30 1998 (+3/-2 lines) download inline-1.patch
--- 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)!="")} {
* Re: [INTERFACES] Pgaccess & Postgresql 6.3
1998-03-17 12:42 Re: [INTERFACES] Pgaccess & Postgresql 6.3 Carlo Vitolo <carlo@ilr.it>
1998-03-22 16:07 ` Re: [INTERFACES] Pgaccess & Postgresql 6.3 Andreas Klemm <andreas@klemm.gtn.com>
@ 1998-03-23 05:41 ` Aleksey Demakov <avd@avd.garsib.ru>
0 siblings, 0 replies; 8+ messages in thread
From: Aleksey Demakov @ 1998-03-23 05:41 UTC (permalink / raw)
To: pgsql-interfaces
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.
inline patch 1: Makefile (+1/-1 lines) download inline-1.patch
*** 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
end of thread, other threads:[~1998-03-23 05:41 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-03-10 13:38 Pgaccess & Postgresql 6.3 Carlo Vitolo <carlo@ilrspa.com>
1998-03-11 10:38 ` Teodorescu Constantin <teo@flex.flex.ro>
1998-03-16 21:20 Re: [INTERFACES] Pgaccess & Postgresql 6.3 Carlo Vitolo <carlo@ilr.it>
1998-03-17 02:57 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-03-17 08:10 ` Constantin Teodorescu <teo@flex.ro>
1998-03-17 12:42 Re: [INTERFACES] Pgaccess & Postgresql 6.3 Carlo Vitolo <carlo@ilr.it>
1998-03-22 16:07 ` Andreas Klemm <andreas@klemm.gtn.com>
1998-03-23 05:41 ` Aleksey Demakov <avd@avd.garsib.ru>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox