How to Solve “Unable to open database file” in PHPRunner

Problem: PHPRunner v.10 unable to open project files created using PHPRunner v. 5 with this error message …

 

TROUBLE SHOOTING

SOLUTION
 SOLVED?
Edit the “.phpr” file created by PHPRunner v. 5, change  the database connection variables. No.
Use PHPRunner v. 5 to re-build PHP files and update the “.phpr” with correct database settings. No.
Use PHPRunner v. 6.2 to re-build PHP files and update the “.phpr” created by PHPRunner v. 5 in above.

PHP v. 6.2 is able to open “.phpr” file created by v. 5.

 No. PHPRunner v. 10 us unable to open the “.phpr” file created by v. 6.2.
Use PHPRunner v. 10 to create a new project and connect to MySQL database server. Open the “.phpr” file to review the connection string. No because “.phpr” structure is different between PHPRunner v. 10 and v. 5
Use PHPRunner v. 8 to open “CRM.phpr”, re-build PHP files and update the “.phpr” created by PHPRunner v. 5 in above. Yes. PHPRunner v. 10 is able to open “.phpr” file created by v.8.

 

Conclusion: PHPRunner v. 10 cannot open project files created by PHPRunner v. 7 and earlier.

Solution: use PHPRunner v. 8 to  re-build project file created by earlier version of PHPRunner, then use v. 10 to open project files created by PHPRunner v.8.

NOTE

  1. PHP files generated by PHPRunner v. 5, 6, 7, 8 will have error message “mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead” when uploaded to crm.mobiteks80.com as they are NOT using “mysqli”.

How to Search for the IP Address of MOBITEK S80 3G Modem

There are 2 methods:-

  1. USR-TCP
  2. USR-VCOM

 

  1. USING USR-TCP
    Click on ” Search in LAN” and you will find your modem in the “Device list in the Net”.Once you click on the modem which is visible on that list, you can view the parameters (including the IP address) of MOBITEK S80 3G MODEM.
  2. Using USR-VCOM
    Once done with the USR-VCOM setup, click on “Search” and select T24. 

    The modem that been detected by the USR-VCOM will be shown as below with the IP address:

VCOM Cannot Be Used to Change IP Address of MobiGATE

Conclusion:

  • VCOM Cannot Be Used to Change IP Address of MobiGATE. 
  • The “Configure” button in VCOM is NOT able to change the IP address.
Select the MobiGATE then click on the “Configure” in VCOM.
Enter the new IP address for the MobiGATE
new IP address and Submask Address been entered
When OK is clicked, no response except .ion
Did the IP address changed? No, IP address remains at 192.168.10.69
What happens if I fill all the fields provided? — NOTHING
After OK is pressed -NOTHING HAPPENS

 

 

 

How to Solve SMS Engine Fails to Initialize Despite Hyper Terminal Can Communicate with MobiGATE

Applies to:

  • All SDK (SMS API, STK API, etc.)
  • all versions of SMS Engine — Enterprise Edition

Cause: “MSComm32.ocx” did not install properly or the date of the file is incorrect. This occur when MOBITEK SMS Engine — Enterprise Edition has been reinstalled a few times on the same Windows machine.

Solution:

  1. Uninstall MOBITEK SMS Engine — Enterprise Edition.
  2. Unregister “MSComm32.ocx”:
    1. for Windows 64-bit, run “cmd” or “Command Prompt” as “administrator”, then type
      1. “cd %systemroot%\SysWoW64\“
      2. “regsvr32.exe /u mscomm32.ocx“
    2. for Windows 32-bit, goto Start → Run → type “regsvr32 /u mscomm32.ocx”
  3. Delete “MSComm32.ocx”.
  4. Re-install SMS Engine — Enterprise Edition.

or

  1. Unregister the “MSComm32.ocx” and delete it
    1. for Windows 64-bit, run “cmd” or “Command Prompt” as “administrator”, then type:
      1. “cd %systemroot%\SysWoW64\“
      2. “regsvr32 /u mscomm32.ocx“
    2. for Windows 32-bit, goto Start → Run → type “regsvr32 /u mscomm32.ocx“
  2. Copy the new “MSComm32.ocx” and manually register it:
    1. for Windows 64-bit, run “cmd” or “Command Prompt” as “administrator”, then type:
      1. “cd %systemroot%\SysWoW64\“
      2. “regsvr32 mscomm32.ocx“
    2. for Windows 32-bit, goto Start → Run → type “regsvr32 mscomm32.ocx“

 

source: https://support.microsoft.com/en-my/help/249873/how-to-use-the-regsvr32-tool-and-troubleshoot-regsvr32-error-messages

Set-up Guide for MOBITEK S80 on LAN

