-
Notifications
You must be signed in to change notification settings - Fork 923
docker run ... generate fails with a tls failure per query #3092
Unanswered
rossbagley
asked this question in
Q&A
-
Here's the command I ran:
> docker run --env SQLC_AUTH_TOKEN=${SQLC_AUTH_TOKEN} --rm -v "${PWD}:/src" -w /src sqlc/sqlc -f .sqlc/sqlc.yaml generate
.sqlc/sqlc.yaml
version: '2'
cloud:
project: '${SQLC_PROJECT}'
sql:
- schema: "../internal/model/sqlc/schema.sql"
queries: "../internal/model/sqlc/query.sql"
engine: postgresql
database:
managed: true
gen:
go:
package: "internal/model/sqlc"
out: "internal/model/sqlc"
sql_package: "pgx/v5"
internal/model/sqlc/schema.sql
CREATE TABLE domain (
r_id bigint PRIMARY KEY,
name text NOT NULL,
parent_id bigint REFERENCES domain(r_id),
domain_pb bytea NOT NULL
);
internal/model/sqlc/query.sql
-- name: GetDomain :one
SELECT * FROM domain
WHERE r_id = 1ドル LIMIT 1;
-- name: ListDomains :many
SELECT * FROM domain
ORDER BY name;
-- name: CreateDomain :one
INSERT INTO domain (
r_id,
name,
parent_id,
domain_pb
) VALUES (
1,ドル 2,ドル 3,ドル 4ドル
) RETURNING *;
-- name: DeleteDomain :exec
DELETE FROM domain
WHERE r_id = 1ドル;
The output is:
# package internal/model/sqlc
../internal/model/sqlc/query.sql:1:1: rpc error: code = Unavailable desc = connection error: desc = "transport: authentication handshake failed: tls: failed to verify certificate: x509: certificate signed by unknown authority"
../internal/model/sqlc/query.sql:6:1: rpc error: code = Unavailable desc = connection error: desc = "transport: authentication handshake failed: tls: failed to verify certificate: x509: certificate signed by unknown authority"
../internal/model/sqlc/query.sql:10:1: rpc error: code = Unavailable desc = connection error: desc = "transport: authentication handshake failed: tls: failed to verify certificate: x509: certificate signed by unknown authority"
../internal/model/sqlc/query.sql:20:1: rpc error: code = Unavailable desc = connection error: desc = "transport: authentication handshake failed: tls: failed to verify certificate: x509: certificate signed by unknown authority"
The line numbers are the first line of each query in query.sql. I would guess that Docker Desktop for Windows is rejecting a self-signed certificate on the connection and my Google-fu has not figured out how to tell Docker it's okay this time.
I'm using the docker command because the windows version of sqlc doesn't do postgresql.
Beta Was this translation helpful? Give feedback.
All reactions
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment