Oninit cdi / Archive
Talk to an expert →

HDR Connectivity (IDS 10.0)

Posted in 2007

Summary

Dileep couldn't start HDR between two Linux IDS 10.00.UC4X2 servers: both sides logged "DR: Cannot connect to secondary/primary server". Suggestions included that sqlhosts pointed the listeners at localhost instead of the real interface (check netstat -atn), setting up trust via ~informix/.rhosts or /etc/hosts.equiv, removing /etc/hosts aliases, using the correct INFORMIXSERVER names in onmode -d, and testing a plain dbaccess connection. Fixing sqlhosts and trust wasn't enough; the real cause was a firewall - traffic from secondary back to primary was blocked. Clearing the iptables rules on the secondary made HDR work.

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

Topics: High Availability & Replication, Server Administration, Networking & sqlhosts Configuration, Platform-Specific Issues, Versions, Editions & End-of-Life

DILEEP NARAYANAN NAIR — — source: IIUG Forums & Mailing Lists

Hi, I am using IDS version 10.00.UC4X2 on linux and is setting up HDR for the first time. I get the "cannot connect" messages on both the primary and secondary servers. I have various network settings as follows. Did I miss anything? Thanks for your help, Dileep /etc/hosts ========== primary (IP: 172.27.27.3) ------- 127.0.0.1 localhost.localdomain localhost 172.27.27.3 primary.domain.com primary 172.27.27.10 secondary.domaincom secondary secondary (IP: 172.27.27.10) --------- 127.0.0.1 localhost.localdomain localhost 172.27.27.3 primary.domain.com primary 172.27.27.10 secondary.domaincom secondary /etc/services ============= primary ------- server_tcp 2001/tcp hdr_tcp 2007/tcp secondary --------- server_tcp 2001/tcp hdr_tcp 2007/tcp $INFORMIXDIR/etc/sqlhosts ========================= primary ------- server onsoctcp localhost server_tcp PrimaryDB onsoctcp localhost hdr_tcp SecondaryDB onsoctcp secondary hdr_tcp secondary --------- server onsoctcp localhost server_tcp SecondaryDB onsoctcp localhost hdr_tcp PrimaryDB onsoctcp primary hdr_tcp Command used for HDR ===================== primary ------- onmode -d primary SecondaryDB secondary --------- onmode -d secondary PrimaryDB

↪ replying to DILEEP NARAYANAN NAIR
Alexey Sonkin — — source: IIUG Forums & Mailing Lists

Hi, Dileep, On both of your machines, Informix listener is started only on 127.0.0.1, and not started on any real network interface... Just do 'netstat -atn', and you will see. Also, don't forget to create ~informix/.rhosts or /etc/hosts.equiv -Alexey > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of DILEEP > NARAYANAN NAIR > Sent: Wednesday, April 18, 2007 3:00 PM > To: ids@iiug.org > Subject: HDR Connectivity (IDS 10.0) [8964] > > Hi, > > I am using IDS version 10.00.UC4X2 on linux and is setting up HDR for the > first time. I get the "cannot connect" messages on both the primary and > secondary servers. > > I have various network settings as follows. Did I miss anything? > > Thanks for your help, > Dileep > > /etc/hosts > ========== > primary (IP: 172.27.27.3) > ------- > 127.0.0.1 localhost.localdomain localhost > 172.27.27.3 primary.domain.com primary > 172.27.27.10 secondary.domaincom secondary > > secondary (IP: 172.27.27.10) > --------- > 127.0.0.1 localhost.localdomain localhost > 172.27.27.3 primary.domain.com primary > 172.27.27.10 secondary.domaincom secondary > > /etc/services > ============= > primary > ------- > server_tcp 2001/tcp > hdr_tcp 2007/tcp > > secondary > --------- > server_tcp 2001/tcp > hdr_tcp 2007/tcp > > $INFORMIXDIR/etc/sqlhosts > ========================= > primary > ------- > server onsoctcp localhost server_tcp > > PrimaryDB onsoctcp localhost hdr_tcp > > SecondaryDB onsoctcp secondary hdr_tcp> > secondary > --------- > server onsoctcp localhost server_tcp > > SecondaryDB onsoctcp localhost hdr_tcp > > PrimaryDB onsoctcp primary hdr_tcp> > Command used for HDR > ===================== > primary > ------- > onmode -d primary SecondaryDB> > secondary > --------- > onmode -d secondary PrimaryDB> > > ************************************************************************ ****** > * > Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Alexey Sonkin
Robert Roussey\\\\(IT\\\\) — — source: IIUG Forums & Mailing Lists

