Hi there, I have a question for you smart guys.

I have Sun Solaris 9 machine where Informix IConnect 10.0 is installed.
The machine should make use of the database server (IDS 10.0) installed
on a Red Hat EL4 Linux server.

By default Linux does not provide 'rlogin' functionality, which is the default
method used by Informix to make the connectivity. Now it is installed on my box.

AFAIU 'sqlhosts' files are different between the two platforms (Solaris uses
'oltlitcp' protocol, while Linux uses 'olsoctcp').

Furthermore (but don't know if this is an issue), the default Informix install
directory is different on the wto platforms ('/usr/informix' for Solaris VS
'/opt/informix' on Linux).

How should I configure the 'sqlhosts' file on the two boxes in order to obtain
the connectivity?

Anyhing else I should take care of?

Any help would be really appreciated.

Rupan3rd (Italy)

Rupan3rd wrote:
> Hi there, I have a question for you smart guys.
>
> I have Sun Solaris 9 machine where Informix IConnect 10.0 is installed.
> The machine should make use of the database server (IDS 10.0) installed
> on a Red Hat EL4 Linux server.
>
> By default Linux does not provide 'rlogin' functionality, which is the
> default
> method used by Informix to make the connectivity. Now it is installed on
> my box.
>
> AFAIU 'sqlhosts' files are different between the two platforms (Solaris
> uses
> 'oltlitcp' protocol, while Linux uses 'olsoctcp').
>
> Furthermore (but don't know if this is an issue), the default Informix
> install
> directory is different on the wto platforms ('/usr/informix' for Solaris VS
> '/opt/informix' on Linux).
>
> How should I configure the 'sqlhosts' file on the two boxes in order to
> obtain
> the connectivity?
>
> Anyhing else I should take care of?
>
> Any help would be really appreciated.
>
> Rupan3rd (Italy)

Informix uses the OS for user authentication. If you want to be able to
connect to IDS without sending password, you can either edit .rhosts
files or edit /etc/hosts.equiv. This works even you can't use rlogin.

You should use environment variable to point to where Informix software
is installed. So on Solaris set INFORMIXDIR=/usr/informix and on linux
INFORMIXDIR=/opt/informix.

Solaris uses transport layer interface (tli) on top of tcp, while linux
uses berkeley socket (soc) so you have to have two different sqlhosts files.
On solaris:
ids_name ontlitcp linux_name service_name

On linux
ids_name onsoctcp linux_name service_name

On both systems set environment variable INFORMIXSERVER=ids_name

The sqlhosts file should be placed in $INFORMIXDIR/etc unless you set
INFORMIXSQLHOSTS environment variable.