Category Archives: MobiGATE

MOBITEK MobiGATE

ERROR [HY000] [MySQL][ODBC 5.1 Driver]Host ‘175.xxx.xxx.xx’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’

Problem: when using MOBITEK SMS Engine — Enterprise Edition v. 7.1 with MySQL database server in remote server (Exabytes), this error will appear after 2 days.

MOBITEK® SMS Engine — Enterprise Edition

 

SMS Engine was started on 23-Aug-2019, non-stop, until these error messages were received on 25-Aug-2019, Sunday, 1:41 am

01:42:21 ERROR [08S01] [MySQL][ODBC 5.1 Driver]Lost connection to MySQL server at 'reading initial communication packet', system error: 0
01:42:25 ERROR [HY000] [MySQL][ODBC 5.1 Driver]Host '175.xxx.xxx.xx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
01:42:28 ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '72.xx.xxx.xx' (10055)
ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '72.18.132.28' (10055)

 

Trouble Shooting: The SMS Engine does not hold the database connection. It always close it after every execution of database query otherwise the engine would have failed long time ago.  Any other applications connecting to this database ? This error can also happen when there are too many connections issued to the database. Default concurrent connection for mysql is 151.

 

Conclusion: MOBITEK SMS Engine — Enterprise Edition only uses 1 database connection.

 

(OBSOLETE) Control Panel for MobiGATE SMS Engine — Enterprise Edition version 2.6 is Released

List of  Fixes in Version 2.6

  • Engine cannot start because service is still stopping (after “Stop” button is clicked). CP shows “Stopped” but in fact service is showing “Stopping”;
  • Engine cannot stop because service is still starting (after “Start” button is clicked). CP shows “Started” bt in fact service is showing “Starting”;
  • “Modem Status” is tab “Modem 9 to 16” is not showing colours, it is showing “5” or “0” instead. Happens in MS SQL Server only (does not happen in MySQL);
  • Error message when connecting the “modem.state” table – “Location: CheckModemStatusVersion2_MSSQL Error message: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication”;
  • Error message when connecting the “modem.state” table – “Location: CheckModemStatusVersion2_MSSQL Error message: Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication”;
  • Conversion from string “” to type ‘Double’ is not valid. Caused by null or empty value in “Modem_State.Status”;
  • After stop monitoring, modem ID 9 to 16 still showing modem status.By right, there should be no colour status and should be all grey colour;
  • Set the application to run as administrator automatically.

 

Download

Existing customers of MobiGATE with valid warranty period or with valid annual support programme could download version 2.6 from here … (https://www.mobitek.my/download/MOBITEK%20MOBIGATE/Setup%20–%20Control%20Panel%20v.%202.6.zip)

 

More Information

 

How to Configure Windows Server and MS SQL Server Express to Allow Control Panel of MobiGATE to Remotely Connect

SETTING WHAT ERROR WILL APPEAR IF THE SETTING IS NOT DONE
Windows Firewall: allow “SQL Server Windows NT – 64 Bit”

 If firewall is not opened for SQL Sever then this error will appear:

“A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error:40 – Could not open a connection to SQL Server) ”
SQL Server Configuration Manager:

  1. Enable Named Pipes and TCP/IP:
    – Go to SQL Server Network Configuration -> Protocols for <instance name> -> right click on Named Pipes and TCP/IP -> choose Enable
  2. Set port 1433 in TCP/IP Properties:
    – Go to SQL Server Network Configuration -> Protocols for <instance name> -> right-click on TCP/IP -> choose Properties
    – in IP Addresses tab -> scroll until the end until find IPAII -> set TCP Dynamic Ports to empty and TCP Port to 1433
 If “Named Pipes” and “TCP/IP” are not enabled in MS SQL Server then this error will appear:

“A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error:40 – Could not open a connection to SQL Server) ”
If the SQL Server is using instance e.g. “./SQLEXPRESS”:

  1. In Windows Firewall, open port number 1434:
  2. In SQL Server Configuration Manager: Start “SQL Server Browser” in “SQL Server Configuration Manager”:
 If TCP/UDP Port no. 1434 is not opened, then this error will appear:

“A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) ”
Remote connection must be enabled to connect to databases remotely. Connect to SQL Server Instance in SSMS. Right click on SQL Server instance name in SSMS and choose Properties. You will get Server properties window. Click on Connections from left side pane and tick the check box on Allow remote connections to this server option from right side pane.

MORE INFORMATION

Own a SMS Gateway that You Can Fulfil Data Privacy and Data Protection

Instead of using 3rd party SMS service provider, you can own a SMS Gateway that can fulfil data privacy and data protection requirements for your Walnut Wellness.

Here is a case study where a wellness solution, MySalam, have their own SMS Gateway — MobiGATE.