Try /etc/hosts first, if that doesn't do it, try the informix/.rhosts. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Alexey Sonkin Sent: Wednesday, April 18, 2007 4:17 PM To: ids@iiug.org Subject: RE: HDR Connectivity (IDS 10.0) [8965] Hi, Dileep, On both of your machines, Informix listener is started only on 127.0.0.1, and not started on any real network interface... Just do 'netstat -atn', and you will see. Also, don't forget to create ~informix/.rhosts or /etc/hosts.equiv -Alexey > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of DILEEP > NARAYANAN NAIR > Sent: Wednesday, April 18, 2007 3:00 PM > To: ids@iiug.org > Subject: HDR Connectivity (IDS 10.0) [8964] > > Hi, > > I am using IDS version 10.00.UC4X2 on linux and is setting up HDR for the > first time. I get the "cannot connect" messages on both the primary and > secondary servers. > > I have various network settings as follows. Did I miss anything? > > Thanks for your help, > Dileep > > /etc/hosts > ========== > primary (IP: 172.27.27.3) > ------- > 127.0.0.1 localhost.localdomain localhost > 172.27.27.3 primary.domain.com primary > 172.27.27.10 secondary.domaincom secondary > > secondary (IP: 172.27.27.10) > --------- > 127.0.0.1 localhost.localdomain localhost > 172.27.27.3 primary.domain.com primary > 172.27.27.10 secondary.domaincom secondary > > /etc/services > ============= > primary > ------- > server_tcp 2001/tcp > hdr_tcp 2007/tcp > > secondary > --------- > server_tcp 2001/tcp > hdr_tcp 2007/tcp > > $INFORMIXDIR/etc/sqlhosts > ========================= > primary > ------- > server onsoctcp localhost server_tcp > > PrimaryDB onsoctcp localhost hdr_tcp > > SecondaryDB onsoctcp secondary hdr_tcp> > secondary > --------- > server onsoctcp localhost server_tcp > > SecondaryDB onsoctcp localhost hdr_tcp > > PrimaryDB onsoctcp primary hdr_tcp> > Command used for HDR > ===================== > primary > ------- > onmode -d primary SecondaryDB> > secondary > --------- > onmode -d secondary PrimaryDB> > > ************************************************************************ ****** > * > Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Robert Roussey\\\\(IT\\\\)
Robert Roussey\\\\(IT\\\\) — — source: IIUG Forums & Mailing Lists

Sorry, /etc/hosts.equiv. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Robert Roussey(IT) Sent: Wednesday, April 18, 2007 4:26 PM To: ids@iiug.org Subject: RE: HDR Connectivity (IDS 10.0) [8966] Try /etc/hosts first, if that doesn't do it, try the informix/.rhosts. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Alexey Sonkin Sent: Wednesday, April 18, 2007 4:17 PM To: ids@iiug.org Subject: RE: HDR Connectivity (IDS 10.0) [8965] Hi, Dileep, On both of your machines, Informix listener is started only on 127.0.0.1, and not started on any real network interface... Just do 'netstat -atn', and you will see. Also, don't forget to create ~informix/.rhosts or /etc/hosts.equiv -Alexey > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of DILEEP > NARAYANAN NAIR > Sent: Wednesday, April 18, 2007 3:00 PM > To: ids@iiug.org > Subject: HDR Connectivity (IDS 10.0) [8964] > > Hi, > > I am using IDS version 10.00.UC4X2 on linux and is setting up HDR for the > first time. I get the "cannot connect" messages on both the primary and > secondary servers. > > I have various network settings as follows. Did I miss anything? > > Thanks for your help, > Dileep > > /etc/hosts > ========== > primary (IP: 172.27.27.3) > ------- > 127.0.0.1 localhost.localdomain localhost > 172.27.27.3 primary.domain.com primary > 172.27.27.10 secondary.domaincom secondary > > secondary (IP: 172.27.27.10) > --------- > 127.0.0.1 localhost.localdomain localhost > 172.27.27.3 primary.domain.com primary > 172.27.27.10 secondary.domaincom secondary > > /etc/services > ============= > primary > ------- > server_tcp 2001/tcp > hdr_tcp 2007/tcp > > secondary > --------- > server_tcp 2001/tcp > hdr_tcp 2007/tcp > > $INFORMIXDIR/etc/sqlhosts > ========================= > primary > ------- > server onsoctcp localhost server_tcp > > PrimaryDB onsoctcp localhost hdr_tcp > > SecondaryDB onsoctcp secondary hdr_tcp> > secondary > --------- > server onsoctcp localhost server_tcp > > SecondaryDB onsoctcp localhost hdr_tcp > > PrimaryDB onsoctcp primary hdr_tcp> > Command used for HDR > ===================== > primary > ------- > onmode -d primary SecondaryDB> > secondary > --------- > onmode -d secondary PrimaryDB> > > ************************************************************************ ****** > * > Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Robert Roussey\\\\(IT\\\\)
Juan Pablo — — source: IIUG Forums & Mailing Lists

