starred/cloudbeaver

Fork 0

mirror of https://github.com/dbeaver/cloudbeaver.git synced 2026-04-25 21:56:01 +03:00

[GH-ISSUE #285] Configure system objects visibility for connections #78

New issue

Closed

opened 2026-03-07 20:44:31 +03:00 by kerem · 11 comments

kerem commented

2026-03-07 20:44:31 +03:00

Owner

Originally created by @EricPE69 on GitHub (Feb 10, 2021).
Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/285

Originally assigned to: @devnaumov on GitHub.

Describe the bug
I access a mysql database (8.0.19) with the root user. i only see the sys database; I do not see mysql, performance_schema and information_schema even if I set it in database parameter.

To Reproduce
Steps to reproduce the behavior:
Access a mysql database (v8) with root user.

Screenshots

Desktop (please complete the following information):

docker image 20.0.3
Browser : chrome
Version 87

Originally created by @EricPE69 on GitHub (Feb 10, 2021). Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/285 Originally assigned to: @devnaumov on GitHub. **Describe the bug** I access a mysql database (8.0.19) with the root user. i only see the sys database; I do not see mysql, performance_schema and information_schema even if I set it in database parameter. **To Reproduce** Steps to reproduce the behavior: Access a mysql database (v8) with root user. **Screenshots** ![2021-02-10 17_26_45-CloudBeaver](https://user-images.githubusercontent.com/39956814/107539852-aa9bd200-6bc5-11eb-96a1-9ef4f304e2f7.png) ![2021-02-10 17_25_51-CloudBeaver](https://user-images.githubusercontent.com/39956814/107539882-b5566700-6bc5-11eb-97be-f3224c5a78da.png) **Desktop (please complete the following information):** - docker image 20.0.3 - Browser : chrome - Version 87

kerem closed this issue

2026-03-07 20:44:31 +03:00

kerem commented

2026-03-07 20:44:32 +03:00

Author

Owner

@kseniiaguzeeva commented on GitHub (Feb 15, 2021):

Unfortunately I cannot reproduce it. Do you enter a schema in the connection settings?

Can you see other schemas when use other clients (e.g. DBeaver https://dbeaver.io/download/)?

@kseniiaguzeeva commented on GitHub (Feb 15, 2021): Unfortunately I cannot reproduce it. Do you enter a schema in the connection settings? ![chrome_bWAm6nodkF](https://user-images.githubusercontent.com/51405061/107942608-86ad0780-6f9c-11eb-8b8d-b9122a46db89.png) Can you see other schemas when use other clients (e.g. DBeaver https://dbeaver.io/download/)?

kerem commented

2026-03-07 20:44:32 +03:00

Author

Owner

@EricPE69 commented on GitHub (Feb 15, 2021):

No, I do not enter schema in the connection settings.
Yes, with adminer or dbeaver I see all the schemas (see screenshot)

@EricPE69 commented on GitHub (Feb 15, 2021): No, I do not enter schema in the connection settings. Yes, with adminer or dbeaver I see all the schemas (see screenshot) ![2021-02-15 13_37_24-Window](https://user-images.githubusercontent.com/39956814/107947684-03d37f00-6f93-11eb-8626-4f984df19047.png)

kerem commented

2026-03-07 20:44:33 +03:00

Author

Owner

@kseniiaguzeeva commented on GitHub (Feb 15, 2021):

Thank you for the additional info. Looking for steps to reproduce.

@kseniiaguzeeva commented on GitHub (Feb 15, 2021): Thank you for the additional info. Looking for steps to reproduce.

kerem commented

2026-03-07 20:44:33 +03:00

Author

Owner

@kseniiaguzeeva commented on GitHub (Feb 16, 2021):

Can you login as admin? If yes, please go to Administration menu>Server configuration and check whether Navigator simple view is enabled.

If yes, disable it and recreate the connection.

@kseniiaguzeeva commented on GitHub (Feb 16, 2021): Can you login as admin? If yes, please go to Administration menu>Server configuration and check whether Navigator simple view is enabled. ![Screenshot 2021-02-16 at 12 49 11](https://user-images.githubusercontent.com/51405061/108046973-4e69ff80-7056-11eb-88d4-da99c3902a68.png) If yes, disable it and recreate the connection.

kerem commented

2026-03-07 20:44:33 +03:00

Author

Owner

@EricPE69 commented on GitHub (Feb 16, 2021):

No, Navigator simple view is not enabled.

@EricPE69 commented on GitHub (Feb 16, 2021): No, Navigator simple view is not enabled. ![2021-02-16 11_14_13-Window](https://user-images.githubusercontent.com/39956814/108049297-5e7ae280-7048-11eb-87cb-475a7528ff2c.png)

kerem commented

2026-03-07 20:44:33 +03:00

Author

Owner

@serge-rider commented on GitHub (Feb 17, 2021):

By default you system objects are hidden in CloudBeaver.
We plan add this configuration option in one of the next versions (in DBeaver it is shown as "Show system objects" setting on connection settings page).

Workaround: you can change connection config manually by editing file data-sources.json file. It can be found in CloudBeaver workspace folder in GlobalConfiguration/.dbeaver or user-projects/USER/.dbeaver.
Find you connection config there and add elemnt "show-system-objects": true somewhere after "name": "...".
Restart CloudBeaver server - now you can see system objects.

@serge-rider commented on GitHub (Feb 17, 2021): By default you system objects are hidden in CloudBeaver. We plan add this configuration option in one of the next versions (in DBeaver it is shown as "Show system objects" setting on connection settings page). Workaround: you can change connection config manually by editing file `data-sources.json` file. It can be found in CloudBeaver workspace folder in `GlobalConfiguration/.dbeaver` or `user-projects/USER/.dbeaver`. Find you connection config there and add elemnt `"show-system-objects": true` somewhere after "name": "...". Restart CloudBeaver server - now you can see system objects.

kerem commented

2026-03-07 20:44:33 +03:00

Author

Owner

@EricPE69 commented on GitHub (Feb 18, 2021):

I add a connection with "show-system-objects": true in data-sources.json file (see joined file).
For information to see this connection in the GUI I had to connect with the admin user, otherwise I do not see it.
But with this connection it does not change anything: I still only see the sys database.

data-sources.json.txt

@EricPE69 commented on GitHub (Feb 18, 2021): I add a connection with "show-system-objects": true in data-sources.json file (see joined file). For information to see this connection in the GUI I had to connect with the admin user, otherwise I do not see it. But with this connection it does not change anything: I still only see the sys database. [data-sources.json.txt](https://github.com/dbeaver/cloudbeaver/files/6003512/data-sources.json.txt)

kerem commented

2026-03-07 20:44:33 +03:00

Author

Owner

@kseniiaguzeeva commented on GitHub (Feb 20, 2021):

Thank you for the additional details. We will add the option to see system objects to the next release.

@kseniiaguzeeva commented on GitHub (Feb 20, 2021): Thank you for the additional details. We will add the option to see system objects to the next release.

kerem commented

2026-03-07 20:44:33 +03:00

Author

Owner

@EricPE69 commented on GitHub (Feb 22, 2021):

Ok,

Thank you.

@EricPE69 commented on GitHub (Feb 22, 2021): Ok, Thank you.

kerem commented

2026-03-07 20:44:33 +03:00

Author

Owner

@Wroud commented on GitHub (Apr 1, 2021):

Hello. great news we released 20.0.6, where we implemented this feature!

@Wroud commented on GitHub (Apr 1, 2021): Hello. great news we released 20.0.6, where we implemented this feature! ![image](https://user-images.githubusercontent.com/811729/113263454-777ae280-92da-11eb-88bb-318f372dcc05.png)

kerem commented

2026-03-07 20:44:33 +03:00

Author

Owner

@EricPE69 commented on GitHub (Apr 6, 2021):

Hello,

It works,
Thank you

@EricPE69 commented on GitHub (Apr 6, 2021): Hello, It works, Thank you

kerem referenced this issue

2026-03-07 21:03:58 +03:00

[PR #78] [MERGED] fix(core): connection picker #1432