starred/cloudbeaver

Fork 0

mirror of https://github.com/dbeaver/cloudbeaver.git synced 2026-04-25 13:46:02 +03:00

[GH-ISSUE #1442] How to apply navigationTree: childrenLimit on CB Comm AMI from AWS #317

New issue

Closed

opened 2026-03-07 20:47:40 +03:00 by kerem · 6 comments

kerem commented

2026-03-07 20:47:40 +03:00

Owner

Originally created by @amorcomb-west on GitHub (Jan 30, 2023).
Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/1442

Originally assigned to: @devnaumov on GitHub.

"Elements are limited to 500 items"

This is the same request as cloudbeaver/issues/387 and others. The 500 limit is too restrictive.

Describe the solution you'd like
This value should be configurable in the UI by an admin.

The proposed solution (supplied in prior Issues) is to update product.conf. Using the package CB that is distributed in the AWS Marketplace there is no clear path to do this. On my server there are 4 versions of this file distributed in the filesystem as follows:

/var/lib/docker/overlay2/.../diff/opt/cloudbeaver/conf
etc.

Furthermore, after updating that value to something larger than 500 (in my case 5000) and then restarting nginx, I see no difference in behavior. There is still a hard limit to displaying more than 500 children items in the navigation tree.

Please provide clear instructions for effecting this behavior using the packaged image provided in the marketplace.

Originally created by @amorcomb-west on GitHub (Jan 30, 2023). Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/1442 Originally assigned to: @devnaumov on GitHub. "Elements are limited to 500 items" This is the same request as cloudbeaver/issues/387 and others. The 500 limit is too restrictive. **Describe the solution you'd like** This value should be configurable in the UI by an admin. The proposed solution (supplied in prior Issues) is to update product.conf. _Using the package CB that is distributed in the AWS Marketplace there is no clear path to do this_. On my server there are **4** versions of this file distributed in the filesystem as follows: /var/lib/docker/overlay2/.../diff/opt/cloudbeaver/conf etc. Furthermore, after updating that value to something larger than 500 (in my case 5000) and then restarting nginx, I see no difference in behavior. There is still a hard limit to displaying more than 500 children items in the navigation tree. Please provide clear instructions for effecting this behavior using the packaged image provided in the marketplace.

kerem closed this issue

2026-03-07 20:47:40 +03:00

kerem commented

2026-03-07 20:47:41 +03:00

Author

Owner

@devnaumov commented on GitHub (Feb 1, 2023):

You can change the value in the product.conf (conf/product.conf)
The example of the configuration:

app: {
    navigationTree: {
        childrenLimit: 1000
    }
}

Make sure to restart the server after that

@devnaumov commented on GitHub (Feb 1, 2023): You can change the value in the product.conf (```conf/product.conf```) The example of the configuration: ``` app: { navigationTree: { childrenLimit: 1000 } } ``` Make sure to restart the server after that

kerem commented

2026-03-07 20:47:41 +03:00

Author

Owner

@amorcomb-west commented on GitHub (Feb 1, 2023):

Thanks for the response. As stated in the original query, I have updated the file in all 4 places and restarted nginx.

What would be helpful is to post which of the 4 files I should care about and further why updating that file had no impact on the behavior after restart.

--- content of product.conf (1 of 4) ---
// Product configuration. Customized web application behavior
// It is in JSONC format
{
// Global properties
core: {
// User defaults
user: {
defaultTheme: "light",
defaultLanguage: "en"
},
app: {
// Log viewer config
logViewer: {
refreshTimeout: 3000,
logBatchSize: 1000,
maxLogRecords: 2000,
maxFailedRequests: 3
},
navigationTree: {
childrenLimit: 5000
}
},
authentication: {
primaryAuthProvider: 'local'
}
},
// Notifications config
core_events: {
notificationsPool: 5
},
plugin_data_spreadsheet_new: {
hidden: false
},
plugin_data_export: {
disabled: false
}
}

--- paths of product.conf files ---
/var/lib/docker/overlay2/59d54fec32a6f63653f6cce835480cba8ac6a56a0d35947294dd2913daa8ef22/diff/opt/cloudbeaver/conf/product.conf
/var/lib/docker/overlay2/ac92948a2dfc1fa40bf0eb6dc92935aaf20cec1078451e8ba7f6276e548e4560/diff/opt/cloudbeaver/conf/product.conf
/var/lib/docker/overlay2/ac92948a2dfc1fa40bf0eb6dc92935aaf20cec1078451e8ba7f6276e548e4560/merged/opt/cloudbeaver/conf/product.conf
/var/lib/docker/overlay2/b6de647e3427556cd7235fd9c501a8f64fbb771aeaed271186d8790a1b306adf/diff/opt/cloudbeaver/conf/product.conf
/var/lib/docker/overlay2/38149e5e0232e88cb9d966848be2fba1b42cc18edbe63a56f5ca3e7bcbb69540/diff/opt/cloudbeaver/conf/product.conf

nginx -t
systemctl restart nginx

@amorcomb-west commented on GitHub (Feb 1, 2023): Thanks for the response. As stated in the original query, I have updated the file in all 4 places and restarted nginx. What would be helpful is to post **which** of the 4 files I should care about and further why updating that file had no impact on the behavior after restart. --- content of product.conf (1 of 4) --- // Product configuration. Customized web application behavior // It is in JSONC format { // Global properties core: { // User defaults user: { defaultTheme: "light", defaultLanguage: "en" }, app: { // Log viewer config logViewer: { refreshTimeout: 3000, logBatchSize: 1000, maxLogRecords: 2000, maxFailedRequests: 3 }, navigationTree: { childrenLimit: 5000 } }, authentication: { primaryAuthProvider: 'local' } }, // Notifications config core_events: { notificationsPool: 5 }, plugin_data_spreadsheet_new: { hidden: false }, plugin_data_export: { disabled: false } } --- paths of product.conf files --- /var/lib/docker/overlay2/59d54fec32a6f63653f6cce835480cba8ac6a56a0d35947294dd2913daa8ef22/diff/opt/cloudbeaver/conf/product.conf /var/lib/docker/overlay2/ac92948a2dfc1fa40bf0eb6dc92935aaf20cec1078451e8ba7f6276e548e4560/diff/opt/cloudbeaver/conf/product.conf /var/lib/docker/overlay2/ac92948a2dfc1fa40bf0eb6dc92935aaf20cec1078451e8ba7f6276e548e4560/merged/opt/cloudbeaver/conf/product.conf /var/lib/docker/overlay2/b6de647e3427556cd7235fd9c501a8f64fbb771aeaed271186d8790a1b306adf/diff/opt/cloudbeaver/conf/product.conf /var/lib/docker/overlay2/38149e5e0232e88cb9d966848be2fba1b42cc18edbe63a56f5ca3e7bcbb69540/diff/opt/cloudbeaver/conf/product.conf --- > nginx -t > systemctl restart nginx <img width="240" alt="image" src="https://user-images.githubusercontent.com/29930690/216123960-a12aba15-7aec-455d-a20c-c7ae670e046c.png">

kerem commented

2026-03-07 20:47:41 +03:00

Author

Owner

@devnaumov commented on GitHub (Feb 5, 2023):

Please ensure that you are restarting the CloudBeaver server, not Nginx. Additionally, try running the following command to determine the location of your volume. Once the volume has been determined, change the configuration there.
docker inspect -f '{{ range .Mounts }}{{ println .Source }}{{ end }}' cloudbeaver-container-name

@devnaumov commented on GitHub (Feb 5, 2023): Please ensure that you are restarting the CloudBeaver server, not Nginx. Additionally, try running the following command to determine the location of your volume. Once the volume has been determined, change the configuration there. ```docker inspect -f '{{ range .Mounts }}{{ println .Source }}{{ end }}' cloudbeaver-container-name```

kerem commented

2026-03-07 20:47:41 +03:00

Author

Owner

@amorcomb-west commented on GitHub (Feb 6, 2023):

Thanks for the information. Where is the documentation on how to 'restart the CloudBeaver server"?

@amorcomb-west commented on GitHub (Feb 6, 2023): Thanks for the information. Where is the documentation on how to 'restart the CloudBeaver server"?

kerem commented

2026-03-07 20:47:42 +03:00

Author

Owner

@devnaumov commented on GitHub (Feb 8, 2023):

Run docker ps to see your running containers. Find the CloudBeaver one and then run docker restart [my_container]

@devnaumov commented on GitHub (Feb 8, 2023): Run ```docker ps``` to see your running containers. Find the CloudBeaver one and then run ```docker restart [my_container]```

kerem commented

2026-03-07 20:47:42 +03:00

Author

Owner

@amorcomb-west commented on GitHub (Feb 14, 2023):

Thank you, restarting using docker restart cloudbeaver properly picked up the change in product.conf

Note that
docker inspect -f '{{ range .Mounts }}{{ println .Source }}{{ end }}' cloudbeaver
returns
/var/cloudbeaver/workspace

However there are no .conf files located under that path. Therefore I can only conclude that one of the product.conf files under the /var/lib/docker/overlay2/ dir contains the active config. I can determine which one is active through trial and error, but it would be preferable to have a definitive command to determine which is active.

@amorcomb-west commented on GitHub (Feb 14, 2023): Thank you, restarting using `docker restart cloudbeaver` properly picked up the change in product.conf Note that `docker inspect -f '{{ range .Mounts }}{{ println .Source }}{{ end }}' cloudbeaver ` returns /var/cloudbeaver/workspace However there are **no** .conf files located under that path. Therefore I can only conclude that one of the product.conf files under the /var/lib/docker/overlay2/ dir contains the active config. I can determine which one is active through trial and error, but it would be preferable to have a definitive command to determine which is active.

kerem referenced this issue

2026-03-07 21:04:50 +03:00

[PR #317] [MERGED] Feat/gis #1610