[
https://issues.apache.org/jira/browse/GUACAMOLE-1808?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17731453#comment-17731453
]
ClassicGOD edited comment on GUACAMOLE-1808 at 6/12/23 6:31 AM:
----------------------------------------------------------------
Having the same issue and rolling back to 1.5.0 does not help.
The issue is probably related/caused by the recent MariaDB update 11.1.1:
* The
[transaction_isolation|https://mariadb.com/kb/en/server-system-variables/#transaction_isolation]
option is now a system variable, and the tx_isolation system variable is
deprecated ([MDEV-21921|https://jira.mariadb.org/browse/MDEV-21921])
Update:
Tried rolling MariaDB back to 11.0.2 - issue persists
Rolled MariaDB back to 10.11.4 - Guacamole working again.
Looks like the issue is with MariaDB 11 and official container was probably
moved to 11 semi-recently. Other applications using this container have no
issues with both MariaDB 10 and 11, the issue seems to be only with Guacamole
Client.
was (Author: JIRAUSER283305):
Having the same issue and rolling back to 1.5.0 does not help.
The issue is probably related/caused by the recent MariaDB update 11.1.1:
* The
[transaction_isolation|https://mariadb.com/kb/en/server-system-variables/#transaction_isolation]
option is now a system variable, and the tx_isolation system variable is
deprecated ([MDEV-21921|https://jira.mariadb.org/browse/MDEV-21921])
> 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)
