CONNECTION MANAGER WINDOWS
Posted in 2010
Topics: High Availability & Replication, Error Codes & Troubleshooting, Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Security, Permissions & Auditing, Networking & sqlhosts Configuration, Platform-Specific Issues, Clustering, Grid & MACH11
Olá amigos, Hello friends, PROBLEMAS COM O CONNECTION MANAGER NO WINDOWS ============================================= PROBLEMS WITH CONNECTION MANAGER ON WINDOWS =========================================== Estou montando 3 servidores rodando SUSE LINUX com Informix 11.50.FC6 I'm setting up 3 servers using SUSE LINUX with Informix 11.50.FC6 Um Primário, outro SDS e outro HDR. A Primary, other SDS and the other HDR. Configurei o CM pra rodar no PRI e SDS e foi de primeira. Os aplicativos caracter que tenho rodando nestes servidores em .4GL alternam perfeitamente entre eles. O Failover e LoadBalance é perfeito. I setted up the CM to run on PRI and SDS and it starts up fine. The .4GL programs running in these servers alternates well between them. The Failover and Loadbalance are perfect. Entretanto terei alguns servidores WEB que estarão acessando o informix nesta configuração e minha intenção era também implantar o loadbalance/failover. A linguagem a ser utilizada nestes servidores WEB é .NET e o SDK está com a última versão. However I'll have some WEB servers accessing the informix with this configuration and my goal is to also configure them with loadbalance/failover. The used language on these WEB servers is .Net and the SDK is the last version. Eu enchergo as 3 máquinas perfeitamente se a conexão for uma por uma. Conectividade funcionanado a contento. I can see the 3 machines perfectly individually. Connectivity is working fine. Entretanto ao subir o "Connection Manager" no Windows com a intenção de fazer PROXY para acessar as intancias no Linux não funciona. However when the CM turns on on Windows going to be a PROXY to access the instances on Linux it's not working. No LOG do CM no Windows eu tenho: On Windows' CM Log I get: 14:15:42 IBM Informix Connection Manager 14:15:42 Connection Manager name is cm_windows 14:15:42 Starting Connection Manager... 14:15:42 dbservername = cluster 14:15:42 nettype = 14:15:42 hostname = - 14:15:42 servicename = - 14:15:42 options = i=10 14:15:42 listener loadbalance initializing 14:15:42 create new thread 1132 for no1 [M:\\\\eo-csdk350-xC6-o-win64\\\\tristarm\\\\.\\\\asf\\\\cmsm\\\\cmsm_sla.c:651] 14:15:42 Listener loadbalance=(PRI+SDS) <MODE=PROXY> is active with 16 worker threads 14:15:42 CONNECT to sysmaster@no1|onsoctcp|192.168.115.82|1525 AS no10 USER abcz SQLCODE = (-951,2,usuario@urbano[Urbano]) [m:/eo-csdk350-xc6-o-win64/tristarm/./asf/cmsm/cmsm_server.ec:156] 14:15:43 Connection Manager started successfully 14:15:43 CONNECT to sysmaster@no1|onsoctcp|192.168.115.82|1525 AS no10 USER abcz SQLCODE = (-951,2,usuario@urbano[Urbano]) [m:/eo-csdk350-xc6-o-win64/tristarm/./asf/cmsm/cmsm_server.ec:156] 14:15:47 Error: monitor thread no1 fatal error, Connection Manager shut down No ONLINE.LOG do informix no LINUX eu tenho: On informix's ONLINE.LOG on LINUX I get: 07/15/10 12:09:47 Password Validation for user [usuario] failed! 07/15/10 12:09:47 Check for password aging/account lock-out. 07/15/10 12:09:47 listener-thread: err = -952: oserr = 0: errstr = usuario@urbano[Urbano]: User (usuario@urbano[Urbano])'s password is not correct for the database server. O usuário existe e o passwd_file também está configurado. Conforme eu disse, a conectividade está perfeita, mas o CM não sobe no Windows. The user exists and the passwd_file is also configured. As I said, the connectivity is perfect, but CM doesn't turns up on Windows. Pretendo liberar estas máquinas para produção brevemente mas não gostaria de apontar as conexões .NET diretamente para os servidores individualmente. Gostaria que fosse controlado pelo CM. I pretend to put these machines on production soon but I wouldn't like to point the .Net connections directly to the servers individually. I'd like to CM control this. Agradeço muito suas ajudas. I apreciate a lot your help. Abraços. Best regards. Urbano.
You need SDK v3.50 or later tousethe CM. Art On Jul 15, 2010 2:29 PM, "RODEMIR URBANO DOS SANTOS" <r.urbano@terra.com.br> wrote: Olá amigos, Hello friends, PROBLEMAS COM O CONNECTION MANAGER NO WINDOWS ============================================= PROBLEMS WITH CONNECTION MANAGER ON WINDOWS =========================================== Estou montando 3 servidores rodando SUSE LINUX com Informix 11.50.FC6 I'm setting up 3 servers using SUSE LINUX with Informix 11.50.FC6 Um Primário, outro SDS e outro HDR. A Primary, other SDS and the other HDR. Configurei o CM pra rodar no PRI e SDS e foi de primeira. Os aplicativos caracter que tenho rodando nestes servidores em .4GL alternam perfeitamente entre eles. O Failover e LoadBalance é perfeito. I setted up the CM to run on PRI and SDS and it starts up fine. The .4GL programs running in these servers alternates well between them. The Failover and Loadbalance are perfect. Entretanto terei alguns servidores WEB que estarão acessando o informix nesta configuração e minha intenção era também implantar o loadbalance/failover. A linguagem a ser utilizada nestes servidores WEB é .NET e o SDK está com a última versão. However I'll have some WEB servers accessing the informix with this configuration and my goal is to also configure them with loadbalance/failover. The used language on these WEB servers is .Net and the SDK is the last version. Eu enchergo as 3 máquinas perfeitamente se a conexão for uma por uma. Conectividade funcionanado a contento. I can see the 3 machines perfectly individually. Connectivity is working fine. Entretanto ao subir o "Connection Manager" no Windows com a intenção de fazer PROXY para acessar as intancias no Linux não funciona. However when the CM turns on on Windows going to be a PROXY to access the instances on Linux it's not working. No LOG do CM no Windows eu tenho: On Windows' CM Log I get: 14:15:42 IBM Informix Connection Manager 14:15:42 Connection Manager name is cm_windows 14:15:42 Starting Connection Manager... 14:15:42 dbservername = cluster 14:15:42 nettype = 14:15:42 hostname = - 14:15:42 servicename = - 14:15:42 options = i=10 14:15:42 listener loadbalance initializing 14:15:42 create new thread 1132 for no1 [M:\\\\eo-csdk350-xC6-o-win64\\\\tristarm\\\\.\\\\asf\\\\cmsm\\\\cmsm_sla.c:651] 14:15:42 Listener loadbalance=(PRI+SDS) <MODE=PROXY> is active with 16 worker threads 14:15:42 CONNECT to sysmaster@no1|onsoctcp|192.168.115.82|1525 AS no10 USER abcz SQLCODE = (-951,2,usuario@urbano[Urbano]) [m:/eo-csdk350-xc6-o-win64/tristarm/./asf/cmsm/cmsm_server.ec:156] 14:15:43 Connection Manager started successfully 14:15:43 CONNECT to sysmaster@no1|onsoctcp|192.168.115.82|1525 AS no10 USER abcz SQLCODE = (-951,2,usuario@urbano[Urbano]) [m:/eo-csdk350-xc6-o-win64/tristarm/./asf/cmsm/cmsm_server.ec:156] 14:15:47 Error: monitor thread no1 fatal error, Connection Manager shut down No ONLINE.LOG do informix no LINUX eu tenho: On informix's ONLINE.LOG on LINUX I get: 07/15/10 12:09:47 Password Validation for user [usuario] failed! 07/15/10 12:09:47 Check for password aging/account lock-out. 07/15/10 12:09:47 listener-thread: err = -952: oserr = 0: errstr = usuario@urbano[Urbano]: User (usuario@urbano[Urbano])'s password is not correct for the database server. O usuário existe e o passwd_file também está configurado. Conforme eu disse, a conectividade está perfeita, mas o CM não sobe no Windows. The user exists and the passwd_file is also configured. As I said, the connectivity is perfect, but CM doesn't turns up on Windows. Pretendo liberar estas máquinas para produção brevemente mas não gostaria de apontar as conexões .NET diretamente para os servidores individualmente. Gostaria que fosse controlado pelo CM. I pretend to put these machines on production soon but I wouldn't like to point the .Net connections directly to the servers individually. I'd like to CM control this. Agradeço muito suas ajudas. I apreciate a lot your help. Abraços. Best regards. Urbano. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --0016368e259787d420048b7176f6
I am using the version 3.50.xC6, December 2009. -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Art Kagel Enviada em: quinta-feira, 15 de julho de 2010 15:42 Para: ids@iiug.org Assunto: Re: CONNECTION MANAGER WINDOWS [20571] You need SDK v3.50 or later tousethe CM. Art On Jul 15, 2010 2:29 PM, "RODEMIR URBANO DOS SANTOS" <r.urbano@terra.com.br> wrote: Olá amigos, Hello friends, PROBLEMAS COM O CONNECTION MANAGER NO WINDOWS ============================================= PROBLEMS WITH CONNECTION MANAGER ON WINDOWS =========================================== Estou montando 3 servidores rodando SUSE LINUX com Informix 11.50.FC6 I'm setting up 3 servers using SUSE LINUX with Informix 11.50.FC6 Um Primário, outro SDS e outro HDR. A Primary, other SDS and the other HDR. Configurei o CM pra rodar no PRI e SDS e foi de primeira. Os aplicativos caracter que tenho rodando nestes servidores em .4GL alternam perfeitamente entre eles. O Failover e LoadBalance é perfeito. I setted up the CM to run on PRI and SDS and it starts up fine. The .4GL programs running in these servers alternates well between them. The Failover and Loadbalance are perfect. Entretanto terei alguns servidores WEB que estarão acessando o informix nesta configuração e minha intenção era também implantar o loadbalance/failover. A linguagem a ser utilizada nestes servidores WEB é .NET e o SDK está com a última versão. However I'll have some WEB servers accessing the informix with this configuration and my goal is to also configure them with loadbalance/failover. The used language on these WEB servers is .Net and the SDK is the last version. Eu enchergo as 3 máquinas perfeitamente se a conexão for uma por uma. Conectividade funcionanado a contento. I can see the 3 machines perfectly individually. Connectivity is working fine. Entretanto ao subir o "Connection Manager" no Windows com a intenção de fazer PROXY para acessar as intancias no Linux não funciona. However when the CM turns on on Windows going to be a PROXY to access the instances on Linux it's not working. No LOG do CM no Windows eu tenho: On Windows' CM Log I get: 14:15:42 IBM Informix Connection Manager 14:15:42 Connection Manager name is cm_windows 14:15:42 Starting Connection Manager... 14:15:42 dbservername = cluster 14:15:42 nettype = 14:15:42 hostname = - 14:15:42 servicename = - 14:15:42 options = i=10 14:15:42 listener loadbalance initializing 14:15:42 create new thread 1132 for no1 [M:\\\\eo-csdk350-xC6-o-win64\\\\tristarm\\\\.\\\\asf\\\\cmsm\\\\cmsm_sla.c:651] 14:15:42 Listener loadbalance=(PRI+SDS) <MODE=PROXY> is active with 16 worker threads 14:15:42 CONNECT to sysmaster@no1|onsoctcp|192.168.115.82|1525 AS no10 USER abcz SQLCODE = (-951,2,usuario@urbano[Urbano]) [m:/eo-csdk350-xc6-o-win64/tristarm/./asf/cmsm/cmsm_server.ec:156] 14:15:43 Connection Manager started successfully 14:15:43 CONNECT to sysmaster@no1|onsoctcp|192.168.115.82|1525 AS no10 USER abcz SQLCODE = (-951,2,usuario@urbano[Urbano]) [m:/eo-csdk350-xc6-o-win64/tristarm/./asf/cmsm/cmsm_server.ec:156] 14:15:47 Error: monitor thread no1 fatal error, Connection Manager shut down No ONLINE.LOG do informix no LINUX eu tenho: On informix's ONLINE.LOG on LINUX I get: 07/15/10 12:09:47 Password Validation for user [usuario] failed! 07/15/10 12:09:47 Check for password aging/account lock-out. 07/15/10 12:09:47 listener-thread: err = -952: oserr = 0: errstr = usuario@urbano[Urbano]: User (usuario@urbano[Urbano])'s password is not correct for the database server. O usuário existe e o passwd_file também está configurado. Conforme eu disse, a conectividade está perfeita, mas o CM não sobe no Windows. The user exists and the passwd_file is also configured. As I said, the connectivity is perfect, but CM doesn't turns up on Windows. Pretendo liberar estas máquinas para produção brevemente mas não gostaria de apontar as conexões .NET diretamente para os servidores individualmente. Gostaria que fosse controlado pelo CM. I pretend to put these machines on production soon but I wouldn't like to point the .Net connections directly to the servers individually. I'd like to CM control this. Agradeço muito suas ajudas. I apreciate a lot your help. Abraços. Best regards. Urbano. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. --0016368e259787d420048b7176f6 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.
On the .net client? Art On Jul 15, 2010 3:10 PM, "Rodemir Urbano dos Santos" <r.urbano@terra.com.br> wrote: I am using the version 3.50.xC6, December 2009. -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Art Kagel Enviada em: quinta-feira, 15 de julho de 2010 15:42 Para: ids@iiug.org Assunto: Re: CONNECTION MANAGER WINDOWS [20571] You need SDK v3.50 or later tousethe CM. Art On Jul 15, 2010 2:29 PM, "RODEMIR URBANO DOS SANTOS" <r.urbano@terra.com.br> wrote: Olá amigos, Hello friends, PROBLEMAS COM O CONNECTION MANAGER NO WINDOWS ============================================= PROBLEMS WITH CONNECTION MANAGER ON WINDOWS =========================================== Estou montando 3 servidores rodando SUSE LINUX com Informix 11.50.FC6 I'm setting up 3 servers using SUSE LINUX with Informix 11.50.FC6 Um Primário, outro SDS e outro HDR. A Primary, other SDS and the other HDR. Configurei o CM pra rodar no PRI e SDS e foi de primeira. Os aplicativos caracter que tenho rodando nestes servidores em .4GL alternam perfeitamente entre eles. O Failover e LoadBalance é perfeito. I setted up the CM to run on PRI and SDS and it starts up fine. The .4GL programs running in these servers alternates well between them. The Failover and Loadbalance are perfect. Entretanto terei alguns servidores WEB que estarão acessando o informix nesta configuração e minha intenção era também implantar o loadbalance/failover. A linguagem a ser utilizada nestes servidores WEB é ..NET e o SDK está com a última versão. However I'll have some WEB servers accessing the informix with this configuration and my goal is to also configure them with loadbalance/failover. The used language on these WEB servers is .Net and the SDK is the last version. Eu enchergo as 3 máquinas perfeitamente se a conexão for uma por uma. Conectividade funcionanado a contento. I can see the 3 machines perfectly individually. Connectivity is working fine. Entretanto ao subir o "Connection Manager" no Windows com a intenção de fazer PROXY para acessar as intancias no Linux não funciona. However when the CM turns on on Windows going to be a PROXY to access the instances on Linux it's not working. No LOG do CM no Windows eu tenho: On Windows' CM Log I get: 14:15:42 IBM Informix Connection Manager 14:15:42 Connection Manager name is cm_windows 14:15:42 Starting Connection Manager... 14:15:42 dbservername = cluster 14:15:42 nettype = 14:15:42 hostname = - 14:15:42 servicename = - 14:15:42 options = i=10 14:15:42 listener loadbalance initializing 14:15:42 create new thread 1132 for no1 [M:\\\\eo-csdk350-xC6-o-win64\\\\tristarm\\\\.\\\\asf\\\\cmsm\\\\cmsm_sla.c:651] 14:15:42 Listener loadbalance=(PRI+SDS) <MODE=PROXY> is active with 16 worker threads 14:15:42 CONNECT to sysmaster@no1|onsoctcp|192.168.115.82|1525 AS no10 USER abcz SQLCODE = (-951,2,usuario@urbano[Urbano]) [m:/eo-csdk350-xc6-o-win64/tristarm/./asf/cmsm/cmsm_server.ec:156] 14:15:43 Connection Manager started successfully 14:15:43 CONNECT to sysmaster@no1|onsoctcp|192.168.115.82|1525 AS no10 USER abcz SQLCODE = (-951,2,usuario@urbano[Urbano]) [m:/eo-csdk350-xc6-o-win64/tristarm/./asf/cmsm/cmsm_server.ec:156] 14:15:47 Error: monitor thread no1 fatal error, Connection Manager shut down No ONLINE.LOG do informix no LINUX eu tenho: On informix's ONLINE.LOG on LINUX I get: 07/15/10 12:09:47 Password Validation for user [usuario] failed! 07/15/10 12:09:47 Check for password aging/account lock-out. 07/15/10 12:09:47 listener-thread: err = -952: oserr = 0: errstr = usuario@urbano[Urbano]: User (usuario@urbano[Urbano])'s password is not correct for the database server. O usuário existe e o passwd_file também está configurado. Conforme eu disse, a conectividade está perfeita, mas o CM não sobe no Windows. The user exists and the passwd_file is also configured. As I said, the connectivity is perfect, but CM doesn't turns up on Windows. Pretendo liberar estas máquinas para produção brevemente mas não gostaria de apontar as conexões .NET diretamente para os servidores individualmente. Gostaria que fosse controlado pelo CM. I pretend to put these machines on production soon but I wouldn't like to point the .Net connections directly to the servers individually. I'd like to CM control this. Agradeço muito suas ajudas. I apreciate a lot your help. Abraços. Best regards. Urbano. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. --0016368e259787d420048b7176f6 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --000e0cd25b00108337048b725d42
Yes, but not yet arrived in the application because the CM did not rise. The application is connected directly to any of the machines work. Urbano. -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Art Kagel Enviada em: quinta-feira, 15 de julho de 2010 16:47 Para: ids@iiug.org Assunto: Re: RES: CONNECTION MANAGER WINDOWS [20573] On the .net client? Art On Jul 15, 2010 3:10 PM, "Rodemir Urbano dos Santos" <r.urbano@terra.com.br> wrote: I am using the version 3.50.xC6, December 2009. -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Art Kagel Enviada em: quinta-feira, 15 de julho de 2010 15:42 Para: ids@iiug.org Assunto: Re: CONNECTION MANAGER WINDOWS [20571] You need SDK v3.50 or later tousethe CM. Art On Jul 15, 2010 2:29 PM, "RODEMIR URBANO DOS SANTOS" <r.urbano@terra.com.br> wrote: Olá amigos, Hello friends, PROBLEMAS COM O CONNECTION MANAGER NO WINDOWS ============================================= PROBLEMS WITH CONNECTION MANAGER ON WINDOWS =========================================== Estou montando 3 servidores rodando SUSE LINUX com Informix 11.50.FC6 I'm setting up 3 servers using SUSE LINUX with Informix 11.50.FC6 Um Primário, outro SDS e outro HDR. A Primary, other SDS and the other HDR. Configurei o CM pra rodar no PRI e SDS e foi de primeira. Os aplicativos caracter que tenho rodando nestes servidores em .4GL alternam perfeitamente entre eles. O Failover e LoadBalance é perfeito. I setted up the CM to run on PRI and SDS and it starts up fine. The .4GL programs running in these servers alternates well between them. The Failover and Loadbalance are perfect. Entretanto terei alguns servidores WEB que estarão acessando o informix nesta configuração e minha intenção era também implantar o loadbalance/failover. A linguagem a ser utilizada nestes servidores WEB é ...NET e o SDK está com a última versão. However I'll have some WEB servers accessing the informix with this configuration and my goal is to also configure them with loadbalance/failover. The used language on these WEB servers is .Net and the SDK is the last version. Eu enchergo as 3 máquinas perfeitamente se a conexão for uma por uma. Conectividade funcionanado a contento. I can see the 3 machines perfectly individually. Connectivity is working fine. Entretanto ao subir o "Connection Manager" no Windows com a intenção de fazer PROXY para acessar as intancias no Linux não funciona. However when the CM turns on on Windows going to be a PROXY to access the instances on Linux it's not working. No LOG do CM no Windows eu tenho: On Windows' CM Log I get: 14:15:42 IBM Informix Connection Manager 14:15:42 Connection Manager name is cm_windows 14:15:42 Starting Connection Manager... 14:15:42 dbservername = cluster 14:15:42 nettype = 14:15:42 hostname = - 14:15:42 servicename = - 14:15:42 options = i=10 14:15:42 listener loadbalance initializing 14:15:42 create new thread 1132 for no1 [M:\\\\eo-csdk350-xC6-o-win64\\\\tristarm\\\\.\\\\asf\\\\cmsm\\\\cmsm_sla.c:651] 14:15:42 Listener loadbalance=(PRI+SDS) <MODE=PROXY> is active with 16 worker threads 14:15:42 CONNECT to sysmaster@no1|onsoctcp|192.168.115.82|1525 AS no10 USER abcz SQLCODE = (-951,2,usuario@urbano[Urbano]) [m:/eo-csdk350-xc6-o-win64/tristarm/./asf/cmsm/cmsm_server.ec:156] 14:15:43 Connection Manager started successfully 14:15:43 CONNECT to sysmaster@no1|onsoctcp|192.168.115.82|1525 AS no10 USER abcz SQLCODE = (-951,2,usuario@urbano[Urbano]) [m:/eo-csdk350-xc6-o-win64/tristarm/./asf/cmsm/cmsm_server.ec:156] 14:15:47 Error: monitor thread no1 fatal error, Connection Manager shut down No ONLINE.LOG do informix no LINUX eu tenho: On informix's ONLINE.LOG on LINUX I get: 07/15/10 12:09:47 Password Validation for user [usuario] failed! 07/15/10 12:09:47 Check for password aging/account lock-out. 07/15/10 12:09:47 listener-thread: err = -952: oserr = 0: errstr = usuario@urbano[Urbano]: User (usuario@urbano[Urbano])'s password is not correct for the database server. O usuário existe e o passwd_file também está configurado. Conforme eu disse, a conectividade está perfeita, mas o CM não sobe no Windows. The user exists and the passwd_file is also configured. As I said, the connectivity is perfect, but CM doesn't turns up on Windows. Pretendo liberar estas máquinas para produção brevemente mas não gostaria de apontar as conexões .NET diretamente para os servidores individualmente. Gostaria que fosse controlado pelo CM. I pretend to put these machines on production soon but I wouldn't like to point the .Net connections directly to the servers individually. I'd like to CM control this. Agradeço muito suas ajudas. I apreciate a lot your help. Abraços. Best regards. Urbano. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. --0016368e259787d420048b7176f6 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. --000e0cd25b00108337048b725d42 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.