Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

The Macintosh is Xerox technology at its best.

devel / comp.databases.ingres / Is my Ingres server running on Windows?

SubjectAuthor
* Is my Ingres server running on Windows?Roy Hann
`* Re: Is my Ingres server running on Windows?chris.cla...@gmail.com
 `* Re: Is my Ingres server running on Windows?Roy Hann
  `* Re: Is my Ingres server running on Windows?Sarkaut Mohn
   `- Re: Is my Ingres server running on Windows?Roy Hann

1
Is my Ingres server running on Windows?

<ud4n6n$1gc8e$1@dont-email.me>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=280&group=comp.databases.ingres#280

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: specia...@processed.almost.meat (Roy Hann)
Newsgroups: comp.databases.ingres
Subject: Is my Ingres server running on Windows?
Date: Mon, 4 Sep 2023 13:48:07 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 7
Message-ID: <ud4n6n$1gc8e$1@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Date: Mon, 4 Sep 2023 13:48:07 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="8890c8e29c7de41f27cfac743dfebf7b";
logging-data="1585422"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+O9u0ww2/xnlD+LL/7mN5wlx8fy0PLnvE="
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
Cancel-Lock: sha1:e9nTa7qi6DB33OHGsp7ni6f2ZHk=
 by: Roy Hann - Mon, 4 Sep 2023 13:48 UTC

Short of querying ima_version, or parsing the _version() string, or
similar antics, is there a convenient way to tell if my application is
connected to Ingres running on Windows?

Clearly I am hoping for something like dbmsinfo('platform')...

Roy

Re: Is my Ingres server running on Windows?

<456a0a17-16bb-4d0e-a301-3eb4aa18a770n@googlegroups.com>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=281&group=comp.databases.ingres#281

  copy link   Newsgroups: comp.databases.ingres
X-Received: by 2002:a05:620a:6193:b0:76f:c1c:8697 with SMTP id or19-20020a05620a619300b0076f0c1c8697mr225201qkn.8.1693882995766;
Mon, 04 Sep 2023 20:03:15 -0700 (PDT)
X-Received: by 2002:a17:90a:a58f:b0:263:3437:a0b0 with SMTP id
b15-20020a17090aa58f00b002633437a0b0mr2838781pjq.3.1693882995232; Mon, 04 Sep
2023 20:03:15 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!news.mixmin.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Mon, 4 Sep 2023 20:03:14 -0700 (PDT)
In-Reply-To: <ud4n6n$1gc8e$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=50.0.68.221; posting-account=rhMgwAoAAAAneMkY_FhOzl8trOd9MYCn
NNTP-Posting-Host: 50.0.68.221
References: <ud4n6n$1gc8e$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <456a0a17-16bb-4d0e-a301-3eb4aa18a770n@googlegroups.com>
Subject: Re: Is my Ingres server running on Windows?
From: chris.cl...@gmail.com (chris.cla...@gmail.com)
Injection-Date: Tue, 05 Sep 2023 03:03:15 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
 by: chris.cla...@gmail.c - Tue, 5 Sep 2023 03:03 UTC

On Monday, September 4, 2023 at 6:48:09 AM UTC-7, Roy Hann wrote:
> Short of querying ima_version, or parsing the _version() string, or
> similar antics, is there a convenient way to tell if my application is
> connected to Ingres running on Windows?
>
> Clearly I am hoping for something like dbmsinfo('platform')...

I can't think of anything off the top of my head. If it were me, I'd use dbmsinfo('_version'). If you want to avoid that then you could look at port numbers in IMA for (say) the GCN. Windows uses pipes, most installations on Unix are tcp/ip sockets (rather than domain/file sockets), so if you can't successfully cast to an integer its **probably** Windows (or VMS).

The other option might be to poke around locations paths, but again for me version string would be my goto solution.

Out of curiosity, what sort of decisions to you want to make once you have this determined in the application?

Chris

Re: Is my Ingres server running on Windows?

