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