|
-----Original Message-----than
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, February 25, 2009 3:35 PM
To: Midrange Systems Technical Discussion
Subject: Re: PHP and mySQL startup
Just went back to the crapper and retrieved "IBM Systems Magazine"
February 2009. (Picture of DB2 train on cover.)
Article "Next Stop: Open Source" by Erwin Earley.
Paragraph "Setting the Storage Engine". Something about changing the
/etc/my.cnf and add this line
default-storage-engine-IBMDB2I
to the [mysqld] section.
Make any sense?
They also listed a few other options, including
CREATE TABLE t1 (...) ENGINE=IBMDB2I;
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From:
"Jeff Crosby" <jlcrosby@xxxxxxxxxxxxxxxx>
To:
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Date:
02/25/2009 02:50 PM
Subject:
PHP and mySQL startup
Sent by:
midrange-l-bounces@xxxxxxxxxxxx
All,
I have successfully installed PHP and MySQL onto our System i. Other
that, I am a long time RPG Developer and know absolutely squat aboutPHP.
Ithat
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
local person isn't going to know squat about the i.table,
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
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/OSand
Getting Started links on the zend.com website are broken. Zend Studiobox
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
"MySQL error 1130. Host 192.168.0.35 is not allowed to connect to thisbe
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,
able to connect to the MySQL database from Zend Studio, and then turn aso
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,
Ito
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
be a MySQL table, and 2) how to connect to the MySQL database on the Ireally
from
my PC.
It shows just how sheltered a life I've led in that it still seems
odd that one has to "connect" to a database to use it. At the sametime,
the network consultant/website developer I have come in can't seem toget
his head around the idea that the database on the i is "just there".without
I appreciate any help in this. I truly don't know how I'd survive
this list.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
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.
As an Amazon Associate we earn from qualifying purchases.
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.