Cheetah 2 on Windows Vista (64bits)
IDS 11.50.FC2 on 64-bit Vista worked fine from DB-Access, but JDBC clients (Server Studio, ILogin) failed with error -908 connecting to the server. Cause: Vista's IPV6_V6ONLY default meant the server, configured with HOST "*hostname", listened only on IPv6, while the Java clients used IPv4. Workarounds: add -Djava.net.preferIPv6Addresses=true to the client's Java command line, or drop the "*" / set an IPv4 host via setnet32. An IBM poster noted it was addressed in 11.50xC3.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi all,
I am running:
IBM Informix Dynamic Server Version 11.50.FC2
Software Serial Number AAA#B000000
Thu Aug 14 22:40:58 CDT 2008
On Windows Vista 64 bits...
I manage to connect to the engine via DB-Access, do all I want to do...
However, as soon as I want to go through Server Studio (or other JDBC, or
even ILogin), it fails...
Here is my env / what I did...
Firewall has exceptions on 9088, oninit, onspaces, dbaccess (most of them I
did not set myself).
If I run netstat, I see:
C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50>netstat -a | grep
9088
TCP [::]:9088 bugsbunny:0 LISTENING
There is nothing else on 9088, if I stop the service or oninit, nothing is
listening anymore.
Here is my env:
set INFORMIXDIR=C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50
set INFORMIXSERVER=ol_bugsbunny
set ONCONFIG=ONCONFIG.ol_bugsbunny
set PATH=C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\bin;%PATH%set
CLASSPATH=%INFORMIXDIR%\\\\extend\\\\krakatoa\\\\krakatoa.jar;%INFORMIXDIR%\\\\extend\\\\kr
akatoa\\\\jdbc.jar;%CLASSPATH%
set DBTEMP=C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\infxtmp
rem set CLIENT_LOCALE=EN_US.CP1252
rem set DB_LOCALE=EN_US.8859-1
rem set SERVER_LOCALE=EN_US.CP1252
rem set DBLANG=EN_US.CP1252
set CLIENT_LOCALE=EN_US.utf8
set DB_LOCALE=EN_US.utf8set SERVER_LOCALE=EN_US.utf8
set DBLANG=EN_US.utf8
mode con codepage select=1252
In my registry, I have:
SQLHOSTS
+- ol_bugsbunny
+- HOST = *bugsbunny
+- OPTIONS =
+- PROTOCOL = olscotcp
+- SERVICE = svc_bugsbunny
Here is my log:
Wed Oct 22 12:27:41 2008
12:27:41 Warning: ONCONFIG dump directory (DUMPDIR)
'C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp' has insecure permissions
12:27:41 Booting Language <c> from module <>
12:27:41 Loading Module <CNULL>
12:27:41 Booting Language <builtin> from module <>
12:27:41 Loading Module <BUILTINNULL>
12:27:41 Could not disable priority aging: errno = 0
12:27:46 DR: DRAUTO is 0 (Off)
12:27:46 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
12:27:46 IBM Informix Dynamic Server Version 11.50.FC2 Software Serial
Number AAA#B000000
12:27:47 IBM Informix Dynamic Server Initialized -- Shared Memory
Initialized.
12:27:48 Started 1 B-tree scanners.
12:27:48 B-tree scanner threshold set at 5000.
12:27:48 B-tree scanner range scan size set to -1.
12:27:48 B-tree scanner ALICE mode set to 6.
12:27:48 B-tree scanner index compression level set to med.
12:27:48 Physical Recovery Started at Page (1:5168).
12:27:48 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
12:27:48 Logical Recovery Started.
12:27:48 10 recovery worker threads will be started.
12:27:48 Logical Recovery has reached the transaction cleanup phase.
12:27:48 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
12:27:49 Dataskip is now OFF for all dbspaces
12:27:50 Init operation complete - Mode Online
12:27:50 Checkpoint Completed: duration was 0 seconds.
12:27:50 Wed Oct 22 - loguniq 10, logpos 0x50c018, timestamp: 0xa2fe4
Interval: 964
12:27:50 Maximum server connections 0
12:27:50 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 0, Llog used 1
12:27:50 On-Line Mode
12:27:51 SCHAPI: Started dbScheduler thread.
12:27:52 Booting Language <spl> from module <>
12:27:52 Loading Module <SPLNULL>
12:27:52 SCHAPI: Started 2 dbWorker threads.
12:32:49 Checkpoint Completed: duration was 0 seconds.
12:32:49 Wed Oct 22 - loguniq 10, logpos 0x518018, timestamp: 0xa38eb
Interval: 965
12:32:49 Maximum server connections 0
12:32:49 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 16, Llog used 12
12:47:49 Checkpoint Completed: duration was 0 seconds.
12:47:49 Wed Oct 22 - loguniq 10, logpos 0x52e018, timestamp: 0xa3a7d
Interval: 966
12:47:49 Maximum server connections 0
12:47:49 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 32, Llog used 22
13:02:49 Checkpoint Completed: duration was 0 seconds.
13:02:49 Wed Oct 22 - loguniq 10, logpos 0x52f044, timestamp: 0xa3a89
Interval: 967
13:02:49 Maximum server connections 0
13:02:49 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 2, Llog used 1
13:17:49 Checkpoint Completed: duration was 0 seconds.
13:17:49 Wed Oct 22 - loguniq 10, logpos 0x530044, timestamp: 0xa3a95
Interval: 968
13:17:49 Maximum server connections 0
13:17:49 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 2, Llog used 1
Jean, probably a very long shot: +- PROTOCOL = olscotcp Is this a typo or...? I don't have any Windows installations, but I would expect to see "olsoctcp" there too (notice: sco <-> soc). But I may be completely missing the point here... Cheers Davorin
Jean, 1/ Protocol should be olsoctcp 2/ What does the eror message say ? Regards, Henri Jean Georges Perrin a écrit : > Hi all, > > I am running: > IBM Informix Dynamic Server Version 11.50.FC2 > Software Serial Number AAA#B000000 > Thu Aug 14 22:40:58 CDT 2008 > > On Windows Vista 64 bits... > > I manage to connect to the engine via DB-Access, do all I want to do... > > However, as soon as I want to go through Server Studio (or other JDBC, or > even ILogin), it fails... > >
Server Studio: Error -908: Attempt to connect to database server (ol_bugsbunny) failed. (it was olsoctcp already, typo). Ilogin now works! Still no success with Server Studio. > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Henri MOUKOURI > Sent: Wednesday, 22 October, 2008 13:49 > To: ids@iiug.org > Subject: Re: Cheetah 2 on Windows Vista (64bits) [13758] > > Jean, > > 1/ Protocol should be olsoctcp > > 2/ What does the eror message say ? > > Regards, > Henri > > Jean Georges Perrin a écrit : > > Hi all, > > > > I am running: > > IBM Informix Dynamic Server Version 11.50.FC2 > > Software Serial Number AAA#B000000 > > Thu Aug 14 22:40:58 CDT 2008 > > > > On Windows Vista 64 bits... > > > > I manage to connect to the engine via DB-Access, do all I want to > do... > > > > However, as soon as I want to go through Server Studio (or other > JDBC, or > > even ILogin), it fails... > > > > > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.
Ok -- I found it... It's ALWAYS the same problem with Vista and I forgot about it... I really need to write something in my blog... As Vista is TCP/IP version 6, you need to run java in IPv6... To do so, add: -Djava.net.preferIPv6Addresses=true To the Java command line If you used server studio, change the command line to something like: "C:\\\\Program Files (x86)\\\\AGS\\\\jre\\\\bin\\\\javaw.exe" -Xmx384m -Dsun.java2d.noddraw=true -Djava.net.preferIPv6Addresses=true -classpath ".;lib\\\\ifxjdbc.jar;lib\\\\derby.jar;lib\\\\jh.jar;lib\\\\tools.jar" launcher -root "C:\\\\Program Files (x86)\\\\AGS" > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Jean Georges Perrin > Sent: Wednesday, 22 October, 2008 17:08 > To: ids@iiug.org > Subject: RE: Cheetah 2 on Windows Vista (64bits) [13759] > > Server Studio: > > Error -908: Attempt to connect to database server (ol_bugsbunny) > failed. > > (it was olsoctcp already, typo). > > Ilogin now works! Still no success with Server Studio. > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > Henri MOUKOURI > > Sent: Wednesday, 22 October, 2008 13:49 > > To: ids@iiug.org > > Subject: Re: Cheetah 2 on Windows Vista (64bits) [13758] > > > > Jean, > > > > 1/ Protocol should be olsoctcp > > > > 2/ What does the eror message say ? > > > > Regards, > > Henri > > > > Jean Georges Perrin a écrit : > > > Hi all, > > > > > > I am running: > > > IBM Informix Dynamic Server Version 11.50.FC2 > > > Software Serial Number AAA#B000000 > > > Thu Aug 14 22:40:58 CDT 2008 > > > > > > On Windows Vista 64 bits... > > > > > > I manage to connect to the engine via DB-Access, do all I want to > > do... > > > > > > However, as soon as I want to go through Server Studio (or other > > JDBC, or > > > even ILogin), it fails... > > > > > > > > > > > > > *********************************************************************** > > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.
Excellent tip ! I was given another way to connect but some troubles... This seem the way to go with Server Studio. J. 2008/10/22 Jean Georges Perrin <jgp@jgp.net> > Ok -- I found it... > > It's ALWAYS the same problem with Vista and I forgot about it... I really > need to write something in my blog... > > As Vista is TCP/IP version 6, you need to run java in IPv6... To do so, > add: > > -Djava.net.preferIPv6Addresses=true > > To the Java command line > > If you used server studio, change the command line to something like: > > "C:\\\\Program Files (x86)\\\\AGS\\\\jre\\\\bin\\\\javaw.exe" -Xmx384m > -Dsun.java2d.noddraw=true -Djava.net.preferIPv6Addresses=true -classpath > ".;lib\\\\ifxjdbc.jar;lib\\\\derby.jar;lib\\\\jh.jar;lib\\\\tools.jar" launcher -root > "C:\\\\Program Files (x86)\\\\AGS" > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > Jean Georges Perrin > > Sent: Wednesday, 22 October, 2008 17:08 > > To: ids@iiug.org > > Subject: RE: Cheetah 2 on Windows Vista (64bits) [13759] > > > > Server Studio: > > > > Error -908: Attempt to connect to database server (ol_bugsbunny) > > failed. > > > > (it was olsoctcp already, typo). > > > > Ilogin now works! Still no success with Server Studio. > > > > > -----Original Message----- > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > > Henri MOUKOURI > > > Sent: Wednesday, 22 October, 2008 13:49 > > > To: ids@iiug.org > > > Subject: Re: Cheetah 2 on Windows Vista (64bits) [13758] > > > > > > Jean, > > > > > > 1/ Protocol should be olsoctcp > > > > > > 2/ What does the eror message say ? > > > > > > Regards, > > > Henri > > > > > > Jean Georges Perrin a écrit : > > > > Hi all, > > > > > > > > I am running: > > > > IBM Informix Dynamic Server Version 11.50.FC2 > > > > Software Serial Number AAA#B000000 > > > > Thu Aug 14 22:40:58 CDT 2008 > > > > > > > > On Windows Vista 64 bits... > > > > > > > > I manage to connect to the engine via DB-Access, do all I want to > > > do... > > > > > > > > However, as soon as I want to go through Server Studio (or other > > > JDBC, or > > > > even ILogin), it fails... > > > > > > > > > > > > > > > > > > > *********************************************************************** > > > ******** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > *********************************************************************** > > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >
You're right. Vista socket option IPV6_V6ONLY is 'true' by default. When we set hostname as "*myvista" in registry, IDS server only can accept IPv6 address. if you want use IPv4 address, you can remove "*" from hostname or change to IPv4 address with 'setnet32' utility. BTW this issue is fixed in 11.50xC3 release. Thanks Jim
Which issue? The Java stuff or the hostname? > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > JIM XIAO > Sent: Thursday, 23 October, 2008 18:43 > To: ids@iiug.org > Subject: Re: Cheetah 2 on Windows Vista (64bits) [13779] > > You're right. Vista socket option IPV6_V6ONLY is 'true' by default. > > When we set hostname as "*myvista" in registry, IDS server only can > accept > IPv6 address. if you want use IPv4 address, you can remove "*" from > hostname > or change to IPv4 address with 'setnet32' utility. > > BTW this issue is fixed in 11.50xC3 release. > > Thanks > Jim > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.
when "*hostname" is used on Vista, IDS 11.50xC3 can work with both IPv4 and IPv6 clients, no workaround needed. But with 11.50xC1/2 we need modify hostname registry or java client as workaround. Thanks
That will permit using Server Studio with no trouble ... J. 2008/10/23 JIM XIAO <jxiao01@yahoo.com> > when "*hostname" is used on Vista, IDS 11.50xC3 can work with both IPv4 and > IPv6 clients, no workaround needed. But with 11.50xC1/2 we need modify > hostname registry or java client as workaround. > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >