Re: mysql/mariadb errors
Thank you so much, went back to 10.11.4-jammy and all good with no fuss.
On Thu, Jun 15, 2023 at 4:50 PM Michael Jumper wrote:
> On 6/15/23 12:14, Eric Wallis wrote:
> > 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
> > ...
> > 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'
> > ...
>
> This is due to an incompatibility between the MySQL/MariaDB JDBC driver
> ("Connector/J") bundled with the "guacamole/guacamole" image and the
> latest version of MariaDB. See:
>
> https://issues.apache.org/jira/browse/GUACAMOLE-1808
>
> It seems the Docker's official MariaDB image was recently updated from
> 10 to 11, hence the error appearing now. I'd recommend taking a database
> backup and (carefully) rolling back to MariaDB 10.x.
>
> - Mike
>
> -
> To unsubscribe, e-mail: user-unsubscr...@guacamole.apache.org
> For additional commands, e-mail: user-h...@guacamole.apache.org
>
>
Re: mysql/mariadb errors
On 6/15/23 12:14, Eric Wallis wrote:
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
...
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'
...
This is due to an incompatibility between the MySQL/MariaDB JDBC driver
("Connector/J") bundled with the "guacamole/guacamole" image and the
latest version of MariaDB. See:
https://issues.apache.org/jira/browse/GUACAMOLE-1808
It seems the Docker's official MariaDB image was recently updated from
10 to 11, hence the error appearing now. I'd recommend taking a database
backup and (carefully) rolling back to MariaDB 10.x.
- Mike
-
To unsubscribe, e-mail: user-unsubscr...@guacamole.apache.org
For additional commands, e-mail: user-h...@guacamole.apache.org
mysql/mariadb errors
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-st
