How do I go about changing the jdbc driver?
On 2/13/2023 08:26, MAURIZI Lorenzo wrote:
Hi,
see if this helps:
https://stackoverflow.com/questions/64210167/unable-to-connect-to-postgres-db-due-to-the-authentication-type-10-is-not-suppor
I think you should change configuration in pg_hba.conf of postgres
Get your pg_hba.conf File […]
And Simply Change scram-sha-256 under Column Method to trust.
, or change the jar with postgresql driver in the Guacamole lib
directories…
According to the wiki
<https://wiki.postgresql.org/wiki/List_of_drivers#Drivers>, the
supported JDBC driver for |SCRAM-SHA-256| encryption is 42.2.0 or
above. In my case, the driver was 41.1.1. Change it to 42.2.0 or
above. That fixed it for me.
Regards.
Lorenzo
*Da:*Andrew Kelsey <[email protected]>
*Inviato:* lunedì 13 febbraio 2023 14:11
*A:* [email protected]
*Oggetto:* Authentication type 10 not support.
I'm trying to get guacamole up and running. I have run into this error
and I am stuck.
I tried adding a logback.xml to enable debugging and it doesn't seem
to work.
Any help egtting me pointed in the right direction would be appreciated.
More from the log:
12:47:32.658 [http-nio-8080-exec-8] 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.
12:47:32.661 [http-nio-8080-exec-8] ERROR
o.a.g.rest.RESTExceptionMapper - Unexpected internal error:
### Error querying database. Cause:
org.postgresql.util.PSQLException: The authentication type 10 is not
supported. Check that you have configured the pg_hba.conf file to
include the client's IP address or subnet, and that it is using an
authentication scheme supported by the driver.
### The error may exist in
org/apache/guacamole/auth/jdbc/user/UserMapper.xml
### The error may involve
org.apache.guacamole.auth.jdbc.user.UserMapper.selectOne
### The error occurred while executing a query
### Cause: org.postgresql.util.PSQLException: The authentication type
10 is not supported. Check that you have configured the pg_hba.conf
file to include the client's IP address or subnet, and that it is
using an authentication scheme supported by the driver.
