If you are getting an error “The MySQL server is running with the secure_file_priv option so it cannot execute this statement” while using ‘LOAD DATA INFILE‘ or ‘INTO OUTFILE‘, then here’s how you can fix it. Here are the snapshots of the error: mysql> select option_value from wp_options WHERE option_value…

If you are using WooCommerce plugin, then you might have noticed order review table being updated after filling out the billing address in the checkout page. If you are looking for a code that updates order review table on state change, then you have landed on the right page. The following are…

If you are working with a deep directory structure, then you might have noticed a lengthier bash prompt. This tutorial will explain various tricks that lets you to shorten bash prompt. For example, if you are working within a directory /var/www/website/content/assets/styles/css/, then based on your settings, you might see a…

Do you need to add or modify state in WooCommerce plugin? If yes, all you need is a simple snippet. Generally, every country in WooCommerce has an unique code. For example, India has a country code of ‘IN’ and IRAN as ‘IR’. Here’s a complete list of country codes in…

Do you want to reset WordPress password? Well, you can use “Lost your password” link in the WordPress login page. Upon clicking, you will be asked to enter WordPress username or email address and once done, WordPress will send you the password reset link. Ok, all is fine when you have an…

Until few months back, I was able to view SSL certificate information in Chrome browser by clicking the padlock icon in the address bar. But starting from Chrome 56, the user cannot follow the same process to view SSL certificate information. For some reason, Chrome does not allow you to…

I have been using file_get_html function of Simple HTML DOM parser to parse and extract the contents of a remote website. The script was working well few months ago, but not anymore (file_get_html returns null). Well, after doing some research, I understood that file_get_html() may not work with all remote…

Are you facing an issue with your cellular data? or do you see an exclamation mark next to the mobile data toggle in the notification tray? Then, you have landed on the right page. In this tutorial, I’ll explain how to fix the issue “Android Cellular data Status Disconnected” If you…

All of a sudden, the Hypervisor Summary page in Horizon dashboard was not updating the usage stats of vCPUs, RAM and Local storage for one of the compute node. I see new VMs are launched on that compute node, but the stats page still showed all the vCPUs, RAM and disk…

I wrote a simple PHP program to copy an image from a website to local directory. The copy() function will copy a file to the specified destination and it can be used to copy a file that’s stored locally and also from a remote website. But I was stuck with…

Question: I have been running cron on a Linux server to take a backup of my website once in a day. But I download those backups to my local machine (which is Windows) once in a week or so. Is it possible to automate file transfer from Linux to Windows? Answer: Yes, you…

Have you installed VSFTP in your OpenStack or Amazon EC2 VM and getting errors such as “Entering passive mode…connection failed“? If yes, then you have landed on the right page. This tutorial will help you to fix the FTP passive mode problem on VMs started in OpenStack cloud middle-ware and…

In this tutorial, I will explain how to configure SSH to allow SFTP and disallow SSH login access. Solution: Well, SFTP uses SSH and by default the users will able to use both SSH and SFTP. But if you ever want users to use only SFTP and disallow SSH access, then…

Today, I noticed a strange connection attempt to my server requesting for a long file name – that starts as ‘/YesThisIsAReallyLongRequestURLbutWeAreDoingItOnPurpose……………….’. Below is the snapshot from the Apache error log. [Thu May 11 17:52:01 2017] [error] [client 137.226.113.7] (36)File name too long  : access to /YesThisIsAReallyLongRequestURLbutWeAreDoingItOnPurposeWeAreScanningForResearchPurposePleaseHaveALookAtTheUserAgentTHXYesThisIsAReallyLongRequestURL        …

TRUST is the word that comes to our mind when we speak about Certificate Authority. StartSSL, a certificate authority that provides free SSL certificate with a validity of one year for non-commercial use. An initiative that aimed to secure the internet traffic has now lost TRUST – StartSSL distrusted! The CA lost trust well…

Nova service controls where the instances are started within OpenStack cloud environment. It means, the nova-scheduler decides which hypervisor will run a particular instance and this behavior is controlled using two filters (Affinity/anti-affinity group policies) – namely, ServerGroupAntiAffinityFilter and ServerGroupAffinityFilter. The ServerGroupAffinityFilter allows a user to run group of instances on the…

Working on a Unix terminal and all of a sudden the terminal freezes after pressing Ctrl+S? Well, did you see the same behavior when you were editing a file using Vi? Not a problem, this tutorial will help you to resume it back. Generally, most of the editors would allow you…

Do you want to delete blank rows in an Excel file, the faster way? Excel generally uses the blank rows to determine data ranges, but sometimes you might want to get rid of those. For e.g., say you want to write a simple script to parse all the rows in…

Are you using the_date function inside the loop to display post published date? Well, you might notice the_date() returning empty date for the posts that are published on the same day. For example, if you have two posts published on the same day, then the_date function will return date for the first…