Jan Zyka
Jan Zyka

Reputation: 17898

How to secure KDB/Q web interface

I am aware of the fact that we can run a Q process with the -p parameter which enables other instances to connect to it and enables also a web interface on that port.

Is there a way how to secure the connection so there will be some kind of authorization? In the moment I don't like the fact that anyone can view and even execute queries on my database when it is running with the -p parameter.

Upvotes: 4

Views: 1502

Answers (2)

Aaron Davies
Aaron Davies

Reputation: 1230

there's also the .z.pw and .z.ac hooks, which can be used for more complex auth logic

Upvotes: 4

algolicious
algolicious

Reputation: 1192

You can add authentication by using -U:

-U /path/to/password.txt 

This file contains user:password where password is result of in q md5"password" and strip off 0x in front.

Upvotes: 5

Related Questions