[
https://issues.apache.org/jira/browse/GUACAMOLE-1808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mike Jumper updated GUACAMOLE-1808:
-----------------------------------
Description:
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:
{code:none}
...
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'
...
{code}
was:
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'
> Add support for MariaDB 11.x to Docker image
> --------------------------------------------
>
> Key: GUACAMOLE-1808
> URL: https://issues.apache.org/jira/browse/GUACAMOLE-1808
> Project: Guacamole
> Issue Type: Improvement
> 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:
>
> {code:none}
> ...
> 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'
> ...
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
