On Wed, Jun 5, 2024 at 9:53 AM wirnwta54kxngyzo <wirnwta54kxng...@proton.me.invalid> wrote:
> Hi, > > I'm having a hard time setting up database authentification with > postgresql. > I'm having this error /var/log/tomcat9/catalina.out . > <code> > > [2024-06-05 15:12:11] [info] 15:12:11.344 [http-nio-8080-exec-6] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection[2024-06-05 15:12:11] > [info] 15:12:11.350 [http-nio-8080-exec-6] DEBUG > o.a.g.a.j.DynamicallyAuthenticatedDataSource - Creating new database > connection for pool. > [2024-06-05 15:12:11] [info] 15:12:11.353 [http-nio-8080-exec-6] WARN > o.a.g.e.AuthenticationProviderFacade - The "postgresql" authentication > provider has encoun > tered 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 g > uacamole.properties. > [2024-06-05 15:12:11] [info] 15:12:11.357 [http-nio-8080-exec-6] ERROR > o.a.g.rest.RESTExceptionMapper - Unexpected internal error: > [2024-06-05 15:12:11] [info] ### Error querying database. Cause: > java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: > java.lang.ClassNotFou > ndException: org.postgresql.Driver > [2024-06-05 15:12:11] [info] ### The error may exist in > org/apache/guacamole/auth/jdbc/user/UserMapper.xml > [2024-06-05 15:12:11] [info] ### The error may involve > org.apache.guacamole.auth.jdbc.user.UserMapper.selectOne > [2024-06-05 15:12:11] [info] ### The error occurred while executing a query > [2024-06-05 15:12:11] [info] ### Cause: java.sql.SQLException: Error > setting driver on UnpooledDataSource. Cause: > java.lang.ClassNotFoundException: org.postgresq > l.Driver > [2024-06-05 15:12:11] [info] 15:12:11.357 [http-nio-8080-exec-6] DEBUG > o.a.g.rest.RESTExceptionMapper - Unexpected error in REST endpoint. > [2024-06-05 15:12:11] [info] > org.apache.ibatis.exceptions.PersistenceException: > [2024-06-05 15:12:11] [info] ### Error querying database. Cause: > java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: > java.lang.ClassNotFou > ndException: org.postgresql.Driver > This indicates that you have not placed the PostgreSQL JDBC driver into a location where Tomcat and/or Guacamole can find it. The manual covers this in the following section: https://guacamole.apache.org/doc/gug/jdbc-auth.html#downloading-the-database-authentication-extension You need to download the JDBC driver and place it in the GUACAMOLE_HOME/lib directory - by default, /etc/guacamole/lib - and then restart Tomcat. -Nick >
