Ok. I've got it figured out. I put the jdbc in /opt/guacamole/postgresql.
Now I am have a user not found issue. I haven't dug into it yet, but if
you have any pointers, I'll be happy hear them.
On 2/13/2023 20:21, Andrew Kelsey wrote:
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.
