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



Ah, that's why it sounds familiar! So MySQL is not broken; I can access it with a password on the command line as you show.

I put the password in the file (temporarily), and it worked. That means it's not broken!

Now if there were such an easy fix for mssql....
--
Sean Porterfield


-----Original Message-----
From: Mike Pavlak
Sent: Tuesday, October 30, 2012 11:18
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Zend and V7R1

Hi Sean,

The vanilla script has no password as it is designed for demo only. If you set a password for root, then you would need to add it. Better yet, change the credential to something you know works and has access to the MySQL db.

When using the `/usr/local/mysql/bin/mysql -u root -p` syntax I find this works best:

mysql -u mpavlak --password='yourPassword'

Regards,

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


-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Porterfield, Sean
Sent: Tuesday, October 30, 2012 8:12 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Zend and V7R1

Gee, thanks, Mike - now I learned MySQL is broken too! My question below was about mssql connections failing. I don't see any real data in /usr/local/mysql/data/ - I just have mysql and test databases.

The mysql script you mention returns: Access denied for user 'root'@'localhost' (using password: NO)

That sounds so familiar... Oddly, I get the same error from `/usr/local/mysql/bin/mysql -u root -p` which should prompt for a password.

I'll look into hotfixes. I thought downloading the latest and greatest version would include everything.
--
Sean Porterfield


-----Original Message-----
From: Mike Pavlak
Sent: Monday, October 29, 2012 17:58
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Zend and V7R1

Hey Sean,

I don't mean to but in but maybe a couple of low hanging pieces of fruit.

1) Does the demo script work that comes with Zend Server? Works on mine. http://192.168.15.112:10088/Samples/MYSQL_access/mysql_access_example.php
2) Do you have the Hot fixes applied? There are 4 and one includes updates to PHP. Not sure if there is anything in there about MySQL, but you never know.
3) Is the MySQL extension enabled in the Zend Server admin interface? Server setup->Extensions->mysql
4) I'd assume MySQL is running and that you are using the same credentials since the app is working in Core.
5) If you are making any changes to my.cnf, please make them under the /usr/local/mysql/bin and there is more detail at http://forums.zend.com/viewtopic.php?f=64&t=3924

Hope this helps!!!

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


-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Porterfield, Sean
Sent: Monday, October 29, 2012 4:16 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Zend and V7R1

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.

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.