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



That is correct (not that I've tried using that engine, but I do have databases in MySQL that are not in QSYS.LIB).

The article also says that the storage engine does not recognize existing db2 tables.
--
Sean Porterfield

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, February 25, 2009 15:53
To: Midrange Systems Technical Discussion
Subject: RE: PHP and mySQL startup

I'm thinking that if you don't set that engine then when you build a database it builds it internally to mysql and not in the qsys.lib file system.

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 03:51 PM
Subject:
RE: PHP and mySQL startup
Sent by:
midrange-l-bounces@xxxxxxxxxxxx



Rob, that's too much information . . . <g>

Yes, those make sense but I'm not to that point just yet.

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




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


This email is confidential, intended only for the named recipient(s) above and may contain information that is privileged. If you have received this message in error or are not the named recipient(s), please notify the sender immediately and delete this email message from your computer as any and all unauthorized distribution or use of this message is strictly prohibited. Thank you.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

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.