× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Ditto on what Scott said, and it looks like you're specifying "mysqlsafe"
as the executable. Make sure you get the "d" in there: "mysqldsafe".

Tim

Subject: Re: Autostarting MYSQL
From: Scott Klement <web400@xxxxxxxxxxxxxxxx>
Date: Mon, 04 Jan 2010 14:20:25 -0600

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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.