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.

 

Workflow of Refreshing Windows 8.1 for Asus Zenbook UX303L

  1. Before Windows Refresh, use SyncBack to back up files to Buffalo external HDD.
  2. Run Windows Refresh , USB thumb drive “Windows Recovery” is required in order to refresh.
  3. After Windows Refresh is completed, remove Metro Apps using PowerShell command (https://news.softpedia.com/news/How-to-Remove-All-Pre-Installed-Windows-8-Metro-Apps-328110.shtml) :
    • Get-AppxPackage -AllUsers | Remove-AppxPackage
    • Get-AppXProvisionedPackage -online | Remove-AppxProvisionedPackage –online
  4. Run Windows Update to update all updates.
    • optional — install “KB 3138615” first if Windows Update stuck
  5. Reinstall drivers and anti-virus software:-
    • Windows Classic Shell;
    • Intel via Intel-Driver-Support-Assistant;
    • NVIDIA via GeForce Experience;
    • Asustek;
    • Webroot
  6. Optional:-
    • create a recovery media (Windows installer) using USB thumb drive;
    • create a password reset key using USB thumb drive;
    • create a back-up of Windows Activation Key.
  7. Run System Image to create a system image of newly refreshed Windows with drivers and anti-virus installed.
  8. Restore files using SyncBack from Buffalo external HDD to “Documents”
  9. Reinstall software as per “Remove Applications.html”

How to Automatically Fill-In Laporan Harian Pematuhan SOP

Quick Guide

  1. Install AutoHotkey (AHK).
  2. Select the script “SOP Daily Report v. 2.0 for 2020-05-21 (demo).ahk”.
  3. Unzip the “SOP Daily Report v. 2.2 for 2020-05-27 (Demo).zip”
  4. Run the script by double clicking on “ahk” file.
  5. Log into https://notification.miti.gov.my
  6. Go to “Laporan Harian Pematuhan SOP”.
  7. Run the hotkey by pressing <CTRL> then <1>,  all fields on that page will be automatically filled in less than 3 seconds.
  8. Finally, manually click “Hantar” to submit the report. Refer to video below for a demonstration …

If you require our service to customise the script or to provide training, please contact us …

 

BEFORE AFTER

Continue reading

How to Ensure that the Customer Has a PayPal Account

Seller protection is very important to prevent charge-back by customer/buyer

 

In order to do so, the customer must have a PayPal account. Otherwise, in the event of charge-back, PayPal will immediately refund the money back to customer.

 

In PayPal setting, disable the PayPal Account Optional feature:-

  1. Click the Settings icon next to “Log out.”
  2. Click My Selling tools.
  3. Click Update beside ‘Website preferences.’
  4. Select ‘Off’ under ‘PayPal Account Optional’ near the bottom of the page.
  5. Click Save.

With this turn off, customer must register an account with PayPal. This is an added security to prevent fraud and it enables seller protection.

 

 

How to Fix sfc Error “found corrupt files but was unable to fix” and DISM Error “The source files could not be downloaded”

Machine: Asus UX303

OS: Windows 8.1 64-but

Status as at 2020-05-25:  fail to solve

  1. sfc /scannow returns this message — “Windows Resource Protection found corrupt files but was unable to fix some of them. “
  2. Run “DISM” as follows:
    1. Type “cmd” in windows search bar
    2. Right click on “Command Prompt”
    3. Select “Run as Administrator”
    4. Type “DISM /Online /Cleanup-Image /CheckHealth” without quote and press ENTER
    5. Type “DISM /Online /Cleanup-Image /ScanHealth” without quote and press ENTER
    6. Type “DISM /Online /Cleanup-Image /RestoreHealth” without quote and press ENTER
      (source: https://answers.microsoft.com/en-us/windows/forum/all/sfc-scannow-found-errors-but-couldnt-fix-all-of/663ec1fa-a215-41b8-abbb-2aa1cca703e2)
  3. If “DISM /Online /Cleanup-Image /RestoreHealth” return this message — “The source files could not be downloaded. Use the “source” option to specify the location of the files that are required to restore the feature.”
    then

    1. mount the “iso” file of the Windows
      (the “iso” file is mounted as “E:\” drive)
    2. Type “DISM /Online /Cleanup-Image /RestoreHealth /Source:E:\” without quote and press ENTER
      (source: https://www.thewindowsclub.com/dism-fails-source-files-could-not-be-found/ )
  4. Same error message appeared — “The source files could not be downloaded. Use the “source” option to specify the location of the files that are required to restore the feature.