ESP32 SIM800L Firebase Singapore Database Connection Failure

Using Arduino Networking, Protocols, and Devices
1

Hello there,

I am in the middle of working on a project based on ESP32 with SIM800L that is sending data to firebase Realtime database. Right now the database region is in the US so the source format would be like this "https://projectname.firebaseio.com/" now I want to try to move it to Singapore region database (which is closer) and the source format of the database would be like this "https://projectname.asia-southeast1.firebasedatabase.app/".

I was connected to the US region before and there are no problem connecting to the database, but after I change it to the Singapore region I can't manage to connect to the database it's just stuck looping attempting to connect to the database as such

14:38:01.105 -> Connecting to Internet OK
14:38:09.003 -> 
14:38:09.862 -> HTTP Connection Nan 1
14:38:09.862 -> Connecting to Internet OK
14:38:16.029 -> 
14:38:16.215 -> HTTP Connection Nan 2
14:38:16.215 -> Connecting to Internet OK

The setup for the database are the same as the previous one nothing is changed and it's in the same project. I cant change the SSL port because (afaik) SSL port to HTTP web is only 443, I did try change it to other (from the list I found here SSL Port) but no effect. I checked some other forum about this and one thing came out about specifying the instance FirebaseDatabase.getInstance("https://vax-in-60807-default-rtdb.asia-southeast1.firebasedatabase.app") but this was on android, I'm not sure if i have to do any masking for the firebase host and I'm not really sure how to do that if I have to.

I made sure that I'm not using the wrong ceredentials. But at least if I did, the result wouldn't be like that, it would continue to trackerdata(); and show an error 401 incorrect credentials.

here is my script that I used to send data to the US region database

#define TINY_GSM_MODEM_SIM800
#define TINY_GSM_RX_BUFFER 1024

//  Serial SIM800L TTGO CALL
HardwareSerial sim800(1);

//  Serial pin SIM800L Module
//#define rxPin 16
//#define txPin 17

//  I2C for SIM800 in ESP32 TTGO (to keep it running when powered from battery)
TwoWire I2CPower = TwoWire(0);

//  Setup for ESP32 TTGO Call

#define MODEM_RST 5
#define MODEM_PWKEY 4
#define MODEM_POWER_ON 23
#define MODEM_TX 27
#define MODEM_RX 26

TinyGsm modem(sim800);

//  Firebase Uthentication Data and GSM data
const char FIREBASE_HOST[] = "projectname.firebaseio.com";  //Database link
const String FIREBASE_AUTH = "ajwdakjwndoawndoawdijawoidjoawijd";  //Firebase Database Secret
const String FIREBASE_PATH = "/";
const int SSL_PORT = 443;

char apn[] = "Internet";  //sim card apn name
char user[] = "";         //sim used ID
char pass[] = "";         //sim pass

//SIM card PIN (leave empty, if not defined)
const char simPIN[] = "";

TinyGsmClientSecure gsm_client_secure_modem(modem, 0);
HttpClient http_client = HttpClient(gsm_client_secure_modem, FIREBASE_HOST, SSL_PORT);

void setup() {
  Serial.begin(115200);
  // Initialize SIM800L
  pinMode(MODEM_PWKEY, OUTPUT);
  pinMode(MODEM_RST, OUTPUT);
  pinMode(MODEM_POWER_ON, OUTPUT);
  digitalWrite(MODEM_PWKEY, LOW);
  digitalWrite(MODEM_RST, HIGH);
  digitalWrite(MODEM_POWER_ON, HIGH);

  sim800.begin(115200, SERIAL_8N1, MODEM_RX, MODEM_TX);
  delay(1000);
  modem.init();

  if (strlen(simPIN) && modem.getSimStatus() != 3) {  // Unlock your SIM card with a PIN if needed
    modem.simUnlock(simPIN);
  }
  String modemInfo = modem.getModemInfo();
  debug("Modem: ");
  debugln(modemInfo);
  http_client.setHttpResponseTimeout(10 * 1000);  // secs timeout

void loop() {
  debug(F("Connecting to "));
  debug(apn);

  if (!modem.gprsConnect(apn, user, pass)) {
    debug(" Timeout ");
    debugln(timeout_c);
    delay(1000);
    return;
  } else {
    debugln(" OK");
    http_client.connect(FIREBASE_HOST, SSL_PORT);
  }

  while (true) {
    if (!http_client.connected()) {
      http_client.stop();  // Shutdown
      debug("HTTP Connection Nan ");
      break;
    } else {
      trackerdata();
    }
  }
}

I'm not sure other people has this same problem or not it might be just me I need some insight to this.