Re: Autostarting MYSQL

hi Mike,

The first parameter to QP2SHELL is the name of the executable program or shell that is to process your request. You've provided nothing but a directory name for that parameter. That's not going to work!

The error message is telling you that you don't have permission to execute a directory. (In Unix whether something is recognized as an executable program or not is based on the permissions/authorities of the object since they don't have object types like we do in OS/400. Thus it's a "permission" error... but in OS/400-terms, you are trying to CALL a *DIR object, instead of calling a *PGM object...)

I'll let you digest that... and meanwhile, I'm going to look up how I autostart my MYSQL... :)



Smith, Mike wrote:

I am trying to autostart MYSQL. I have the newer version of MYSQL not the one that originally came with
the Zend Install.
When I start MYSQL via QP2term, I follow the following steps
CALL QP2TERM

cd /QOpenSys/usr/local/mysql/mysql

bin/mysqld_safe &

I can hit my Joomla website after running this.
I have searched for example of autostarting MYSQL but so far I can't get
it to work.
Here is my latest CL. DCL VAR(&CMD) TYPE(*CHAR) LEN(80) DCL VAR(&PARM1) TYPE(*CHAR) LEN(20) DCL VAR(&NULL) TYPE(*CHAR) LEN(1) VALUE(X'00') CHGVAR VAR(&CMD) + VALUE('/QOpenSys/usr/local/mysql/mysql/') CHGVAR VAR(&PARM1) VALUE('bin/mysqlsafe &') /*CHGVAR VAR(&PARM1) VALUE('bin/mysqlsafe --user=mysql & *TCAT *NULL'*/

CHGVAR VAR(&CMD) VALUE(&CMD *TCAT &NULL) CHGVAR VAR(&PARM1) VALUE(&PARM1 *TCAT &NULL) PASESHELL: CALL PGM(QP2SHELL) PARM(&CMD &PARM1)

When I run the CL I get "Not authorized to i5/OS PASE program
/QOpenSys/usr/local/mysql/mysql/"

I'm not sure what I need to do to get this working. (both versions of
&PARM1 give the same result.)
Any ideas?

Thanks Mike



NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.