26-Mar-2007

Yet another update
of Soymail. Minor issues, and no problems – as usual.
Downloaded Clamev anti-virus – to prevent problems on the PC’s, not for the VMS box, of course, and taking a look at SpamAssassin, once again. See if we can get that instaleld and running, though both take resources, but I expect I have enough resources left to have these two running. At least, give it a try.

23-Mar-2007

Update 2 and some more
I just installed the latest UPDATE to the system and some patches that were released after that. Smoothless, as usual. It seems everything has come up as it should. I would like to know if shutting down has woked as expected – that is: the MySQL database should have been closed properly but shutdown doesn’t log like startup so the only way to tel is to examine the startup log – but it looks as if shutdown did not happen. Anyway, it does work.
Web redesign
is on the way, but it will take some time before the results are shown.

19-Mar-2007

Updates
I took some time to install two deferred updates: my mailclient (Soymail, to version 1.3.0) and the WASD PHP engine (to version 1.3.4).
The first was no problem at all, once I got all old files removed from the wrong locations (cgi-bin happens to be a searchlist refrerring to cgi-bin and axp-bin directories, in that order. The installation scripts will copy files explicitly to the[axp-bin] directory. No problem – unless there is a [cgi-bin]SOYMAIL.EXE, as on Diana. Once that file was removed, it workes fine.
The second meant a big deal of extra work. The CSWS MOD_PHP sources are required for that so I had to download the CSWS sourcecode – one big ZIP file containing a number of backup savesets of whicht MOD_PHP is one. That one needs to be installed, and referred to in calling the installation procedure. Now PHPWASD could be installed. All seemed well, the major applications (blog and forums) were Ok but PHPINFO.PHP revealed no data at all, and PHPMyAdmin fails to start, because it could not locate ‘./libaries/common.php.inc’. Funny, since the file does exist and has the right protection…
WATCH didn’t show a problem either, but in the configuration I found two lines missing that were present for both blog and forum software. After I added these lines, PhpMyAdmin was no problem either. But PHPINFO.PHP kept an empty screen, just header and en empty body…That needs to be investigated, it might be I disabled it to run on the external address 😉
E107
known to crash the PHP process, missed these two lines as well, so I added them there also, but that did not chage the behaviour. But after I deleted the existing database and re-enabled installation, creation of the database went ok, but after that, there was, once more, the crash in PHPWASD.EXE – when calling php_execute_script. This is a normal path, that is taken by any of the other PHP processes, so it must be something within either the code, or within the database.
I started drilling down where it might be….

16-Mar-2007

MySQL Database backup now Ok
that is: no more endings in error.
Nasty part is that is there is something wrong in MySql – or better: MySqlAdmin actually dumping the dataabse – this is not signalled to DCL and status will be odd. The procedure weill therefore not signal the porblem and finish successfully – though there has been an error!
WordPress – does DATE matter?
had wrong behaviour when entering the previous entry: the overview that should contain the last 15 posts, showed just the one just entered, and when asking to show all of this month, there was an error signalled, and after that this same entry. Nothing more, although all posts could be located in the database. Requesting the posts of February, there was nothing wrong, they showed up without error and missing entries.
Today, the problem does not occur.

14-Mar-2007

Reason of yesterday’s hang
is obvious.
Cheching the system’s performance of yesterday using Hyperspy, showed memory was fully saturated – that is: completely used up”, all of it, including the pagefiles.
So I turned to ANA/CRASH to look to memory:

SDA> SHO MEM/FILES

System Memory Resources from Crashdump on 13-MAR-2007 19:09:26.90
—————————————————————–

Swap File Usage (8KB pages): Index Free Size
$116$DKA100:[SYS0.SYSEXE]SWAPFILE.SYS
1 56 1976

Paging File Usage (8KB pages): Index Free Size
$1$DKA0:[local]PAGEFILE1.SYS;2
252 0 11088
$1$DKA0:[local]PAGEFILE.SYS;2
253 0 11088
$116$DKA100:[SYS0.SYSEXE]PAGEFILE.SYS
254 0 11088

Total size of all paging files: 33264
Total committed paging file usage: 57688

The system is thrashing: no more pagefile space available at all, ans too little swapfile space.
Where this comes from – I’ll need to install an SDA extension – last year I asked Ian Miller for this..
Running that extension (pf$sda) against all pagefiles, and after some editing to clear things up (remove the lines for processes that were swapped out), I got:
$ type memory.out

PF V1.1-1 (c) 2006, Ian Miller (miller@xxxxx) built on VMS V8.3
%PF-I-INFO, File index 254
Device: $116$DKA100 (default filespec SYS$SYSROOT:[SYSEXE]PAGEFILE.SYS)
Pagefile flags: INITED
Total size (in pages) 11088 Pages in use 11088
Free Pages 0 Minimum free pages 0
Total write count 2561 Total read count 4013
%PF-I-LOOKING, Searching for proceses using this file
PID 20200108 CONFIGURE has 35 pagefile refs
PID 20200109 LANACP has 84 pagefile refs
PID 2020010B IPCACP has 34 pagefile refs
ERRFMT not dumped
CACHE_SERVER not dumped
OPCOM not dumped
PID 2020010F AUDIT_SERVER has 104 pagefile refs
JOB_CONTROL not dumped
QUEUE_MANAGER not dumped
PID 20200113 SECURITY_SERVER has 345 pagefile refs
PID 20200114 ACME_SERVER has 321 pagefile refs
PID 20200117 DNS$ADVER has 274 pagefile refs
NET$ACP not dumped
REMACP not dumped
NET$EVD not dumped
DTSS$SERVICE not dumped
SMISERVER not dumped
PID 2020011E TP_SERVER has 65 pagefile refs
SMTP_DIANA_01 not dumped
PID 20200129 DECW$SERVER_0 has 1293 pagefile refs
PID 20200132 TCPIP$INETACP has 200 pagefile refs
PID 20200333 TCPIP$BIND_1 has 854 pagefile refs
TCPIP$PORTM_1 not dumped
TCPIP$DHCP_1 not dumped
TCPIP$FTP_1 not dumped
PID 20200138 TCPIP$IMAP_1 has 392 pagefile refs
PID 20200139 TCPIP$NTP_1 has 292 pagefile refs
TCPIP$POP_1 not dumped
PID 2020013B TCPIP$PWIP_ACP has 155 pagefile refs
TCPIP$NTP_4646 not dumped
TCPIP$XDM_1 not dumped
DTLOGIN not dumped
DTGREET not dumped
PID 20200146 HTTPd:80 has 4276 pagefile refs
PID 20200147 HyperSPI++ has 137 pagefile refs
DBL$MSGMGR not dumped
PID 2020014A MYSQL_SERVER has 10716 pagefile refs
PID 2020014B SYMBIONT_2 has 206 pagefile refs
HTTPd:80-25 not dumped
PID 202040D7 HTTPd:80-26 has 2971 pagefile refs
HTTPd:80-27 not dumped
HTTPd:80-28 not dumped
PID 202040DA HTTPd:80-29 has 2972 pagefile refs
HTTPd:80-30 not dumped
HTTPd:80-31 not dumped
HTTPd:80-32 not dumped
PID 202040DE HTTPd:80-33 has 2950 pagefile refs
HTTPd:80-34 not dumped
PID 202040E0 HTTPd:80-35 has 2127 pagefile refs
PID 202040E1 HTTPd:80-36 has 2206 pagefile refs
PID 202040E2 HTTPd:80-37 has 1429 pagefile refs
PID 202040E3 HTTPd:80-38 has 1511 pagefile refs
PID 202040E4 HTTPd:80-39 has 1486 pagefile refs
HTTPd:80-40 not dumped
HTTPd:80-41 not dumped
HTTPd:80-42 not dumped
%PF-I-USERS, 26 processes found to be using this file
%PF-I-PFREFS, Total page file references 37435
%PF-I-TOTALSWAP, Total Size of all Swap Files 1976 pages
%PF-I-TOTALPAGE, Total Size of all Page Files 33264 pages
%PF-I-TOTALREFS, Total Committed Page File Usage 57688 pages
%PF-I-TOTALALLO, Total Allocated Page File 33264 pages
%PF-I-PINUSE, 100.00% pagefile is in use
%SYSTEM-W-PAGEFRAG, page file filling up
%SYSTEM-W-PAGECRIT, page file nearly full

PF V1.1-1 (c) 2006, Ian Miller (miller@xxxxx) built on VMS V8.3
%PF-I-INFO, File index 253
ALPHASYS:[local]PAGEFILE.SYS;2
Pagefile flags: INITED
Total size (in pages) 11088 Pages in use 11088
Free Pages 0 Minimum free pages 0
Total write count 2540 Total read count 3527
%PF-I-LOOKING, Searching for proceses using this file
PID 20200109 LANACP has 84 pagefile refs
PID 2020010B IPCACP has 34 pagefile refs
ERRFMT not dumped
CACHE_SERVER not dumped
OPCOM not dumped
PID 2020010F AUDIT_SERVER has 104 pagefile refs
JOB_CONTROL not dumped
QUEUE_MANAGER not dumped
PID 20200113 SECURITY_SERVER has 345 pagefile refs
PID 20200114 ACME_SERVER has 321 pagefile refs
PID 20200117 DNS$ADVER has 274 pagefile refs
NET$ACP not dumped
REMACP not dumped
NET$EVD not dumped
DTSS$SERVICE not dumped
SMISERVER not dumped
PID 2020011E TP_SERVER has 65 pagefile refs
SMTP_DIANA_01 not dumped
PID 20200129 DECW$SERVER_0 has 1293 pagefile refs
PID 20200132 TCPIP$INETACP has 200 pagefile refs
PID 20200333 TCPIP$BIND_1 has 854 pagefile refs
TCPIP$PORTM_1 not dumped
TCPIP$DHCP_1 not dumped
TCPIP$FTP_1 not dumped
PID 20200138 TCPIP$IMAP_1 has 392 pagefile refs
PID 20200139 TCPIP$NTP_1 has 292 pagefile refs
TCPIP$POP_1 not dumped
PID 2020013B TCPIP$PWIP_ACP has 155 pagefile refs
TCPIP$NTP_4646 not dumped
TCPIP$XDM_1 not dumped
DTLOGIN not dumped
DTGREET not dumped
PID 20200146 HTTPd:80 has 4276 pagefile refs
PID 20200147 HyperSPI++ has 137 pagefile refs
DBL$MSGMGR not dumped
PID 2020014A MYSQL_SERVER has 10716 pagefile refs
PID 2020014B SYMBIONT_2 has 206 pagefile refs
HTTPd:80-25 not dumped
PID 202040D7 HTTPd:80-26 has 2971 pagefile refs
HTTPd:80-27 not dumped
HTTPd:80-28 not dumped
PID 202040DA HTTPd:80-29 has 2972 pagefile refs
HTTPd:80-30 not dumped
HTTPd:80-31 not dumped
HTTPd:80-32 not dumped
PID 202040DE HTTPd:80-33 has 2950 pagefile refs
HTTPd:80-34 not dumped
PID 202040E0 HTTPd:80-35 has 2127 pagefile refs
PID 202040E1 HTTPd:80-36 has 2206 pagefile refs
PID 202040E2 HTTPd:80-37 has 1429 pagefile refs
PID 202040E3 HTTPd:80-38 has 1511 pagefile refs
PID 202040E4 HTTPd:80-39 has 1486 pagefile refs
HTTPd:80-40 not dumped
HTTPd:80-41 not dumped
HTTPd:80-42 not dumped
%PF-I-USERS, 25 processes found to be using this file
%PF-I-PFREFS, Total page file references 37400
%PF-I-TOTALSWAP, Total Size of all Swap Files 1976 pages
%PF-I-TOTALPAGE, Total Size of all Page Files 33264 pages
%PF-I-TOTALREFS, Total Committed Page File Usage 57688 pages
%PF-I-TOTALALLO, Total Allocated Page File 33264 pages
%PF-I-PINUSE, 100.00% pagefile is in use
%SYSTEM-W-PAGEFRAG, page file filling up
%SYSTEM-W-PAGECRIT, page file nearly full

PF V1.1-1 (c) 2006, Ian Miller (miller@xxxxx) built on VMS V8.3
%PF-I-INFO, File index 252
ALPHASYS:[local]PAGEFILE1.SYS;2
Pagefile flags: INITED
Total size (in pages) 11088 Pages in use 11088
Free Pages 0 Minimum free pages 0
Total write count 2532 Total read count 3962
%PF-I-LOOKING, Searching for proceses using this file
PID 20200108 CONFIGURE has 35 pagefile refs
PID 20200109 LANACP has 84 pagefile refs
ERRFMT not dumped
CACHE_SERVER not dumped
OPCOM not dumped
JOB_CONTROL not dumped
QUEUE_MANAGER not dumped
PID 20200113 SECURITY_SERVER has 345 pagefile refs
PID 20200114 ACME_SERVER has 321 pagefile refs
PID 20200117 DNS$ADVER has 274 pagefile refs
NET$ACP not dumped
REMACP not dumped
NET$EVD not dumped
DTSS$SERVICE not dumped
SMISERVER not dumped
PID 2020011E TP_SERVER has 65 pagefile refs
SMTP_DIANA_01 not dumped
PID 20200129 DECW$SERVER_0 has 1293 pagefile refs
PID 20200132 TCPIP$INETACP has 200 pagefile refs
PID 20200333 TCPIP$BIND_1 has 854 pagefile refs
TCPIP$PORTM_1 not dumped
TCPIP$DHCP_1 not dumped
TCPIP$FTP_1 not dumped
PID 20200138 TCPIP$IMAP_1 has 392 pagefile refs
PID 20200139 TCPIP$NTP_1 has 292 pagefile refs
TCPIP$POP_1 not dumped
PID 2020013B TCPIP$PWIP_ACP has 155 pagefile refs
TCPIP$NTP_4646 not dumped
TCPIP$XDM_1 not dumped
DTLOGIN not dumped
DTGREET not dumped
PID 20200146 HTTPd:80 has 4276 pagefile refs
PID 20200147 HyperSPI++ has 137 pagefile refs
DBL$MSGMGR not dumped
PID 2020014A MYSQL_SERVER has 10716 pagefile refs
PID 2020014B SYMBIONT_2 has 206 pagefile refs
HTTPd:80-25 not dumped
PID 202040D7 HTTPd:80-26 has 2971 pagefile refs
HTTPd:80-27 not dumped
HTTPd:80-28 not dumped
PID 202040DA HTTPd:80-29 has 2972 pagefile refs
HTTPd:80-30 not dumped
HTTPd:80-31 not dumped
HTTPd:80-32 not dumped
PID 202040DE HTTPd:80-33 has 2950 pagefile refs
HTTPd:80-34 not dumped
PID 202040E0 HTTPd:80-35 has 2127 pagefile refs
PID 202040E1 HTTPd:80-36 has 2206 pagefile refs
PID 202040E2 HTTPd:80-37 has 1429 pagefile refs
PID 202040E3 HTTPd:80-38 has 1511 pagefile refs
PID 202040E4 HTTPd:80-39 has 1486 pagefile refs
HTTPd:80-40 not dumped
HTTPd:80-41 not dumped
HTTPd:80-42 not dumped
%PF-I-USERS, 24 processes found to be using this file
%PF-I-PFREFS, Total page file references 37297
%PF-I-TOTALSWAP, Total Size of all Swap Files 1976 pages
%PF-I-TOTALPAGE, Total Size of all Page Files 33264 pages
%PF-I-TOTALREFS, Total Committed Page File Usage 57688 pages
%PF-I-TOTALALLO, Total Allocated Page File 33264 pages
%PF-I-PINUSE, 100.00% pagefile is in use
%SYSTEM-W-PAGEFRAG, page file filling up
%SYSTEM-W-PAGECRIT, page file nearly full

It looks like MySQLServer and the webserver processes (running PHP) consume most of the space!