× 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

Thanks Jim.

On Jan 20, 2017, at 11:49 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

I hate Captcha. I struggle with that when I go into LinkedIn.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 01/20/2017 11:47 AM
Subject: RE: MySql / ZENDDbi running on i
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



I sent it off line with the attachment.

Code.midrange.com keeps failing the Captcha test.


--
Jim Oberholtzer
Agile Technology Architects


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Jack
Tucky
Sent: Friday, January 20, 2017 10:01 AM
To: Midrange Systems Technical Discussion
Subject: Re: MySql / ZENDDbi running on i

That's what I thought. Can anyone post their index.html? We overwrote
the
original. dumb

thanks

On Fri, Jan 20, 2017 at 10:04 AM, Jim Oberholtzer <
midrangel@xxxxxxxxxxxxxxxxx> wrote:

The apache instance for Zend Server will be in /www/zendsvr6/*

In there you'll find three directories, conf, htdocs, and logs.
Explore conf. You find the .conf file s that Zend server uses.

Inside HTDOCS you'll find the index.html.




--
Jim Oberholtzer
Agile Technology Architects


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Jack Tucky
Sent: Thursday, January 19, 2017 8:10 PM
To: Midrange Systems Technical Discussion
Subject: Re: MySql / ZENDDbi running on i

Right, I meant we don't have a license for any paid Zend features.

I can't get to the control panel from that URL. Our Zend is installed
from
root @ /www/zendsvr6. Should there be an index.html or .php somewhere
in
that directory?

Thanks again.



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

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