HDR Cannot connect

I have one little problem here with trying to get my HDR to start up. I know it is something that I have misunderstood along the way in my reading. Can someone take a quick look at this? Primary: hosts file in /etc has the ip of Linux server name of Primary and Linux server name of Secondary. hosts.equiv in /etc has newserverS_hdr which is in my onconfig under DBSERVERALIASES onconfig has DBSERVERNAME newserver DBSERVERALIASES newserver_hdr sqlhosts file newserver onipschm linux primary server name newserver newserver_hdr onsoctcp linux primary server name newserver_hdr s=1 newserverS_hdr onsoctcp linux secondary server name newserverS_hdr s=1 Secondary: host file same as primary above host.eqiv newserver_hdr onconfig DBSERVERNAME newserverS DBSERVERALIASES newserver_hdr sqlhosts file newsererS onipschm linux secondary server name newserverS newserverS_hdr onsoctcp linux secondary server name newserverS_hdr s=1 newserver_hdr onsoctcp linux primary server name newserver_hdr s=1 I have tried a number of things to tee it up, but I assume I have something wrong here. From the primary, I thought I run this command onmode -d secondary newserver_hdr

in the secondary, I have a typo. DBSERVERALIASES is supposed to be newserverS_hdr

I wanted to add that I didn't solve this. My original post had a typo in it and I can't see how to edit a post on here.

Which version of Linux are you using? A) First try and ping between the two machines in both directions, first ping with ipaddress then ping with hostname: ping 192.16.1.23 ping myhost B) download then telnet program E.g for CentOS As root yum whatprovides telnet # returns telnet-0.17-60.el7.x86_64 yum install telnet-0.17-60.el7.x86_64 C0 See if telnet can connect to the host and port between machines telnet myhost myport and see if the connection is allowed. One thing you may need to do is to open a port on the linux firewall to allow connections E.g. for CentOS something like sudo firewall-cmd --zone=public --add-port=1433/tcp --permanent sudo firewall-cmd --reload Regards, David. > On 26 April 2017 at 12:47 BENJI LONG <ruggedmouse@hotmail.com> wrote: > > > I wanted to add that I didn't solve this. My original post had a typo in it > and I can't see how to edit a post on here. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Hi, do I have everything configured correctly up to this point? It is Red Hat Enterprise release 7.1 Maipo Ping works both ways. Not like I was expecting like I see in Windows though. I ping the ip and it keeps doing its thing until I hit control C, and then it tells me no packets lost. Telnet fails. I forgot to post what I have in /etc/services. Do I need the linux server name or do I need what is in my sqlhosts file for tcp? On both servers, I have what I put in my sqlhosts file under onisoctcp I have in /etc/services newserver_hdr 1112/tcp newserverS_hdr 1113/tcp

Try telnet <ip> <informix port> <return><return> If you see don't see error -408 in the informix log you don't have comms configured like you think you have Cheers Paul > Hi, do I have everything configured correctly up to this point? > > It is Red Hat Enterprise release 7.1 Maipo > > Ping works both ways. Not like I was expecting like I see in Windows > though. I > ping the ip and it keeps doing its thing until I hit control C, and then > it > tells me no packets lost. > > Telnet fails. > > I forgot to post what I have in /etc/services. Do I need the linux server > name > or do I need what is in my sqlhosts file for tcp? > > On both servers, I have what I put in my sqlhosts file under onisoctcp > > I have in /etc/services > newserver_hdr 1112/tcp > newserverS_hdr 1113/tcp > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com Oninit® is a registered trademark of Oninit LLC Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. What this country needs are more unemployed politicians

Hi, when you say informix port, is that the port I put into the /etc/services file? So in my case it would be 1113?

Dear Benji: I usually test my connection between the HDR pair beforehand by initiating a DBACCESS session from one server to the other and visa versa. This will let you know if one instance can see the other, can connect to it, and if you are authenticating. Good luck. Best regards, Martin M. Graney Queues Enforth Development, Inc. This electronic message contains information which may be privileged, confidential, or otherwise protected from disclosure. The information contained herein is intended for the addressee or recipient only. If you are not the addressee, or not the intended recipient, any disclosure, copying, distribution, or use of the contents of this message (including any attachments) is prohibited. If you have received this electronic message in error, please notify the sender immediately and destroy the original message and all copies. (Queues Enforth Development, Inc.) -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of BENJI LONG Sent: Wednesday, April 26, 2017 9:58 AM To: ids@iiug.org Subject: Re: HDR Cannot connect [39049] Hi, when you say informix port, is that the port I put into the /etc/services file? So in my case it would be 1113? ************************************************************************** ***** Forum Note: Use "Reply" to post a response in the discussion forum.

