Re: Auto starting ZEND and MYSQL subsystem and MYSQL Daemon

Brian,

When this was installed, it was using the ZEND core menus.  I believe
that it was ZEND CORE responding to starting a MYSQL option from the
menu, so I guess it would be from the savf.

I don't know that it was QSECOFR, but it was a profile with *SECOFR authority.

Yes, the jobq is in ZMYSQL, and is attached to the ZMYSQL subsystem.

I found a note in the archives at
http://archive.midrange.com/web400/200903/msg00055.html that includes;

Here are the notes from 2.5.1:
MySQL extension is not working after updating Zend Core with 2.5.1, the
libmysqlclient.a file should be removed from /usr/local/Zend/core/lib.
Note: The new MySql client libmysqlclient.a file is placed in the
following directory /usr/local/Zend/core/lib/mysql

I found the libmysqlclient.a file in the mentioned directory, and
renamed it to *.old. The same file was in th .../mysql subdirectory
I will do some testing when the PHP programmer and the graphic
designer have gone home to see if the problem is fixed.

Jim


On Wed, Jun 24, 2009 at 3:21 PM, <BMay@xxxxxxxxx> wrote:

I have seen this happen more than once.

1.  Did you use the windows installer or the SAVF?
2.  When installing via either method, did you log in using QSECOFR?
3. Does the ZMYSQLJBQ jobq in library ZMYSQL exist?  Is it attached to the
ZMYSQL subsystem?

Brian May
Project Lead
Management Information Systems
Garan, Incorporated
Starkville, Mississippi

Young i Professionals
http://www.youngiprofessionals.com



Jim Essinger <dilbernator@xxxxxxxxx>
Sent by: web400-bounces@xxxxxxxxxxxx
06/24/2009 04:14 PM
Please respond to
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>


To
"Web Enabling the AS400 / iSeries" <web400@xxxxxxxxxxxx>
cc

Subject
[WEB400] Auto starting ZEND and MYSQL subsystem and MYSQL Daemon






After a quick check of the archives, where I did not see this addressed,
and
looking at the ZEND forums, where It is only partially addressed, I am
looking for how to gracefully end and start the ZEND and ZMYSQL
subsystems,
the ZEND http server instance, and the MYSQL daemon.  The only way I have
gotten the daemon to start is to start a PASE shell session, then issue
the
'mysqld_safe &' command.  This puts the daemon running in QINTER.

What am I missing in getting the MYSQL daemon to start in the ZMYSQL
subsystem?  It does not seem to start when I start either the ZEND or
ZMYSQL
subsystems, nor does it start when taking the "4. Start MySQL daemon" menu
option off of the "Zend MYSQL Management" menu.

Thanks!

Jim
--
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.


--
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.