Re: Autostarting MYSQL

Hi, Scott,
That actually makes sense. I just copied from a CL I found
somewhere(zend forum- I think). I know there was a thread about it on
Midrange not too long ago, but I couldn't seem to find it. I will
search again.

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Scott Klement
Sent: Monday, January 04, 2010 3:20 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] 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.