[jira] [Comment Edited] (GUACAMOLE-1808) Updating to the latest version resulted in a SQL auth error with MariaDB

["Mike Jumper (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/GUACAMOLE-1808?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17731409#comment-17731409 ] 

Mike Jumper edited comment on GUACAMOLE-1808 at 6/11/23 11:27 PM:
------------------------------------------------------------------

[~pdanders], is that:

* {{guacamole/guacamole}}
* {{guacamole/guacd}}
* {{mariadb}} (Docker Official)

?

The version of Connector/J (the JDBC driver for MySQL/MariaDB) included in the {{guacamole/guacamole}} image was updated in 1.5.1. It's possible there is an incompatibility between the newer version and the version of MariaDB you are using.


was (Author: mike.jumper):
[~pdanders], is that:

* {{guacamole/guacamole}}
* {{guacamole/guacd]}
* {{mariadb}} (Docker Official)

?

The version of Connector/J (the JDBC driver for MySQL/MariaDB) included in the {{guacamole/guacamole}} image was updated in 1.5.1. It's possible there is an incompatibility between the newer version and the version of MariaDB you are using.

> 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)