Hi, Just found another issue, when trying to delete a group through the UI it shows unexpected error, looking through the log, it seems like a not working SQL command is generate:
`DELETE FROM guacamole_entity WHERE type = 'USER_GROUP' name = ?` which seems to be missing an `AND` `DELETE FROM guacamole_entity WHERE type = 'USER_GROUP' AND name = ?` Log entry; ``` 09:43:37.865 [http-nio-8080-exec-3] INFO o.a.g.event.EventLoggingListener - User "XXXXX" (authenticated by "mysql") failed to delete user group "apache-guacamole-admin" within "mysql": ### 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 = 'apache-guacamole-admin'' 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 = 'apache-guacamole-admin'' at line 5 09:43:37.865 [http-nio-8080-exec-3] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error: ``` Thanks. - Tobias Sent with [Proton Mail](https://pr.tn/ref/BTTM5JG4EZEG) secure email. On Monday, July 7th, 2025 at 09:52, newslet...@tobiasmeier.dev.INVALID <newslet...@tobiasmeier.dev.INVALID> wrote: > Hi > > While troubleshooting I found out, that assigning a group the "Audit" > permissions results in an application error and an empty permission entry in > the db: > > As soon as I assign the Audit permission, guacamole crashes and assigns an > Empty permission entry to that group. manually removing that empty entry from > the table results in the audit permission being unticket again. > > Thanks > > - Tobias > > Sent with [Proton Mail](https://pr.tn/ref/BTTM5JG4EZEG) secure email.
