pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedPgAccess Problem
5+ messages / 5 participants
[nested] [flat]
* PgAccess Problem
@ 1998-10-28 19:21 Matthew <matt@ctlno.com>
0 siblings, 1 reply; 5+ messages in thread
From: Matthew @ 1998-10-28 19:21 UTC (permalink / raw)
To: pgsql-interfaces
Hello. I am trying to get PgAccess to work on my system and I'm having
a few problems. Here is what I have done.
I have installed RedHat 5.0 on my P75, I did not install PostgreSQL from
the RedHat CD
I downloaded the lates postgresql source, compiled and installed.
postgresql now works fine. I can connect to it with psql.
I downloaded libpgtcl.so and libpq.so and copied them to the /usr/lib
directory
I exploded the pgaccess files into ~pgaccess
I then ran pgaccess.tcl and this was the output
Error in startup script: couldn't load file "libpgtcl.so: undefined
symbol: crypt
while executing
"load libpgtcl.so"
(procedure "main" line 3)
invoked from within
"main $argc $argv"
(file "./pgaccess.tcl" line 4682)
Please help, do I to define crypt or something?
Thanks in advance,
Matt O'Connor
^ permalink raw reply [nested|flat] 5+ messages in thread
* pgaccess problem
@ 1998-10-28 19:51 peter.garner@toward.com
0 siblings, 0 replies; 5+ messages in thread
From: peter.garner@toward.com @ 1998-10-28 19:51 UTC (permalink / raw)
To: pgsql-interfaces
Hi Matt!
>Error in startup script: couldn't load file "libpgtcl.so:
>undefined symbol: crypt
I am not familiar with tcl and pgaccess, but in general to link
with C/C++ the library "libcrypt.so" must be linked into the
application. The libraries are in /usr/lib on my Redhat 5.1, I
would assume they are also present in RH5.0. I hope this helps
Peace
Peter
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] PgAccess Problem
@ 1998-10-28 20:02 Gus Nwosu <anwosu@houston.geoquest.slb.com>
parent: Matthew <matt@ctlno.com>
0 siblings, 0 replies; 5+ messages in thread
From: Gus Nwosu @ 1998-10-28 20:02 UTC (permalink / raw)
To: Matthew <matt@ctlno.com>; +Cc: pgsql-interfaces
Matthew,
I did the same but I made a few changes:
1. Imposed the linux_elf template in the configure command.
2. Edit the src/interfaces/lipgtcl/Makefile to include -L/usr/lib -lcrypt at
the line that defines LIBPQ ie
LIBPQ= -L(SRCDIR)/interfaces/libpq -lpq -L/usr/lib -lcrypt
3. This compiled the shared library libpgtcl.so.1 with the crypt object
resolved.
I had one problem which was apparently caused by the -O2 option of gcc. I
just
went back and repeated the compile (ie gcc command) with -O instead and
everything seems to be fine.
Another option would be to go into src/Makefile.global and edit the -O2 to -O
and compile.
I hope this is of some help.
Rgds
Gus
At 01:21 PM 10/28/98 -0600, Matthew wrote:
>Hello. I am trying to get PgAccess to work on my system and I'm having
>a few problems. Here is what I have done.
>
>I have installed RedHat 5.0 on my P75, I did not install PostgreSQL from
>the RedHat CD
>I downloaded the lates postgresql source, compiled and installed.
>postgresql now works fine. I can connect to it with psql.
>I downloaded libpgtcl.so and libpq.so and copied them to the /usr/lib
>directory
>I exploded the pgaccess files into ~pgaccess
>I then ran pgaccess.tcl and this was the output
>
>Error in startup script: couldn't load file "libpgtcl.so: undefined
>symbol: crypt
> while executing
>"load libpgtcl.so"
> (procedure "main" line 3)
> invoked from within
>"main $argc $argv"
> (file "./pgaccess.tcl" line 4682)
>
>Please help, do I to define crypt or something?
>
>Thanks in advance,
>
>Matt O'Connor
>
=============================================================
Gus
Nwosu
Tel: 1-(713)350-4301
GeoRise Training Manager
Fax: 1-(713)350-4103
5444 Westheimer Road
Houston. Tx 77056 email:
anwosu@houston.geoquest.slb.com
=============================================================
^ permalink raw reply [nested|flat] 5+ messages in thread
* pgaccess problem....
@ 2003-08-26 20:35 Alejandro Vargas M. <avargas@sgocostarica.com>
0 siblings, 1 reply; 5+ messages in thread
From: Alejandro Vargas M. @ 2003-08-26 20:35 UTC (permalink / raw)
To: pgsql-interfaces
I have problems with pgaccess.
I configured the postgresql.conf with tcpip_socket = true and port =
5432.
After that I configured pg_hba.conf
host all all 127.0.0.1 255.255.255.255 trust
I restart the postgresql service and started perfect.
I open the connection, then It opens very well at localhost, opens the
database, but, when I try to see the tables, it's like their not exists.
I don't know, what's wrong. I can see them at psql, but in pgaccess, I
can't.
Please Help Me.
Thank you.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgaccess problem....
@ 2003-08-27 12:38 Bruno Wolff III <bruno@wolff.to>
parent: Alejandro Vargas M. <avargas@sgocostarica.com>
0 siblings, 0 replies; 5+ messages in thread
From: Bruno Wolff III @ 2003-08-27 12:38 UTC (permalink / raw)
To: Alejandro Vargas M. <avargas@sgocostarica.com>; +Cc: pgsql-interfaces
On Tue, Aug 26, 2003 at 16:35:31 -0400,
"Alejandro Vargas M." <avargas@sgocostarica.com> wrote:
> I have problems with pgaccess.
>
> I configured the postgresql.conf with tcpip_socket = true and port =
> 5432.
>
> After that I configured pg_hba.conf
>
> host all all 127.0.0.1 255.255.255.255 trust
>
> I restart the postgresql service and started perfect.
>
> I open the connection, then It opens very well at localhost, opens the
> database, but, when I try to see the tables, it's like their not exists.
> I don't know, what's wrong. I can see them at psql, but in pgaccess, I
> can't.
Are you running pgaccess from the local host?
Are you connecting to the loopback address (127.0.0.1) and not an external IP?
psql probably is conecting using domain sockets instead of using a network
connection, which could explain why it works and pgaccess doesn't.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2003-08-27 12:38 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-10-28 19:21 PgAccess Problem Matthew <matt@ctlno.com>
1998-10-28 20:02 ` Gus Nwosu <anwosu@houston.geoquest.slb.com>
1998-10-28 19:51 pgaccess problem peter.garner@toward.com
2003-08-26 20:35 pgaccess problem.... Alejandro Vargas M. <avargas@sgocostarica.com>
2003-08-27 12:38 ` Re: pgaccess problem.... Bruno Wolff III <bruno@wolff.to>
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