11.7 - REMOTE_SERVER_CFG
I would benefit greatly from being able to manage my own hosts.equiv; as /etc/hosts.equiv is owned by root and I have to jump through hoops to update. I have an HDR pair setup on separate servers for testing. On the secondary node, I set the REMOTE_SERVER_CFG value in ONCONFIG and bounce the instance. My hosts.equiv will contain 2 entries for the Primary server - 'hostname' & 'hostname.domain'. This doesn't seem to do the trick though as I keep coming across -956 errors in the secondary server's online log. listener-thread: err = -956: oserr = 0: errstr = informix@'hostname.domain': Client host or user informix@'hostname.domain' is not trusted by the server. IF I switch back to use ONLY /etc/hosts.equiv, it works just fine. I clearly see in the message log where it's caching in both /etc/hosts.equiv and my newly created hosts.equiv. What am I missing?
Got s=6 in your sqlhosts file perhaps ? Cheers Paul > I would benefit greatly from being able to manage my own hosts.equiv; as > /etc/hosts.equiv is owned by root and I have to jump through hoops to > update. > I have an HDR pair setup on separate servers for testing. On the secondary > node, I set the REMOTE_SERVER_CFG value in ONCONFIG and bounce the > instance. > My hosts.equiv will contain 2 entries for the Primary server - 'hostname' > & > 'hostname.domain'. This doesn't seem to do the trick though as I keep > coming > across -956 errors in the secondary server's online log. listener-thread: > err > = -956: oserr = 0: errstr = informix@'hostname.domain': Client host or > user > informix@'hostname.domain' is not trusted by the server. IF I switch back > to > use ONLY /etc/hosts.equiv, it works just fine. I clearly see in the > message > log where it's caching in both /etc/hosts.equiv and my newly created > hosts.equiv. What am I missing? > > > ******************************************************************************* > 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 www.advancedatatools.com 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
where is your hosts.equiv file? You don't need to bounce the instance. add user informix to the file... not just the hostname On Aug 29, 2013 3:43 PM, "JACOB SHADIX" <jacobshadix@gmail.com> wrote: > I would benefit greatly from being able to manage my own hosts.equiv; as > /etc/hosts.equiv is owned by root and I have to jump through hoops to > update. > I have an HDR pair setup on separate servers for testing. On the secondary > node, I set the REMOTE_SERVER_CFG value in ONCONFIG and bounce the > instance. > My hosts.equiv will contain 2 entries for the Primary server - 'hostname' & > 'hostname.domain'. This doesn't seem to do the trick though as I keep > coming > across -956 errors in the secondary server's online log. listener-thread: > err > = -956: oserr = 0: errstr = informix@'hostname.domain': Client host or > user > informix@'hostname.domain' is not trusted by the server. IF I switch back > to > use ONLY /etc/hosts.equiv, it works just fine. I clearly see in the message > log where it's caching in both /etc/hosts.equiv and my newly created > hosts.equiv. What am I missing? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e01177235df061f04e51a17d8
You can also use the .rhosts file on the remote server for the incoming ser= ver and ID. This goes under the ID on the database server and you can mana= ge, without disturbing the Systems Admin to add it to the /etc/hosts.equiv.= This is for UNIX base. Windows is another thought. Thanks, ***************************************************************************= *************** Ernie Knox Sr. Technical Specialist, I&TG - IT Operations & Governance Sears Holdings Management Corp 3333 Beverly Rd. Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry:=A02244650553@messaging.sprintpcs.com Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com Informix Primary: INFORMIXDBAPrimaryPager@searshc.com Informix Secondary: INFORMIXDBASecondaryPager@searshc.com MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com MySQL Primary: MYSQLDBAPrimaryPager@searshc.com MySQL Secondary: MYSQLDBASecondaryPager@searshc.com For more information, view our DBA Wiki page link below: http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= t#DatabaseManagement " Yes we can make a Change! " " IF you can think it, you can do it! " " IT'S always a great day to watch=A0Sports: FOOTBALL " GSU MISSION: " The focus of my life begins at home with family, loved ones, and friends.= I want to use my resources to create a secure environment that fosters love, learning, laughter, and mutual succes= s. I will protect and value integrity. I will admit and quickly correct my mistakes. I will be a self-starter. I w= ill be a caring person. I will be a good listener with an open mind. I will continue to grow and learn. I will facilitate a= nd celebrate the success of others. " ***************************************************************************= *************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Ferna= ndo Nunes Sent: Thursday, August 29, 2013 2:16 PM To: ids@iiug.org Subject: Re: 11.7 - REMOTE_SERVER_CFG [31301] where is your hosts.equiv file?=20 You don't need to bounce the instance.=20 add user informix to the file... not just the hostname On Aug 29, 2013 3:43= PM, "JACOB SHADIX" <jacobshadix@gmail.com> wrote:=20 > I would benefit greatly from being able to manage my own hosts.equiv;=20 > as /etc/hosts.equiv is owned by root and I have to jump through hoops=20 > to update. > I have an HDR pair setup on separate servers for testing. On the=20 > secondary node, I set the REMOTE_SERVER_CFG value in ONCONFIG and=20 > bounce the instance. > My hosts.equiv will contain 2 entries for the Primary server -=20 > 'hostname' & 'hostname.domain'. This doesn't seem to do the trick=20 > though as I keep coming across -956 errors in the secondary server's=20 > online log. listener-thread: > err > =3D -956: oserr =3D 0: errstr =3D informix@'hostname.domain': Client host= or=20 > user informix@'hostname.domain' is not trusted by the server. IF I=20 > switch back to use ONLY /etc/hosts.equiv, it works just fine. I=20 > clearly see in the message log where it's caching in both=20 > /etc/hosts.equiv and my newly created hosts.equiv. What am I missing? >=20 >=20 >=20 >=20 ***************************************************************************= ****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 --089e01177235df061f04e51a17d8=20 ***************************************************************************= **** Forum Note: Use "Reply" to post a response in the discussion forum.=20 This message, including any attachments, is the property of Sears Holdings = Corporation and/or one of its subsidiaries. It is confidential and may cont= ain proprietary or legally privileged information. If you are not the inten= ded recipient, please delete it without reading the contents. Thank you.
That brings again the permissions issue and it may open the door to allow he users to establish non authorized trusts. Forget all that and use REMOTE_SERVER_CFG... for years we listened complains from customers (just complaints I may say). Now that it's solved, please don't look back! This should be under DBA control. Regards On Thu, Aug 29, 2013 at 11:46 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > You can also use the .rhosts file on the remote server for the incoming > ser= > ver and ID. This goes under the ID on the database server and you can mana= > ge, without disturbing the Systems Admin to add it to the > /etc/hosts.equiv.= > This is for UNIX base. Windows is another thought. > > Thanks, > > ***************************************************************************= > *************** > Ernie Knox > Sr. Technical Specialist, I&TG - IT Operations & Governance > Sears Holdings Management Corp > 3333 Beverly Rd. > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com > Blackberry:=A02244650553@messaging.sprintpcs.com > Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com > Informix Primary: INFORMIXDBAPrimaryPager@searshc.com > Informix Secondary: INFORMIXDBASecondaryPager@searshc.com > MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com > MySQL Primary: MYSQLDBAPrimaryPager@searshc.com > MySQL Secondary: MYSQLDBASecondaryPager@searshc.com > > For more information, view our DBA Wiki page link below: > > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= > t#DatabaseManagement > > " Yes we can make a Change! " > " IF you can think it, you can do it! " > " IT'S always a great day to watch=A0Sports: FOOTBALL " > GSU > MISSION: > " The focus of my life begins at home with family, loved ones, and > friends.= > I want to use my resources to create a > secure environment that fosters love, learning, laughter, and mutual > succes= > s. I will protect and value integrity. I > will admit and quickly correct my mistakes. I will be a self-starter. I w= > ill be a caring person. I will be a good listener > with an open mind. I will continue to grow and learn. I will facilitate a= > nd celebrate the success of others. " > > ***************************************************************************= > *************** > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Ferna= > ndo Nunes > Sent: Thursday, August 29, 2013 2:16 PM > To: ids@iiug.org > Subject: Re: 11.7 - REMOTE_SERVER_CFG [31301] > > where is your hosts.equiv file?=20 > You don't need to bounce the instance.=20 > add user informix to the file... not just the hostname On Aug 29, 2013 > 3:43= > PM, "JACOB SHADIX" <jacobshadix@gmail.com> wrote:=20 > > > I would benefit greatly from being able to manage my own hosts.equiv;=20 > > as /etc/hosts.equiv is owned by root and I have to jump through hoops=20 > > to update. > > I have an HDR pair setup on separate servers for testing. On the=20 > > secondary node, I set the REMOTE_SERVER_CFG value in ONCONFIG and=20 > > bounce the instance. > > My hosts.equiv will contain 2 entries for the Primary server -=20 > > 'hostname' & 'hostname.domain'. This doesn't seem to do the trick=20 > > though as I keep coming across -956 errors in the secondary server's=20 > > online log. listener-thread: > > err > > =3D -956: oserr =3D 0: errstr =3D informix@'hostname.domain': Client > host= > or=20 > > user informix@'hostname.domain' is not trusted by the server. IF I=20 > > switch back to use ONLY /etc/hosts.equiv, it works just fine. I=20 > > clearly see in the message log where it's caching in both=20 > > /etc/hosts.equiv and my newly created hosts.equiv. What am I missing? > >=20 > >=20 > >=20 > >=20 > > ***************************************************************************= > ****=20 > > Forum Note: Use "Reply" to post a response in the discussion forum.=20 > >=20 > >=20 > > --089e01177235df061f04e51a17d8=20 > > > ***************************************************************************= > **** > Forum Note: Use "Reply" to post a response in the discussion forum.=20 > > This message, including any attachments, is the property of Sears Holdings > = > Corporation and/or one of its subsidiaries. It is confidential and may > cont= > ain proprietary or legally privileged information. If you are not the > inten= > ded recipient, please delete it without reading the contents. Thank you. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --089e013a166625f29204e51d8dc6