Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Ingres Topics / September 2005

Tip: Looking for answers? Try searching our database.

Which tcp port does Ingres/Net use on HPUX

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Norman Woo - 28 Sep 2005 01:52 GMT
Hi folks

We have Ingres/Net running on a development server (HPUX 10.20) and we
need to access a production database running on a production server
(also HPUX 10.20) via ISQL.  However, the production server is behind
a firewall and we need to advise the security folks which port on the
production server we need to have open so that Ingres/Net on our
development server can access the production server.  Which port(s)
should we use and/or where should lwe ook to determine the port?

TIA
Peter Gale - 28 Sep 2005 06:06 GMT
Hi Norman,

The choice of ports is entirely up to you. Typically Ingres/Net is
configured on the server to use the Installation ID as the listen address.
This translates to a tcp-ip port when the net server starts up and will
always translate to the same value. You can find out what it translates to
by looking in $II_SYSTEM/ingres/files/errlog.log on the server just after
the net server has started. You will see an entry like this.

Sun Jul 10 07:31:16 2005 E_GC2815_NTWK_OPEN   Network open complete for
protocol TCP_IP, port II (21064).

So the port ID is 21064.

If the server is configured to start multiple net servers from the same
configuration then there will be one line for each.

Sun Jul 10 07:31:16 2005 E_GC2815_NTWK_OPEN   Network open complete for
protocol TCP_IP, port II1 (21065).

Sun Jul 10 07:31:16 2005 E_GC2815_NTWK_OPEN   Network open complete for
protocol TCP_IP, port II2 (21066).

And so on up to a maximum II7 (21071). If there are multiple net server
configurations then you could find more than 8 ports.

As I said these port ID's will be the same every time these net servers
start up.

All the best

Peter Gale
Comprehensive Solutions (US)
Comprehensive Solutions International (UK)
T: +44 (0)1398 341777                M: +44 (0)7831 513181
PGale@Comp-Soln.co.uk   www.Comp-Soln.co.uk


-----Original Message-----
From: info-ingres-admin@cariboulake.com
[mailto:info-ingres-admin@cariboulake.com] On Behalf Of Norman Woo
Sent: 28 September 2005 01:52
To: info-ingres@cariboulake.com
Subject: [Info-ingres] Which tcp port does Ingres/Net use on HPUX

Hi folks

We have Ingres/Net running on a development server (HPUX 10.20) and we
need to access a production database running on a production server
(also HPUX 10.20) via ISQL.  However, the production server is behind
a firewall and we need to advise the security folks which port on the
production server we need to have open so that Ingres/Net on our
development server can access the production server.  Which port(s)
should we use and/or where should lwe ook to determine the port?

TIA
_______________________________________________
Info-ingres mailing list
Info-ingres@cariboulake.com
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres
franky.leeuwerck@gmail.com - 28 Sep 2005 09:47 GMT
Thanks for this tip, Peter.

Franky
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.