Re: Autostarting MYSQL

Subject: Re: Autostarting MYSQL
From: Scott Klement <web400@xxxxxxxxxxxxxxxx>
Date: Mon, 04 Jan 2010 14:20:25 -0600

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

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

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

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

&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.