Creating user in local insecure cluster

I’m currently using SSL with user/password authentication on my k8s cluster. I’d like to be able to run unit tests and services locally on my laptop with my insecure cluster but I don’t seem to be able to create users when my local cluster is insecure. What’s up?

FYI, I’m just running a local cluster via:

#!/bin/bash
export ROACH_DATA=/Users/jimlambrt/cockroach-data
docker run -d \
--name=roach1 \
--hostname=roach1 \
--net=roachnet \
-p 26257:26257 -p 8080:8080  \
-v "$ROACH_DATA/roach1:/cockroach/cockroach-data"  \
 cockroachdb/cockroach:v2.1.6 start --insecure


 # Start the second container/node:
 docker run -d \
--name=roach2 \
--hostname=roach2 \ 
--net=roachnet \
-v "$ROACH_DATA/roach2:/cockroach/cockroach-data" \
cockroachdb/cockroach:v2.1.6 start --insecure --join=roach1

# Start the third container/node:
docker run -d \
--name=roach3 \
--hostname=roach3 \
--net=roachnet \
-v "$ROACH_DATA/roach3:/cockroach/cockroach-data" \
cockroachdb/cockroach:v2.1.6 start --insecure --join=roach1

AFAIK and unfortunately, insecure means no security at all in CRDB. Here are some other issues with it:


I’m not looking for security. I’m looking for compatibility. Returning an error when I try to create a user is silly just because it’s in “insecure” mode.

Hey @jimlambrt,

Can you share the command you ran when you tried creating the new user?

Thanks,

Ron

CREATE USER %s WITH PASSWORD %s;