Sunday, September 27, 2020

Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

 OpenJDK 11


1. Export certificate from url

firefox - click on HTTPS certificate chain (the lock icon right next to URL address). Click "more info" > "security" > "show certificate" > "details" > "export..". Pickup the name and choose file type example.cer

chrome - click on site icon left to address in address bar, select "Certificate" -> "Details" -> "Export" and save in format "Der-encoded binary, single certificate".

2. Import cer to jdk

./keytool -import -trustcacerts -cacerts -storepass changeit -noprompt -alias file_name -file /path/to/file.pem



Monday, September 21, 2020

Allow remote connection MySQL

 

Your root account, and this statement applies to any account, may only have been added with localhost access (which is recommended).

You can check this with:

SELECT host FROM mysql.user WHERE User = 'root';

If you only see results with localhost and 127.0.0.1, you cannot connect from an external source. If you see other IP addresses, but not the one you're connecting from - that's also an indication.

You will need to add the IP address of each system that you want to grant access to, and then grant privileges:

CREATE USER 'root'@'ip_address' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip_address';

If you see %, well then, there's another problem altogether as that is "any remote source". If however you do want any/all systems to connect via root, use the % wildcard to grant access:

CREATE USER 'root'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

Finally, reload the permissions, and you should be able to have remote access:

FLUSH PRIVILEGES;

Friday, August 7, 2020

Create custom Eclipse

 

Download Platform Runtime Binary

Choose Eclipse Releaes for add plugin




Choose 

Eclipse Java Developments Tools

Javadocs Help Feature

Javascript Development Tool

Wild Web Developer

m2e - Maven Integration for Eclipse


Add useful update sites

https://www.genuitec.com/updates/devstyle/ci/

(tickDevStyle Features)

 http://eclipse.sonarlint.org

(tick SonarLint for Eclipse, SonarLint for Eclipse Developer Resources,  SonarLint for Eclipse Source Code)

https://dbeaver.io/update/latest/ 

https://github.eclipsesource.com/jshint-eclipse/updates/

https://ecd-plugin.github.io/update


Install Nodeclipse, Wild Web Developer,

Open .js files with Nodelipse-JSDT