Re: [JDBC] jdbc "proxy" server ...

2001-08-23 Thread Gunnar Rønning

* "Marc G. Fournier" <[EMAIL PROTECTED]> wrote:
|
| have a database behind a firewall ... we'd like to make connections
| available to that machine through a machine outside of the firewall, so
| that its a secure connection to the "proxy", and in-secure from
| proxy->database ...
| 
| the 'clients' will be written in java ...

What about tunneling your connections through ssh ?

-- 
Gunnar Rønning - [EMAIL PROTECTED]
Senior Consultant, Polygnosis AS, http://www.polygnosis.com/

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [JDBC] jdbc "proxy" server ...

2001-08-23 Thread Peter T Mount

Quoting "Marc G. Fournier" <[EMAIL PROTECTED]>:

> 
> have a database behind a firewall ... we'd like to make connections
> available to that machine through a machine outside of the firewall, so
> that its a secure connection to the "proxy", and in-secure from
> proxy->database ...
> 
> the 'clients' will be written in java ...

Marc, in the past I used sucessfully the proxygw tool from the fwtk toolkit. 
Although it wasn't that secure (pg_hba.conf was effectively useless as it saw 
just the firewall ip), it worked.

Peter

-- 
Peter Mount [EMAIL PROTECTED]
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [JDBC] jdbc "proxy" server ...

2001-08-22 Thread Peter Wiley


I don't mind. Wrote it to do one particular job, extended its
functionality a couple times, most recently to implement a crude pooling
system. The code needs work (what doesn't when it gets genericised... )
but it'd be a good starting point at least. I own the IP (as much as
anyone owns IP to stuff built on top of other peoples' work) so there's no
hassle releasing it as GPL code or whatever.

I'm leaving this job in 2 weeks and going to another one so - how fast do
you need the code?

Another alternative for you is RmiJdbc. I looked at this but decided to
'roll my own' as I wanted the ability to submit batch jobs and do a
couple other unusual things like crosstab datasets - in effect turn a
'deep' table structure into a 'wide' one for easy display in a JTable etc.
The batch stuff is pretty generic but not the crosstab code; never needed
to.

>
> something maybe that would fit into contrib? :)
>
> On Thu, 23 Aug 2001, Peter Wiley wrote:
>
> >
> > I've got a pile of RMI/JDBC code that does something damn close if not
> > exactly what you want. Client & server ends. I wrote it to allow
> > interactive queries & display the results in a Java applet or application
> > then extended it to allow interactive and/or batch insert/update/delete
> > functionality with (optionally) an email back telling you what happened to
> > your batch SQL.
> >
> > It's known to work against Informix, Oracle 8i and I think PostgreSQL -
> > certainly there's no reason why it won't asit just loads the appropriate
> > JDBC driver.


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



Re: [JDBC] jdbc "proxy" server ...

2001-08-22 Thread Marc G. Fournier


something maybe that would fit into contrib? :)

On Thu, 23 Aug 2001, Peter Wiley wrote:

>
> I've got a pile of RMI/JDBC code that does something damn close if not
> exactly what you want. Client & server ends. I wrote it to allow
> interactive queries & display the results in a Java applet or application
> then extended it to allow interactive and/or batch insert/update/delete
> functionality with (optionally) an email back telling you what happened to
> your batch SQL.
>
> It's known to work against Informix, Oracle 8i and I think PostgreSQL -
> certainly there's no reason why it won't asit just loads the appropriate
> JDBC driver.
>
> Email me if you're interested.
>
> Peter Wiley
>
> On Wed, 22 Aug 2001, Marc G. Fournier wrote:
>
> >
> > have a database behind a firewall ... we'd like to make connections
> > available to that machine through a machine outside of the firewall, so
> > that its a secure connection to the "proxy", and in-secure from
> > proxy->database ...
> >
> > the 'clients' will be written in java ...
> >
> >
> > ---(end of broadcast)---
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to [EMAIL PROTECTED] so that your
> > message can get through to the mailing list cleanly
> >
>
>


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [JDBC] jdbc "proxy" server ...

2001-08-22 Thread Peter Wiley


I've got a pile of RMI/JDBC code that does something damn close if not
exactly what you want. Client & server ends. I wrote it to allow
interactive queries & display the results in a Java applet or application
then extended it to allow interactive and/or batch insert/update/delete
functionality with (optionally) an email back telling you what happened to
your batch SQL.

It's known to work against Informix, Oracle 8i and I think PostgreSQL -
certainly there's no reason why it won't asit just loads the appropriate
JDBC driver.

Email me if you're interested.

Peter Wiley

On Wed, 22 Aug 2001, Marc G. Fournier wrote:

>
> have a database behind a firewall ... we'd like to make connections
> available to that machine through a machine outside of the firewall, so
> that its a secure connection to the "proxy", and in-secure from
> proxy->database ...
>
> the 'clients' will be written in java ...
>
>
> ---(end of broadcast)---
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
> message can get through to the mailing list cleanly
>


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html