I have set my informix database server to listen to port 4725/tcp in the /etc/services file. SELinux is disabled. No other dameon is using this port. I can telnet to "localhost 4725" but when I try it from another PC in the office the connection is refused. The PC is in the /etc/hosts, hosts.allow and also put it in hosts.equiv. Also made sure it was not in hosts.deny. I ran "netstat -pantu | grep LISTEN" and saw "tcp 0 0 127.0.0.1:4725 0.0.0.0:* LISTEN 3625/sqlexced" along with other stuff. I can telnet to port 22 from the remote PC.

Any ideas on how to resolve this problem will be greatly appreciated.

Thanks,
David

Maybe a firewall is stopping the connection?

From what you've provided it appears that the service is only listening on the localhost and/or not the local network interface, that's why connections work from localhost and not the network.

I don't use Informix, but doing some research I think you need to check your /etc/hosts file. Make sure your network interface IP address (i.e. not 127.0.0.1) with FQDN hostname is listed in /etc/hosts. You can have 127.0.0.1, but make sure it only shows with the localhost name.
Also check your sqlhosts file to make sure the server hostname is listed.

Configuring Client/Server for IBM Informix products on Unix and Linux
http://www-1.ibm.com/support/docview...n&rss=ct631db2

How to install and use Informix CLI with Informix SE on Linux
http://www.iiug.org/library/linux/Ho...ormix_CLI.html

Product Review Informix on Linux
http://www.linuxjournal.com/files/li...10/3110s1.html

I hope that helps.

No it is not the firewall, it is because infomix is binding to the localhost, this means you cannot access it over the network only from the machine itself, if you want to access it over the network you need to change the configuration to get it to listen to all addresses.

Thanks for the heads up. I went back and checked the hosts file again and believe that was where the problem was. I made a change and the service is now binding itself to the servers ipaddress at the correct port, not localhost as before. I can now get a telnet connection to the port that was refusing the connection before. I am now moving on to another problem that I will start a new thread on.

Thanks again,
David

Thanks for the hint! I was having trouble getting IBM's Design Studio to connect to an Informix 10.0.UC5 database running on Centos 4 so I could crossload data into a DB2 Data Warehouse Edition (now "InfoSphere Warehouse") database. I could connect from the Design Studio installation on the Informix server, but from the workstations (Win XP and Centos 4) I kept getting a jdbc "InvocationTargetException" error. I chased around for a day thinking it was jdbc, but a tech put me onto the fact that nothing was listening at the port (nmap helped me with that). That led me to this thread, and making the appropriate entry in the /etc/hosts file on the Informix server solved it! Thanks!