I have the JDBC driver in /etc/guacamole/lib . /etc/guacamole# tree . ├── extensions │ ├── guacamole-auth-jdbc-postgresql-1.5.5.jar │ ├── guacamole-auth-ldap-1.5.5.jar │ └── guacamole-auth-totp-1.5.5.jar ├── guacamole.properties ├── guacd.conf ├── lib │ └── postgresql-42.7.3.jar └── user-mapping.xml 3 directories, 7 files On Wednesday, June 5th, 2024 at 5:09 PM, Nick Couchman <vn...@apache.org> wrote:
> 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 > >>
