[jira] [Commented] (GUACAMOLE-1422) Admin login failes with sql backend

["Jean-Benoit PAUX (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/GUACAMOLE-1422?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17417965#comment-17417965 ] 

Jean-Benoit PAUX commented on GUACAMOLE-1422:
---------------------------------------------

This issue has already been created :)

> Admin login failes with sql backend
> -----------------------------------
>
>                 Key: GUACAMOLE-1422
>                 URL: https://issues.apache.org/jira/browse/GUACAMOLE-1422
>             Project: Guacamole
>          Issue Type: Bug
>          Components: guacamole-auth-jdbc-sqlserver
>    Affects Versions: 1.3.0
>         Environment: Google GKE, using the docker image with mssql-jdbc-9.2.1.jre8.jar added
>            Reporter: Willy Vanlid
>            Priority: Major
>
> If we give a user the ADMINISTER system permission, they cant login anymore.
> The logged error is
> {noformat}
> 2021-09-21T06:40:44.736801472Z06:40:44.736 [http-nio-8080-exec-14] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error:
> 2021-09-21T06:40:44.736850722Z### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
> 2021-09-21T06:40:44.736859835Z### The error may exist in org/apache/guacamole/auth/jdbc/connectiongroup/ConnectionGroupMapper.xml
> 2021-09-21T06:40:44.736876206Z### The error may involve defaultParameterMap
> 2021-09-21T06:40:44.736882216Z### The error occurred while setting parameters{noformat}
> Which makes me believe it has to do with the number of connection groups or maybe users we have in the system. We give every user its own connection group and we have 640 users.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)