Hi Manuel, It seems, like your are not running the init script for the DB. Have you tried running this:
```
docker run --rm guacamole/guacamole /opt/guacamole/bin/initdb.sh
--mysql > guac_db.sql
```
From the error it seems as if your DB is not initialised.
I missed it the first couple of times as well. But this would be the point in
the documentation:
https://guacamole.apache.org/doc/gug/guacamole-docker.html#initializing-the-mysql-database
Kind regards
Rolf
> On 1 Mar 2023, at 17:56, Fischer, Manuel <[email protected]>
> wrote:
>
> 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]
> <mailto:[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
smime.p7s
Description: S/MIME cryptographic signature
