Re: Zend and V7R1 -- WEB400

Is there a cheat sheet for how to use the db2_ functions? I was hoping there wasn't much more than search/replace i5_ with db2_

Sadly, I get a failure at db2_pconnect($hostname,$db2username,$db2password);

With the only change being from i5_pconnect($hostname,$db2username,$db2password);

$hostname='127.0.0.1';
$db2username='';
$db2password='';

I tried substituting my username and password, but it still failed. The "Zend Server -> Logs" screen doesn't show anything. I only know it failed because I checked the status in the php script (and of course because I get no results).

It's amazing what I've saved from this list that I hadn't looked at in 3 years... I had someone else's message that would have answered my freetds question earlier. I found a list of db2_ functions and even a reply to my email about i5_ vs. db2_ (which was basically "you can use either or both").

I see db2_free_result is probably the replacement for i5_free_query, and I'll have to figure out what I'm going to do on the i5_open and i5_seek that I used, but I haven't gotten that far yet.
--
Sean Porterfield

-----Original Message-----
From: Alan Seiden [mailto:alan@xxxxxxxxxxxxxx]
Sent: Thursday, November 01, 2012 20:11
To: Web Enabling the AS400 / iSeries
Cc: Porterfield, Sean
Subject: Re: [WEB400] Zend and V7R1

Sean, although some shops used i5_prepare() to access DB2, and I
sympathize with their need to convert to db2_* functions now, most
seemed to use the native db2_* functions from the start.

Alan

On 10/31/12 11:11 AM, Porterfield, Sean wrote:

Apparently they didn't include i5_prepare in CW. This must be an absolute nightmare for shops that really use Zend Core extensively.
--
Sean Porterfield

From: Alan Seiden [mailto:alan@xxxxxxxxxxxxxx]
Sent: Friday, October 26, 2012 16:20
To: Web Enabling the AS400 / iSeries
Cc: Porterfield, Sean
Subject: Re: [WEB400] Zend and V7R1

Sean,

You received "undefined function i5_pconnect()" because Zend Server no longer ships with the Easycom i5 toolkit.

On a new server installation you need to use the new toolkit. To keep your PHP code 99% unchanged, you can use the included Compatibility Wrapper (CW).

Resources:
http://www.slideshare.net/aseiden/new-php-toolkit-from-zend-and-ibm-open-source-on-ibm-i
http://www.iprodeveloper.com/article/application-development/php-toolkit-perfect-match-rpg-699367

If you need any help just let me know.

Alan
--
Alan Seiden Consulting LLC
PHP for IBM i expertise and advocacy

Lead PHP Developer, new toolkit for IBM i
Zend Framework certified contributor

Office: 201-447-2437 Cell: 201-248-4704
http://www.alanseiden.com | alan@xxxxxxxxxxxxxx<mailto:alan@xxxxxxxxxxxxxx>

http://alanseiden.com/tips
http://twitter.com/alanseiden

On 10/26/12 12:57 PM, Porterfield, Sean wrote:

Zend Server installed easily (still on V5R4). I got a warning or error that MySQL was not installed because it was already installed (with Zend Core).

I copied my sites over to the new directory and get some things back but not everything. I finally found an error logged in the Zend Server console that said Call to undefined function i5_pconnect().

The only thing I could find, that didn't help, was http://www.easycom-aura.com/Data/WebHelp/PHP/api_functions/connection/i5_pconnect.htm that said I needed to configure the port in php.ini.

--

Sean Porterfield

-----Original Message-----

