Re: Newbie question: Informix SE on Linux
Posted in 1998
Topics: Server Administration, Networking & sqlhosts Configuration, Platform-Specific Issues
Hi!
Mike Jagdis wrote:
> KakukZ said
>
> >I'm on kernel 2.0.27, and I can't connect with seipcpip. That's why I assumed that
> >unnamed pipes only supported in 2.0.30 & above. I always get a 25591 error from
> >dbaccess. But I will NEVER give up! :) Anyone has an idea?
>
> Your $INFORMIXDIR/etc/sqlhosts must look like:
>
> server_se seipcpip host1 sqlexec
> server_se sesoctcp host2 1536
Are you sure that you can enter service port number to the 4th coloumn? Because I'm
not. Informix expect service name not port number.
>
>
> You can use whatever string you like for the server name (server_se).
>
> The host1 in the first line must match *exactly* the output
> of "uname -n". You may not use just the hostname if "uname -m"
Ladies & gentleman he's got the point! seipcpip only works if you give "uname -n"
output to the 3rd coloumn!!! Thanks for the idea!
> gives you the fully qualified name - i.e. with a domain (it's
> got dots in it). You may not use "localhost" - unless "uname -m"
> tells you your hostname is localhost (which is wrong anyway...).
>
> The host2 in the second line may match host1 or may not. It must,
> however, be something that can be looked up via /etc/hosts, NIS
> or DNS and turned into an IP address for the machine providing
> the service.
>
> The 1536 is the port number or name the server process is listening
> on.
I had problems only with seipcpip. sesoctcp works fine, thanks.
>
>
> Informix scans the sqlhosts file and uses the first matching line
> it finds. So if your uname matches the host name in an seipcpip
> line first you get pipes, otherwise you drop through and use the
> sesoctcp line. This allows the same sqlhosts file to be used company
> wide rather than being machine specific.
>
> Mike
>
> --
> .----------------------------------------------------------------------.
> | Mike Jagdis | Internet: mailto:mike@roan.co.uk |
> | Roan Technology Ltd. | |
> | 54A Peach Street, Wokingham | Telephone: +44 118 989 0403 |
Regards,
KakukZ
-----------------------------------------------------------------
Zoltan Kakuk kakukz@freemail.c3.hu
System Administrator Mosonyi str. 9.
Hungarian National Police HQ 1087, Budapest
Criminal Identification Service HUNGARY
-----------------------------------------------------------------