Here's a simple startup process that I created:
1.) I created an IFS script file in /qopensys/usr/local/mysql5142 called
startmysql.sh.
I installed my version of MySQL to: /qopensys/usr/local/mysql5142
Here's the contents of that file:
cd /QOpenSys/usr/local/mysql5142/mysql-5.1.42-i5os-power-32bit
/QOpenSys/usr/local/mysql5142/mysql-5.1.42-i5os-power-32bit/bin/mysqld_s
afe &
2.) Then I created a CL called STARTMYSQL and put the following inside:
PGM
DCL VAR(&CMD) TYPE(*CHAR) LEN(1024)
MONMSG MSGID(CPF0000) EXEC(GOTO CMDLBL(ERRORS))
/*---------------------------------------------------------------------
/* BUILD THE PASE CALL TO START MYSQL SERVER */
/*---------------------------------------------------------------------
CHGVAR VAR(&CMD) +
VALUE('/QOpenSys/usr/local/mysql5142/startm+
ysql.sh')
/* START THE MYSQL SERVER */
CALL PGM(QP2SHELL) PARM('/QOpensys/usr/bin/-sh' +
'-c' &CMD)
RETURN
/*---------------------------------------------------------------------
/* Handle Errors
/*---------------------------------------------------------------------
ERRORS:
SNDPGMMSG MSGID(CPF9898) MSGF(QCPFMSG) MSGDTA('Errors +
occurred while starting MySQL Server') +
MSGTYPE(*ESCAPE)
ENDPGM:
ENDPGM
Then I simply submit STARTMYSQL to QSYSNOMAX to start MySQL as a batch
job.
Regards,
Richard Schoen
RJS Software Systems Inc.
"Get the information you need. Now!"
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site:
http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
------------------------------
message: 2
date: Mon, 4 Jan 2010 14:23:02 -0500
from: "Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>
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
midrange.com
