craftyshaun/2025-04-03 - Pawnit Onsite.md

Recent #client-pawnitsystems Notes

TABLE file.ctime as Created
FROM #client-pawnitsystems  
WHERE !contains(file.name, "Template")
SORT file.ctime desc

Tasks for Day

Pawnit Networking

Install ZeroTier on UTM

Odoo

Script to backup using the curl to the db backup endpoint.

https://handbook.coopdevs.org/ca/Odoo/Sysadmin/Add-Backups-To-Odoo-Instance

curl -X POST -F 'master_pwd=ptd2-da5d-uewx' -F 'name=OdooProd_Dev' -F 'backup_format=zip' -o odoo-dev-backup-`date -Iseconds`.zip http://localhost:8065/web/database/backup

curl -X POST -F 'master_pwd=ptd2-da5d-uewx' -F 'name=OdooProd_Dev' -F 'backup_format=zip' -F "backup_file=@$RESTORE_FILE" -F "neutralize_database=1"  http://localhost:8065/web/database/restore

#howto-odoo How do do do hiracheral structures:

https://www.odoo.com/forum/help-1/multi-level-customer-structure-how-can-i-add-a-subsidiary-to-a-company-record-not-a-contact-i-need-a-grandparent-parent-child-hierarchy-for-my-customer-record-122659
Client Import (backup between setup)
- Import the orgs
- Import the org sites under the orgs

AWS Cognito

Finish making the test user pool with simple user/pass
Find out how we link to draftbit

Mobile Push Notifications

Confirm the push method
- SNS Based ??
  - SNS -> APNS
  - SNS -> Google
  - SNS -> Web
- ~~Using another push / notification ag (check Raindrop)~~
Initial use in pawnit mobile

Preforming Odoo Backups

SSH to the odoo host
cd to /opt/docker/backups
Run ./dump-prod.sh

This will make an adhoc backup with a file name like odoo-prod-backup-adhoc-2025-06-03T23:58:23+00:00.zip

This can then be restored across to dev using ./restore-dev.sh with the filename. So ./restore-dev.sh odoo-prod-backup-adhoc-2025-06-03T23:58:23+00:00.zip

The backup script is also called from CRON with a --scheduled flag that writes the backup and removes anything older than 7 days.

Crontab

cd /opt/docker/backups && dump-prod.sh --scheduled