Re: Need help for remote connection

erro -931 states that server couldn't localte a service in /etc/services. And I think it is right since you have specified dummy2 as the service name for sopd2 server on production system. First of all I'd advise you to use the same server name on production system and development system, i.e., you have to define the server sopd2_tcp on production server (not sopd2, wich is a ipcshm connection on development server). Then you have to check you've added sopd2_tcp to /etc/services on production system. Best Regards, Octav On Mon, Nov 15, 1999 at 05:24:38PM -0600, Sanjeev Sagar wrote: > > I am having two hosts running IDS 7.31.UC2 on Solaris 2.5.1. > > hosts 1. sopsnp01[production]- sqlhosts contents > > sopp1 onipcshm > sopsnp01 dummy1 > sopp1_tcp ontlitcp > sopsnp01 sopp1_tcp > dbap1 onipcshm > sopsnp01 dummy12 > dbap1_tcp ontlitcp > sopsnp01 dbap1_tcp > sopd2 ontlitcp > sopsnd01 dummy2 --Added for remote connection testing > > hosts 2. sopsnd01[Development] - sqlhosts contents [note- this machine > has 3 instances, 1 instance has the same informixserver name as > production i.e. sopp1, in order to do rstore of last month data on > development box. But I did take care of this thing in sqlhosts file for > remote connection like following > > sopd2 onipcshm sopsnd01 dummy2 > sopd2_tcp ontlitcp sopsnd01 sopd2_tcp > dbad1 onipcshm sopsnd01 dummy21 > dbad1_tcp ontlitcp sopsnd01 dbad1_tcp > sopp1 onipcshm sopsnd01 dummy1 > #sopp1_tcp ontlitcp sopsnd01 sopp1_tcp> sopp1_tcp ontlitcp sopsnp01 sopp1_tcp --This I added > for remote connection > > Cuurrent Environment : INFORMIXSERVER=sopd2 on sopsnd01 [Development > machine]. > > >From here I have to connect to sopp1 on sopsnp01[Production Box] and > insert some records from sopd2:<table_on_dev> to sopp1:<table_on_prd> > > I did following > > prompt > INFORMIXSERVER=sopp1_tcp dbaccess - - > > connect to 'sp1bill' user 'informix'; > Here dbaccess prompt for password > > connected > which is right, I can see my production tables here. My > main aim of connection is to insert records form Dev > > > delete from <table_on_prd> ; --Executed successfully > > > insert into <table_on_prd> select * from > <dbname>@sopd2:<owner>.<table_on_dev>; > > It gives me following error > > 908: Attempt to connect to database server (sopd2, > conerr=-931, oserr=0) failed. > Error in line 1 > Near character position 45> > Even if I say > > select count(*) from> <dbname>@sopd2:<owner>.<table_on_dev>; > It gave same error > > Am I missing something or It is not possible through dbaccess to have > this kind of operation. I do not have ESQLC or I4gl > but does it possible throught ESQLC. I checked manual, It talk about > "connect to <remote> as with concurrent transaction" > Does this tell that It is possible in ESQLC not in DBACCESS. I can not > afford luxury of ESQLC b'coz I do not have it > > I will highly appreciate if someone can help. > > Thanks > > > > -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com

