GA3 vs GA4 Comparison

Google Analytics 3 (GA3) was launched on October 18, 2007 and it’s going away on 1st July, 2023. This version of Google Analytics was replaced by Google Analytics 4 (GA4), which was launched on October 14, 2020. GA4 is the latest version of Google Analytics and offers new features and capabilities compared to GA3, such […]

GCP: How to Recover Your SSH Login When You Forget Your Custom SSH Port?

Prerequisites GCP with VM instances. Firstly, here is how to change the default SSH port You can change the default SSH port from 22 to something else in sshd_config then restart your sshd service – make sure keep your current SSH connection open until your new port is verified to avoid locked out of your […]

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 sudo apt install php7.4-common php7.4-mysql php7.4-xml php7.4-xmlrpc php7.4-curl php7.4-gd php7.4-imagick php7.4-cli php7.4-dev php7.4-imap php7.4-mbstring […]

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 […]