Author Archives: Taufiq

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.

List of Functions Supported by MOBITEK EC20 4G Router & IoT Gateway

MOBITEK EC20 4G Router and IoT Gateway

 

Home -> Basic Info

 

System Info -> Clients Info

 

System Info -> Statistics

 

System Info -> 4G/WAN Status

 

Wireless Setting -> 2.4G Basic Setting

 

Wireless Setting -> 2.4G Repeater Setting

 

Network Setting -> Work Mode Setting

 

Network Setting -> WAN Setting

 

Network Setting -> LAN Setting

 

Network Setting -> DHCP Setting

 

Network Setting -> 4G Setting

 

Network Setting -> VPN Setting -> Open VPN Setting

 

Network Setting -> VPN Setting -> PPTP Setting

 

Network Setting -> VPN Setting -> L2TP Setting

 

Network Setting -> Ping Reboot

 

System Admin -> Web Access Control -> Web Password Setting

 

System Admin -> Web Access Control -> Wan Access Control

 

System Admin -> Backup/Restore -> Backup Configs

 

System Admin -> Backup/Restore -> Restore Factory

 

System Admin -> Backup/Restore -> Restore Backup Configs

 

System Admin -> Firmware Upgrade -> Local Upgrade

 

System Admin -> Firmware Upgrade -> Online Upgrade

 

System Admin -> Time Setting -> System Time

 

System Admin -> Time Setting -> Time Zone

 

System Admin -> Reboot -> Reboot Now

 

System Admin -> Reboot -> Schedule Reboot

 

System Admin -> System Log -> Kernel Log

 

 

System Admin -> System Log -> App Log

 

Advance Setting -> Intranet Passthrough

Advance Setting -> Oray Passthrough

 

Advance Setting -> DTU Setting -> Ser2net Setting1

 

Advance Setting -> DTU Setting -> Ser2net Setting2

 

Advance Setting -> DTU Setting -> Ser2net Setting3

 

Advance Setting -> DTU Setting -> Ser2net Setting4

 

Advance Setting -> PLC Setting

 

Advance Setting -> Remote Help

 

Advance Setting -> DMZ Setting

 

Advance Setting -> Port Mapping

 

 

Advance Setting -> Static Route

 

Advance Setting -> MQTT

 

How to Reuse Existing VB.Net Form by “Add Existing Item”

  1. Copy VB.net form with the same filename  having these file extensions — “.vb”, “.resx” and “Designer.vb” into the project folder.
  2. Open the project, in “Solution Explorer”, right-click on project  “Add -> Existing Item…”
  3. Select the VB.net form file with “.vb” extension.
  4. The same file added should appear in “Solution Explorer”.

Connecting Your Equipment and Systems to Internet via MOBITEK EC20 4G Router

 

MOBITEK EC20 allows uninterrupted internet access via 4G network (LTE) for mission critical applications or systems that requires uninterrupted internet connection (in case landline service goes down).

 

MOBITEK EC20 act as an 4G router to allow remote devices and equipment to be connected to the internet via 4G network.

MOBITEK EC20  is also an IoT gateway for remote devices or equipment on remote site to be connected with IoT Platform via MQTT.

Remote devices or equipment on remote site such as:-

  • Sensor
  • LED Sign Board
  • Kiosk
  • Vending Machine
  • CCTV
  • ATM
  • Utility Metering
  • SCADA

 

Features

  • LTE Cat 4 module optimized for M2M and IoT applications
  • Worldwide LTE, UMTS/HSPA(+) and GSM/GPRS/EDGE coverage, i.e. support all mobile networks in all countries
  • VPN
  • Wi-Fi
  • Port Mapping
  • MQTT

 

Specifications

FREQUENCY BAND

  • LTE-FDD: B1/B3/B5/B7/B8/B20
  • LTE-TDD: B38/B40/B41
  • WCDMA: B1/B5/B8
  • GSM: 900 Mhz / 1800 Mhz

 

More Information

MOBITEK EC20 4G Router and IoT Gateway

 

 

How to Rename “List” in PHPRunner

There are 3 places that need to modify:

  1. Custom views table
  2. Top menu
  3. Landing page menu (no need to modify if this is removed)

 

BEFORE AFTER MODIFICATION IN PHPRunner
List Of Sales Contracts Not Reserved, Loaded Or Delivered Rename to
List Of Sales Contracts NOT Delivered
  1. Go to “Tables” tab -> right-click on select “list_of_sales_contracts_not_reserved_loaded_or_delivered” under Custom views -> select “Rename view”.
  2. In “Rename View”, rename “list_of_sales_contracts_not_reserved_loaded_or_delivered” to “list_of_sales_contracts_not_delivered”.
  3. In the same “Tables” tab -> click on “Menu editor” button.
  4. In “Menu Editor” -> select “List_Of_Sales_Contracts_Not_Reserved_Loaded_Or_Delivered” under the “Menu Settings” -> click “Edit item” button.
  5. In “Menu Item Editor”, rename “List Of Sales Contracts Not Reserved Loaded Or Delivered” to “List Of Sales Contracts Not Reserved Loaded Or Delivered”
  6. Go to “Designer” tab -> select “Common pages” in the Tables list -> select “List Of Sales Contracts Not Reserved Loaded Or Delivered” -> in “linkComments” and “linkText”, rename the text to “List Of Sales Contracts Not Delivered”.

How to Edit Landing Page (HTML File) Without Using PHPRunner

Applies to: PHPRunner version 10.4

Problem: the landing page — https://sot.sweetco.com.my/v.4.0/menu.php shows descriptions:-

 

If I want to edit the description, e.g. “Sot description”  change to “This form is to be filled by sales department” without using PHPRunner, how should I do it?

 

Solution: edit the file “.global_menu.htm”:

  1. Open “<Parent folder>/output/templates/.global_menu.htm” in Notepad++.
  2. Find the menu title, e.g: “Sales Order Tracking”. Go to “bs-welcome-content” <div> under the menu title <div>, change the text.
  3. Save the file and upload it to web server in the same path as where it is located in the local.
  4. Then reload the page.

Does Shutting Down 3G Network Affect the Functionality of MOBITK Q24 and MOBITEK S80 SMS Modem (GSM Modem)

Question: Malaysia TELCO phasing out 3G soon, may we know if MOBITEK S80 (3G) and MOBITEK Q24 (2G) SMS Modem will be affected (not able to send out SMS)?

 

Answer no. 1: please refer to https://www.malaysianwireless.com/2020/09/malaysia-3g-shut-down-maxis-celcom-2g-voice-volte

“Malaysia is among a limited countries around the world that have decided to shut down its 3G networks while maintaining 2G.“

“As a safety net, 2G network will still be maintained to ensure customers are able to make calls and SMS seamlessly, whenever 4G is inaccessible,”

 

Answer no. 2: please refer to https://soyacincau.com/2021/11/24/digi-3g-shutdown-schedule-states-december-2021/

Digi CTO Kesavan Sivabalan said: “Our priority remains in ensuring high availability and consistency of our 4G network services, and to do so effectively, it is necessary that we retire the 3G network, freeing up crucial spectrum and resources that would now be channelled towards increasing capacity of the 4G network to support higher usage.”  Users with 3G devices can still stay connected to 2G after the 3G shutdown. While 2G is sufficient for basic voice calls and SMS, it is barely usable for internet services in this day and age.

Therefore, as long as 2G network is maintained, MOBITEK S80 (3G) and MOBITEK Q24 (2G) SMS Modem can still send and receive SMS.