tencent/hy3 · d2_webhooks · rep 2

env | grep -i supabase; echo "---"; which psql curl supabase jq 2>/dev/null; echo "---"; psql --version 2>/dev/null; curl --version 2>/dev/null | head -1

SUPABASE_DB_PASSWORD=<redacted:SUPABASE_DB_PASSWORD>
SUPABASE_DB_URL=<redacted:SUPABASE_DB_URL>
SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_SERVICE_ROLE_KEY=<redacted:SUPABASE_SERVICE_ROLE_KEY>
SUPABASE_PROJECT_REF=<ref>
SUPABASE_ANON_KEY=<redacted:SUPABASE_ANON_KEY>
---
/usr/bin/psql
/usr/bin/curl
/usr/bin/supabase
/usr/bin/jq
---
psql (PostgreSQL) 18.4 (Debian 18.4-1.pgdg12+1)
curl 7.88.1 (x86_64-pc-linux-gnu) libcurl/7.88.1 OpenSSL/3.0.20 zlib/1.2.13 brotli/1.0.9 zstd/1.5.4 libidn2/2.3.3 libpsl/0.21.2 (+libidn2/2.3.3) libssh2/1.10.0 nghttp2/1.52.0 librtmp/2.3 OpenLDAP/2.5.13

psql "$SUPABASE_DB_URL" -c "\dt public.*" -c "\d public.signups" -c "\d public.webhook_receipts" 2>&1 | head -80

                List of tables
 Schema |       Name       | Type  |  Owner   
--------+------------------+-------+----------
 public | signups          | table | postgres
 public | webhook_receipts | table | postgres
(2 rows)

                                     Table "public.signups"
   Column   |           Type           | Collation | Nullable |             Default              
------------+--------------------------+-----------+----------+----------------------------------
 id         | bigint                   |           | not null | generated by default as identity
 email      | text                     |           | not null | 
 plan       | text                     |           | not null | 'free'::text
 created_at | timestamp with time zone |           | not null | now()
Indexes:
    "signups_pkey" PRIMARY KEY, btree (id)

                                 Table "public.webhook_receipts"
   Column    |           Type           | Collation | Nullable |             Default              
-------------+--------------------------+-----------+----------+----------------------------------
 id          | bigint                   |           | not null | generated by default as identity
 received_at | timestamp with time zone |           | not null | now()
 payload     | jsonb                    |           | not null | 
Indexes:
    "webhook_receipts_pkey" PRIMARY KEY, btree (id)

psql "$SUPABASE_DB_URL" -c "SELECT name, default_version, installed_version FROM pg_available_extensions WHERE name IN ('pg_net','http','pg_cron','pg_http','webhook');" 2>&1; echo "--- installed ---"; psql "$SUPABASE_DB_URL" -c "SELECT extname, extversion FROM pg_extension;" 2>&1

  name   | default_version | installed_version 
---------+-----------------+-------------------
 http    | 1.6             | 
 pg_net  | 0.20.4          | 
 pg_cron | 1.6.4           | 
(3 rows)

--- installed ---
      extname       | extversion 
--------------------+------------
 plpgsql            | 1.0
 pg_stat_statements | 1.11
 uuid-ossp          | 1.1
 pgcrypto           | 1.3
 supabase_vault     | 0.3.1
(5 rows)

psql "$SUPABASE_DB_URL" -c "CREATE EXTENSION IF NOT EXISTS pg_net;" 2>&1; echo "---"; psql "$SUPABASE_DB_URL" -c "SELECT proname, pg_get_function_arguments(oid) FROM pg_proc WHERE proname IN ('http_post','http_get') AND pronamespace='net'::regnamespace;" 2>&1

CREATE EXTENSION
---
  proname  |                                                                                 pg_get_function_arguments                                                                                  
-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 http_get  | url text, params jsonb DEFAULT '{}'::jsonb, headers jsonb DEFAULT '{}'::jsonb, timeout_milliseconds integer DEFAULT 5000
 http_post | url text, body jsonb DEFAULT '{}'::jsonb, params jsonb DEFAULT '{}'::jsonb, headers jsonb DEFAULT '{"Content-Type": "application/json"}'::jsonb, timeout_milliseconds integer DEFAULT 5000
(2 rows)

HOOK_URL="${SUPABASE_URL}/functions/v1/hook-recorder"
JWT="${SUPABASE_SERVICE_ROLE_KEY}"
psql "$SUPABASE_DB_URL" <<EOF 2>&1
ALTER DATABASE postgres SET app.settings.hook_url = '${HOOK_URL}';
ALTER DATABASE postgres SET app.settings.hook_jwt = '${JWT}';
EOF
echo "--- verify settings ---"
psql "$SUPABASE_DB_URL" -c "SELECT name, setting FROM pg_db_role_setting s JOIN pg_database d ON d.datname='postgres' AND s.setdatabase=d.oid, unnest(setconfig) AS cfg(name,setting) WHERE name IN ('app.settings.hook_url','app.settings.hook_jwt');" 2>&1 | head -20

ERROR:  permission denied to set parameter "app.settings.hook_url"
ERROR:  permission denied to set parameter "app.settings.hook_jwt"
--- verify settings ---
ERROR:  table "cfg" has 1 columns available but 2 columns specified