fetch() API socket hang up

[DieSchoeneWolke]

Hello,

I am running code-server in docker behind caddy2 as a reverse proxy and can access my website with the node.js http-server as backend at https://domain.com/proxy/5050/index.html. My website also includes an API endpoint which is working fine locally in vs-code at http://127.0.0.1:5000/api/user. However I have issues now while using code-server when I change my endpoint to https://domain.com/proxy/5000/api/user in which I receive a socket hang up message after loading the page for quite some time. The network tab in the developer console of my browser shows 0 transferred bytes.

Does anyone know how I would have to change my setup that it will work with code-server?
Thank you very much for your replies!

[code-asher]

Is your app using http or is that a typo? Can you make it use https instead?

[code-asher]

Is your app something you can share so I can try reproducing? Or if not are you able to make a simple reproduction?

It certainly seems weird that it can load HTML from one proxied port but not an API response from another port. Are you able to log all requests to your app? I wonder if it is getting hung up in code-server or in the app.

[DieSchoeneWolke]

You can find the code of my application here:
https://github.com/DieSchoeneWolke/JavaScriptWorkbench

A live version through code-server is linked in the 'About' section.

[code-asher]

Thanks! I tested and I get responses from /api/user when I fill out an invalid email which indicates the proxy is working, for me at least.

But it hangs when I try to create a user with a valid email. Looks like the database call is hanging but I am not sure why. I confirmed I can access it with mysql -uroot -p, and I set the timeout to 1 second but it just hangs forever.

In your case is it also hanging here? Could explain the socket hang up if so.

[DieSchoeneWolke]

I was trying to resolve this by installing MySQL within my custom ubuntu code-server image or use the mysql-server bookworm image as base, which didn't succeed because I am not able to reach the socket or install it in another way, because I don't have systemd as init system in my container and I don't want to run it in privileged mode to be able to use systemd.

This is what I get in the logs:

[2024-08-29T15:42:44.081] [ERROR] api - Error while getting the user  An error occurred while executing the SQL query
[2024-08-29T15:42:44.083] [ERROR] startup - Something went wrong: Error: An error occurred while executing the SQL query
    at Object.query (/VSCode/JavaScript/Tutorial/JavaScriptWorkbench/src/services/db_user.js:17:11)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async Object.getMultiple (/VSCode/JavaScript/Tutorial/JavaScriptWorkbench/src/services/user.js:10:16)
    at async /VSCode/JavaScript/Tutorial/JavaScriptWorkbench/src/routes/user.js:35:14
[2024-08-29T15:42:54.117] [ERROR] db - Error executing SQL query: Error: getaddrinfo ENOTFOUND 192.168.0.1:3306
    at Object.createConnection (/VSCode/JavaScript/Tutorial/JavaScriptWorkbench/node_modules/mysql2/promise.js:253:31)
    at Object.query (/VSCode/JavaScript/Tutorial/JavaScriptWorkbench/src/services/db_user.js:10:36)
    at Object.getMultiple (/VSCode/JavaScript/Tutorial/JavaScriptWorkbench/src/services/user.js:10:25)
    at /VSCode/JavaScript/Tutorial/JavaScriptWorkbench/src/routes/user.js:35:25
    at Layer.handle [as handle_request] (/VSCode/JavaScript/Tutorial/JavaScriptWorkbench/node_modules/express/lib/router/layer.js:95:5)
    at next (/VSCode/JavaScript/Tutorial/JavaScriptWorkbench/node_modules/express/lib/router/route.js:149:13)
    at Route.dispatch (/VSCode/JavaScript/Tutorial/JavaScriptWorkbench/node_modules/express/lib/router/route.js:119:3)
    at Layer.handle [as handle_request] (/VSCode/JavaScript/Tutorial/JavaScriptWorkbench/node_modules/express/lib/router/layer.js:95:5)
    at /VSCode/JavaScript/Tutorial/JavaScriptWorkbench/node_modules/express/lib/router/index.js:284:15
    at Function.process_params (/VSCode/JavaScript/Tutorial/JavaScriptWorkbench/node_modules/express/lib/router/index.js:346:12) {
  code: 'ENOTFOUND',
  errno: -3008,
  sqlState: undefined
}

Setting the timeouts in my database:

SET GLOBAL wait_timeout = 1;
SET GLOBAL interactive_timeout = 1;

Also does nothing to me.

[code-asher]

For now I patched out the database call and just return success, and the proxy seems to be working, at least.

$ curl 'http://localhost:8080/proxy/3000/api/user' -X POST -H 'Content-Type: application/json' --data-raw '{"fname":"test","lname":"test","department":"controlling","email":"[email protected]"}'
{"message":"user entry created successfully"}