Hi all, we are trying to get latest docker image running with docker, but we cant login. We can access the webserver of guacamole, but we can only see the following message:
! Error An error has occurred and this action cannot be completed. If the problem persists, please notify your system administrator or check your system logs. Our Host is Ubuntu 22.04 in a VMware based VM on vSphere with latest docker. Portainer and other containers are running fine. You will find the steps we followed according to the official guacamole and docker documentations and the logfile from the the guacamole container. All containers (postgres, guacd, guacamole) are running in green state. We can also access the guacamole_db with pgAdmin and see the newly created schemes, types and created user. Can you please assist us solving this problem? Kind regards Manuel Installation steps: A docker pull postgres docker run --name Guacamole_postgres -e POSTGRES_PASSWORD=pgpass -d postgres B docker pull dpage/pgadmin4:snapshot docker run --name pgAdmin -p 8090:80 -e '[email protected]' -e 'PGADMIN_DEFAULT_PASSWORD=pgadminpass' -d dpage/pgadmin4:snapshot C https://hub.docker.com/r/guacamole/guacd docker run --name Guacamole_guacd -d guacamole/guacd D Configure in pgAdmin: 1. create guacamole_db 2. create user: CREATE USER guacamole_user WITH PASSWORD 'gcuserpass'; GRANT SELECT,INSERT,UPDATE,DELETE ON ALL TABLES IN SCHEMA public TO guacamole_user; GRANT SELECT,USAGE ON ALL SEQUENCES IN SCHEMA public TO guacamole_user; 3. DB-Schema und User anlegen: https://github.com/apache/guacamole-client/tree/0.9.10-incubating/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-postgresql/schema E docker run --name Guacamole_app --link Guacamole_guacd:guacd --link Guacamole_postgres:postgres -e POSTGRES_DATABASE=guacamole_db -e POSTGRES_USER=guacamole_user -e POSTGRES_PASSWORD=gcuserpass -d -p 8100:8080 guacamole/guacamole Logfile from guacamole container 16:12:38.507 [localhost-startStop-1] INFO o.a.g.rest.auth.HashTokenSessionMap - Sessions will expire after 60 minutes of inactivity. 16:12:39.386 [localhost-startStop-1] INFO o.a.g.extension.ExtensionModule - Extension "PostgreSQL Authentication" (postgresql) loaded. 16:12:39.466 [localhost-startStop-1] INFO o.a.g.t.w.WebSocketTunnelModule - Loading JSR-356 WebSocket support... 01-Mar-2023 16:12:40.158 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/home/guacamole/tomcat/webapps/guacamole.war] has finished in [3,081] ms 01-Mar-2023 16:12:40.160 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"] 01-Mar-2023 16:12:40.170 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 3129 ms 16:12:45.582 [http-nio-8080-exec-6] WARN o.a.g.e.AuthenticationProviderFacade - The "postgresql" authentication provider has encountered an internal error which will halt the authentication process. If this is unexpected or you are the developer of this authentication provider, you may wish to enable debug-level logging. If this is expected and you wish to ignore such failures in the future, please set "skip-if-unavailable: postgresql" within your guacamole.properties. 16:12:45.585 [http-nio-8080-exec-6] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: relation "guacamole_entity" does not exist Position: 571 ### The error may exist in org/apache/guacamole/auth/jdbc/user/UserMapper.xml ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT guacamole_user.user_id, guacamole_entity.entity_id, guacamole_entity.name, password_hash, password_salt, password_date, disabled, expired, access_window_start, access_window_end, valid_from, valid_until, timezone, full_name, email_address, organization, organizational_role, MAX(start_date) AS last_active FROM guacamole_user JOIN guacamole_entity ON guacamole_user.entity_id = guacamole_entity.entity_id LEFT JOIN guacamole_user_history ON guacamole_user_history.user_id = guacamole_user.user_id WHERE guacamole_entity.name = ? AND guacamole_entity.type = 'USER'::guacamole_entity_type GROUP BY guacamole_user.user_id, guacamole_entity.entity_id; SELECT guacamole_user_attribute.user_id, guacamole_user_attribute.attribute_name, guacamole_user_attribute.attribute_value FROM guacamole_user_attribute JOIN guacamole_user ON guacamole_user.user_id = guacamole_user_attribute.user_id JOIN guacamole_entity ON guacamole_user.entity_id = guacamole_entity.entity_id WHERE guacamole_entity.name = ? AND guacamole_entity.type = 'USER'::guacamole_entity_type ### Cause: org.postgresql.util.PSQLException: ERROR: relation "guacamole_entity" does not exist Position: 571
