Snipe-it: Service reported 500 error

[kevin-chen05]

My version is v4.7.5, 500 errors occurred when the asset was imported. Now debugging mode log information is enabled as follows:
root@8c2670604451:/var/www/html/storage/logs# tail -f laravel.log

[2019-08-15 13:05:00] production.ERROR: SymfonyComponentDebugExceptionFatalThrowableError: Type error: Argument 1 passed to SpatieDbDumperDbDumper::setPort() must be of the type integer, string given, called in /var/www/html/vendor/spatie/laravel-backup/src/Tasks/Backup/DbDumperFactory.php on line 36 in /var/www/html/vendor/spatie/db-dumper/src/DbDumper.php:117
Stack trace:

0 /var/www/html/vendor/spatie/laravel-backup/src/Tasks/Backup/DbDumperFactory.php(36): SpatieDbDumperDbDumper->setPort('${MYSQL_PORT_33...')

1 /var/www/html/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJobFactory.php(28): SpatieBackupTasksBackupDbDumperFactory::createFromConnection('mysql')

2 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Collection.php(928): SpatieBackupTasksBackupBackupJobFactory::SpatieBackupTasksBackup{closure}('mysql', 0)

3 /var/www/html/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJobFactory.php(29): IlluminateSupportCollection->mapWithKeys(Object(Closure))

4 /var/www/html/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJobFactory.php(14): SpatieBackupTasksBackupBackupJobFactory::createDbDumpers(Array)

5 /var/www/html/vendor/spatie/laravel-backup/src/Commands/BackupCommand.php(27): SpatieBackupTasksBackupBackupJobFactory::createFromArray(Array)

6 [internal function]: SpatieBackupCommandsBackupCommand->handle()

7 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(29): call_user_func_array(Array, Array)

8 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(87): IlluminateContainerBoundMethod::IlluminateContainer{closure}()

9 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(31): IlluminateContainerBoundMethod::callBoundMethod(Object(IlluminateFoundationApplication), Array, Object(Closure))

10 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(549): IlluminateContainerBoundMethod::call(Object(IlluminateFoundationApplication), Array, Array, NULL)

11 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): IlluminateContainerContainer->call(Array)

12 /var/www/html/vendor/symfony/console/Command/Command.php(255): IlluminateConsoleCommand->execute(Object(SymfonyComponentConsoleInputArrayInput), Object(IlluminateConsoleOutputStyle))

13 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(170): SymfonyComponentConsoleCommandCommand->run(Object(SymfonyComponentConsoleInputArrayInput), Object(IlluminateConsoleOutputStyle))

14 /var/www/html/vendor/spatie/laravel-backup/src/Commands/BaseCommand.php(16): IlluminateConsoleCommand->run(Object(SymfonyComponentConsoleInputArrayInput), Object(SymfonyComponentConsoleOutputBufferedOutput))

15 /var/www/html/vendor/symfony/console/Application.php(960): SpatieBackupCommandsBaseCommand->run(Object(SymfonyComponentConsoleInputArrayInput), Object(SymfonyComponentConsoleOutputBufferedOutput))

16 /var/www/html/vendor/symfony/console/Application.php(255): SymfonyComponentConsoleApplication->doRunCommand(Object(SpatieBackupCommandsBackupCommand), Object(SymfonyComponentConsoleInputArrayInput), Object(SymfonyComponentConsoleOutputBufferedOutput))

17 /var/www/html/vendor/symfony/console/Application.php(148): SymfonyComponentConsoleApplication->doRun(Object(SymfonyComponentConsoleInputArrayInput), Object(SymfonyComponentConsoleOutputBufferedOutput))

18 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Application.php(88): SymfonyComponentConsoleApplication->run(Object(SymfonyComponentConsoleInputArrayInput), Object(SymfonyComponentConsoleOutputBufferedOutput))

19 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Application.php(177): IlluminateConsoleApplication->run(Object(SymfonyComponentConsoleInputArrayInput), Object(SymfonyComponentConsoleOutputBufferedOutput))

20 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(249): IlluminateConsoleApplication->call('backup:run', Object(IlluminateSupportCollection), NULL)

