On Mon, Jul 7, 2025 at 11:17 AM <[email protected]> wrote:
> > No I didn't do any database schema update, I used this repo, which just > updates guacamole binary and extensions all to latest, while also updating > the mysql connector. > https://github.com/itiligent/Easy-Guacamole-Installer > > First, I guess I should clarify - was this a clean install, with a clean DB, under 1.6.0, or were you updating an existing guacamole 1.5.5 or earlier version with an existing MySQL database? It seems I made an assumption that you were upgrading, but, looking back through the e-mail threads, I don't see that stated clearly anywhere. If this is a brand-new install, with a brand-new database using the 1.6.0 deployment scripts, then you should definitely not see the issue you're seeing with the AUDIT privilege, and something else has gone wrong. The link above is not an "official" installer - that is, it is not associated with the Guacamole project. I'm not sure who is responsible for maintaining this, and I've no issue with it being provided or linked or with folks using it - I'm glad that the community is building tools like this - but I just am not familiar with it. It does look like the upgrade script includes commands to run the extra SQL upgrade files, but only if you're not providing an external (existing) MySQL DB: https://github.com/itiligent/Easy-Guacamole-Installer/blob/04151be101f37773aee19ac27c729f6ee9b91705/upgrade-guacamole.sh#L223-L249 > I also didn't see any note, that a manual DB migration would be neccessary > for the app not to crash, in the announcement, but let me know if I missed > that. > > This is documented generally in the manual: https://guacamole.apache.org/doc/gug/mysql-auth.html#upgrading-an-existing-guacamole-database Also, in the 1.6.0 release notes (" https://guacamole.apache.org/releases/1.6.0/";), under the "Deprecation/Compatibility" section there is a note specifically about the new Audit permission ("New AUDIT permission in database schema"), which states: "The new audit-specific permission requires a new entry in the guacamole_system_permission_type enum used by the various Guacamole database implementations, which requires schema changes. To upgrade your database to the latest version, run the relevant upgrade-pre-1.6.0.sql script against your database." -Nick
