Hi, I already had this issue with 1.6.0 Guacamole version on docker image pulled from Docker Hub. To solve this issue, i just rebuilded the guacamole-client image from Apache Github project with the latest fixes.
Florian Segura Le mar. 5 août 2025 à 23:51, Barnhart, Steven <[email protected]> a écrit : > Oh maybe that is why I couldn’t delete a group with the REST API! I > figured it had changed from the docs someone had written. > > –Steve > ------------------------------ > *From:* Gareth Williams <[email protected]> > *Sent:* Tuesday, August 5, 2025 4:14:11 PM > *To:* [email protected] <[email protected]> > *Subject:* SQL Error when group name contains a space > > Hi, I've noticed that if I create a group with a space in its name, the > group is created but cannot be deleted. I've created a group called "SAS > PCE" in my lab, but when I came to delete it, I get "Unexpected internal > error". When I look in > Hi, > > I've noticed that if I create a group with a space in its name, the group > is created but cannot be deleted. > > I've created a group called "SAS PCE" in my lab, but when I came to delete > it, I get "Unexpected internal error". When I look in guacamole's logs, I > see: > > --------------------- > > 14:45:51.296 [http-nio-8080-exec-6] ERROR o.a.g.rest.RESTExceptionMapper - > Unexpected internal error: > ### Error updating database. Cause: java.sql.SQLSyntaxErrorException: You > have an error in your SQL syntax; check the manual that corresponds to your > MariaDB server version for the right syntax to use near 'name = 'SAS PCE'' > at line 5 > ### The error may exist in > org/apache/guacamole/auth/jdbc/usergroup/UserGroupMapper.xml > ### The error may involve defaultParameterMap > ### The error occurred while setting parameters > ### SQL: DELETE FROM guacamole_entity WHERE type = 'USER_GROUP' name = ? > ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL > syntax; check the manual that corresponds to your MariaDB server version > for the right syntax to use near 'name = 'SAS PCE'' at line 5 > > ----------------------- > > This should either allow deletions, or block creations, of groups with > spaces in the name. > > Is this a reportable bug? > > Kind regards, > > Gareth Williams >
