| Author |
Apache, MySQL, and PHP |
Altivo
Member
Posts: 86
Location: Illinois
Joined: 26.05.07 |
| Posted on April 07 2009 07:52 |
|
|
If a Linux system with these three applications linked is called a "LAMP" server, does that mean that a VMS system with the same three pieces is a "VAMP" server?
Seriously, I'm trying to get this going. I downloaded the CSWS package from the HP web site and installed it on an Alpha running OpenVMS 8.3. It's working well.
Added PHP and the PHP-MySQL modules, also from HP's web site, and then installed MYSQL from the latest VMS Freeware CD images (V8 of the CD, 4.1.14 of MYSQL.)
MySQL is working, accepting connections both locally and from other machines as I've defined them.
PHP works with Apache as pure PHP. However, it doesn't quite seem to work with MySQL. The mysql_connect() function produces this error message:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /apache$specific/htdocs/test2.php on line 3
The actual text in test2.php reads:
$conn = mysql_connect( "localhost", "username", "password" );
(Substituting, of course, a valid user name and password combination that works just fine with the mysql command line client.)
I'm guessing that MySQL wants encrypted passwords and PHP doesn't want to encrypt them or else is using the wrong encryption method. But I can't seem to find anything in either configuration to let me fix this. I don't particularly need any encryption, but as long as it works, I don't care which way it gets resolved. Anyone have an idea?
--Gary
Edited by Altivo on April 07 2009 07:55 |
 |
