Invalid Login after used guac-upgrade.sh to upgrade from 1.2 to 1.3

[rolandcheung]

Hi, I used guac-upgrade.sh to upgrade from 1.2 to 1.3 and then find those existing Guac user cannot account to login. It got invalid login error in screen.

I manual create a new user in guacamole_db INSERT INTO guacamole_entity (name, type) VALUES ('newuser', 'USER'); INSERT INTO guacamole_user (entity_id,password_salt,password_hash, password_date,disabled,expired) values(12,'',UNHEX(SHA2('newuserpassword',256)),'2021-05-26 00:00:00',0,0); and login still failure.

Here is the log in /var/log/tomcat9 42.2.72.140 - - [26/May/2021:18:04:01 +0000] "GET / HTTP/1.1" 200 5414 42.2.72.140 - - [26/May/2021:18:04:01 +0000] "GET /app.css?v=1.2.0 HTTP/1.1" 200 59449 42.2.72.140 - - [26/May/2021:18:04:01 +0000] "GET /webjars/simonwep__pickr/1.2.6/dist/themes/monolith.min.css HTTP/1.1" 200 8531 42.2.72.140 - - [26/May/2021:18:04:02 +0000] "GET /app.js?v=1.2.0 HTTP/1.1" 200 371334 42.2.72.140 - - [26/May/2021:18:04:03 +0000] "POST /api/tokens HTTP/1.1" 403 279 42.2.72.140 - - [26/May/2021:18:04:03 +0000] "GET /api/languages?token=A5E7F467BE81F73BD06A65EFC79D2FF7C3F08ED6DB4B59AF4A2FA483F04B5387 HTTP/1.1" 200 205 42.2.72.140 - - [26/May/2021:18:04:03 +0000] "GET /api/patches?token=A5E7F467BE81F73BD06A65EFC79D2FF7C3F08ED6DB4B59AF4A2FA483F04B5387 HTTP/1.1" 200 12 42.2.72.140 - - [26/May/2021:18:04:03 +0000] "GET /images/logo-64.png HTTP/1.1" 200 5082 42.2.72.140 - - [26/May/2021:18:04:03 +0000] "GET /translations/en.json HTTP/1.1" 200 55613 42.2.72.140 - - [26/May/2021:18:04:31 +0000] "POST /api/tokens HTTP/1.1" 403 279 42.2.72.140 - - [26/May/2021:18:08:41 +0000] "POST /api/tokens HTTP/1.1" 403 279

Would you help me to troubleshoot the problem.

Thanks

[MysticRyuujin]

Was your original 1.2 installation installed from the script in this repo, or was it installed is some other way (e.g. manually, via other instructions, etc?)

[rolandcheung]

Hi Chase,

Thanks for your reply I use v1.2 installation script as attached screenshot

Due to forgot mysql db root user password, I have follow the instruction to reset it https://devanswers.co/how-to-reset-mysql-root-password-ubuntu/ before execute the upgrade script

Do you need log data, please instruct me how to collect if need.

Cheers, Roland