Migration v4.5.45 -> v5.3.54-C75 [docker, traefik]

Hi there,

first of all: thanks for all the work on IN - much appreciated!

My setup is IN4 and IN5 running in Docker containers, reverse proxy is traefik with LE SSL. Both instances itself work flawlessly. Credentials [+ company name] are the same in both instances.

This is probably a stupid mistake, but I can’t seem to find it. When starting Migration in v4 it immediately stops: Failed to connect to IN5DOMAIN port 443: Connection refused

Logs are not that helpful:

ninja4 laravel-error:
[2022-01-31 03:19:11] production.ERROR: ***Unirest\Exception*** [0] : /var/www/app/vendor/mashape/unirest-php/src/Unirest/Request.php [Line 476] => Failed to connect to IN5DOMAIN port 443: Connection refused {"context":"PHP","user_id":1,"account_id":1,"user_name":"My Name","method":"POST","user_agent":"Mozilla/5.0 (X11; Linux x86_64; rv:96.0) Gecko/20100101 Firefox/96.0","locale":"de","ip":"**TRAEFIK's IP**","count":34,"is_console":"no","is_api":"no","db_server":"mysql","url":"migration/auth"} []

ninja4 stacktrace:
2022-01-31 03:19:11 Failed to connect to IN5DOMAIN port 443: Connection refused: #0 /var/www/app/vendor/mashape/unirest-php/src/Unirest/Request.php(292): Unirest\Request::send('POST', 'https://in5domain....', '{"email":"mail...', Array, NULL, NULL) #1 /var/www/app/app/Services/Migration/AuthService.php(56): Unirest\Request::post('https://in5domain....', Array, '{"email":"mail...') #2 /var/www/app/app/Http/Controllers/Migration/StepsController.php(186): App\Services\Migration\AuthService->start() #3 [internal function]: App\Http\Controllers\Migration\StepsController->handleAuth(Object(App\Http\Requests\MigrationAuthRequest)) #4 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #5 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('handleAuth', Array) #6 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Route.php(212): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\Migration\StepsController), 'handleAuth') #7 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Route.php(169): Illuminate\Routing\Route->runController() #8 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Route->run() #9 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #10 /var/www/app/app/Http/Middleware/EligibleForMigration.php(19): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #11 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\Http\Middleware\EligibleForMigration->handle(Object(Illuminate\Http\Request), Object(Closure)) #12 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #13 /var/www/app/app/Http/Middleware/Authenticate.php(122): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #14 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\Http\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure), 'user') #15 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #16 /var/www/app/app/Http/Middleware/DatabaseLookup.php(21): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #17 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\Http\Middleware\DatabaseLookup->handle(Object(Illuminate\Http\Request), Object(Closure), 'user') #18 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #19 /var/www/app/app/Http/Middleware/StartupCheck.php(241): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #20 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\Http\Middleware\StartupCheck->handle(Object(Illuminate\Http\Request), Object(Closure)) #21 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #22 /var/www/app/app/Http/Middleware/QueryLogging.php(32): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #23 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\Http\Middleware\QueryLogging->handle(Object(Illuminate\Http\Request), Object(Closure)) #24 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #25 /var/www/app/app/Http/Middleware/DuplicateSubmissionCheck.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #26 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\Http\Middleware\DuplicateSubmissionCheck->handle(Object(Illuminate\Http\Request), Object(Closure)) #27 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #28 /var/www/app/vendor/turbo124/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #29 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #30 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #31 /var/www/app/vendor/turbo124/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(68): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #32 /var/www/app/app/Http/Middleware/VerifyCsrfToken.php(44): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #33 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #34 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #35 /var/www/app/vendor/turbo124/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #38 /var/www/app/vendor/turbo124/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #40 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #41 /var/www/app/vendor/turbo124/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #44 /var/www/app/vendor/turbo124/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(68): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #46 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #47 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #48 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Router.php(660): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #49 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Router.php(635): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #50 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Router.php(601): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route)) #51 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Router.php(590): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #52 /var/www/app/vendor/turbo124/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #53 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #54 /var/www/app/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php(51): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #55 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(149): Barryvdh\Debugbar\Middleware\InjectDebugbar->handle(Object(Illuminate\Http\Request), Object(Closure)) #56 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/app/vendor/turbo124/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #58 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #59 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #60 /var/www/app/vendor/barryvdh/laravel-cors/src/HandlePreflight.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #61 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(149): Barryvdh\Cors\HandlePreflight->handle(Object(Illuminate\Http\Request), Object(Closure)) #62 /var/www/app/vendor/turbo124/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #63 /var/www/app/vendor/turbo124/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #64 /var/www/app/vendor/turbo124/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #65 /var/www/app/vendor/turbo124/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #66 /var/www/app/public/index.php(51): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #67 {main}

Probably a traefik related error? Absolutely nothing (request not even coming in) in traefik logs though… Any way to do the migration manually?

Thanks!

P.S.: Using v4.5.45 because I couldn’t get any of the v4.5.46(p…) versions running succesfully under docker, but apparently the changes aren’t that big concerning migration…

Hi,

Seems like it may be a networking issue, you may want to try using telnet to ensure the v4 server can access the v5 server.

@david do you have any suggestions?

Hi hillel,

thanks for that suggestion! It got me thinking the right way about the problem. The migration succeeded by providing the IN5-NGINX-Container’s IP in the migration assistent + connecting via HTTP. IP can be found by docker inspect -f '{{range.NetworkSettings.Networks}}{{.IPAddress}}{{end}}' container_name

Thanks for that really fast response, too. IN is a nice product and I am so glad I can use a selfhosted FOSS app for my invoicing.

1 Like