Cleaned up a bit too much
Startup yesterday turned out to be incomplete: the database didn’t start – so the blogs were not accessible. But why?
Checking startup log of MariaDB stated:
%DCL-E-NOCMDPROC, error opening captive command procedure - access denied
This is weird, so I checked the command procedure, but there was nothing special to be noted.
But it was clear it had to do with the login procedure of user that runs the databaseserver: MYSQL051_SRV. So it may have been the path to the login procedure of this user, according SYSUAF:
Username: MYSQL051_SRV Owner:
Account: MYSQL051 UIC: [37775,1] ([MYSQL051,MYSQL051_SRV])
CLI: DCL Tables: DCLTABLES
Default: MYSQL051_ROOT:[MYSQL_SERVER]
LGICMD: MYSQL051_ROOT:[VMS.MYSQL]LOGIN_SERVER.COM
but I did some cleaning on this user: Removed all I think was obsolete. What was left was $116$dka100:[web.mysql.mysql051] – that is wat MYSQL051_ROOT refers to. But all beyond was gone. Since the only thing that I needed was MYSQL051_ROOT:[VMS.MYSQL]LOGIN_SERVER.COM, it was sufficient to recreate that directory and command procedure (a copy of MYSQL055_SRV’s LOGIN.COM file) to get the database server running again.
but still the blogs didn’t start; even worse, connectivity to any webservice was interrupted time after time again: At times I could get in, but getting deeper into the same site failed – No connection could be made: Site was not reachable. looked at access log, there was a constant flow of calls to HyperRead – more precise: “/HyperReader/download/FREEWAREV40/BLISS/4359PRO.DECW$BOOK” with a lot of extra’s; Well, FREEWAREV40 had already been blocked, so all these give status 404, but also, a lot of calls to other freeware locations.
So I disabled all HELP content in the ‘open’ site – including Hyperread.
Now the site signals Server error (500) on hyperread calls – due to a loop somewhere: Access log now shows: “/HyperReader/HyperReader/HyperReader/HyperReader/HyperReader/HyperReader/HyperReader/download/FREEWAREV40/BLISS/4359PRO.DECW$BOOK…”. If this is inside the server (likely, otherwise I wouldn’t get the 500 error) it might be better to handle this in the configuration (return some error).
Anyway: it caused the server to be far more responsive.
But still the blogs didn’t work. Looking on what is started, I noted PHP 7.2 has been activated – I forgot to reverse the change in startup to use an older version. I got “Nonconformant response” – meaning the application gave some error, the server signalled something unexpected, according WATCH output: it could not locate a file: got the system status FNF (File Not Found). However, SYSBLOG is defined and its content present, as is TRACKS. But checking the logicals, I noted both reference the older 4.9.8 version of WordPress, where only the new one (5.2.2) was defined. Therefore, the server could not locate the base code of WordPress – causing Fine_Not_Found. After I added the right logical, this problem too was solved.
I keep PHP 7.2 running for now. It no problems occur, I’ll disable older versions.
Update on server mapping
HyperReader (and all help) has been disabled on the site (I still can use it via another) but is still an issue with this: WASD will continue processing the request until it had enough.
There might be an issue with PHP7.2 as well, since adding this update, I couldn’t since the UPDATE button was disabled, reloading the page failed again, I had to clear the cache before I got the page (and revisions) back and could update the post
Update2 on server mapping
Having asked Mark on the issue, I have now changed the mapping so access to HyperReader is now blocked completely (you get a 403 error) except when requested from my own IP address – so I can use it at my workstation). If needed this can be extended with whatever I deem necessary. Simply a matter of adapting one configuration file and reload the mapping.
It is now a matter of checking regularly whether this solves the connection – and perhaps performance – issues. Sometimes, PHPWASD returns status 000, and ik looks like this happens if the RTE is still in memory and waiting for requests. Once it returns this status, it will keep doing so: therefore this happens so fast: Nothing is done. One the RTE’s are stopped or the server is restarted, all is well – for the time being.
Another (minor) issue
The Trips, Travels and Travels blog didn’t show either, again due it’s definition that refers to WP5.2.2: No page, just empty header and body – no content between the tags. So reversed that to 4.9.8 and the pages show up.
So WordPress 5.2.2 is no doubt something to dig deeper into.