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 MobiGATE Fails to Initailize Despite Hyper Terminal Can Communicate with MobiGATE

Applies to: All SDK (SMS Engine, SMS API, STK API, etc.) that uses “MSComm32.ocx”

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 to operate on local area network (LAN) via LAN port.

Applies to:-

  • MOBITEK® S80 SMS Modem Type S-L
  • MOBITEK® S80 3G Modem Type E-L

MOBITEK® S80 for SMS Over 3G Network

 

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”.
    USR-TCP232-T24-01
  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.10.210
  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”;
      USR-TCP232-T24-02
  7. Finally, click “Set selected item via Net” or “Set selected item via LAN” to save changes.
    USR-TCP232-T24-03
  8. Exit the Windows application “USR-TCP232-Setup”.

 

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.
    USR-VCOM_V3.7.1.520_Setup-02
  4. A new COM port number will be created under “COM Name”, in this example it is 1.
  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. COM20), and select “TCP Client”:
  5. MOBITEK® S80 Modem is connected to COM port number 20.

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

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.

 

How to Solve Unable to Log Into Windows XP PC Despite The User Name and Password Are Correct

Problem: On local area network (LAN), other PC (Windows Vista, 7 and 8) are not able to log into Windows XP PC with the correct user name and password.

Solution: the date and time of Windows XP PC are incorrect, re-set them.

source: https://superuser.com/questions/287009/logon-failure-unknown-username-or-bad-password-when-connecting-windows-7-pc-to-w

How to Solve Microsoft Security Essentials Stopping by Itself

  1. Uninstall (Microsoft Security Essentials), should be able to remove MSE from Control Panel. Any problems uninstalling see: Uninstalling Microsoft Security Essentials  
  2. Recommend to restart the computer to ensure the uninstall is complete.
  3. Re-install the MSE. Can download a new MSE Installation File from:   http://windows.microsoft.com/en-us/windows/security-essentials-all-versions