connection manager SLA point to DBALIAS not workin

Posted in 2013

Topics: Server Administration, Clustering, Grid & MACH11

Justin — Mon, 24 Jun 2013 16:55:06 — source: IIUG Forums & Mailing Lists

Hi, I have a SERVERSET in the connection manager. In the SLA, I have DBSERVERS set to a dbalias to the server (this service runs PAM authentication). My problem is that the connection manager keeps redirecting to the primary instance instead of the alias - how do I fix that? -Justin

↪ replying to Justin

Art Kagel — Mon, 24 Jun 2013 17:13:37 — source: IIUG Forums & Mailing Lists

Post your SQLHOSTS entries for the server and the SLA. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jun 24, 2013 at 12:55 PM, Justin Killen < jkillen@allamericanasphalt.com> wrote: > Hi, > > I have a SERVERSET in the connection manager. In the SLA, I have DBSERVERS > set > to a dbalias to the server (this service runs PAM authentication). My > problem > is that the connection manager keeps redirecting to the primary instance > instead of the alias - how do I fix that? > > -Justin > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1133b7dac2fe2404dfe973aa

↪ replying to Art Kagel

Justin — Mon, 24 Jun 2013 17:34:40 — source: IIUG Forums & Mailing Lists

Connection manager snippet: SERVERSET rmca_set_yard_${INFORMIXSERVER} { INFORMIXSERVER rmcapamgrp SLA rmca_cm_yard_${INFORMIXSERVER} DBSERVERS=curlypam FOC ORDER=NOTIFY TIMEOUT=10 RETRY=2 CMALARMPROGRAM ${INFORMIXDIR}/etc/cmalarmprogram.sh } Sqlhosts: curlynet onsoctcp curly rmcasoc g=rmcagrp rmcapamgrp group - - i=1876 curlypam onsoctcp curly rmcapamsoc g=rmcapamgrp,s=4,pam_serv=(rmca_pam),pamauth=(password) rmca_cm_yard group - - i=1778,c=1 rmca_cm_yard_curlynet onsoctcp curly rmcacmyardsoc g=rmca_cm_yard /etc/services snippet: rmcasoc 10022/tcp rmcapamsoc 10023/tcp rmcacmhqsoc 10030/tcp rmcacmyardsoc 10031/tcp output from cmsm when I try to connect: 09:54:27 DEBUG[TID140000110888704]:SLA rmca_cm_yard_curlynet server curlynet [10] workload=[(readyQ=0 sess=0 + 0 CPUVP=0) * 0.00] [cmsm_sla.c:select_server_from_sssla_type:3984] 09:54:27 SLA rmca_cm_yard_curlynet redirect SQLI client from 192.168.1.19 to curlynet 192.168.39.13.10022 Note the redirect to port 10022 (rmcasoc) instead of 10023 (rmcapamsoc) -Justin -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Monday, June 24, 2013 10:14 AM To: ids@iiug.org Subject: Re: connection manager SLA point to DBALIAS no.... [30621] Post your SQLHOSTS entries for the server and the SLA. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jun 24, 2013 at 12:55 PM, Justin Killen < jkillen@allamericanasphalt.com> wrote: > Hi, > > I have a SERVERSET in the connection manager. In the SLA, I have DBSERVERS > set > to a dbalias to the server (this service runs PAM authentication). My > problem > is that the connection manager keeps redirecting to the primary instance > instead of the alias - how do I fix that? > > -Justin > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1133b7dac2fe2404dfe973aa ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Justin

JINMING XIAO — Tue, 25 Jun 2013 13:49:24 — source: IIUG Forums & Mailing Lists

http://www-01.ibm.com/support/docview.wss?uid=swg21635513 a technote for Configuring the Connection Manager for PAM Authentication Thanks

↪ replying to JINMING XIAO

Justin — Tue, 25 Jun 2013 15:56:40 — source: IIUG Forums & Mailing Lists

That did the trick - thanks Jinming. For anyone viewing this in the future, what you need to do is add the 's=4,pam_serv=(rmca_pam),pamauth=(password)' onto the connection manager sqlhost entry in addition to the server entry. -Justin -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JINMING XIAO Sent: Tuesday, June 25, 2013 6:49 AM To: ids@iiug.org Subject: Re: RE: connection manager SLA point to DBALIAS no [30637] http://www-01.ibm.com/support/docview.wss?uid=swg21635513 a technote for Configuring the Connection Manager for PAM Authentication Thanks ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.