IDS Forum

Re: -956 error message while HADR IDS 10 UC4

Posted By: Martin Fuerderer
Date: Friday, 24 August 2007, at 10:00 a.m.

In Response To: -956 error message while HADR IDS 10 UC4 (DEEPAK BISWAS)

Hi,

critical is, that the user informix is trusted.
Have you tried as user informix to do the remote
connect on OS level (rlogin or similar)?

I never heard that you can enter IP-address only in
sqlhosts file, but not the hostname. This I think is not
a (version specific) problem of IDS.

It is more likely a setup problem between the machines.
First make sure that each machine "knows" itself by
name. Usually this is done by an entry in /etc/hosts.
There may be a difference between long and short
name (with and without full domain name qualification).
So you may have to put both into /etc/hosts.

Next see whether the peer is known by name
on each machine. E.g. use "nslookup" utility or
something similar. You may have to adjust some
setup regarding DNS utilization vs. files (like /etc/hosts).

As a last test, you can use dbaccess on one machine
to connect to server on the other and vice versa. Do
this as user informix and it should work without requiring
the password.

Once all this is correctly in place, HDR should work.

BTW: you can use $INFORMIXDIR/etc/hosts.equiv
instead of /etc/hosts.equiv. The syntax in the file is
the same, only $INFORMIXDIR/etc/hosts.equiv will
be effective for IDS only (but not all the other UNIX
functionality).

Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

IBM Deutschland GmbH
Chairman of the Supervisory Board: Hans Ulrich Märki
Board of Management: Martin Jetter (Chairman), Rudolf Bauer, Christian
Diedrich, Christoph Grandpierre, Matthias Hartmann, Thomas Fell, Michael
Diemer
Corporate Seat: Stuttgart, Germany; Reg.-Gericht: Amtsgericht Stuttgart,
HRB-Nr.: 14 562 WEEE-Reg.-Nr. DE 99369940

ids-bounces@iiug.org wrote on 24.08.2007 15:27:48:

> Hi all,
> I have implemented a hadr setup in two suse9 box using ids10 uc4. i am
getting
> the following error "-956 informix@fff:172.40.100.11 is not trusted" i
tried
> the following steps.
> i entered hostname in /root/.rhosts and /etc/hosts.equiv and also edited

> ..netrc in both the machine still the database server is not able to
> communicate. i am able to connect from OS level without password. but
database
> server is giving the above mentioned error. i noticed that sqlhosts file
in
> UC4 doesnt take hostname it takes only ip address. can anyone help me
out in
> this regard or tell me what are the steps required for trusted
connection in
> HADR.
>
> Thanks and regards
> Deepak Biswas
>
>
>
*******************************************************************************

> Forum Note: Use "Reply" to post a response in the discussion forum.
>

Messages In This Thread

• -956 error message while HADR IDS 10 UC4
  DEEPAK BISWAS -- Friday, 24 August 2007, at 9:27 a.m.
  • RE: -956 error message while HADR IDS 10 UC4
    Robert Roussey(IT) -- Friday, 24 August 2007, at 9:33 a.m.
  • Re: -956 error message while HADR IDS 10 UC4
    Martin Fuerderer -- Friday, 24 August 2007, at 10:00 a.m.
    • Re: -956 error message while HADR IDS 10 UC4
      DEEPAK BISWAS -- Friday, 24 August 2007, at 10:15 a.m.
      • Re: -956 error message while HADR IDS 10 UC4
        Martin Fuerderer -- Friday, 24 August 2007, at 11:02 a.m.
      • RE: -956 error message while HADR IDS 10 UC4
        Clifton Bean -- Monday, 27 August 2007, at 9:04 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.