[ https://issues.apache.org/jira/browse/GUACAMOLE-697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nick Couchman updated GUACAMOLE-697: ------------------------------------ Priority: Critical (was: Major) > Connection Error when permissions assigned to user and to group user is in > -------------------------------------------------------------------------- > > Key: GUACAMOLE-697 > URL: https://issues.apache.org/jira/browse/GUACAMOLE-697 > Project: Guacamole > Issue Type: Bug > Components: guacamole-auth-jdbc > Affects Versions: 1.0.0 > Reporter: matt nelson > Assignee: Nick Couchman > Priority: Critical > Fix For: 1.1.0 > > > If you assign a user permissions to a connection and have the same permission > assigned to a group that the user is a member of then they cannot connect. > The error shown on the web client is this: > {code:java} > An internal error has occurred within the Guacamole server, and the > connection has been terminated. If the problem persists, please notify your > system administrator, or check your system logs.{code} > > The catalina log shows this: > > {code:java} > SEVERE: Error reading request, ignored > org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or > null) to be returned by selectOne(), but found: 2 > at > org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:81) > at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.ibatis.session.SqlSessionManager$SqlSessionInterceptor.invoke(SqlSessionManager.java:357) > at com.sun.proxy.$Proxy30.selectOne(Unknown Source) > at > org.apache.ibatis.session.SqlSessionManager.selectOne(SqlSessionManager.java:166) > at > org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:83) > at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) > at com.sun.proxy.$Proxy112.selectOne(Unknown Source) > at > org.apache.guacamole.auth.jdbc.permission.ModeledObjectPermissionService.hasPermission(ModeledObjectPermissionService.java:171) > at > org.apache.guacamole.auth.jdbc.permission.ObjectPermissionSet.hasPermission(ObjectPermissionSet.java:103) > at > org.apache.guacamole.auth.jdbc.base.ModeledDirectoryObjectService.hasObjectPermission(ModeledDirectoryObjectService.java:175) > at > org.apache.guacamole.auth.jdbc.connection.ConnectionService.connect(ConnectionService.java:514) > at > org.apache.guacamole.auth.jdbc.connection.ModeledConnection.connect(ModeledConnection.java:263) > at > org.apache.guacamole.tunnel.TunnelRequestService.createConnectedTunnel(TunnelRequestService.java:219) > at > org.apache.guacamole.tunnel.TunnelRequestService.createTunnel(TunnelRequestService.java:393) > at > org.apache.guacamole.tunnel.websocket.RestrictedGuacamoleWebSocketTunnelEndpoint.createTunnel(RestrictedGuacamoleWebSocketTunnelEndpoint.java:113) > at > org.apache.guacamole.websocket.GuacamoleWebSocketTunnelEndpoint.onOpen(GuacamoleWebSocketTunnelEndpoint.java:200) > at > org.apache.tomcat.websocket.server.WsHttpUpgradeHandler.init(WsHttpUpgradeHandler.java:138) > at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:651) > at > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > at java.lang.Thread.run(Thread.java:748){code} > -- This message was sent by Atlassian JIRA (v7.6.3#76005)