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



Jeff,

I just looked at the new version of phpMyAdmin. It seems the setup script
has moved since the Redbook was written. (Not surprisingly)

Try http://192.168.0.1:89/phpMyAdmin/setup/

As for the errors, you will set up your blowfish secret word in the setup
script. Don't worry too much about the mcrypt error. I don't have it
loaded on either of my installs and I have had no problems.

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

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



"Jeff Crosby" <jlcrosby@xxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/26/2009 09:02 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

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





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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.