ids without network?

Posted in 2011

Summary

Problem: IDS 11.70.TC3IE on Windows Server 2008 wouldn't start/run on a demo laptop unless the machine was connected to a network. Suggested fix: make the server listen on the loopback interface by using localhost/127.0.0.1 instead of the machine's hostname — on Unix in $INFORMIXDIR/etc/sqlhosts (or alias the hostname to localhost in /etc/hosts), and on Windows in the sqlhosts registry key (HKLM\\\\software\\\\Informix\\\\sqlhosts\\\\<server>, Host value), then restart the IDS service. Art Kagel noted INFORMIXSQLHOSTS only matters for a non-default sqlhosts file/location, so its blank setting in setnet32 was irrelevant. The poster never confirmed whether this worked, so no confirmed resolution is recorded.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

Bill Hamilton — Thu, 29 Dec 2011 04:51:44 — source: IIUG Forums & Mailing Lists

This concerns IDS 11.70.TC3IE on Window Server 2008. We have laptop that we can use for demos but Informix will not run without a connection to a network. Is there a setting someplace that will allow this?

↪ replying to Bill Hamilton

Joerg Volz — Thu, 29 Dec 2011 09:09:29 — source: IIUG Forums & Mailing Lists

take localhost on 127.0.0.1 ? Mfg Joerg Volz Am 29.12.2011 um 06:01 schrieb "Bill Hamilton" <garage_dba@hotmail.com>: > This concerns IDS 11.70.TC3IE on Window Server 2008.=20 > We have laptop that we can use for demos but Informix will not run = without a=20 > connection to a network.=20 > Is there a setting someplace that will allow this?=20 >=20 >=20 > = *************************************************************************= ******=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 >=20 IT Handel und Beratung Jorg Volz Bernhard-Fruh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de

↪ replying to Joerg Volz

Bill Hamilton — Thu, 29 Dec 2011 22:04:42 — source: IIUG Forums & Mailing Lists

Where do you suggest I put 127.0.0.1 ? -----Original Message----- From: Joerg Volz Sent: Thursday, December 29, 2011 3:09 AM To: ids@iiug.org Subject: Re: ids without network? [25771] take localhost on 127.0.0.1 ? Mfg Joerg Volz Am 29.12.2011 um 06:01 schrieb "Bill Hamilton" <garage_dba@hotmail.com>: > This concerns IDS 11.70.TC3IE on Window Server 2008.=20 > We have laptop that we can use for demos but Informix will not run = without a=20 > connection to a network.=20 > Is there a setting someplace that will allow this?=20 >=20 >=20 > = *************************************************************************= ******=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 >=20 IT Handel und Beratung Jorg Volz Bernhard-Fruh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Joerg Volz

Joerg Volz — Thu, 29 Dec 2011 22:21:05 — source: IIUG Forums & Mailing Lists

127.0.0.1 is always set to the hostname localhost in /etc/hosts (*nix machines) or /Windows/System32/Drivers/etc/hosts. Every machine is able to find "herself" by referring to localhost or 127.0.0.1 Assuming a "standard" Informix on a Unix box: Usually the hostname is in $INFORMIXDIR/etc/sqlhosts: replace the hostname with "localhost" it´s usually the 3rd entry or if you run on a not network connected box, you can modify /etc/hosts on the Unix side and add your hostname from sqlhosts as an alias to the localhost entry in /etc/hosts. Another possibility: If you run your Demo System with VMWare, add the VMware Network to your VMWare Software, and use a address from this VMware network and set the appropriate hostname/IP entries in /etc/hosts. Regards, Joerg Volz ----------------------------------------------------------------------------- -----Original Message----- From: Bill Hamilton [mailto:garage_dba@hotmail.com] Sent: Thursday, December 29, 2011 11:05 PM To: ids@iiug.org Cc: Joerg Volz Subject: Re: ids without network? [25771] Where do you suggest I put 127.0.0.1 ? -----Original Message----- From: Joerg Volz Sent: Thursday, December 29, 2011 3:09 AM To: ids@iiug.org Subject: Re: ids without network? [25771] take localhost on 127.0.0.1 ? Mfg Joerg Volz Am 29.12.2011 um 06:01 schrieb "Bill Hamilton" <garage_dba@hotmail.com>: > This concerns IDS 11.70.TC3IE on Window Server 2008.=20 > We have laptop that we can use for demos but Informix will not run = without a=20 > connection to a network.=20 > Is there a setting someplace that will allow this?=20 >=20 >=20 > = *************************************************************************= ******=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 >=20 IT Handel und Beratung Jorg Volz Bernhard-Fruh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. IT Handel und Beratung Jörg Volz Bernhard-Früh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de