| Author |
RE: Apache, MySQL, and PHP |
martinv2
Member
Posts: 107
Location: Goslar, Germany
Joined: 02.10.07 |
| Posted on April 07 2009 17:55 |
|
|
Gary,
the PHP_MYSQL.EXE extension of CSWS_PHP v1.3 was linked against a MySQL v3 library. You'll have to set a v3 password for the user in MySQL using
mysql> use mysql;
mysql> update User
set Password = old_password('password')
where User = 'username';
mysql> flush privileges;
or build yourself an updated PHP_MYSQL.EXE, linked against a more recent MySQL library - see this discussion. I have put up an an updated PHP_MYSQL.EXE for download (built under OpenVMS Alpha V7.3-2 for CSWS 2.1-1 and MySQL 5.1-23.1).
And BTW, there's a port of MySQL v5.1 available at www.vmsmysql.org.
HTH,
Martin
P.S.: Of course, VAMP is the correct designation for such a system ;-)
http://de.openvms.org/martinv/
Edited by martinv2 on April 07 2009 20:48 |
|
|
| Author |
RE: Apache, MySQL, and PHP |
Altivo
Member
Posts: 86
Location: Illinois
Joined: 26.05.07 |
| Posted on April 08 2009 00:39 |
|
|
Thanks very much, Martin. Your quick fix of the password made things work with what I have installed now on my test system. That lets me proceed with my experiments now. I can just keep a special user defined with the old style password for use in PHP operations for now.
Once some added disk drives arrive for my DS10, I plan to build a new "production" VMS over there and will assemble the newer versions of the software that you point out. Is there a downloadable VMS distribution for Apache 2.1 or do I have to build that? (Ugh, I'd rather not.)
--Gary |
|
|
| Author |
RE: Apache, MySQL, and PHP |
martinv2
Member
Posts: 107
Location: Goslar, Germany
Joined: 02.10.07 |
| Posted on April 08 2009 03:14 |
|
|
|
Once some added disk drives arrive for my DS10, I plan to build a new "production" VMS over there and will assemble the newer versions of the software that you point out. Is there a downloadable VMS distribution for Apache 2.1 or do I have to build that? (Ugh, I'd rather not.)
And I wrote:
I have put up an an updated PHP_MYSQL.EXE for download (built under OpenVMS Alpha V7.3-2 for CSWS 2.1-1 and MySQL 5.1-23.1).
So, either you build your own, or you update your MySQL to v5 and can use my pre-built PHP_MYSQL.EXE (hint: the text "updated PHP_MYSQL.EXE" is a link).
In the latter case, the image has to go to APACHE$COMMON:[PHP.EXTENSIONS]
cu,
Martin
http://de.openvms.org/martinv/ |
|
|
| Author |
RE: Apache, MySQL, and PHP |
Altivo
Member
Posts: 86
Location: Illinois
Joined: 26.05.07 |
| Posted on April 08 2009 05:05 |
|
|
Got it, thanks. For whatever reason, links on this forum appear on my screen as dark grey, not underlined, and so close to the normal text that they aren't always obvious. I assume it's a style sheet choice or something, but not one I would have picked.
I will get the PHP 5 and your interface kit for my new installation then. The drives are arriving on Monday according to UPS. |
|
|
| Author |
RE: Apache, MySQL, and PHP |
Altivo
Member
Posts: 86
Location: Illinois
Joined: 26.05.07 |
| Posted on April 11 2009 10:30 |
|
|
Almost, but still not there.
I uninstalled MySQL 4.1 and installed MySQL 5.1.23. Added back my users and fixed all the startup files to start the correct version and define all the right logicals and symbols. It appears to be working.
Then I renamed APACHE$ROOT:[PHP.EXTENSIONS]PHP_MYSQL.EXE to PHP_MYSQL-V3.EXE
and copied the downloaded PHP_MYSQL.EXE to APACHE$ROOT:[PHP.EXTENSIONS]
Stopped Apache and restarted it. It crashes on
%SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual address=000000000000
0000, PC=FFFFFFFF8090F6C4, PS=0000001B
%TRACE-F-TRACEBACK, symbolic stack dump follows
image module routine line rel PC abs PC
LIBOTS 0 00000000000216C4 FFFFFFFF8090F6C4
PHPSHR 0 000000000017DCB8 FFFFFFFF8090F6C4
PHPSHR 0 000000000015DD84 0000000000B7FD84
PHP_MYSQL 0 00000000000A0564 0000000000FFA564
PHPSHR 0 00000000000EAE9C 0000000000B0CE9C
PHPSHR 0 000000000013769C 0000000000B5969C
PHPSHR 0 00000000001920B4 0000000000BB40B4
PHPSHR 0 0000000000137E0C 0000000000B59E0C
PHPSHR 0 0000000000141574 0000000000B63574
MOD_PHP_APACHE-2_0 0 0000000000030A0C 0000000000A00A0C
MOD_PHP_APACHE-2_0 0 0000000000030C14 0000000000A00C14
APACHE$HTTPD_SHR 0 0000000000045408 000000000027F408
APACHE$HTTPD 0 0000000000021024 0000000000021024
APACHE$HTTPD 0 000000000002006C 000000000002006C
0 FFFFFFFF80377CE4 FFFFFFFF80377CE4
%TRACE-I-END, end of TRACE stack dump
Swapped back the two versions of PHP_MYSQL.EXE and restarted Apache and it runs, but of course still has the password problem that it had before. Evidently I've done something wrong, but I'm not sure what. |
|
|
| Author |
RE: Apache, MySQL, and PHP |
martinv2
Member
Posts: 107
Location: Goslar, Germany
Joined: 02.10.07 |
| Posted on April 12 2009 00:05 |
|
|
Gary,
I have to get back to work to check things (on tuesday, probably).
Until then, I'll describe my environment (from memory):
VMS 7.3-2 with some VMS732_UPDATE installed
CSWS 2.1-1 Update 2
CSWS_PHP 1.3 Update 2
Do you run the same releases?
cu,
Martin
http://de.openvms.org/martinv/ |
|
|
| Author |
RE: Apache, MySQL, and PHP |
Altivo
Member
Posts: 86
Location: Illinois
Joined: 26.05.07 |
| Posted on April 12 2009 05:42 |
|
|
I have the same CSWS releases, but my VMS is 8.3. I suppose that may be the problem.
The really odd thing is that with the newer MYSQL051 installation, the 'old-password' trick doesn't work any more. It does set the same hex code into the password field as it did in 4.1.x, but that no longer works to get the connection to go through, even though the rest of the configuration remains the same.
--Gary |
|
|
| Author |
RE: Apache, MySQL, and PHP |
Altivo
Member
Posts: 86
Location: Illinois
Joined: 26.05.07 |
| Posted on April 12 2009 15:22 |
|
|
Scratch that last remark. It really wasn't working, and I don't know why. Today I deleted the user and added it back, with the same password that looks the same after it's encrypted. Only now it works again. So I'm still functional, but running on the old style password. Coming in from a Linux host with a newer PHP version, I can connect with the new style password encryption. So it's a fairly minor issue at this point.
I wonder if anyone is working on porting PHP 5 with its object oriented structures. |
|
|
| Author |
RE: Apache, MySQL, and PHP |
martinv2
Member
Posts: 107
Location: Goslar, Germany
Joined: 02.10.07 |
| Posted on April 12 2009 15:52 |
|
|
|
I wonder if anyone is working on porting PHP 5 with its object oriented structures.
There's rumor it's being worked on - see this discussion. But I haven't seen an official statement yet.
cu,
Martin
http://de.openvms.org/martinv/ |
|
|
| Author |
RE: Apache, MySQL, and PHP |
martinv2
Member
Posts: 107
Location: Goslar, Germany
Joined: 02.10.07 |
| Posted on April 15 2009 20:19 |
|
|
|
%SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual address=0000000000000000, PC=FFFFFFFF8090F6C4, PS=0000001B
Frankly said, I have no idea what's happening here.
Starting from the PHP_MYSQL line in the stack dump (rel PC A0564) and using the map file, I find
Psect Name Module Name Base End Length Align Attributes
---------- ----------- ---- --- ------ ----- ----------
$CODE$ 000A0000 001E5D8B 00145D8C ( 1334668.) OCTA 4 PIC,CON,REL,LCL, SHR, EXE,NOWRT,NOVEC, MOD
PHP_MYSQL 000A0000 000AB1E3 0000B1E4 ( 45540.) OCTA 4
i.e. the error occurs at offset 564 into the module. The listing file gives
A602EF40 0564 LDQ R16, -4288(R2) ; 036278
which points to source line 36278:
36270 ZEND_MODULE_STARTUP_D(mysql)
E int zm_startup_mysql(int type, int module_number)
1 36271 {
...
1 36278 Z_TYPE(mysql_module_entry) = type;
E (mysql_module_entry).type
...
And that's where I am at my wit's end - how could that instruction possibly call back into the PHPSHR image?
(mysql_module_entry is a structure local to PHP_MYSQL that contains all of the information PHP needs to call into the module.)
Seems you'd have to follow the re-build path - don't worry, it's not that hard if you follow the instructions I've given.
Sorry,
Martin
http://de.openvms.org/martinv/ |
|
|
| Author |
RE: Apache, MySQL, and PHP |
Altivo
Member
Posts: 86
Location: Illinois
Joined: 26.05.07 |
| Posted on April 16 2009 00:30 |
|
|
|
Thanks for trying to figure it out. I'll try your instructions for building the module as soon as I can. |
|
|
| Author |
RE: Apache, MySQL, and PHP |
operagost
Member
Posts: 4
Joined: 14.01.08 |
| Posted on August 05 2009 08:23 |
|
|
PHP 5.2.6 has been ported:
http://h71000.www7.hp.com/openvms/products/ips/apache/csws_php.html?jumpid=/products/openvms/php |
|
|
| Author |
RE: Apache, MySQL, and PHP |
martinv2
Member
Posts: 107
Location: Goslar, Germany
Joined: 02.10.07 |
| Posted on August 10 2009 02:57 |
|
|
|
PHP 5.2.6 has been ported
...and a new version of the PHP kit also comes with the sources!
But they don't seem to necessary (in the context of this thread) - I haven't time to test it yet, but I've read that it supports MySQL 5.1 out of the box.
cu,
Martin
http://de.openvms.org/martinv/ |
|
|
