Installation: mysql password error

[fsteckel]

When installing on a RPi5, the installer queries for root and guacamole_user passwords. When I set these, installation continues. Then in 2-install-guacamole.sh an error occurs:

Setting MySQL root password...
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Failed. See /home/user/guac-setup/guacamole_install.log
2-install-guacamole.sh FAILED. See /home/user/guac-setup/guacamole_install.log

** software environment:**

• Pi5 running Debian GNU/Linux 12 (bookworm)
• Linux pi5 6.6.62+rpt-rpi-2712 interactive setup? #1 SMP PREEMPT Debian 1:6.6.62-1+rpt1 (2024-11-25) aarch64 GNU/Linux

Troubleshooting steps already taken?:
The guacamole_install.log contains no errors or related information.

[itiligent]

Just a reminder the readme says I only support Raspbian. Debain 12 will be much slower on Pi than native raspian with guacamole btw.. It is simply not possible to capture every variant. AMD64 Debian Stable and Ubuntu LTS only.

The issue likely relates to a slight differening $DB_CMD value in the first script (some versions of MySQL use the "mySQL" in front of sql commands, cmd, others use the "mariadb" in front. The error comes from line 550 in the 2nd script. Something is differrnt with the root login command requirement on the Pi to create the database.

Some workarounds:

• manually test/adapt the script syntax in and around line 550 that first logs on to mysql (or look for other default se linux or apparmor settings that that prevents root login)
• Just use rasbian
• install mysql manually using the official docs with any updated root commands from the officialdocs, then run the installer and point it to a pre-existing mysql instance (it will skip the mysqlsetup).
• Try changing the script parameters to install mariaDB from official repo instead of distro version. (insert 11.4.4 into line 95 in first script)

[fsteckel]

Actually it is just standard Raspberry Pi OS (former raspbian). But as that is derived from debian it is indicated as such.

Thanks for your comment. I'll try.

[itiligent]

I just checked, latest RaspiOS based on Debian 12 was only released 7 weeks ago, so this is normal to find things have changed.

You could also roll back to a supported Raspi version as per the readme and be fine .

Raspi packages often have very many differences to their base OS, this time perhaps with the default mysql packages. Installing mariadb from maria.org should be the best workaraound.

With each new release, scripts often need some research and adjustment, which takes a lot of to test and maintain, so anything you find will be helpful for others. I dont have time to test at present, and I dont own Raspi5.