Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Trying to generate a backup using the backup feature in snipeIT #9866

Closed
1 task done
arikita opened this issue Jul 27, 2021 · 1 comment
Closed
1 task done

Trying to generate a backup using the backup feature in snipeIT #9866

arikita opened this issue Jul 27, 2021 · 1 comment
Labels

Comments

@arikita
Copy link

arikita commented Jul 27, 2021

Please confirm you have done the following before posting your bug report:

Describe the bug
Trying to generate a backup using the backup feature in snipeIT

To Reproduce
Steps to reproduce the behavior:

  1. Go to 'Admin'
  2. Click on 'Backup'
  3. Click on 'General Backup'
  4. See error:
    Error: Backup failed because The dump process failed with exitcode 127 : Command not found : sh: 1: /usr/bin/mysqldump: not found . #0 /var/www/html/snipeit/vendor/spatie/db-dumper/src/DbDumper.php(263): Spatie\DbDumper\Exceptions\DumpFailed::processDidNotEndSuccessfully() Fix depreciation math #1 /var/www/html/snipeit/vendor/spatie/db-dumper/src/Databases/MySql.php(203): Spatie\DbDumper\DbDumper->checkIfDumpWasSuccessFul() Ability for admin to check out an asset to a user #2 /var/www/html/snipeit/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(252): Spatie\DbDumper\Databases\MySql->dumpToFile() Add reports - depreciation, people with no assets, etc #3 [internal function]: Spatie\Backup\Tasks\Backup\BackupJob->Spatie\Backup\Tasks\Backup{closure}() Add category back to Models blade/controller #4 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Support/Collection.php(638): array_map() Needs sexy dashboard summary #5 /var/www/html/snipeit/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(255): Illuminate\Support\Collection->map() Disallow models/depreciations/categories to be deleted if they have assets associated #6 /var/www/html/snipeit/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(169): Spatie\Backup\Tasks\Backup\BackupJob->dumpDatabases() Add location to users, propagate those to assets #7 /var/www/html/snipeit/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(145): Spatie\Backup\Tasks\Backup\BackupJob->createBackupManifest() Figure out how to handle multi-seat licenses #8 /var/www/html/snipeit/vendor/spatie/laravel-backup/src/Commands/BackupCommand.php(56): Spatie\Backup\Tasks\Backup\BackupJob->run() Search box isn't hooked up to anything #9 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Spatie\Backup\Commands\BackupCommand->handle() Improve UI of category display to show nesting #10 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container{closure}() Build-out ACLs to set who can view which sections (reports, etc) #11 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() A user (non-admin) should be able to request an asset [$15] #12 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() Column sorting on table displays #13 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\Container\BoundMethod::call() Add "clone" option in edit screen for assets #14 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call() Option to mark assets as requestable. #15 /var/www/html/snipeit/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute() Child assets linked to parent assets (HDD, replacement parts, etc) [$100] #16 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run() Add warrantee field to assets/models #17 /var/www/html/snipeit/vendor/spatie/laravel-backup/src/Commands/BaseCommand.php(16): Illuminate\Console\Command->run() Move validation out of the controllers and into the models where it belongs #18 /var/www/html/snipeit/vendor/symfony/console/Application.php(1009): Spatie\Backup\Commands\BaseCommand->run() Seed database with models, manufacturers, categories, etc. #19 /var/www/html/snipeit/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand() Import functions for users, assets, models, etc #20 /var/www/html/snipeit/vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun() Merge licenses table into assets table #21 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\Component\Console\Application->run() Fix depreciation on model vs asset #22 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Console/Application.php(185): Illuminate\Console\Application->run() Support multiple companies [$500 awarded] #23 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(273): Illuminate\Console\Application->call() Tighten up checkin/checkout UX #24 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Foundation\Console\Kernel->call() Show number of assets for each asset model in listing page #25 /var/www/html/snipeit/app/Http/Controllers/SettingsController.php(1068): Illuminate\Support\Facades\Facade::__callStatic() Handle errors more sanely when nothing in the DB #26 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\SettingsController->postBackups() Depreciation fix #27 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction() Fix tables on mobile #28 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\Routing\ControllerDispatcher->dispatch() Integrate barcode generation #29 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\Routing\Route->runController() Confirmation screens on delete #30 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\Routing\Route->run() Fixing bootstrap process with default values. #31 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Routing\Router->Illuminate\Routing{closure}() Added confirmation popups for deletes #32 /var/www/html/snipeit/app/Http/Middleware/CheckPermissions.php(26): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Add notion of lost, stolen, out for deployment, RTD, etc #33 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\CheckPermissions->handle() Update asset index/view blade to reflect new status  #34 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Add CSV export for reports #35 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Auth\Middleware\Authenticate->handle() Make the Edit Profile page look less assy #36 /var/www/html/snipeit/app/Http/Middleware/AssetCountForSidebar.php(56): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() incorrect command chown in README #37 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\AssetCountForSidebar->handle() Develop #38 /var/www/html/snipeit/vendor/laravel/passport/src/Http/Middleware/CreateFreshApiToken.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Implement settings  #39 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Laravel\Passport\Http\Middleware\CreateFreshApiToken->handle() Settings edit #40 /var/www/html/snipeit/app/Http/Middleware/CheckForTwoFactor.php(36): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Add asset_type to Asset controller #41 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\CheckForTwoFactor->handle() Fix delete-check on licenses #42 /var/www/html/snipeit/app/Http/Middleware/CheckLocale.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Fix checkout for licenses #43 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\CheckLocale->handle() Fix depreciation report with new licenses structure #44 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() When you soft-delete a user, should free up all associated resources  #45 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle() Fix miscount on assets in user view #46 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() When the number of seats is edited, handle that smartly #47 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle() LDAP authentication #48 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Calendar view(s) for asset check out/in, due date, etc. [$20] #49 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\EncryptCookies->handle() XSS Issues #50 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Add postcode to locations #51 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\Pipeline\Pipeline->then() Make the report columns sortable #52 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Router->runRouteWithinStack() Add autocomplete to the search box #53 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\Routing\Router->runRoute() New button weirdly placed on my iPad (3rd gen) #54 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(613): Illuminate\Routing\Router->dispatchToRoute() Show months until asset is fully depreciated #55 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): Illuminate\Routing\Router->dispatch() Disable sorting on action column #56 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}() Spaces get filtered out #57 /var/www/html/snipeit/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php(60): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Modal stops passing title/message/href through if modal is canceled #58 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Barryvdh\Debugbar\Middleware\InjectDebugbar->handle() Checkin message is wrong #59 /var/www/html/snipeit/app/Http/Middleware/SecurityHeaders.php(26): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() CSRF protect all of the things #60 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\SecurityHeaders->handle() DB seed fails when mysql is in strict mode #61 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Add 'retired' status #62 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() Asset Notes #63 /var/www/html/snipeit/app/Http/Middleware/CheckForDebug.php(25): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Notifications for when warranties are expiring... #64 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\CheckForDebug->handle() Invalid SQL #65 /var/www/html/snipeit/app/Http/Middleware/CheckForSetup.php(26): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Broken Gravatar URL in SSL-only environments #66 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\CheckForSetup->handle() Patch 1 #67 /var/www/html/snipeit/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Fix insecure content warnings #68 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Fideloper\Proxy\TrustProxies->handle() Initial install script failing on db installation, tries to drop tables that don't exist #69 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Modify the Assets and Licenses controllers and database schemas to work #70 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\View\Middleware\ShareErrorsFromSession->handle() Can't edit address fields on locations #71 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Add address to location form #72 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Session\Middleware\StartSession->handle() Email input types #73 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() change location to status on assets table header #74 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle() License Count misreporting #75 /var/www/html/snipeit/app/Http/Middleware/NoSessionStore.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Purchase as separate entity #76 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\NoSessionStore->handle() Allow '+' in Model Name & No #77 /var/www/html/snipeit/vendor/barryvdh/laravel-cors/src/HandlePreflight.php(29): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Expand Manufacturer #78 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Barryvdh\Cors\HandlePreflight->handle() Services Management Section [big, needs fleshing out] #79 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() Re-jigger the asset displays to make "more info" more prominent #80 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\Pipeline\Pipeline->then() File uploads #81 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() allow more characters in model name (and number) #82 /var/www/html/snipeit/public/index.php(58): Illuminate\Foundation\Http\Kernel->handle() Ignoring production configs #83 {main} Backup failed because: The dump process failed with exitcode 127 : Command not found : sh: 1: /usr/bin/mysqldump: not found .

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
image

