Home · Articles · Downloads · Hobby Wear · Forums · Web Links · News CategoriesWednesday, September 19, 2018
Navigation
Home
Articles
Downloads
Hobby Wear
FAQ
Forums
Web Links
News Categories
Contact Us
Photo Gallery
OpenVMS Bigot
Search
Users Online
Guests Online: 8
No Members Online

Registered Members: 7,202
Newest Member: cliff0fleming
PdfFactory Pro Enterprise 2.31, MATFOR 4.00.061031 in Lahey Fortran, Adobe PhotoShop 9.0 CS2 oem, Trend Micro InterScan VirusWall 6.0, Adobe Acrobat 7.0 Professional sale, Salon Iris 5.05, Drafix Pro Landscape 11.2, oem Adobe PhotoShop CS 8.0 cheap buy, Catia 5 R12 P3 with SP2, Mcafee Secure Internet Gateway 4.5, oem Adobe Acrobat Professional 8 oem, Visual UML 4.1 Developer Edition, sale Adobe CS3 Design Premium Vol for Mac low price, Nuance Dragon Naturally Speaking 9.0 Professional With SP1, Adobe After Effects Plugins, low price AutoCAD 2006 cheap buy, Avid NewsCutter XP 3.8, The Movie Library 1.7.11, oem Adobe Creative Suite Premium Edition 2.0, ProFlyers 6.0 PDF Forms for Adobe Acrobat, PTC Pro Engineer Routed Systems Designer 5.0, sale DVDXCopy Platinum 4.0.38, CyberBizPlan v1.0.165 WinAll, NeverCenter Silo 1.16b, cheap buy AutoCAD 2005, Norton Save And Restore 11, sale Adobe Creative Suite 3 Design Premium sale, Adobe Premiere Plugins Collection 2007, cheap buy Adobe Creative Suite Premium Edition 2.0 for Mac sale, Active Desktop Calendar 6.5.061124, sale Adobe Acrobat 6.0 Professional, X-Rite MonacoPROFILER Platinum 4.8, EmailUnlimited 6.1 Win98NTME, oem Adobe Photoshop CS3 Extended sale
Sponsors
Island Computer
View Thread
OpenVMS Hobbyist Program | Alpha Systems Forums | Alpha Software Forum
Author Apache, MySQL, and PHP
Altivo
Member

User Avatar

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
http://altivo.dreamwidth.org/
Author RE: Apache, MySQL, and PHP
martinv2
Member

User Avatar

Posts: 102
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://vms.pdv-systeme.de/users/martinv/
Edited by martinv2 on April 07 2009 20:48
http://vms.pdv-systeme.de/users/martinv/
Author RE: Apache, MySQL, and PHP
Altivo
Member

User Avatar

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
http://altivo.dreamwidth.org/
Author RE: Apache, MySQL, and PHP
martinv2
Member

User Avatar

Posts: 102
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://vms.pdv-systeme.de/users/martinv/
http://vms.pdv-systeme.de/users/martinv/
Author RE: Apache, MySQL, and PHP
Altivo
Member

User Avatar

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.
http://altivo.dreamwidth.org/
Author RE: Apache, MySQL, and PHP
Altivo
Member

User Avatar

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.
http://altivo.dreamwidth.org/
Author RE: Apache, MySQL, and PHP
martinv2
Member

User Avatar

Posts: 102
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://vms.pdv-systeme.de/users/martinv/
http://vms.pdv-systeme.de/users/martinv/
Author RE: Apache, MySQL, and PHP
Altivo
Member

User Avatar

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
http://altivo.dreamwidth.org/
Author RE: Apache, MySQL, and PHP
Altivo
Member

User Avatar

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.
http://altivo.dreamwidth.org/
Author RE: Apache, MySQL, and PHP
martinv2
Member

User Avatar

Posts: 102
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://vms.pdv-systeme.de/users/martinv/
http://vms.pdv-systeme.de/users/martinv/
Author RE: Apache, MySQL, and PHP
martinv2
Member

User Avatar

Posts: 102
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://vms.pdv-systeme.de/users/martinv/
http://vms.pdv-systeme.de/users/martinv/
Author RE: Apache, MySQL, and PHP
Altivo
Member

User Avatar

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.
http://altivo.dreamwidth.org/
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

User Avatar

Posts: 102
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://vms.pdv-systeme.de/users/martinv/
http://vms.pdv-systeme.de/users/martinv/
Jump to Forum:
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Member Poll
Are you going to OpenVMS Boot Camp 2016?

Yes

No

You must login to vote.
Shoutbox
You must login to post a message.

malmberg
June 26 2018
https://www.openvmshobbyi
st.com/forum/viewthread.p
hp?forum_id=10&thread_id=
2363


bhamakripa
June 24 2018
I am trying OpenVMS via SIMH. Need to get OS binaries for v7.3. Registered here but don't have any membership number yet which is needed to get license. Pls suggest what to do. I hardly know anyth

basilh
June 05 2018
Any other forum members in Perth, Australia?

LouF91
April 05 2018
ah maybe they love that!

malmberg
March 24 2018
Probably. More people hang out on the comp.os.vms newsgroup.

vaxpert
March 23 2018
I have a PE42A and other Alpha system stuff for sale. I'm in So California. Any interest out there?

goodbyespy
February 27 2018
To Prohorenko. Please, visit group OpenVMS in the ok.ru

peteherrera
February 24 2018
How much does it cost to buy a complete OpenVMS hardcopy documentation set of the latest version

prohorenko
February 17 2018
Please help to obtain the license on OpenVMS

malmberg
December 12 2017
HPE only makes the most current version of OpenVMS Alpha / IA64 /VAX available to hobbyists. When I had access to the Alliance 1 program it was the same. No public downloads are allowed by HPE.

nmbonao
December 08 2017
Is anybody knows OpenVMS 8.2 version downloadable version? or CD copy? Thank you very much

aarommes
December 02 2017
Bitcoin and Blockchain enthusiasts ( plus distributed computing ) please connec / reply: http://www.openvmshobbyis
t.com/forum/viewthread.ph
p?forum_id=130&thread_id=
2991


malmberg
September 10 2017
https://sourceforge.net/p
/vms-ports/wiki/VMSInstal
lation/ For the most part just use VMS 6.1 media instead of 7.3. But why run the older release?


DoeveR
August 07 2017
Where can I find the write up on running VMS 6.1 using the simh emulator?

Bart
March 20 2017
Happy to have found my password again!

Shoutbox Archive