Objective: to set-up MOBITEK® S80  and MOBITEK® Q25 to operate on local area network (LAN) via LAN port.

Applies to:-

  • MOBITEK® S80  Type S-L
  • MOBITEK® S80 Type E-L
  • MOBITEK® Q25 Type D
  • MOBITEK® Q25  Type M

MOBITEK® S80 for SMS Over 3G Network

MOBITEK® Q25 4G Modem for SMS, E-Mail, MQTT & GNSS

 

How to Configure LAN Port of MOBITEK® S80

There are 2 tasks:-

  1. How to Assign/Change IP Address of MOBITEK® S80
    1. IP address has to be assigned to the modem
  2. How to Add A COM Port for MOBITEK® S80
    1. on PC/server, a new COM port has to be added and mapped to the IP address of the modem

 

How to Assign/Change IP Address of MOBITEK® S80

  1. Connect the LAN  (ethernet) cable to the modem and the other end to your router or switch.
  2. Connect power adapter to the modem, turn on the power.
  3. Run the Windows application “USR-TCP232-T24-V5.1.1.20.exe“.
  4. Click “Search in LAN”.
  5. It will look for the IP address of MOBITEK® S80, if found it will display the address. In this example it is 192.168.31.7
  6. Click the “Device list in the net” , make the following changes in the “Parameters” section:-
    1. set to “TCP Server”;
    2. change the IP address in “Module IP” that matches your LAN, the IP address is for MOBITEK® S80 (e.g. 192.168.10.210);
    3. change the “Default Gateway” that matches the IP address of your router (e.g. 192.168.10.1);
    4. optional — change “Module port”;
  7. Finally, click “Set selected item via Net” or “Set selected item via LAN” to save changes.
  8. Exit the Windows application “USR-TCP232-Setup”.
  9. Check if the new IP address assigned to MOBITEK® S80 is discoverable by entering the IP address into the browser. The username and password are as below:
    • Username = admin
    • Password = admin
  10. Go to “Local IP Config” and see the “Static IP” and “Gateway”.

 

How to Add A COM Port for MOBITEK® S80

  1. In Windows PC/Server, install “USR-VCOM” then run it.
  2. Click “Smart VCOM” (you must first exit “USR-TCP232-Setup”, otherwise an error message “Search port 1901 is occupied” will appear):
    USR-VCOM_V3.7.1.520_Setup-01
  3. If MOBITEK® S80 is found, it will be displayed. Check it then click “Next” to create COM port.
  4. A new COM port number will be created under “COM Name”, in this example it is 2.
  5. Also the COM port number can also be seen either in “Device Manager -> Ports”

    or in  “Device Manager -> Virtual Serial Ports (Eltima Software)”. COM port number will be displayed.
    USR-VCOM_V3.7.1.520_Setup-04
  6. “Net State” will show “Connected”.
  7. Your application will communicate with MOBITEK® S80 via the above COM port number.
  8. When your application is connected to MOBITEK® S80  then “COM State” will show “Open”.
  9. When your application is communicating with MOBITEK® S80 to send and read SMS, the values in “COM Received” and “Net Received” will be increasing.
  10. Ensure “USR-VCOM” is set to “AutoRun” (red box) and ensure it is running, otherwise SMS application is unable to connect to MOBITEK® S80 Modem:

 

Appendix: Using “Search” to Find the IP address of MOBITEK S80

  1. If “Smart VCOM” fail to work, then use “Search” function. Select “USR-TCP232-T24”:
  2. If modem is found, it will list the IP address of modem:
  3. Click “Connect Virtual COM” to create a COM port:
  4. Select a COM port for the modem (e.g. COM2), and select “TCP Client”:
  5. MOBITEK® S80 Modem is connected to COM port number 2.

How to Set-Up 3G Router F342x

Configuring F342x

  1. Insert SIM card (standard size; not nano size nor micro size) into router.
  2. Connect the LAN cable between PC and router (label with “ETH”).
  3. Enter the IP address of the 3G Router (default is 192.168.1.1) on the web page, you will see this.
  4. Click on “Setup”, and enter this to enable access to the Configuration Page of F342x —  user name “admin”, password  is “admin”.
  5. Click on “WAN”, to check 3G signal strength and connection status.

Configuring APN of the 3G Network (SIM card)

  1. Look for “APN” to check the connected network
  2. Select a preferred network from the table below and key-in into the APN on the F3424 configuration page.
    TELCO APN USER NAME PASSWORD
    MAXIS post-paid unet maxis net
    MAXIS pre-paid net guest guest
    DIGI diginet guest guest
    CELCOM celcom.net.my guest guest
    U MOBILE my3g

List updated on 2019-Sep-9

How to Check for Internet Connection

There are 2 ways:-

  1. Check WAN status :
  2. Use web browser to check for internet connection

