Re: Autostarting MYSQL

[Scott Klement <web400@xxxxxxxxxxxxxxxx>]

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.