IDS Forum

Re: Connection manager redirect

Posted By: PING TANG
Date: Tuesday, 5 May 2009, at 10:59 p.m.

In Response To: Re: Connection manager redirect (Nilesh Ozarkar)

Connection manager only redirects connection and it was not designed to redirect or handle transactions. Your clients need to communicate with the server in DMZ directly.

Regards,

-Ping

--- On Tue, 5/5/09, Nilesh Ozarkar <nilesho@us.ibm.com> wrote:

> From: Nilesh Ozarkar <nilesho@us.ibm.com>
> Subject: Re: Connection manager redirect [15682]
> To: ids@iiug.org
> Date: Tuesday, May 5, 2009, 6:43 PM
> What kind of error clients are
> getting ?
>
> Regards,
> Nilesh.,
>
> ids-bounces@iiug.org
> wrote on 05/05/2009 05:08:25 PM:
>
> > [image removed]
> >
> > Connection manager redirect [15681]
> >
> > VIVIAN JONES
> >
> > to:
> >
> > ids
> >
> > 05/05/2009 05:09 PM
> >
> > Sent by:
> >
> > ids-bounces@iiug.org
>
> >
> > Please respond to ids
> >
> > We implement a MACH11 environment (one primary server,
> one SDS server and
> two
> > connection managers in separate machines); when any
> client (in a public
> > network) establish a connection with the connection
> manager (DMZ
> network),
> > this last one redirect the connection to the selected
> IDS instance
> (private
> > network), but the instance response directly to the
> client and in the
> same
> > session when the client need to establish a
> communication go directly to
> the
> > IDS instance without using the connection manager,
> reporting an error
> because
> > the client dont know the IP private address of the IDS
> server.
> >
> > here the configuration files:
> >
> > ENVIRONMENT VARIABLES AT CONNECTION MANAGER SERVER
> > INFORMIXSQLHOSTS=/informix/etc/sqlhosts
> > INFORMIXDIR=/informix
> > INFORMIXSERVER=sefin_tcp
> >
> > CONNECTION MANAGER CONFIG FILE
> > # Connection Manager name
> > NAME cm3
> > # re-route Informix clients to the primary for
> transaction processing
> > SLA sefincm1_tcp=(PRI+SDS)
> > # Failover Configuration
> > FOC SDS,0
> > # worker threads for each SLA listener, default is 8
> > SLA_WORKERS 16
> > #Debugging
> > DEBUG 1
> > # Connection Manager message file
> > LOGFILE /informix/cm3.log
> >
> > SQLHOSTS AT CONNECTION MANAGER SERVER
> > sefincm_tcp group - - c=1
> > #Primary Connection Manager server
> > sefincm1_tcp onsoctcp 10.4.74.121 4950 g=sefincm_tcp
> > sefincm2_tcp onsoctcp 192.168.41.42 4950
> g=sefincm_tcp,s=6
> > sefincm3_tcp onsoctcp 192.168.41.43 4950
> g=sefincm_tcp,s=6
> > sefincm4_tcp onsoctcp 192.168.41.44 4950
> g=sefincm_tcp,s=6
> > #Secondary Connection Manager server
> > sefincm11_tcp onsoctcp 192.168.41.141 4950
> g=sefincm_tcp,s=6
> > sefincm12_tcp onsoctcp 192.168.41.142 4950
> g=sefincm_tcp,s=6
> > sefincm13_tcp onsoctcp 192.168.41.143 4950
> g=sefincm_tcp,s=6
> > sefincm14_tcp onsoctcp 192.168.41.144 4950
> g=sefincm_tcp,s=6
> > sefin_tcpg group - - c=1
> > # Primary Server
> > sefin_tcp onsoctcp 192.168.41.21 1525 g=sefin_tcpg,s=6
>
> > sefin_tcp2 onsoctcp 192.168.41.22 1525
> g=sefin_tcpg,s=6
> > sefin_tcp3 onsoctcp 192.168.41.23 1525
> g=sefin_tcpg,s=6
> > sefin_tcp4 onsoctcp 192.168.41.24 1525
> g=sefin_tcpg,s=6
> > # SDS Server
> > sefinsds_tcp onsoctcp 192.168.41.121 1525
> g=sefin_tcpg,s=6
> > sefinsds_tcp2 onsoctcp 192.168.41.122 1525
> g=sefin_tcpg,s=6
> > sefinsds_tcp3 onsoctcp 192.168.41.123 1525
> g=sefin_tcpg,s=6
> > sefinsds_tcp4 onsoctcp 192.168.41.124 1525
> g=sefin_tcpg,s=6
> >
> > CONNECTION MANAGER LOG FILE
> > Tue May 5 11:54:19 2009
> > 11:54:19 IBM Informix Connection Manager
> > 11:54:19 Connection Manager name is cm3
> > 11:54:19 Starting Connection Manager...
> > 11:54:19 stat(/informix/etc/passwd_file) failed, errno
> = 2
> > 11:54:19 Warning: Password Manager failed; working in
> trusted node mode
> > 11:54:19 Current max open fd is 2000
> > 11:54:19 fcntl(/informix/tmp/cmsm.pid.cm3) success
> errno = 0
> > 11:54:19 dbservername = sefin_tcp
> > 11:54:19 nettype = onsoctcp
> > 11:54:19 hostname = 192.168.41.21
> > 11:54:19 servicename = 1525
> > 11:54:19 options = g=sefin_tcpg,s=6
> > 11:54:19 switch to daemon mode
> > 11:54:19 new daemon pid is 467036
> > 11:54:19 create new thread 772 for sefin_tcp
> > 11:54:19 listener sefincm1_tcp initializing
> > 11:54:19 Listener sefincm1_tcp=(PRI) is active with 16
> worker threads
> > 11:54:19 Connection Manager successfully connected to
> sefin_tcp
> > 11:54:19 sefin_tcp protocols = 1
> > 11:54:19 fetch sysconfig_cursor sqlcode = (100,0,)
> > 11:54:19 Adding server sefin_tcp
> > 11:54:19 Arbitrator FOC string = DISABLED,0
> > 11:54:19 Arbitrator setting primary name = sefin_tcp
> > 11:54:19 FOC: Failover Arbitrator disabled
> > 11:54:19 FOC timeout = 0
> > 11:54:19 get sefin_tcp CM_ADM event 8:3 cm3
> > 11:54:19 Arbitrator received CM event, subtype=3,
> cm=cm3
> > 11:54:19 Arbitrator reinitialized CM names
> > 11:54:19 Arbitrator added CM name = cm3
> > 11:54:19 Arbitrator is active on CM = cm3
> > 11:54:20 Connection Manager started successfully
> > 11:55:33 SLA sefincm1_tcp redirect SQLI client from
> 10.4.25.57 to
> sefin_tcp
> > 192.
> > 168.41.21.1525
> >
> >
> >
>
> *******************************************************************************
>
>
> > Forum Note: Use "Reply" to post a response in the
> discussion forum.
> >
>
>
> *******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
>
>

Messages In This Thread

• Connection manager redirect
  VIVIAN JONES -- Tuesday, 5 May 2009, at 6:08 p.m.
  • Re: Connection manager redirect
    Nilesh Ozarkar -- Tuesday, 5 May 2009, at 7:43 p.m.
    • Re: Connection manager redirect
      VIVIAN JONES -- Tuesday, 5 May 2009, at 9:34 p.m.
      • Re: Connection manager redirect
        Madison Pruet -- Tuesday, 5 May 2009, at 9:40 p.m.
        • Re: Connection manager redirect
          VIVIAN JONES -- Tuesday, 5 May 2009, at 10:45 p.m.
          • Re: Connection manager redirect
            JIM XIAO -- Wednesday, 6 May 2009, at 4:47 p.m.
    • Re: Connection manager redirect
      PING TANG -- Tuesday, 5 May 2009, at 10:59 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.