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 🙌

Displaying PHP Errors from admin-ajax.php in Wordpress

Edit wp-includes/class-wp-fatal-error-handler.php and 

change this in display_default_error_template( $error, $handled ) (Line: 193):

$message = sprintf(

                        '<p>%s</p><p><a href="%s">%s</a></p>',

                        $message,

                        /* translators: Documentation explaining debugging in WordPress. */

                        __( 'https://wordpress.org/support/article/debugging-in-wordpress/' ),

                        __( 'Learn more about debugging in WordPress.' )

                );

to

$message = sprintf(

                        '<p>%s</p><p><a href="%s">%s</a></p>',

                        $message . ' ' . json_encode($error),

                        /* translators: Documentation explaining debugging in WordPress. */

                        __( 'https://wordpress.org/support/article/debugging-in-wordpress/' ),

                        __( 'Learn more about debugging in WordPress.' )

                );

Then preview HTML response to admin-ajax.php using Dev Tools.

New Order alert on Telegram for Prestashop

I created a Prestashop Module for a project that would send an alert to a Telegarm group when ever a new order is placed.
I would like to share the same with all of you.
Please feel free to download and use 👦

You can download the module zip file from here - https://github.com/bhaskarvyas001/TelegramOrderAlert

Requirement:
1. You will need to Telegram Bot Token
This can be got by creating a bot. Details to create a telegram bot is here - https://core.telegram.org/bots#6-botfather

2. You will need to know that Chat Id of the telegram group where you want to receive the alert
You can find out the Chat Id by following details here - https://stackoverflow.com/questions/32423837/telegram-bot-how-to-get-a-group-chat-id

Setting Screen

This is how the Telegram alert would look like