↪ replying to Joerg Volz

Bill Hamilton — Fri, 30 Dec 2011 03:37:57 — source: IIUG Forums & Mailing Lists

There is no such file on a Windows installation in the "%INFORMIXDIR%/etc" folder or anyplace that I know of. The registry is used, I believe. Under "HKEY_LOCAL_MACHINE/software/Informix/sqlhosts/databasename" I have: Host REG_SZ *sixfore Protocol REG_SZ olsoctcp Service REG_SZ turbo6 My machine name is sixfore (not the laptop in question, but it is not here now and it runs the same os and IDS version) . I guess you are saying to replace "*sixfore" with 127.0.0.1 and bounce the IDS service? Also setnet32 has a line without a value: INFORMIXSQLHOSTS= does this need to change? -----Original Message----- From: Joerg Volz Sent: Thursday, December 29, 2011 4:19 PM To: Bill Hamilton ; ids@iiug.org Subject: RE: ids without network? [25771] 127.0.0.1 is always set to the hostname localhost in /etc/hosts (*nix machines) or /Windows/System32/Drivers/etc/hosts. Every machine is able to find "herself" by referring to localhost or 127.0.0.1 Assuming a "standard" Informix on a Unix box: Usually the hostname is in $INFORMIXDIR/etc/sqlhosts: replace the hostname with "localhost" it´s usually the 3rd entry or if you run on a not network connected box, you can modify /etc/hosts on the Unix side and add your hostname from sqlhosts as an alias to the localhost entry in /etc/hosts. Another possibility: If you run your Demo System with VMWare, add the VMware Network to your VMWare Software, and use a address from this VMware network and set the appropriate hostname/IP entries in /etc/hosts. Regards, Joerg Volz ----------------------------------------------------------------------------- -----Original Message----- From: Bill Hamilton [mailto:garage_dba@hotmail.com] Sent: Thursday, December 29, 2011 11:05 PM To: ids@iiug.org Cc: Joerg Volz Subject: Re: ids without network? [25771] Where do you suggest I put 127.0.0.1 ? -----Original Message----- From: Joerg Volz Sent: Thursday, December 29, 2011 3:09 AM To: ids@iiug.org Subject: Re: ids without network? [25771] take localhost on 127.0.0.1 ? Mfg Joerg Volz Am 29.12.2011 um 06:01 schrieb "Bill Hamilton" <garage_dba@hotmail.com>: > This concerns IDS 11.70.TC3IE on Window Server 2008.=20 > We have laptop that we can use for demos but Informix will not run = without a=20 > connection to a network.=20 > Is there a setting someplace that will allow this?=20 >=20 >=20 > = *************************************************************************= ******=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 >=20 IT Handel und Beratung Jorg Volz Bernhard-Fruh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. IT Handel und Beratung Jörg Volz Bernhard-Früh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de

↪ replying to Bill Hamilton

Art Kagel — Fri, 30 Dec 2011 04:21:28 — source: IIUG Forums & Mailing Lists

