Crate SQL query using curl with basic access authentication

Question

From the crate.io documentation I am told that an SQL query can be performed like this:

curl -sSXPOST 'CLUSTER_IP:4200/_sql?pretty' -d '{"stmt":"select name from sys.cluster"}'

The database I am trying to connect to requires a username and password:

How can I build this authentication into the curl call? I have tried several variants of things I found online with no success. The error I keep seeing looks like this:

score 1 · Answer 1 · answered Jan 06 '17 at 23:19

1

Out of the box CrateDB does not provide any authentication. Maybe you are running a HTTP Proxy or loadbalancer with authentication in front of it? NGINX? Try to connect to one of the CrateDB servers instead.

answered Jan 06 '17 at 23:19

Jodok Batlogg

373
1
9

Thanks for the advice. I'll have to ask the person who created the database I think. – Alex Jan 07 '17 at 00:19
You are correct. Turns out it's a Reverse Proxy using NGINX with HTTP Basic Authentication. – Alex Jan 09 '17 at 18:09

score 1 · Answer 2 · answered Jan 09 '17 at 18:15

1

The query worked when I included the login credentials as follows:

curl -sSXPOST 'username:password@hostname:port/_sql?pretty' -d '{"stmt":"select name from sys.cluster"}'

answered Jan 09 '17 at 18:15

Alex

12,078
6
64
74

Crate SQL query using curl with basic access authentication

2 Answers2