Just to close this thread out, the issue is I was using this environment variable: -e MYSQL_DRIVER="mariadb"
But…contrary to the documentation, guacamole does not support using the mariadb driver. So you have to use -e MYSQL_DRIVER="mysql" Which seems to work just as well. thanks Tony From: Tony Guadagno <[email protected]> Sent: Saturday, October 11, 2025 7:17 AM To: [email protected] Subject: RE: [External] Warning EXTERNAL Email help with new installation not talking to native mariadb Hi, thanks, that got me a little closer I think, but not there yet. I looked closer at docker networking. The setup guide tells you to create a guac network for guacd and guacamole…so I did: a0208821ff67 guac-network bridge local ip addr: 6: br-a0208821ff67: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP group default link/ether 7e:30:87:f8:f7:95 brd ff:ff:ff:ff:ff:ff inet 172.18.0.1/16 brd 172.18.255.255 scope global br-a0208821ff67 valid_lft forever preferred_lft forever inet6 fe80::7c30:87ff:fef8:f795/64 scope link valid_lft forever preferred_lft forever also, I can now ping 172.18.0.2 (guacd) 172.18.0.3 (guacamole) I also added a bind statement to /etc/my.cnf.d/mariadb-server.conf: bind-address=0.0.0.0 so netstat shows: tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN i am now starting the container this way: docker run --network=guac-network --name lnb-guacamole -e MYSQL_HOSTNAME="172.18.0.1" -e MYSQL_DATABASE="guacamole_db" -e MYSQL_USERNAME="guacamole_user" -e MYSQL_SSL_MODE="disabled" -e MYSQL_SERVER_TIMEZONE="America/New_York" -e LOGBACK_LEVEL="info" -e MYSQL_DRIVER="mariadb" -e MYSQL_PASSWORD="somepw" -e GUACD_HOSTNAME="lnb-guacd" -d -p 8080:8080 guacamole/guacamole ug, but still same 11:06:42.230 [http-nio-8080-exec-10] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error: ### Error querying database. Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. ### 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: Error setting driver on UnpooledDataSource. Any other suggestions would be greatly appreciated Tony Guadagno Lyons National Bank E: [email protected]<mailto:[email protected]> O: 585.577.1003 C: 585.703.6700 [cid:[email protected]] From: Mailing Lists <[email protected]<mailto:[email protected]>> Sent: Friday, October 10, 2025 7:28 PM To: [email protected]<mailto:[email protected]> Subject: Re: [External] Warning EXTERNAL Email help with new installation not talking to native mariadb Hi , just a quick hint. I think „localhost“ from within docker is not your rhel9 host. so the container can not find your database server. you must find a way, either via real ip, docker bridge ip or real hostname to get a route to your rhel9 server from the inside of the container. via Smartphone Am 10.10.2025 um 23:19 schrieb Tony Guadagno <[email protected]<mailto:[email protected]>>: Hi, I am new to guac and am moving through the online guides. I am using guacd and guacamole docker containers but I am using native mariadb all on a single rhel 9 server. I have gone through the process of creating the database and user in maria. I have run the initialization script and I can see that it did create the tables so all looks good there. I am now trying to go to the login page. Before I set the database parms up, I got a login page but I could not login (expected) after I configured the database info, I get an error page on guac. I am starting the container this way: docker run --name lnb-guacamole -e MYSQL_HOSTNAME="localhost" -e MYSQL_DATABASE="guacamole_db" -e MYSQL_USERNAME="guacamole_user" -e MYSQL_SSL_MODE="disabled" -e MYSQL_SERVER_TIMEZONE="America/New_York" -e MYSQL_DRIVER="mariadb" -e MYSQL_PASSWORD="somepw" -e GUACD_HOSTNAME="lnb-guacd" -d -p 8080:8080 guacamole/guacamole This is in the logs: I would appreciate any help…thanks [root@lnb-rdp bin]# docker logs lnb-guacamole NOTE: Picked up JDK_JAVA_OPTIONS: --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.lang.invoke=ALL-UNNAMED --add-opens=java.base/java.lang.reflect=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.util.concurrent=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED 10-Oct-2025 21:00:46.652 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name: Apache Tomcat/9.0.110 10-Oct-2025 21:00:46.655 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Oct 1 2025 08:36:05 UTC 10-Oct-2025 21:00:46.656 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 9.0.110.0 10-Oct-2025 21:00:46.656 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux 10-Oct-2025 21:00:46.656 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 5.14.0-570.51.1.el9_6.x86_64 10-Oct-2025 21:00:46.656 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64 10-Oct-2025 21:00:46.656 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /opt/java/openjdk 10-Oct-2025 21:00:46.657 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 21.0.8+9-LTS 10-Oct-2025 21:00:46.657 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Eclipse Adoptium 10-Oct-2025 21:00:46.658 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /tmp/catalina-base.f4H5RUfMwL 10-Oct-2025 21:00:46.658 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /usr/local/tomcat 10-Oct-2025 21:00:46.665 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.lang=ALL-UNNAMED 10-Oct-2025 21:00:46.666 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.lang.invoke=ALL-UNNAMED 10-Oct-2025 21:00:46.666 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.lang.reflect=ALL-UNNAMED 10-Oct-2025 21:00:46.666 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.io=ALL-UNNAMED 10-Oct-2025 21:00:46.667 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.util=ALL-UNNAMED 10-Oct-2025 21:00:46.667 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.util.concurrent=ALL-UNNAMED 10-Oct-2025 21:00:46.667 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED 10-Oct-2025 21:00:46.667 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/tmp/catalina-base.f4H5RUfMwL/conf/logging.properties 10-Oct-2025 21:00:46.668 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 10-Oct-2025 21:00:46.668 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048 10-Oct-2025 21:00:46.668 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources 10-Oct-2025 21:00:46.668 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dsun.io.useCanonCaches=false 10-Oct-2025 21:00:46.669 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027 10-Oct-2025 21:00:46.669 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs= 10-Oct-2025 21:00:46.669 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/tmp/catalina-base.f4H5RUfMwL 10-Oct-2025 21:00:46.669 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/local/tomcat 10-Oct-2025 21:00:46.669 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/tmp/catalina-base.f4H5RUfMwL/temp 10-Oct-2025 21:00:46.672 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded Apache Tomcat Native library [1.3.1] using APR version [1.7.2]. 10-Oct-2025 21:00:46.672 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true], UDS [true]. 10-Oct-2025 21:00:46.673 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true] 10-Oct-2025 21:00:46.675 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 3.0.13 30 Jan 2024] 10-Oct-2025 21:00:46.968 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"] 10-Oct-2025 21:00:46.984 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [479] milliseconds 10-Oct-2025 21:00:47.009 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina] 10-Oct-2025 21:00:47.010 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.110] 10-Oct-2025 21:00:47.021 INFO [main] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [/tmp/catalina-base.f4H5RUfMwL/webapps/guacamole.war] 10-Oct-2025 21:00:48.611 INFO [main] 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. 21:00:48.793 [main] INFO org.apache.guacamole.environment.LocalEnvironment -- GUACAMOLE_HOME is "/tmp/guacamole-home.5It2BfNxkb". 21:00:48.853 [main] INFO org.apache.guacamole.GuacamoleServletContextListener -- Read configuration parameters from "/tmp/guacamole-home.5It2BfNxkb/guacamole.properties". 21:00:48.855 [main] INFO org.apache.guacamole.GuacamoleServletContextListener -- Additional configuration parameters may be read from environment variables. 21:00:48.856 [main] INFO org.apache.guacamole.GuacamoleServletContextListener -- Additional configuration parameters may be read from files pointed to by "*_FILE" environment variables. 21:00:48.857 [main] INFO org.apache.guacamole.rest.auth.HashTokenSessionMap -- Sessions will expire after 60 minutes of inactivity. 21:00:48.922 [main] INFO org.apache.guacamole.log.LogModule -- Logging will be at the "info" level. 21:00:49.172 [main] INFO o.a.g.extension.ExtensionModule - Multiple extensions are installed and will be loaded in order of decreasing priority: 21:00:49.173 [main] INFO o.a.g.extension.ExtensionModule - - [ban] "Brute-force Authentication Detection/Prevention" (/tmp/guacamole-home.5It2BfNxkb/extensions/guacamole-auth-ban.jar) 21:00:49.173 [main] INFO o.a.g.extension.ExtensionModule - - [mysql] "MySQL Authentication" (/tmp/guacamole-home.5It2BfNxkb/extensions/guacamole-auth-jdbc-mysql.jar) 21:00:49.173 [main] 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. 21:00:49.192 [main] INFO o.a.g.a.b.BanningAuthenticationListener - Addresses will be automatically banned for 300 seconds after 5 failed authentication attempts. Up to 10485760 unique addresses will be tracked/banned at any given time. 21:00:49.223 [main] INFO o.a.g.extension.ExtensionModule - Extension "Brute-force Authentication Detection/Prevention" (ban) loaded. 21:00:49.232 [main] WARN o.a.g.a.m.MySQLAuthenticationProviderModule - The MySQL module is currently configured to support case-sensitive username and/or group name comparisons, however, the default collations for MySQL databases do not support case-sensitive string comparisons. If you want identifiers within Guacamole to be treated as case-sensitive, further database configuration may be required. 21:00:49.816 [main] INFO o.a.g.extension.ExtensionModule - Extension "MySQL Authentication" (mysql) loaded. 21:00:50.018 [main] INFO o.a.g.t.w.WebSocketTunnelModule - Loading JSR-356 WebSocket support... 21:00:50.127 [main] INFO o.a.g.event.EventLoggingListener - The Apache Guacamole web application has started. 21:00:50.420 [main] WARN o.g.jersey.server.wadl.WadlFeature - JAXBContext implementation could not be found. WADL feature is disabled. 10-Oct-2025 21:00:50.600 INFO [main] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/tmp/catalina-base.f4H5RUfMwL/webapps/guacamole.war] has finished in [3,579] ms 10-Oct-2025 21:00:50.603 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"] 10-Oct-2025 21:00:50.608 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [3618] milliseconds 21:01:13.379 [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<https://urldefense.proofpoint.com/v2/url?u=http-3A__guacamole.properties&d=DwQFaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=FAi7_Un_xIwqyE1tNdU-gb08bRZLlfxR_VZo5-zbQF0&m=epgoL2yp5905aq-DMfXSwJUpsGM2zHiyiXdyHnSNvZeOtyxNP_hJvHSMGGIiKVyR&s=9sQBqx1R_6nMEW75bSiK9pPwOCSLKI2pa68IViJIlLU&e=>. 21:01:13.382 [http-nio-8080-exec-8] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error: ### Error querying database. Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. ### 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: Error setting driver on UnpooledDataSource. 21:01:22.644 [http-nio-8080-exec-1] 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<https://urldefense.proofpoint.com/v2/url?u=http-3A__guacamole.properties&d=DwQFaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=FAi7_Un_xIwqyE1tNdU-gb08bRZLlfxR_VZo5-zbQF0&m=epgoL2yp5905aq-DMfXSwJUpsGM2zHiyiXdyHnSNvZeOtyxNP_hJvHSMGGIiKVyR&s=9sQBqx1R_6nMEW75bSiK9pPwOCSLKI2pa68IViJIlLU&e=>. 21:01:22.644 [http-nio-8080-exec-1] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error: ### Error querying database. Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. ### 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: Error setting driver on UnpooledDataSource. 21:01:32.940 [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<https://urldefense.proofpoint.com/v2/url?u=http-3A__guacamole.properties&d=DwQFaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=FAi7_Un_xIwqyE1tNdU-gb08bRZLlfxR_VZo5-zbQF0&m=epgoL2yp5905aq-DMfXSwJUpsGM2zHiyiXdyHnSNvZeOtyxNP_hJvHSMGGIiKVyR&s=9sQBqx1R_6nMEW75bSiK9pPwOCSLKI2pa68IViJIlLU&e=>. 21:01:32.940 [http-nio-8080-exec-9] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error: ### Error querying database. Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. ### 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: Error setting driver on UnpooledDataSource. Tony ________________________________ ________________________________ This email has been scanned for spam and viruses by Proofpoint Essentials. Click here<https://us1.proofpointessentials.com/app/report_spam.php?mod_id=11&mod_option=logitem&report=1&type=easyspam&k=k1&payload=53616c7465645f5f4e358f9cbf5e66ee95b8770c14eec51c41ed06f102a2900032c3c9ebebcebab55ec7957177b1fe525f54f5954830cd1ab70b59745e849a59258d108befe4b8ffaab867a2abf7316c766695869cb569b709e8cc9909ed5223f20fd9ca3d834808ef74afb7c8bd1ed3a307dcde11f3ad5895d60715aa320bddccfbf7b1f79d0666cbb5824685097c7a41f3b735b99713fdd3521cc8578ae138> to report this email as spam.
