Latest Questions and Answers

How to check which mysql version is available to install in UBUNTU?

If MySQL is not installed, you can check the available versions in the Ubuntu repositories using the following commands: sudo apt-cache policy mysql and if MySql is installed already then you can run below command to check the version: sudo mysql --version  Additionally, you can use the apt list command to list the available versions of MySQL packages: sudo apt list -a | grep mys... (more)

How to write unit tests in node JS using Jest?

  To write unite tests in node js you nee to install jest package. After installing the package create a js file with name like abc.test.js. Filename should always contain .test.js in the last of file name then it will be identified by jest framework to execute added unit tests. In this example I have a file run.js containing functions and run.test.js file containing unit tests of t... (more)

How to create a private key and convert a .pem file to .ppk and from .ppk to .pem on Windows?
How to generate a public key using puttygen?
How to debug in nodejs?

In the it is explained in real time so have look to understand properly.

How to create a new SSH key in Azure and use it to access a VM?

To create a new SSH key 1- Login to azure portal and go to the search bar and search "SSH Key" and click on the option. 2- On that panel you will see a Create option click on it and you will see a panel opened same like below. 3- Fill the details and click "Review + Create" button. 4- After it is created click on this newly created key, you will see a public key "Public key" copy i... (more)

Hot, cool, and archive access tiers for blob storage data in azure?

Data stored in the cloud grows at an exponential pace. To manage costs for your expanding storage needs, it can be helpful to organize your data based on how frequently it will be accessed and how long it will be retained. Azure storage offers different access tiers so that you can store your blob data in the most cost-effective manner based on how it's being used. Azure Storage access tiers i... (more)

Composer execution killed | Composer killed while updating laravel?

Composer update or composer install throwing an error something like "killed" showing on screen. It is generally occurs when you don't have enough memory (RAM) on your machine. In this case solution will be to increase your ram and if you are running on your PC or lower ENV server then possible solutions could be as below: - Stopping some unnecessary processes which will reduce RAM cons... (more)

What is the AWS CLI ( Command Line Interface )?

The AWS Command Line Interface (AWS CLI) is a tool to manage your AWS services. With just one tool to download and configure, you can control multiple AWS services from the command line and automate them through scripts. AWS CLI is a tool that pulls all the AWS services together in one central console, giving you easy control of multiple AWS services with a single tool. The AWS CLI v2 of... (more)

How to reset SSH key pair of Azure VM | How to use a new ssh key to connect with VM?

You can get access in an Azure VM if you have lost your access of that VM or you just created a VM and don't have credentials to login into the VM, in all these scenarios you can follow below solution. 1- Get the SSH key which you use to login in any other server. OR 2- Create a new SSH key from SSH key service. 3- Copy the public key of the key file and paste in the field of below... (more)

How to export and restore few tables in mysql database from command line?

We can export some/partial number of tables from mysql database and below are the commands which you can use and put your details according: Export:         sudo mysqldump -h db_hostname -P 3306 -u db_username -p DatabaseName table_1 table_2 > export_tables.sql Import:         sudo mysql -u db_username -p DatabaseName < export_tables.sql In case you are trying to export azure ... (more)

How to set custom environment variables in GitHub Actions workflow file?

You can use environment variables to store information that you want to reference in your workflow. You reference environment variables within a workflow step or an action, and the variables are interpolated on the runner machine that runs your workflow. Commands that run in actions or workflow steps can create, read, and modify environment variables. You can set your own custom environment var... (more)

What is Docker?

Docker is a software platform that allows you to build, test, and deploy applications quickly. Docker packages software into standardized units called containers that have everything the software needs to run including libraries, system tools, code, and runtime. Using Docker, you can quickly deploy and scale applications into any environment and know your code will run. Running Docker on AW... (more)

How to Dockerize node app and using .env file?

How to Dockerize a nodejs app and use environment variavles / .env file in container?

How to automate Docker image deployment on server?

Please explain a complete deployment lifecycle to deploy latest code on server using CICD / Github Actions. 

How to create an image of Linux VM in Azure?

Capture a VM in the portal: Note:  Don't capture image if server is running on production or running and you can't bear its loss. Since capturing image will destroy the current server and you will not be able to run again. You will have to create a new Vm from the captured image only. There is another way to clone the VM which is snapshot, refer to this article How to create a Snapshot... (more)

How to create a Snapshot in Azure?

A snapshot is a full, read-only copy of a virtual hard disk (VHD). You can use a snapshot as a point-in-time backup, or to help troubleshoot virtual machine (VM) issues. You can take a snapshot of both operating system (OS) or data disk VHDs. Create a snapshot of a VHD: If you want to use a snapshot to create a new VM, ensure that you first cleanly shut down the VM. This action clears any pr... (more)

How to create a VM from a VHD/Disk in Azure?

There are several ways to create a virtual machine (VM) in Azure: If you already have a virtual hard disk (VHD) to use or you want to copy the VHD from an existing VM to use, you can create a new VM by attaching the VHD to the new VM as an OS disk. You can create a new VM from the VHD of a VM that has been deleted. For example, if you have an Azure VM that isn't working correctly, yo... (more)

