RE: PHP and mySQL startup

["Jeff Crosby" <jlcrosby@xxxxxxxxxxxxxxxx>]

Thanks - just sent you an email.

--
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 BMay@xxxxxxxxx
> Sent: Wednesday, February 25, 2009 3:00 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: PHP and mySQL startup
>
> I would be happy to give you a hand with this.  Contact me off list and I
> will work through your issue with you.  It sounds like MySQL is not up on
> your IBM i.
>
> 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/25/2009 01:50 PM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
> To
> "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
> cc
>
> Subject
> PHP and mySQL startup
>
>
>
>
>
>
> All,
>
> I have successfully installed PHP and MySQL onto our System i. Other than
> that, I am a long time RPG Developer and know absolutely squat about PHP.
> I
> have dabbled in SQL.
>
> What we want to do is put up a "Product Search" on our GoDaddy hosted
> website, which I figure should be relatively simple for a good PHP
> developer.  I plan on hiring someone local to do the actual PHP.  But that
> local person isn't going to know squat about the i.
>
> I already have the product search table built as a DB2/400 table (it is
> defined via DDL, not DDS).  I know it has to be reworked as a MySQL table,
> and that subsequent to that, it can be seen as a DB2/400 table as well.  I
> don't know how to proceed in getting that done.  A number of the i5/OS and
> Getting Started links on the zend.com website are broken.  Zend Studio
> looks
> virtually nothing like the pictures in the installation and users guides
> (because they went to the next version of Eclipse in Zend Studio and
> haven't
> updated the documentation).
>
> I downloaded a windows program from Sun called MySQL Administrator to my
> PC
> and tried to connect to MySQL on the i.  Not allowed - I get an error box
> "MySQL error 1130.  Host 192.168.0.35 is not allowed to connect to this
> MySQL Server."  192.168.0.35 is the IP address of my PC.  This tells me
> that
> it's running on the I and that's about it.
>
> I opened a support ticket with Zend and they suggested I take their $600
> course.  Spending $600 for that isn't in the cards right now.  I could
> contact the mySQL people at Sun (They've already emailed me) but I don't
> think they'll be too knowledgeable about the setup on the i.
>
> All I was really hoping for is to get the MySQL table set up properly, be
> able to connect to the MySQL database from Zend Studio, and then turn a
> PHP
> developer loose.  The PHP could be developed (or tweaked from an already
> existing search) on my PC within our office.  When satisfied, we could
> upload the whole shebang to GoDaddy.  It would remain on my PC as well, so
> I
> could tinker, tweak, learn, and play to my hearts content without
> affecting
> the actual website.  Sound doable?
>
> I essentially have 2 problems:  1) How to get this single DB2/400 table to
> be a MySQL table, and 2) how to connect to the MySQL database on the I
> from
> my PC.
>
> It shows just how sheltered a life I've led in that it still seems really
> odd that one has to "connect" to a database to use it.  At the same time,
> the network consultant/website developer I have come in can't seem to get
> his head around the idea that the database on the i is "just there".
>
> I appreciate any help in this.  I truly don't know how I'd survive without
> this list.
>
> --
> 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.
>
>
>
> --
> 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.
>
>
> --
> 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.