Re: Proxy Server and Sql*Net

From: Don Jerman <djerman_at_dot.state.nc.us>
Date: Fri, 12 Jan 2001 14:07:59 -0500
Message-Id: <10739.126547@fatcity.com>

This is a multi-part message in MIME format. --------------E32D0E2C85228AF31FE627E1
Content-Type: multipart/alternative;
boundary="------------69CE217DAEF98808D58431FB"

--------------69CE217DAEF98808D58431FB
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I don't know about that particular proxy server, but Connection Manager at your end would allow you to tie it down to a single port number. The client connects to a known CM port, and provides the downstream connect information (see the configuration instructions for details). The CM handles the server port redirect.

Michael Kline wrote:

> I have a client running MS Proxy Server II.
>
> They would like to find a way to allow a somewhat secure
> connect to their database via sql*net...
>
> They tried a redirect of using a port xyz and passing that to
> the database as the listener port abc... The problem is the
> connect is made as port defgh, and this "redirect" has no idea
> what to do with it...
>
> Has anyone else done this and how did you go about making it
> work?
>
>
> ThinkSpark - Michael Alan Kline, Sr.
> Technical Consultant - Richmond, Virginia Office
> 13308 Thornridge Court; Midlothian, VA 23112, USA.
> W: 804-744-1545
> Michael.Kline_at_ThinkSpark.com
> Pager: 877-705-1155
> Alpha pager: www.metrocall.com/Page.html
> ICQ: 1009605, 975313 PhoneFree: 1057439

--------------69CE217DAEF98808D58431FB
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">

<html>
<body text="#000000" bgcolor="#CCCCCC" link="#0000EE" vlink="#551A8B" alink="#FF0000"> I don't know about that particular proxy server, but Connection Manager at your end would allow you to tie it down to a single port number.  The client connects to a known CM port, and provides the downstream connect information (see the configuration instructions for details).  The CM handles the server port redirect.
Michael Kline wrote:
<blockquote TYPE=CITE> I have a client running MS Proxy Server II.
They would like to find a way to allow a somewhat secure connect to their database via sql*net... They tried a redirect of using a port xyz and passing that to the database as the listener port abc... The problem is the connect is made as port defgh, and this "redirect" has no idea what to do with it...
Has anyone else done this and how did you go about making it work?
 ThinkSpark  - Michael Alan Kline, Sr. Technical Consultant -  Richmond, Virginia Office 13308 Thornridge Court; Midlothian, VA 23112, USA. W:    804-744-1545
 Michael.Kline_at_ThinkSpark.com Pager: 877-705-1155
 Alpha pager: www.metrocall.com/Page.html ICQ: 1009605, 975313    PhoneFree: 1057439 </blockquote>

</body>
</html>

--------------69CE217DAEF98808D58431FB-- --------------E32D0E2C85228AF31FE627E1
Content-Type: text/x-vcard; charset=us-ascii; name="djerman.vcf"

Content-Transfer-Encoding: 7bit
Content-Description: Card for Don Jerman
Content-Disposition: attachment;

filename="djerman.vcf"

begin:vcard
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Information Technology
version:2.1
email;internet:djerman_at_dot.state.nc.us
title:Database Administrator
adr;quoted-printable:;;Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA Received on Fri Jan 12 2001 - 13:07:59 CST