User Manual

Download the full user manual here …F3427 User Manual

Merry Christmas 2018

Dear readers,

I wish to share a wonderful experience and a miracle.

I landed on Manila on 26 Nov, 10 p.m. I took Grab Car from airport to my hotel. After half an hour upon checking in, to my horror, I realized that my laptop bag was missing!

My bag had these valuable items:-
a) laptop with confidential files, intellectual properties, working e-mails, and passwords;
b) Public Bank security token;
c) HSBC security token;
d) house keys;

I started to panic but then calm down.

I had contacted the Grab car driver who dropped me at hotel to check if my laptop bag was left in his car. But he answered no.

I seek help from the hotel’s security to check the CCTV recording, it didn’t show me carrying laptop bag while checking in.

So the only place that I might have left my laptop bag was at the airport. So at 12:25 am in the morning, I took Grab taxi back to the airport and searched at these places:-
a) Grab booth;
b) Globe (TELCO) booth;
c) toilet of the baggage collection area
unfortunately, my laptop bag was not there.

Before going to airport I had prepared myself for the worst case scenario. I didn’t have any high expectations because Philippines is a poor country.

Finally, I asked for the direction to the lost and found office. And to my surprise, my laptop bag was there.

I had left it at the Grab counter, outside of arrival hall. Usually in this public area without any CCTV and security guard, my bag would have definitely gone. Not only I found my bag, all items in my bag were intact.

You can say that I had good fortune but I believe that it was a miracle.

Have you lost something? I wish that in this Christmas and in the coming new year, you will experience a miracle — something valuable that you have lost is found later.

Merry Christmas!
Kong Leng

MOBITEK S80 SMS Modem — Send SMS via SQL Statement

Problem: Many 3G modems allow you to send SMS via graphical user interface but not able to integrate with your software or system.

 

Solution: MOBITEK® S80 SMS Modem

MOBITEK® S80 allows you to integrate with your software or system send SMS via SQL statement.

  1. To send out SMS 
    Insert into Outbox (Message, Mobile, DateTimeQueue, Status) 
values (‘Hello!’, ‘0163311600’, mm/dd/yyyy hh:mm am, ‘P’)
  2. To read all new SMS 
    Select * from Inbox where Status = ‘New’

 

How It Works?

  • Your application will connect to a MS Access database file.
  • SMS Engine — Basic Edition (Windows software) connects to both MOBITEK® S80 and with the database file.
  • Whenever there is a new record in the [outbox] table, SMS Engine — Basic Edition will pick-up and instruct MOBITEK® S80 to send out as SMS.
  • Whenever there is a new incoming SMS recevied by MOBITEK® S80, SMS Engine — Basic Edition will automatically insert into [inbox] table

 

More Advantages of SMS Engine — Basic Edition 

  1. Rapid Development: no need to waste time in developing a programme to handle incoming and outgoing SMS.
  2. SIM Unlock: enter the PIN, and the SMS Engine will unlock the SIM card.
  3. Polling: set the frequency of database polling – this will control the speed of the sending and receiving SMS.
  4. Delivery Status Report: a report will accompany with each outgoing SMS to report whether the SMS is delivered or not.
  5. Routing: able to configure multiple mobile number prefixes (by comma separated).
  6. Direction: to speed-up the broadcast, SMS Engine can be configured to send SMS only.
  7. Query Balance: if prepaid is used, the credit balance can be queried.
  8. Reload: if prepaid is used, a top-up can be performed.
  9. For more information, refer to https://www.mobitek.my/main/software-development-kit/mobitek-sms-engine-basic-edition/

 

New version 6 is available for existing customer to download. Please reply to this e-mail to receive the download link.


COM Port Number of MOBITEK S80 Modem Will Change If USB Port is Changed

MOBITEK® S80 for SMS Over 3G Network

 

OBJECTIVE: to test if restarting Windows 10 causes COM port number of MOBITEK S80 SMS Modem to change.

 

TEST METHOD TEST RESULT
  1. Use MOBITEK S80 (no SIM card required)
  2. Use your Lenovo laptop running Windows 10
  3. Connect S80 into USB port no. 1
 What is the COM port number?

COM 9
  • Restart Windows 10
 What is the COM port number after restart?

COM 9

Does COM port number change after restart?

NO
  1. unplug S80 from USB port no. 1
  2. plug into USB port no. 2 (different one)
  What is the COM port number?  COM 7
  • Restart Windows 10
  What is the COM port number after restart? 

COM 7

Does COM port number change after restart?

NO

CONCLUSION

Restarting Windows 10 doesn’t change the COM Port Number.

It is common that that the COM port number will be changed if you plug the modem into another USB port. As long as that MOBITEK S80 is using the same USB port, COM port number will be the same.