Snipe-It Backup Failure running on Unraid within Docker:

After opening the Backups section and clicking ‘Generate Backup’…
the following error was reported:

An internet search, resulted in the following:
https://github.com/snipe/snipe-it/issues/12497

https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html

https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html

On Unraid, open the ‘Snipe-It’ docker configuration file located on the following path:

/boot/config/plugins/dockerMan/templates-user/my-snipe-it.xml

Collect the following use with mysql alter user command:
* MYSQL_USER
* MYSQL_PASSWORD

mysql -h <mysql.host> -u root -p

use mysql;
ALTER USER '<MYSQL_USER>'@'%' IDENTIFIED WITH mysql_native_password BY '<MYSQL_PASSWORD>';

Retrying resulted with ‘Success’!

Leave a Reply