You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@guacamole.apache.org by "Mike Jumper (Jira)" <ji...@apache.org> on 2023/06/11 23:26:00 UTC
[jira] [Updated] (GUACAMOLE-1808) Updating to the latest version resulted in a SQL auth error with MariaDB
[ https://issues.apache.org/jira/browse/GUACAMOLE-1808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Jumper updated GUACAMOLE-1808:
-----------------------------------
Component/s: guacamole-docker
(was: 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: Major
>
> 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)