Hello all,

It seem I have successfully upgraded to 9.1.1 (int.lnx/103)NPTL
(isql & ingmenu run OK).

But on trying to apply patch 13236 the following error appears
(I'm following the patch's installation instructions, on SLES 10)

acer patches/patch13236>
acer patches/patch13236> whoami
ingres
acer patches/patch13236> ./utility/iiinstaller
Initializing ...
chmod: changing permissions of `/opt/Ingres/IngresII/ingres/install/control': Operation not permitted
chmod: changing permissions of `/opt/Ingres/IngresII/ingres/install/control/.save': Operation not permitted
chmod: changing permissions of `/opt/Ingres/IngresII/ingres/install/control/.protocols': Operation not permitted
Unable to set mode on directory.
Dir: /opt/Ingres/IngresII/ingres/install/control[/.save|/.protocols]
acer patches/patch13236>

Do I perhaps need to inject another step somewhere??


Thanks for any help,

Bob Borbiro

Hi Bob,



Your II_SYSTEM looks like it sits on /opt which looks like an old
OpenIngres licensing path.



/opt is normally root owned and there is a very fine chance that ingres
doesn't own the directory tree underneath that. Ergo your problems are
all down to UNIX permissions.

Try ls -ldg `/opt/Ingres/IngresII/ingres/install/control



I'd suggest a reinstall of 9.1.1 and choose a better II_SYSTEM. The
alternative is to go see root and get some directory ownership and
pemissions changed.



Martin Bowes

From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Ballpoint
Sent: 06 March 2009 05:36
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: [Info-Ingres] patch 13236 installer problem



Hello all,



It seem I have successfully upgraded to 9.1.1 (int.lnx/103)NPTL

(isql & ingmenu run OK).



But on trying to apply patch 13236 the following error appears
(I'm following the patch's installation instructions, on SLES 10)



acer patches/patch13236>
acer patches/patch13236> whoami
ingres
acer patches/patch13236> ./utility/iiinstaller
Initializing ...
chmod: changing permissions of
`/opt/Ingres/IngresII/ingres/install/control': Operation not permitted
chmod: changing permissions of
`/opt/Ingres/IngresII/ingres/install/control/.save': Operation not
permitted
chmod: changing permissions of
`/opt/Ingres/IngresII/ingres/install/control/.protocols': Operation not
permitted
Unable to set mode on directory.
Dir: /opt/Ingres/IngresII/ingres/install/control[/.save|/.protocols]
acer patches/patch13236>

Do I perhaps need to inject another step somewhere??





Thanks for any help,



Bob Borbiro

On Mar 6, 10:29*am, "Martin Bowes" <martin.bo... (AT) ctsu (DOT) ox.ac.uk> wrote:
Martin,

/opt/Ingres/IngresII is not an "old OpenIngres" licensing path, but is
the default path when you do an "Express" install (using
ingres_express_install.sh),
At least it has been so with 9.1.0.
You run ingres_express_install.sh as root, but unfortunately it
doesn't set all the permissions correctly to the installation owner
(user "ingres"),
/opt/Ingres and /opt/Ingres/IngresII are still owned by root
afterwards.

Therefore I also had problems when installing openROAD into such an
installation, so I manually had to (still as "root"):
# chown ingres /opt/Ingres
# chown ingres /opt/Ingres/IngresII
# chgrp -R users /opt/Ingres

"users" is the default group of my "ingres" user.

Bodo.

Oh that's interesting. Did you set and export II_SYSTEM before the installation started?

You'll need to install with a response file in place.

setenv II_SYSTEM /your/desired/path
setenv II_RESPONSE_FILE /full/path/to/file

Within the response file set some or all of the following, I've set the paths for my own installation you can make up yours as required.
II_CONFIG=/dbsystem/II/ingres/files
II_DATABASE=/dbdata1/II
II_CHECKPOINT=/dbbackup/II
II_JOURNAL=/dbbackup/II
II_DUMP=/dbbackup/II
II_WORK=/dbbackup/II
II_LOG_FILE=/dbsystem/II
II_DUAL_LOG=/dbdual/II
LOG_KBYTES=1000000
II_NUM_OF_PROCESSORS=2
II_TIMEZONE_NAME=UNITED-KINGDOM
II_CHARSET=ISO88591
ING_ABFDIR=/dbsystem/II
ING_EDIT=/bin/vi

Marty
-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Bodo
Sent: 06 March 2009 12:15
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: Re: [Info-Ingres] patch 13236 installer problem

On Mar 6, 10:29*am, "Martin Bowes" <martin.bo... (AT) ctsu (DOT) ox.ac.uk> wrote:
Martin,

/opt/Ingres/IngresII is not an "old OpenIngres" licensing path, but is
the default path when you do an "Express" install (using
ingres_express_install.sh),
At least it has been so with 9.1.0.
You run ingres_express_install.sh as root, but unfortunately it
doesn't set all the permissions correctly to the installation owner
(user "ingres"),
/opt/Ingres and /opt/Ingres/IngresII are still owned by root
afterwards.

Therefore I also had problems when installing openROAD into such an
installation, so I manually had to (still as "root"):
# chown ingres /opt/Ingres
# chown ingres /opt/Ingres/IngresII
# chgrp -R users /opt/Ingres

"users" is the default group of my "ingres" user.

Bodo.
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres

On Mar 6, 1:52*pm, "Martin Bowes" <martin.bo... (AT) ctsu (DOT) ox.ac.uk> wrote:
Setting II_SYSTEM or II_RESPOSE_FILE for the express RPM install is
not required.
But you can of course use: ingres_express_install [instance_ID]
[instance_location]
(See the Installation Guide for detailed description).

The default II_SYSTEM=/opt/Ingres/IngresII (instance_location) and
default II_INSTALLATION=II (instance_ID).

BTW: Installing under /opt is also a common behavior for many RPM
packages,
so setting file permissions correctly should be part of the
ingres_express_install script.

Of course you can set II_RESPOSE_FILE to customize your installation.
You probably should do this
otherwise the locations for databases, transaction logfiles etc.
are all pointing to the same file system
(default locations under II_SYSTEM).

Bodo.

Changed the ownership of the directories Bodo mentioned, and the control directory,
and also of the files .save and .protocols shown in the error message.

That solved the problem.

Thank you.

Bob Borbiro.

"Ballpoint" <aborbiro (AT) internode (DOT) on.net> wrote

Hello all,

It seem I have successfully upgraded to 9.1.1 (int.lnx/103)NPTL
(isql & ingmenu run OK).

But on trying to apply patch 13236 the following error appears
(I'm following the patch's installation instructions, on SLES 10)

acer patches/patch13236>
acer patches/patch13236> whoami
ingres
acer patches/patch13236> ./utility/iiinstaller
Initializing ...
chmod: changing permissions of `/opt/Ingres/IngresII/ingres/install/control': Operation not permitted
chmod: changing permissions of `/opt/Ingres/IngresII/ingres/install/control/.save': Operation not permitted
chmod: changing permissions of `/opt/Ingres/IngresII/ingres/install/control/.protocols': Operation not permitted
Unable to set mode on directory.
Dir: /opt/Ingres/IngresII/ingres/install/control[/.save|/.protocols]
acer patches/patch13236>

Do I perhaps need to inject another step somewhere??


Thanks for any help,

Bob Borbiro