25572 error when hostname is used

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

It may be that xyz.com is not registered as a valid domain in the DNS. Art

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 ------------------------------

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

Hi Neville, What is the OS error in the -25572 error? ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------

Neville: OK, so is there a domain name set in the environment? You can check with domainname: $ domainnamekagelzone.com Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ 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.

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

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 ------------------------------

Sir, Following is the output of the "domainname" command :- informix > domainname (none) informix > ------------------------------ Neville Monteiro ------------------------------

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 ------------------------------

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 ------------------------------

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 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

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 ------------------------------

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 ------------------------------

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 ------------------------------

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

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 ------------------------------

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 ------------------------------

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 www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ 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.

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.

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 ------------------------------

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 ------------------------------

sqlhosts :- olr_bela onsoctcp dcinfdb01 olrbela /etc/services :-olrbela 55041/tcp ------------------------------ Neville Monteiro ------------------------------

Hi Neville, You can see the hostname with: ss -lpr You can see how informix is interpreting with: onstat -g disI hope this can help, SP ------------------------------ Sergio Peres AIRC Coimbra ------------------------------

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: https://w3-connections.ibm.com/wikis/home?lang=en#!/wiki/Wf58c4c538dbf_45b4_b7a7_5003d0ceb79b/page/Informix The older Internal IMAZ CTP Informix Main Page can be found here: https://w3-connections.ibm.com/wikis/home?lang=en-us#!/wiki/Info%20Mgmt%20Client%20Technical%20Professional%20Resources%20Wiki/page/Informix Website for Internet Of Things https://www.ibm.com/internet-of-things/ Website for Informix https://www.ibm.com/analytics/us/en/technology/informix/

Dbservername configuration value and INFORMIXSERVER environment variable are both "olr_bela". ------------------------------ Neville Monteiro ------------------------------

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 ------------------------------

Hi, Not dic but dis ; that option tell about the listener configuration SP ------------------------------ Sergio Peres AIRC Coimbra ------------------------------

I got it. Thank you very much. ------------------------------ Neville Monteiro ------------------------------