ob-operator icon indicating copy to clipboard operation
ob-operator copied to clipboard

[Feature]: open connection in odc sql console for clusters and tenants

Open yizhouxw opened this issue 1 year ago • 1 comments

Describe your use case

open connection in odc sql console for cluster and tenants.

Describe the solution you'd like

we can see clusters and tenants in ob-operator console dashboard. and now mysql command line windows is embeded in cluster page.

what if open connection in odc sql console!

  • connect to sys tenant use root user for cluster
  • connect to business tenant with selected user

infact odc has ready for integration now, legerage odc bastion integraiton, we can use http url paramter to transfer datasource info. refer details from https://www.oceanbase.com/docs/common-odc-1000000000672287

Describe alternatives you've considered

No response

Additional context

No response

yizhouxw avatar May 14 '24 13:05 yizhouxw

If everything goes well we will add it in version 0.3.0 of oceanbase-dashboard, otherwise it will be in version 0.4.0

chris-sun-star avatar May 15 '24 12:05 chris-sun-star

After the ODC server is deployed, set environment ODC_URL of Dashboard to base url of ODC server like http://xx.xx.xx.xx:yyyy (or set the variable through PATCH /api/v1/info w/o restarting Dashboard pod). A new button to open temporary connection through ODC will appear in Connection panel like PR #454 demonstrates.

powerfooI avatar Jun 19 '24 06:06 powerfooI

Notes: The ODC_URL will be visited in users' browsers, so make sure the URL is accessible.

powerfooI avatar Jun 19 '24 06:06 powerfooI