Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Location
    Pakistan (Lahore)
    Posts
    16

    Unanswered: Remotely Accessing Database Server

    Hello All

    I have installed IDS 7.31 for SCO UNIX on two machines (A AND B).
    Both machines are intereconected using TCP/IP protocol. Both machines are ping to eachother.
    I have added the entries in SQLHOSTS, services, hosts and hosts.equiv files.
    Both machine only connect with local DB server whenever i try to connect remote server
    it gives the following error
    "761 INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES."

    I have also installed 7.31 on two NT machines I can access both server from single machines
    using dbaccess
    I have just added the required entries of both servers in hosts and services files
    and entries in SQLHOSTS (regsitry) using setnet32 utilities.

    How i can do this in UNIX environment?
    I'm not sure how to make the trust relationship in unix i read in manual and according to them i
    updated the hosts.equiv files on both machines?


    Kindly help me in this regards

    Muhammad Waqas

  2. #2
    Join Date
    Mar 2002
    Posts
    112

    re

    In Unix env. you have to use file ".rhosts" in user home directory to tell Unix , who's you allowed ?
    to allow access append the file :
    <remote-host> <remote-user>
    remote-user is user on remote-host that you allow access this host by use your shell(environment)
    if you don't see this file you can touch this file in you home directory

  3. #3
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    You already trusted the machines in the hosts.equiv file, so you don't need .rhost file.
    You'll need to adapt you $ONCONFIG files.
    In the $ONCONFIG file of machine A, you 'll need to add a DBSERVERALIAS that corresponds to the line in the sqlhosts file on machine B and vice versa.
    f.ex.

    Machine A:

    $ONCONFIG:
    DBSERVERNAME macha_tcp
    DBSERVERALIAS macha_rem

    sqlhosts:
    macha_tcp onsoctcp machineA porta
    machb_rem onsoctcp machineB portb


    Machine B:

    $ONCONFIG:
    DBSERVERNAME machb_tcp
    DBSERVERALIAS machb_rem

    sqlhosts:
    machb_tcp onsoctcp machineB portb
    macha_rem onsoctcp machineA porta

    in this case you are able to connect from machineA to machineB using the form:

    databaseb@server:table
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •