Generate Backup Feature in GUI giving error

[zain3822]

Issue:
I had installed Snipe IT on Windows Server 2002 Database Edition. The issue which I was facing was that GUI based "Generate Backup" button was giving multiple errors. CLI based backup command was executing perfectly (after correcting the path to dump file as mentioned in documentation). I had followed all of the steps mentioned here:

https://snipe-it.readme.io/docs/windowsiis

Pasting some part of the error (Total 51 errors):

Error: Backup failed because: The dump process failed with a none successful exitcode. Exitcode ======== 1: General error Output ====== Error Output ============ . #0 C:\inetpub\wwwroot\snipe-it\vendor\spatie\db-dumper\src\DbDumper.php(194): Spatie\DbDumper\Exceptions\DumpFailed::processDidNotEndSuccessfully() #1 C:\inetpub\wwwroot\snipe-it\vendor\spatie\db-dumper\src\Databases\MySql.php(170): Spatie\DbDumper\DbDumper->checkIfDumpWasSuccessFul() #2 C:\inetpub\wwwroot\snipe-it\vendor\spatie\laravel-backup\src\Tasks\Backup\BackupJob.php(281): Spatie\DbDumper\Databases\MySql->dumpToFile() #3 [internal function]: Spatie\Backup\Tasks\Backup\BackupJob->{closure:Spatie\Backup\Tasks\Backup\BackupJob::dumpDatabases():247}() #4 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Collections\Arr.php(600): array_map() #5 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Collections\Collection.php(778): Illuminate\Support\Arr::map()Backup failed because: The dump process failed with a none successful exitcode. Exitcode ======== 1: General error Output ====== Error Output ============ .

Solution:

The solution was to add a user "IIS_IUSRS" and give all permissions to this user, instead of "IUSR" as mentioned in documentation.

After adding the user with above mentioned spellings, generate backup feature started working perfectly.

Snipe-IT version: 7.0.14
PHP Version: 8.3.16
Maria DB Version: 11.6
Laravel Version: 10.48.25

[welcome]

👋 Thanks for opening your first issue here! If you're reporting a 🐞 bug, please make sure you include steps to reproduce it. We get a lot of issues on this repo, so please be patient and we will get back to you as soon as we can.

[snipe]

Duplicate of #15873