RE: Temporarily blocking SOCKETS connections

Are you sure you commented it out in the sqlhosts file. I dont have a box to test my memory on, but I thought I recalled if you didnt comment out the NETTYPE and did comment out the sqlhosts entry the database wouldnt even come up. (I have been mistaken many a time before) Anyway, I have deleted an entry in the sqlhosts file as well as the NETTYPE in the ONCONFIG file for the exact purpose, so can tell you it worked for me, but I dont know what you are doing wrong. Are you sure INFORMIXSQLHOSTS isnt defined or something? Are you sure the entries were removed when you bounced the database. (You do have to bounce the database as far as I know.) Will >===== Original Message From "Adam Bradley" <Adam.Bradley@ahmg.com.au> ===== >Hi all, > >I am wondering what the best method is for temporarily blocking SOCKET >based >connections to my Informix 7.31 Server (running on HP-UX 10.20). > >Our application is client/server in that the client is running on >P.C.'s(WIN95/NT) connecting to the IDS 7.31 DB Server. > >I have two connection types defined on the Informix Server namely, sockets >and shared-memory - obviously the P.C.'s would be connecting via sockets. > >If I want to be able to block access to the Informix Database Server to >these client(P.C.'s) I thought that >it would be a simple matter of commenting out the relevant lines in either >the '/etc/services' or >'$INFORMIXDIR/etc/sqlhosts' file. > >I have included below the relevant connection information from the >'$ONCONFIG', '/etc/services' and >'$INFORMIXDIR/etc/sqlhosts' files. > >Now, I tried commenting out the 'geff1_soc' line from BOTH the >'/etc/services' and '$INFORMIXDIR/etc/sqlhosts' >(and even bounced the Informix Engine) but the clients(P.C.'s) can still >connect. > >How can this be? > >Is there another approach that I can take eg. Perhaps there is some way >through the >UNIX OS where I can specify a port (1557 in this case) to be temporarily >disabled? > >Here, are the configuration files: > >'$ONCONFIG' file (Connection Type) >------------------------- >NETTYPE ipcshm,1,30,NET >NETTYPE soctcp,1,30,CPU> > >'/etc/services' file >------------------------ >geff1_soc 1557/tcp # Finance One Sockets >geff1_shm 1558/tcp # Finance One Shared Memory > >'$INFORMIXDIR/etc/sqlhosts' file >----------------------------------------------- >geff1_soc onsoctcp kenny geff1_soc >geff1_shm onipcshm kenny geff1_shm> > >Regards, >Adam Bradley ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------