Delete Aliases in /etc/hosts Example: /etc/hosts ========== primary (IP: 172.27.27.3) ------- 172.27.27.3 primary 172.27.27.10 secondary secondary (IP: 172.27.27.10) --------- 172.27.27.3 primary 172.27.27.10 secondary bye The freedom of Linux ... The power of Informix Dele >From: "Robert Roussey(IT)" <Robert.Roussey@SpiritAir.com> >Reply-To: ids@iiug.org >To: ids@iiug.org >Subject: RE: HDR Connectivity (IDS 10.0) [8967] >Date: Wed, 18 Apr 2007 16:27:50 -0400 (EDT) > >Sorry, /etc/hosts.equiv. > >Bob Roussey >Unix / Informix Administration >Spirit Airlines >Robert.Roussey@SpiritAir.com > >-----Original Message----- >From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of >Robert Roussey(IT) >Sent: Wednesday, April 18, 2007 4:26 PM >To: ids@iiug.org >Subject: RE: HDR Connectivity (IDS 10.0) [8966] > >Try /etc/hosts first, if that doesn't do it, try the informix/.rhosts. > >Bob Roussey >Unix / Informix Administration >Spirit Airlines >Robert.Roussey@SpiritAir.com > >-----Original Message----- >From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of >Alexey Sonkin >Sent: Wednesday, April 18, 2007 4:17 PM >To: ids@iiug.org >Subject: RE: HDR Connectivity (IDS 10.0) [8965] > >Hi, Dileep, > >On both of your machines, Informix listener is started only >on 127.0.0.1, and not started on any real network interface... >Just do 'netstat -atn', and you will see. > >Also, don't forget to create ~informix/.rhosts or /etc/hosts.equiv > >-Alexey > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of >DILEEP > > NARAYANAN NAIR > > Sent: Wednesday, April 18, 2007 3:00 PM > > To: ids@iiug.org > > Subject: HDR Connectivity (IDS 10.0) [8964] > > > > Hi, > > > > I am using IDS version 10.00.UC4X2 on linux and is setting up HDR for >the > > first time. I get the "cannot connect" messages on both the primary >and > > secondary servers. > > > > I have various network settings as follows. Did I miss anything? > > > > Thanks for your help, > > Dileep > > > > /etc/hosts > > ========== > > primary (IP: 172.27.27.3) > > ------- > > 127.0.0.1 localhost.localdomain localhost > > 172.27.27.3 primary.domain.com primary > > 172.27.27.10 secondary.domaincom secondary > > > > secondary (IP: 172.27.27.10) > > --------- > > 127.0.0.1 localhost.localdomain localhost > > 172.27.27.3 primary.domain.com primary > > 172.27.27.10 secondary.domaincom secondary > > > > /etc/services > > ============= > > primary > > ------- > > server_tcp 2001/tcp > > hdr_tcp 2007/tcp > > > > secondary > > --------- > > server_tcp 2001/tcp > > hdr_tcp 2007/tcp > > > > $INFORMIXDIR/etc/sqlhosts > > ========================= > > primary > > ------- > > server onsoctcp localhost server_tcp > > > > PrimaryDB onsoctcp localhost hdr_tcp > > > > SecondaryDB onsoctcp secondary hdr_tcp> > > > secondary > > --------- > > server onsoctcp localhost server_tcp > > > > SecondaryDB onsoctcp localhost hdr_tcp > > > > PrimaryDB onsoctcp primary hdr_tcp> > > > Command used for HDR > > ===================== > > primary > > ------- > > onmode -d primary SecondaryDB> > > > secondary > > --------- > > onmode -d secondary PrimaryDB> > > > > > >************************************************************************ > >****** > > * > > Forum Note: Use "Reply" to post a response in the discussion forum. > >************************************************************************ > >******* >Forum Note: Use "Reply" to post a response in the discussion forum. > >************************************************************************ >******* >Forum Note: Use "Reply" to post a response in the discussion forum. > > >******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > te _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/