<ud6qco$1tloj$1@dont-email.me>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=282&group=comp.databases.ingres#282

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: specia...@processed.almost.meat (Roy Hann)
Newsgroups: comp.databases.ingres
Subject: Re: Is my Ingres server running on Windows?
Date: Tue, 5 Sep 2023 08:54:48 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 32
Message-ID: <ud6qco$1tloj$1@dont-email.me>
References: <ud4n6n$1gc8e$1@dont-email.me> <456a0a17-16bb-4d0e-a301-3eb4aa18a770n@googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Date: Tue, 5 Sep 2023 08:54:48 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="87a701676adb3949a29741dc2194998c";
logging-data="2021139"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/FOH4EpPXeJRtqM0D0vbeceQ8Ap5YWhDI="
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
Cancel-Lock: sha1:u9/o2awv7hhrtxf2KuUAXarbkgU=
 by: Roy Hann - Tue, 5 Sep 2023 08:54 UTC

chris.cla...@gmail.com wrote:

> On Monday, September 4, 2023 at 6:48:09 AM UTC-7, Roy Hann wrote:
>> Short of querying ima_version, or parsing the _version() string, or
>> similar antics, is there a convenient way to tell if my application is
>> connected to Ingres running on Windows?
>>
>> Clearly I am hoping for something like dbmsinfo('platform')...

> [snip]
>
> Out of curiosity, what sort of decisions to you want to make once you
> have this determined in the application?

I want to know what kind of UUID I'm getting back from

SELECT uuid()

On a 'nix I'll get a Type-1 UUID; on Windows I'll get a Type-4 and the
human-readable representation will be scrambled (seemingly because it's
ignoring endian-ness): e.g. 4dbbb0f1-e68d-834a-8e47-359b73beb840.
According to me that -834a- bit should be -4a83-.

If I know the UUID is coming from Windows I can select hex(uuid()) and
format it correctly myself.

The formatting is my issue; I don't care that the two versions return
different types of UUID--though I can't imagine it's desirable.

Roy

Re: Is my Ingres server running on Windows?

<0610d155-5946-45e0-99f7-eef509a6174bn@googlegroups.com>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=283&group=comp.databases.ingres#283

  copy link   Newsgroups: comp.databases.ingres
X-Received: by 2002:ad4:4f81:0:b0:650:304:5137 with SMTP id em1-20020ad44f81000000b0065003045137mr329121qvb.12.1694000922303;
Wed, 06 Sep 2023 04:48:42 -0700 (PDT)
X-Received: by 2002:a63:2dc4:0:b0:573:fc10:3b33 with SMTP id
t187-20020a632dc4000000b00573fc103b33mr133621pgt.9.1694000921806; Wed, 06 Sep
2023 04:48:41 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Wed, 6 Sep 2023 04:48:41 -0700 (PDT)
In-Reply-To: <ud6qco$1tloj$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=185.114.121.156; posting-account=-ah9zAoAAAB8MzTXFbdDW6xjHHG0FiHu
NNTP-Posting-Host: 185.114.121.156
References: <ud4n6n$1gc8e$1@dont-email.me> <456a0a17-16bb-4d0e-a301-3eb4aa18a770n@googlegroups.com>
<ud6qco$1tloj$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <0610d155-5946-45e0-99f7-eef509a6174bn@googlegroups.com>
Subject: Re: Is my Ingres server running on Windows?
From: sarkaut....@gtempaccount.com (Sarkaut Mohn)
Injection-Date: Wed, 06 Sep 2023 11:48:42 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 2868
 by: Sarkaut Mohn - Wed, 6 Sep 2023 11:48 UTC

