From c9bc3a2a938da5a56096e2b3941c38515ca42894 Mon Sep 17 00:00:00 2001
From: xangelo <me@xangelo.ca>
Date: Wed, 4 Dec 2024 15:00:13 -0500
Subject: [PATCH] chore(build): fix db ssl for DO

---
 knexfile.ts          | 6 ++++--
 src/server/lib/db.ts | 3 ++-
 2 files changed, 6 insertions(+), 3 deletions(-)

diff --git a/knexfile.ts b/knexfile.ts
index 987738c..ea4b0b7 100644
--- a/knexfile.ts
+++ b/knexfile.ts
@@ -11,7 +11,8 @@ const config: { [key: string]: Knex.Config } = {
     connection: {
       connectionString: connectionUrl,
       ssl: {
-        rejectUnauthorized: false
+        rejectUnauthorized: false,
+        ca: process.env.CA_CERT
       }
     },
     pool: {
@@ -28,7 +29,8 @@ const config: { [key: string]: Knex.Config } = {
     connection: {
       connectionString: connectionUrl,
       ssl: {
-        rejectUnauthorized: false
+        rejectUnauthorized: false,
+        ca: process.env.CA_CERT
       }
     },
     pool: {
diff --git a/src/server/lib/db.ts b/src/server/lib/db.ts
index 7b9fe4a..6a19281 100644
--- a/src/server/lib/db.ts
+++ b/src/server/lib/db.ts
@@ -10,7 +10,8 @@ export const db = knex({
   connection: {
     connectionString: connectionUrl,
     ssl: {
-      rejectUnauthorized: false
+      rejectUnauthorized: false,
+      ca: process.env.CA_CERT
     }
   }
 });
-- 
2.25.1