[ https://issues.apache.org/jira/browse/GUACAMOLE-1808?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17731677#comment-17731677 ]
Pete Anderson edited comment on GUACAMOLE-1808 at 6/13/23 2:06 PM: ------------------------------------------------------------------- I can validate what [~ClassicGOD] posted. Rolling MariaDB back to 10.11.4 gets it working again (appreciate at least a temporary solution btw - kudos!) was (Author: JIRAUSER300835): I can validate what [~ClassicGOD] posted. Rolling MariaDB back to 10.11.4 gets it working again (appreciate at least a temporary solution btw - kuods!) > Add support for MariaDB 11.x to Docker image > -------------------------------------------- > > Key: GUACAMOLE-1808 > URL: https://issues.apache.org/jira/browse/GUACAMOLE-1808 > Project: Guacamole > Issue Type: Improvement > Components: guacamole-docker > Reporter: Pete Anderson > Priority: Minor > > I have been running guacamole in docker without issue using mariadb for > years. After Watchtower updated me to the latest version I can no longer > access guacamole: > > {code:none} > ... > 00:22:42.601 [http-nio-8080-exec-6] WARN o.a.g.e.AuthenticationProviderFacade > - The "mysql" 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: mysql" within your > guacamole.properties. > 00:22:42.607 [http-nio-8080-exec-6] ERROR o.a.g.rest.RESTExceptionMapper - > Unexpected internal error: > ### Error querying database. Cause: java.sql.SQLException: Unknown system > variable 'transaction_isolation' > ### 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: java.sql.SQLException: Unknown system variable > 'transaction_isolation' > ... > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)