↪ replying to Juan Pablo
DILEEP NARAYANAN NAIR — — source: IIUG Forums & Mailing Lists

Hi, Thanks all for your responses. I configured /etc/hosts.equiv and ~informix/.rhosts to contain + to accept all servers, in both the machines. I also modified sqlhosts as follows. primary ------- server onsoctcp localhost server_tcpprimary onsoctcp <local machine name> hdr_tcp secondary onsoctcp <secondary/remote machine name> hdr_tcp secondary ---------- server onsoctcp localhost server_tcpsecondary onsoctcp <local machine name> hdr_tcp primary onsoctcp <primary/remote machine name> hdr_tcp After this sqlhost change, 'netstat -atn' shows listeners started on other interfaces like ... tcp 0 0 172.27.27.3:2007 0.0.0.0:* LISTEN 2007 is my hdr port number. I still get the connection errors though. I tried with removing aliases in /etc/hosts also. I run the 'onmode -d primary secondary' command when primary IDS is in online mode and 'onmode -d secondary primary' command when the secondary is in the 'Fast Recovery' mode. Is it ok? The errors are: 09:30:26 DR: new type = primary, secondary server name = SecondaryMP 09:30:33 Dynamically allocated new virtual shared memory segment (size 8192KB) 09:31:27 DR: Cannot connect to secondary server 09:31:27 DR: Turned off on primary server 09:31:31 DR: Cannot connect to secondary server 09:31:31 DR: Turned off on primary server and 17:19:50 DR: new type = secondary, primary server name = PrimaryMP 17:19:50 DR: Trying to connect to primary server = PrimaryMP [The command 'onmode -d secondary primary' returns immediately] Thanks, Dileep

↪ replying to DILEEP NARAYANAN NAIR
Marcus Haarmann — — source: IIUG Forums & Mailing Lists

Hi, I did not try a setup with different ports for HDR than for IDS itself, so I am not sure if this will work. My idea of HDR was always that the second parameter for onmode -d was the machine name (as an alias in /etc/hosts or DNS) and not the informixserver value. So, you should try to call onmode -d primary <machine_name secondary server>and onmode -d secondary <machine_name primary server> Marcus ----- Originalnachricht ----- Von: DILEEP NARAYANAN NAIR <ndileep@cisco.com> Gesendet: Don, 19.4.2007 02:39 An: ids@iiug.org Betreff: Re: RE: HDR Connectivity (IDS 10.0) [8969] Hi, Thanks all for your responses. I configured /etc/hosts.equiv and ~informix/.rhosts to contain + to accept all servers, in both the machines. I also modified sqlhosts as follows. primary ------- server onsoctcp localhost server_tcpprimary onsoctcp <local machine name> hdr_tcp secondary onsoctcp <secondary/remote machine name> hdr_tcp secondary ---------- server onsoctcp localhost server_tcpsecondary onsoctcp <local machine name> hdr_tcp primary onsoctcp <primary/remote machine name> hdr_tcp After this sqlhost change, 'netstat -atn' shows listeners started on other interfaces like ... tcp 0 0 172.27.27.3:2007 0.0.0.0:* LISTEN 2007 is my hdr port number. I still get the connection errors though. I tried with removing aliases in /etc/hosts also. I run the 'onmode -d primary secondary' command when primary IDS is in online mode and 'onmode -d secondary primary' command when the secondary is in the 'Fast Recovery' mode. Is it ok? The errors are: 09:30:26 DR: new type = primary, secondary server name = SecondaryMP 09:30:33 Dynamically allocated new virtual shared memory segment (size 8192KB) 09:31:27 DR: Cannot connect to secondary server 09:31:27 DR: Turned off on primary server 09:31:31 DR: Cannot connect to secondary server 09:31:31 DR: Turned off on primary server and 17:19:50 DR: new type = secondary, primary server name = PrimaryMP 17:19:50 DR: Trying to connect to primary server = PrimaryMP [The command 'onmode -d secondary primary' returns immediately] Thanks, Dileep ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Marcus Haarmann
André Luiz Rufino — — source: IIUG Forums & Mailing Lists

