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.
midrange.com
