How to Update PHP Version in a LAMP Stack

This article covers: Update PHP in a Lamp Stack Switch PHP version Audiences of this article: Server Admin Install The Latest PHP (7.4 in this case) sudo apt-get install software-properties-common sudo add-apt-repository ppa:ondrej/php sudo apt-get update sudo apt-get install -y php7.4 Disable old PHP version 7.1 and Enable New version 7.4, then restart Apache and […]

How to Configure Timezone Properly in A LAMP Stack

This article covers: How to Setup Time Zone on Your Web Server based on LAMP Stack Audiences of this article: LAMP Stack Admin Change Linux Timezone To check timezone in a Linux OS such as Ubuntu: timedatectl The output looks like this: Local time: Fri 2020-04-10 15:10:28 AEST Universal time: Fri 2020-04-10 05:10:28 UTC RTC […]

Excel VLooup – Compare Two Spreadsheets & Return Value

This article covers: How to use Excel VLooup function to compare columns in two spreadsheets, then return value if there are matched fields between the two columns. A Common Scenario: You have two spreadsheets: one has columns such as ID, Name and Phone Number, the other has ID, Name and Email Address; and you would […]

How to Enable HTTP2 in Apache 2.4

This article covers: How to upgrade from http/1.1 to http/2 on a web server. The Server Environment: Sever OS – Ubuntu 18.0.4 PHP Version – 7.1 Apache Version – 2.4.33 Apache MPM (Multi-Processing Module) prefork is used by PHP Steps If you’re running Apache 2.4, most likely you will have http2 module already installed, all […]

Google Analytics Data Attributes and Segmentations

This article covers: The building blocks and data processing methods of Google Analytics, such as: Scope Segments Filters Dimensions Metrics Scope Scope defines the way how data is collected. As it’s clearly define in Google Analytics, Scope has 4 types: User data Session data Hit data Product Data A hit is single action users perform […]

Address Google Cloud VM Instance SSH Login Issue

This article covers: How to access your Google Cloud VM instance when SSH login fails? How to use GCP Serial Console to address your SSH connection issues? We had an issue with GC VM instance denied our SSH access even with the web console. It turned out to be a mistake made when editing Now […]

How to Add New SSH User in Google Cloud VM Instance

This article covers: How to add new SSH user to your Google Cloud VPS This article is suitable for: Google Cloud VM Instance OS: Ubuntu 18.04 SSH clients: Putty, Pageant Step 1 – Generate Public/Private Key Pair Step 2 – Add Public Key Download your public and private pair to your PC. Open public key, […]

How to Generate CSR and Install SSL in Apache 2.4

This article covers: How to generate CSR (certificate signing request), which is required before when you purchase an SSL. How to install SSL in a shared hosting environment How to redirect http to https The server environment: Apache 2.4, Ubuntu 18.04 Certificate purchased from RapidSSL Online and issued by GeoTrust. Website platform can be either […]

Google Cloud: How to Migrate VM Instances from One Project to Another

If you’re just getting started with GCP, chances are you will have different VM instances running under a default project. Then somewhere down the track, if you decided to set up different billing accounts for different VM instances, you will have to come across this issue. So let’s get it started with a step by […]