MySalam (https://www.mysalam.com.my/b40/info/?url=intro_EN) is national health protection scheme offered by Malaysia government.

MySalam is using MOBITEK®  MobiGATETM as the SMS Gateway to:-

  • send out notification to applicants who are qualified for the scheme;
  • send out claims notices to insured parties on claim status

 

CASE STUDY

  • MySalam.com.my web portal, is hosted in a data centre in Puchong, Malayisa while MOBITEK®  MobiGATETM is located in Micare’s data centre in Shah Alam.
  • Advantages:-
    • MobiGATE can be placed anywhere, co-location or on separate location with the application server;
    • there are no internet connection to MOBITEK System therefore, all messages sent and received are protected and kept private by Micare; and
    • MobiGATE uses SIM card, support up to 8 SIM cards per unit, with SIM card, the SMS Gateway is directly connected with TELCO via GSM or 3G network without relying on internet.

For more information on MOBITEK®  MobiGATETM , visit its product page or contact us.

MobiGATE is the SMS Gateway for HRWeb.ph

HRweb.ph is a web based Payroll, HRIS, Timekeeping & Solution developed by Sert Technology from the Philippines.

 

MOBITEK® MobiGATE SMS Gateway

HRWeb.ph is using MOBITEK®  MobiGATETM as the SMS Gateway to send out notifications.

 

CASE STUDY

  • HRWeb, web portal, is hosted in a data centre in Singapore, while MOBITEK®  MobiGATETM is located in Sert Technology’s office in Cavite, Philippines.
  • Advantages:-
    • MobiGATE can be placed anywhere on the internet, whether in the data centre, Singapore or in Cavite, Philippines;
    • there are no internet connection to MOBITEK System therefore, all messages sent and received are protected and kept private by Sert Technology; and
    • MobiGATE uses SIM card, support up to 8 SIM cards per unit, with SIM card, the SMS Gateway is directly connected with TELCO via GSM or 3G network without relying on internet.

For more information on MOBITEK®  MobiGATETM , visit its product page.

 

 

How to Solve the Problem of “mcpu.exe – Application Error : The application was unable to start correctly (0xc0000142)”

Applies To:

  • MOBITEK MobiGATE Model SG-B-4-L / SG-B-8-L series (model having LAN port)
  • VCOM version older than 4.5.11

 

Problem: Windows applications not able to run or the whole PC/server will hang.

  1. In “Windows Task Managmer”, “mcpu.exe” will appear everytime VCOM connects to modem in MobiGATE then will disappear:-
  2. After running VCOM for few days, Windows will show an error message “mcpu.exe – Application Error : The application was unable to start correctly (0xc0000142)”:-

  3. “Windows Task Manager” shows high memory usage:-
  4. This will caused other Windows applications not able to run or the whole PC/server will hang:-

 

Solution: VCOM version older than 4.5.11 has memory leak, causing high memory usage. Therefore, need to install version 4.5.11.

How to Run VCOM as Windows Service Using “AlwaysUp”

VCOM

VCOM is a Windows Application. It is NOT a Windows Service. VCOM will auto-run when user has logged into (entering user name and password) Windows. Otherwise, VCOM will not run.

To run VCOM as a Windows Service you can install a 3rd party software call “AlwaysUp”.

 

Install & Configure VCOM in AlwaysUp

  1. Download “AlwaysUp” here … or from 3rd party web site ….
  2. Install it.
  3. Add a new service.
  4. Point to the path of “vcom.exe”.
  5. Ensure the status is “Automatic”.
  6. To view the GUI of VCOM, click on “Switch to Session 0”.
    then it will display the VCOM GUI:
  7. To return to Windows desktop from VCOM GUI, click “Return now”.

 

Warning

  1. After VCOM service is started by AlwaysUp, sometimes, this message by “Interactive Services Detection” will appear “A program running on this computer is trying to display a message”:
    click on “View Message” to switch to VCOM GUI:

  2. To return to Windows desktop from VCOM GUI, click “Return now”.

 

 

How to Run VCOM as Windows Service

VCOM is a Windows Application. It is NOT a Windows Service. VCOM will auto-run when user has logged into (entering user name and password) Windows. Otherwise, VCOM will not run.

To run VCOM as a Windows Service you can manually create a Windows Service using these steps. However, take note that you cannot run VCOM as both Windows Application and Windows Service mode at the same time.

 

CONFIGURE VCOM AS WINDOWS SERVICE

  1. First, IP address of MobiGATE and all 8 modems must be properly configured in VCOM application.
  2. Disable “auto-start” in VCOM application:
  3. Exit completely VCOM application.
  4. Download and install Windows Server 2003 Resource Kit Tools from Microsoft web page or from here …
  5. Only 2 executable files are needed:
    1. INSTSRV.exe
    2. SRVANY.exe
  6. After you have installed, run this command in command prompt: 
    C:\Program Files\Windows Resource Kits\Tools>INSTSRV.exe VCOM "C:\Program Files\Windows Resource Kits\Tools\SRVANY.exe"
  7. Run Registry Editor (Regedt32.exe), check the registry to verify that the ImagePath value under “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VCOM” is set to 
    "C:\Program Files\Windows Resource Kits\Tools\srvany.exe"
  8. Right click on VCOM, from the Edit menu, click “Add Key”. Type the following and click “OK”: 
    Key Name: Parameters
Class : <leave blank>
  9. Select the “Parameters” key, click “Add Value”. Type the following and click “OK”: 
    Value Name: Application
Data Type : REG_SZ
String : C:\Program Files\VCOM\VCOM\vcom.exe
  10. Exit Registry Editor and goto “Computer Management > Services” configure “VCOM” to run “Automatic”
  11. After service is started, 8 COM ports are created:

WARNING

  1. After VCOM service is started, then you start VCOM application, the application could NOT show all the 8 modems and 8 COM ports:
    VCOM application must be closed.
  2. If you want VCOM application to show all modems, then you must first stop the VCOM service, the only start VCOM application.
  3. VCOM cannot be running as both Windows Application and Windows Service mode at the same time.

 

Source: https://support.microsoft.com/en-my/help/137890/how-to-create-a-user-defined-service