Re: Re: 908: Attempt to connect to database server

Posted in 2014

Topics: Server Administration, Networking & sqlhosts Configuration, Licensing & Editions

Esteban — Mon, 15 Dec 2014 17:24:14 — source: IIUG Forums & Mailing Lists

Giles I think you missunderstood my comment. I meant to remove the port number in the sqlhosts file and replace with the name that you have in the /etc/services. YOu do not need root privileges to do that. You can do it as informix user. The changes I am talking about are on the client in the sqlhosts file. That is all. (see below in red) hdbafdba onipcshm hmba04 hdbafdba_net1 #hdbafdba_tcp onsoctcp hmba04 hdbafdba_net1hdbafdba_tcp onsoctcp hmba0415038 hdbafdbasrv_tcp onsoctcp hmba04 hdbaisrv_net1 thanks esteban.- On 15/12/14 15:33, GILLES TCHAPPI wrote: > Thanks for your answer : > > As I'm root permissions on client box, I can't modify /etc/services on client > box, that's why I used port number (15038) instead of hdbafdba_net1 in the > client sqlhosts file > > Here are the informations you asked for : > > ON CLIENT BOX > > /etc/hosts : > > 127.0.0.1 localhost.localdomain localhost > 192.82.196.190 PBDDLX03 > 111.64.216.4 pbddlc01 > > but hmba04 (server box) is reachable via DNS (see below) : > > informix@PBDDLX03: # nslookup hmba04 > Server: 192.64.229.111 > Address: 192.64.229.111#53 > > hmba04.dns24.socgen canonical name = hmba04.dns24-1.socgen. > Name: hmba04.dns24-1.socgen > Address: 192.85.62.2 > > sqlhosts file : > > #************************************************************************** > # > # Licensed Material - Property Of IBM > # > # "Restricted Materials of IBM" > # > # IBM Informix Dynamic Server > # (c) Copyright IBM Corporation 1996, 2004 All rights reserved. > # > # Title: sqlhosts.demo > # Description: > # Default sqlhosts file for running demos. > # > #************************************************************************** > hdbafdba onipcshm hmba04 hdbafdba_net1 > #hdbafdba_tcp onsoctcp hmba04 hdbafdba_net1 > hdbafdba_tcp onsoctcp hmba04 15038 > hdbafdbasrv_tcp onsoctcp hmba04 hdbaisrv_net1> > /etc/services : > > informix@PBDDLX03: # cat /etc/services | grep hdba > informix@PBDDLX03: # > > ON SERVER BOX > > /etc/hosts : > > oracle@hmba04::/produits/oracle/112040/products > cat /etc/hosts | grep -y > PBDDLX03 > 192.82.196.190 PBDDLX03 > > sqlhosts file : > > #************************************************************************** > # > # Licensed Material - Property Of IBM > # > # "Restricted Materials of IBM" > # > # IBM Informix Dynamic Server > # (c) Copyright IBM Corporation 1996, 2004 All rights reserved. > # > # Title: sqlhosts.demo > # Description: > # Default sqlhosts file for running demos. > # > #************************************************************************** > hdbafdba onipcshm hmba04 hdbafdba_net1 > hdbafdba_tcp onsoctcp hmba04 hdbafdba_net1 > hdbafdbasrv_tcp onsoctcp hmba04 hdbaisrv_net1> > /etc/services : > > informix@hmba04:hdbafdba_tcp:/usr/tivoli/tsm/client> cat /etc/services | grep > hdba > hdbafdba_net1 15038/tcp > hdbaisrv_net1 46038/tcp > > Regards > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

↪ replying to Esteban

GILLES — Wed, 17 Dec 2014 09:15:19 — source: IIUG Forums & Mailing Lists

Hi Esteban, On one of my previous post I sent the following for the client host /etc/services : informix@PBDDLX03: # cat /etc/services | grep hdba informix@PBDDLX03: # As you can see there's no 'hdbafdba_net1' in the client /etc/services. That's why I 'hard-coded' port number in client sqlhosts file, and why I told you I can't modified the client /etc/services Regards

Glossary

sqlhosts