Re: Online 7.11.UC1 - Cant set soctcp if service in local /etc/services

CSC CIS wrote: > > Hi All > > Pardon me if this is a stupid question. We are running Online 7.11.UC1 = > on HP-UX 10.01. This machine is on a TCP/IP network and is running = > yellow pages. When I create an instance I usually set up a shared memory = > as well as a socket service, with the service names in both sqlhosts and = > in services file, like so: > > onconfig file: > DBSERVERNAME test_shm # Name of default database server > DBSERVERALIASES test_soc # List of alternate dbservernames > NETTYPE ipcshm,1,50,CPU # Override sqlhosts nettype params > NETTYPE soctcp,1,50,NET # Override sqlhosts nettype params> > sqlhosts file: > test_shm onipcshm costello test_shm > test_soc onsoctcp costello test_soc> > /etc/services file: > test_soc 1665/tcp > test_shm 1666/tcp > > Previously we would propagate the services into the Yellow pages, but = > now we are getting more choosy about putting the instances that dont = > need to be accessed across the network. > > I find that if we dont put the services on the Yellow pages, then we = > cant set up the socket connexion. The instance refuses to startup, and = > gives error no. -931. The contents of the log file is as follows: > <SNIP> > > finderr -931 gives me: > -931 Cannot locate servicename service/tcp service in > /etc/services. > > The service noted is not listed in the network configuration > file /etc/services (UNIX) or \\etc\\services (DOS). Check the > $INFORMIXDIR/etc/sqlhosts file and make sure that the > service name for the desired server is correct. If so, contact > your network administrator and find out why the service is > not known. If you are using INFORMIX-OnLine for NetWare, > check the \\etc\\services file on the client for the required > entries. > This may be an HP-UX problem. As far as I can recall (if I could find which pile of books my Nemeth et al is in I could check this :-), if you use YP on HP-UX 9 it ignores /etc/hosts. Perhaps the same thing is happening with /etc/services. Ian