30-jun-2010

PhpMyAdmin
I downloaded the latest version (3.3.4) and installed it on Daphne, to test it with the new PHP installation.
That, by itself, was a challenge.
First, I tried the .ZIP file. but no: There are issues with files with multiple dots – and directory-names with dots in them. Unzip – as far as I knew – translated all but the last dots into underscores – and that’s not what I want. So I got the .tar.gz file – and had to get gzip and vmstar, and build them. For VMSTar, it meant re-compilation as well, since required objectfiles were missing. So C had to be installed – and the license loaded. But even that wasn’t sufficient, I also needed MMS to be installed, for a proper build….
Finally, I got both and could now work on the compressed tarball. decormpressing worked fne, but for some reason, VMSTAR choked on a CRC error in a directory and stopped.
Exit .tar.gz.
Got myself the latest version of UNZIP, hoping it would get over the problems with it’s predecessor, But it simply down’t work: not only were multiple dots – again – translated into undersores, the files were always stored in upercase – even when the “-LL” option was specified. Even the -a option doesn’t work…
Set proces-environment into extended parse-style – that might have been the problem, but not even that did work.
Exit UNZIP60, and back to the old one. Which now, all of a sudden did actually work: I got a directory name full of dots where expected, and files stored in their original (lowercase) names.

so fa, so good.
Next, add the location and handling in the mapping-file, using the PHP-INFO one as a starting point.
That didn’t wo the trick, and it required quite some fiddling with config itens and logicals to get at least some result (here, WASD’s real-time logging facilities are proiceless!): Defined “DBA” to be the right location, and use it in the configuration:

set /dba/**.php* script=query=relaxed
set /dba/**.php script=query=relaxed ods=5
exec /dba/**.php ($cgi-bin:[000000]phpwasd.exe)/dba/* script=query=relaxed
pass /dba/* /dba/*

or use the plain definotion instead of the logical:

exec /dba/**.php ($cgi-bin:[000000]phpwasd.exe)/dka0/web/dba/* script=query=relaxed
pass /dba/* /dka0/web/dba/*

But the scripts ends within index.php, where files need to be located:

PHP Warning: require_once(./libraries/common.inc.php) [function.require-once]: failed to open stream: no such file or directory in /dka0/web/dba/DKA0:[web.dba]index.php on line 35

Pasrse-style (should be EXTENDED since it’s an ODS-5 disk) and default directory (should be DKA0:[WEB.DBA]) are correct accoring the WASD WATCH output:

|08:13:20.12 DCL 4856 0001 DCL WRITE SYS$COMMAND 26|SET PROCESS/PARSE=EXTENDED
|08:13:20.12 DCL 4856 0001 DCL WRITE SYS$COMMAND 51|IF F$TRNLNM("HTTPD$LOGIN").NES."" THEN @HTTPD$LOGIN
|08:13:20.12 DCL 4856 0001 DCL WRITE SYS$COMMAND 49|IF F$TRNLNM("WASD_LOGIN").NES."" THEN @WASD_LOGIN
|08:13:20.12 DCL 4856 0001 DCL WRITE SYS$COMMAND 26|SET DEFAULT DKA0:[web.dba]
|08:13:20.12 DCL 4856 0001 DCL WRITE SYS$COMMAND 31|RUN cgi-bin:[000000]phpwasd.exe
|08:13:20.12 DCL 4856 0001 DCL WRITE SYS$COMMAND 9|STOP/ID=0
|08:13:20.12 DCL 4842 0001 DCL WRITE SYS$COMMAND EOF|

so now I’m stuck – there might be something within PHP? Because the same applies when the same file is run using PHP.

A second ‘flaw’ I found: running PHPWASD.EXE sometimes failes for uncertain reasons.
the setting for PHP_INFO specifies “@cgi-bin:phpwasd.exe” in the EXEC statement, and it always works. With PHPMyADMIN, however, it _may_ work (I do have a logfile that shows just that) but for some reason, it may result in a load of warnings:

%DCL-W-IVVERB, unrecognized command verb - check validity and spelling

as if the executable is interpreted as a commandprocedure – consistent with the “@” character. Removing it, or replacing it by “$” causes the same error as before. The main configurations states “$” for an executable, so my guess is that that’s actually right (PHP_INFO works with “$”, I’ve checked that.
So these quetsions are moved to the WASD mailing list – see what comes out of this.

WordPress
Again, I obtained the lastest version (3.0), immediately after I downloaded PHPMyAdmin. First the .tar.gz version because of the (expeted) problems with UNZIP. But knowing the problems I had with installing PHPMYADMIN, I used the ZIP version – and it installed nicely.
Using the same construct as for PHPMYADMIN, and adapting protection of all files, this turned out to be far easier. However, it relies on the MySQL extension, which I didn’t enable (since I expected MySQLi to be more feasable). So I enabled it in PHP.INI, but found out I had to rerun PHP_STARTUP to get it available. After that, I got thhe message I lacked a config file. Duh – I didn’t do anything here! So I created one, referring to Diana for a database. But connection failed – I needed to create one first. Now, index.php redirects to installation.php – and there it all ends – no warning, just an empty page. This rings a bell: there seems to be a redirectrion and this may not be handled by WASD.
Even using the configuration as on Diana, it doens’t do anything.

Another way to get around it is to install MySQL and use a local database. That might be the next thing to do.