dbaccess connection from a different machine 3

[essiprojects]

Hi,
I have an informix database in a linux machine. On this, as server, I have defined:
/etc/services
sqlexec3 1536/tcp
$INFORMIXDIR/etc/sqlhosts
ol_segades3_shm onipcshm segades3 sqlexec3

As client, I have defined:
$INFORMIXDIR/etc/sqlhosts
ol_segades3_shm onipcshm 172.16.1.137 sqlexec

When I do that and I try to connect from client's dbaccess, I get the
error:
Interrupted system call cannot connect to OnLine server ol_segades3_shm.

And if I change onipcshm from sqlhost and I put ontlitcp, then I have another error:
931: Cannot locate sqlexec3 service/tcp service in /etc/services.

And if I put another line in /etc/services with in the client:
sqlexec3 1536/tcp

Then, it gives me this error:
Exec format error er cannot bind a name to the port.

Does anybody know what I'm doing wrong?
Thank you.

 

[vpshriyan]

Hi,

Study the $INFORMIXDIR/release/en_us/0333/ONLINE_X.x (X.x stands for version) and under Machine Specific Notes, see which are the protocol(s)/interface(s) is/are supported for your platform.

In the Server Machine put the following information:
In /etc/hosts
172.16.1.137 segades3

In $INFORMIXDIR/etc/sqlhosts
# For local connections (like 4GL)
ol_segades3_shm onipcshm segades3 dummy
# For remote connections (if supported for SOCkets)
ol_segades3_tcp onsoctcp segades3 sqlexec3
# For remote connections (if supported for TLI)
ol_segades3_tli ontlitcp segades3 sqlexec3

In /etc/services
sqlexec3 1536/tcp

In $INFORMIXDIR/etc/onconfig
DBSERVERNAME ol_segades3_shm
DBSERVERALIASES ol_segades3_tcp ol_segades3_tli

In the Client Machine put the following information:
In /etc/hosts
172.16.1.137 segades3

In $INFORMIXDIR/etc/sqlhosts
# For remote connections (if supported for SOCkets)
ol_segades3_tcp onsoctcp segades3 sqlexec3
# For remote connections (if supported for TLI)
ol_segades3_tli ontlitcp segades3 sqlexec3

set environment variable
INFORMIXSERVER=ol_segades3_tcp; export INFORMIXSERVER
or
INFORMIXSERVER=ol_segades3_tli; export INFORMIXSERVER
as the case may be.

Once the connection is through, you can set optional configurable parameter NETTYPE to improve the polling and listen threads in the server machine. example:
NETTYPE soctcp,1,20,CPU

Good Luck.

Regards,
Shriyan