What is the difference between OS Disk and Data Disk in Azure?

Data disk: A data disk is a managed disk that's attached to a virtual machine to store application data, or other data you need to keep. Data disks are registered as SCSI drives and are labeled with a letter that you choose. Each data disk has a maximum capacity of 32,767 gibibytes (GiB). The size of the virtual machine determines how many data disks you can attach to it and the type of sto... (more)

How to automate taking snapshots in Azure?

Automate taking snapshot in azure manual and automated. Script that will require to put in runbook: $resourceGroupName = 'ABC'  $location = 'eastus'  $vmName = 'VM-Name' $datetime = Get-Date -Format "MM-dd-yyyy-HH-mm" $snapshotName = 'Snapshot-' + $datetime   # Ensures you do not inherit an AzContext in your run... (more)

How to install free SSL using DNS challenge (apply on all subdomains) on ubuntu server?

To configure free SSL on website domain, there are few steps need to follow and require you to have access of below: - Domain management panel like route53 in AWS, DNS zone in azure etc where you can go and create a txt record. - Server terminal access so that you can login and make some change in apache configuration file to specify certificate path Once you have these access, now foll... (more)

How to automate free SSL renewal on Azure Load Balancer/Appication Gateway?

To generate and automate free SSL certificate on application gateway of load balancer, you need to go through below steps: - Create a storage account - Create a public container and two folders inside ".well-known / acme-challenge" to upload tokens - Create Automation account and then create "Run As Account" - Create runbook with the large script we have already - Install "ACME-PS" and "ACM... (more)

What is Azure DevOps?

Azure DevOps provides developer services for allowing teams to plan work, collaborate on code development, and build and deploy applications. Azure DevOps supports a collaborative culture and set of processes that bring together developers, project managers, and contributors to develop software. It allows organizations to create and improve products at a faster pace than they can with traditio... (more)

What is Swap Memory in Linux / Ubuntu?

Swap is a portion of hard drive storage that has been set aside for the operating system to temporarily store data that it can no longer hold in RAM. This lets you increase the amount of information that your server can keep in its working memory, with some caveats. The swap space on the hard drive will be used mainly when there is no longer sufficient space in RAM to hold in-use application data.... (more)

How to send email using PHPMailer in laravel?

Many PHP developers need to send email from their code. The only PHP function that supports this directly is mail(). However, it does not provide any assistance for making use of popular features such as encryption, authentication, HTML messages, and attachments. Formatting email correctly is surprisingly difficult. There are myriad overlapping (and conflicting) standards, requiring tight adher... (more)

How to solve mysql query error when using table name in capital letter?

In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Triggers also correspond to files. Consequently, the case sensitivity of the underlying operating system plays a part in the case sensitivity of database, table, and trigger names. ... (more)

How to start with Azure Functions in Azure Server?

In this article, you use Visual Studio Code to create a Python function that responds to HTTP requests. After testing the code locally, you deploy it to the server less environment of Azure Functions. Reference: https://docs.microsoft.com/en-us/azure/azure-functions/create-first-function-vs-code-python ... (more)

What is logic app practical example, Send alert to slack?

Azure Logic Apps is a cloud-based platform for creating and running automated workflows that integrate your apps, data, services, and systems. With this platform, you can quickly develop highly scalable integration solutions for your enterprise and business-to-business (B2B) scenarios. As a member of Azure Integration Services, Azure Logic Apps simplifies the way that you connect legacy, moder... (more)

What is cloud server?

Please watch the video below to have complete understanding of cloud servers.

What is Azure Logic Apps?

Azure Logic Apps has been explained in the video below:

What is azure functions?

Azure Functions is a serverless solution that allows you to write less code, maintain less infrastructure, and save on costs. Instead of worrying about deploying and maintaining servers, the cloud infrastructure provides all the up-to-date resources needed to keep your applications running. Azure function has been explained in the video below: ... (more)

How to create a server on AWS EC2?

You can watch this video to see how to create a linux server on AWS EC2. We have explained all important sections which are required to create a apache web server so you can host your website on this server. It is very easy to get a server ready on aws.    ... (more)

How to implement Google Login in Jenkins?

We have a very easy steps to implement Google Login in Jenkins. In Jenkins by default we have an admin user authentication enabled but we can establish the user authentication from the Global Security section. We have to create users for team members and it maintains all user in its own database. We can also configure Jenkins with Google login using OAuth. So, if you are leveraging G... (more)

How to copy data from S3 to Azure blob using AzCopy?

AzCopy is a command-line utility that you can use to copy blobs or files to or from a storage account. This article helps you copy objects, directories, and buckets from Amazon Web Services (AWS) S3 to Azure Blob Storage by using AzCopy. You will need below authorizations to get this work done: 1- To authorize with the Azure Storage, use Azure Active Directory (AD) or a Shared Access Sig... (more)

How to copy files/folders from EC2 to S3 bucket?

