Re: Zend and V7R1 -- WEB400

I should have been more clear when I said "Both my stripped down and full script now work in Core but not in Server from the same system."

What I meant was that I get the exact same error from Zend Server when the script does nothing but connect. Since that's where it failed in my original script, it really didn't prove much, but it did let me ensure I didn't have some other problem interfering with the error message I saw.

cat ms.php

<?php
$connSQL = mssql_connect('myserver','user','password');
if ($connSQL) {
echo "Success!\n";
} else {
echo "SQL Connection failed.\n";
}
?>
$

/usr/local/zendsvr/bin/php-cli ms.php

[29.10.2012 17:08:04 SYSTEM] Zend Monitor UI is disabled in CLI/CGI run...
PHP Warning: mssql_connect(): Unable to connect to server: myserver in ms.php on line 2
SQL Connection failed.
$

/usr/local/zend/core/bin/php ms.php

Success!
$

(Names have been changed for obscurity, but it's clear that it doesn't connect from Zend Server and does from Zend Core.)
--
Sean Porterfield

-----Original Message-----
From: Alan Seiden
Sent: Monday, October 29, 2012 16:34
To: Web Enabling the AS400 / iSeries
Cc: Porterfield, Sean
Subject: Re: [WEB400] Zend and V7R1

What happens now when you run the stripped-down version in Zend Server?

On 10/29/12 1:13 PM, Porterfield, Sean wrote:

Yes, the script works fine on Zend Core on my production system. I'm able to ping the server from the backup system where I installed Zend Server.

The script failed on the backup system in Zend Core before it got to that line, so I don't know if the mssql part works there.

I decided to strip it down to just the mssql_connect() and test with Zend Core. I got an error that the function didn't exist. (I lost the exact output, but that's close enough probably.)

When I tried to check /usr/local/Zend/Core/etc/php.ini, I noticed I didn't have access to view it. I updated the directory and file permissions and no longer got the function doesn't exist error. Both my stripped down and full script now work in Core but not in Server from the same system.
--
Sean Porterfield

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

Sean, I will try for 3 out of 3:

Don't you find the error message a bit suspicious?

Unable to connect to server: myservername

Do you have a server called "myservername?"

Alan

On 10/29/12 10:14 AM, Porterfield, Sean wrote:

Looks like you're 2/2.

Not authorized to object. Object is /etc/zce.rc.

/usr/local/ZendSvr/etc is configured as *PUBLIC *EXCLUDE. I changed that, so I can read the file.

Now I get:

PHP Warning: mssql_connect(): Unable to connect to server: myservername in myscript.php on line 10

Did mssql_connect() change as well?

I'm on my backup system, so I can't be sure it worked before, as I only ran it on the production system. I just tried running it in Zend Core on the backup system, but I got an error about undefined function ldap_connect() on line 3 which probably isn't worth troubleshooting.

I do see in the production Zend Core php.ini:

extension=mssql.so

Adding that to the zendsvr php.ini didn't help.

Sean Porterfield

Sr. Systems and Network Engineer

Beacon Roofing Supply

919-739-8126

From: Alan Seiden

Sent: Friday, October 26, 2012 16:27

To: Web Enabling the AS400 / iSeries

Cc: Porterfield, Sean

Subject: Re: [WEB400] Zend and V7R1

Sean,

Could be a permissions issue with the user profile you are using. See this forum posting:

http://forums.zend.com/viewtopic.php?f=77&t=8819

I'll jump right to the punch line:

"/etc/zce.rc is a symbolic link to /usr/local/zendsvr/etc/zce.rc.

Therefore, you must set permissions on the /usr/local/zendsvr/etc folder as well."

Alan

On 10/26/12 1:08 PM, Porterfield, Sean wrote:

/usr/local/zendsvr/bin/php-cli myscript.php

/etc/zce.rc doesn't exist!

--

Sean Porterfield

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.