Search code examples
kdb

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.

Solution

  • 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.