can not connect to cockroachdb invalid cluster name

Question

Why I cant connect to cockroachdb via powershell ?

I use this command:

cockroach sql --url postgres://username@cloud-host:26257/defaultdb?sslmode=require&options=--cluster=clustername;

I get the following error: Invalid clustername 08004

but the clustername is the right one.

€:

Nodejs

//For secure connection:
// const fs = require('fs');
const { Pool } = require("pg");

// Configure the database connection.

const config = {
  user: "xxxxx",
  password: "xxxx",
  cluster_name: "xxxx",
  host: "xxxx",
  database: "wxxx",
  port: 26257,
  ssl: {
    rejectUnauthorized: false,
  },
  //For secure connection:
  /*ssl: {
        ca: fs.readFileSync('/certs/ca.crt')
            .toString()
    }*/
};

// Create a connection pool

const pool = new Pool(config);

router.get('/', async (req, res) => {
  const client = await pool.connect();
  const d = await client.query('CREATE TABLE test (id INT, name VARCHAR, desc VARCHAR);');
  console.log(d);
  return res.json({
    message: 'BOSY'
  })

Get this error:

CodeParamsRoutingFailed: rejected by BackendConfigFromParams: Invalid cluster name

remove cluster name and put database name like `database: 'cluster_name.dbname'` — ROHIT KHURANA, Jun 22 '21 at 03:11

score 3 · Accepted Answer · edited Jan 11 '22 at 12:14

3

Try specifying the Cluster Name before dbname like this

cockroach sql --url postgres://username@cloud-host:26257/**clustername.defaultdb**?sslmode=require

edited Jan 11 '22 at 12:14

raiyan22

1,043
10
20

answered Jan 06 '22 at 20:09

Ina Tacheva

46
1

solved a `Error: pq: codeParamsRoutingFailed: missing cluster identifier` for connecting to a cockroachlabs.cloud cluster – ddelange Feb 01 '23 at 10:20

score 2 · Answer 2 · answered Jun 21 '21 at 16:05

2

I wonder if there's an issue with special characters in the shell. Having never used PowerShell this is only a guess, but does it work if you put the URL string in quotes?

cockroach sql --url "postgres://username@cloud-host:26257/defaultdb?sslmode=require&options=--cluster=clustername";

answered Jun 21 '21 at 16:05

paulkernfeld

2,171
1
16
16

Okey in the terminal it works now, but not on nodejs client, look at my post I edited – localdata01 Jun 22 '21 at 03:04
For the solution to the Node connection issue, Rohit Khurana's comment on your question should do what you're looking for. – paulkernfeld Jun 22 '21 at 15:57

can not connect to cockroachdb invalid cluster name

2 Answers2