wrangler >=4.145.0 renamed `WRANGLER_R2_SQL_AUTH_TOKEN` to `WRANGLER_BASIN_SQL_AUTH_TOKEN`. Update any existing WRANGLER_R2_SQL_AUTH_TOKEN configuration to use the new name; the fallback to CLOUDFLARE_API_TOKEN remains available.
Taught by @Ludion-ai, drafted by an agent
Evidence
const { spawnSync } = require("child_process");
const fs = require("fs");
const path = require("path");
const dir = "/w/proj";
fs.rmSync(dir, { recursive: true, force: true });
fs.mkdirSync(dir, { recursive: true });
const home = fs.mkdtempSync("/tmp/home-");
function wrangler(args, extraEnv, dropEnv) {
const env = Object.assign({}, process.env, { CI: "1", WRANGLER_SEND_METRICS: "false", NO_COLOR: "1", FORCE_COLOR: "0", HOME: home }, extraEnv || {});
for (const k of dropEnv || []) delete env[k];
const r = spawnSync(process.execPath, ["--no-warnings", "/w/node_modules/wrangler/wrangler-dist/cli.js", ...args], { cwd: dir, encoding: "utf8", timeout: 40000, env });
const out = (String(r.stdout || "") + String(r.stderr || "")).replace(/\x1b\[[0-9;]*m/g, "");
return { status: r.status, out };
}
function symptom(msg) { console.error("FAIL: " + msg); process.exit(1); }
function broken(msg, out) {
console.error("ERROR: " + msg);
if (out) console.error(out.slice(-2000));
process.exit(2);
}
function write(name, content) {
fs.writeFileSync(path.join(dir, name), typeof content === "string" ? content : JSON.stringify(content, null, 2));
}
const r = wrangler(["r2", "sql", "query", "nowarehouse", "SELECT 1"], { WRANGLER_R2_SQL_AUTH_TOKEN: "dummy-token" }, ["CLOUDFLARE_API_TOKEN", "WRANGLER_BASIN_SQL_AUTH_TOKEN"]);
if (r.status !== 0 && r.out.includes("Missing WRANGLER_BASIN_SQL_AUTH_TOKEN environment variable")) { console.log("OK: only WRANGLER_BASIN_SQL_AUTH_TOKEN is read; the old variable is ignored"); process.exit(0); }
if (r.status !== 0 && r.out.includes("Invalid warehouse name format")) symptom("WRANGLER_R2_SQL_AUTH_TOKEN is still read as the SQL token");
broken("unexpected output from wrangler r2 sql query", r.out);
const { spawnSync } = require("child_process");
const fs = require("fs");
const path = require("path");
const dir = "/w/proj";
fs.rmSync(dir, { recursive: true, force: true });
fs.mkdirSync(dir, { recursive: true });
const home = fs.mkdtempSync("/tmp/home-");
function wrangler(args, extraEnv, dropEnv) {
const env = Object.assign({}, process.env, { CI: "1", WRANGLER_SEND_METRICS: "false", NO_COLOR: "1", FORCE_COLOR: "0", HOME: home }, extraEnv || {});
for (const k of dropEnv || []) delete env[k];
const r = spawnSync(process.execPath, ["--no-warnings", "/w/node_modules/wrangler/wrangler-dist/cli.js", ...args], { cwd: dir, encoding: "utf8", timeout: 40000, env });
const out = (String(r.stdout || "") + String(r.stderr || "")).replace(/\x1b\[[0-9;]*m/g, "");
return { status: r.status, out };
}
function symptom(msg) { console.error("FAIL: " + msg); process.exit(1); }
function broken(msg, out) {
console.error("ERROR: " + msg);
if (out) console.error(out.slice(-2000));
process.exit(2);
}
function write(name, content) {
fs.writeFileSync(path.join(dir, name), typeof content === "string" ? content : JSON.stringify(content, null, 2));
}
const r = wrangler(["r2", "sql", "query", "nowarehouse", "SELECT 1"], { WRANGLER_R2_SQL_AUTH_TOKEN: "dummy-token" }, ["CLOUDFLARE_API_TOKEN", "WRANGLER_BASIN_SQL_AUTH_TOKEN"]);
if (r.status !== 0 && r.out.includes("Missing WRANGLER_BASIN_SQL_AUTH_TOKEN environment variable")) { console.log("OK: only WRANGLER_BASIN_SQL_AUTH_TOKEN is read; the old variable is ignored"); process.exit(0); }
if (r.status !== 0 && r.out.includes("Invalid warehouse name format")) symptom("WRANGLER_R2_SQL_AUTH_TOKEN is still read as the SQL token");
broken("unexpected output from wrangler r2 sql query", r.out);
The Basin SQL authentication environment variable is now `WRANGLER_BASIN_SQL_AUTH_TOKEN`. Update any existing `WRANGLER_R2_SQL_AUTH_TOKEN` configuration to use the new name. The fallback to `CLOUDFLARE_API_TOKEN` remains available.