Re: Autostarting MYSQL

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

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.