Showing posts from 2021

How to create a self signed SSL certificate and how to use it with your web Server.

SSL certificate is the foremost important aspect of any website. If your website is running without the SSL, the modern browsers will stop the users from entering the website. Of course, there are ways to bypass that, at your own risk. As long as your website has no commercial data exchange, sensitive user information, etc, you are still good to run a website without a proper SSL certificate. For example, a blog can run without an SSL.  Note that Google AdSense accepts websites without SSL.  But the topic of this post is about Self Signed SSL certificate. How to create one, how to use it, and where to use it.  Let us see where to use it. For any website which is used for internal purposes, it's always a good idea to use Self Signed SSL, instead of paying for a real SSL certificate. Internal I mean, within a company, team, or for personal uses, for testing purposes, etc.  Now, let us see how to create a self-signed SSL certificate.  What you need A Linux machine.  OpenSSL utility  A

How to set Python3 as default interpreter for VS Code | or set any version as default interpreter.

Want to run your python code with a particular python version in Microsoft VS Code? And, make it the default version? Read on. Make sure that the required version is installed. You check the available version and the path by running this command. I am trying this on Apple Mac. It should be similar in Windows Machines as well.   Open the VS Code, at the bottom of the screen you will Terminal. If it is not visible, Go to View and then select Terminal. Check the available python versions and their path.   % which python   /usr/bin/python  % which python2 /usr/bin/python2  % which python3   /Library/Frameworks/Python.framework/Versions/3.7/bin/python3 Next,  Run this python code to check what version is used by default.  import platform print ( platform . python_version_tuple ()) print ( type ( platform . python_version_tuple ())) You will get this ('2', '7', '16') <type 'tuple'> Now you know the path and versions available. In the VS code, go to the

SOLVED | AdSense Approval Issues and Fixes for Site down or Unavailable | How to Fix

I tried to get an AdSense approval for my site but I got a mail from AdSense saying the site is down or unavailable. But the site is definitely accessible and all the other requirements are taken care of. The site is also very old and the domain itself is 3 years old. There are no issues with page views as well.  Here is my situation. I have an approved AdSense for YouTube. I got my blogger site upgrade to a top-level domain. This is the requirement to link your YouTube AdSense to your blogger site.   I have taken care of all the requirements to apply for the AdSense for my site.  1. Clean design and unique content. No issue with the design as I have created it using a blogger theme.  2. About page, Contact Us Page, Privacy Policy Page. These are mandatory  3. Top-Leve Domain After applying for the AdSense I got the denial mail and looking at the reason, I was convinced that there must be a small mistake in the Domain setup or blogger settings.    I tried these things and found the cul

How to create MS Word document automatically with Excel

MS Word and Excel can do wonders together.  You can do a lot of automation using these 2 applications for your small and medium businesses.  Here is one such solution.   Generating the MS word report automatically using excel as a data source. Mail merge is used to link data from excel to word. Then a simple macro is used to get the desired record from Excel Spreadsheet. Download the MS word document and Excel spreadsheet used in this video here If you are not able to access this link, let me know. The link in my YouTube channel was not working, now I have uploaded the files here. 

[SOLVED] MacBook Pro keyboard backlight not working? Check this post

Keyboard backlight not working on your MacBook Pro? And your Mac has a touch bar?  Continue reading... MacBook Pro 2020 which comes with a touch bar has moved its Keyboard backlight controls to the touch bar. You will not see any control on the screen under the Keyboard settings. But the setting in the touch bar is also not easy to see and it bit tricky. You most probably, think that there is some issue with Keyboard. Even the support people suggest resetting some of the settings. That is what happened with my case. Luckily I found a way to change the settings.  By default, the Keyboard backlight settings are not visible on the touch bar. You have to expand the tra-like stuff on the touch bar and then you will find icons, which look similar to screen brightness control icons.  On the right side of your touch bar, you will these 4 controls 1. Screen Brightness control  2. Volume control  3. Mute control  4. Siri button.  Left these controls there is an arrow button which looks like '

How to create self signed ssl certificate, easy steps

 These are the ready commands to create self-signed SSL certificate. These certificates can be used for testing purposes. For a production-grade application, you need to contact a CA authority to get the actual SSL certificate. But for your internal testing, you can always use a self-signed SSL certificate.  Here are the steps to create a Self Signed SSL certificate using OpenSSL # generate self sigend ssl certificate rm -rf *.pem echo "Generating CA certificates" # Step 1: generate CAs certificate openssl req -x509 -newkey rsa:4096 -days 365 -keyout ca-key.pem -out ca-cert.pem -subj "/C=IN/ST=kartnataka/L=bangalore/O=test/OU=test/CN=*" #inspect the CAs certificate #openssl x509 -in ca-cert.pem -noout -text # Step 2 generate server sign request certificate which will be used for self signing. Change the subject to as per web server echo "Generating Server certificate sign request" openssl req  -newkey rsa:4096 -keyout server