Hi Nick, It was an upgrade from 1.5.5 to 1.6.0
Yeah fully agree with that and that is okay, I did not want support about the installer. Ah yes I've seen it now and was able to do the migration. While not everyone is that invested in Software deployment to immediately pick that up, as I'm used such things requiring manual invervention are highlighted a big bigger, but yeah then that one goes on me for not reading properly :P Audit Permission is fixed after running the Schema-Update. Thanks a lot! - Tobias Sent with [Proton Mail](https://pr.tn/ref/BTTM5JG4EZEG) secure email. On Monday, July 7th, 2025 at 18:43, Nick Couchman <vn...@apache.org> wrote: > On Mon, Jul 7, 2025 at 11:17 AM <newslet...@tobiasmeier.dev.invalid> 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
