Willy Vanlid created GUACAMOLE-1422:
---------------------------------------
Summary: 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
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)