Server (please complete the following information):

  • Snipe-IT Version v5.1.8
  • OS: [e.g. Ubuntu, CentOS] Ubuntu 20.04.2 LTS
  • Web Server: [e.g. Apache, IIS]: Laravel 6.20.29
  • PHP Version: 7.4.3

Desktop (please complete the following information):

  • OS: [e.g. iOS]: windows 10 pro
  • Browser [e.g. chrome, safari]: chrome
  • Version [e.g. 22]: 91.0.4472.164

Smartphone (please complete the following information):

  • Device: [e.g. iPhone6]
  • OS: [e.g. iOS8.1]
  • Browser [e.g. stock browser, safari]
  • Version [e.g. 22]

Error Messages

  • WITH DEBUG TURNED ON, if you're getting an error in your browser, include that error
  • If a stacktrace is provided in the error, include that too.
  • Any errors that appear in your browser's error console.
  • Confirm whether the error is reproducible on the demo: https://snipeitapp.com/demo.
  • Include any additional information you can find in storage/logs and your webserver's logs.
  • Include the output from php -m (this should display what modules you have enabled.)

Additional context

  • Is this a fresh install or an upgrade? fresh
  • What OS and web server you're running Snipe-IT on
  • What method you used to install Snipe-IT (install.sh, manual installation, docker, etc)
  • Include what you've done so far in the installation, and if you got any error messages along the way.
  • Indicate whether or not you've manually edited any data directly in the database

Add any other context about the problem here.

Please do not post an issue without answering the related questions above. If you have opened a different issue and already answered these questions, answer them again, once for every ticket. It will be next to impossible for us to help you.

@aduzsardi
Copy link

you don't have mysqldump installed , as clearly the error message says on first line

Command not found : sh: 1: /usr/bin/mysqldump

@snipe snipe added the backups label Mar 21, 2022
@snipe snipe closed this as completed Aug 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants