RE: [Openroad-users] Cloning Ingres/Openroad Installations
Gerhard Hofmann
Stephen wrote:
>
> We are using a product called Symantic Ghost to try and clone our Ingres
> Net/Openroad installation/applications. There is a facility
> within Symantic
> Ghost called AIBuilder, which basically takes a snapshot of a pc's
> configuration prior to installation of the Ingres/openroad stuff.
> Then you install all the components that make the Openroad
> application run,
> like Openroad runtime, Ingres Net, ODBC and image files. This done, you
> make sure the application runs ok. Then another snapshot is taken
> of the pc's
> configuration. The two snapshots are then compared and the changes are
> logged and an Installation file is created. This file is copied
> to the next pc for
> cloning. The installation file is run on the new pc and low and
> behold a new
> Ingres installation, a mirror of the original.
>
> Problem
> The cloned pc's Ingres installation has taken the Computer name from the
> source pc. Files in the IngresII\ingres\files\name directory have
> this Computer
> name suffix. The config.dat file has entries where the Computer
> name is used
> and the II_GCNII_LCL_VNODE environment variable set in the symbol table
> also uses the Computer name. So Ingres doesn't start and the application
> doesn't run.
>
> Question
> Is this computer name necessary in the installation and running of Ingres
> net/openroad, or can it be suppressed?
>
> I managed to get the openroad application to work by changing the
> computer
> name manually in the places mentioned above. However Ingres does
> not start
> as a service. I had to run Ingstart from a dos prompt. The Ingres
> utilities,
> Visual DBA and Configuration manager wouldn't work. They couldn't
> find the
> files OIEMBDNT.DLL(vdba) and OICLFNT.DLL(configuration manager).
> These files are present in the installation and are in
> C:\IngresII\ingres\bin.
>
> What do you think might be causing this?
> The system Environment variables look ok, as does the path statement.
> Is there something in the registry that needs changed?
>
> I would like this ghosting process to work as it saves
> considerable time on
> installations.
>
You have to fix several things to get cloned OR clients running because the
PC name is stored in multiple files:
1. fix the config.dat:
running "iigenres %COMPUTERNAME%" should do this
2. recreate all vnode entries (because old ones won't work after renaming
PC):
you can use netutil's non-interactive mode to run this from a batch file
3. fix Ingres variables that contain the PC name:
ingsetenv II_GCNII_LCL_VNODE %COMPUTERNAME%
HTH
Gerhard
_______________________________________________
Openroad-users mailing list
Openroa...@peerlessit.com
http://www.peerlessit.com/mailman/listinfo/openroad-users
Pete Rabjohns
You can certainly replace all instances of the computer name in
config.dat with a '*' symbol. Do this before cloning.
I have not found a way of successfully copying VNODE settings, although
you should probably remove all files from the 'name' folder that are
node specific and re-create as required on each target machine.
I think I tried renaming the files to the correct node name, but that
did not seem to work.
Let me know how you get on, because I'm also interested in creating a
full installer for our product without the pain of having to go through
several installers and patch updates.
Question to any CA listeners - are there any plans to support or assist
people with creating their own 'one-click' installation packages for
OpenROAD/Ingres/Gateway etc?
Regards,
Pete
Gary Hansford
Stephen,
We do this all the time on CITRIX Server FARM.
They key is the environmental logical II_HOSTNAME which allows you to
override the hostname that ingres will sort-of-use.
Define it at system level before you perform an Ingres / OpenRoad
installation to something like MYPC. Once you've built the installation also
do an INGSETENV II_HOSTNAME MYPC and check/review the config.dat and
symbol.tbl files (via ingprenv).
Sometimes you'll find Ingres has sneaked it back in under something like
lcl_vnode etc.
Once you've done this you can copy the installation onto any PC and change
the PC's name - ingres wont care... Also very useful in that you can copy
the same symbol.tbl and config.dat files around as they'll all have the same
details in them...!!
Hope this makes sense/helps...
Gary
Thanks in advance
Stephen B McCulloch
Software Developer
----------------------------
Corporate & Commercial Services
ICT Infrastructure (Software Development)
Falkirk Council,
Municipal Buildings,
West Bridge Street,
Falkirk, FK1 5RS
Scotland, UK
------------------------------------------
Telephone : (01324) 501523
Fax : (01324) 501516
E-mail : stephen....@falkirk.gov.uk
Gerhard Hofmann
Pete wrote:
>
> How do you get over the user id & password settings - or do you use
> installation passwords?
>
You mean the used id and password settings in the vnode entries?
Just create a file command.txt that looks like this:
create global login myserver ingres Ingres
create global connection myserver myserver wintcp II
Run
netutil -file command.txt
This will create a vnode "myserver" that points to server "myserver" with
user "ingres" and password "Ingres"
Regards
Gerhard
Bloomfield, Martin (PSD)
Pete,
We currently use IIPROMPT1 in the vnode definition, but are in the process
of moving to installation passwords. The username / password information is
stored in the iilogin file. I guess that if you have different login ids
for each machine then this approach is not feasible.
Martin Bloomfield.
-----Original Message-----
From: Pete Rabjohns [mailto:PRab...@uk.amc.com]
Sent: 06 February 2004 12:11
To: Bloomfield, Martin (PSD); Gerhard Hofmann;
stephen....@falkirk.gov.uk; OpenRoad List
Subject: RE: [Openroad-users] Cloning Ingres/Openroad Installations
How do you get over the user id & password settings - or do you use
installation passwords?
-----Original Message-----
From: Bloomfield, Martin (PSD)
[mailto:martin.b...@psd.defra.gsi.gov.uk]
Sent: 06 February 2004 11:15
To: Pete Rabjohns; 'Gerhard Hofmann'; 'stephen....@falkirk.gov.uk';
'OpenRoad List'
Subject: RE: [Openroad-users] Cloning Ingres/Openroad Installations
I have found that you can move the vnode settings by renaming the files in
the name folder with the new PC name. This is done via a batch file, which
uses the %COMPUTERNAME% environment variable to get the pc name. The command
look like: ren iinode_ghost iinode_%COMPUTERNAME% (where iinode_ghost is
the master version in the ghost image.)
Note that ingres must not be running when this is done. Obviously this is
only applicable to windows PCs. We have also found that if you are using
windows XP, then all users need permissions to various files/directories in
the ingres tree. We ended up giving all users full control to the whole
installation tree.
The files needed to transfer the vnode information appear to be iinode and
iilogin. We are planning using this approach to distribute new vnode
definitions when we replace our database server.
Martin Bloomfield.
-----Original Message-----
From: Pete Rabjohns [mailto:PRab...@uk.amc.com]
Sent: 06 February 2004 10:58
To: Gerhard Hofmann; stephen....@falkirk.gov.uk; OpenRoad List
Subject: RE: [Openroad-users] Cloning Ingres/Openroad Installations
You can certainly replace all instances of the computer name in config.dat
with a '*' symbol. Do this before cloning.
I have not found a way of successfully copying VNODE settings, although you
should probably remove all files from the 'name' folder that are node
specific and re-create as required on each target machine.
I think I tried renaming the files to the correct node name, but that did
not seem to work.
Let me know how you get on, because I'm also interested in creating a full
installer for our product without the pain of having to go through several
installers and patch updates.
Question to any CA listeners - are there any plans to support or assist
people with creating their own 'one-click' installation packages for
OpenROAD/Ingres/Gateway etc?
Regards,
Pete
-----Original Message-----
From: Gerhard Hofmann [mailto:gerhard...@planat.de]
Sent: 06 February 2004 10:33
To: stephen....@falkirk.gov.uk; OpenRoad List
Subject: RE: [Openroad-users] Cloning Ingres/Openroad Installations
You have to fix several things to get cloned OR clients running because
the PC name is stored in multiple files:
1. fix the config.dat:
running "iigenres %COMPUTERNAME%" should do this
2. recreate all vnode entries (because old ones won't work after
renaming
PC):
you can use netutil's non-interactive mode to run this from a batch
file 3. fix Ingres variables that contain the PC name:
ingsetenv II_GCNII_LCL_VNODE %COMPUTERNAME%
HTH
Gerhard
_______________________________________________
Openroad-users mailing list
Openroa...@peerlessit.com
http://www.peerlessit.com/mailman/listinfo/openroad-users
_______________________________________________
Openroad-users mailing list
Openroa...@peerlessit.com
http://www.peerlessit.com/mailman/listinfo/openroad-users
Department for Environment, Food and Rural Affairs (Defra)
This email and any attachments is intended for the named recipient only.
Its unauthorised
use, disclosure, storage or copying is not permitted. If you have
received it in error, please
destroy all copies and inform the sender. Whilst this email and
associated attachments will
have been checked for known viruses whilst within Defra systems we can
accept no
responsibility once it has left our systems. Communications on Defra's
computer systems
may be monitored and/or recorded to secure the effective operation of
the system and for
other lawful purposes.
stephen....@falkirk.gov.uk
Thanks in advance
Stephen B McCulloch
Software Developer
----------------------------
Corporate & Commercial Services
ICT Infrastructure (Software Development)
Falkirk Council,
Municipal Buildings,
West Bridge Street,
Falkirk, FK1 5RS
Scotland, UK
------------------------------------------
Telephone : (01324) 501523
Fax : (01324) 501516
E-mail : stephen....@falkirk.gov.uk
_______________________________________________
Pete Rabjohns
You have to fix several things to get cloned OR clients running because
the PC name is stored in multiple files:
1. fix the config.dat:
running "iigenres %COMPUTERNAME%" should do this
2. recreate all vnode entries (because old ones won't work after
renaming
PC):
you can use netutil's non-interactive mode to run this from a batch
file 3. fix Ingres variables that contain the PC name:
ingsetenv II_GCNII_LCL_VNODE %COMPUTERNAME%
HTH
Gerhard
_______________________________________________
Openroad-users mailing list
Openroa...@peerlessit.com
http://www.peerlessit.com/mailman/listinfo/openroad-users
_______________________________________________
Openroad-users mailing list
Openroa...@peerlessit.com
http://www.peerlessit.com/mailman/listinfo/openroad-users
Department for Environment, Food and Rural Affairs (Defra)
This email and any attachments is intended for the named recipient only.
Its unauthorised
use, disclosure, storage or copying is not permitted. If you have
received it in error, please
destroy all copies and inform the sender. Whilst this email and
associated attachments will
have been checked for known viruses whilst within Defra systems we can
accept no
responsibility once it has left our systems. Communications on Defra's
computer systems
may be monitored and/or recorded to secure the effective operation of
the system and for
other lawful purposes.
Bloomfield, Martin (PSD)
Paul White
Nodeless connections avoid the requirement of setting up Vnodes. They work
ok for Ingres Net 2.6 and 2.5 and OpenROAD 4.1 and also through EA 2.1 to
MSSQL.
OpenROAD Eclient would help minimize the installation tree, security issues
etc.
Paul
-----Original Message-----
From: openroad-us...@peerlessit.com
[mailto:openroad-us...@peerlessit.com]On Behalf Of Bloomfield,
Martin (PSD)
Sent: Friday, 6 February 2004 11:19 PM
To: 'Pete Rabjohns'; 'Gerhard Hofmann';
'stephen....@falkirk.gov.uk'; 'OpenRoad List'
Subject: RE: [Openroad-users] Cloning Ingres/Openroad Installations
Pete,
We currently use IIPROMPT1 in the vnode definition, but are in the process
of moving to installation passwords. The username / password information is
stored in the iilogin file. I guess that if you have different login ids
for each machine then this approach is not feasible.
Martin Bloomfield.
-----Original Message-----
From: Pete Rabjohns [mailto:PRab...@uk.amc.com]
Sent: 06 February 2004 12:11
To: Bloomfield, Martin (PSD); Gerhard Hofmann;
stephen....@falkirk.gov.uk; OpenRoad List
Subject: RE: [Openroad-users] Cloning Ingres/Openroad Installations
How do you get over the user id & password settings - or do you use
installation passwords?
-----Original Message-----
From: Bloomfield, Martin (PSD)
[mailto:martin.b...@psd.defra.gsi.gov.uk]
Sent: 06 February 2004 11:15
Paul White
Here are some examples:
w4glrun mine.img -d...@1.2.3.4,wintcp,II[paul,paulpass]::mydb/mssql
sql @mymachine,wintcp,II[paul,paulpass]::mydb/mssql -rfred/fredpass
Within OpenROAD you can ask for the user/password and supply the network
connect string in configuration file, environment or APPSFLAG parameter.
DECLARE
...
Ldbso = dbSessionObject;
...
lv_ConnectStr = '@' + lv_connect + '[' + lv_user + ','
+ lv_password + ']::' + lv_dbase;
Li_RtnStatus = Ldbso.Connect(database = Lv_ConnectStr);
If Li_RtnStatus != C_RTNSUCCESS THEN
curframe.trace('Could not connect. Status=' +
varchar(li_rtnstatus));
RESUME;
EndIf;
CurFrame.DbSession = Ldbso;
curframe.Trace('Connected');
The -r parameter seems to only work as a parameter. I haven't been able to
get it to work with the connect() method. I'm working with CA Support on
this right now.
I haven't been able to get nodeless connections working with Ingres odbc.
Has anyone else done this?
Remember you must have Ingres25 or above on the client.
Paul