INFORMIXSQLHOSTS only needs to be set if you have an sqlhosts file named something other than 'sqlhosts' or which is in a location other than the 'etc' subdirectory under INFORMIXDIR. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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. On Thu, Dec 29, 2011 at 10:37 PM, Bill Hamilton <garage_dba@hotmail.com>wrote: > There is no such file on a Windows installation in the "%INFORMIXDIR%/etc" > folder or anyplace that I know of. > The registry is used, I believe. > > Under "HKEY_LOCAL_MACHINE/software/Informix/sqlhosts/databasename" I have: > Host REG_SZ *sixfore > Protocol REG_SZ olsoctcp > Service REG_SZ turbo6 > > My machine name is sixfore (not the laptop in question, but it is not here > now and it runs the same os and IDS version) . > I guess you are saying to replace "*sixfore" with 127.0.0.1 and bounce the > IDS service? > > Also setnet32 has a line without a value: > INFORMIXSQLHOSTS= > does this need to change? > > -----Original Message----- > From: Joerg Volz > Sent: Thursday, December 29, 2011 4:19 PM > To: Bill Hamilton ; ids@iiug.org > Subject: RE: ids without network? [25771] > > 127.0.0.1 is always set to the hostname localhost in /etc/hosts (*nix > machines) or /Windows/System32/Drivers/etc/hosts. Every machine is able to > find "herself" by referring to localhost or 127.0.0.1 > > Assuming a "standard" Informix on a Unix box: > > Usually the hostname is in $INFORMIXDIR/etc/sqlhosts: > replace the hostname with "localhost" it´s usually the 3rd entry > > or if you run on a not network connected box, you can modify /etc/hosts on > the Unix side and add your hostname from sqlhosts as an alias to the > localhost entry in /etc/hosts. > > Another possibility: > > If you run your Demo System with VMWare, add the VMware Network to your > VMWare Software, and use a address from this VMware network and set the > appropriate hostname/IP entries in /etc/hosts. > > Regards, > Joerg Volz > > ----------------------------------------------------------------------------- > > -----Original Message----- > From: Bill Hamilton [mailto:garage_dba@hotmail.com] > Sent: Thursday, December 29, 2011 11:05 PM > To: ids@iiug.org > Cc: Joerg Volz > Subject: Re: ids without network? [25771] > > Where do you suggest I put 127.0.0.1 ? > > -----Original Message----- > From: Joerg Volz > Sent: Thursday, December 29, 2011 3:09 AM > To: ids@iiug.org > Subject: Re: ids without network? [25771] > > take localhost on 127.0.0.1 ? > > Mfg > Joerg Volz > > Am 29.12.2011 um 06:01 schrieb "Bill Hamilton" <garage_dba@hotmail.com>: > > > This concerns IDS 11.70.TC3IE on Window Server 2008.=20 > > We have laptop that we can use for demos but Informix will not run = > without a=20 > > connection to a network.=20 > > Is there a setting someplace that will allow this?=20 > >=20 > >=20 > > = > *************************************************************************= > ******=20 > > Forum Note: Use "Reply" to post a response in the discussion forum.=20 > >=20 > >=20 > >=20 > > IT Handel und Beratung Jorg Volz > Bernhard-Fruh-Str. 7 > 77855 Achern > GERMANY > > Tel: +49 (0)7841-681651 > Fax: +49 (0)7841-681654 > Mobil: +49 (0)170-2989757 > > VAT-ID: DE201383541 > > http://www.it-volz.de > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > IT Handel und Beratung Jörg Volz > Bernhard-Früh-Str. 7 > 77855 Achern > GERMANY > > Tel: +49 (0)7841-681651 > Fax: +49 (0)7841-681654 > Mobil: +49 (0)170-2989757 > > VAT-ID: DE201383541 > > http://www.it-volz.de > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae934040fb9cab604b5479092

↪ replying to Joerg Volz

Joerg Volz — Fri, 30 Dec 2011 08:25:06 — source: IIUG Forums & Mailing Lists