21 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): IlluminateFoundationConsoleKernel->call('backup:run')

22 /var/www/html/app/Http/Controllers/Api/ImportController.php(122): IlluminateSupportFacadesFacade::__callStatic('call', Array)

23 [internal function]: AppHttpControllersApiImportController->process(Object(AppHttpRequestsItemImportRequest), '48')

24 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array)

25 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): IlluminateRoutingController->callAction('process', Array)

26 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): IlluminateRoutingControllerDispatcher->dispatch(Object(IlluminateRoutingRoute), Object(AppHttpControllersApiImportController), 'process')

27 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(169): IlluminateRoutingRoute->runController()

28 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): IlluminateRoutingRoute->run()

29 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): IlluminateRoutingRouter->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

30 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(57): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

31 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): IlluminateRoutingMiddlewareThrottleRequests->handle(Object(IlluminateHttpRequest), Object(Closure), 120, '1')

32 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

33 /var/www/html/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

34 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): IlluminateAuthMiddlewareAuthenticate->handle(Object(IlluminateHttpRequest), Object(Closure), 'api')

35 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

36 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

37 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(660): IlluminatePipelinePipeline->then(Object(Closure))

38 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(635): IlluminateRoutingRouter->runRouteWithinStack(Object(IlluminateRoutingRoute), Object(IlluminateHttpRequest))

39 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(601): IlluminateRoutingRouter->runRoute(Object(IlluminateHttpRequest), Object(IlluminateRoutingRoute))

40 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(590): IlluminateRoutingRouter->dispatchToRoute(Object(IlluminateHttpRequest))

41 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): IlluminateRoutingRouter->dispatch(Object(IlluminateHttpRequest))

42 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): IlluminateFoundationHttpKernel->IlluminateFoundationHttp{closure}(Object(IlluminateHttpRequest))

43 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php(65): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

44 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): BarryvdhDebugbarMiddlewareInjectDebugbar->handle(Object(IlluminateHttpRequest), Object(Closure))

45 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

46 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

47 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): IlluminateFoundationHttpMiddlewareTransformsRequest->handle(Object(IlluminateHttpRequest), Object(Closure))

48 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

49 /var/www/html/app/Http/Middleware/CheckForDebug.php(25): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

50 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): AppHttpMiddlewareCheckForDebug->handle(Object(IlluminateHttpRequest), Object(Closure))

51 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

52 /var/www/html/app/Http/Middleware/CheckForSetup.php(27): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

53 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): AppHttpMiddlewareCheckForSetup->handle(Object(IlluminateHttpRequest), Object(Closure))

54 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

55 /var/www/html/vendor/fideloper/proxy/src/TrustProxies.php(57): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

56 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): FideloperProxyTrustProxies->handle(Object(IlluminateHttpRequest), Object(Closure))

57 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

58 /var/www/html/app/Http/Middleware/NosniffGuard.php(17): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

59 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): AppHttpMiddlewareNosniffGuard->handle(Object(IlluminateHttpRequest), Object(Closure))

60 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

61 /var/www/html/app/Http/Middleware/ContentSecurityPolicyHeader.php(18): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

62 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): AppHttpMiddlewareContentSecurityPolicyHeader->handle(Object(IlluminateHttpRequest), Object(Closure))

63 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

64 /var/www/html/app/Http/Middleware/ReferrerPolicyHeader.php(17): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

65 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): AppHttpMiddlewareReferrerPolicyHeader->handle(Object(IlluminateHttpRequest), Object(Closure))

66 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

67 /var/www/html/app/Http/Middleware/XssProtectHeader.php(18): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

68 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): AppHttpMiddlewareXssProtectHeader->handle(Object(IlluminateHttpRequest), Object(Closure))

69 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

70 /var/www/html/app/Http/Middleware/FrameGuard.php(17): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

71 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): AppHttpMiddlewareFrameGuard->handle(Object(IlluminateHttpRequest), Object(Closure))

72 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

73 /var/www/html/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

74 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): IlluminateViewMiddlewareShareErrorsFromSession->handle(Object(IlluminateHttpRequest), Object(Closure))

75 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

76 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

77 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): IlluminateSessionMiddlewareStartSession->handle(Object(IlluminateHttpRequest), Object(Closure))

78 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

79 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

80 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): IlluminateFoundationHttpMiddlewareCheckForMaintenanceMode->handle(Object(IlluminateHttpRequest), Object(Closure))

81 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))

82 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): IlluminateRoutingPipeline->IlluminateRouting{closure}(Object(IlluminateHttpRequest))

83 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): IlluminatePipelinePipeline->then(Object(Closure))

84 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): IlluminateFoundationHttpKernel->sendRequestThroughRouter(Object(IlluminateHttpRequest))

85 /var/www/html/public/index.php(58): IlluminateFoundationHttpKernel->handle(Object(IlluminateHttpRequest))

86 {main}

[2019-08-15 13:05:00] production.ERROR: Type error: Argument 1 passed to SpatieDbDumperDbDumper::setPort() must be of the type integer, string given, called in /var/www/html/vendor/spatie/laravel-backup/src/Tasks/Backup/DbDumperFactory.php on line 36 {"userId":3,"exception":"[object] (Symfony\Component\Debug\Exception\FatalThrowableError(code: 0): Type error: Argument 1 passed to Spatie\DbDumper\DbDumper::setPort() must be of the type integer, string given, called in /var/www/html/vendor/spatie/laravel-backup/src/Tasks/Backup/DbDumperFactory.php on line 36 at /var/www/html/vendor/spatie/db-dumper/src/DbDumper.php:117)
[stacktrace]

0 /var/www/html/vendor/spatie/laravel-backup/src/Tasks/Backup/DbDumperFactory.php(36): Spatie\DbDumper\DbDumper->setPort('${MYSQL_PORT_33...')

1 /var/www/html/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJobFactory.php(28): Spatie\Backup\Tasks\Backup\DbDumperFactory::createFromConnection('mysql')

2 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Collection.php(928): Spatie\Backup\Tasks\Backup\BackupJobFactory::Spatie\Backup\Tasks\Backup\{closure}('mysql', 0)

3 /var/www/html/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJobFactory.php(29): Illuminate\Support\Collection->mapWithKeys(Object(Closure))

4 /var/www/html/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJobFactory.php(14): Spatie\Backup\Tasks\Backup\BackupJobFactory::createDbDumpers(Array)

5 /var/www/html/vendor/spatie/laravel-backup/src/Commands/BackupCommand.php(27): Spatie\Backup\Tasks\Backup\BackupJobFactory::createFromArray(Array)

6 [internal function]: Spatie\Backup\Commands\BackupCommand->handle()

7 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(29): call_user_func_array(Array, Array)

8 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()

9 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure))

10 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(549): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL)

11 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call(Array)

12 /var/www/html/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArrayInput), Object(Illuminate\Console\OutputStyle))

13 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(170): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Illuminate\Console\OutputStyle))

14 /var/www/html/vendor/spatie/laravel-backup/src/Commands/BaseCommand.php(16): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

15 /var/www/html/vendor/symfony/console/Application.php(960): Spatie\Backup\Commands\BaseCommand->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

16 /var/www/html/vendor/symfony/console/Application.php(255): Symfony\Component\Console\Application->doRunCommand(Object(Spatie\Backup\Commands\BackupCommand), Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

17 /var/www/html/vendor/symfony/console/Application.php(148): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

18 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Application.php(88): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

19 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Application.php(177): Illuminate\Console\Application->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

20 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(249): Illuminate\Console\Application->call('backup:run', Object(Illuminate\Support\Collection), NULL)

21 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Foundation\Console\Kernel->call('backup:run')

22 /var/www/html/app/Http/Controllers/Api/ImportController.php(122): Illuminate\Support\Facades\Facade::__callStatic('call', Array)

23 [internal function]: App\Http\Controllers\Api\ImportController->process(Object(App\Http\Requests\ItemImportRequest), '48')

24 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array)

25 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('process', Array)

26 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\Api\ImportController), 'process')

27 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(169): Illuminate\Routing\Route->runController()

28 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Route->run()

29 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

30 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(57): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

31 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Routing\Middleware\ThrottleRequests->handle(Object(Illuminate\Http\Request), Object(Closure), 120, '1')

32 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))

33 /var/www/html/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

34 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure), 'api')

35 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))

36 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

37 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(660): Illuminate\Pipeline\Pipeline->then(Object(Closure))

38 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(635): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))

39 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(601): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))

40 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(590): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))

41 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))

42 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))

43 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

44 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Barryvdh\Debugbar\Middleware\InjectDebugbar->handle(Object(Illuminate\Http\Request), Object(Closure))

45 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))

46 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

47 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))

48 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))

49 /var/www/html/app/Http/Middleware/CheckForDebug.php(25): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

50 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\Http\Middleware\CheckForDebug->handle(Object(Illuminate\Http\Request), Object(Closure))

51 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))

52 /var/www/html/app/Http/Middleware/CheckForSetup.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

53 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\Http\Middleware\CheckForSetup->handle(Object(Illuminate\Http\Request), Object(Closure))

54 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))

55 /var/www/html/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

56 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))

57 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))

58 /var/www/html/app/Http/Middleware/NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

59 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure))

60 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))

61 /var/www/html/app/Http/Middleware/ContentSecurityPolicyHeader.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

62 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\Http\Middleware\ContentSecurityPolicyHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

63 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))

64 /var/www/html/app/Http/Middleware/ReferrerPolicyHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

65 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\Http\Middleware\ReferrerPolicyHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

66 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))

67 /var/www/html/app/Http/Middleware/XssProtectHeader.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

68 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

69 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))

70 /var/www/html/app/Http/Middleware/FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

71 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure))

72 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))

73 /var/www/html/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

74 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))

75 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))

76 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

77 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))

78 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))

79 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

80 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))

81 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))

82 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))

83 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))

84 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))

85 /var/www/html/public/index.php(58): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

86 {main}

"}

[snipe]

What do you have for your DB_PORT in your .env?

[wranders]

@snipe Ran across this issue and that ENV VAR worked.

To add something else to your plate, that VAR isn't mentioned anywhere in the docs.

[Matroxt]

I was trying to run on Docker with the 4.7.7 container (in kubernetes) and adding the DB_PORT variable fixed this specific issue. Didn't find it in the doc indeed.

[jonasbareiss]

Fixed it for me as well. Not working backups also blocked the import assistant from working.

[stale[bot]]

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail.
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

[stale[bot]]

This issue has been automatically closed because it has not had recent activity. If you believe this is still an issue, please confirm that this issue is still happening in the most recent version of Snipe-IT and reply to this thread to re-open it.

[dev-head]

I don't think this issue should have been closed; there has been no repair to resolve it and docs don't reflect the DB_PORT being required in the first place. really it should just be defaulted somewhere; it's strange to fail on this one error.

[snipe]

DB_PORT is not required. It never has been. It defaults to the... default port.

[MikeFathom5]

@snipe That is incorrect. Attempting a manual backup from within a docker container generates this error:

root@3baab39ca490:/var/www/html# php artisan snipeit:backup
Starting backup...

In DbDumper.php line 117:

  Type error: Argument 1 passed to Spatie\DbDumper\DbDumper::setPort() must be of the type integer, string given, cal
  led in /var/www/html/vendor/spatie/laravel-backup/src/Tasks/Backup/DbDumperFactory.php on line 36

Backups through the web interface likewise generate the same error. Please either reopen this issue or update your documentation.

[bashou]

@snipe @MikeFathom5 A workarround just to unlock backups (very clever on production) :
Edit file /var/www/html/vendor/spatie/laravel-backup/src/Tasks/Backup/DbDumperFactory.php in container and change line 36 like this :

$dbDumper = $dbDumper->setPort(intval($dbConfig['port']));

⚠️ it's not a good idea to do it like this permanently, we need changes from snipe to avoid this bug.

[mikemackintosh]

I started having this issue in 4.9.1 specifically. I use a name unix socket, not TCP for my database so this was throwing the error on me. I updated my_env_file with DB_PORT=0 and it resolved the issue without the code changes.

[Caracca]

same conclusion as @mikemackintosh.
Adding MYSQL_PORT_3306_TCP_PORT=3306 to my .env file resolved the issue without any other changes needed.
(using docker )