Re: PHP/MYSQL setup -- WEB400

Well once again Thank you! Let me decipher through these sites and I'll let
you know if I need anything else.

Jeff

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Mike Pavlak
Sent: Thursday, August 16, 2012 2:54 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] PHP/MYSQL setup

Hi Jeff,

Well, since you asked, There is a ton of info on the Zend.com site. Most
importantly are the manuals, Sample Scripts, Webcasts and online help. Most
of which is covered in my latest blog article:
http://mikepavlak.blogspot.com/2012/08/dont-suffer-in-silence.html

Specifically, there is a Getting Started webcast I would recommend:
http://www.zend.com/en/resources/webinars/i5-os

From the community there is a ton of stuff like

Alan Seiden's SUPER DUPER web site: http://www.alanseiden.com/

The YiP's site:(ALL PHP on IBM i) http://www.youngiprofessionals.com/

I think Brian may already offered his blog:
http://www.iprodeveloper.com/blog/open-your-i-24/

Jon Paris' articles at iProDeveloper (there is more than just this):
http://www.iprodeveloper.com/article/php-rpg-perspective-part-1-phpundamenta
ls%E2%80%94-basics
(and a great interview with Scott Klement completely unrelated to PHP:
http://www.iprodeveloper.com/article/rpg-programming/scott-klement-person-69
9430)

Bunches of upcoming events where PHP content will be highlighted like:
COMMON Columbus, OH:
http://www.common.org/index.php/fall-conference-and-expo.html
COMMON Las Vegas, NV:
http://www.common.org/index.php/focused-education-series.html
OMNI Chicago, IL: http://www.omniuser.org/index.php
Vermont: http://vtmug.org/
Various meetups on PHP:
http://www.meetup.com/find/?keywords=PHP&x=0&y=0&country=us
iProDeveloper Virtual Conference: https://rpgandbeyond.iprodeveloper.com/

And if you would like, I can schedule some time to show you around.

Hope this helps!

Regards,

Mike
Office Phone: (708)233-5880 Cell: (408)679-1011

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Jeff Elam
Sent: Thursday, August 16, 2012 1:18 PM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] PHP/MYSQL setup

Hi Mike,

It appears I have the ZendDBi installed correctly now as I can get to the
administration page via IE.

Now for the PHP. Is there a current redbook for the PHP? The latest one I
found was Jan. 2007 and I'm seeing some major inconsistencies between what I
have installed and the book.

For instance I found a piece that you authored or at least helped.

http://www-05.ibm.com/fr/events/modernisation_i/S4_PHP_les_solutions_Zend_po
ur_IBMi.pdf

Using some of the information from this I was able to get to the PHP
administration page up http:// <Ip Address>:10088/Zendserver/Login/Leave.

The redbook I have still uses http:// <ip address>:89/ZendCore.

Thanks,

Jeff

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Mike Pavlak
Sent: Thursday, August 16, 2012 9:33 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] PHP/MYSQL setup

Jeff,

Please make sure you COMPLETELY remove MySQL before installing. Also,
ZendDBi can only be installed on i6.1 and higher.

Here are the full removal steps I'll be illustrating in a webcast this
morning for Zend.

ENDSBS ZMYSQL OPTION(*IMMED)
DLTLIB ZMYSQL
CALL QP2TERM
rm -f /usr/local/mysql
rm -r -f /usr/local/mysql-5.1.50-i5os-power-64bit
rm -r -f /usr/local/mysqldata
rm -f /etc/my.cnf
rm -f /tmp/mysql.sock

Regards,

Mike
Office Phone: (708)233-5880 Cell: (408)679-1011

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of jeff elam
Sent: Wednesday, August 15, 2012 5:22 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] PHP/MYSQL setup

Installed both times with qsecofr will try again in morning to verify

Sent from my Verizon Wireless Droid

-----Original message-----
From: Mike Pavlak <mike.p@xxxxxxxx>
To: Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
Sent: Wed, Aug 15, 2012 21:48:19 GMT+00:00
Subject: Re: [WEB400] PHP/MYSQL setup

Jeff,

Given your error I would guess that you installed on V5R4 without QSECOFR
user profile (I don't care if you have *SECOFR as MySQL looks at the UID not
the profile name) For best results on all releases logon n as QSECOFR when
dealing with MySQL. You should not need it for i6.1 or i7.1, but...

The forums at Zend.com might be valuable, but these forums are darned good,
too!!!

There are two VERY good redbooks on MySQL for IBM i:
http://www.redbooks.ibm.com/abstracts/sg247398.html
http://publib-b.boulder.ibm.com/abstracts/sg247705.html

Regards,

Mike
Office Phone: (708)233-5880 Cell: (408)679-1011

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Jeff Elam
Sent: Wednesday, August 15, 2012 2:18 PM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] PHP/MYSQL setup

Thanks, I decided to uninstall the MYSQL and Installed the DBI

Tried starting the server and received the following error

Object not found. Object is /tmp/mysql.sock.

I received this same error earlier with the MYSQL. Bad part is I'm not sure
how I fixed it as I reset the PHP environment and that seemed to solve my
issue. I couldn't connect to the administration page via IE prior to that.

Any ideas on why that object is missing?

Please let me know if there is another forum this would be better served
on. I would also appreciate any links/suggestions on setting all of this
up from a beginner's standpoint. I've been a long time RPG guy and have
done everything Green screen to this point. I'm way behind the curve in web
development and figured it's way beyond time to change that.

I'm using the community version. I started this process a couple of years
ago got the hello world page up and going then got sidetracked on other
business projects. Therefor I no longer have the one year of support.

Jeff

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Timothy P Clark
Sent: Wednesday, August 15, 2012 1:59 PM
To: web400@xxxxxxxxxxxx
Subject: Re: [WEB400] PHP/MYSQL setup

Hi Jeff,

The warning about the versions is noise you can ignore. It means that
PHPMyAdmin is using an older MySQL client library. This is normal and should
work just fine with MySQL/DBi 5.1.x.

If you're just starting out with MySQL, I would suggest using Zend DBi. It
is the most current version of MySQL available on IBM i and is the
recommended way forward.

Hope that helps,
Tim Clark

date: Wed, 15 Aug 2012 12:18:52 -0400
from: "Jeff Elam" <jelam@xxxxxxxxxxx>
subject: [WEB400] PHP/MYSQL setup

Good afternoon,

I'm trying to get the Zend PHP server/MYSQL up and running on our
System

I was able to change the root password on the admin screen but I
noticed

I'm

also receiving an error at the bottom

"Your PHP MySQL library version 5.0.45 differs from your MySQL server
version 5.1.50. This may cause unpredictable behavior."

I also read something about Zendcore's apparent replacement for MYSQL

called

DBI. Am I barking up the wrong tree trying to get MYSQL up and running?

Thanks,

Jeff

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

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

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

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