My guacamole install has been working great for months until now. Any help
would be very appreciated! I'm getting this in my docker log:
Attaching to guacd, guacamole
guacd | guacd[1]: INFO: Guacamole proxy daemon (guacd) version 1.5.2
started
guacd | guacd[1]: INFO: Listening on host 0.0.0.0, port 4822
guacamole | 15-Jun-2023 17:58:52.844 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log Server version name:
Apache Tomcat/8.5.90
guacamole | 15-Jun-2023 17:58:52.845 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log Server built:
Jun 2 2023 17:14:04 UTC
guacamole | 15-Jun-2023 17:58:52.845 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log Server version
number: 8.5.90.0
guacamole | 15-Jun-2023 17:58:52.845 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log OS Name:
Linux
guacamole | 15-Jun-2023 17:58:52.845 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log OS Version:
5.15.0-73-generic
guacamole | 15-Jun-2023 17:58:52.845 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log Architecture:
amd64
guacamole | 15-Jun-2023 17:58:52.846 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log Java Home:
/opt/java/openjdk/jre
guacamole | 15-Jun-2023 17:58:52.846 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log JVM Version:
1.8.0_372-b07
guacamole | 15-Jun-2023 17:58:52.846 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:
Temurin
guacamole | 15-Jun-2023 17:58:52.846 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:
/home/guacamole/tomcat
guacamole | 15-Jun-2023 17:58:52.846 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:
/usr/local/tomcat
guacamole | 15-Jun-2023 17:58:52.846 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log Command line
argument:
-Djava.util.logging.config.file=/home/guacamole/tomcat/conf/logging.properties
guacamole | 15-Jun-2023 17:58:52.846 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log Command line
argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
guacamole | 15-Jun-2023 17:58:52.846 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log Command line
argument: -Djdk.tls.ephemeralDHKeySize=2048
guacamole | 15-Jun-2023 17:58:52.846 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log Command line
argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
guacamole | 15-Jun-2023 17:58:52.846 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log Command line
argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
guacamole | 15-Jun-2023 17:58:52.847 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log Command line
argument: -Dignore.endorsed.dirs=
guacamole | 15-Jun-2023 17:58:52.847 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log Command line
argument: -Dcatalina.base=/home/guacamole/tomcat
guacamole | 15-Jun-2023 17:58:52.847 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log Command line
argument: -Dcatalina.home=/usr/local/tomcat
guacamole | 15-Jun-2023 17:58:52.847 INFO [main]
org.apache.catalina.startup.VersionLoggerListener.log Command line
argument: -Djava.io.tmpdir=/home/guacamole/tomcat/temp
guacamole | 15-Jun-2023 17:58:52.847 INFO [main]
org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded Apache
Tomcat Native library [1.2.37] using APR version [1.7.0].
guacamole | 15-Jun-2023 17:58:52.847 INFO [main]
org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR
capabilities: IPv6 [true], sendfile [true], accept filters [false], random
[true], UDS [{4}].
guacamole | 15-Jun-2023 17:58:52.847 INFO [main]
org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL
configuration: useAprConnector [false], useOpenSSL [true]
guacamole | 15-Jun-2023 17:58:52.851 INFO [main]
org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL
successfully initialized [OpenSSL 3.0.2 15 Mar 2022]
guacamole | 15-Jun-2023 17:58:52.907 INFO [main]
org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler
["http-nio-8080"]
guacamole | 15-Jun-2023 17:58:52.925 INFO [main]
org.apache.catalina.startup.Catalina.load Initialization processed in 453 ms
guacamole | 15-Jun-2023 17:58:52.946 INFO [main]
org.apache.catalina.core.StandardService.startInternal Starting service
[Catalina]
guacamole | 15-Jun-2023 17:58:52.946 INFO [main]
org.apache.catalina.core.StandardEngine.startInternal Starting Servlet
engine: [Apache Tomcat/8.5.90]
guacamole | 15-Jun-2023 17:58:52.959 INFO [localhost-startStop-1]
org.apache.catalina.startup.HostConfig.deployWAR Deploying web application
archive [/home/guacamole/tomcat/webapps/guacamole.war]
guacamole | 15-Jun-2023 17:58:54.092 INFO [localhost-startStop-1]
org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned
for TLDs yet contained no TLDs. Enable debug logging for this logger for a
complete list of JARs that were scanned but no TLDs were found in them.
Skipping unneeded JARs during scanning can improve startup time and JSP
compilation time.
guacamole | 17:58:54.439 [localhost-startStop-1] INFO
o.a.g.environment.LocalEnvironment - GUACAMOLE_HOME is
"/home/guacamole/.guacamole".
guacamole | 17:58:54.530 [localhost-startStop-1] INFO
o.a.g.GuacamoleServletContextListener - Read configuration parameters from
"/home/guacamole/.guacamole/guacamole.properties".
guacamole | 17:58:54.531 [localhost-startStop-1] INFO
o.a.g.rest.auth.HashTokenSessionMap - Sessions will expire after 60
minutes of inactivity.
guacamole | 17:58:54.836 [localhost-startStop-1] INFO
o.a.g.extension.ExtensionModule - Multiple extensions are installed and
will be loaded in order of decreasing priority:
guacamole | 17:58:54.836 [localhost-startStop-1] INFO
o.a.g.extension.ExtensionModule - - [mysql] "MySQL Authentication"
(/home/guacamole/.guacamole/extensions/guacamole-auth-jdbc-mysql-1.5.2.jar)
guacamole | 17:58:54.836 [localhost-startStop-1] INFO
o.a.g.extension.ExtensionModule - - [totp] "TOTP TFA Authentication
Backend"
(/home/guacamole/.guacamole/extensions/guacamole-auth-totp-1.5.2.jar)
guacamole | 17:58:54.836 [localhost-startStop-1] INFO
o.a.g.extension.ExtensionModule - To change this order, set the
"extension-priority" property or rename the extension files. The default
priority of extensions is dictated by the sort order of their filenames.
guacamole | 17:58:54.853 [localhost-startStop-1] INFO
o.a.g.a.mysql.conf.MySQLEnvironment - Installed JDBC driver for
MySQL/MariaDB detected as "MySQL Connector/J".
guacamole | 17:58:55.512 [localhost-startStop-1] INFO
o.a.g.extension.ExtensionModule - Extension "MySQL Authentication" (mysql)
loaded.
guacamole | 17:58:55.699 [localhost-startStop-1] INFO
o.a.g.extension.ExtensionModule - Extension "TOTP TFA Authentication
Backend" (totp) loaded.
guacamole | 17:58:55.786 [localhost-startStop-1] INFO
o.a.g.t.w.WebSocketTunnelModule - Loading JSR-356 WebSocket support...
guacamole | 15-Jun-2023 17:58:56.463 INFO [localhost-startStop-1]
org.apache.catalina.startup.HostConfig.deployWAR Deployment of web
application archive [/home/guacamole/tomcat/webapps/guacamole.war] has
finished in [3,503] ms
guacamole | 15-Jun-2023 17:58:56.464 INFO [main]
org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler
["http-nio-8080"]
guacamole | 15-Jun-2023 17:58:56.472 INFO [main]
org.apache.catalina.startup.Catalina.start Server startup in 3546 ms
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.
guacamole | 19:03:39.396 [http-nio-8080-exec-9] 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.
guacamole | 19:03:39.399 [http-nio-8080-exec-9] ERROR
o.a.g.rest.RESTExceptionMapper - Unexpected internal error:
guacamole | ### Error querying database. Cause: java.sql.SQLException:
Unknown system variable 'transaction_isolation'
guacamole | ### The error may exist in
org/apache/guacamole/auth/jdbc/user/UserMapper.xml
guacamole | ### The error may involve
org.apache.guacamole.auth.jdbc.user.UserMapper.selectOne
guacamole | ### The error occurred while executing a query
guacamole | ### Cause: java.sql.SQLException: Unknown system variable
'transaction_isolation'
guacamole | 19:04:24.453 [http-nio-8080-exec-8] 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.
guacamole | 19:04:24.454 [http-nio-8080-exec-8] ERROR
o.a.g.rest.RESTExceptionMapper - Unexpected internal error:
guacamole | ### Error querying database. Cause: java.sql.SQLException:
Unknown system variable 'transaction_isolation'
guacamole | ### The error may exist in
org/apache/guacamole/auth/jdbc/user/UserMapper.xml
guacamole | ### The error may involve
org.apache.guacamole.auth.jdbc.user.UserMapper.selectOne
guacamole | ### The error occurred while executing a query
guacamole | ### Cause: java.sql.SQLException: Unknown system variable
'transaction_isolation'
