Re: PHP/MYSQL setup

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

One very strong caution:  Since you will be signed on with a very high 
authority profile, and you will be using the "-f" which means "force it" 
and "-r" which mean recursive though all the directories from there down;

Be really, really; no-really careful about those "rm" statements.  Make 
sure you fully qualify them as Mike shows below because bad things can 
happen if you mistakenly run these commands from the wrong directory etc.

Before doing this I strongly suggest a "cd /usr/local" first.  At least 
if the command is run improperly you'll minimize the damage.  Also 
remember Tape is your friend!

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 8/16/2012 8:32 AM, Mike Pavlak wrote:
> 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
> > >  
> > >  
> > >  
> > >  
> --