LAN

http://home.sqlzoo.net/s-po/analytics Server status.

All the linux machines (aside from web facing) do a share of wiki-php work:

upstream tubbies{
  server 192.168.1.247:81 weight=1;     # laalaa
  server 192.168.1.234:81 weight=1;     # po
  server 192.168.1.108:81 weight=1;     # dipsy
  server 192.168.1.230:81 weight=1;     # tinky
#  server 192.168.1.219:81 weight=3;    # hammy
  server 192.168.1.223:81 weight=3;     # dill
  server 192.168.1.224:81 weight=1;     # parsley
  server 192.168.1.226:81 weight=1;     # sage
  server 192.168.1.202:81 weight=1;     # bill
#  server 192.168.1.206:81 weight=1;    # ben
  server 192.168.1.228:81 weight=1;     # basil
}

Name	IP	Kind	Jobs
basil	192.168.1.228	PI 5	ssh port 22 goes here
ben	192.168.1.202	PI 5	Web facing - distributes work to the others Ports 80, 443 go here
bill	192.168.1.206	PI 5	new
dill	192.168.1.223	PI 5	Stand-by Web facing port 222 mapped to 22 nosqlzoo progzoo
DG0001IGS	192.168.1.105	Windows Tower
dipsy	192.168.1.108	PI 3B	SAMBA on ports 139 & 445 Offset Studio
hammy	192.168.1.219	PI 5 64Gb	hammy no longer boots, changed the memory card, no luck
laalaa	192.168.1.247	PI 3B	general php duties
parsley	192.168.1.224	PI 5	MySQL for all wikis
po	192.168.1.234	PI 3B	Logging and analytics
sage	192.168.1.226	PI 5	GISQ MySQL
sun	192.168.1.186	Windows small	Oracle & MS SQL Server
tinky	192.168.1.230	PI 3B	Stand-by GISQ MySQL GISQ postgres

Fail log-

• 2025-05-27
  • sage reporting kernel panic not syncing
  • suspecting SD card. SP 64GB 3D NAND
  • replaced SD card with verbatum 64GB (no formatting required)
• 2025-10-07
  • basil does not respond from 2025-10-26 04:55, noddy snapshot spun up late evening but then does unattended upgrade
  • no alerts sent
  • cause unknown