SLA Not Working with Kerberos Enabled Service
Dear All,
I am running the Informix IDS 11.70 FC4 at AIX 64-bit OS.
I have a connection manager, in which I wanted to configure an SLA which
should use the DBSERVERALIAS, which is configured with kerberos authentication.
My connection manager and DB server are running on the same machine.
I can successfully make direct connections using DBSERVERALIAS which is
configured with kerberos by issuing "dbaccess stores@test1_tcp_1"
However, when I configure the SLA and start the connection manager, and try to
use that SLA, then instead of connecting the session with the kerberos
configured service, it connect the session with the other service (i.e.
DBSERVER).
Please note that I am also using USEALIASES=off option in the SLA as well but
it is still not working and making connection with the DBSERVER instead of
DBSERVERALIAS
Here are the configuration details:
---------------------------------------------------
#Connection Manager Configuration File
---------------------------------------------------
# Connection Manager name
NAME test2_cmsm_1
# Connection Manager message file
LOGFILE /home/informix/test2_cmsm_1.log
LOG 1
CM_TIMEOUT 60 #default value is 60
DEBUG 1
EVENT_TIMEOUT 30 #default value is 60
SECONDARY_EVENT_TIMEOUT 30
# BODY
# Connection Unit 1
CLUSTER g_er1
{
INFORMIXSERVER test1_tcp_1
SLA support1 DBSERVERS=test1_tcp_1 USEALIASES=off
FOC ORDER=DISABLE
}
---------------------------------------------------
#sqlhosts file
---------------------------------------------------
# Entry for DBSERVER service
test1_tcp onsoctcp dev40 test1_tcp# Entry for kerberos supported service (DBSERVERALIAS)
test1_tcp_1 onsoctcp dev40 test1_tcp_1 s=7,csm=(GSSCSM)
---------------------------------------------------
#sqlhosts file
---------------------------------------------------
bash-3.00$ onstat -c|grep DBSERVERDBSERVERNAME test1_tcp
DBSERVERALIASES test1_tcp_1
Can anyone help me in resolving the issue.
Can I use kerberos enabled service in the connection manager SLA or not?
Thanks in advance for your help.
Regards,
Khan