Accessing CrateDB Admin UI behind Ingress #777

Activity

1. amotl commented on Sep 14, 2022

   

   amotl

   on Sep 14, 2022

   Contributor

   More actions

   Dear Arjun,

   thank you for writing in.

   In general, the Admin UI itself can be hosted on any path. However, it has to know about the CrateDB HTTP API endpoint, usually available at /_sql.

   I have set up an ingress to access the admin UI on path /db.

   I see. So, the HTTP API endpoint of CrateDB itself would also be available at /db/_sql?

   At [1], I've referenced the utility function which computes the base URI used to access the database HTTP API. We will have to check if that would need corresponding adjustments.

   With kind regards,
   Andreas.

   [1]

   crate-admin/app/scripts/services/sql.js

   Lines 20 to 40 in 83e2a3a

   	.factory('baseURI', function() {
   	var baseURI = {};
   	baseURI.getWindowLocation = function() {
   	return window.location;
   	};
   	baseURI.getURI = function(path) {
   	var basePath;
   	var loc = baseURI.getWindowLocation();
   	var uriParam = loc.search.match(/([\?|&])base_uri=([^&]+)/);
   	if (!uriParam) {
   	basePath = loc.protocol + '//' + loc.host + loc.pathname;
   	} else {
   	basePath = uriParam[2];
   	}
   	// remove trailing slash from base path and append path
   	return basePath.replace(/\/+$/, '') + path;
   	};
   	return baseURI;
   	})
2. amotl commented on Sep 14, 2022

   

   amotl

   on Sep 14, 2022

   Contributor

   More actions

   Hi again,

   I've added an example at ¹, which outlines how to configure Nginx to reverse-proxy the CrateDB HTTP API endpoint to the /db subdirectory. The nginx.conf is at ². Maybe you can use it as an inspiration to configure the K8s Ingress component appropriately.

   With kind regards,
   Andreas.

   Footnotes

   1. https://github.com/crate/cratedb-examples/tree/main/spikes/http-api-behind-nginx ↩

   2. https://github.com/crate/cratedb-examples/blob/main/spikes/http-api-behind-nginx/nginx.conf ↩
3. amotl commented on Sep 29, 2022

   

   amotl

   on Sep 29, 2022

   Contributor

   More actions

   Dear Arjun,

   are the resources referenced above helpful to you?

   With kind regards,
   Andreas.
4. seut

   added

   customer feedback

   question

   and removed

   customer feedback

   on Dec 5, 2022
5. amotl commented on Apr 3, 2026

   

   amotl

   on Apr 3, 2026

   Last edited by amotl

   Contributor

   More actions

   I have set up an ingress to access the admin UI on path /db.

   Hi again. @Kleinjohann contributed an improvement in this area just recently, in this case to the Python driver.

   • Propagate path prefix in server URLs to all requests crate-python#771

   I am also exploring similar details with vanilla Nginx, where I selected the /c URL path to serve CrateDB from. If there is anything you feel unanswered about, please let us know. On the other hand, we are interested if you have been able to make progress with a corresponding Ingress configuration. 🙏

   /cc @goat-ssh, @WalBeh