RE: PHP and mySQL startup

I'm 'this close' to having phpMyAdmin set up and running.

I'm following the Redbook "Discovering MySQL on IBM i5/OS". I'm in section
4.3.3 where it has these instructions for an automatic setup script. These
instructions:

------------------------------------------------------------

Automatic setup script for phpMyAdmin

Instead of manually editing the config.inc.php file, you can use the setup
script as explained in
the following steps.

1. Create a folder named config inside the phpMyAdmin directory. On the
i5/OS PASE shell,
type the following commands to create and give write permissions to the new
directory:
mkdir config
chmod o+rw config

2. Run the setup script in your browser:
http://your_host/path_to_phpMyAdmin/scripts/setup.php

In our case, we entered:
http://rchas55.rchland.ibm.com:89/phpMyAdmin/scripts/setup.php

--------------------------------------------------------------

In my case, I entered: http://192.168.0.1:89/phpMyAdmin/scripts/setup.php
It doesn't work. The redbook didn't say anything about creating a setup.php
file, though it talks about a config.inc.php, which I don't even have. The
redbook is almost a year old, which may have something to do with it. I
tried it without a setup.php file, and I tried it creating an empty
setup.php file.

I CAN use the link http://192.168.0.1:89/phpMyAdmin however, and it opens
phpMyAdmin. Don't have a clue what to do just yet. Got these errors at the
bottom of that page:

"Cannot load mcrypt extension. Please check your PHP configuration."
"The configuration file now needs a secret passphrase (blowfish_secret)."

The first error may have something to do with not having done proper setup.
The second error probably the same, though it sounds like something from a
porn site. It's the first day of kindergarten for me.


--
Jeff Crosby
UniPro FoodService/Dilgard
P.O. Box 13369
Ft. Wayne, IN 46868-3369
260-422-7531
www.dilgardfoods.com

The opinions expressed are my own and not necessarily the opinion of my
company.  Unless I say so.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Porterfield, Sean
Sent: Wednesday, February 25, 2009 3:51 PM
To: Midrange Systems Technical Discussion
Subject: RE: PHP and mySQL startup

From: Jeff Crosby

I have successfully installed PHP and MySQL onto our System i.

Did you do this manually or install Zend Core?

"MySQL error 1130. Host 192.168.0.35 is not allowed to connect to this

MySQL Server."

This is "normal" with any MySQL installation. There is a mysql database

that

handles the security for MySQL. The Zend installer adds an entry to the

user

table to allow access from your system. If you want access from other
locations, you need entries in the user table. (Check MySQL documentation
for alternatives; there are many ways to configure MySQL.)

The user table has fields for host, user, password, and what permissions

are

allowed. You could allow user root to do anything from localhost but be

read

only from 192.168.0.35, for example.

You should be able to get to a mysql command line from within "CALL

QP2TERM"

but I'd have to dig up specifics if you don't know how to do that. Let's
just say that I've done it, but it wasn't easy.

Another alternative is to install (i.e. unzip and put in htdocs folder)
phpMyAdmin which will make this process much easier.
--
Sean Porterfield

This email is confidential, intended only for the named recipient(s) above
and may contain information that is privileged. If you have received this
message in error or are not the named recipient(s), please notify the

sender

immediately and delete this email message from your computer as any and

all

unauthorized distribution or use of this message is strictly prohibited.
Thank you.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.