[
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)
