From 254b758c06cdad5bed16ac3c08efc2b54f9beebe Mon Sep 17 00:00:00 2001
From: Paul Norman <penorman@mac.com>
Date: Fri, 24 Jul 2026 16:32:33 -0700
Subject: [PATCH] Run hourly ofastlylog with tilelog

---
 cookbooks/tilelog/recipes/default.rb          | 28 +++++++++++++++++++
 .../templates/default/ofastlylog-hourly.erb   |  9 ++++++
 2 files changed, 37 insertions(+)
 create mode 100644 cookbooks/tilelog/templates/default/ofastlylog-hourly.erb

diff --git a/cookbooks/tilelog/recipes/default.rb b/cookbooks/tilelog/recipes/default.rb
index 67c6deade..de8932698 100644
--- a/cookbooks/tilelog/recipes/default.rb
+++ b/cookbooks/tilelog/recipes/default.rb
@@ -24,6 +24,7 @@ include_recipe "python"
 aws_credentials = data_bag_item("tilelog", "aws")
 
 tilelog_directory = "/opt/tilelog"
+ofastlylog_directory = "/opt/ofastlylog"
 tilelog_output_directory = node[:tilelog][:output_directory]
 
 python_virtualenv tilelog_directory do
@@ -71,3 +72,30 @@ end
 service "tilelog.timer" do
   action [:enable, :start]
 end
+
+python_virtualenv ofastlylog_directory do
+  interpreter "/usr/bin/python3"
+end
+
+python_package "tilelog" do
+  python_virtualenv ofastlylog_directory
+  python_version "3"
+  version "0.3.0"
+end
+
+template "/usr/local/bin/ofastlylog-hourly" do
+  source "ofastlylog-hourly.erb"
+  owner "root"
+  group "root"
+  mode "755"
+  variables :aws_credentials => aws_credentials
+end
+
+systemd_service "ofastlylog-hourly" do
+  description "ofastlylog analysis"
+  user "planet"
+  exec_start "/usr/local/bin/ofastlylog-hourly"
+  nice 10
+  sandbox :enable_network => true
+  protect_home True
+end
diff --git a/cookbooks/tilelog/templates/default/ofastlylog-hourly.erb b/cookbooks/tilelog/templates/default/ofastlylog-hourly.erb
new file mode 100644
index 000000000..75eaa2009
--- /dev/null
+++ b/cookbooks/tilelog/templates/default/ofastlylog-hourly.erb
@@ -0,0 +1,9 @@
+#!/bin/sh
+set -e
+
+export AWS_ACCESS_KEY_ID="<%= @aws_credentials["tilelog_access_key_id"] %>"
+export AWS_SECRET_ACCESS_KEY="<%= @aws_credentials["tilelog_secret_access_key"] %>"
+export AWS_REGION="eu-north-1"
+
+/opt/ofastlylog/bin/ofastlylog process hourly --hours 6 \
+--raster success --vector success --nominatim success --website success
-- 
2.47.3