DBeaver SSLHandshakeException certificate errors while downloading MySQL drivers

 So, on a blissful morning I had to reinstall my OS and DBeaver as well.

But to my surprise, DBeaver will not download the MYSQL driver. It kept giving some certificate error.

Network error

Network unavailable:

javax.net.ssl.SSLHandshakeException:PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

The reason being, the java certificate it uses under the hood is expired.

Simple fix to it is remove following line from "dbeaver.ini " file.
This file is present in the DBeaver install folder.
DBeaver install foder for me was "C:\Users\<user>\AppData\Local\DBeaver"

-Djavax.net.ssl.trustStoreType=WINDOWS-ROOT

Thats it. Enjoy databasing 😜

Connect your router to another router wirelessly (Wireless Distribution System (WDS))

I had a situation following situations thta needed to be solved

1. The strength of my primary router was not enough to reach to all parts of my house.

2. I had an old computer that needed to be connected via LAN cable.

Thus I wanted to use another router that could be kept near to the old PC. The second router would connect to the primary router via WIFI (WDS)

Here are the steps used to achieve this goal:

1. Disconnect the primary router
2. Conect to secondary router and Access the Secodary router's web-based interface. usually: http://192.168.0.1
3. Set the IP address of the router:
1. Navigate to Advanced > Network > LAN and adjust the extended router's IP address to match the root router's subnet. (For instance, if the root router's IP address is 192.168.0.1, assign the extended router an IP address within the range of 192.168.0.2 to 192.168.0.254. For example, 192.168.0.2.)
2. Save the changes.

Note: After altering the router's IP address, log in again to the web management page.

3. Identify the SSID for bridging:
1. Visit Advanced > System Tools > System Parameters and focus on the 2.4GHz Wireless section. Enable WDS Bridging.
2. Conduct a survey and select the root router's SSID. (For example, TP-Link_4F98.)
3. If the root router has a wireless password, provide it.
4. Save the settings.
   
   
   
   
   
   
   
4. Deactivate DHCP: (Optional step. Try if it doesn't work)
1. Access Network > DHCP Server.
2. Uncheck Enable DHCP Server and save the changes.
   
   
   

Now, verify the WDS status by navigating to Advanced > Status > Wireless. A "Run" status indicates successful WDS bridging.

Now you are good to go!

Cheers 🙌