You need to build the SQL structure First link is to get you to the point to run the steps in the second link.
https://guacamole.apache.org/doc/gug/jdbc-auth.html https://github.com/glyptodon/guacamole-client/blob/master/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-mysql/schema/001-create-schema.sql Thank You Sean Hulbert Security Centric Inc. A Cybersecurity Virtualization Enablement Company We don't just run you through the motions, Our labs teach you how to think! System Award Management CAGE: 8AUV4 AFCEA San Francisco Chapter V.P. If you have heard of a hacker by name, he/she has failed, fear the hacker you haven’t heard of! CONFIDENTIALITY NOTICE: This communication with its contents may contain confidential and/or legally privileged information. It is solely for the use of the intended recipient(s). Unauthorized interception, review, use or disclosure is prohibited and may violate applicable laws including the Electronic Communications Privacy Act. If you are not the intended recipient, please contact the sender and destroy all copies of the communication. Content within this email communication is not legally binding as a contract and no promises are guaranteed unless in a formal contract outside this email communication. igitur qui desiderat pacem, praeparet bellum!!! Epitoma Rei Militaris From: Andrew Kelsey [mailto:[email protected]] Sent: Monday, February 13, 2023 6:10 PM To: [email protected] Subject: Re: R: Authentication type 10 not support. 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 <mailto:[email protected]> <[email protected]> Inviato: lunedì 13 febbraio 2023 14:11 A: [email protected] <mailto:[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.
