Hi, I've struggled several hours with an issue which seems to be new in 1.3.0.
When I'm using Version 1.3.0 of the mysql jdb auth provider I get an java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT The query itself looks fine - but it consists of two select statements, which has to be allowed in the jdbc driver with allowMultiQueries =true. There is code in https://github.com/apache/guacamole-client/blob/master/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-mysql/src/main/java/org/apache/guacamole/auth/mysql/MySQLAuthenticationProviderModule.java which hasn't changed for years: > // Allow use of multiple statements within a single query > driverProperties.setProperty("allowMultiQueries", "true"); but it does not seem to have an effect on the jdbc connection. Another instance with guacamole 1.1.0 works fine, so I tried to downgrade 1.3.0 to 1.2.0 and voila - this one works too. I could not find any issues on the internet about guacamoles 1.3.0 mysql auth provider.Can anybody verify this? Following a full guacamole debug log of the error with guacamole 1.3.0: Jun 21 09:08:05 guacamole-host tomcat9[7152]: 09:08:05.171 [http-nio-8080-exec-2] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection Jun 21 09:08:05 guacamole-host tomcat9[7152]: 09:08:05.238 [http-nio-8080-exec-2] DEBUG o.a.i.d.pooled.PooledDataSource - Created connection 984033933. Jun 21 09:08:05 guacamole-host tomcat9[7152]: 09:08:05.239 [http-nio-8080-exec-2] DEBUG o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@3aa72a8d] Jun 21 09:08:05 guacamole-host tomcat9[7152]: 09:08:05.244 [http-nio-8080-exec-2] DEBUG o.a.g.a.j.user.UserMapper.selectOne - ==> Preparing: SELECT guacamole_user.user_id, guacamole_entity.entity_id, guacamole_entity.name, password_hash, password_salt, password_date, disabled, expired, access_window_start, access_window_end, valid_from, valid_until, timezone, full_name, email_address, organization, organizational_role, MAX(start_date) AS last_active FROM guacamole_user JOIN guacamole_entity ON guacamole_user.entity_id = guacamole_entity.entity_id LEFT JOIN guacamole_user_history ON guacamole_user_history.user_id = guacamole_user.user_id WHERE guacamole_entity.name = ? AND guacamole_entity.type = 'USER' GROUP BY guacamole_user.user_id, guacamole_entity.entity_id; SELECT guacamole_user_attribute.user_id, guacamole_user_attribute.attribute_name, guacamole_user_attribute.attribute_value FROM guacamole_user_attribute JOIN guacamole_user ON guacamole_user.user_id = guacamole_user_attribute.user_id JOIN guacamole_entity ON guacamole_user.entity_id = guacamole_entity.entity_id WHERE guacamole_entity.name = ? AND guacamole_entity.type = 'USER' Jun 21 09:08:05 guacamole-host tomcat9[7152]: 09:08:05.295 [http-nio-8080-exec-2] DEBUG o.a.g.a.j.user.UserMapper.selectOne - ==> Parameters: null, null Jun 21 09:08:05 guacamole-host tomcat9[7152]: 09:08:05.303 [http-nio-8080-exec-2] DEBUG o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@3aa72a8d] Jun 21 09:08:05 guacamole-host tomcat9[7152]: 09:08:05.304 [http-nio-8080-exec-2] DEBUG o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@3aa72a8d] Jun 21 09:08:05 guacamole-host tomcat9[7152]: 09:08:05.305 [http-nio-8080-exec-2] DEBUG o.a.i.d.pooled.PooledDataSource - Closed connection 984033933. Jun 21 09:08:05 guacamole-host tomcat9[7152]: 09:08:05.305 [http-nio-8080-exec-2] 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. Jun 21 09:08:05 guacamole-host tomcat9[7152]: 09:08:05.305 [http-nio-8080-exec-2] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error: Jun 21 09:08:05 guacamole-host tomcat9[7152]: ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT Jun 21 09:08:05 guacamole-host tomcat9[7152]: guacamole_user_attribute.user_id, Jun 21 09:08:05 guacamole-host tomcat9[7152]: guacamole_user_' at line 28 Jun 21 09:08:05 guacamole-host tomcat9[7152]: ### The error may exist in org/apache/guacamole/auth/jdbc/user/UserMapper.xml Jun 21 09:08:05 guacamole-host tomcat9[7152]: ### The error may involve defaultParameterMap Jun 21 09:08:05 guacamole-host tomcat9[7152]: ### The error occurred while setting parameters Jun 21 09:08:05 guacamole-host tomcat9[7152]: ### SQL: SELECT guacamole_user.user_id, guacamole_entity.entity_id, guacamole_entity.name, password_hash, password_salt, password_date, disabled, expired, access_window_start, access_window_end, valid_from, valid_until, timezone, full_name, email_address, organization, organizational_role, MAX(start_date) AS last_active FROM guacamole_user JOIN guacamole_entity ON guacamole_user.entity_id = guacamole_entity.entity_id LEFT JOIN guacamole_user_history ON guacamole_user_history.user_id = guacamole_user.user_id WHERE guacamole_entity.name = ? AND guacamole_entity.type = 'USER' GROUP BY guacamole_user.user_id, guacamole_entity.entity_id; SELECT guacamole_user_attribute.user_id, guacamole_user_attribute.attribute_name, guacamole_user_attribute.attribute_value FROM guacamole_user_attribute JOIN guacamole_user ON guacamole_user.user_id = guacamole_user_attribute.user_id JOIN guacamole_entity ON guacamole_user.entity_id = guacamole_entity.entity_id WHERE guacamole_entity.name = ? AND guacamole_entity.type = 'USER' Jun 21 09:08:05 guacamole-host tomcat9[7152]: ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT Jun 21 09:08:05 guacamole-host tomcat9[7152]: guacamole_user_attribute.user_id, Jun 21 09:08:05 guacamole-host tomcat9[7152]: guacamole_user_' at line 28 Jun 21 09:08:05 guacamole-host tomcat9[7152]: 09:08:05.306 [http-nio-8080-exec-2] DEBUG o.a.g.rest.RESTExceptionMapper - Unexpected error in REST endpoint. Jun 21 09:08:05 guacamole-host tomcat9[7152]: org.apache.ibatis.exceptions.PersistenceException: Jun 21 09:08:05 guacamole-host tomcat9[7152]: ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT Jun 21 09:08:05 guacamole-host tomcat9[7152]: guacamole_user_attribute.user_id, Jun 21 09:08:05 guacamole-host tomcat9[7152]: guacamole_user_' at line 28 Jun 21 09:08:05 guacamole-host tomcat9[7152]: ### The error may exist in org/apache/guacamole/auth/jdbc/user/UserMapper.xml Jun 21 09:08:05 guacamole-host tomcat9[7152]: ### The error may involve defaultParameterMap Jun 21 09:08:05 guacamole-host tomcat9[7152]: ### The error occurred while setting parameters Jun 21 09:08:05 guacamole-host tomcat9[7152]: ### SQL: SELECT guacamole_user.user_id, guacamole_entity.entity_id, guacamole_entity.name, password_hash, password_salt, password_date, disabled, expired, access_window_start, access_window_end, valid_from, valid_until, timezone, full_name, email_address, organization, organizational_role, MAX(start_date) AS last_active FROM guacamole_user JOIN guacamole_entity ON guacamole_user.entity_id = guacamole_entity.entity_id LEFT JOIN guacamole_user_history ON guacamole_user_history.user_id = guacamole_user.user_id WHERE guacamole_entity.name = ? AND guacamole_entity.type = 'USER' GROUP BY guacamole_user.user_id, guacamole_entity.entity_id; SELECT guacamole_user_attribute.user_id, guacamole_user_attribute.attribute_name, guacamole_user_attribute.attribute_value FROM guacamole_user_attribute JOIN guacamole_user ON guacamole_user.user_id = guacamole_user_attribute.user_id JOIN guacamole_entity ON guacamole_user.entity_id = guacamole_entity.entity_id WHERE guacamole_entity.name = ? AND guacamole_entity.type = 'USER' Jun 21 09:08:05 guacamole-host tomcat9[7152]: ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT Jun 21 09:08:05 guacamole-host tomcat9[7152]: guacamole_user_attribute.user_id, Jun 21 09:08:05 guacamole-host tomcat9[7152]: guacamole_user_' at line 28 Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at java.base/java.lang.reflect.Method.invoke(Method.java:566) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.session.SqlSessionManager$SqlSessionInterceptor.invoke(SqlSessionManager.java:357) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at com.sun.proxy.$Proxy40.selectOne(Unknown Source) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.session.SqlSessionManager.selectOne(SqlSessionManager.java:166) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at com.sun.proxy.$Proxy43.selectOne(Unknown Source) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.guacamole.auth.jdbc.user.UserService.retrieveAuthenticatedUser(UserService.java:378) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.guacamole.auth.jdbc.JDBCAuthenticationProviderService.authenticateUser(JDBCAuthenticationProviderService.java:76) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.guacamole.auth.jdbc.InjectedAuthenticationProvider.authenticateUser(InjectedAuthenticationProvider.java:76) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.guacamole.extension.AuthenticationProviderFacade.authenticateUser(AuthenticationProviderFacade.java:190) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.guacamole.rest.auth.AuthenticationService.authenticateUser(AuthenticationService.java:174) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.guacamole.rest.auth.AuthenticationService.getAuthenticatedUser(AuthenticationService.java:300) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.guacamole.rest.auth.AuthenticationService.authenticate(AuthenticationService.java:453) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.guacamole.rest.auth.TokenRESTService.createToken(TokenRESTService.java:174) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at java.base/java.lang.reflect.Method.invoke(Method.java:566) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:219) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.internal.Errors.process(Errors.java:292) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.internal.Errors.process(Errors.java:274) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.internal.Errors.process(Errors.java:244) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:290) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:280) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:184) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:89) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:85) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:121) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:133) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at java.base/java.lang.Thread.run(Thread.java:829) Jun 21 09:08:05 guacamole-host tomcat9[7152]: Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT Jun 21 09:08:05 guacamole-host tomcat9[7152]: guacamole_user_attribute.user_id, Jun 21 09:08:05 guacamole-host tomcat9[7152]: guacamole_user_' at line 28 Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:370) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at java.base/java.lang.reflect.Method.invoke(Method.java:566) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at com.sun.proxy.$Proxy102.execute(Unknown Source) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) Jun 21 09:08:05 guacamole-host tomcat9[7152]: #011... 73 common frames omitted And the corresponding mysql log messages: 2021-06-21T09:37:36.879815Z 50 Connect guacamole_user@localhost on guacamole_db using SSL/TLS 2021-06-21T09:37:36.880743Z 50 Query /* mysql-connector-java-8.0.19 (Revision: a0ca826f5cdf51a98356fdfb1bf251eb042f80bf) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@collation_connection AS collation_connection, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_write_timeout AS net_write_timeout, @@performance_schema AS performance_schema, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@transaction_isolation AS transaction_isolation, @@wait_timeout AS wait_timeout 2021-06-21T09:37:36.882431Z 50 Query SET NAMES utf8mb4 2021-06-21T09:37:36.883050Z 50 Query SET character_set_results = NULL 2021-06-21T09:37:36.883748Z 50 Query SET autocommit=1 2021-06-21T09:37:36.885039Z 50 Query SET autocommit=0 2021-06-21T09:37:36.887231Z 50 Query SELECT guacamole_user.user_id, guacamole_entity.entity_id, guacamole_entity.name, password_hash, password_salt, password_date, disabled, expired, access_window_start, access_window_end, valid_from, valid_until, timezone, full_name, email_address, organization, organizational_role, MAX(start_date) AS last_active FROM guacamole_user JOIN guacamole_entity ON guacamole_user.entity_id = guacamole_entity.entity_id LEFT JOIN guacamole_user_history ON guacamole_user_history.user_id = guacamole_user.user_id WHERE guacamole_entity.name = null AND guacamole_entity.type = 'USER' GROUP BY guacamole_user.user_id, guacamole_entity.entity_id; SELECT guacamole_user_attribute.user_id, guacamole_user_attribute.attribute_name, guacamole_user_attribute.attribute_value FROM guacamole_user_attribute JOIN guacamole_user ON guacamole_user.user_id = guacamole_user_attribute.user_id JOIN guacamole_entity ON guacamole_user.entity_id = guacamole_entity.entity_id WHERE guacamole_entity.name = null AND guacamole_entity.type = 'USER' 2021-06-21T09:37:36.888819Z 50 Query SET autocommit=1 2021-06-21T09:37:36.889756Z 50 Quit Versions: mysql Ver 8.0.25-0 /etc/guacamole/lib/mysql-connector-java.jar 8.0.19 Regards christoph --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@guacamole.apache.org For additional commands, e-mail: user-h...@guacamole.apache.org
