dbeaver / cloudbeaver

Cloud Database Manager
https://dbeaver.com/
Apache License 2.0
3.52k stars 382 forks source link

Run Docker Container hangs at inlog screen #2364

Closed KnurpsBram closed 8 months ago

KnurpsBram commented 9 months ago

I follow the steps at https://github.com/dbeaver/cloudbeaver/wiki/Run-Docker-Container

I run the command

export CB_LOCAL_HOST_ADDR=$(ifconfig | grep -E "([0-9]{1,3}\.){3}[0-9]{1,3}" | grep -v 127.0.0.1 | awk '{ print $2 }' | cut -f2 -d: | head -n1)

docker run --name cloudbeaver --rm -ti -p 8080:8978 --add-host=host.docker.internal:${CB_LOCAL_HOST_ADDR} -v /opt/cloudbeaver/workspace dbeaver/cloudbeaver:23.3.4

The interface at http://localhost:8080/ hangs at the loading screen.

Screenshot from 2024-02-06 17-06-02

The log shows that it's hanging at getAuthProviders

06-02-2024 16:04:46.921 [main] INFO  o.e.j.s.s.DefaultSessionIdManager - Session workerName=
06-02-2024 16:04:46.937 [main] INFO  o.e.j.server.handler.ContextHandler - Started o.e.j.s.ServletContextHandler@38e7860c{/,file:///opt/cloudbeaver/web/,AVAILABLE}
06-02-2024 16:04:46.947 [main] INFO  o.e.jetty.server.AbstractConnector - Started ServerConnector@41d16cc3{HTTP/1.1, (http/1.1)}{0.0.0.0:8978}
06-02-2024 16:04:46.948 [main] INFO  org.eclipse.jetty.server.Server - Started JettyServer@56478522{STARTING}[11.0.18,sto=0] @2498ms
06-02-2024 16:04:53.292 [qtp1095731113-50] INFO  i.c.s.w.CBJettyWebSocketManager - Websocket created for session: 1djudss1b2el0e7a8jnhhgdvk0
06-02-2024 16:04:53.332 [qtp1095731113-50] DEBUG i.c.s.websockets.CBEventsWebSocket - EventWebSocket connected to the 1djudss1b2el0e7a8jnhhgdvk0 session
06-02-2024 16:04:53.346 [qtp1095731113-48] DEBUG i.c.server.graphql.GraphQLEndpoint - API > serverConfig
06-02-2024 16:04:53.509 [qtp1095731113-53] DEBUG i.c.server.graphql.GraphQLEndpoint - API > openSession
06-02-2024 16:04:53.544 [qtp1095731113-53] DEBUG i.c.model.session.WebUserContext - refresh permissions null 74683372-4f1d-44fa-b858-fd0b963af753
06-02-2024 16:04:53.611 [qtp1095731113-58] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getActiveUser
06-02-2024 16:04:53.637 [qtp1095731113-53] DEBUG i.c.server.graphql.GraphQLEndpoint - API > sessionPermissions
06-02-2024 16:04:53.667 [qtp1095731113-58] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAuthProviders
06-02-2024 16:04:57.333 [qtp1095731113-58] DEBUG i.c.s.websockets.CBEventsWebSocket - Socket Closed: [1001] null
06-02-2024 16:04:57.441 [qtp1095731113-51] INFO  i.c.s.w.CBJettyWebSocketManager - Websocket created for session: 1djudss1b2el0e7a8jnhhgdvk0
06-02-2024 16:04:57.443 [qtp1095731113-51] DEBUG i.c.s.websockets.CBEventsWebSocket - EventWebSocket connected to the 1djudss1b2el0e7a8jnhhgdvk0 session
06-02-2024 16:04:57.494 [qtp1095731113-53] DEBUG i.c.server.graphql.GraphQLEndpoint - API > serverConfig
06-02-2024 16:04:57.554 [qtp1095731113-50] DEBUG i.c.server.graphql.GraphQLEndpoint - API > openSession
06-02-2024 16:04:57.581 [qtp1095731113-53] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getActiveUser
06-02-2024 16:04:57.600 [qtp1095731113-50] DEBUG i.c.server.graphql.GraphQLEndpoint - API > sessionPermissions
06-02-2024 16:04:57.628 [qtp1095731113-53] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAuthProviders

Any pointers into what could be going on are greatly appreciated

EvgeniaBzzz commented 9 months ago

Hi @KnurpsBram Could you, please, provide us with the whole devtools log?

EvgeniaBzzz commented 9 months ago

Also, please, try to run CloudBeaver in the incognito mode (it could be some cache issue)

KnurpsBram commented 9 months ago

Here's the full log

docker run --name cloudbeaver --rm -ti -p 8080:8978 --add-host=host.docker.internal:${CB_LOCAL_HOST_ADDR} -v /opt/cloudbeaver/workspace dbeaver/cloudbeaver:23.3.4
Starting Cloudbeaver Server
WARNING: Using incubator modules: jdk.incubator.vector, jdk.incubator.foreign
07-02-2024 06:36:54.785 [main] DEBUG i.c.model.app.BaseWebApplication - Loading configuration from /opt/cloudbeaver/conf/cloudbeaver.conf
07-02-2024 06:36:54.787 [main] DEBUG io.cloudbeaver.server.CBApplication - Using configuration [/opt/cloudbeaver/conf/cloudbeaver.conf]
07-02-2024 06:36:54.787 [main] DEBUG io.cloudbeaver.server.CBApplication - Read configuration [/opt/cloudbeaver/conf/cloudbeaver.conf]
07-02-2024 06:36:54.809 [main] DEBUG io.cloudbeaver.server.CBApplication - Load product configuration from '/opt/cloudbeaver/conf/product.conf'
07-02-2024 06:36:54.813 [main] DEBUG io.cloudbeaver.server.CBApplication - CloudBeaver CE Server 23.3.4.202402051107 is starting
07-02-2024 06:36:54.813 [main] DEBUG io.cloudbeaver.server.CBApplication -  OS: Linux 5.15.0-92-generic (amd64)
07-02-2024 06:36:54.813 [main] DEBUG io.cloudbeaver.server.CBApplication -  Java version: 17.0.10 by Eclipse Adoptium (64bit)
07-02-2024 06:36:54.813 [main] DEBUG io.cloudbeaver.server.CBApplication -  Install path: '/opt/cloudbeaver/server'
07-02-2024 06:36:54.813 [main] DEBUG io.cloudbeaver.server.CBApplication -  Global workspace: 'file:/opt/cloudbeaver/workspace/'
07-02-2024 06:36:54.815 [main] DEBUG io.cloudbeaver.server.CBApplication -  Memory available 248Mb/3904Mb
07-02-2024 06:36:54.820 [main] INFO  io.cloudbeaver.server.CBPlatform - Initialize web platform...
07-02-2024 06:36:54.926 [main] DEBUG o.j.d.runtime.SecurityProviderUtils - BounceCastle bundle found. Use JCE provider BC
07-02-2024 06:36:55.072 [main] DEBUG o.j.d.registry.BasePlatformImpl - Initialize base platform...
07-02-2024 06:36:55.180 [main] DEBUG o.j.d.r.DataSourceProviderDescriptor - Script dialect 'cubrid' not found in registry (for data source provider cubrid). Use default.
07-02-2024 06:36:55.227 [main] DEBUG o.j.d.r.DataSourceProviderRegistry - Total database drivers: 110 (110)
07-02-2024 06:36:55.232 [main] ERROR io.cloudbeaver.server.CBPlatform -     Driver 'yandex_clickhouse' is missing library 'ru.yandex.clickhouse:clickhouse-jdbc:RELEASE'
07-02-2024 06:36:55.235 [main] INFO  io.cloudbeaver.server.CBPlatform - Available drivers: ClickHouse,Db2 for LUW,Db2 for IBM i,Firebird,DuckDB,Trino,H2 Embedded,H2 Embedded V.2,MS SQL Server / SQL Server,MySQL,MariaDB,Oracle,PostgreSQL,SQLite
07-02-2024 06:36:55.237 [main] INFO  io.cloudbeaver.server.CBPlatform - Web platform initialized (417ms)
07-02-2024 06:36:55.238 [main] DEBUG io.cloudbeaver.server.CBApplication -  Content root: /opt/cloudbeaver/web
07-02-2024 06:36:55.238 [main] DEBUG io.cloudbeaver.server.CBApplication -  Drivers storage: /opt/cloudbeaver/drivers
07-02-2024 06:36:55.240 [main] DEBUG io.cloudbeaver.server.CBApplication -  Listen port: 8978 on all interfaces
07-02-2024 06:36:55.240 [main] DEBUG io.cloudbeaver.server.CBApplication -  Base URI: /api/
07-02-2024 06:36:55.240 [main] DEBUG io.cloudbeaver.server.CBApplication -  Production mode
07-02-2024 06:36:55.240 [main] DEBUG io.cloudbeaver.server.CBApplication -  Server is in configuration mode!
07-02-2024 06:36:55.240 [main] DEBUG io.cloudbeaver.server.CBApplication -  Run in Docker container (host.docker.internal/172.17.0.1)?
07-02-2024 06:36:55.241 [main] DEBUG io.cloudbeaver.server.CBApplication -  Local host addresses:
07-02-2024 06:36:55.242 [main] DEBUG io.cloudbeaver.server.CBApplication -  172.17.0.1 (host.docker.internal)
07-02-2024 06:36:55.242 [main] DEBUG io.cloudbeaver.server.CBApplication -  172.17.0.2 (f9bd5d064271)
07-02-2024 06:36:55.242 [main] DEBUG io.cloudbeaver.server.CBApplication -  127.0.0.1 (localhost)
07-02-2024 06:36:55.268 [main] DEBUG io.cloudbeaver.server.CBPlatform - Initializing product: CloudBeaver CE Server 23.3.4
07-02-2024 06:36:55.268 [main] DEBUG io.cloudbeaver.server.CBPlatform - Host plugin: io.cloudbeaver.product.ce 23.3.4.202402051107
07-02-2024 06:36:55.268 [main] INFO  io.cloudbeaver.server.CBPlatform - Initialize web platform...
07-02-2024 06:36:55.270 [main] DEBUG o.j.d.registry.BasePlatformImpl - Initialize base platform...
07-02-2024 06:36:55.270 [main] ERROR io.cloudbeaver.server.CBPlatform -     Driver 'yandex_clickhouse' is missing library 'ru.yandex.clickhouse:clickhouse-jdbc:RELEASE'
07-02-2024 06:36:55.271 [main] INFO  io.cloudbeaver.server.CBPlatform - Available drivers: ClickHouse,Db2 for LUW,Db2 for IBM i,Firebird,DuckDB,Trino,H2 Embedded,H2 Embedded V.2,MS SQL Server / SQL Server,MySQL,MariaDB,Oracle,PostgreSQL,SQLite
07-02-2024 06:36:55.271 [main] INFO  io.cloudbeaver.server.CBPlatform - Web platform initialized (3ms)
07-02-2024 06:36:55.281 [main] DEBUG i.c.s.auth.ReverseProxyConfigurator - Reverse proxy provider disabled, migration not needed
07-02-2024 06:36:55.296 [main] DEBUG i.c.service.security.db.CBDatabase - Initiate management database
07-02-2024 06:36:55.318 [main] DEBUG i.c.service.security.db.CBDatabase -   Initiate connection pool with management database (H2 Embedded V.2; jdbc:h2:/opt/cloudbeaver/workspace/.data/cb.h2v2.dat)
07-02-2024 06:36:55.511 [main] DEBUG i.c.service.security.db.CBDatabase -   Connected to H2 2.1.214 (2022-06-13)
07-02-2024 06:36:55.565 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Create new schema CB
07-02-2024 06:36:55.662 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_SCHEMA_INFO
(
    VERSION     INTEGER   NOT NULL,
    UPDATE_TIME TIMESTAMP NOT NULL
)
07-02-2024 06:36:55.666 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_INSTANCE
(
    INSTANCE_ID     CHAR(36)     NOT NULL, -- Unique instance ID

    MAC_ADDRESS     CHAR(12)     NOT NULL,
    HOST_NAME       VARCHAR(128) NOT NULL,

    PRODUCT_NAME    VARCHAR(100) NOT NULL, -- Server product name
    PRODUCT_VERSION VARCHAR(32)  NOT NULL, -- Server product version

    UPDATE_TIME     TIMESTAMP    NOT NULL,

    PRIMARY KEY (INSTANCE_ID)
)
07-02-2024 06:36:55.670 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_INSTANCE_DETAILS
(
    INSTANCE_ID CHAR(36)    NOT NULL, -- Unique instance ID
    FIELD_NAME  VARCHAR(32) NOT NULL,
    FIELD_VALUE VARCHAR(255),

    PRIMARY KEY (INSTANCE_ID, FIELD_NAME),
    FOREIGN KEY (INSTANCE_ID) REFERENCES CB_INSTANCE (INSTANCE_ID)
)
07-02-2024 06:36:55.679 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_INSTANCE_EVENT
(
    EVENT_ID      BIGINT AUTO_INCREMENT NOT NULL,

    INSTANCE_ID   CHAR(36)    NOT NULL, -- Unique instance ID

    EVENT_TYPE    VARCHAR(16) NOT NULL,
    EVENT_TIME    TIMESTAMP   NOT NULL,

    EVENT_MESSAGE VARCHAR(255),

    PRIMARY KEY (EVENT_ID),
    FOREIGN KEY (INSTANCE_ID) REFERENCES CB_INSTANCE (INSTANCE_ID)
)
07-02-2024 06:36:55.684 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_WORKSPACE
(
    WORKSPACE_ID       VARCHAR(32)   NOT NULL, -- Workspace unique ID
    INSTANCE_ID        CHAR(36)      NOT NULL, -- Unique instance ID

    WORKSPACE_LOCATION VARCHAR(1024) NOT NULL,

    UPDATE_TIME        TIMESTAMP     NOT NULL,

    PRIMARY KEY (INSTANCE_ID, WORKSPACE_ID),
    FOREIGN KEY (INSTANCE_ID) REFERENCES CB_INSTANCE (INSTANCE_ID)
)
07-02-2024 06:36:55.687 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_AUTH_SUBJECT
(
    SUBJECT_ID        VARCHAR(128) NOT NULL,
    SUBJECT_TYPE      VARCHAR(8)   NOT NULL,
    IS_SECRET_STORAGE CHAR(1)      DEFAULT 'Y' NOT NULL,

    PRIMARY KEY (SUBJECT_ID)
)
07-02-2024 06:36:55.688 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_SUBJECT_META
(
    SUBJECT_ID  VARCHAR(128) NOT NULL,
    META_ID     VARCHAR(32)  NOT NULL,
    META_VALUE  VARCHAR(1024),

    UPDATE_TIME TIMESTAMP     DEFAULT CURRENT_TIMESTAMP NOT NULL,

    PRIMARY KEY (SUBJECT_ID, META_ID),
    FOREIGN KEY (SUBJECT_ID) REFERENCES CB_AUTH_SUBJECT(SUBJECT_ID) ON DELETE CASCADE
)
07-02-2024 06:36:55.692 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_AUTH_PERMISSIONS
(
    SUBJECT_ID    VARCHAR(128) NOT NULL,
    PERMISSION_ID VARCHAR(64)  NOT NULL,

    GRANT_TIME    TIMESTAMP    NOT NULL,
    GRANTED_BY    VARCHAR(128) NOT NULL,

    PRIMARY KEY (SUBJECT_ID, PERMISSION_ID),
    FOREIGN KEY (SUBJECT_ID) REFERENCES CB_AUTH_SUBJECT (SUBJECT_ID) ON DELETE CASCADE
)
07-02-2024 06:36:55.694 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_OBJECT_PERMISSIONS
(
    OBJECT_ID   VARCHAR(128) NOT NULL,
    OBJECT_TYPE VARCHAR(128) NOT NULL,
    SUBJECT_ID  VARCHAR(128) NOT NULL,

    PERMISSION  VARCHAR(32)  NOT NULL,

    GRANT_TIME  TIMESTAMP    NOT NULL,
    GRANTED_BY  VARCHAR(128) NOT NULL,

    PRIMARY KEY (SUBJECT_ID, OBJECT_TYPE, OBJECT_ID, PERMISSION),
    FOREIGN KEY (SUBJECT_ID) REFERENCES CB_AUTH_SUBJECT (SUBJECT_ID) ON DELETE CASCADE
)
07-02-2024 06:36:55.697 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_CREDENTIALS_PROFILE
(
    PROFILE_ID          VARCHAR(128) NOT NULL,
    PROFILE_NAME        VARCHAR(100) NOT NULL,
    PROFILE_DESCRIPTION VARCHAR(255) NOT NULL,
    PARENT_PROFILE_ID   VARCHAR(128) NULL,
    CREATE_TIME         TIMESTAMP    DEFAULT CURRENT_TIMESTAMP NOT NULL,

    PRIMARY KEY (PROFILE_ID),
    FOREIGN KEY (PROFILE_ID) REFERENCES CB_AUTH_SUBJECT (SUBJECT_ID) ON DELETE CASCADE,
    FOREIGN KEY (PARENT_PROFILE_ID) REFERENCES CB_CREDENTIALS_PROFILE(PROFILE_ID) ON DELETE NO ACTION
)
07-02-2024 06:36:55.700 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_USER
(
    USER_ID     VARCHAR(128) NOT NULL,
    IS_ACTIVE   CHAR(1)      NOT NULL,
    CREATE_TIME TIMESTAMP    NOT NULL,
    DEFAULT_AUTH_ROLE VARCHAR(32) NULL,
    CREDENTIALS_PROFILE_ID VARCHAR(128) NULL,

    PRIMARY KEY (USER_ID),
    FOREIGN KEY (USER_ID) REFERENCES CB_AUTH_SUBJECT (SUBJECT_ID) ON DELETE CASCADE,
    FOREIGN KEY (CREDENTIALS_PROFILE_ID) REFERENCES CB_CREDENTIALS_PROFILE(PROFILE_ID) ON DELETE NO ACTION
)
07-02-2024 06:36:55.704 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: -- Additional user properties (profile)

CREATE TABLE CB_USER_PARAMETERS
(
    USER_ID     VARCHAR(128) NOT NULL,
    PARAM_ID    VARCHAR(32)  NOT NULL,
    PARAM_VALUE VARCHAR(1024),

    PRIMARY KEY (USER_ID, PARAM_ID),
    FOREIGN KEY (USER_ID) REFERENCES CB_USER (USER_ID) ON DELETE CASCADE
)
07-02-2024 06:36:55.707 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_TEAM
(
    TEAM_ID                 VARCHAR(128) NOT NULL,
    TEAM_NAME               VARCHAR(100) NOT NULL,
    TEAM_DESCRIPTION        VARCHAR(255) NOT NULL,
    CREATE_TIME             TIMESTAMP    NOT NULL,

    PRIMARY KEY (TEAM_ID),
    FOREIGN KEY (TEAM_ID) REFERENCES CB_AUTH_SUBJECT (SUBJECT_ID) ON DELETE CASCADE
)
07-02-2024 06:36:55.709 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_EXTERNAL_TEAM
(
    TEAM_ID          VARCHAR(128) NOT NULL,
    EXTERNAL_TEAM_ID VARCHAR(128) NOT NULL,

    PRIMARY KEY (TEAM_ID,EXTERNAL_TEAM_ID),
    FOREIGN KEY (TEAM_ID) REFERENCES CB_TEAM (TEAM_ID) ON DELETE CASCADE
)
07-02-2024 06:36:55.711 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_USER_TEAM
(
    USER_ID    VARCHAR(128) NOT NULL,
    TEAM_ID    VARCHAR(128) NOT NULL,

    GRANT_TIME TIMESTAMP    NOT NULL,
    GRANTED_BY VARCHAR(128) NOT NULL,

    PRIMARY KEY (USER_ID, TEAM_ID),
    FOREIGN KEY (USER_ID) REFERENCES CB_USER (USER_ID) ON DELETE CASCADE,
    FOREIGN KEY (TEAM_ID) REFERENCES CB_TEAM (TEAM_ID) ON DELETE NO ACTION
)
07-02-2024 06:36:55.715 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_AUTH_PROVIDER
(
    PROVIDER_ID VARCHAR(32) NOT NULL,
    IS_ENABLED  CHAR(1)     NOT NULL,

    PRIMARY KEY (PROVIDER_ID)
)
07-02-2024 06:36:55.717 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_AUTH_CONFIGURATION
(
    PROVIDER_ID VARCHAR(32) NOT NULL,
    PARAM_ID    VARCHAR(32) NOT NULL,
    PARAM_VALUE VARCHAR(1024),

    PRIMARY KEY (PROVIDER_ID, PARAM_ID),
    FOREIGN KEY (PROVIDER_ID) REFERENCES CB_AUTH_PROVIDER (PROVIDER_ID) ON DELETE CASCADE
)
07-02-2024 06:36:55.719 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_USER_CREDENTIALS
(
    USER_ID     VARCHAR(128)  NOT NULL,
    PROVIDER_ID VARCHAR(32)   NOT NULL,
    CRED_ID     VARCHAR(32)   NOT NULL,
    CRED_VALUE  VARCHAR(1024) NOT NULL,

    UPDATE_TIME TIMESTAMP     DEFAULT CURRENT_TIMESTAMP NOT NULL,

    PRIMARY KEY (USER_ID, PROVIDER_ID, CRED_ID),
    FOREIGN KEY (USER_ID) REFERENCES CB_USER (USER_ID) ON DELETE CASCADE
)
07-02-2024 06:36:55.722 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE INDEX CB_USER_CREDENTIALS_SEARCH_IDX ON CB_USER_CREDENTIALS (PROVIDER_ID, CRED_ID)
07-02-2024 06:36:55.723 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_USER_STATE
(
    USER_ID            VARCHAR(128) NOT NULL,

    USER_CONFIGURATION TEXT NULL,

    UPDATE_TIME        TIMESTAMP    DEFAULT CURRENT_TIMESTAMP NOT NULL,

    PRIMARY KEY (USER_ID),
    FOREIGN KEY (USER_ID) REFERENCES CB_USER (USER_ID) ON DELETE CASCADE
)
07-02-2024 06:36:55.725 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_SESSION
(
    SESSION_ID                 VARCHAR(64) NOT NULL,
    APP_SESSION_ID             VARCHAR(64) NULL,
    USER_ID                    VARCHAR(128) NULL,

    CREATE_TIME                TIMESTAMP   NOT NULL,
    LAST_ACCESS_REMOTE_ADDRESS VARCHAR(128) NULL,
    LAST_ACCESS_USER_AGENT     VARCHAR(255) NULL,
    LAST_ACCESS_TIME           TIMESTAMP   NOT NULL,

    LAST_ACCESS_INSTANCE_ID    CHAR(36),
    SESSION_TYPE               VARCHAR(64),

    PRIMARY KEY (SESSION_ID),
    FOREIGN KEY (USER_ID) REFERENCES CB_USER (USER_ID) ON DELETE CASCADE,
    FOREIGN KEY (LAST_ACCESS_INSTANCE_ID) REFERENCES CB_INSTANCE (INSTANCE_ID)
)
07-02-2024 06:36:55.736 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_SESSION_STATE
(
    SESSION_ID    VARCHAR(64) NOT NULL,

    SESSION_STATE TEXT        NOT NULL,
    UPDATE_TIME   TIMESTAMP   NOT NULL,

    PRIMARY KEY (SESSION_ID),
    FOREIGN KEY (SESSION_ID) REFERENCES CB_SESSION (SESSION_ID) ON DELETE CASCADE
)
07-02-2024 06:36:55.738 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_SESSION_LOG
(
    SESSION_ID  VARCHAR(64)  NOT NULL,

    LOG_TIME    TIMESTAMP    NOT NULL,
    LOG_ACTION  VARCHAR(128) NOT NULL,
    LOG_DETAILS VARCHAR(255) NOT NULL,

    FOREIGN KEY (SESSION_ID) REFERENCES CB_SESSION (SESSION_ID) ON DELETE CASCADE
)
07-02-2024 06:36:55.739 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_AUTH_TOKEN
(
    TOKEN_ID                      VARCHAR(128) NOT NULL,
    REFRESH_TOKEN_ID              VARCHAR(128),
    SESSION_ID                    VARCHAR(64)  NOT NULL,
    USER_ID                       VARCHAR(128),
    AUTH_ROLE                     VARCHAR(32),

    EXPIRATION_TIME               TIMESTAMP    NOT NULL,
    REFRESH_TOKEN_EXPIRATION_TIME TIMESTAMP    DEFAULT CURRENT_TIMESTAMP NOT NULL,
    CREATE_TIME                   TIMESTAMP    DEFAULT CURRENT_TIMESTAMP NOT NULL,

    PRIMARY KEY (TOKEN_ID),
    FOREIGN KEY (SESSION_ID) REFERENCES CB_SESSION (SESSION_ID) ON DELETE CASCADE,
    FOREIGN KEY (USER_ID) REFERENCES CB_USER (USER_ID) ON DELETE NO ACTION
)
07-02-2024 06:36:55.741 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_AUTH_ATTEMPT
(
    AUTH_ID           VARCHAR(128) NOT NULL,
    AUTH_STATUS       VARCHAR(32)  NOT NULL,
    AUTH_ERROR        TEXT,
    APP_SESSION_ID    VARCHAR(64)  NOT NULL,
    SESSION_ID        VARCHAR(64),
    SESSION_TYPE      VARCHAR(64)  NOT NULL,
    APP_SESSION_STATE TEXT         NOT NULL,
    IS_MAIN_AUTH      CHAR(1)      DEFAULT 'Y' NOT NULL,
    AUTH_USERNAME     VARCHAR(128) NULL,
    CREATE_TIME       TIMESTAMP    DEFAULT CURRENT_TIMESTAMP NOT NULL,

    PRIMARY KEY (AUTH_ID),
    FOREIGN KEY (SESSION_ID) REFERENCES CB_SESSION (SESSION_ID) ON DELETE CASCADE
)
07-02-2024 06:36:55.743 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_AUTH_ATTEMPT_INFO
(
    AUTH_ID                        VARCHAR(128) NOT NULL,
    AUTH_PROVIDER_ID               VARCHAR(128) NOT NULL,
    AUTH_PROVIDER_CONFIGURATION_ID VARCHAR(128),
    AUTH_STATE                     TEXT         NOT NULL,

    CREATE_TIME                    TIMESTAMP    DEFAULT CURRENT_TIMESTAMP NOT NULL,

    PRIMARY KEY (AUTH_ID, AUTH_PROVIDER_ID),
    FOREIGN KEY (AUTH_ID) REFERENCES CB_AUTH_ATTEMPT (AUTH_ID) ON DELETE CASCADE
)
07-02-2024 06:36:55.744 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE INDEX CB_SESSION_LOG_INDEX ON CB_SESSION_LOG (SESSION_ID, LOG_TIME)
07-02-2024 06:36:55.745 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: -- Secrets

CREATE TABLE CB_USER_SECRETS
(
    USER_ID                        VARCHAR(128) NOT NULL,
    SECRET_ID                      VARCHAR(512) NOT NULL,
    SECRET_VALUE                   TEXT NOT NULL,

    SECRET_LABEL                   VARCHAR(128),
    SECRET_DESCRIPTION             VARCHAR(1024),
    ENCODING_TYPE                  VARCHAR(32) DEFAULT 'PLAINTEXT' NOT NULL,
    UPDATE_TIME                    TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,

    PRIMARY KEY (USER_ID, SECRET_ID),
    FOREIGN KEY (USER_ID) REFERENCES CB_USER (USER_ID) ON DELETE CASCADE
)
07-02-2024 06:36:55.746 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE TABLE CB_SUBJECT_SECRETS
(
    SUBJECT_ID                     VARCHAR(128) NOT NULL,
    SECRET_ID                      VARCHAR(255) NOT NULL,

    PROJECT_ID                     VARCHAR(128),
    OBJECT_TYPE                    VARCHAR(32),
    OBJECT_ID                      VARCHAR(128),

    SECRET_VALUE                   TEXT NOT NULL,

    ENCODING_TYPE                  VARCHAR(32) DEFAULT 'PLAINTEXT' NOT NULL,
    CREATE_TIME                    TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
    UPDATE_TIME                    TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,

    PRIMARY KEY (SUBJECT_ID, SECRET_ID),
    FOREIGN KEY (SUBJECT_ID) REFERENCES CB_AUTH_SUBJECT (SUBJECT_ID) ON DELETE CASCADE
)
07-02-2024 06:36:55.748 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE INDEX IDX_SUBJECT_SECRETS_PROJECT ON CB_SUBJECT_SECRETS (PROJECT_ID,SUBJECT_ID)
07-02-2024 06:36:55.748 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Execute migration query: CREATE INDEX IDX_SUBJECT_SECRETS_OBJECT ON CB_SUBJECT_SECRETS (PROJECT_ID,OBJECT_TYPE,OBJECT_ID)
07-02-2024 06:36:55.783 [main] DEBUG i.c.service.security.db.CBDatabase -   Management database connection established
07-02-2024 06:36:55.784 [main] DEBUG i.c.s.s.CBEmbeddedSecurityController - Auth provider 'local' registered
07-02-2024 06:36:55.785 [main] DEBUG i.c.s.s.CBEmbeddedSecurityController - Auth provider 'reverseProxy' registered
07-02-2024 06:36:55.785 [main] INFO  io.cloudbeaver.server.CBApplication - No auto configuration was found. Server must be configured manually
07-02-2024 06:36:55.786 [main] DEBUG io.cloudbeaver.server.CBApplication - Starting Jetty server (8978 on all interfaces) 
07-02-2024 06:36:56.064 [main] DEBUG i.c.server.graphql.GraphQLEndpoint - Schema extensions loaded: WebServiceBindingCore,WebServiceBindingNavigator,WebServiceBindingSQL,WebServiceBindingAdmin,WebServiceBindingAuth,WebServiceBindingDataTransfer,WebServiceBindingFS,WebServiceBindingMetadata,WebServiceBindingRM
07-02-2024 06:36:56.310 [main] DEBUG i.c.server.jetty.CBJettyServer - Active servlets:
07-02-2024 06:36:56.310 [main] DEBUG i.c.server.jetty.CBJettyServer -   static: [/*]
07-02-2024 06:36:56.310 [main] DEBUG i.c.server.jetty.CBJettyServer -   images: [/api/images/*]
07-02-2024 06:36:56.310 [main] DEBUG i.c.server.jetty.CBJettyServer -   status: [/status]
07-02-2024 06:36:56.310 [main] DEBUG i.c.server.jetty.CBJettyServer -   graphql: [/api/gql/*]
07-02-2024 06:36:56.311 [main] DEBUG i.c.server.jetty.CBJettyServer -   sqlResultValueViewer: [/api/sql-result-value/*]
07-02-2024 06:36:56.311 [main] DEBUG i.c.server.jetty.CBJettyServer -   sqlUploadFile: [/api/resultset/blob/*]
07-02-2024 06:36:56.311 [main] DEBUG i.c.server.jetty.CBJettyServer -   adminLogs: [/api/logs/*]
07-02-2024 06:36:56.311 [main] DEBUG i.c.server.jetty.CBJettyServer -   dataTransfer: [/api/data/*]
07-02-2024 06:36:56.311 [main] DEBUG i.c.server.jetty.CBJettyServer -   fileSystems: [/api/fs-data/*]
07-02-2024 06:36:56.312 [main] INFO  org.eclipse.jetty.server.Server - jetty-11.0.18; built: 2023-10-27T02:14:36.036Z; git: 5a9a771a9fbcb9d36993630850f612581b78c13f; jvm 17.0.10+7
07-02-2024 06:36:56.358 [main] INFO  o.e.j.s.s.DefaultSessionIdManager - Session workerName=
07-02-2024 06:36:56.370 [main] INFO  o.e.j.server.handler.ContextHandler - Started o.e.j.s.ServletContextHandler@62158991{/,file:///opt/cloudbeaver/web/,AVAILABLE}
07-02-2024 06:36:56.377 [main] INFO  o.e.jetty.server.AbstractConnector - Started ServerConnector@662e682a{HTTP/1.1, (http/1.1)}{0.0.0.0:8978}
07-02-2024 06:36:56.379 [main] INFO  org.eclipse.jetty.server.Server - Started JettyServer@3caf5c96{STARTING}[11.0.18,sto=0] @3040ms
07-02-2024 06:37:13.982 [qtp500985266-50] INFO  i.c.s.w.CBJettyWebSocketManager - Websocket created for session: 18nhqhcjc9mwx9fmpboxwvq000
07-02-2024 06:37:14.015 [qtp500985266-50] DEBUG i.c.s.websockets.CBEventsWebSocket - EventWebSocket connected to the 18nhqhcjc9mwx9fmpboxwvq000 session
07-02-2024 06:37:14.045 [qtp500985266-48] DEBUG i.c.server.graphql.GraphQLEndpoint - API > serverConfig
07-02-2024 06:37:14.209 [qtp500985266-60] DEBUG i.c.server.graphql.GraphQLEndpoint - API > openSession
07-02-2024 06:37:14.243 [qtp500985266-60] DEBUG i.c.model.session.WebUserContext - refresh permissions null f51bd6d0-586f-4154-a8d1-49170c9e4143
07-02-2024 06:37:14.305 [qtp500985266-54] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getActiveUser
07-02-2024 06:37:14.333 [qtp500985266-60] DEBUG i.c.server.graphql.GraphQLEndpoint - API > sessionPermissions
07-02-2024 06:37:14.391 [qtp500985266-54] DEBUG i.c.server.graphql.GraphQLEndpoint - API > getAuthProviders
KnurpsBram commented 9 months ago

Opening in incognito mode works! That's great! :D

I cleared my browser's cache, but without incognito mode I can't get past the loading screen

EvgeniaBzzz commented 9 months ago

Great news :) It's a frontend cache issue. Did you try to clear Cache storage for CloudBeaver in devtools?

EvgeniaBzzz commented 8 months ago

I hope everything worked out for you. Please feel free to ask to reopen the ticket if it is still actual.