3 replies

So I have created a D1 database with

wrangler

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

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

However if I try to execute any SQL with

wrangler

wrangler

I get an auth error. This happens for remote and local instances:

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

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

✘ [ERROR] not authorized: SQLITE_AUTH

npx wrangler whoami

npx wrangler whoami

tells me I have

d1 (write)

d1 (write)

permissions. Did I miss a setup step with

wrangler

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"

"errorType": "UserError"

.

Please note that the SQL in my file works fine when entered via the web console.

Cloudflare Developers•5mo ago•

3 replies

omortis

So I have created a D1 database with

wrangler

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

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

However if I try to execute any SQL with

wrangler

wrangler

I get an auth error. This happens for remote and local instances:

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

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

✘ [ERROR] not authorized: SQLITE_AUTH

npx wrangler whoami

npx wrangler whoami

tells me I have

d1 (write)

d1 (write)

permissions. Did I miss a setup step with

wrangler

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"

"errorType": "UserError"

.

Please note that the SQL in my file works fine when entered via the web console.

So I have created a D1 database with

Similar Threads

So I have created a D1 database with

Similar Threads

Similar Threads

Similar Threads