Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to secure KDB/Q web interface

Tags:

kdb

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.

like image 847
Jan Zyka Avatar asked Jan 18 '23 06:01

Jan Zyka


1 Answers

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.

like image 59
algolicious Avatar answered Feb 16 '23 18:02

algolicious