ISM - run backups as a user other than root?

#11

On 28/07/2010 16:47, malc_p wrote:

Quote:

Bugger me I think it works; just ran an onbar backup of a couple of
dbspaces as user informix and got no errors.

I added the following entries to the ‘/opt/sudo/etc/sudoers/sudoers’file:

User_Alias IMIX=informix,dba

(at the end of the existing user aliases)

And:

IMIX ALL=(ALL) NOPASSWD:/opt/informix/bin/onbar

IMIX ALL=(ALL) NOPASSWD:/opt/informix/bin/savegrp

(In the “user privilege specification’ section)

So it looks like the call to savegrp is covered.
Thanks for your help, Clive, appreciated!

Ignoring the comedians sideshow - you're welcome

And you PROBABLY don't need the sudoers entry for savegrp as it's being
run by onbar that is 'already' root

--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.

#12

On 28/07/2010 19:22, Clive Eisen wrote:

Quote:

Ignoring the comedians sideshow - you're welcome

And you PROBABLY don't need the sudoers entry for savegrp as it's
being run by onbar that is 'already' root

....which also turns out correct, ta.

Obo - it wasn't a direct request to you personally, I know your form.

#13

On 27 July, 10:23, Malc <i... (AT) perrior (DOT) net> wrote:

Quote:

One more thing ((c) 2010).

It is a TOTAL pain in that with ISM you have to be root to run the
backup commands.
The root user round here is under tighter security than a very nervous
camel's backside in a very powerful sandstorm. They are really NOT
happy about adding anything to root cron or 'at' or into their
imprenetrable schedule, and database backups don't register much if at
all on their 'things we want/need/have to do' radar.
Is there any way at all of allowing the informix user to run the
backup commands without ISM triggering the "07/27/10 10:15:41 savegrp:
You are not authorized to run this command" error? It basically means
that no bootstrap file can be created if user informix runs the
backups (whether database ot logical log)

Ta

informix should be able to run backups fine including savegrp.

Run

ism_show -admins

and check that informxi@hostname is configure as an admin for the ISM
server other use

ism_add -admins informix@hostname

#14

On Jul 29, 7:56*pm, "da... (AT) smooth1 (DOT) co.uk" <da... (AT) smooth1 (DOT) co.uk> wrote:

Quote:

informix should be able to run backups fine including savegrp.

Run

ism_show -admins

and check that informxi@hostname is configure as an admin for the ISM
server other use

ism_add -admins informix@hostname

Yup informix is in the admins list, first thing we checked, still no
dice!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

ISM - run backups as a user other than root?

comp.databases.informix comp.databases.informix

Re: ISM - run backups as a user other than root? - 07-28-2010 , 01:22 PM

Re: ISM - run backups as a user other than root? - 07-29-2010 , 09:50 AM

Re: ISM - run backups as a user other than root? - 07-29-2010 , 01:56 PM

Re: ISM - run backups as a user other than root? - 07-30-2010 , 12:18 PM