From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
---|---|
To: | "Andrew R(dot) Jackson" <ajackson(at)dezines(dot)com> |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: [INTERFACES] a JDBC applet |
Date: | 1998-07-09 17:04:52 |
Message-ID: | Pine.LNX.3.96.980709175912.1647C-100000@maidast.retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
On Thu, 9 Jul 1998, Andrew R. Jackson wrote:
> At 04:49 PM 09/07/98 +0200, Cyril FERRAND wrote:
> > I look for an example of a Java applet to communicate with a
> >postgresql base via JBDC. Because I have a lot of pb with my own one.
> >A example like basic.java example is ok.
>
> I have a general question related to this connecting to the DB via
> applet: would this require the applet user's domain to be in the
> pg_hba.conf file? I couldn't successfully run basic.java (one of the
> examples) locally here and have it connect to Postgres at school without
> doing this first.
Yes, anything that connects to the server needs to be in pg_hba.conf
> If one wants an applet that can run anywhere to have access, then you'd
> have to set up Postgres not to only accept connections from certain
> domains, but all domains, right? I could be way off here since I am a
> lowly Postgres *user*, and most docs/discussion speak to people who have
> Postgres admin/config abilities, which is unfortunate.
You are correct, although you would do this at a database by database
level, rather than all databases.
> Anyway, my approach to the applet-Postgres issue is a client-server one.
> Applets are clients that connect to a server running on the same machine
> running the Postgres stuff which mediates the database connection. This
> will keep the sysadmin people happy :) At least at my school...
Personally, I work with Java applications rather than applets, because my
code isn't really suited to a browser environment. Most of the time it's
on the same machine as postgres, but a lot of the time, it's another
machine on my local network, so it's not much of a problem.
But for those who do write applets for External web use, they have to
account for it.
I think the following should work:
host mydb 0.0.0.0 0.0.0.0 password
I'd ill advise using trust, as they could get in as the DBA, and ident
wouldn't work well with most browsers (actually I can't think of any that
would work).
--
Peter T Mount peter(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)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(at)maidstone(dot)gov(dot)uk
From | Date | Subject | |
---|---|---|---|
Next Message | Peter T Mount | 1998-07-09 17:15:40 | Re: [INTERFACES] PostgreSql-users and passwords |
Previous Message | Peter T Mount | 1998-07-09 16:58:44 | Re: [INTERFACES] java.lang.OutOfMemoryError |