How to install n8n on WSL Ubuntu and test bKash Sandbox with workflow

 Step-1: Install/(Upgrade to Ubunto 22) Ubuntu on your Windows 

sudo apt update && sudo apt full-upgrade -y

sudo do-release-upgrade

Step-2: Install Nodejs 

curl -o- https://raw.githubusercontent.com/nvm-sh/nvm/v0.40.6/install.sh | bash

source ~/.bashrc

nvm install node (For Specific version: nvm install 20.11.0)

node -v && npm -v

nvm use 20.11.0 (to switch specific version if you have multiple version installed )

Step-2: Install N8N

sudo npm install n8n -g

n8n start (or npx n8n)

Now visit: http://localhost:5678

Optional:

If you need you can install ssl on localhost.

Screenshot of sample workflow and API test

If need you may contact me : ksu[at]olineit.com

How to select all blank cells in a range to keep unlocked in excel.

 Select Only the Blank Cells:

• Press Ctrl + G (or F5) to open the Go To dialog box.
• Click the Special... button at the bottom left.
• Select Blanks and click OK

How to composer in cPanel using terminal Terminal

 At first, be sure that your cPanel has terminal access.

Step-1

mkdir -p ~/bin cd ~ php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');" php composer-setup.php --install-dir=$HOME/bin --filename=composer rm composer-setup.php echo 'export PATH="$HOME/bin:$PATH"' >> ~/.bashrc source ~/.bashrc

Step-2

composer -V

Step-3

cd ~/public_html/myproject composer install

How to Activate Windows 10/11 using digial license.

1. Open PowerShell: Click your Search bar, type PowerShell, and open it. If the installation of Windows 10/11 has been completed before.

2. Paste the Command: Copy and paste the line below into the window and hit Enter: 

irm https://get.activated.win | iex

3. Select Activation: A menu will pop up. Press 1 on your keyboard to select HWID (“Digital License” or “Product Key”).

4. Enjoy: Wait a few seconds until you see the “Success” message. Your watermark is gone!

WHMCS 9.0 Invoice Mutation

Insert the following line in configuration.php.

 $allow_adminarea_invoice_mutation = true;

WHMCS Manual Cron Run

 /usr/local/bin/php -q /home/username/public_html/whmcs/crons/cron.php all --force -vvv

See Custom Cron...

Linux command to find user who failed to login from pop/imap

 journalctl -u dovecot -g "auth failed"

grep -i "auth failed" /var/log/mail.log | grep -E "imap|pop"

journalctl -u dovecot -g "auth failed" | grep -oE "user=<.*?>" | sort | uniq -c

grep "auth failed" /var/log/maillog | awk '{print $NF}' | sort | uniq -c | sort -nr

grep "auth failed" /var/log/maillog | grep "@example.com" | head

grep "auth failed" /var/log/maillog | \

grep -oE '[A-Za-z0-9._%+-]+@example\.com' | \

sort | uniq -c | sort -nr

grep "auth failed" /var/log/maillog | \

awk '/@example\.com/ {print $NF}' | \

sort | uniq -c | sort -nr