RE: SP Question: System Command
informix user runs all system commands, and on the database server, and with no environment. Does informix have execute permission to the script? and does the script set the required environment? MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Lane O'Connor Sent: Tuesday, February 13, 2001 3:27 PM To: informix-list@iiug.org Subject: Re: SP Question: System Command Thank you for a quick reply. When the command fails, the login user is "root" (other user logins have been tried with the same results). Root has dbadmin authority. The files and directories are in place. Might there be any other situations that would create these errors? Lane O. Wolfgang Zager wrote: > Lane O'Connor wrote: > > > > What can be my problem if a system command cannot be executed from > > within an SP on some servers, but it can on others? > > > > SE7x, SCO5 > > > > One server creates a 668 and 1 error, another creates a 668 and 2 error, > > a third works fine... with what is designed to be the same config on > > each server (same user executing SP, same db, same paths, etc.). > > > > The errors: 668 is "system command cannot be executed", 1 is "not > > owner", 2 is "no file or directory"). > > > > Any clues offered would be appreciated, thanks. > > -- > > Error 1 looks like if the user executing the sp is not allowed to > execute > the system command. Maybe the owner of the file is someone else and > execute > permissions on that file are not granted to group and/or others. > > Error 2 should be the result of a missing file. > > **************************************************************************** *** > * Any opinions written in this e-mail are my own. They may not > correspond to * > * those of my > company. * > **************************************************************************** *** > * Wolfgang Zager Berghauser Str. > 104 * > * BAB Data-Systems GmbH D-42349 > Wuppertal * > * Abt. Programmierung Tel. : +49 202 > 479870 * > * Fax : +49 202 > 470035 * > * E-Mail: > zager@gmx.de * > **************************************************************************** ***
Well that was clue enough. There /usr/informix/bin/ files that were owned by informix whereas they needed to be owned by root. Changing ownership of those files fixed the problem. Thanks Murray. Murray Wood wrote: > informix user runs all system commands, and on the database server, and with > no environment. > Does informix have execute permission to the script? and does the script > set the required environment? > > MW > > -----Original Message----- > From: owner-informix-list@iiug.iiug.org > [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Lane O'Connor > Sent: Tuesday, February 13, 2001 3:27 PM > To: informix-list@iiug.org > Subject: Re: SP Question: System Command > > Thank you for a quick reply. > > When the command fails, the login user is "root" (other user logins have > been tried > with the same results). Root has dbadmin authority. The files and > directories are > in place. > > Might there be any other situations that would create these errors? > > Lane O. > > Wolfgang Zager wrote: > > > Lane O'Connor wrote: > > > > > > What can be my problem if a system command cannot be executed from > > > within an SP on some servers, but it can on others? > > > > > > SE7x, SCO5 > > > > > > One server creates a 668 and 1 error, another creates a 668 and 2 error, > > > a third works fine... with what is designed to be the same config on > > > each server (same user executing SP, same db, same paths, etc.). > > > > > > The errors: 668 is "system command cannot be executed", 1 is "not > > > owner", 2 is "no file or directory"). > > > > > > Any clues offered would be appreciated, thanks. > > > > -- > > > > Error 1 looks like if the user executing the sp is not allowed to > > execute > > the system command. Maybe the owner of the file is someone else and > > execute > > permissions on that file are not granted to group and/or others. > > > > Error 2 should be the result of a missing file. > > > > > **************************************************************************** > *** > > * Any opinions written in this e-mail are my own. They may not > > correspond to * > > * those of my > > company. * > > > **************************************************************************** > *** > > * Wolfgang Zager Berghauser Str. > > 104 * > > * BAB Data-Systems GmbH D-42349 > > Wuppertal * > > * Abt. Programmierung Tel. : +49 202 > > 479870 * > > * Fax : +49 202 > > 470035 * > > * E-Mail: > > zager@gmx.de * > > > **************************************************************************** > ***