Re: Autostarting MYSQL

["Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>]

Thanks Scott.  
I'll take a look at this in the morning 

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

hi Mike,

Okay, I looked up how I start MYSQL on my system.  Because there's a
bunch of settings I want to be set properly for MYSQL, I decided the
best thing was to create a MYSQL subsystem, and put all of the settings
into the subsystem description.  That way, you can simply start the 
subsystem to start MySQL...   Without that, it'd be tricky to start it 
with consistent settings.

So I created a library (also named MYSQL) and created the subsystem
objects, etc, in it.  I wrote a CL program to create the library and
it's objects (so I'd be able to recreate it later if necessary)  here's
the code for that:

http://code.midrange.com/aa6f8aed17.html

What you'd want to do is modify that CL program as appropriate (in
particular, look at the path name where I'm keeping MySQL.. it might not
be the place you prefer to use)  On my box, I named that source member
SETUP

Then compile it:

    CRTCLPGM SETUP SRCFILE(xxx/QCLSRC)

Then run it:

    CALL SETUP PARM(MYSQL)

(the parm is the name of the library where you want to put the subsystem
and other objects -- I used the name MYSQL for that library.)  It will
also create a QCLSRC file in that library.  For convenience I put all of
my CL code into that source file.  (Which doesn't quite make sense since
you already need the code to create the library in the first place --
but I threw the CL in there after I ran it so I didn't lose it.)

Then you need a program named STRMYSQL to start MYSQL (it's called by
the subsystem created above).  Here's the code for that program:

http://code.midrange.com/637d09aca2.html

And I also created another one called ENDMYSQL that ends the server
properly.  Here's the code for that:

http://code.midrange.com/dd2725206e.html

Then, in QSTRUPPGM, you should be able to do this:

  STRSBS SBSD(MYSQL/MYSQL)
  MONMSG MSGID(CPF0000)

(though, I haven't tested that part.  My startup process is different...

on my box, QSTRUPPGM submits another program that does a whole lot of
other processing, and eventually runs those commands... but I assume
it'll work just as well if run directly from QSTRUPPGM)

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.

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.




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.