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