2020-10-29

[Solved] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

 

Googled: "spring.datasource.url" "Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure" "Caused by: java.net.ConnectException: Connection refused: connect"

But has no solutions.

Situation was: SpringBoot Microservice failed to launch due to error above.

MySql version was 8.0.22


Found that my repository was develop on MySql version 8.0.15


After revert back to MySql version 8.0.15, no more Communications link failure error.






But hit another issue 

mysql 8.0.15 "java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed"


Need to revise spring.datasource.url by append database connection string

&allowPublicKeyRetrieval=true


Then service is up.










2020-09-20

[Gave up] Oppo S1 Mini

[Gave up]: I gave up to patch this issue for this customized device, but hope these info I found could lead u somewhere.


Main issue:

  • Unfortunately, the process com.google.process.gapps has stopped.
  • Unfortunately, Google Play Store has stopped.



Model number: S1 mini

Android version: 7.0

Baseband version: 2019.3.1

Kernel version 3.4.67 | Builder@C1 #51 | sat Jul 4 21:58:27 CST 2020

Build number: q9_m432_b15_wx_r3_V0.9_20200704

Custom build version: 1593871116


Factory version:
Google Play services: 5.0.89 (1307510-034)
Google Play Store: 14.1.48-all [0] [PR] 239702733
Google Services Framework: 3.3.3-1288895


Google Services Framework: 3.3.3-1288895
Google Play services: 5.0.89 (1307510-034)
Google Play Store: 14.1.48-all [0] [PR] 239702733


Saw 6GB RAM installed in device info/setting, but using Device Info HW 4.28.1 showing different thing.


Install Sequence from previous Mi 9 experience:
Framework
Play Service
Play Store










https://www.apkmirror.com/apk/google-inc/google-services-framework/google-services-framework-7-0-release/google-services-framework-7-0-android-apk-download/


https://www.apkmirror.com/apk/google-inc/google-services-framework/google-services-framework-7-0-3037786-release/google-services-framework-7-0-3037786-android-apk-download/


https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-12-6-85-release/google-play-services-12-6-85-000300-197041431-android-apk-download/


https://www.apkmirror.com/apk/google-inc/google-play-store/google-play-store-21-9-47-release/google-play-store-21-9-47-21-0-pr-331897675-android-apk-download/


https://play.google.com/store/apps/details?id=com.google.android.gms


https://www.apkmirror.com/apk/google-inc/google-play-store/google-play-store-12-6-13-release/google-play-store-12-6-13-all-0-pr-221870828-android-apk-download/


All apk won't be able to install, except Google Play services, installed but not working





https://www.deviceinfo.me/

Android version: 4.4.2 (Build: KOT49H) (32-bit)

Android WebView version: 30.0 (32-bit) (Engine: Blink)

Browser Build Number / Identifier: 2003-01-07

User Agent: i Mozilla/5.0 (Linux; Android 4.4.2; S1 mini Build/KOT49H) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/30.0.0.0 Mobile Safari/537.36

 


https://whatdevice.app/

Unknown Android device

Operating system: Android 4.4.2

Architecture: armv7l

Language: en-US

 


armeabi-v7a

https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-20-36-14-release/google-play-services-20-36-14-000300-331796208-android-apk-download/ 

 Although change to architecture of v7, still the same, able to installed, but loop stopping.

Installed, but loop stopping.

Revert back to factory version, 5.0.89 (1307510-034) 

Found info to get version GOOGLE PLAY SERVICES 12.2.21 from URL: 

https://www.apksquare.com/google-play-services-apk-for-android-4-4-2-kitkat-download-new-version/

how to update Google Play Services app manually

Google Play services: version 12.2.21 (070-188803320)

https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-12-2-21-release/google-play-services-12-2-21-070-188803320-android-apk-download/ 

Installed, but loop stopping.

Revert back to factory version, 5.0.89 (1307510-034) 

 

Google Play services: version 20.33.15

Found info of Google Play services: version 20.33.15 (120400-330018294) from URL: https://google-play-services.apk.gold/android-4.4.2

https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-20-33-15-release/google-play-services-20-33-15-000700-330018294-android-apk-download/

Installed, but loop stopping.

Revert back to factory version, 5.0.89 (1307510-034)

 armeabi-v7a

 https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-20-33-15-release/google-play-services-20-33-15-000300-330018294-android-apk-download/

Installed, but loop stopping.

Revert back to factory version, 5.0.89 (1307510-034)

240dpi

https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-20-33-15-release/google-play-services-20-33-15-000304-330018294-android-apk-download/




 

Google Play services: version 4.4.48

https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-4-4-48-3-release/google-play-services-4-4-48-1150368-038-android-apk-download/


https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-6-5-85-17-release/google-play-services-6-5-85-1589008-070-android-apk-download/ 


https://www.apkmirror.com/apk/google-inc/google-play-store/google-play-store-21-9-47-release/google-play-store-21-9-47-16-0-pr-331897675-android-apk-download/





Factory version with sequence from YouTube printscreen:


Google Services Framework:
3.3.3-1288895

Google Account Manager:
4.4.4-1227136
not sure

