Re: DBLOAD failing ... help

In reply to Fuzzy's email about DBLOAD failing ... help, on 5 Sep 97 Hi Fuzzy ( not your real name , huh ), > Hi people, > > I've got a problem with dbload, and it's driving me crazy. > I'm attempting to load data into a table, with the following command > dbload -d mydb@myserver -c actdef.ctl -l actdef.bad -k >>load.log> When I run this, I get the following error > > "Client host or user (Administrator@my_domain) is not trusted by the > server." > > I've tried this as Administrator, the informix user that is set up by > default during install, and several other users, and I can't for the > life of me find any details on the error. Is there some sort of > privilege a user needs in Informix to allow them to use dbload, > (something similar to Oracle's import privilege)? > You need to either set the /etc/hosts.equiv file or $HOME/.rhosts file. Either of these files allow user from a remote host to login/execute commands on the server without prompting for password. Thus if myserver is remote host, create either /etc/hosts.equiv with an entry of your hostname or create $HOME/.rhosts in informix user dir. with an entry for your hostname. If you are logged on to mydomain, then the /etc/hosts.equiv or $HOME/.rhosts of mydomain should contain an entry for mydomain. Strange but true. However, there is a note of caution to all this. and it is a big note of caution. /etc/hosts.equiv & $HOME/.rhosts are potential security risks. > Thanks, > Fuzzy > :-) Hope this helps, Ravi... P.S. I am not replying individually to Fuzzy due to anti spam email id. -- Ravi Joseph Pinto, mailto:ravi@in.dhl.com Senior Consultant, voice :91-22-8503000 Astra Infotech, Mumbai, India extn. 1531 If Network is computer, how come Sun makes servers, not routers ;-) PS : Standard disclaimers apply.