Cloudflare DevelopersCD
Cloudflare Developers•4mo ago•
3 replies
omortis

So I have created a D1 database with

So I have created a D1 database with 
wrangler
 and I have added a table to the database using the D1 web console. I can get the db schema just fine via PRAGMA:

 npx wrangler d1 execute spendydb --command='PRAGMA table_list' --remote


However if I try to execute any SQL with 
wrangler
 I get an auth error. This happens for remote and local instances:

npx wrangler d1 execute spendydb --file=./sql/create_d1.sql --remote^


✘ [ERROR] not authorized: SQLITE_AUTH

npx wrangler whoami
 tells me I have 
d1 (write)
 permissions. Did I miss a setup step with 
wrangler
? Note that it is up to date at 4.42.2. Is this a question for the wrangler channel? I don't see anything useful in the log, although this is interesting: 
"errorType": "UserError"
.

Please note that the SQL in my file works fine when entered via the web console.
Was this page helpful?
CommunitiesDocsAboutTermsPrivacy