[object Object]

← back to Dw Five Field Step0

fix scan DB auth: connect over unix socket (peer auth) like psql

6d9656ec179f0897b5943e8259cb79b936a710cf · 2026-06-21 14:38:18 -0700 · steve

Files touched

Diff

commit 6d9656ec179f0897b5943e8259cb79b936a710cf
Author: steve <steve@designerwallcoverings.com>
Date:   Sun Jun 21 14:38:18 2026 -0700

    fix scan DB auth: connect over unix socket (peer auth) like psql
---
 node_modules         | 1 +
 scripts/scan-live.js | 6 +++++-
 2 files changed, 6 insertions(+), 1 deletion(-)

diff --git a/node_modules b/node_modules
new file mode 120000
index 0000000..9f30656
--- /dev/null
+++ b/node_modules
@@ -0,0 +1 @@
+/Users/stevestudio2/Projects/Designer-Wallcoverings/node_modules
\ No newline at end of file
diff --git a/scripts/scan-live.js b/scripts/scan-live.js
index 99b8ea3..13c9b7c 100644
--- a/scripts/scan-live.js
+++ b/scripts/scan-live.js
@@ -22,7 +22,11 @@ const env = fs.readFileSync(process.env.HOME + '/Projects/secrets-manager/.env',
 const TOKEN = (env.match(/SHOPIFY_ADMIN_TOKEN=(\S+)/) || [])[1];
 const DOMAIN = 'designer-laboratory-sandbox.myshopify.com', VER = '2024-10';
 const URL = `https://${DOMAIN}/admin/api/${VER}/graphql.json`;
-const pool = new Pool({ connectionString: process.env.DATABASE_URL || 'postgresql://dw_admin@127.0.0.1:5432/dw_unified' });
+// Connect over the unix socket (peer auth, no password) exactly like the psql
+// CLI does — TCP to 127.0.0.1 demands a password the local trust setup rejects.
+delete process.env.PGPASSWORD;
+delete process.env.DATABASE_URL;
+const pool = new Pool({ host: '/tmp', database: 'dw_unified' });
 
 const Q = `query($cursor:String){products(first:120,after:$cursor,query:"status:active"){pageInfo{hasNextPage endCursor} edges{node{id vendor descriptionHtml variants(first:30){edges{node{title sku price}}}}}}}`;

← aaaaf09 Step-0 scaffold: live 5-field scanner (DTD verdict B), persi  ·  back to Dw Five Field Step0  ·  fix scan null-sku crash in bare-sku derivation 9f81672 →