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


  1.  Home
  2. MIDRANGE-L
  3. January 2017

Re: MySql / ZENDDbi running on i

Depends on what you mean by "better" Jack.

If writing your own PHP code you would normally use the DB2 access directly.

If you have an application that uses mySQL then I personally would only use the DB2 storage engine for those tables where I need to process the data with both PHP and RPG.

At this point I'm going to stop this post and wait for you to reopen this thread on the Web400 list. David will just get cross with us if we continue it here. <grin>

P.S. In order to use the Admin console you do apparently need a key from Zend for the current version - either a full license key or one for the basic edition. I would suggest you do as I suggested earlier and just drop a copy of adminer into your root folder and use that. It is every bit as good as PHPmyAdmin and better in some ways as well as being simpler and faster.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Jan 25, 2017, at 10:28 AM, Jack Tucky <jacktucky@xxxxxxxxx> wrote:

Hi Jon: I can't get to Phpmyadmin, only the screen that tells me to choose
a version of Zend. I guess a license is required? I've tried to fill out
the serial number for the basic version but I never hear back from Zend.

I'm going to give them a call today because I think it would be better to
use Db2 on the i instead of mySql.

Thanks

On Thu, Jan 19, 2017 at 2:29 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

Well I don't know what PHP you are running if not Zend <grin>

If you go to yourSystemName:10080/ZendServer/ you should be taken to the
control panel which at some point you'll need particularly if working with
Wordpress.

From there you can also set up PHPMyAdmin which you'll find a useful tool
for setting authorities, backing up tables, etc. With a tool like WP the
"database" - if such it can be called - probably holds no interest as far
as using it from RPG or SQL is concerned, but that interface also makes it
easy to change the underlying DB storage engine so that you could switch to
using the DB2 storage engine if desired for software where you do want to
share the data.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Jan 19, 2017, at 12:56 PM, Jack Tucky <jacktucky@xxxxxxxxx> wrote:

I have a working PHP Apache instance. We don't really use Zend as far
as I
know.

When I go to
http://myserver:10080/wordpress/wp-admin/setup-config.php?step=1 I see
the
page to enter the DB connection details.

When I enter the correct info, I get the page
Error establishing a database connection

If I create a wp-config.php file, it tells me it already exists.

Thanks for the quick response.



On Thu, Jan 19, 2017 at 12:48 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx>
wrote:

Jack can you be a bit more precise about " it's not working." - that
really doesn't help.

Can you see the Zend Server control panel?

Can you see a regular HTML page when using this Apache server instance?

When you try to launch WP what happens? Does it show you the setup page
or
???


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Jan 19, 2017, at 12:43 PM, Jack Tucky <jacktucky@xxxxxxxxx> wrote:

I have it installed and have created a database and user. Since I can
use
QP2TERM to run commands on the DB I assume it's running.

I'm trying to install Wordpress for a POC. I try to connect with this
sample PHP, but it's not working. How can I confirm all of my settings
on
the mySql server? Thanks

<?php
# Fill our vars and run on cli
# $ php -f db-connect-test.php

$dbname = 'wordpress';
$dbuser = 'myuser';
$dbpass = 'mypassword';
$dbhost = 'localhost';

$connect = mysql_connect($dbhost, $dbuser, $dbpass) or die("Unable to
Connect to '$dbhost'");
mysql_select_db($dbname) or die("Could not open the db '$dbname'");

$test_query = "SHOW TABLES FROM $dbname";
$result = mysql_query($test_query);

$tblCnt = 0;
while($tbl = mysql_fetch_array($result)) {
$tblCnt++;
#echo $tbl[0]."<br />\n";
}

if (!$tblCnt) {
echo "There are no tables<br />\n";
} else {
echo "There are $tblCnt tables<br />\n";
}
--
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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

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

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
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.