Hi, HDR just need to see the secondary server. Just like you would do to connect to another informixserver. The both sqlhosts ( on primary and secondary informix server ) must to have its lines on sqlhosts file. so if you want to make the informix server "mickey" on hostsname "disney" works, you would have on sqlhosts file mickey ipcshm disney mickey mickey_tcp onsoctcp disney mickey_tcp considering /etc/services in the example above mickey_tcp 1526/tcp and now the configuration of informix server "thor" on hostsname "marvel" thor ipcshm marvel thor thor_tcp ipcshm marvel thor_tcp considering /etc/services in the example above thor_tcp 1527/tcp You need just one more line in each sqlhosts file , so they must to be like this: in disney machine mickey ipcshm disney mickey mickey_tcp onsoctcp disney mickey_tcpthor_tcp ipcshm marvel thor_tcp and in marvel machine thor ipcshm marvel thor thor_tcp ipcshm marvel thor_tcp mickey_tcp onsoctcp disney mickey_tcp and /etc/services in both machines: mickey_tcp 1526/tcpthor_tcp 1527/tcp After make the trusted connection between machines and archive and restore sincronizing, you just execute de onmode -d using only informixserver names so, in primary server disney:/>onmode -d primary thor_tcp and in secondary machine marvel:/>onmode -d secondary mickey_tcp Just like that Good luck !!! André Luiz > To: ids@iiug.org> From: marcus.haarmann@midoco.de> Subject: AW: RE: HDR Connectivity (IDS 10.0) [8970]> Date: Thu, 19 Apr 2007 07:03:01 -0400> > Hi, > > I did not try a setup with different ports for HDR than for IDS itself, so I > am not sure if this will work. > > My idea of HDR was always that the second parameter for onmode -d was the > machine name (as an alias in /etc/hosts or DNS) and not the informixserver > value. > > So, you should try to call > onmode -d primary <machine_name secondary server> > and > onmode -d secondary <machine_name primary server> > > Marcus > > ----- Originalnachricht ----- > Von: DILEEP NARAYANAN NAIR <ndileep@cisco.com> > Gesendet: Don, 19.4.2007 02:39 > An: ids@iiug.org > Betreff: Re: RE: HDR Connectivity (IDS 10.0) [8969] > > Hi, > > Thanks all for your responses. I configured /etc/hosts.equiv and >~informix/.rhosts to contain + to accept all servers, in both the machines. > > I also modified sqlhosts as follows. > > primary > ------- > server onsoctcp localhost server_tcp > primary onsoctcp <local machine name> hdr_tcp > secondary onsoctcp <secondary/remote machine name> hdr_tcp > > secondary > ---------- > server onsoctcp localhost server_tcp > secondary onsoctcp <local machine name> hdr_tcp > primary onsoctcp <primary/remote machine name> hdr_tcp > > After this sqlhost change, 'netstat -atn' shows listeners started on other > interfaces like ... > > tcp 0 0 172.27.27.3:2007 0.0.0.0:* LISTEN > > 2007 is my hdr port number. > > I still get the connection errors though. I tried with removing aliases in > /etc/hosts also. > > I run the 'onmode -d primary secondary' command when primary IDS is in online > mode and 'onmode -d secondary primary' command when the secondary is in the > 'Fast Recovery' mode. Is it ok? > > The errors are: > > 09:30:26 DR: new type = primary, secondary server name = SecondaryMP > 09:30:33 Dynamically allocated new virtual shared memory segment (size 8192KB) > 09:31:27 DR: Cannot connect to secondary server > 09:31:27 DR: Turned off on primary server > 09:31:31 DR: Cannot connect to secondary server > 09:31:31 DR: Turned off on primary server > > and > > 17:19:50 DR: new type = secondary, primary server name = PrimaryMP > 17:19:50 DR: Trying to connect to primary server = PrimaryMP > [The command 'onmode -d secondary primary' returns immediately] > > Thanks, > Dileep > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Ligue para os amigos com a Chamada de PC para PC - GRATUITO http://get.live.com/messenger/overview

