Thread: libpgtcl.so?
good day too guru. pgaccess has lot of dependencies, actually nnot so much :) i already install tcl/tk in my system rh7.3 and the next step is the libpgtcl package [libpgtcl.so] which i found from postgresqlinstallation source. my directory: /usr/src/redhat/SOURCES/postgresql-7.3.2/src/interfaces/libpgtcl and then i found this instraction at postgresql mailing list, tryingg to look for possible solution for other installationdependencies. but i really can understand what has to do with it. i need to post iit here so anybbody can helpme.. -- Rather than applying that patch, it would probably be easier creating a 'Makefile.custom' file in the postgresql-6.3.2/src (which get included by Makefile.global, and thus every Makefile in the tree). Set LINUX_ELF=true in Makefile.custom, and you won't have to patch all of the shared library makefiles. You can also specify CUSTOM_CC and CUSTOM_COPT in Makefile.custom to specify your compiler and compile flags, respectively. As for libpgtcl.so and unresolved symbols, I run a Redhat 5.0 system where the crypt() function lives in its own library (libcrypt) and not libc. libpgtcl.so is linked to libpq.so, which is statically linked. crypt() is probably used by libpq.so for passwords, etc, but since libpq.so is *not* linked with libcrypt, you must link libcrypt.so as well libpq.so into your app. The Tk shell, wish8.0, is *not* linked to libcrypt.so. Thus, when pgaccess.tcl loads the libpgtcl.so library, the system can't resolve the calls to crypt(). One solution is to run pgaccess.tcl with pgtksh, which *is* linked with libcrypt.so. Just change the first line of pgaccess.tcl to #!/usr/local/pgsql/bin/pgtksh (or where ever you installed postgresql). You could also link libpgtcl.so manually, adding the '-lcrypt' crypt option, which would let you run pgaccess.tcl and any other postgresql tcl scripts with wish and tclsh. ==================end=== please help how to edit my Makefile.custom at /usr/src/redhat/SOURCES/postgresql-7.3.2/src the next thing was the libpgtcl.. where should i put it and or what should i make a link to it? ..and what really next thing to do. all i want is to use pgacces[gui] to administer my postgres database.. any help wwill appreciate very much. tnx.. vic -- _____________________________________________________________ Web-based SMS services available at http://www.operamail.com. From your mailbox to local or overseas cell phones. Powered by Outblaze
Is pgaccess not running for you? Have you tried the newest snapshot? You don't necessarily need libpgtcl right now, but if you really want it, then you should be able to compile it from the makefile supplied in the libpgtcl directory. I would be surprised if RedHat didn't already come with libpgtcl installed. Have you checked (sorry, I don't use RedHat). What other dependencies are you having problems with? BTW, there is a dedicated pgaccess list, if you would like to use that. Go to www.pgaccess.org --brett --- Vickriz Buenaventuura <vickr1z@operamail.com> wrote: > good day too guru. > pgaccess has lot of dependencies, actually nnot so > much :) > i already install tcl/tk in my system rh7.3 and the > next step is the libpgtcl package [libpgtcl.so] > which i found from postgresql installation source. > my directory: > /usr/src/redhat/SOURCES/postgresql-7.3.2/src/interfaces/libpgtcl > > and then i found this instraction at postgresql > mailing list, tryingg to look for possible solution > for other installation dependencies. but i really > can understand what has to do with it. i need to > post iit here so anybbody can help me.. > -- > Rather than applying that patch, it would probably > be easier creating a > 'Makefile.custom' file in the postgresql-6.3.2/src > (which get included > by Makefile.global, and thus every Makefile in the > tree). Set > LINUX_ELF=true in Makefile.custom, and you won't > have to patch all of > the shared library makefiles. You can also specify > CUSTOM_CC and > CUSTOM_COPT in Makefile.custom to specify your > compiler and compile > flags, respectively. > > As for libpgtcl.so and unresolved symbols, I run a > Redhat 5.0 system > where the crypt() function lives in its own library > (libcrypt) and not > libc. libpgtcl.so is linked to libpq.so, which is > statically linked. > crypt() is probably used by libpq.so for passwords, > etc, but since > libpq.so is *not* linked with libcrypt, you must > link libcrypt.so as > well libpq.so into your app. The Tk shell, wish8.0, > is *not* linked to > libcrypt.so. Thus, when pgaccess.tcl loads the > libpgtcl.so library, the > system can't resolve the calls to crypt(). One > solution is to run > pgaccess.tcl with pgtksh, which *is* linked with > libcrypt.so. Just > change the first line of pgaccess.tcl to > #!/usr/local/pgsql/bin/pgtksh > (or where ever you installed postgresql). You could > also link > libpgtcl.so manually, adding the '-lcrypt' crypt > option, which would let > you run pgaccess.tcl and any other postgresql tcl > scripts with wish and > tclsh. > ==================end=== > > please help how to edit my Makefile.custom at > /usr/src/redhat/SOURCES/postgresql-7.3.2/src > the next thing was the libpgtcl.. where should i put > it and or what should i make a link to it? > ..and what really next thing to do. > > all i want is to use pgacces[gui] to administer my > postgres database.. > > any help wwill appreciate very much. tnx.. > > vic > > > -- > _____________________________________________________________ > Web-based SMS services available at > http://www.operamail.com. > From your mailbox to local or overseas cell phones. > > Powered by Outblaze > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster __________________________________ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com
thanx foor your reply Brett..
it did run now my pgaccess gui. but there's still error inside of pgaccess.
1.creating new database an error will pop.:
Tcl error executing pg_exec CREATE DATABASE test1 can not find channel named " ".
2.after that error i connect to a host and error pop:
Error trying to connect to database 'polmap' on host 172.blah.blah.blah
PostgreSQL error message: Connection to database failed Fatal: Password authentication failed user "kriz".
-I have typed correct user/password and im the superuser of my database. i really dont know what the error cost. but
whenim opening it again my pgaccess i was connected to that host i create.
3.when im trying to open at my host connect database tree i cant access them. an error tells me:
Could not find a good db handle.
Could not find PG version of the database.
4.on my frustrations i close thhe pgaccess[gui] then open it again. this is what i get:
[vvbuenaventura@localhost vvbuenaventura]$ pgaccess
Error in startup script: bad option "-1": must be -exact, -glob, -regexp, or -- while executing
"switch $res { 0 { # they hit ok } 1 { # they need help if {[string
length$helptopic]>0} {..." (procedure "showError" line 10) invoked from within
"showError $m open_database" (procedure "::Connections::openConn" line 137) invoked from within
"::Connections::openConn $i" (procedure "main" line 60) invoked from within
"main $argc $argv" (file "/usr/X11R6/bin/pgaccess" line 1172)
=======================
can u tell me what im missing to configure?
and what does the -pgintcl command line i found in help suggested me? where and how should i use it?
----- Original Message -----
From: Brett Schwarz <brett_schwarz@yahoo.com>
Date: Thu, 18 Mar 2004 19:07:33 -0800 (PST)
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] libpgtcl.so?
> Is pgaccess not running for you? Have you tried the
> newest snapshot?
>
> You don't necessarily need libpgtcl right now, but if
> you really want it, then you should be able to compile
> it from the makefile supplied in the libpgtcl
> directory. I would be surprised if RedHat didn't
> already come with libpgtcl installed. Have you checked
> (sorry, I don't use RedHat).
>
> What other dependencies are you having problems with?
>
> BTW, there is a dedicated pgaccess list, if you would
> like to use that. Go to www.pgaccess.org
>
> --brett
>
>
> --- Vickriz Buenaventuura <vickr1z@operamail.com>
> wrote:
> > good day too guru.
> > pgaccess has lot of dependencies, actually nnot so
> > much :)
> > i already install tcl/tk in my system rh7.3 and the
> > next step is the libpgtcl package [libpgtcl.so]
> > which i found from postgresql installation source.
> > my directory:
> >
> /usr/src/redhat/SOURCES/postgresql-7.3.2/src/interfaces/libpgtcl
> >
> > and then i found this instraction at postgresql
> > mailing list, tryingg to look for possible solution
> > for other installation dependencies. but i really
> > can understand what has to do with it. i need to
> > post iit here so anybbody can help me..
> > --
> > Rather than applying that patch, it would probably
> > be easier creating a
> > 'Makefile.custom' file in the postgresql-6.3.2/src
> > (which get included
> > by Makefile.global, and thus every Makefile in the
> > tree). Set
> > LINUX_ELF=true in Makefile.custom, and you won't
> > have to patch all of
> > the shared library makefiles. You can also specify
> > CUSTOM_CC and
> > CUSTOM_COPT in Makefile.custom to specify your
> > compiler and compile
> > flags, respectively.
> >
> > As for libpgtcl.so and unresolved symbols, I run a
> > Redhat 5.0 system
> > where the crypt() function lives in its own library
> > (libcrypt) and not
> > libc. libpgtcl.so is linked to libpq.so, which is
> > statically linked.
> > crypt() is probably used by libpq.so for passwords,
> > etc, but since
> > libpq.so is *not* linked with libcrypt, you must
> > link libcrypt.so as
> > well libpq.so into your app. The Tk shell, wish8.0,
> > is *not* linked to
> > libcrypt.so. Thus, when pgaccess.tcl loads the
> > libpgtcl.so library, the
> > system can't resolve the calls to crypt(). One
> > solution is to run
> > pgaccess.tcl with pgtksh, which *is* linked with
> > libcrypt.so. Just
> > change the first line of pgaccess.tcl to
> > #!/usr/local/pgsql/bin/pgtksh
> > (or where ever you installed postgresql). You could
> > also link
> > libpgtcl.so manually, adding the '-lcrypt' crypt
> > option, which would let
> > you run pgaccess.tcl and any other postgresql tcl
> > scripts with wish and
> > tclsh.
> > ==================end===
> >
> > please help how to edit my Makefile.custom at
> > /usr/src/redhat/SOURCES/postgresql-7.3.2/src
> > the next thing was the libpgtcl.. where should i put
> > it and or what should i make a link to it?
> > ..and what really next thing to do.
> >
> > all i want is to use pgacces[gui] to administer my
> > postgres database..
> >
> > any help wwill appreciate very much. tnx..
> >
> > vic
> >
> >
> > --
> >
> _____________________________________________________________
> > Web-based SMS services available at
> > http://www.operamail.com.
> > From your mailbox to local or overseas cell phones.
> >
> > Powered by Outblaze
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - More reliable, more storage, less spam
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
--
_____________________________________________________________
Web-based SMS services available at http://www.operamail.com.
From your mailbox to local or overseas cell phones.
Powered by Outblaze
On Fri, 19 Mar 2004, Vickriz Buenaventuura waxed: > thanx foor your reply Brett.. > it did run now my pgaccess gui. but there's still error inside of pgaccess. > > 1.creating new database an error will pop.: > Tcl error executing pg_exec CREATE DATABASE test1 can not find channel named " ". The problem here is that you aren't yet connected to any database. If you can download the latest version, there is a wizard you can use that makes creating a new database much, much easier. You just need to click on the button with a "wand" on it instead of typing in a database name right away. Download from here: http://www.pgaccess.org/index.php?page=Download I recommend the "pgaccess.bin" file, for the Linux Starpack. It is a one file download. Just chmod 755 this file and run it. No dependencies involved. > 2.after that error i connect to a host and error pop: > Error trying to connect to database 'polmap' on host 172.blah.blah.blah > PostgreSQL error message: Connection to database failed Fatal: Password authentication failed user "kriz". > -I have typed correct user/password and im the superuser of my database. i really dont know what the error cost. but whenim opening it again my pgaccess i was connected to that host i create. It sounds like you have some stale connections. Try removing the ~/.pgaccess/connections file. > 3.when im trying to open at my host connect database tree i cant access them. an error tells me: > Could not find a good db handle. > Could not find PG version of the database. Try clicking "OK", I think that's a bogus error you are getting, so just try ignoring it for right now. > 4.on my frustrations i close thhe pgaccess[gui] then open it again. this is what i get: > > [vvbuenaventura@localhost vvbuenaventura]$ pgaccess > Error in startup script: bad option "-1": must be -exact, -glob, -regexp, or -- > while executing > "switch $res { > 0 { > # they hit ok > } > 1 { > # they need help > if {[string length $helptopic]>0} {..." > (procedure "showError" line 10) > invoked from within > "showError $m open_database" > (procedure "::Connections::openConn" line 137) > invoked from within > "::Connections::openConn $i" > (procedure "main" line 60) > invoked from within > "main $argc $argv" > (file "/usr/X11R6/bin/pgaccess" line 1172) > ======================= Oops, this was a bug. It should read "switch -- $res {" on that first line there. Brett fixed this very recently, and it should be available in the release coming out at the end of this week. > can u tell me what im missing to configure? It's actually gotten much easier to setup PgAccess than the route you took. > and what does the -pgintcl command line i found in help suggested me? where and how should i use it? It loads a pure-Tcl interface, pgin.tcl, so that you can connect to PostgreSQL without worrying about any C files. This is the default behaviour if the dll/so files do not exist. You shouldn't have to worry about it if you download the latest version I mentioned above. --Chris -- Chris Maj, Rochester cmaj_at_freedomcorpse_dot_com Pronunciation Guide: Maj == May