update_subdomain_cnames.js

Go to the documentation of this file.

// Script to update all subdomain CNAMEs to point to your Cloudflare Tunnel hostname
require('dotenv').config();
const axios = require('axios');
const pool = require('../services/db');
 
const CLOUDFLARE_BASE_URL = process.env.CLOUDFLARE_BASE_URL || 'https://api.cloudflare.com/client/v4';
const CLOUDFLARE_ZONE_ID = process.env.CLOUDFLARE_ZONE_ID;
const CLOUDFLARE_TOKEN = process.env.CLOUDFLARE_TOKEN;
const ZONE_NAME = process.env.ZONE_NAME || 'everydaytech.au';
const TUNNEL_HOSTNAME = '52106555-6961-4b4d-bb84-1026b4892bec.cfargotunnel.com';
 
/**
 *
 */
async function updateSubdomainCNAMEs() {
  if (!CLOUDFLARE_ZONE_ID || !CLOUDFLARE_TOKEN) {
    throw new Error('Cloudflare credentials not configured');
  }
 
  const tenants = await pool.query('SELECT subdomain FROM tenants WHERE status = $1', ['active']);
  const headers = {
    Authorization: `Bearer ${CLOUDFLARE_TOKEN}`,
    'Content-Type': 'application/json'
  };
 
  for (const row of tenants.rows) {
    const subdomain = row.subdomain;
    const fqdn = `${subdomain}.${ZONE_NAME}`;
    // Find existing DNS record
    const listUrl = `${CLOUDFLARE_BASE_URL}/zones/${CLOUDFLARE_ZONE_ID}/dns_records?type=CNAME&name=${fqdn}`;
    const res = await axios.get(listUrl, { headers });
    if (res.data.result && res.data.result.length > 0) {
      // Update existing record
      const recordId = res.data.result[0].id;
      const updateUrl = `${CLOUDFLARE_BASE_URL}/zones/${CLOUDFLARE_ZONE_ID}/dns_records/${recordId}`;
      const payload = {
        type: 'CNAME',
        name: fqdn,
        content: TUNNEL_HOSTNAME,
        ttl: 120,
        proxied: true
      };
      const updateRes = await axios.put(updateUrl, payload, { headers });
      if (updateRes.data.success) {
        console.log(`✅ Updated CNAME for ${fqdn} → ${TUNNEL_HOSTNAME}`);
      } else {
        console.error(`❌ Failed to update ${fqdn}:`, updateRes.data.errors);
      }
    } else {
      // Create new record
      const createUrl = `${CLOUDFLARE_BASE_URL}/zones/${CLOUDFLARE_ZONE_ID}/dns_records`;
      const payload = {
        type: 'CNAME',
        name: fqdn,
        content: TUNNEL_HOSTNAME,
        ttl: 120,
        proxied: true
      };
      const createRes = await axios.post(createUrl, payload, { headers });
      if (createRes.data.success) {
        console.log(`✅ Created CNAME for ${fqdn} → ${TUNNEL_HOSTNAME}`);
      } else {
        console.error(`❌ Failed to create ${fqdn}:`, createRes.data.errors);
      }
    }
  }
  process.exit(0);
}
 
updateSubdomainCNAMEs().catch(err => {
  console.error('Error:', err.message);
  process.exit(1);
});