starred/cloudbeaver

Fork 0

mirror of https://github.com/dbeaver/cloudbeaver.git synced 2026-04-25 05:36:14 +03:00

[GH-ISSUE #23] data-sources not working #13

New issue

Closed

opened 2026-03-07 20:43:41 +03:00 by kerem · 10 comments

kerem commented

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

Owner

Originally created by @FreeSoftwareServers on GitHub (Apr 28, 2020).
Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/23

Please, describe your question in details.
I'm trying to setup pre-defined data-sources. I installed dbeaver and created a connection, copied the config and tried my best to get it to work but I continue to get the following error:

Can anybody give me an example/see what I'm doing wrong? Thanks!

Exception while fetching data (/navGetStructContainers) : null

PWD=/opt/cloudbeaver/cloudbeaver/deploy/cloudbeaver/workspace/GlobalConfiguration/.dbeaver/
cd $PWD
cat << 'EOF' >data-sources-postgresql.json
{
        "folders": {},
        "connections": {
                "postgres-jdbc-171bee20d7c-272dcd5ad2bbe925": {
                        "provider": "postgresql",
                        "driver": "postgres-jdbc",
                        "name": "PostgreSQL - postgres",
                        "save-password": false,
                        "show-system-objects": false,
                        "read-only": false,
                        "configuration": {
                                "host": "127.0.0.1",
                                "port": "5432",
                                "database": "postgres",
                                "url": "jdbc:postgresql://localhost:5432/",
                                "type": "prod",
                                "properties": {
                                        "connectTimeout": "20",
                                        "loginTimeout": "20"
                                },
                                "auth-model": "native",
                                "handlers": {}
                        }
                }
        },
        "connection-types": {
                "prod": {
                        "name": "Production",
                        "color": "247,159,129",
                        "description": "Production database",
                        "auto-commit": false,
                        "confirm-execute": true,
                        "confirm-data-change": true
                }
        }
}
EOF
systemctl restart cloudbeaver

Originally created by @FreeSoftwareServers on GitHub (Apr 28, 2020). Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/23 Please, describe your question in details. I'm trying to setup pre-defined data-sources. I installed dbeaver and created a connection, copied the config and tried my best to get it to work but I continue to get the following error: Can anybody give me an example/see what I'm doing wrong? Thanks! ![DB_error](https://user-images.githubusercontent.com/16218200/80445511-58552300-88c9-11ea-81e8-a6423441b2ab.png) `Exception while fetching data (/navGetStructContainers) : null` ``` PWD=/opt/cloudbeaver/cloudbeaver/deploy/cloudbeaver/workspace/GlobalConfiguration/.dbeaver/ cd $PWD cat << 'EOF' >data-sources-postgresql.json { "folders": {}, "connections": { "postgres-jdbc-171bee20d7c-272dcd5ad2bbe925": { "provider": "postgresql", "driver": "postgres-jdbc", "name": "PostgreSQL - postgres", "save-password": false, "show-system-objects": false, "read-only": false, "configuration": { "host": "127.0.0.1", "port": "5432", "database": "postgres", "url": "jdbc:postgresql://localhost:5432/", "type": "prod", "properties": { "connectTimeout": "20", "loginTimeout": "20" }, "auth-model": "native", "handlers": {} } } }, "connection-types": { "prod": { "name": "Production", "color": "247,159,129", "description": "Production database", "auto-commit": false, "confirm-execute": true, "confirm-data-change": true } } } EOF systemctl restart cloudbeaver ```

kerem closed this issue

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

kerem commented

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

Author

Owner

@Wroud commented on GitHub (Apr 28, 2020):

it's a known issue, we work on it, it's not related with configuration

@Wroud commented on GitHub (Apr 28, 2020): it's a known issue, we work on it, it's not related with configuration

kerem commented

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

Author

Owner

@serge-rider commented on GitHub (Apr 28, 2020):

@FreeSoftwareServers could you check server log?
Steps to reproduce in UI would be helpful too.

@serge-rider commented on GitHub (Apr 28, 2020): @FreeSoftwareServers could you check server log? Steps to reproduce in UI would be helpful too.

kerem referenced this issue

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

[GH-ISSUE #24] Can you package cloudbeaver with Docker and Docker compose? #14

kerem commented

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

Author

Owner

@FreeSoftwareServers commented on GitHub (Apr 28, 2020):

@serge-rider I don't know where to find logs just yet, would help me with debugging, but seems @Wroud says it's a bug/known issue atm. (Though I didn't see a issue tracker created). Basically to reproduce, setup a PostgreSQL DB on localhost that you can connect to and then create the `data-sources*.json* and restart the CB server. It should auto load the data-source and in my case gave the above error. Does that make sense? The goal is to pre-define the connections I want so I don't have to add them each time.

@FreeSoftwareServers commented on GitHub (Apr 28, 2020): @serge-rider I don't know where to find logs just yet, would help me with debugging, but seems @Wroud says it's a bug/known issue atm. (Though I didn't see a issue tracker created). Basically to reproduce, setup a PostgreSQL DB on localhost that you can connect to and then create the `data-sources*.json* and restart the CB server. It should auto load the data-source and in my case gave the above error. Does that make sense? The goal is to pre-define the connections I want so I don't have to add them each time.

kerem referenced this issue

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

[GH-ISSUE #24] Can you package cloudbeaver with Docker and Docker compose? #14

kerem commented

2026-03-07 20:43:43 +03:00

Author

Owner

@FreeSoftwareServers commented on GitHub (Apr 28, 2020):

@Wroud I noticed the driver field was blank, perhaps that is related? (In the UI behind the error)

@FreeSoftwareServers commented on GitHub (Apr 28, 2020): @Wroud I noticed the `driver` field was blank, perhaps that is related? (In the UI behind the error)

kerem commented

2026-03-07 20:43:43 +03:00

Author

Owner

@Wroud commented on GitHub (Apr 28, 2020):

it's can be helpful if you can find this request (query navGetStruct Containers) and send which variables are sent to the backend

also, it's probably related with empty driver field like you said

@Wroud commented on GitHub (Apr 28, 2020): it's can be helpful if you can find this request (`query navGetStruct Containers`) and send which variables are sent to the backend ![image](https://user-images.githubusercontent.com/811729/80539053-772de500-89af-11ea-9f83-93852abb38b0.png) also, it's probably related with empty driver field like you said

kerem commented

2026-03-07 20:43:43 +03:00

Author

Owner

@serge-rider commented on GitHub (Apr 28, 2020):

@FreeSoftwareServers well, default server run script doesn't dump logs anywhere, just flushed everything into stdout (we are working on proper logging configuration). If you start server from console you can see logs on screen.

@serge-rider commented on GitHub (Apr 28, 2020): @FreeSoftwareServers well, default server run script doesn't dump logs anywhere, just flushed everything into stdout (we are working on proper logging configuration). If you start server from console you can see logs on screen.

kerem commented

2026-03-07 20:43:43 +03:00

Author

Owner

@Wroud commented on GitHub (Apr 28, 2020):

I'm pushed a fix for object tabs, so request leading to the error now sends only for SQL-editor, probably error will still occur for SQL-editor

@Wroud commented on GitHub (Apr 28, 2020): I'm pushed a fix for object tabs, so request leading to the error now sends only for SQL-editor, probably error will still occur for SQL-editor

kerem commented

2026-03-07 20:43:43 +03:00

Author

Owner

@FreeSoftwareServers commented on GitHub (Apr 28, 2020):

@serge-rider I forgot, I actually had trouble getting it to run "silently" lol, used systemd and &, but I'll start it manually for debugging next time and post logs.

@FreeSoftwareServers commented on GitHub (Apr 28, 2020): @serge-rider I forgot, I actually had trouble getting it to run "silently" lol, used systemd and `&`, but I'll start it manually for debugging next time and post logs.

kerem commented

2026-03-07 20:43:43 +03:00

Author

Owner

@allenyu6 commented on GitHub (May 21, 2020):

was this fixed? can we try out postgres and mysql? can someone post an example here if we have those done and working? Thanks!

@allenyu6 commented on GitHub (May 21, 2020): was this fixed? can we try out postgres and mysql? can someone post an example here if we have those done and working? Thanks!

kerem commented

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

Author

Owner

@serge-rider commented on GitHub (May 25, 2020):

@allenyu6 There are several different and unrelated issues in this ticket. So I'm not quite sure what exactly are you asking about

Datasources configuration was fixed, now it supports folders and all other options.
If it still doesn't work for you - please create separate ticket.

@serge-rider commented on GitHub (May 25, 2020): @allenyu6 There are several different and unrelated issues in this ticket. So I'm not quite sure what exactly are you asking about Datasources configuration was fixed, now it supports folders and all other options. If it still doesn't work for you - please create separate ticket.

kerem referenced this issue

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

[PR #16] [CLOSED] WIP: Add Docker support #1386