Re: Autostarting MYSQL

I haven't yet put it in QSTRUPPGM, but
I do have it created to use adopted authority and I'm running it from a
Power user profile. Still no luck.

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Mike Pavlak
Sent: Monday, January 04, 2010 2:30 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Autostarting MYSQL

If you are trying to do this from QSTRUPPGM the default user is QPGMR
who may not have enough "oomph" to start up MySQL. You may need to
compile the program with adopted authority, et al.

Regards,

Mike

mike.p@xxxxxxxx Cell: (408)679-1011 Office: (815)722-3454

Zend Server for IBM i Beta avilable at
http://www.zend.com/en/products/server/zend-server-5-new-ibmi



-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Smith, Mike
Sent: Monday, January 04, 2010 1:23 PM
To: Web Enabling the AS400 / iSeries
Subject: [WEB400] Autostarting MYSQL

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.