KrishTalk.com

 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=*.test.com/emailAddress=test@test" #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...

Flask is one of the most used frameworks in Python. If you are new to the flask and if you are getting this error - ImportError: No module named 'flask' on virtualenv, read further. You are sure that the Flask module is already installed. But still, you are getting No module error. This is because you need to install a flask framework inside the virtualenv. Follow these instructions Step 1 Create a directory where you will be installing the virtualenv.   krishna@osboxes:~$ mkdir testenv   Step 2 Get inside the folder and install virtualenv krishna@osboxes:~$ cd testenv/ krishna@osboxes:~/testenv$ pip install virtualenv or $ sudo apt-get install virtualenv   Successfully installed appdirs contextlib2 distlib filelock importlib-metadata importlib-resources pathlib2 scandir singledispatch six typing unknown unknown virtualenv Step 3 Activate the virtualenv This virtual environment requires activation and dedicated installation insid...

DevOps is a buzz word in the last decade, everybody wants to try their luck in DevOps. DevOps is the most generic area of software engineering. Every team and every company wants to have a team called DevOps. Nowadays, everybody wants a DevOps tag name attached to them irrespective of what they do. This works for most people. Because of the generous nature of the DevOps skillsets. That means, the pool of DevOps skillsets so huge, even if you know a few of them, it will work for you. If you are a developer or QA and want to change over to DevOps, here is the list of bare minimum technologies and skills you should learn. These are the mandatory skillsets you should possess before you try your luck in DevOps. 1. Expert Knowledge on Linux Environment You take any software development, without a Linux flavor it will be incomplete. You should have a thorough knowledge of how to work in a Linux environment. If you have system administration knowledge, then it's a huge advantage. Mos...

Redmi Note 8 Pro is among the most anticipated flagship phone in the last few months in India. Now that it is available and I wanted to list out some of the features that new on this device and interesting. You can connect to Wifi and enable Hotspot at the same time This is a very interesting feature. You can enable WiFi and at the same time, you can enable the hotspot. Earlier, either you could enable WiFi or enable Hotspot at the same time. That means you could use mobile data in the hotspot. Once you enable the hotspot, your WiFi would be disabled and when you enable the WiFi, your hotspot would be disabled. With this, you could only share your mobile data through the hotspot. Now you can use the WiFi data to share the internet through the hotspot. With this, you can use your mobile as a WiFi repeater, as a WiFi relay. If your WiFi router is a bit far from your TV, for example, and if the strength of the Wifi signal is weak, then you can keep your mobile phone in between these...

There are lots of things you can do with MS Excel and MS word. Word and Excel can be connected easily to build sophisticated use cases. Mail merge is one of the great tool, where you can leverage the data power of excel and reporting feature of the MS Word. With a bit of VBA knowledge, you can extend the mail merge for usages. Below I explain how to use the Excel data to populate the DropDown control in the MS word. And it is dynamic, when the data in Excel got changed, the items in the drop-down will also be changed.  First, I have this sample data in Excel. I want this data to be displayed in a dropdown control in the MS Word. For this I am making use of this macro or VBA code. Private Sub ld_Click() Dim objExcel As New Excel.Application Dim objWB As Excel.Workbook Set objWB = objExcel.Workbooks.Open("C:\Users\krsanjee\Documents\krishtalk.com\book1.xlsx") 'Me.drop.RemoveItem (0) Me.drop.Clear total_rows = Cells(Rows.Count, 1).End(xlUp)....

If you are using Windows 10 operating system and want to use virtualization on it, then you have 2 options. 1. Using Virtual Box 2. Using Hyper V This post is not about how to use them but instead, what are the issues you will encounter if you have them together. One scenario is, you have VirtualBox installed and working fine. Then you realize you want to use a docker on your Windows machine. The VirtualBox working fine until will start comparing about virtualization and acceleration. After installing the docker on your windows, all your VMs on the VirtualBox cannot start. It complains about the availability of virtualization. " The hardware virtualization is enabled in the Acceleration section of the system although it is not supported from the host system. It should be disabled in order to start the visual system " The error message not straight forward to understand. As you know virtualization is required for docker or VirtualBox to work. First thing you will do...

1. Condition on a single cell To apply conditional formatting based on the values of multiple cells. In other words, format a cell where formatting cell is different and conditional cell is different. Click on the cell where you want to apply for formatting Go to Home on the Ribbon, then select Conditional Formatting. Then select the last option, "Use a formula to select which cell to format" Now, in the formula cell write the formula for your condition =$C$6=10 2. Conditions on multiple cells What if you have to consider multiple cells for the condition? Condition cell 1: Value equal to 10 Condition cell 2: Value equal to "Krishna"  You need to build a formula with multiple conditions using AND operator. Based on your requirement, you can also use OR operator. Not just AND and OR, you can use any of the available functions in the MS Excel. The overall result should be TRUE or FALSE. It does not matter how complex your formula is, what do...