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

["Pete Anderson (Jira)" <ji...@apache.org>]

Pete Anderson created GUACAMOLE-1808:
----------------------------------------

             Summary: 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
            Reporter: Pete Anderson


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)