Content-Type: text/plain; charset="iso-8859-1"
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
MIME-Version: 1.0
From: "Vickriz Buenaventuura" <vickr1z@operamail.com>
To: "Brett Schwarz" <brett_schwarz@yahoo.com>
Cc: pgsql-interfaces@postgresql.org
Date: Fri, 19 Mar 2004 06:56:29 +0100
Subject: Re: libpgtcl.so?
Message-Id: <20040319055629.29F4423979@ws5-3.us4.outblaze.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 when im 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