Cleanup and configuration changes
First of all, I have started a new accounting file – thought it’s time to do so after 5 years: It takes quite some time to get to the latest data (the file is 256 Mb in size…). Next, I extracted the data of the server-executoree (HTTP%NOBODY) after 01-Jan-2017, to find out what mnay cause the PHP problems. It could be a matter of sizing. It looks like it, and that meant I had to change the working set parameters of this user:
UAF> sho http$nobody
Username: HTTP$NOBODY Owner: WASD Scripting
Account: WEBSRV UIC: [76,1] ([HTTP$NOBODY])
CLI: DCL Tables: DCLTABLES
Default: WASD_ROOT:[HTTP$NOBODY]
LGICMD: LOGIN.COM
Flags: DisNewMail DisMail
Primary days: Mon Tue Wed Thu Fri
Secondary days: Sat Sun
Primary 000000000011111111112222 Secondary 000000000011111111112222
Day Hours 012345678901234567890123 Day Hours 012345678901234567890123
Network: ##### Full access ###### ##### Full access ######
Batch: ----- No access ------ ----- No access ------
Local: ----- No access ------ ----- No access ------
Dialup: ----- No access ------ ----- No access ------
Remote: ----- No access ------ ----- No access ------
Expiration: (none) Pwdminimum: 6 Login Fails: 0
Pwdlifetime: 90 00:00 Pwdchange: 14-AUG-2012 07:49
Last Login: 14-AUG-2012 07:48 (interactive), 13-APR-2017 19:20 (non-interactive)
Maxjobs: 0 Fillm: 500 Bytlm: 500000
Maxacctjobs: 0 Shrfillm: 0 Pbytlm: 0
Maxdetach: 0 BIOlm: 2000 JTquota: 4000
Prclm: 100 DIOlm: 1000 WSdef: 1000
Prio: 4 ASTlm: 2000 WSquo: 4000
Queprio: 0 TQElm: 100 WSextent: 20000
CPU: (none) Enqlm: 500 Pgflquo: 500000
Authorized Privileges:
NETMBX TMPMBX
Default Privileges:
NETMBX TMPMBX
Identifier Value Attributes
WASD_HTTP_NOBODY %X8001001D
UAF> mod http$nobody/wsquo=8000/wsextend=30000/biolm=2048/diolm=1024
%UAF-I-MDFYMSG, user record(s) updated
UAF>
That should make at least some difference, time will tell.
Another addition is a job that should tell me about the workload during some time, it may mean I’ll have to do some changes to system parameters and reboot. But this will take a few weeks to set in.
MariaDb test
I had installed MariaDb 5.5, as ported by Mark Berryman. There were two issue with the creation of SSL certificates: The routine wasn’t found where expected, and though all references are to SSL$ROOT:, there is one that refers to SSLROOT (within one of these procedures). Might have been a local issue, and was easily circumvented.
I copied MySQL database using conversion routines, in stead of creating a new one and loading the export (the backup of then database).
One thing to change anyway is the port to listen on: 3306 is currently in use my MySQL 5.1 that is used by the blogs. So I changed this to 3316, and started the server.
Next I connected using mysql -u root -p – entered my password, and could access the data. But at some point, the server crashed, it seems to occur in LIBRTL. This happened three times, same signature (at first glance).
That means contacting Mark Berryman….