Roy Hann schrieb am Dienstag, 5. September 2023 um 10:54:50 UTC+2:
> chris.cla...@gmail.com wrote:
>
> > On Monday, September 4, 2023 at 6:48:09 AM UTC-7, Roy Hann wrote:
> >> Short of querying ima_version, or parsing the _version() string, or
> >> similar antics, is there a convenient way to tell if my application is
> >> connected to Ingres running on Windows?
> >>
> >> Clearly I am hoping for something like dbmsinfo('platform')...
> > [snip]
> >
> > Out of curiosity, what sort of decisions to you want to make once you
> > have this determined in the application?
> I want to know what kind of UUID I'm getting back from
>
> SELECT uuid()
>
> On a 'nix I'll get a Type-1 UUID; on Windows I'll get a Type-4 and the
> human-readable representation will be scrambled (seemingly because it's
> ignoring endian-ness): e.g. 4dbbb0f1-e68d-834a-8e47-359b73beb840.
> According to me that -834a- bit should be -4a83-.
>
> If I know the UUID is coming from Windows I can select hex(uuid()) and
> format it correctly myself.
>
> The formatting is my issue; I don't care that the two versions return
> different types of UUID--though I can't imagine it's desirable.
>
> Roy

If you wanted to get v1 UUID on Windows, you can use II_UUID_MAC set to TRUE.
On Windows, Ingres runs the OS function UuidCreate which generates v4 UUIDs.. With II_UUID_MAC=TRUE, Ingres uses OS function UuidCreateSequential which generates v1 UUIDs. On Linux, Ingres uses an own customized code and generates v1 UUIDs.

Re: Is my Ingres server running on Windows?

<ud9s9r$2girh$1@dont-email.me>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=284&group=comp.databases.ingres#284

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: specia...@processed.almost.meat (Roy Hann)
Newsgroups: comp.databases.ingres
Subject: Re: Is my Ingres server running on Windows?
Date: Wed, 6 Sep 2023 12:45:47 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 46
Message-ID: <ud9s9r$2girh$1@dont-email.me>
References: <ud4n6n$1gc8e$1@dont-email.me> <456a0a17-16bb-4d0e-a301-3eb4aa18a770n@googlegroups.com> <ud6qco$1tloj$1@dont-email.me> <0610d155-5946-45e0-99f7-eef509a6174bn@googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Date: Wed, 6 Sep 2023 12:45:47 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="13497b0483bb0ccab7e91b8792a10ca1";
logging-data="2640753"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+d3HX57+OG832KGIDytqB6kxsYUadeNTA="
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
Cancel-Lock: sha1:mvzHA8tWIKKPHrl82ykxCJO6PrM=
 by: Roy Hann - Wed, 6 Sep 2023 12:45 UTC

Sarkaut Mohn wrote:

> Roy Hann schrieb am Dienstag, 5. September 2023 um 10:54:50 UTC+2:
>> chris.cla...@gmail.com wrote:
>>
>> > On Monday, September 4, 2023 at 6:48:09 AM UTC-7, Roy Hann wrote:
>> >> Short of querying ima_version, or parsing the _version() string, or
>> >> similar antics, is there a convenient way to tell if my application is
>> >> connected to Ingres running on Windows?
>> >>
>> >> Clearly I am hoping for something like dbmsinfo('platform')...
>> > [snip]
>> >
>> > Out of curiosity, what sort of decisions to you want to make once you
>> > have this determined in the application?
>> I want to know what kind of UUID I'm getting back from
>>
>> SELECT uuid()
>>
>> On a 'nix I'll get a Type-1 UUID; on Windows I'll get a Type-4 and the
>> human-readable representation will be scrambled (seemingly because it's
>> ignoring endian-ness): e.g. 4dbbb0f1-e68d-834a-8e47-359b73beb840.
>> According to me that -834a- bit should be -4a83-.
>>
>> If I know the UUID is coming from Windows I can select hex(uuid()) and
>> format it correctly myself.
>>
>> The formatting is my issue; I don't care that the two versions return
>> different types of UUID--though I can't imagine it's desirable.
>
> If you wanted to get v1 UUID on Windows, you can use II_UUID_MAC set to TRUE.
> On Windows, Ingres runs the OS function UuidCreate which generates v4 UUIDs.
> With II_UUID_MAC=TRUE, Ingres uses OS function UuidCreateSequential
> which generates v1 UUIDs. On Linux, Ingres uses an own customized code
> and generates v1 UUIDs.

Ah-hah! I did not know about that. Thank you.

There is still the problem that on Windows the human-readble
representation is garbled though.

As for my original question: I've resigned myself to looking for "win"
in the _version() string. It's not very horrible.

Roy

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor