[Info-ingres] how can other user execute ingstart and ingstop

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sankar Narayanan - 29 Nov 2006 08:17 GMT

Hai All,

I am newly to Ingres and i had installed a ingres in normal user(other
than ingres,root).but i execute the ingstart command it will display the
error like below

Ingres 2006/ingstart
Error while opening ingstart.log

Checking host "localhost.localdomain" for system resources required to run
Ingres 2006...

Your system has sufficient resources to run Ingres 2006.

Starting your Ingres 2006 installation...
Error while opening ingstart.log

Starting the Name Server...
Error while opening ingstart.log

Allocating shared memory for Logging and Locking Systems...
Error while opening ingstart.log
Could not create the system segment, does your kernel have enough
shared memory or has this program already been run?

Unable to allocate shared memory.

Error while opening ingstart.log

Thanks
Sankar

Reply to this Message

Wooton, Geoffrey (NESL-IT) - 29 Nov 2006 11:15 GMT

The venerable Paul Mason wrote our routines to allow some 3rd party to run
ingres commands.
Only ingstop and ingstart, but I guess you could open this up if you so
desired...

It was a c routine which changed the uid to root to allow a su to ingres
without a prompt for the password. The commands allowed were hardcoded in
the header file... and the routine did not exit into either root nor ingres
and proved very useful and safe to use.
The header file and compilations were controlled by the ingres user so was
controlled.

Clever Lad this Paul Mason fella...

Geoff

-----Original Message-----
From: info-ingres-admin@cariboulake.com
[mailto:info-ingres-admin@cariboulake.com]On Behalf Of Duncan Hill
Sent: Wednesday, November 29, 2006 10:55 AM
To: info-ingres@cariboulake.com
Subject: Re: [Info-ingres] how can other user execute ingstart and
ingstop

> Hi Sankar,
>
[quoted text clipped - 10 lines]
> For example, I just tried and got...
> Starting DBMS Server (default)...Error while opening ingstart.log

On a Linux box, and probably quite a few other *nix ones, you could always
use
sudo to grant rights non-ingres users to execute ingstart etc as ingres.
They would only have to know their password, and sudo limits the commands
available, so no (in theory) other actions as the ingres user would be
possible.
_______________________________________________
Info-ingres mailing list
Info-ingres@cariboulake.com
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres

**********************************************************************

The information contained in this e-mail is confidential and intended only
for the use of the addressee. If the reader of this message is not the
addressee, you are hereby notified that you have received this e-mail in
error and you must not copy, disseminate, distribute, use or take any action
as a result of the information contained in it.

If you have any queries, please contact the IT Service Desk on 1870
(01384-275454).

postmaster@npower.com

**********************************************************************

Reply to this Message