↪ replying to André Luiz Rufino
Peter van Eck — — source: IIUG Forums & Mailing Lists

4GB as goes for all 32-bit OS'es Varies a bit per unix flavour but on a GNU/Linux server you will have approx,. 2 -3 GB to allocate for IDS shared memory. 1GB should be reserved for the linux kernel. HTH. PEter André Luiz Rufino wrote: > Hi, > > HDR just need to see the secondary server. Just like you would do to connect > to another informixserver. > > The both sqlhosts ( on primary and secondary informix server ) must to have > its lines on sqlhosts file. > > so if you want to make the informix server "mickey" on hostsname "disney" > works, you would have on sqlhosts file > > mickey ipcshm disney mickey > mickey_tcp onsoctcp disney mickey_tcp> > considering /etc/services in the example above > > mickey_tcp 1526/tcp > > and now the configuration of informix server "thor" on hostsname "marvel" > > thor ipcshm marvel thor > thor_tcp ipcshm marvel thor_tcp > > considering /etc/services in the example above > > thor_tcp 1527/tcp > > You need just one more line in each sqlhosts file , so they must to be like > this: > > in disney machine > > mickey ipcshm disney mickey > mickey_tcp onsoctcp disney mickey_tcp> thor_tcp ipcshm marvel thor_tcp > > and in marvel machine > > thor ipcshm marvel thor > thor_tcp ipcshm marvel thor_tcp > mickey_tcp onsoctcp disney mickey_tcp> > and /etc/services in both machines: > > mickey_tcp 1526/tcpthor_tcp 1527/tcp > > After make the trusted connection between machines and archive and restore > sincronizing, you just execute de onmode -d using only informixserver names > > so, in primary server > > disney:/>onmode -d primary thor_tcp > > and in secondary machine > > marvel:/>onmode -d secondary mickey_tcp > > Just like that > > Good luck !!! > > André Luiz > > >> To: ids@iiug.org> From: marcus.haarmann@midoco.de> Subject: AW: RE: HDR >> > Connectivity (IDS 10.0) [8970]> Date: Thu, 19 Apr 2007 07:03:01 -0400> > Hi, > > >> I did not try a setup with different ports for HDR than for IDS itself, so I >> am not sure if this will work. > > My idea of HDR was always that the second >> > parameter for onmode -d was the > machine name (as an alias in /etc/hosts or > DNS) and not the informixserver > value. > > So, you should try to call > > onmode -d primary <machine_name secondary server> > and > onmode -d secondary > <machine_name primary server> > > Marcus > > ----- Originalnachricht ----- > > Von: DILEEP NARAYANAN NAIR <ndileep@cisco.com> > Gesendet: Don, 19.4.2007 > 02:39 > An: ids@iiug.org > Betreff: Re: RE: HDR Connectivity (IDS 10.0) [8969]> >>> Hi, > > Thanks all for your responses. I configured /etc/hosts.equiv and > >>> > ~informix/.rhosts to contain + to accept all servers, in both the machines. > > >> I also modified sqlhosts as follows. > > primary > ------- > server onsoctcp >> > localhost server_tcp > primary onsoctcp <local machine name> hdr_tcp > > secondary onsoctcp <secondary/remote machine name> hdr_tcp > > secondary > > ---------- > server onsoctcp localhost server_tcp > secondary onsoctcp <local > machine name> hdr_tcp > primary onsoctcp <primary/remote machine name> hdr_tcp > >>> After this sqlhost change, 'netstat -atn' shows listeners started on other >>> >> interfaces like ... > > tcp 0 0 172.27.27.3:2007 0.0.0.0:* LISTEN > > 2007 >> > is my hdr port number. > > I still get the connection errors though. I tried > with removing aliases in > /etc/hosts also. > > I run the 'onmode -d primary > secondary' command when primary IDS is in online > mode and 'onmode -d > secondary primary' command when the secondary is in the > 'Fast Recovery' > mode. Is it ok? > > The errors are: > > 09:30:26 DR: new type = primary, > secondary server name = SecondaryMP > 09:30:33 Dynamically allocated new > virtual shared memory segment (size 8192KB) > 09:31:27 DR: Cannot connect to > secondary server > 09:31:27 DR: Turned off on primary server > 09:31:31 DR: > Cannot connect to secondary server > 09:31:31 DR: Turned off on primary server > >>> and > > 17:19:50 DR: new type = secondary, primary server name = PrimaryMP >>> >> 17:19:50 DR: Trying to connect to primary server = PrimaryMP > [The command >> > 'onmode -d secondary primary' returns immediately] > > Thanks, > Dileep > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > > > >> > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > _________________________________________________________________ > Ligue para os amigos com a Chamada de PC para PC - GRATUITO > http://get.live.com/messenger/overview > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

