Incoming SMS is Not Lost Even When Database Connection or Network Connection is Lost

TEST OBJECTIVE: Is incoming SMS / message lost when MySQL database connection is lost while SMS Engine — Enterprise Edition version 7.x is running?

 

TESTING METHODOLOGY TEST RESULT REMARK
  1. Start WAMP, start SMS Engine — Enterprise Edition version 7.1. Make sure the modem can be initialized to show the connection with database.
  2. Stop all MySQL DB service only. Note the time.
  3. Send 1 SMS from mobile phone to 011-56368598. Note the time.
  4. After 5 minutes (from the time of sending 1 SMS in step 3) start MySQL DB service only.
  5. Verify that the modem is still initialized.
  6. Check in the “inbox” table for the incoming SMS.
  1. Log File: 2021_5_20.log
    Modem 1 initialized at 12:58:59pm
  2. MySQL DB service stopped at 13:14pm
  3. SMS sent to 011-56368598 at 13:19pm
  4. MySQL DB service started at 13:25pm
  5. Control Panel of SMS Engine — Enterprise Edition shows Modem ID 1 is still in “initialized” (green colour) state
  6. SMS inserted into “inbox” table at 13:27:13pm
Incoming SMS is NOT LOST Even though the database connection is lost.
  1. Start WAMP, start SMS Engine — Enterprise Edition version 7.1. Make sure the modem can be initialized to show the connection with database.
  2. Unplug network cable from Dell-E6410 (laptop).  Note the time.
  3. Send 1 SMS from mobile phone to 011-56368598. Note the time.
  4. After 5 minutes, reconnect network cable. Note the time. Verify that the modem is initialized.
  5. Check in the “inbox” table for the incoming SMS.
  1. Log File: 2021_5_21.log
    Modem 1 initialized at 10:29:48am
  2. Network cable unplugged at 10:33:37am and modem ID 1 failed to connect to GSM network (not initialized)
  3. SMS sent at 10:36am
  4. Network cable reconnect at 10:43:10am and modem ID 1 was initialized
  5. SMS inserted into “inbox” table at 10:43:20am
Incoming SMS is NOT LOST even though network connection is lost.