For redhat Linux 5.6, firewall has been closed, the machine use dbaccess can access database,
In the server configuration is as follows:
The cat/etc/services
Sqlexec # 9088/TCP IBM Informix SQL Interface
Sqlexec # 9088/udp IBM Informix SQL Interface
Sqlexec - SSL/TCP 9089 # IBM Informix SQL Interface - Encrypted
Sqlexec - SSL/udp # 9089 IBM Informix SQL Interface - Encrypted
Informix # 8000/TCP informix services
The cat/opt/informix/etc/sqlhosts
# demo_on onipcshm on_hostname on_servername
# demo_se seipcpip se_hostname sqlexec
Online_pc onipcshm localhost informix
Online_tcp onsoctcp localhost informix
The cat/opt/informix/. Following
INFORMIXDIR=/opt/informix; Export INFORMIXDIR
INFORMIXSERVER=online_tcp; Export INFORMIXSERVER
ONCONFIG=ONCONFIG. PC; Export ONCONFIG
TERMCAP=/opt/informix/etc/TERMCAP; Export TERMCAP
The cat/opt/informix/etc/onconfig STD
SERVERNUM 0 # Unique id corresponding to a Dynamic Server instance
DBSERVERNAME online_pc # Name of the default database server
DBSERVERALIASES online_tcp # List of alternate dbservernames
NETTYPE ipcshm, # 3, 30, the CPU Configure poll thread (s) for NETTYPE
NETTYPE soctcp, # 3, 30, NET Configure poll thread (s) for NETTYPE
DEADLOCK_TIMEOUT 60 # Max time to wait of the lock in distributed env.
RESIDENT 0 # Forced residency flag (Yes=1, No=0)
Netstat apn | grep 8000
TCP 0 0 127.0.0.1:0.0.0.0:8000 * 3340/LISTEN oninit
TCP 0 0 127.0.0.1:8000, 26645:127.0.0.1 ESTABLISHED 3340/oninit
TCP 0 0 127.0.0.1:26645, 8000:127.0.0.1 ESTABLISHED 14739/dbaccess
CodePudding user response:
The cat/opt/informix/etc/sqlhosts# demo_on onipcshm on_hostname on_servername
# demo_se seipcpip se_hostname sqlexec
Online_pc onipcshm localhost informix
online_tcp onsoctcp localhost informix
127.0.0.1 localhost representative
You should change localhost to informix server IP address, and restart the database, try in the attachment