Re: MySql / ZENDDbi running on i

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