I wasn't sure if the update clears the database so here is an attempt to save someone some time:
Web UI: System->Settings->Administration:
Check:
Enable Secure Shell
Permit root user login
Permit password login
Apply
ssh root@<yourgateway>
root@OPNsense:/var/db/hostwatch # ls -lh
total 207598624
-rw-r--r-- 1 hostd hostd 4.0M Jan 30 17:30 hosts.db
-rw-r--r-- 1 hostd hostd 393M Jan 30 18:05 hosts.db-shm
-rw-r--r-- 1 hostd hostd 198G Jan 30 18:05 hosts.db-wal
service hostwatch stop
rm -rf /var/db/hostwatch/*
Update to OPNsense 26.1_4:
exit
12) Update from console
Web UI: System->Settings->Administration:
Uncheck:
Enable Secure Shell
Permit root user login
Permit password login
Apply
Web UI: System->Settings->Administration:
Check:
Enable Secure Shell
Permit root user login
Permit password login
Apply
ssh root@<yourgateway>
root@OPNsense:/var/db/hostwatch # ls -lh
total 207598624
-rw-r--r-- 1 hostd hostd 4.0M Jan 30 17:30 hosts.db
-rw-r--r-- 1 hostd hostd 393M Jan 30 18:05 hosts.db-shm
-rw-r--r-- 1 hostd hostd 198G Jan 30 18:05 hosts.db-wal
service hostwatch stop
rm -rf /var/db/hostwatch/*
Update to OPNsense 26.1_4:
exit
12) Update from console
Web UI: System->Settings->Administration:
Uncheck:
Enable Secure Shell
Permit root user login
Permit password login
Apply
"