[
https://issues.apache.org/jira/browse/GUACAMOLE-1808?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17731460#comment-17731460
]
Mike Jumper commented on GUACAMOLE-1808:
----------------------------------------
No {{transaction_isolation}} nor {{tx_isolation}} option is set within
Guacamole. The MariaDB Connector/J driver simply sits in the classpath, and is
loaded via a {{jdbc:mysql://}} URI. If there's something incompatible about the
current or past version of Connector/J included in the image, this makes sense,
but I don't see why it would be specific to Guacamole.
> Updating to the latest version resulted in a SQL auth error with MariaDB
> ------------------------------------------------------------------------
>
> Key: GUACAMOLE-1808
> URL: https://issues.apache.org/jira/browse/GUACAMOLE-1808
> Project: Guacamole
> Issue Type: Bug
> 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:
>
>
> Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver
> class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered
> via the SPI and manual loading of the driver class is generally unnecessary.
>
> 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'
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
