Repository navigation
It can't parse cockroachdb DSN #698
Description
I'm trying to connect to a database with this DSN: cockroachdb://test:test@host:26257/test?sslmode=verify-full. (I changed the password and host for this example)
This is the code:
connURL, err := crdb.ParseURL(os.Getenv("DATABASE_URI"))
if err != nil {
return nil, err
}
sess, err := crdb.Open(connURL)
if err != nil {
return nil, err
}And I'm getting the error bellow:
$ env DATABASE_URI=cockroachdb://test:test@host:26257/test?sslmode=verify-full go run main.go start
failed to connect to `host=127.0.0.1 user=arantes database=`: dial error (dial tcp 127.0.0.1:26257: connect: connection refused)
exit status 1But if I use postgres schema in the DSN (postgres://test:test@host:26257/test?sslmode=verify-full), it works fine.
Activity
GaMoCh commentedon Oct 1, 2023
@arantesxyz
The CockroachDB documentation connection-parameters says that the URL scheme used is
postgres://, is there any specification in the documentation that shows the use ofcockroachdb://?If the
cockroachdb://URL scheme is valid, you can open a PR by changing the file: cockroachdb/connection.goThe Cockroach CLI has the
convert-urlcommand that converts an SQL connection string for use with various client drivers, and thecockroachdbURL scheme is an unrecognized URL scheme.arantesxyz commentedon Oct 2, 2023
The DSN I'm using was generated by the CockroachDB cloud panel, I'm using postgres schema to run the code, it works fine, but i do think upper should implement this directly into their parse logic.