From: web400-bounces@xxxxxxxxxxxx<mailto:web400-bounces@xxxxxxxxxxxx> [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Mike Pavlak

Sent: Monday, October 15, 2012 17:30

To: Web Enabling the AS400 / iSeries

Subject: Re: [WEB400] Zend and V7R1

That is correct. In addition, please make sure that you are on Zend Core 2.6.1 as anything older could "break" the Zend Server installation when you go to DLTLICPGM on 1ZCORE5...

http://kb.zend.com/index.php?View=entry&EntryID=242

Regards,

Mike

Office Phone: (708)233-5880 Cell: (408)679-1011

-----Original Message-----

From: web400-bounces@xxxxxxxxxxxx<mailto:web400-bounces@xxxxxxxxxxxx> [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Porterfield, Sean

Sent: Monday, October 15, 2012 3:31 PM

To: Web Enabling the AS400 / iSeries

Subject: Re: [WEB400] Zend and V7R1

Theoretically, I should be able to install Zend Server, migrate everything over to the new setup, remove Zend Core, upgrade to 7.1? Still a lot of planning, but that would reduce the hassle on OS upgrade day.

--

Sean Porterfield

-----Original Message-----

From: Mike Pavlak

Sent: Sunday, October 14, 2012 23:04

To: Web Enabling the AS400 / iSeries

Subject: Re: [WEB400] Zend and V7R1

But please keep in mind a few things:

1) Zend Core is pushing around PHP 5.2.something which has been deprecated by the community for nearly 2 years! http://php.net/archive/2010.php

2) Zend Core is NOT SUPPORTED and will not install on i7.1. If you upgrade an IBM i OS to i7.1, be very concerned about Core running.

3) Zend Server tends to run faster than Zend Core, primarily due to the switch from 2 Apache servers to FastCGI. YMMV

4) Some of the latest frameworks (Symfony 2, Zend Framework 2) are looking for PHP 5.3. Smarty still runs on PHP 5.2, but...

5) Zend Server is still a no charge feature!

6) One of the more popular "breakages" when upgrading is the fact that the CLI now require that you use PHP-CLI rather than just PHP. Have had several customers discover their batch based PHP was running under Core while the rest of their world was running under Server. D'oh!

If you must stick with PHP 5.2 here are a couple of tips:

1) Download the correct version of Zend Server! PHP 5.2 and PHP 5.3 are available at Zend.com (again, at no charge!!!). PHP 5.4 coming soon.

2) Keep in mind that a migration of Zend Server from PHP 5.2 to PHP 5.3 requires a rip-and-replace upgrade.

So, the moral of the story is, if you can get to PHP 5.3, it would probably serve you better in the long run. Here is a link that discusses incompatibilities: http://www.php.net/manual/en/migration53.incompatible.php

Usually not too much risk for most of the IBM i installations.

Regards,

Mike

Office Phone: (708)233-5880 Cell: (408)679-1011

-----Original Message-----

From: web400-bounces@xxxxxxxxxxxx<mailto:web400-bounces@xxxxxxxxxxxx> [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Alan Seiden

Sent: Saturday, October 13, 2012 11:01 AM

To: Web Enabling the AS400 / iSeries

Subject: Re: [WEB400] Zend and V7R1

Yes, you can Zend Core and Zend Server at the same time.

Alan

On 10/13/12 7:18 AM, Jack Kingsley wrote:

Question, can you run both at the same time.

On Fri, Oct 12, 2012 at 7:05 PM, Scott Klement <web400@xxxxxxxxxxxxxxxx><mailto:web400@xxxxxxxxxxxxxxxx>wrote:

Hi Sean,

Since Zend Core and Zend Server run in PASE (rather than the native

environment) they can operate more or less independently of the OS

version. It's possible to update IBM i and leave Zend Core running,

as-is, on the updated box.

However, if you do decide to upgrade Zend Core to Zend Server, in my

experience it does break some stuff, but they are mostly minor things.

You'll want to go back and re-test your programs on the new server,

and fix anything that broke. (You can run both Zend Core and Zend

Server on the same box at the same time if you like.)

Good luck!

On 10/12/2012 3:17 PM, Porterfield, Sean wrote:

Is there an upgrade guide for going from V5R4M5 with Zend Core to

V7R1 which I believe should be Zend Server?

I'm not so much concerned with the configuration bits, as I'm pretty

sure I can figure that out (though if it's documented somewhere,

I'll certainly accept the easy way out.)

I'm thinking more along the lines of should I uninstall the previous

version before upgrading the OS? Will MySQL go easily along with

it?

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.