Re: MYSQL error requires IPL -- WEB400

It most definitely is a different world. While the AS400 might be the
pinnacle of not having to reboot, it is also the pinnacle of the most
disorganized installation ever. I received my new Power6 machine and am
trying to figure out what the steps are to start up and get connected.
First, in paper form, tell me to type in a crazily long URL which only ends
up hanging and states it can't connect (I rechecked it MANY times). Then
once I got there it still wasn't telling me how to start the machine.
Finally I started at the top of infocenter and worked my way down to the
install process.

IMO, I should be able to hook an ethernet cable into T1 (the labeled
ethernet port on the back) and go to a specific IP address FROM ANY PLATFORM
(i.e. they require you run Windows and Client Access) and continue setup
from there. IBM i in the cloud, where are you?

Aaron Bartell
http://mowyourlawn.com

On Wed, Oct 28, 2009 at 2:31 PM, dale janus <dalejanus@xxxxxxxxxxxxxxxxx>wrote:

I just have to vent a little here about MYSQL (free community edition)
and the new, modern world we live in.

We are very small shop, and we have implemented the IAMP stack
internally. Our main business use of our internal web site is to add
and view image files. We also use it for lots of file inquiry, but we
NEED it to scan, view and print image files (all documents in PDF
format) every day. So no web site, no scanning/viewing/printing
images. Business grinds to a halt, unhappy users, etc.

Last month we upgraded to the latest version of MYSQL 5.1.39 to get the
IBMDB2I storage engine because we kept getting errors trying to load our
data into SUGARCRM. The new version fixed the errors.

Last week we were working on another PHP application (moving data entry
from green screen to PHP program on the web) and we simply needed to add
a field to a MYSQL database. As usual, we used PHPMYADMIN, but this
time it would not run correctly. Ok, we figure, something's wrong with
PHPMYADMIN, let's use SQLCC. It runs, but will not allow any changes
to the database. Hmmmm.

We tried to install new verion of phpmyadmin, got errors.
We then tried mysql_upgrade. Got errors.
We tried myslq_fix_privalege_table, got errors.
Shut down mysql, then tried mysql_upgrade.
Tried mysql_fix_privalege_table.
Started mysqld_safe, got errror "could not remove old PID file".
We tried to delete PID file with OPSNAV, could not because it was in use.
We changed my.cnf to use new pid file. Got error device busy.
Shut down apache, all HTTP servers, all subsystems we thought could be
remotely connected to this problem. We could not delete the PID File
MYSQL wanted to recreate.
We called IBM to ask how to delete PID file in IFS. AS/Navigator
properties could not show what job was using it, so IBM recommeded IPL
of AS400.
We restared the as400. IT took 45 minutes, but after it came up, MYSQL
worked just fine. Total elapsed time from start of problem to
resolution, 6 hours.

I am just amazed that I had to resort to a PC tactic of re-booting to
fix things. I guess if you're using PC type tools, you need PC type
fixes.

While searching the web for possible solutions, we came across many
suggestions. Each involved changing some arcane setting somewhere in
MYSQL config files. Lots of stuff that I had a hard time understand
what the suggestion would do, and where the heck to find it. "go look
at yetanother.cnf in the etc/bin/usr/notthatusr/theotherusr" or the
"outie.ini in the /local/express/metro/nonstop" or some other deeply
nested directory. "Remove the 3rd comma and # from the 2nd line."

Anyway, I am assuming that people that run their entire business on a
LAMP stack put up with all this crap. No wonder they need a system
administrator. I have enough work getting my applications to do what I
want, I don't want to have to know all the ins and outs of MYSQL or
APACHE. Geez, imagine the as400 database not working.

The sad thing is we know the as400 (I, Iseries, whatever) is a better
way but IBM is doing it's best to keep it a secret.

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