Change Informix server name and activate port 1526 tcp

YTD · #1 (**permalink**) 08-10-09, 02:48

I have CentOS 5 X86_64 and Informix server 9.40 UC2

First question:

I need to change the hostname of the CentOS linux machine, is it a problem for informix server if I do that ?

Second question:

I need to open port 1526/tcp in the linux machine for onserv for informix server. How do I do that ?

1. I can ping the linux machine from the windows machine.
2. I can connect to port 22 using telnet.
3. I can connect to port 3306 *(mysqlserver) from the localhost linux machine server.

[root@xxxx ~]# telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
4
5.0.45!{n4V4B/,b"~w[@l$jma~quit
Bad handshakeConnection closed by foreign host.
[root@xxxx ~]#

4. I can connect to port 3306 *(mysqlserver) from a windows machine using telnet.
5. The iptables are default policy set to accept. Anyway I have added the exception for the port 1526 tcp and udp, just to be done.
6. I have disabled the SE linux enforcing.
7. I can connect to port 1526 to the linux machine but only from the localhost - using root.

[root@xxxx ~]# telnet localhost 1526
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
quit
Connection closed by foreign host.
[root@xxxx ~]#

pls answer asap I need to know fast, please.

ceinma · #2 (**permalink**) 08-13-09, 09:23

Answering the first question.

Depends! Depends of your configuration on Informix. Depends how you will change the hostname (change only the hostname? change the /etc/hosts? )
Look the SQLHOSTS file (enviroment INFORMIXSQLHOSTS) .
On this file your configure all possible connections with Informix.
If have a "onsoctcp" , you are using TCP/IP connection, look the third field, if have a hostname there, you will have a problem, if have the IP, don't worry.
For more information about SQLHOSTS : The sqlhosts Information
If you change the SQLHOSTS file, need to restart Informix.

The second question:
Depends of the first question!

Well, you have sure that your configuration are working with TCP for all NICs?

To check what port the Informix are listening :
Informix way:

Code:

$ onstat -g ntt | grep soctcp
4c51e8a8 soctcplst       15 09:02:46                   codsrv222.mynet|56010|soctcp
4c4cf8a8 soctcplst       14 09:02:46 09:02:55          codsrv222.mynet|55010|soctcp
4c2658a8 soctcplst        6 09:02:46                   codsrv222.mynet|2110|soctcp
4c2098a8 soctcplst        5 09:02:46 07:00:16          codsrv222.mynet|2010|soctcp

here my Informix are listening the ports: 56010, 55010, 2110 and 2010

Linux way (with root):

Code:

# netstat -nltp | grep oninit
tcp        0      0 172.30.252.222:55010    0.0.0.0:*               LISTEN      5767/oninit
tcp        0      0 172.30.252.222:56010    0.0.0.0:*               LISTEN      5767/oninit
tcp        0      0 0.0.0.0:2010            0.0.0.0:*               LISTEN      5767/oninit
tcp        0      0 0.0.0.0:2110            0.0.0.0:*               LISTEN      5767/oninit

Here show that are listening the ports 55010 and 56010 only on IP 172.30.252.222 , and the ports 2010 and 2110 for ALL NICs.

Internet Services

Web Development

Digital Marketing

Consumer Tech