↪ replying to DILEEP NARAYANAN NAIR
Nilesh Ozarkar — — source: IIUG Forums & Mailing Lists

Hi Dileep, Check if you can connect to primary server from the secondary server host. When Primary server is online, try connecting to it using dbaccess from secondary server host. You could also try using different port # for primary and secondary servers. - Nilesh - "DILEEP NARAYANAN NAIR" <ndileep@cisco.com> Sent by: ids-bounces@iiug.org 04/18/2007 07:39 PM Please respond to ids@iiug.org To ids@iiug.org cc Subject Re: RE: HDR Connectivity (IDS 10.0) [8969] Hi, Thanks all for your responses. I configured /etc/hosts.equiv and ~informix/.rhosts to contain + to accept all servers, in both the machines. I also modified sqlhosts as follows. primary ------- server onsoctcp localhost server_tcpprimary onsoctcp <local machine name> hdr_tcp secondary onsoctcp <secondary/remote machine name> hdr_tcp secondary ---------- server onsoctcp localhost server_tcpsecondary onsoctcp <local machine name> hdr_tcp primary onsoctcp <primary/remote machine name> hdr_tcp After this sqlhost change, 'netstat -atn' shows listeners started on other interfaces like ... tcp 0 0 172.27.27.3:2007 0.0.0.0:* LISTEN 2007 is my hdr port number. I still get the connection errors though. I tried with removing aliases in /etc/hosts also. I run the 'onmode -d primary secondary' command when primary IDS is in online mode and 'onmode -d secondary primary' command when the secondary is in the 'Fast Recovery' mode. Is it ok? The errors are: 09:30:26 DR: new type = primary, secondary server name = SecondaryMP 09:30:33 Dynamically allocated new virtual shared memory segment (size 8192KB) 09:31:27 DR: Cannot connect to secondary server 09:31:27 DR: Turned off on primary server 09:31:31 DR: Cannot connect to secondary server 09:31:31 DR: Turned off on primary server and 17:19:50 DR: new type = secondary, primary server name = PrimaryMP 17:19:50 DR: Trying to connect to primary server = PrimaryMP [The command 'onmode -d secondary primary' returns immediately] Thanks, Dileep ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Nilesh Ozarkar
DILEEP NARAYANAN NAIR — — source: IIUG Forums & Mailing Lists

Hi, The problem was related to network connectivity. Primary was able to connect to the secondary, but not the other way. I was able to ping each other, but traceroute was giving error while running from the primary. After clearing the ip tables entries in secondary, using the /sbin/iptables command, HDR worked. Thanks for all responses, Dileep

Related threads

Glossary