XHE: Secure ODBC using XHE

XHE: Secure ODBC using XHE


XYCONF on 192.160.10.20
# MX/ODBC/XHE TEST FOR INTERNAL IP STACK
18649 $SYSTEM.XYGATEHE.XYGATEHE -A:ODBC -T:$ZTCMX -SSL_NEG:SSLSRV -P:18650
#18650 RESERVED FOR ODBC/MX
18651 $SYSTEM.XYGATEHE.XYGATEHE-A:ODBC -T:$ZTCMX -SSL_NEG:SSLSRV -P:18651
18652 $SYSTEM.XYGATEHE.XYGATEHE-A:ODBC -T:$ZTCMX -SSL_NEG:SSLSRV -P:18652
18653 $SYSTEM.XYGATEHE.XYGATEHE-A:ODBC -T:$ZTCMX -SSL_NEG:SSLSRV -P:18653
18654 $SYSTEM.XYGATEHE.XYGATEHE-A:ODBC -T:$ZTCMX -SSL_NEG:SSLSRV -P:18654
18655 $SYSTEM.XYGATEHE.XYGATEHE-A:ODBC -T:$ZTCMX -SSL_NEG:SSLSRV -P:18655
18656 $SYSTEM.XYGATEHE.XYGATEHE-A:ODBC -T:$ZTCMX -SSL_NEG:SSLSRV -P:18656
18657 $SYSTEM.XYGATEHE.XYGATEHE-A:ODBC -T:$ZTCMX -SSL_NEG:SSLSRV -P:18657
18658 $SYSTEM.XYGATEHE.XYGATEHE-A:ODBC -T:$ZTCMX -SSL_NEG:SSLSRV -P:18658
18659 $SYSTEM.XYGATEHE.XYGATEHE-A:ODBC -T:$ZTCMX -SSL_NEG:SSLSRV -P:18659
18660 $SYSTEM.XYGATEHE.XYGATEHE-A:ODBC -T:$ZTCMX -SSL_NEG:SSLSRV -P:18660

Add a process for SQL-MX

info process $zzkrn.#mxjpm,detail
NONSTOP KERNEL - Detailed Info PROCESS \QUALITY.$ZZKRN.#MXJPM
 
*AutoRestart...............10
*BackupCPU.................Not Specified
*CPU.......................FIRSTOF (01,00)
*DefaultVolume.............$SYSTEM.NOSUBVOL
*ExtSwap...................Not Specified
*Highpin...................ON
*HomeTerminal..............$ZHOME
*InFile....................Not Specified
*Library...................Not Specified
*MemPages..................Not Specified
*Name......................$MXJPM
*OutFile...................Not Specified
*PFSSize...................Not Specified
*PrimaryCPU................Not Specified
*Priority..................10
*Program...................$SYSTEM.ZMXODBC.MXOAS
*SaveAbend.................OFF
*StartMode.................APPLICATION
*StartupMessage............-pn 18650 -pr 10 -TCP $ZTCMX
*StopMode..................STANDARD
*Type......................OTHER
*UserId....................SUPER.SUPER (  255,255  )

HEACL Configuration
SERVER_GROUP INTERNAL_ODBC
 DESCRIPTION "ODBC for in-house use"
  SERVER 127.0.0.1 18649
  SERVER 127.0.0.1 18650
  SERVER 127.0.0.1 18651
  SERVER 127.0.0.1 18652
  SERVER 127.0.0.1 18653
  SERVER 127.0.0.1 18654
  SERVER 127.0.0.1 18655
  SERVER 127.0.0.1 18656
  SERVER 127.0.0.1 18657
  SERVER 127.0.0.1 18658
  SERVER 127.0.0.1 18659
  IP *.*.*.*
  IP re:".*"

HP NonStop SSL RemoteProxy configuration
  1. FTP $SYSTEM.ZNSSL.PROXYEXE to a PC in binary mode
  2. Rename PROXYEXE to proxy.exe
  3. Install the proxy and start a session.
  4. HP NonStop SSL RemoteProxy



HP NonStop ODBC Configuration
  1. Install ODBC driver provided by HP
  2. FTP NSODBC64 OR NSODBC32 in binary mode from $SYSTEM.ZMXODBC to a PC.
  3. Rename NSODBC64 to NSODBC63.exe and run to install (NSODBC32 to NSODBC32.exe)
  4. Add a ODBC setting to connect to remote proxy (localhost )