backlog

Hours of dialog with ChatGPT trying to implement some security features, but ran into problems that went past midnight. Will continue tomorrow.

Created secure passwords for the database root, wiki and wordpress users. Put them in environment variables, updated the passwords in the database and tested for functionality.

Much dialog with ChatGPT about setting up this server. Re-configured for shared db and using Docker builds rather than Turnkey. Many other tweaks as well. Got the initial Wordpress service working and notified Marcin / Catarina.

backlog

Floor plans for 1-story hous

Campus design

Floor plans for 1 story house and campus dorm

backlog

Got info from ChatGPT and installed docker -> Turnkey appliances for Wordpress and Mediawiki. Fetched images, extensions and Localsettings in preparation for migrating all of mediawiki.

backlog

Installed "restic" software, did a backup and finally got the keepass database decrypted and opened.

Securing access to hetzner2 and setting up SSH keys for Marcin to access servers. Some progress made on keepass, but couldn't open the database.

backlog

Working with LetsEncrypt site and "certbot" program to generate certs to make the website work.

(belated entry for 2025-04-30) hetzner2 sda replacement

(belated entry for 2025-05-27) github, wiki logs, aws follow-up

Having SSL issues and other isuses. Resolved most, but still have to get the certs fixdd.

Diving into problem with Wordpress not visible. Studying various components, testing

Configure dev WP site for Catarina.

backlog

Update kitchen BoM and budget

Created database instance and user for new Wordpress install. Created ansible templates for its deployment. Created target directories for the deployment.

backlog

Work with Catarina to get Dreamhost / Wordpress site working. Attempted to get credentials, but all keepass data unaccessible.

backlog

As Hetzner is largely inacessible, Catarina starts website on Dreamhost, but can't access as DNS hosted on Cloudflare, credentials in hetzner2:/etc/keepass and we can't see them as yet.

Enabled sftp on hetzner3 to fix ansible connections.

Fixed ansible errors with scp and sftp.

backlog

Study ansible and server provisioning. Trials with ansible, but hit stopping point.

Tom onboarding, wazuh, google groups, RAID follow-up, GitHub, hetzner2 ssh

fix grub on hetzner2, Tom onboarding email

update hetzner3 networking config for new IPv4 address, CHG to replaced /dev/sdb on hetzner2 https://wiki.opensourceecology.org/wiki/CHG-2025-04-24_replace_hetzner2_sdb

Sign Post: design + BoM

backlog

prepare CHG for disk change, SMART email alerts, munin varnish & smart, phpList and postfix email delivery investigations

(belated entry for 2025-04-19) hetzner3 sudo & ssh, prepare CHG for disk change

(belated entry for 2025-04-18) db corruption recovery, sudo for marcin (reboot only), SMART investigation, prepare CHG for disk change

(belated entry for 2025-04-17) db corruption recovery

(belated entry for 2025-04-11) ordered second IPv4 address for hetzner3, hetzner3 ssh, Marcin veracrypt backups & wiki docs, hour logging, billing, osemain

backlog

backlog

(belated entry for 2025-03-17) wiki, obi dreamhost keepass, hetzner3 ssh access, 3tofu

(belated entry for 2025-03-16) hetzner3 ssh access, 3tofu, obi, hetzer wui lock-out troubleshooting

(belated entry for 2025-03-15) osemain, hetzner3 ssh access, wiki, 3tofu

(belated entry for 2025-03-04) wordpress theme research, osemain post db queries

(belated entry for 2025-03-03) meeting with Marcin & Catarina, follow-up research and emails, billing for Feb

vBoM to BoM: bathrooms (revisions)

backlog