On Wed, Aug 6, 2025 at 3:04 AM Florian Segura <[email protected]> wrote:
> 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 >> >> I actually don't think this has anything to do with the space, I suspect you're hitting the bug that we found and recently fixed where we were missing an "AND" in the "DELETE" statement in the MySQL module: https://issues.apache.org/jira/browse/GUACAMOLE-2088 We haven't released 1.6.1, yet, so the fix isn't out, but my guess is that's actually your issue. I suspect it'll fail equally well with a group name that has no space. -Nick >