as Art said, INFORMIXHOSTS is of no interest in this case. I never run a = IDS under Windows, but that registry entry you mentioned should be the = right one, but please: enter localhost, not the IP Adress... =20 If I am wrong, please correct me. To all A happy new year!=20 Mfg Joerg Volz Am 30.12.2011 um 04:36 schrieb "Bill Hamilton" <garage_dba@hotmail.com>: > There is no such file on a Windows installation in the = "%INFORMIXDIR%/etc" folder or anyplace that I know of. > The registry is used, I believe. >=20 > Under "HKEY_LOCAL_MACHINE/software/Informix/sqlhosts/databasename" I = have: > Host REG_SZ *sixfore > Protocol REG_SZ olsoctcp > Service REG_SZ turbo6 >=20 > My machine name is sixfore (not the laptop in question, but it is not = here now and it runs the same os and IDS version) . > I guess you are saying to replace "*sixfore" with 127.0.0.1 and bounce = the IDS service? >=20 > Also setnet32 has a line without a value: > INFORMIXSQLHOSTS=3D> does this need to change? >=20 >=20 > -----Original Message----- From: Joerg Volz > Sent: Thursday, December 29, 2011 4:19 PM > To: Bill Hamilton ; ids@iiug.org > Subject: RE: ids without network? [25771] >=20 > 127.0.0.1 is always set to the hostname localhost in /etc/hosts (*nix = machines) or /Windows/System32/Drivers/etc/hosts. Every machine is able = to find "herself" by referring to localhost or 127.0.0.1 >=20 >=20 > Assuming a "standard" Informix on a Unix box: >=20 > Usually the hostname is in $INFORMIXDIR/etc/sqlhosts: > replace the hostname with "localhost" it=C3=82=C2=B4s usually the = 3rd entry >=20 > or if you run on a not network connected box, you can modify = /etc/hosts on the Unix side and add your hostname from sqlhosts as an = alias to the localhost entry in /etc/hosts. >=20 > Another possibility: >=20 > If you run your Demo System with VMWare, add the VMware Network to = your VMWare Software, and use a address from this VMware network and set = the appropriate hostname/IP entries in /etc/hosts. >=20 > Regards, > Joerg Volz > = -------------------------------------------------------------------------= ---- >=20 >=20 > -----Original Message----- > From: Bill Hamilton [mailto:garage_dba@hotmail.com] > Sent: Thursday, December 29, 2011 11:05 PM > To: ids@iiug.org > Cc: Joerg Volz > Subject: Re: ids without network? [25771] >=20 > Where do you suggest I put 127.0.0.1 ? >=20 > -----Original Message----- From: Joerg Volz > Sent: Thursday, December 29, 2011 3:09 AM > To: ids@iiug.org > Subject: Re: ids without network? [25771] >=20 > take localhost on 127.0.0.1 ? >=20 > Mfg > Joerg Volz >=20 > Am 29.12.2011 um 06:01 schrieb "Bill Hamilton" = <garage_dba@hotmail.com>: >=20 >> This concerns IDS 11.70.TC3IE on Window Server 2008.=3D20 >> We have laptop that we can use for demos but Informix will not run = =3D > without a=3D20 >> connection to a network.=3D20 >> Is there a setting someplace that will allow this?=3D20 >> =3D20 >> =3D20 >> =3D > = *************************************************************************= =3D > ******=3D20 >> Forum Note: Use "Reply" to post a response in the discussion = forum.=3D20 >> =3D20 >> =3D20 >> =3D20 >=20 > IT Handel und Beratung Jorg Volz > Bernhard-Fruh-Str. 7 > 77855 Achern > GERMANY >=20 > Tel: +49 (0)7841-681651 > Fax: +49 (0)7841-681654 > Mobil: +49 (0)170-2989757 >=20 > VAT-ID: DE201383541 >=20 > http://www.it-volz.de >=20 >=20 > = *************************************************************************= ****** > Forum Note: Use "Reply" to post a response in the discussion forum. >=20 >=20 > IT Handel und Beratung J=C3=83=C2=B6rg Volz > Bernhard-Fr=C3=83=C2=BCh-Str. 7 > 77855 Achern > GERMANY >=20 > Tel: +49 (0)7841-681651 > Fax: +49 (0)7841-681654 > Mobil: +49 (0)170-2989757 >=20 > VAT-ID: DE201383541 >=20 > http://www.it-volz.de >=20 >=20 >=20 >=20 IT Handel und Beratung J=C3=B6rg Volz Bernhard-Fr=C3=BCh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de

Glossary

IDS (Informix Dynamic Server)