Google Play services:
5.0.89 (1307510-034)


Google Calendar Sync:


Google Contacts Sync:


Finally
Google Play Store:
14.1.48-all [0] [PR] 239702733
not sure




Google Services Framework 4.4.2-1289630 (Android 4.4+)

https://www.apkmirror.com/apk/google-inc/google-services-framework/google-services-framework-4-4-2-1289630-release/google-services-framework-4-4-2-1289630-android-apk-download/#file

https://www.apkmirror.com/apk/google-inc/google-services-framework/google-services-framework-4-4-2-1289630-release/google-services-framework-4-4-2-1289630-android-apk-download/download/ 




Google Play services 10.0.84 (034-137749526) (034)

https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-10-0-84-release/google-play-services-10-0-84-034-137749526-android-apk-download/download/ 


Google Calendar Sync 4.4-927798 (Android 4.0.3+)

Google Calendar Sync 5.2.3-99827563-release (Android 4.0.3+)






>adb.exe shell logcat *:E






E/        (  677): Could not open '/data/data/hotplug/cmd'
E/        (  677): error : 2, No such file or directory
E/        (  677): Could not open '/data/data/hotplug/cmd'
E/        (  677): error : 2, No such file or directory
E/cutils-trace( 3069): Error opening trace file: No such file or directory (2)
E/dalvikvm( 3055): Unable to extract+optimize DEX from '/data/data/com.android.vending/code_cache/secondary-dexes/Phonesky.apk.classes2.zip'
E/dalvikvm( 3055): Unable to extract+optimize DEX from '/data/data/com.android.vending/code_cache/secondary-dexes/Phonesky.apk.classes3.zip'
E/AndroidRuntime( 3055): FATAL EXCEPTION: main
E/AndroidRuntime( 3055): Process: com.android.vending, PID: 3055
E/AndroidRuntime( 3055): java.lang.NoClassDefFoundError: ieq
E/AndroidRuntime( 3055):        at dso.<init>(SourceFile)
E/AndroidRuntime( 3055):        at dgb.bj(SourceFile:3)
E/AndroidRuntime( 3055):        at dgb.aQ(SourceFile:9)
E/AndroidRuntime( 3055):        at djd.onCreate(SourceFile)
E/AndroidRuntime( 3055):        at android.app.Instrumentation.callApplicationOnCreate(Instrumentation.java:1007)
E/AndroidRuntime( 3055):        at android.app.ActivityThread.handleBindApplication(ActivityThread.java:4541)
E/AndroidRuntime( 3055):        at android.app.ActivityThread.access$1500(ActivityThread.java:151)
E/AndroidRuntime( 3055):        at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1381)
E/AndroidRuntime( 3055):        at android.os.Handler.dispatchMessage(Handler.java:110)
E/AndroidRuntime( 3055):        at android.os.Looper.loop(Looper.java:193)
E/AndroidRuntime( 3055):        at android.app.ActivityThread.main(ActivityThread.java:5299)
E/AndroidRuntime( 3055):        at java.lang.reflect.Method.invokeNative(Native Method)
E/AndroidRuntime( 3055):        at java.lang.reflect.Method.invoke(Method.java:515)
E/AndroidRuntime( 3055):        at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:825)
E/AndroidRuntime( 3055):        at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:641)
E/AndroidRuntime( 3055):        at dalvik.system.NativeStart.main(Native Method)
E/        (  677): Could not open '/data/data/hotplug/cmd'
E/        (  677): error : 2, No such file or directory
E/        (  677): Could not open '/data/data/hotplug/cmd'
E/        (  677): error : 2, No such file or directory
E/WindowManager(  677): Starting window AppWindowToken{426cea30 token=Token{420ed1b8 ActivityRecord{4241c4e8 u0 com.android.vending/.AssetBrowserActivity t17}}} timed out























