novaBBS - comp.databases.ingres - Finding ..\ingres\lib for a script

Re: [Info-ingres] Finding ..\ingres\lib for a script

<mailman.125.1642982824.1681.info-ingres@lists.planetingres.org>

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

copy link Newsgroups: comp.databases.ingres

Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!buffer2.nntp.dca1.giganews.com!buffer1.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Sun, 23 Jan 2022 18:08:02 -0600
h=message-id:date:mime-version:user-agent:reply-to:subject
:content-language:to:references:from:organization:in-reply-to
:content-transfer-encoding;
bh=RfGEbHbZtxtBZ332mI6jzovv1S/OZ3ikBVdvOhI/FhU=;
b=nS2Vt6cic/MSxKH2NHVjfhgIj8URf8WwUjkRoNGP6yzV+IlhRrawZrT0g5wnF7G3ER
67ehRup4JLCHYj+fwHzj7KAPE0oFDMOqHX9ciwwfEzWGLdflAgOTW3MIH3X8fAQdLp6q
2eRhf1KEnwyH041zQhTdMmjAwPb9imrBs96K2K8dMft+wKr+VpPTJ61UWsnHjEi+lIqB
ZpqRgQA0xbJ88T90NqJI3o3lW0P6UGHYefLfvN0bHjW5qKhmGsGwHxXr+s2VpMvYt/pv
0aY+d3scuK/OS5y8HTr1E1YEnhT/ArayDM2ZeC9QtX1lmoa1eLIzpnbe1U7m1C5YtOhv
AZxg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=1e100.net; s=20210112;
h=x-gm-message-state:message-id:date:mime-version:user-agent:reply-to
:subject:content-language:to:references:from:organization
:in-reply-to:content-transfer-encoding;
bh=RfGEbHbZtxtBZ332mI6jzovv1S/OZ3ikBVdvOhI/FhU=;
b=eWEoBTstWqphFqKG9E0Xi4bPPIjimCCo1jtJH0mq/2SH4dnKOMbJklrCmHu7jxXTWm
lfV22bIkzyCNcSNsGUeTTMuCCPdMkVxkoFhTkne//kaX2kQW+OlI1eCtyyDk8nMZBWA8
VjPf1ZnFokR0V+NNMAVQ69NVVkf06ZCvA1WIo/wain6FGyKQRqLgesCvfLc2HPIBNqkI
xvSg6JZBqms3HXPRfs9qSUmrP3j+JlH2hvJ3utcd1PCSiH8jcMNeoNOf5rc02vTO7jLq
CUbTcqRg0Q56Vv9bsxokGuZIb/vVg/hUB83xABuc6r4gk4ECn9M4H26RSCKGQTPYTwWe
Lhcg==
X-Gm-Message-State: AOAM533tIvLK+kkDUAyc5rq8p0Wib14S/g4379HrmvSsavX65pwqLFlf
UusXVPdxWnO2aS1lHycVHIQPj5U9JQEZDw==
X-Google-Smtp-Source: ABdhPJyXqz/D9WpbqfCZeq4hG5cxf35g1fb3X4jtPGVAFtqxmF+XnSBa+xEJsXqSiP8C2p+PZDEvdw==
X-Received: by 2002:a62:6415:0:b0:4c6:fe2f:6a94 with SMTP id
y21-20020a626415000000b004c6fe2f6a94mr12231063pfb.25.1642982820303;
Sun, 23 Jan 2022 16:07:00 -0800 (PST)
Date: Mon, 24 Jan 2022 10:06:52 +1000
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.5.0
Reply-To: shift7solutions@gmail.com
Content-Language: en-US
To: info-ingres@lists.planetingres.org
References: <sskdso$7t6$1@gioia.aioe.org>
From: shift7so...@gmail.com (Paul White)
Organization: Shift Seven Solutions
In-Reply-To: <sskdso$7t6$1@gioia.aioe.org>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Subject: Re: [Info-ingres] Finding ..\ingres\lib for a script
X-BeenThere: info-ingres@lists.planetingres.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: <info-ingres.lists.planetingres.org>
List-Unsubscribe: <https://lists.planetingres.org/mailman/options/info-ingres>,
<mailto:info-ingres-request@lists.planetingres.org?subject=unsubscribe>
List-Archive: <https://lists.planetingres.org/pipermail/info-ingres/>
List-Post: <mailto:info-ingres@lists.planetingres.org>
List-Help: <mailto:info-ingres-request@lists.planetingres.org?subject=help>
List-Subscribe: <https://lists.planetingres.org/mailman/listinfo/info-ingres>,
<mailto:info-ingres-request@lists.planetingres.org?subject=subscribe>
Newsgroups: comp.databases.ingres
Message-ID: <mailman.125.1642982824.1681.info-ingres@lists.planetingres.org>
Lines: 140
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-ab1JMCiTH40brlBOAJlyY1Cw3E0Sc2vmz9J/4FmQeUi/D4+j6J7eMmZJ3PFfoaqbgfbFoXZLABJQCAp!Yv77/yXltKI6PRfh4YKVEtNGyr1MFTmrLznpwZ3jPIkH/I6sWp2AgVPexESOJ8BF1xpOt0SYyxVf!kwrg2N7ngMUSFJtgvLPUok0=
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 8773

by: Paul White - Mon, 24 Jan 2022 00:06 UTC

Hi Roy,

If the sysop has decided not install II_SYSTEM in in the System
environment (or there may be multiple installations) then you have an
number of options to search for installations:

If you have access to an Ingres Command window.

set | find "II"
set | find /i "lib"

Right click on an Ingres utility icon to see the wrapper which sets the
environment based on the location. In that shell you can query
environment and ingprenv:

eg
Actian Administrator Command Prompt
C:\IngresII\ingres\bin\ingadminwrap.exe "C:\Windows\system32\CMD.EXE" /K
"C:\IngresII\ingres\bin\setingenvs.bat"

Actian Visual DBA
C:\IngresII\ingres\bin\ingwrap.exe "C:\IngresII\ingres\bin\vdba.exe"

For DB servers I always use the 8 character name to simplify admin
scripting. eg C:\IngresII, D:\IngresII or similar. Default windows
directories are usually:

C:\ProgramData\Actian\
C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Actian>
C:\Program Files\Actian\
C:\Program Files (x86) \Actian\

If you have admin access to the server the reg command can be used directly:

reg query HKLM\Software\classes | find /i "\ingres"

HKEY_LOCAL_MACHINE\Software\classes\Ingres.IIA.II
HKEY_LOCAL_MACHINE\Software\classes\Ingres.VDBA.II
HKEY_LOCAL_MACHINE\Software\classes\IngresImportExport
HKEY_LOCAL_MACHINE\Software\classes\IngresImportExport.1
HKEY_LOCAL_MACHINE\Software\classes\Ingres_Database_II

reg query hklm\software\classes\ingres_database_ii /s
HKEY_LOCAL_MACHINE\software\classes\ingres_database_ii\shell
    II_SYSTEM    REG_SZ    C:\IngresII
    II_INSTALLATION    REG_SZ    II
    II_TEMPORARY    REG_SZ    C:\ProgramData\Actian\IngresII\temp

The output of commands can be captured to a variable if you are trying
to automate:

C:\>for /f "tokens=*" %%a in ( 'reg query
hklm\software\classes\ingres_database_ii /s ^| find "II_SYSTEM"') do set
MYLOC=%%a
C:\>set MYLOC=II_SYSTEM REG_SZ C:\IngresII
C:\>echo %MYLOC%
II_SYSTEM REG_SZ C:\IngresII

C:\>for /f "tokens=3" %%a in ( 'reg query
hklm\software\classes\ingres_database_ii /s ^| find "II_SYSTEM"') do set
MYLOC=%%a
C:\>set MYLOC=C:\IngresII
C:\>echo %MYLOC%
C:\IngresII

(ps use %a instead of %%a if running directly from command window)

You can use Powershell to retrieve registry items without admin access.
I'm not a fan of powershell. All my scripts are traditional windows BAT
files.

PS W:\> Get-ChildItem -Path HKLM:\software\classes\ingres* |
Select-Object Name
Name
----
HKEY_LOCAL_MACHINE\software\classes\Ingres.IIA.II
HKEY_LOCAL_MACHINE\software\classes\Ingres.VDBA.II
HKEY_LOCAL_MACHINE\software\classes\IngresImportExport
HKEY_LOCAL_MACHINE\software\classes\IngresImportExport.1
HKEY_LOCAL_MACHINE\software\classes\Ingres_Database_II

PS W:\> Get-Item -Path HKLM:\software\classes\ingres_database_II\shell
    Hive: HKEY_LOCAL_MACHINE\software\classes\ingres_database_II\
Name                           Property
----                           --------
shell                          II_SYSTEM       : C:\IngresII
                               II_INSTALLATION : II
                               II_TEMPORARY    :
C:\ProgramData\Actian\IngresII\temp

PS W:\> Get-ItemProperty -Path
HKLM:\software\classes\ingres_database_II\shell
II_SYSTEM       : C:\IngresII
II_INSTALLATION : II
II_TEMPORARY    : C:\ProgramData\Actian\IngresII\temp
PSPath          :
Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\software\classes\ingr
                  es_database_II\shell
PSParentPath    :
Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\software\classes\ingr
                  es_database_II
PSChildName     : shell
PSDrive         : HKLM
PSProvider      : Microsoft.PowerShell.Core\Registry

PS W:\> Get-ItemPropertyValue -Path
HKLM:\software\classes\ingres_database_II\shell -name II_SYSTEM
C:\IngresII

On 24/01/2022 6:30 am, Roy Hann wrote:
> In the *nix world I would look for $II_SYSTEM and navigate from there.
> But there is no II_SYSTEM in Windows. Is there anything that makes it
> look like I know what I'm doing other than searching %LIB% for an entry
> ending with "ingres\lib"?
>
> Roy
> _______________________________________________
> Info-ingres mailing list
> Info-ingres@lists.planetingres.org
> https://lists.planetingres.org/mailman/listinfo/info-ingres

--
Paul White 
Shift Seven Solutions 
m: 0414681799 
p: 0754482137 
e: paul.white@shift7solutions.com.au 
w: https://www.shift7solutions.com.au 
International: +61414681799

Re: [Info-ingres] Finding ..\ingres\lib for a script

<sslqof$1hgn$1@gioia.aioe.org>

copy mid

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

copy link Newsgroups: comp.databases.ingres

Path: i2pn2.org!i2pn.org!aioe.org!ow2HZ3WUoSa7bUAoHqrJ8A.user.46.165.242.75.POSTED!not-for-mail
From: specia...@processed.almost.meat (Roy Hann)
Newsgroups: comp.databases.ingres
Subject: Re:
[Info-ingres] Finding ..\ingres\lib for a scrip
t
Date: Mon, 24 Jan 2022 09:16:00 -0000 (UTC)
Organization: Aioe.org NNTP Server
Message-ID: <sslqof$1hgn$1@gioia.aioe.org>
References: <sskdso$7t6$1@gioia.aioe.org> <mailman.125.1642982824.1681.info-ingres@lists.planetingres.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Injection-Info: gioia.aioe.org; logging-data="50711"; posting-host="ow2HZ3WUoSa7bUAoHqrJ8A.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
X-Notice: Filtered by postfilter v. 0.9.2

by: Roy Hann - Mon, 24 Jan 2022 09:16 UTC

Thanks for that very comprehensive response Paul. That's a great public
service.

Not to take anything away from the rest of what you wrote, your first
sentence points out something I didn't know. As it happens almost all
my Windows machines running Ingres have multiple installations. So
that explains why I don't see II_SYSTEM.

Sure enough, I just hopped onto the one machine with only a single
installation and II_SYSTEM is set, ripe for use.

I am still puzzling over why it wouldn't be set on my other machines
when it is implied in settings in PATH, LIB, etc.

Since I would need to do an ingprenv to get the installation identifier
I think parsing %LIB% for the "ingres\lib" entry remains the most
concise solution. But bleh.

Thanks again for putting my mind at rest.

Roy

Paul White wrote:

> Hi Roy,
>
> If the sysop has decided not install II_SYSTEM in in the System
> environment (or there may be multiple installations) then you have an
> number of options to search for installations:
>
> If you have access to an Ingres Command window.
>
> set | find "II"
> set | find /i "lib"
>
>
> Right click on an Ingres utility icon to see the wrapper which sets the
> environment based on the location. In that shell you can query
> environment and ingprenv:
>
> eg
> Actian Administrator Command Prompt
> C:\IngresII\ingres\bin\ingadminwrap.exe "C:\Windows\system32\CMD.EXE" /K
> "C:\IngresII\ingres\bin\setingenvs.bat"
>
> Actian Visual DBA
> C:\IngresII\ingres\bin\ingwrap.exe "C:\IngresII\ingres\bin\vdba.exe"
>
>
> For DB servers I always use the 8 character name to simplify admin
> scripting. eg C:\IngresII, D:\IngresII or similar. Default windows
> directories are usually:
>
> C:\ProgramData\Actian\
> C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Actian>
> C:\Program Files\Actian\
> C:\Program Files (x86) \Actian\
>
>
> If you have admin access to the server the reg command can be used directly:
>
> reg query HKLM\Software\classes | find /i "\ingres"
>
> HKEY_LOCAL_MACHINE\Software\classes\Ingres.IIA.II
> HKEY_LOCAL_MACHINE\Software\classes\Ingres.VDBA.II
> HKEY_LOCAL_MACHINE\Software\classes\IngresImportExport
> HKEY_LOCAL_MACHINE\Software\classes\IngresImportExport.1
> HKEY_LOCAL_MACHINE\Software\classes\Ingres_Database_II
>
>
> reg query hklm\software\classes\ingres_database_ii /s
> HKEY_LOCAL_MACHINE\software\classes\ingres_database_ii\shell
>     II_SYSTEM    REG_SZ    C:\IngresII
>     II_INSTALLATION    REG_SZ    II
>     II_TEMPORARY    REG_SZ    C:\ProgramData\Actian\IngresII\temp
>
>
> The output of commands can be captured to a variable if you are trying
> to automate:
>
> C:\>for /f "tokens=*" %%a in ( 'reg query
> hklm\software\classes\ingres_database_ii /s ^| find "II_SYSTEM"') do set
> MYLOC=%%a
> C:\>set MYLOC=II_SYSTEM    REG_SZ C:\IngresII
> C:\>echo %MYLOC%
> II_SYSTEM    REG_SZ    C:\IngresII
>
> C:\>for /f "tokens=3" %%a in ( 'reg query
> hklm\software\classes\ingres_database_ii /s ^| find "II_SYSTEM"') do set
> MYLOC=%%a
> C:\>set MYLOC=C:\IngresII
> C:\>echo %MYLOC%
> C:\IngresII
>
> (ps use %a instead of %%a if running directly from command window)
>
>
> You can use Powershell to retrieve registry items without admin access.
> I'm not a fan of powershell. All my scripts are traditional windows BAT
> files.
>
> PS W:\> Get-ChildItem -Path HKLM:\software\classes\ingres* |
> Select-Object Name
> Name
> ----
> HKEY_LOCAL_MACHINE\software\classes\Ingres.IIA.II
> HKEY_LOCAL_MACHINE\software\classes\Ingres.VDBA.II
> HKEY_LOCAL_MACHINE\software\classes\IngresImportExport
> HKEY_LOCAL_MACHINE\software\classes\IngresImportExport.1
> HKEY_LOCAL_MACHINE\software\classes\Ingres_Database_II
>
>
> PS W:\> Get-Item -Path HKLM:\software\classes\ingres_database_II\shell
>     Hive: HKEY_LOCAL_MACHINE\software\classes\ingres_database_II\
> Name                           Property
> ----                           --------
> shell                          II_SYSTEM       : C:\IngresII
>                                II_INSTALLATION : II
>                                II_TEMPORARY    :
> C:\ProgramData\Actian\IngresII\temp
>
>
> PS W:\> Get-ItemProperty -Path
> HKLM:\software\classes\ingres_database_II\shell
> II_SYSTEM       : C:\IngresII
> II_INSTALLATION : II
> II_TEMPORARY    : C:\ProgramData\Actian\IngresII\temp
> PSPath          :
> Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\software\classes\ingr
>                   es_database_II\shell
> PSParentPath    :
> Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\software\classes\ingr
>                   es_database_II
> PSChildName     : shell
> PSDrive         : HKLM
> PSProvider      : Microsoft.PowerShell.Core\Registry
>
>
> PS W:\> Get-ItemPropertyValue -Path
> HKLM:\software\classes\ingres_database_II\shell -name II_SYSTEM
> C:\IngresII
>
>
> On 24/01/2022 6:30 am, Roy Hann wrote:
>> In the *nix world I would look for $II_SYSTEM and navigate from there.
>> But there is no II_SYSTEM in Windows. Is there anything that makes it
>> look like I know what I'm doing other than searching %LIB% for an entry
>> ending with "ingres\lib"?
>>
>> Roy
>> _______________________________________________
>> Info-ingres mailing list
>> Info-ingres@lists.planetingres.org
>> https://lists.planetingres.org/mailman/listinfo/info-ingres
>

We'll pivot at warp 2 and bring all tubes to bear, Mr. Sulu!

devel / comp.databases.ingres / Finding ..\ingres\lib for a script

devel / comp.databases.ingres / Finding ..\ingres\lib for a script

Subject	Author
Finding ..\ingres\lib for a script	Roy Hann
Re: [Info-ingres] Finding ..\ingres\lib for a script	Paul White
Re:	Roy Hann