IDS Forum

RE: Accessing remote database table

Posted By: Plugge, Joe R.
Date: Wednesday, 11 August 2010, at 10:13 a.m.

In Response To: RE: Accessing remote database table (Schleicher, Keith)

Sorry, I overlooked that you are using Solaris 10.

Try having your sys admins add the entry in the /etc/hosts file for XXXXdbs.csc.XXXXX.com and see if that corrects the issue.

You have verified that there is an entry for XXXXdbs.csc.XXXXX.com in the .rhosts file in ~jsoude1 , correct?

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Schleicher, Keith
Sent: Wednesday, August 11, 2010 9:07 AM
To: ids@iiug.org
Subject: RE: Accessing remote database table [20835]

Joe,

Here is what the Informix log says:

12:15:48 listener-thread: err = -956: oserr = 0: errstr =
jsoude1@XXXXdbs.csc.XXXXX.com: Client host or user
jsoude1@XXXXdbs.csc.XXXXX.com is not trusted by the server.

It doesn't look like we have a netsvc.conf file on the server currently.
The /etc/hosts file doesn't have the IP address for
XXXXdbs.csc.XXXXX.com, so maybe that is the issue?

Keith Schleicher
IT Database Administrator
B2-253B-A
Office: 847-286-4027
Cell: 224-210-8358
Blackberry: 2242108358@messaging.sprintpcs.com
Page: 2242108358@sprint.skytel.com

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Plugge, Joe R.
Sent: Tuesday, August 10, 2010 4:37 PM
To: ids@iiug.org
Subject: RE: Accessing remote database table [20826]

Keith,

Are you using /etc/hosts or DNS?

Exactly what does your online log say for the 956 error? The reason that
I ask
is that one time we had .rhosts to trust a machine named for example,
"atlas"
and the error coming through in the online log was something to the
effect of
" err = -956: oserr = 0: errstr = jadams@atlas.xxx.xxx.com: Client host
or
user jadams@atlas.xxx.xxx.com is not trusted by the server.

The entry in the rhosts was for atlas, not the fully qualified name....
which
was being caused by an incorrectly configured /etc/netsvc.conf file.
Since we
use the /etc/hosts, the netsvc.conf file needs to have this stanza:

hosts = local,bind

So if you are using the /etc/hosts for resolution, make sure that your
machine
is still in /etc/hosts and that the stanza is there and you will have to

bounce the engine to get the change to take effect, as that file is read
in
when the engine starts up.

joe

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Schleicher, Keith
Sent: Tuesday, August 10, 2010 4:13 PM
To: ids@iiug.org
Subject: RE: Accessing remote database table [20823]

I looked into the rhosts files and the SA said that it made no sense
that those files would be the culprit because they haven't been changed
for months.

Keith Schleicher
IT Database Administrator
B2-253B-A
Office: 847-286-4027
Cell: 224-210-8358
Blackberry: 2242108358@messaging.sprintpcs.com
Page: 2242108358@sprint.skytel.com

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Link, David A
Sent: Tuesday, August 10, 2010 4:10 PM
To: ids@iiug.org
Subject: RE: Accessing remote database table [20822]

Did he have .rhosts file in his home directory and are the permission
and
ownership correct?

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Schleicher, Keith
Sent: Tuesday, August 10, 2010 4:00 PM
To: ids@iiug.org
Subject: Accessing remote database table [20821]

I have a user that is querying tables from a database from server B
while logged onto server A. He previously had no problems with this,
but now he is getting a not trusted error (956).

Server A is running IDS 7.30.UC11 on Solaris 10.

Server B is running IDS 10.00.UC6 on Solaris 10.

I contacted the SA and he said that nothing has changed on the Solaris
side. There haven't been any changes on the Informix side and he has
the correct permissions assigned on the database. We aren't using the
/etc/hosts.equiv file. There doesn't seem to be a .netrc file in the
user's home directory. Does anyone have any idea how this could work
last week and then suddenly not work?

Keith Schleicher

IT Database Administrator

B2-253B-A

Office: 847-286-4027

Cell: 224-210-8358

Blackberry: 2242108358@messaging.sprintpcs.com

Page: 2242108358@sprint.skytel.com

************************************************************************

*******
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.

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

Messages In This Thread

• Accessing remote database table
  Schleicher, Keith -- Tuesday, 10 August 2010, at 4:59 p.m.
  • RE: Accessing remote database table
    Link, David A -- Tuesday, 10 August 2010, at 5:09 p.m.
    • RE: Accessing remote database table
      Schleicher, Keith -- Tuesday, 10 August 2010, at 5:12 p.m.
      • RE: Accessing remote database table
        Plugge, Joe R. -- Tuesday, 10 August 2010, at 5:37 p.m.
        • RE: Accessing remote database table
          Schleicher, Keith -- Wednesday, 11 August 2010, at 10:06 a.m.
          • RE: Accessing remote database table
            Plugge, Joe R. -- Wednesday, 11 August 2010, at 10:13 a.m.
            • Re: Accessing remote database table
              Alexandre Marini -- Wednesday, 11 August 2010, at 10:40 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.