急!!!window上,DbVisualize客户端连接INFORMIX7.31问题
我在WINDOWS,用DbVisualize连接linux下INFORMIX7.31,8000 端口 ping server 也不通。
linux为redhat 5.6,防火墙已经关闭,本机用dbaccess可以进入数据库的。
在服务器端配置如下:
cat /etc/services
sqlexec 9088/tcp # IBM Informix SQL Interface
sqlexec 9088/udp # IBM Informix SQL Interface
sqlexec-ssl 9089/tcp # IBM Informix SQL Interface - Encrypted
sqlexec-ssl 9089/udp # IBM Informix SQL Interface - Encrypted
informix 8000/tcp # informix services
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
cat /opt/informix/.bash_profile
INFORMIXDIR=/opt/informix;export INFORMIXDIR
INFORMIXSERVER=online_tcp;export INFORMIXSERVER
ONCONFIG=onconfig.pc;export ONCONFIG
TERMCAP=/opt/informix/etc/termcap;export TERMCAP
cat /opt/informix/etc/onconfig.std
SERVERNUM 0 # Unique id corresponding to a Dynamic Server instance
DBSERVERNAME online_pc # Name of default database server
DBSERVERALIASES online_tcp # List of alternate dbservernames
NETTYPE ipcshm,3,30,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 lock in distributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
netstat -apn|grep 8000
tcp 0 0 127.0.0.1:8000 0.0.0.0:* LISTEN 3340/oninit
tcp 0 0 127.0.0.1:8000 127.0.0.1:26645 ESTABLISHED 3340/oninit
tcp 0 0 127.0.0.1:26645 127.0.0.1:8000 ESTABLISHED 14739/dbaccess