I tried that. I ran the command dbacces and then in the menu, I chose "connect" but nothing displays. I take it that if I did that correctly, then I have issues with how this is all setup, but I can't figure it out...ugh

ok, I hit "connection" and then connect, and my other instance shows up! So what is that telling me?

I put in my user and password and it said running... and then ended with: 908 Attempt to connect to database server newserverS failed. ISAM error: record is locked I tried to login with the user I log into the server with. After that I sudo su - informix to get to the informix user, so I'm not sure what I am supposed to connect with through dbaccess

If I connect to the instance on the local machine, I can connect. If I try and connect to the instance on the remote machine, it fails...darn.

Dear Benji: I would look in the remote systems IDS message log and see if there is an authentication failure. If so you may need to make changes to the security on the instance you are connecting to (i.e. hosts.equiv file, ...) Best regards, Martin M. Graney Queues Enforth Development, Inc. This electronic message contains information which may be privileged, confidential, or otherwise protected from disclosure. The information contained herein is intended for the addressee or recipient only. If you are not the addressee, or not the intended recipient, any disclosure, copying, distribution, or use of the contents of this message (including any attachments) is prohibited. If you have received this electronic message in error, please notify the sender immediately and destroy the original message and all copies. (Queues Enforth Development, Inc.) -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of BENJI LONG Sent: Wednesday, April 26, 2017 11:49 AM To: ids@iiug.org Subject: Re: RE: HDR Cannot connect [39054] If I connect to the instance on the local machine, I can connect. If I try and connect to the instance on the remote machine, it fails...darn. ************************************************************************** ***** Forum Note: Use "Reply" to post a response in the discussion forum.

An error message/number is always useful :-) > If I connect to the instance on the local machine, I can connect. > > If I try and connect to the instance on the remote machine, it > fails...darn. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com Oninit® is a registered trademark of Oninit LLC Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. What this country needs are more unemployed politicians

Tried what ? > I tried that. I ran the command dbacces and then in the menu, I chose > "connect" but nothing displays. > > I take it that if I did that correctly, then I have issues with how this > is > all setup, but I can't figure it out...ugh > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com Oninit® is a registered trademark of Oninit LLC Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. What this country needs are more unemployed politicians

I think my post became convoluted and nobody knows what the other is asking now...ugh.

I think I found one issue. From the literature: DBSERVERALIASES must not include uppercase characters So that means my newserverS is no good. I thought that is what Lester used in his webcast, but I must be mistaken.

Dear Benji: If you are using server alias make sure you can connect to the instance with the alias on the sever that you've created the alias for first. If that works then try connecting from the remote server with the alias. Best regards, Martin M. Graney Queues Enforth Development, Inc. This electronic message contains information which may be privileged, confidential, or otherwise protected from disclosure. The information contained herein is intended for the addressee or recipient only. If you are not the addressee, or not the intended recipient, any disclosure, copying, distribution, or use of the contents of this message (including any attachments) is prohibited. If you have received this electronic message in error, please notify the sender immediately and destroy the original message and all copies. (Queues Enforth Development, Inc.) -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of BENJI LONG Sent: Wednesday, April 26, 2017 2:41 PM To: ids@iiug.org Subject: Re: RE: HDR Cannot connect [39059] I think I found one issue. From the literature: DBSERVERALIASES must not include uppercase characters So that means my newserverS is no good. I thought that is what Lester used in his webcast, but I must be mistaken. ************************************************************************** ***** Forum Note: Use "Reply" to post a response in the discussion forum.

Hi, do you mean connect to the instance through dbaccess?

Dear Benji: Yes connect to the local instance through DBACCESS but use the alias you created to make sure that it is functioning locally. Best regards, Martin M. Graney Queues Enforth Development, Inc. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of BENJI LONG Sent: Wednesday, April 26, 2017 5:07 PM To: ids@iiug.org Subject: Re: RE: RE: HDR Cannot connect [39061] Hi, do you mean connect to the instance through dbaccess? ************************************************************************** ***** Forum Note: Use "Reply" to post a response in the discussion forum.