Integration with Hadera Fails Due to 'Could not detect network' Error

[youssefea]

Issue Description: When trying to integrate Hadera Mainnet with SubQuery, the initialization process fails, raising an error related to "Error: could not detect network (event="noNetwork", code=NETWORK_ERROR, version=providers/5.7.2)".

Log Output: hadera-starter-postgres-1 | 2023-09-07 16:12:31.588 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 hadera-starter-postgres-1 | 2023-09-07 16:12:31.588 UTC [1] LOG: listening on IPv6 address "::", port 5432 hadera-starter-postgres-1 | 2023-09-07 16:12:31.592 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" hadera-starter-postgres-1 | 2023-09-07 16:12:31.630 UTC [61] LOG: database system was shut down at 2023-09-07 16:12:31 UTC hadera-starter-postgres-1 | 2023-09-07 16:12:31.659 UTC [1] LOG: database system is ready to accept connections hadera-starter-subquery-node-1 | 2023-09-07T16:12:36.512Z <subql-node> INFO Current @subql/node-ethereum version is 2.12.3 hadera-starter-subquery-node-1 | 2023-09-07T16:12:36.512Z <subql-node> INFO Current @subql/node-ethereum version is 2.12.3 hadera-starter-subquery-node-1 | 2023-09-07T16:12:36.734Z <api.ethereum> INFO Api host: mainnet.hashio.io, method: https hadera-starter-subquery-node-1 | 2023-09-07T16:12:36.761Z <db> WARN Database does not support SSL connection, will try to connect without it hadera-starter-subquery-node-1 | 2023-09-07T16:12:37.435Z <api> ERROR Failed to init api service Error: could not detect network (event="noNetwork", code=NETWORK_ERROR, version=providers/5.7.2) hadera-starter-subquery-node-1 exited with code 0 hadera-starter-subquery-node-1 | 2023-09-07T16:12:39.762Z <subql-node> INFO Current @subql/node-ethereum version is 2.12.3 hadera-starter-subquery-node-1 | 2023-09-07T16:12:39.764Z <subql-node> INFO Current @subql/node-ethereum version is 2.12.3 hadera-starter-subquery-node-1 | 2023-09-07T16:12:39.979Z <api.ethereum> INFO Api host: mainnet.hashio.io, method: https hadera-starter-subquery-node-1 | 2023-09-07T16:12:40.007Z <db> WARN Database does not support SSL connection, will try to connect without it hadera-starter-subquery-node-1 | 2023-09-07T16:12:40.634Z <api> ERROR Failed to init api service Error: could not detect network (event="noNetwork", code=NETWORK_ERROR, version=providers/5.7.2) dependency failed to start: container hadera-starter-subquery-node-1 is unhealthy

Steps to Reproduce:

• Set up a SubQuery EVM Project.
• Add details from Hadera chain and this WHBAR token to index transfers and approvals.
• Run yarn dev.
• This branch has a project on it already: Hadera branch

Suggested Solutions: Investigate the cause of the error if it comes from the SubQuery SDK. Close this issue if you believe the problem comes from RPC endpoint.