To perform these operation you will need to follow step below: Create an IAM role with S3 write access or admin access     https://docs.aws.amazon.com/IAM/latest/UserGuide/id_roles_create_for-service.html Map the IAM role to an EC2 instance     https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/iam-roles-for-amazon-ec2.html Install AWS CLI in EC2 instance     https://docs... (more)

How to import and Export large Database in MySql using command line?

You just need to login to your server where mysql is installed and start using below commands. It is very easy and capable to export and import huge databases quickly. Export Database:     mysqldump -h localhost -u root -p database_name > export_file.sql Export Database and Exclude Some tables:     mysqldump -h localhost -P 3306 -u root -p --ignore-table=table1 --ignore-table=tab... (more)

How to transfer/migrate a repository to a user account or organization in Github?

Transferring a repository:     - You can transfer repositories to other users or organization accounts. When you transfer a repository to a new owner, they can immediately administer the repository's contents, issues, pull requests, releases, project boards, and settings. Prerequisites for repository transfers:          - When you transfer a repository that you own to anothe... (more)

What is Organization and Team in Github?

Organizations: Organizations are shared accounts where businesses and open-source projects can collaborate across many projects at once. Owners and administrators can manage members access to the organization's data and projects with sophisticated security and administrative features. You can create more than one organization as per your need. Organizations includes:     Unlimite... (more)

How to add an existing project to GitHub repository?

These are the steps you an follow to connect/add an existing project with remote github repository. - Initialize the local directory as a Git repository. git init -b featured_branch - Add the files in your new local repository. This stages them for the first commit. git add . - Commit the files that you've staged in your local repository. git commit -m "First commit" Add the U... (more)

How to create droplet / server on digitalocean?

It is very simple to create and setup a web server on digitalocean droplets. You can refer to instructions illustrated in video to get it done. ... (more)

How to attach a Data Disk to a Linux VM in Azure?

1- Go to the Azure portal to find the VM. Search and select Virtual machines. Choose the VM from the list. In the Virtual machines page, under Settings, choose Disks. 2- On the Disks pane, under Data disks, select Create and attach a new disk. Enter a name for your managed disk. Review the default settings, and update the Storage type, Size (GiB), Encryption and Host ca... (more)

How to Copy file / folder from EC2 to S3 and vice-versa?

You can copy any file or folder from EC2 to S3 and from S3 to EC2. This can be done easily using AWS CLI command. To check whether you have installed AWS CLI or not use below command aws --version Output will be something like: aws-cli/2.1.29 Python/3.7.4 Linux/10 botocore/2.0.0 If not already installed use below command to install it. sudo apt-get install awscli  on Linux termi... (more)

How to check whether laptop has SSD or HDD hard disk?

It is very easy to check whether our laptop had SSD or HDD hard disk. You just need to search in window taskbar "Defragment" and click on "Defragment and Optimize Drives" option. You will see below window opened:     You can see under "Media Type" it shows SSD or HDD.  ... (more)

How to start with Node Js?

Node.js is an open-source and cross-platform JavaScript runtime environment. It is a popular tool for almost any kind of project! A Node.js app runs in a single process, without creating a new thread for every request. Node.js provides a set of asynchronous I/O primitives in its standard library that prevent JavaScript code from blocking and generally, libraries in Node.js are written using non... (more)

How much time does it take to be expert in Selenium?

Selenium is a popular open source web based test automation tool. This online course is a step by step guide to learn Selenium Concepts. You all must be wondering that why Selenium is in demand? Why Selenium professional enjoys the perks of a good salary? Moreover, it is important to know the reasons attached to learn Selenium. All these questions are genuine and can pop up in anybody’s mind.... (more)

What is the difference between tree and graph data structure?

Tree and Graph both are data structure to store data different format. Due their structure one is called tree and the other one is called graph. We can understand their differences from below table: There are many other differences but these are some of them.... (more)

How to stop others to post on your facebook page?

To stop people/visitor publish their posts on your page, you can do this from facebook page settings. It is required sometime to make your page more secure from unwanted posts by others. Lets see the the steps to disable this permission from page settings. Follow below steps:   - Go to your facebook page - Go to left sidebar on bottom  - Click on "Settings" - Click on "Vis... (more)

Apache Invalid command 'ProxyPass'?

If you are using Linux Ubuntu operating system and have setup apache web server. In some case if you get the error mentioned in question description and want to solve it, for that you just need to install proxy module and restart apache and it will solve your problem. Below are the steps to solve this issue: sudo a2enmod proxy sudo a2enmod proxy_http sudo systemctl restart apache2 Hope... (more)

What is Facebook Business Suite?

  With Facebook Business Suite (Pages Manager), you can access and manage the tools your business needs to thrive across your Facebook Page and Instagram account, simplified and in one place. Use this app to:  Create, schedule, and manage posts and stories to your Facebook Page and Instagram account. Facebook Business Suite lets you manage all of your connected accounts across Faceb... (more)

Free video editing software for desktop?

There are numerous computer-based totally enhancing software programs available for corporations seeking to create promotional films. The largest gain of loose video modifying software programs for computers is they have a tendency to have greater functions than most cellular video enhancing apps. If you are looking to edit your promotional video pictures on a finances, Look at our list of free... (more)