Re: Re: Re: 908: Attempt to connect to database se
Posted in 2014
Topics: Server Administration, Networking & sqlhosts Configuration
Hello Giles,
Yes I understand that. Now, can you please reply this posting just
the sqlhosts from the server and the client.
is the below the sqlhosts file that you have on the server?
hdbafdba onipcshm hmba04 hdbafdba_net1
hdbafdba_tcp onsoctcp hmba04 hdbafdba_net1
hdbafdbasrv_tcp onsoctcp hmba04 hdbaisrv_net1
thanks
esteban.-
On 17/12/14 10:15, GILLES TCHAPPI wrote:
> 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
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Hi Esteban :
Yes, that is server host sqlhosts.
The client sqlhosts is :
#**************************************************************************
#
# 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
I used this port number 15038 in client sqlhosts as this is the port bind to
hdbafdba_net1 in server host /etc/services (see below) :
informix@hmba04:hdbafdba_tcp:/bases/informix/hdbafdba/arch/logical> cat
/etc/services | grep hdbafdba_net1
hdbafdba_net1 15038/tcp
Regards