Thread: pgaccess under IRIX 5.3 - please help

pgaccess under IRIX 5.3 - please help

From
Stuart Rison
Date:
Dear all,

In a brief moment of folly I thought "oh, I'll just install pgaccess0.87
today".

Three day later I had:

- Installed tcl8.0, installed tk8.0 (when it dawned upon me that a tcl/tk
interface might just need the :) )
- learnt about patches; obtained gnu patch; patched ./configure for pgsql
6.3.2 (this to recompile postgreSQL --with-tcl)
- learnt -ok, fudged- about with tk.h and libtcl8.0.a libtk8.0.a and stuck
them in /usr/local/lib
- compiled /src/interfaces/libpgtcl
- got libpgtcl.a
- wept/sworn and kicked myself and my computer

I fell I am tantalisingly close, like I have all the bits but not quite the
right order.

I'm trying all on this on an INDIGO2 running IRIX 5.3.  I've read
newsgroups/web sites etc for pgaccess and they all say you need
libpgtcl.so.  However, there are -to the best of my knowledge- no
precompiled IRIX 5.3 binaries for libpgtcl.   Also, and please bear in mind
that I'm a biologist by training so don't be too harsh, I'm under the
impression that libpgtcl.so and libpgtcl.a are not simply minor variation
on each other but completely different concepts with the former a dynamic
shared library accessed a run-time and the latter a static library fixed at
compilation time.

Can anybody help?

What am I doing wrong?  Is there a way of getting libpgtcl.so under IRIX
5.3?  Is there a way to run pgaccess with libpgtcl.a?  Has anybody got
pgaccess to run successfully under IRIX 5.3?  and if so could you help me
out?

or should I just have a nice cup of tea and do the Time crossword?

best regards,

Stuart.

PS.  The Times crosswords are at: http://www.the-times.co.uk [Register, get
to the front page and click the link at the top]


+-------------------------+--------------------------------------+
| Stuart Rison            | Ludwig Institute for Cancer Research |
| Tel. (0171) 878 4041    | Courtauld Building                   |
| Fax. (0171) 878 4040    | 91 Riding House Street               |
+-------------------------+ London, W1P 8BT                      |
| stuart@ludwig.ucl.ac.uk | UNITED KINGDOM.                      |
+-------------------------+--------------------------------------+



JDBC update permission denied!!!

From
Bernhard Matthias Ertl
Date:
Hi all, I hope only a small problem: When I'm connecting via JDBC to my
database, I can select without any problems, but updating I get permission
denied, and no action is performed. Maybe it is, cause I'm connecting from
a applet via TCP/IP. In the pga_access the host and also the server are
trusted.....
So, what could I do?

Be
*********************************************************************
* Bernhard Matthias Ertl  *  email: ertl@bigfoot.com                *
* Calslaan 1-107          *                                         *
* NL-7522 MH Enschede     *         ertl@edupsy.uni-muenchen.de     *
* Tel: ++31 53 489 5001   *                                         *
*********************************************************************
select * from ID where kind = 'node'
update ID set ID = 16 where kind = 'node'
Exception: java.sql.SQLException: WARN:id: Permission denied.

Re: [INTERFACES] JDBC update permission denied!!!

From
Peter T Mount
Date:
On Mon, 8 Jun 1998, Bernhard Matthias Ertl wrote:

> Hi all, I hope only a small problem: When I'm connecting via JDBC to my
> database, I can select without any problems, but updating I get permission
> denied, and no action is performed. Maybe it is, cause I'm connecting from
> a applet via TCP/IP. In the pga_access the host and also the server are
> trusted.....

No, applet security doesn't filter down to the database. The fact that you
are connecting to the database means that Applet Security isn't affecting
you.

> So, what could I do?

Did you create the tables as a different user to the one the applet is
using? If so, you will have to GRANT update access to the applet user for
them to update the tables.

--
Peter T Mount peter@retep.org.uk or petermount@earthling.net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk