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)
