IDS Forum

RE: 668: System command cannot be executed

Posted By: Kerhalkar, Rohit
Date: Friday, 13 August 2004, at 11:41 a.m.

In Response To: 668: System command cannot be executed (Kerhalkar, Rohit)

Thanx. This really helped. We took out a copy of our backuped files and
compared the informix file permissions with the existing ones.

Some of the files in $INFORMIXDIR/bin had "informix" as owner whereas it
should have been "root". After changing these file permissions/ownership
and restarting informix, the problem disappears.

Regards,
Rohit



-----Original Message-----
From: kagel [mailto:1190260@skytel.com]
Sent: Friday, August 13, 2004 7:22 PM
To: Kerhalkar, Rohit
Subject: Re: 668: System command cannot be executed [3355]


Looks like someone mucked with the permissions of the oninit task.
There's a file in $INFORMIXDIR/etc with the correct perms for all
installed files. Otherwise reinstall.

Art S. Kagel


Original Message:
rohit.kerhalkar@hp.com|668: System command cannot be executed [3355]|Hi
All,
We are using HP-UX 11i in Trusted Computer Base setup with Informix IDS
=
9.4(FC4).
=20
All the while, our application stored procedures were behaving properly
=
and getting executed in an orderly manner. We did some changes to file =
permissions and restarted informix and after that we started getting the
=
following error:
=20
668: system command cannot be executed.
1: Not owner
=20
We get this error, when any user other than informix or root executes a
=
stored procedure that uses the "system" command. Also, now the statement
=
"set DEBUG" also throws error. We have checked thoroughly and there is =
no problem with permission where debug files should be created.
=20
These errors do not show up when we execute the same procedure using =
informix or root user id. It only shows when we execute the stored =
procedure using any other users.
=20
Following is one of the sample stored proc script:
************************************************************************
*=
*************************
drop procedure th_test;
=20
create procedure th_test(theNo smallint) returning smallint
=20
=20
=20
--let theCMD =3D 'echo "Good for nothing" > thTest.log';
-- Following statement will throw error
system 'echo "Good for nothing" > thTest.log';
=20
return 0;
=20
end procedure
************************************************************************
*=
*************************
=20
Any help would be appreciated.

Regards,=20
Rohit

=20

=20


------------------------------------------------------------------------
--------
WARNING: THIS IS AN INTERNET MESSAGE AND IS SUBJECT TO INHERENT
UNRELIABILITY OF INTERNET TRAFFIC. THE BLOOMBERG E-MAIL SYSTEM
PROVIDES FAST, SECURE DELIVERY TO RECIPIENTS ON OTHER BLOOMBERG
TERMINALS.

Messages In This Thread

• 668: System command cannot be executed
  Kerhalkar, Rohit -- Friday, 13 August 2004, at 2:40 a.m.
  • RE: 668: System command cannot be executed
    Kerhalkar, Rohit -- Friday, 13 August 2004, at 11:41 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.