1,195
社区成员
发帖
与我相关
我的任务
分享急！！！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
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
...全文
请发表友善的回复…
发表回复
ArthurCYChen 2019-04-22
- 打赏
- 举报
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
localhost 代表 127.0.0.1
你该把 localhost 改为 informix 服务器IP地址, 重新启动数据库后，在连线试试
