connection manager SLA point to DBALIAS not workin

Posted in 2013

Summary

Justin's Connection Manager SLA, pointing to a PAM-authenticated DBSERVERS alias, redirected clients to the primary port 10022 instead of the PAM port 10023. Jinming Xiao pointed to an IBM technote on CM with PAM. Justin solved it by adding s=4,pam_serv=(rmca_pam),pamauth=(password) to the connection manager's sqlhosts entry as well as the server entry.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

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.