Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    1

    Unanswered: Change Informix server name and activate port 1526 tcp

    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.

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    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.
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •