Server error when query label by using WORMS import label

[cywhale]

When using WORMS import label, always got 500 Server Error. I tried the same query on biigle.de, it's ok and got similar request/response header in DevTools.
I searched issues on biigle/core, and found label-trees have been merged, seems no need to do any additional configuration in build. Any hints or suggestions to figure out this cause of error would be appreciated.
My biigle server got error message on Chrome DevTools:　

main.js?1614700742:2 
GET https://MY_HOST/api/v1/label-sources/1/find?query=Sagitta+pacifica 500 (error)

and Request/Response Header is:

Request URL: https://MYHOST/api/v1/label-sources/1/find?query=Sagitta+pacifica
Request Method: GET
Status Code: 500 
Remote Address: MY_IP:443
Referrer Policy: strict-origin-when-cross-origin

Response Headers:

cache-control: no-cache, private
content-type: application/json
date: Fri, 09 Apr 2021 09:32:58 GMT
server: nginx/1.18.0
set-cookie: biigle_session=eyJpdiI6ImpzMlRTZVZlVE1QWTFRSmNEVklRYXc9PSIsInZhbHVlIjoiYVRYN01mZEQ1VVFtTUFDRzJNeFE2Yk02SW9hM0o0bmdpbWxnT0lqUzRJMExXXC8yZ2EydWtPMytacER0SFVZcHRRR1dCQjNBbnh4MHczbmlVNGJTdXI1bmp3YjlkUE9pMnpIQlVsRG40TkcyXC9nZ1VkUTV5UExvRmlVdVZQU3JuayIsIm1hYyI6IjQxOTA0Y2MyYmU5ZWJmZGQ1NTM4MTJkMjEzYjllZTIwOThiZThjZGQ5NjQ0YzJjNDMxMGI4NzJjOWU4MDQzZDgifQ%3D%3D; expires=Fri, 09-Apr-2021 11:32:58 GMT; Max-Age=7200; path=/; httponly; samesite=lax
strict-transport-security: max-age=63072000; includeSubdomains

[mzur]

Please have a look at the error logs in the admin area (https://MYHOST/admin/logs). You can also find the logs in the filesystem at storage/logs/. Do you find anything that is related to the failing requests?

[cywhale]

Yes, here it is.

[2021-04-09 20:25:09] production.ERROR: SOAP-ERROR: Parsing WSDL: Couldn't load from 'http://www.marinespecies.org/aphia.php?p=soap&wsdl=1' : failed to load external entity "http://www.marinespecies.org/aphia.php?p=soap&wsdl=1"
 {"userId":4,"exception":"[object] (SoapFault(code: 0 faultcode: WSDL): SOAP-ERROR: Parsing WSDL: Couldn't load from 'http://www.marinespecies.org/aphia.php?p=soap&wsdl=1' : failed to load external entity \"http://www.marinespecies.org/aphia.php?p=soap&wsdl=1\"
 at /var/www/app/Services/LabelSourceAdapters/WormsAdapter.php:52)
[stacktrace]
#0 /var/www/app/Services/LabelSourceAdapters/WormsAdapter.php(52): SoapClient->SoapClient('http://www.mari...', Array)
#1 /var/www/app/Services/LabelSourceAdapters/WormsAdapter.php(80): Biigle\\Services\\LabelSourceAdapters\\WormsAdapter->getSoapClient()
#2 /var/www/app/Http/Controllers/Api/LabelSourceController.php(30): Biigle\\Services\\LabelSourceAdapters\\WormsAdapter->find(Object(Illuminate\\Http\\Request))
#3 /var/www/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): Biigle\\Http\\Controllers\\Api\\LabelSourceController->find(Object(Illuminate\\Http\\Request), '1')
#4 /var/www/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('find', Array)
#5 /var/www/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Biigle\\Http\\Controllers\\Api\\LabelSourceController), 'find')
#6 /var/www/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController()
#7 /var/www/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\\Routing\\Route->run()
#8 /var/www/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#9 /var/www/app/Http/Middleware/UpdateUserActivity.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#10 /var/www/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Biigle\\Http\\Middleware\\UpdateUserActivity->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#11 /var/www/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#12 /var/www/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#13 /var/www/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#14 /var/www/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'web', 'api')
#15 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#16 /var/www/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#17 /var/www/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#18 /var/www/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#19 /var/www/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#20 /var/www/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#21 /var/www/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#22 /var/www/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#23 /var/www/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#24 /var/www/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#25 /var/www/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#26 /var/www/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#27 /var/www/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request))
#28 /var/www/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route))
#29 /var/www/vendor/laravel/framework/src/Illuminate/Routing/Router.php(613): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))
#30 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))
#31 /var/www/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request))
#32 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#33 /var/www/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#34 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#35 /var/www/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#36 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#37 /var/www/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#38 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#39 /var/www/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#40 /var/www/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#41 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#42 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))
#43 /var/www/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))

[mzur]

Does your installation run behind a restrictive proxy? Then maybe you need to update the proxy configuration of Docker as well as the SOAP options of BIIGLE.

[cywhale]

I use NGINX as a reverse proxy. I configured my docker-compose.yaml port at

    ports:
      - 8081:80
      - 8008:443

and in NGINX, set a upstream to 8008

upstream biigle {
  server 127.0.0.1:8008;
}

Then, proxy_pass to it

location \ {
...
proxy_pass https://biigle;
}

Indeed, on the same VM (ubuntu 16.04), I also run other servers, such as R shiny-server, GeoServer, and some testing NodeJS server, and all upstream to different ports. Some of them also have REST API and work well. I do not quite sure what "restrictive" means, but I can try how to setup this SOAP configuration?...

[cywhale]

Finally I got it done. One of my application server would do prerouting of iptables. After removing it, SOAP of WORMS import label works. Thanks for your help.