E/        (  677): Could not open '/data/data/hotplug/cmd'
E/        (  677): error : 2, No such file or directory
E/        (  677): Could not open '/data/data/hotplug/cmd'
E/        (  677): error : 2, No such file or directory
E/cutils-trace( 3096): Error opening trace file: No such file or directory (2)
E/dalvikvm( 3082): Unable to extract+optimize DEX from '/data/data/com.android.vending/code_cache/secondary-dexes/Phonesky.apk.classes2.zip'
E/dalvikvm( 3082): Unable to extract+optimize DEX from '/data/data/com.android.vending/code_cache/secondary-dexes/Phonesky.apk.classes3.zip'
E/AndroidRuntime( 3082): FATAL EXCEPTION: main
E/AndroidRuntime( 3082): Process: com.android.vending, PID: 3082
E/AndroidRuntime( 3082): java.lang.NoClassDefFoundError: ieq
E/AndroidRuntime( 3082):        at dso.<init>(SourceFile)
E/AndroidRuntime( 3082):        at dgb.bj(SourceFile:3)
E/AndroidRuntime( 3082):        at dgb.aQ(SourceFile:9)
E/AndroidRuntime( 3082):        at djd.onCreate(SourceFile)
E/AndroidRuntime( 3082):        at android.app.Instrumentation.callApplicationOnCreate(Instrumentation.java:1007)
E/AndroidRuntime( 3082):        at android.app.ActivityThread.handleBindApplication(ActivityThread.java:4541)
E/AndroidRuntime( 3082):        at android.app.ActivityThread.access$1500(ActivityThread.java:151)
E/AndroidRuntime( 3082):        at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1381)
E/AndroidRuntime( 3082):        at android.os.Handler.dispatchMessage(Handler.java:110)
E/AndroidRuntime( 3082):        at android.os.Looper.loop(Looper.java:193)
E/AndroidRuntime( 3082):        at android.app.ActivityThread.main(ActivityThread.java:5299)
E/AndroidRuntime( 3082):        at java.lang.reflect.Method.invokeNative(Native Method)
E/AndroidRuntime( 3082):        at java.lang.reflect.Method.invoke(Method.java:515)
E/AndroidRuntime( 3082):        at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:825)
E/AndroidRuntime( 3082):        at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:641)
E/AndroidRuntime( 3082):        at dalvik.system.NativeStart.main(Native Method)
E/        (  677): Could not open '/data/data/hotplug/cmd'
E/        (  677): error : 2, No such file or directory
E/        (  677): Could not open '/data/data/hotplug/cmd'
E/        (  677): error : 2, No such file or directory





WhatsApp Messenger 2.20.198.15 (arm-v7a) (Android 4.1+)





2020-09-18

Visual Studio Code cannot detect installed git

 


Open Visual Studio Code

File > Preference > Settings

or

Ctrl + , 

 

in Search Settings: git.path


Click edit in settings.json, and edit as below, end with git.exe







2020-08-28

Fixed: Microsoft Office 2013 Pro Plus 15. microsoft office can't find your license for this application. a repair attempt was unsuccessful

 



Source URL: https://www.heidoc.net/joomla/technology-science/microsoft/79-create-an-office-2013,-2016-and-365-offline-installer-with-the-office-deployment-tool

Refer to:

  1. https://superuser.com/questions/42788/is-it-possible-to-execute-a-file-after-extraction-from-a-7-zip-self-extracting-a
  2. http://ntsblog.homedev.com.au/index.php/2015/05/14/self-extracting-archive-runs-setup-exe-7zip-sfx-switch/


Microsoft Office 2013 Deployment Tool
The Office 2013 Deployment Tool allows the administrator to customize and manage Office 2013 Click-to-Run deployments. This tool will help adminstrators to manage installations sources, product/language combinations, and deployment configuration options for Office Click-to-Run.

Download above and save as: officedeploymenttool_x86_5031-1000.exe

Double click run it, then extract:

  1. setup.exe
  2. configuration.xml
Edit configuration.xml to become below.


download template configuration.xml from heidoc.net.


modified to 

<Configuration>
<Add OfficeClientEdition="64">
<Product ID="ProPlusRetail">
<Language ID="en-us"/>
</Product>
</Add>
<Updates Enabled="TRUE"/>
<Display Level="Full" AcceptEULA="TRUE"/>
</Configuration>




Run

setup /download configuration.xml


will download as below:



select files below, right click and add to 7zip archive.












;!@Install@!UTF-8!
Title="ProPlusRetail x64"
BeginPrompt="Do you want to install ProPlusRetail x64?"
RunProgram="setup.exe /configure configuration.xml"
;!@InstallEnd@!





copy /b 7zSD.sfx + config.txt + ProPlusRetail_x64.7z ProPlusRetail_x64.exe

 

copy /b 7zSD.sfx + config.txt + ProPlusRetail_x64.7z ProPlusRetail_x64.exe
7zSD.sfx
config.txt
ProPlusRetail_x64.7z
        1 file(s) copied.








Successful build exe, but never try to install


End up fix the main issue by install from ProfessionalRetail.img, download from url below:

Open url below in new window(verified still able to download@20211204_pm093826):


Microsoft Office 2013 (15.0.4433.1508)

32bit & 64 bit:

http://officeredir.microsoft.com/r/rlidO15C2RMediaDownload?p1=db&p2=en-US&p3=ProfessionalRetail

default setup for 32 bit in ProfessionalRetail.img




For 64 bit,  in ProfessionalRetail.img/office/setup64





What are x86 and x64 editions?

Running the x64 (64 bit) edition also requires an x64 Windows edition. The advantage of Office x64 is a bit better performance. Disadvantage is that it doesn't support most third party plugins and add-ons. Microsoft actually discourages the use of the x64 editions. So unless you're absolutely sure you need an x64 edition, you should choose x86 (32 bit).

Download Office 2013 Backup Images from Microsoft

The following links point to the official download server officecdn.microsoft.com. Instead of ISO they come as IMG images. These files are pure backup media, and can't be installed without a retail product key.

The IMG images are not the same as the "Single Image" downloads that used to be available from Digital River, but offline versions of the streaming "Click-to-Run" version, with all disadvantages associated with that. If your required download is not included here (such as Office 2013 Professional Plus) please proceed to the download instructions here.

...




Google Referrals