You are absolutely right. I did changed my sqlhosts entry on production box like sopp1 onipcshm sopsnp01 dummy1 sopp1_tcp ontlitcp sopsnp01 sopp1_tcp dbap1 onipcshm sopsnp01 dummy12 dbap1_tcp ontlitcp sopsnp01 dbap1_tcp sopd2_tcp ontlitcp sopsnd01 sopd2_tcp One more thing, the port# for sopd2_tcp (in /etc/services) should be same, the one which I defined on sopsnd01 hosts, It did not worked for me when the port# (/etc/services) were different. Anyway now I have one more problem in the same stream of remote connection. I am able to connect to production box through dbacces connect statement and I can see my production tables but when I do prompt > select count(*) from <devdb>@sopd2_tcp:<table_on_dev> It gave me error 956: Client host or user (informix@sopsnp01) is not trusted by the server. In oreder to do more check I went on production box and try to connect to development INFORMIXSERVER=sopd2_tcp dbaccess - -> connect to '<devdb>' user 'informix'; ENTER PASSWORD > connected ---worked fine but > select count(*) from <prddb>@sopp1_tcp:<table_on_prd>; gave me same error 956: Client host or user (informix@sopsnd01) is not trusted by the server. If I checked the 956 error, It tells me that I need to put the entries with the user name in /etc/hosts.equiv and rhosts file. That is something is not easy for me b'coz I have to go for system security department to approve this. Anyway I need to know If I am correct then what kind of chenges I need to have in /etc/hosts.equiv file on both the hosts. We do not maintained rhosts files. Do I have to create the rhosts file also OR there is some way to avoid /etc/hosts.equiv & rhosts files. I appreciate your efforts. Thanks Sanjeev K. Sagar Octav Chiriac wrote: > erro -931 states that server couldn't localte a service in /etc/services. > And I think it is right since you have specified dummy2 as the service > name for sopd2 server on production system. First of all I'd > advise you to use the same server name on production system and > development system, i.e., you have to define the server sopd2_tcp > on production server (not sopd2, wich is a ipcshm connection on > development server). Then you have to check you've added sopd2_tcp > to /etc/services on production system. > > Best Regards, > Octav > > On Mon, Nov 15, 1999 at 05:24:38PM -0600, Sanjeev Sagar wrote: > > > > I am having two hosts running IDS 7.31.UC2 on Solaris 2.5.1. > > > > hosts 1. sopsnp01[production]- sqlhosts contents > > > > sopp1 onipcshm sopsnp01 dummy1 > > sopp1_tcp ontlitcp sopsnp01 sopp1_tcp > > dbap1 onipcshm sopsnp01 dummy12 > > dbap1_tcp ontlitcp sopsnp01 dbap1_tcp> > sopd2 ontlitcp sopsnd01 dummy2 --Added for remote > connection testing > > > hosts 2. sopsnd01[Development] - sqlhosts contents [note- this machine > > has 3 instances, 1 instance has the same informixserver name as > > production i.e. sopp1, in order to do rstore of last month data on > > development box. But I did take care of this thing in sqlhosts file for > > remote connection like following > > > > sopd2 onipcshm sopsnd01 dummy2 > > sopd2_tcp ontlitcp sopsnd01 sopd2_tcp > > dbad1 onipcshm sopsnd01 dummy21 > > dbad1_tcp ontlitcp sopsnd01 dbad1_tcp > > sopp1 onipcshm sopsnd01 dummy1 > > #sopp1_tcp ontlitcp sopsnd01 sopp1_tcp> > sopp1_tcp ontlitcp sopsnp01 sopp1_tcp --This I added > > for remote connection > > > > Cuurrent Environment : INFORMIXSERVER=sopd2 on sopsnd01 [Development > > machine]. > > > > >From here I have to connect to sopp1 on sopsnp01[Production Box] and > > insert some records from sopd2:<table_on_dev> to sopp1:<table_on_prd> > > > > I did following > > > > prompt > INFORMIXSERVER=sopp1_tcp dbaccess - - > > > connect to 'sp1bill' user 'informix'; > > Here dbaccess prompt for password > > > connected > > which is right, I can see my production tables here. My > > main aim of connection is to insert records form Dev > > > > > delete from <table_on_prd> ; --Executed successfully > > > > > insert into <table_on_prd> select * from > > <dbname>@sopd2:<owner>.<table_on_dev>; > > > > It gives me following error > > > > 908: Attempt to connect to database server (sopd2, > > conerr=-931, oserr=0) failed. > > Error in line 1 > > Near character position 45> > > > Even if I say > > > select count(*) from> > <dbname>@sopd2:<owner>.<table_on_dev>; > > It gave same error > > > > Am I missing something or It is not possible through dbaccess to have > > this kind of operation. I do not have ESQLC or I4gl > > but does it possible throught ESQLC. I checked manual, It talk about > > "connect to <remote> as with concurrent transaction" > > Does this tell that It is possible in ESQLC not in DBACCESS. I can not > > afford luxury of ESQLC b'coz I do not have it > > > > I will highly appreciate if someone can help. > > > > Thanks > > > > > > > > > > -- > Octav Chiriac Phone: (373) 2 22 99 67 > NetInfo S.R.L. Fax: (373) 2 21 36 59 > Chisinau (373) 2 22 84 88 > Moldova, Republic of mailto:com@netinfo-moldova.com

Sanjeev Sagar <sanjeevsagar@hotmail.com> wrote: > 956: Client host or user (informix@sopsnp01) is not trusted by the server.> > the user name in /etc/hosts.equiv and rhosts file. That is something is not You have to create a file ".rhost" with read/write access only for the owner in the home directory of the user. The file contains the names of the servers you want allow to connect to the server where the .rhost file resides. Example (if you want to act as user informix): on your developement server sopsnd01: Log in as informix, change to $HOME create .rhosts edit .rhosts Content of .rhosts: sopsnp01 If you want to establish a pseudo remote connection from the host sopsnd01 to sopsnd01 himself add sopsnd01 to .rhosts. If you want to allow certain users access _as_ the user on the remote box add one line for each user with following syntax: servername username for example: sopsnp01 Sanjeev that implies Sanjeev can act as informix on sopsnd01. Use it with caution. Don´t forget to change access mode to 600 for .rhost You do not need to edit /etc/hosts.equiv HTH Reinhard

Thanks a ton!!! It worked. Sanjeev K. Sagar Reinhard Habichtsberg wrote: > Sanjeev Sagar <sanjeevsagar@hotmail.com> wrote: > > 956: Client host or user (informix@sopsnp01) is not trusted by the > server.> > > > the user name in /etc/hosts.equiv and rhosts file. That is > something is not > > You have to create a file ".rhost" > with read/write access only for the owner > in the home directory of the user. > The file contains the names of the servers you want allow > to connect to the server where the .rhost file resides. > > Example (if you want to act as user informix): > on your developement server sopsnd01: > Log in as informix, change to $HOME > create .rhosts > edit .rhosts > Content of .rhosts: > sopsnp01 > > If you want to establish a pseudo remote connection from the > host sopsnd01 to sopsnd01 himself add sopsnd01 to .rhosts. > > If you want to allow certain users access _as_ the user on the > remote box add one line for each user with following syntax: > servername username > for example: > sopsnp01 Sanjeev > > that implies Sanjeev can act as informix on sopsnd01. > Use it with caution. > > Don´t forget to change access mode to 600 for .rhost > > You do not need to edit /etc/hosts.equiv > > HTH > Reinhard