Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Expand all | Collapse all

25572 error when hostname is used

  • 1.  25572 error when hostname is used

    Posted Sun April 05, 2020 09:43 AM
    An entry in the /etc/hosts file is as follows :-
    10.10.10.10 abc.xyz.com

    When "abc.xyz.com" is used in the hostname field of the sqlhosts file and the databaseserver is started (i.e. oninit), it displays -25572 error.

    Next, an alias (i.e. abc) is added to the same entry in the /etc/hosts file as follows :-
    10.10.10.10 abc.xyz.com abc

    Now, when "abc" is used in the hostname field of the sqlhosts file and the databaseserver (i.e. oninit) is started, the engine starts successfully.

    When I ping to "abc.xyz.com" and "abc" individually, the ping is successful and displays the IP as "10.10.10.10" in the output of both the ping commands. The output of the "hostname" command displays "abc.xyz.com" correctly.

    Just wanted to know as to why when "abc.xyz.com" is used in the sqlhosts file, the 25572 error is displayed but when its alias (i.e. "abc") is used in the sqlhosts file, the databaseserver starts successfully.

    ------------------------------
    Neville Monteiro
    ------------------------------

    #Informix


  • 2.  RE: 25572 error when hostname is used

    Posted Sun April 05, 2020 10:22 AM
    It may be that xyz.com is not registered as a valid domain in the DNS.

    Art





  • 3.  RE: 25572 error when hostname is used

    Posted Sun April 05, 2020 11:05 AM
    Sir,
    DNS is not setup in the environment. All hostname to IP resolution is through the /etc/hosts file of the systems only.

    ------------------------------
    Neville Monteiro
    ------------------------------



  • 4.  RE: 25572 error when hostname is used

    Posted Sun April 05, 2020 11:09 AM

    Shouldn't make a difference but are you case consistent ?

    What version of IDS

    How long is abc.xyx.com

    You 100% sure you don't have a weird character ?  od –bc /etc/hosts

     

    Cheers

    Paul

     






  • 5.  RE: 25572 error when hostname is used

    Posted Mon April 06, 2020 05:52 AM
    Sir,

    I don't notice any weird characters in the output. Following is the output of "od -bc /etc/hosts" command :-

    informix > od -bc /etc/hosts
    0000000 061 062 067 056 060 056 060 056 061 040 040 040 154 157 143 141
    1 2 7 . 0 . 0 . 1 l o c a
    0000020 154 150 157 163 164 040 154 157 143 141 154 150 157 163 164 056
    l h o s t l o c a l h o s t .
    0000040 154 157 143 141 154 144 157 155 141 151 156 040 154 157 143 141
    l o c a l d o m a i n l o c a
    0000060 154 150 157 163 164 064 040 154 157 143 141 154 150 157 163 164
    l h o s t 4 l o c a l h o s t
    0000100 064 056 154 157 143 141 154 144 157 155 141 151 156 064 012 072
    4 . l o c a l d o m a i n 4 \n :
    0000120 072 061 040 040 040 040 040 040 040 040 040 154 157 143 141 154
    : 1 l o c a l
    0000140 150 157 163 164 040 154 157 143 141 154 150 157 163 164 056 154
    h o s t l o c a l h o s t . l
    0000160 157 143 141 154 144 157 155 141 151 156 040 154 157 143 141 154
    o c a l d o m a i n l o c a l
    0000200 150 157 163 164 066 040 154 157 143 141 154 150 157 163 164 066
    h o s t 6 l o c a l h o s t 6
    0000220 056 154 157 143 141 154 144 157 155 141 151 156 066 012 072 072
    . l o c a l d o m a i n 6 \n : :
    0000240 061 040 154 157 143 141 154 150 157 163 164 066 056 154 157 143
    1 l o c a l h o s t 6 . l o c
    0000260 141 154 144 157 155 141 151 156 066 040 154 157 143 141 154 150
    a l d o m a i n 6 l o c a l h
    0000300 157 163 164 066 012 151 156 145 164 072 040 061 062 067 056 060
    o s t 6 \n i n e t : 1 2 7 . 0
    0000320 056 060 056 061 054 040 061 060 056 062 061 065 056 060 056 060
    . 0 . 1 , 1 0 . 2 1 5 . 0 . 0
    0000340 057 062 065 065 056 062 065 065 056 062 065 065 012 061 060 056
    / 2 5 5 . 2 5 5 . 2 5 5 \n 1 0 .
    0000360 062 061 065 056 061 064 071 056 067 065 011 144 143 151 156 146
    2 1 5 . 1 4 9 . 7 5 \t d c i n f
    0000400 144 166 060 061 056 153 162 143 154 056 143 157 155 011 144 143
    d v 0 1 . k r c l . c o m \t d c
    0000420 151 156 146 144 166 060 061 012 061 060 056 062 061 065 056 061
    i n f d v 0 1 \n 1 0 . 2 1 5 . 1
    0000440 064 071 056 063 062 011 144 143 151 156 146 144 142 060 061 056
    4 9 . 3 2 \t d c i n f d b 0 1 .
    0000460 153 162 143 154 056 143 157 155 011 144 143 151 156 146 144 142
    k r c l . c o m \t d c i n f d b
    0000500 060 061 012 061 060 056 062 061 065 056 061 064 071 056 064 071
    0 1 \n 1 0 . 2 1 5 . 1 4 9 . 4 9
    0000520 011 144 143 152 162 144 166 160 060 061 056 153 162 143 154 056
    \t d c j r d v p 0 1 . k r c l .
    0000540 143 157 155 011 144 143 152 162 144 166 160 060 061 012 061 060
    c o m \t d c j r d v p 0 1 \n 1 0
    0000560 056 062 061 065 056 061 064 071 056 065 060 011 144 143 152 162
    . 2 1 5 . 1 4 9 . 5 0 \t d c j r
    0000600 160 164 144 060 061 056 153 162 143 154 056 143 157 155 011 144
    p t d 0 1 . k r c l . c o m \t d
    0000620 143 152 162 160 164 144 060 061 012 061 060 056 062 061 065 056
    c j r p t d 0 1 \n 1 0 . 2 1 5 .
    0000640 070 060 056 067 040 040 040 040 040 142 154 160 142 153 155 163
    8 0 . 7 b l p b k m s
    0000660 061 067 012 061 060 056 062 061 065 056 067 071 056 067 070 040
    1 7 \n 1 0 . 2 1 5 . 7 9 . 7 8
    0000700 040 040 040 142 154 160 156 141 163 060 061 012 061 060 056 062
    b l p n a s 0 1 \n 1 0 . 2
    0000720 061 065 056 061 064 071 056 063 060 011 144 143 142 153 160 141
    1 5 . 1 4 9 . 3 0 \t d c b k p a
    0000740 160 060 061 011 144 143 142 153 160 141 160 060 061 056 153 162
    p 0 1 \t d c b k p a p 0 1 . k r
    0000760 156 145 164 056 143 157 155 012
    n e t . c o m \n
    0000770
    informix >


    ------------------------------
    Neville Monteiro
    ------------------------------



  • 6.  RE: 25572 error when hostname is used

    Posted Tue April 07, 2020 12:21 PM
    Sir,

    Q1) What version of IDS ?
    A1) IDS v.14.10.FC1

    Q2) How long is abc.xyx.com
    A2) It is 18 characters in length.

    Q3) You 100% sure you don't have a weird character ?  od –bc /etc/hosts
    A3) I don't notice any weird characters in the output.



    ------------------------------
    Neville Monteiro
    ------------------------------



  • 7.  RE: 25572 error when hostname is used

    Posted Tue April 07, 2020 12:45 PM
    Neville:

    14.10.FC1 had a few quirks and bugs. You may want to upgrade to the latest.

    Art

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.








  • 8.  RE: 25572 error when hostname is used

    Posted Tue April 07, 2020 01:35 PM
    Yes Sir, we are planning to upgrade to the version that is one version lower than the latest version that is release,, but I thought that I should find out the reason for this behavior as to why the engine starts with "abc" which is the alias for the hostname and not with "abc.xyz.com" which is the proper hostname.

    ------------------------------
    Neville Monteiro
    ------------------------------



  • 9.  RE: 25572 error when hostname is used

    Posted Sun April 05, 2020 12:54 PM
    Neville:

    OK, so is there a domain name set in the environment?  You can check with domainname:

    $ domainname
    kagelzone.com

    Art

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.








  • 10.  RE: 25572 error when hostname is used

    Posted Mon April 06, 2020 05:54 AM
    Sir,
    Following is the output of the "domainname" command :-

    informix > domainname
    (none)
    informix >

    ------------------------------
    Neville Monteiro
    ------------------------------



  • 11.  RE: 25572 error when hostname is used

    Posted Mon April 06, 2020 03:58 AM
    Hi,
    Check whether you can ping xyz.abc.com.

    If not, that could be a dummy address.

    With the best regards and thanks,
    Saradhi Motamarri
    +61430022130
    Sent from Yahoo Mail for iPhone





  • 12.  RE: 25572 error when hostname is used

    Posted Mon April 06, 2020 06:01 AM
    Ping to "abc.xyz.com" and "abc" individually is successful and displays the IP as "10.10.10.10" in the output of both the ping commands. The output of the "hostname" command displays "abc.xyz.com" correctly.

    Ping to "xyz.abc.com".
    I did that also and the output is "Name or service not known".

    ------------------------------
    Neville Monteiro
    ------------------------------



  • 13.  RE: 25572 error when hostname is used

    Posted Mon April 06, 2020 06:05 AM

    Neville

     

     

    If you run 'netstat -pale' | more

     

    Do you see the hostname and service num or name ?

     

    Eric Vercelletto
    Data Management Architect and Owner / Begooden IT Consulting
    Board of Directors, International Informix Users group
    IBM Champion 2013,2014,2015,2016,2017,2018,2019,2020
    ibm-champion-rgb-130px

    Tel:     +33(0) 298 51 3210
    Mob : +33(0)626 52 50 68
    skype: begooden-it
    Google Hangout: eric.vercelletto@begooden-it.com
    Email:
    eric.vercelletto@begooden-it.com
    www :
    http://www.vercelletto.com
    www  https://kandooerp.org

    image001.jpg@01CDC3E9.1425CBB0

    image002.jpg@01CDC3E9.1425CBB0

    image003.jpg@01CDC3E9.1425CBB0

     

     






  • 14.  RE: 25572 error when hostname is used

    Posted Mon April 06, 2020 06:16 AM
    In the output of 'netstat -pale' | more" command, in the "Local Address" column for the "oninit" process "abc.xyz.com.servicename" is displayed.

    ------------------------------
    Neville Monteiro
    ------------------------------



  • 15.  RE: 25572 error when hostname is used

    Posted Sun April 05, 2020 11:24 AM
    Hi Neville,
    What is the OS error in the -25572 error?

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 16.  RE: 25572 error when hostname is used

    Posted Mon April 06, 2020 06:04 AM
    SangGyu Jeong,

    I nullified the log file after it was able to connect successfully using "abc" in the hostname of the sqlhosts file. Is there any other way to find out the error on the OS side ?

    ------------------------------
    Neville Monteiro
    ------------------------------



  • 17.  RE: 25572 error when hostname is used

    Posted Mon April 06, 2020 07:31 AM
    Edited by System Admin Fri January 20, 2023 04:51 PM
    @Neville Monteiro

    When the 25572 error message occurs, the oserr number is displayed in the online log file as shown below.
    I think it might help to guess the cause based on the error number.
    13:00:00 listener-thread: err = -25572: oserr = 98: errstr = : Network driver cannot 
    bind a name to the port. System error = 98.
    13:00:00 sql_listener: ASF_LISTEN failed
    13:00:00 Attempting to bring listener thread down.​

    https://www.ibm.com/support/pages/informix-fails-start-25572-error



    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 18.  RE: 25572 error when hostname is used

    Posted Tue April 07, 2020 12:24 PM
    Yes, I remember the error being displayes as "Network driver cannot bind a name to the port.". Although I don't remember the system error it displayed. Can we get the system error from any of the OS files ?

    ------------------------------
    Neville Monteiro
    ------------------------------



  • 19.  RE: 25572 error when hostname is used

    Posted Tue April 07, 2020 12:45 PM

    I would say the best bet would be to try separate lines in /etc/hosts for each entry:

     

     

    10.10.10.10 abc.xyz.com

    10.10.10 10  abc

     

    if that does not work then something in sqlhosts file is throwing things off as it points to /etc/services.

     

    post the entries  from /etc/services file where the tcp/ip port is defined.

    same for the sqlhosts file.

     

     

     






  • 20.  RE: 25572 error when hostname is used

    Posted Tue April 07, 2020 01:39 PM
    sqlhosts :-
    olr_bela         onsoctcp                 dcinfdb01              olrbela

    /etc/services :-
    olrbela      55041/tcp

    ------------------------------
    Neville Monteiro
    ------------------------------



  • 21.  RE: 25572 error when hostname is used

    Posted Tue April 07, 2020 01:56 PM
    Please also post Dbservername configuration value and INFORMIXSERVER environment variable value for the server.
     
    Scott Pickett
    IBM Informix WW Technical Sales
    IBM Informix WW Cloud Technical Sales
    IBM Informix WW Cloud Technical Sales ICIAE
    IBM Informix WW Informix Warehouse Accelerator Sales
    Boston, Massachusetts USA
    spickett@us.ibm.com
    617-899-7549
    33 Years Informix User
     
    The Informix Roadshow page is here:

    https://www.ibm.com/developerworks/mydeveloperworks/wikis/home?lang=en_US#/wiki/Informix%20Roadshow%20-%20Informix%20is%20Everywhere

    Shortcut to the Informix Roadshow Page:

    http://bit.ly/ifmx_roadshow

    All presentations and the agenda used by the Roadshow can be found there.
     
    The current ZACS Informix Page can be found here:
     
     
     





  • 22.  RE: 25572 error when hostname is used

    Posted Tue April 07, 2020 02:32 PM
    Dbservername configuration value and INFORMIXSERVER environment variable are both "olr_bela".

    ------------------------------
    Neville Monteiro
    ------------------------------



  • 23.  RE: 25572 error when hostname is used

    Posted Tue April 07, 2020 04:38 AM
    Hi,

    Maybe there is one resolution problem, create one empty file called IFX_DISABLE_IPV6 on your $INFORMIXDIR/etc and restart your engine.
    [touch $INFORMIXDIR/etc/IFX_DISABLE_IPV6]

    Then verify if the daemon is running over the TCP port [ss -lp]

    SP

    ------------------------------
    Sergio Peres
    AIRC
    Coimbra
    ------------------------------



  • 24.  RE: 25572 error when hostname is used

    Posted Tue April 07, 2020 10:09 AM

    Good spot, if IPV6 is active but not fully configured you can get issues with connectivity (12.10.FC<I forget> in my world)

     

    Cheers

    Paul

     






  • 25.  RE: 25572 error when hostname is used

    Posted Tue April 07, 2020 01:04 PM
    Sergio Peres,

    Will do the following on the next system down time :-
    1) shutdown the engine.
    2) Remove "abc" from the /etc/hosts file and change "abc" to "abc.xyz.com" in the sqlhosts file.
    3) From "informix" login, execute the command "touch $INFORMIXDIR/etc/IFX_DISABLE_IPV6" to create the file named "$INFORMIXDIR/etc/IFX_DISABLE_IPV6"
    4) start the engine
    5) execute the command "ss -lp | grep <port number on which the tcp connection of the databaseserver is running"

    I just checked the "ss -lp | grep 55041" command (55041 is the port number on which the tcp connection of the databaseserver is running) and following is the output :-

    informix > ss -lp | grep 55041
    tcp LISTEN 0 128 10.10.10.10:55041 *:*
     informix >

    Just wanted to know what does it tell us now when the databaseserver is currently running with the alias name as "abc" for the IP as 10.10.10.10 ?

    ------------------------------
    Neville Monteiro
    ------------------------------



  • 26.  RE: 25572 error when hostname is used

    Posted Tue April 07, 2020 01:49 PM
    Hi Neville,

    You can see the hostname with: ss -lpr

    You can see how informix is interpreting with: onstat -g dis

    I hope this can help,

    SP

    ------------------------------
    Sergio Peres
    AIRC
    Coimbra
    ------------------------------



  • 27.  RE: 25572 error when hostname is used

    Posted Tue April 07, 2020 02:49 PM
    Yes, The command "ss -lpr" displays the hostname, but how I know how informix is interpreting the hostname with "ontat -g dic" ?. Kindly guide.

    ------------------------------
    Neville Monteiro
    ------------------------------



  • 28.  RE: 25572 error when hostname is used

    Posted Tue April 07, 2020 03:06 PM
    Hi,

    Not dic but dis ; that option tell about the listener configuration

    SP

    ------------------------------
    Sergio Peres
    AIRC
    Coimbra
    ------------------------------



  • 29.  RE: 25572 error when hostname is used

    Posted Tue April 07, 2020 03:21 PM
    I got it. Thank you very much.

    ------------------------------
    Neville Monteiro
    ------------------------------