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


  1.  Home
  2. WEB400
  3. August 2012

Re: 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-phpundamentals%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-699430)

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


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.