How to extract a substring that comes after or before a specific symbol like @ in excel?

Use the following formula:

=RIGHT(A2,LEN(A2)-SEARCH("-",A2))

Before

=LEFT(A2,LEN(A2)-SEARCH("-",A2))

DAMRC record example for subdomain

deen.revealdigitalmarketing.com. IN TXT

"v=DMARC1;p=reject;sp=none;adkim=r;aspf=r;pct=100;fo=0;rf=afrf;ri=86400;rua=mailto:postmaster@deen.revealdigitalmarketing.com;ruf=mailto:postmaster@deen.revealdigitalmarketing.com"

How to add Mutiple IP and Multiple Domain in Single SPF TXT record

 SFP record example:

v=spf1 +a +mx +ip4:35.209.113.119 ip4:209.145.61.178 include:_spf.mailspamprotection.com include:deen.revealdigitalmarketing.com ~all

Cocoapods install in Mac

First, check the version of Ruby you are using.

$ruby -v ruby 

2.7.1p83 (2020-03-31 revision a0c7c23c9c) [x86_64-darwin18] 

$ which ruby 

usr/bin/ruby


Now use Homebrew to install the latest Ruby.

$ brew install ruby 

==> ruby By default, binaries installed by gem will be placed into: /usr/local/lib/ruby/gems/2.7.0/bin You may want to add this to your PATH. ruby is keg-only, which means it was not symlinked into /usr/local, because macOS already provides this software and installing another version in parallel can cause all kinds of trouble.


If you need to have ruby first in your PATH run:

$ echo 'export PATH="/usr/local/opt/ruby/bin:$PATH"' >> /Users/xxx/.bash_profile
(For newer mac the file name will be : .zprofile )


For compilers to find ruby you may need to set:

$ export LDFLAGS="-L/usr/local/opt/ruby/lib" 

$ export CPPFLAGS="-I/usr/local/opt/ruby/include"


Follow the instructions to set PATH. Now you will go to see the installed Ruby. Make sure to replace the 'xxx' with your username.

$ echo 'export PATH="/usr/local/opt/ruby/bin:$PATH"' >> /Users/xxx/.bash_profile 

$ echo 'export LDFLAGS="-L/usr/local/opt/ruby/lib"' >> ~/.bash_profile 

$ echo 'export CPPFLAGS="-I/usr/local/opt/ruby/include"' >> ~/.bash_profile 

$ source ~/.bash_profile
(For newer mac the file name will be : .zprofile )

Finally, Make sure your PATH is in place.

$ ruby -v ruby 2.7.1p83 (2020-03-31 revision a0c7c23c9c) [x86_64-darwin18] 

$ which ruby 

/usr/local/opt/ruby/bin/ruby


You're good to go! Make sure you install by specifying the save destination as follows.

$ sudo gem install -n /usr/local/bin cocoapods

See more..

Install Webmin on Ubuntu 20.04

sudo apt update

sudo apt install wget apt-transport-https software-properties-common

wget -q http://www.webmin.com/jcameron-key.asc -O- | sudo apt-key add -

sudo add-apt-repository "deb [arch=amd64] http://download.webmin.com/download/repository sarge contrib"

sudo apt install webmin

sudo systemctl status webmin

sudo ufw allow 10000/tcp

sudo ufw reload

https://server-ip:10000/

Installation fails with request timeout in Litespeed server

 LiteSpeed totally ignores the usual Apache setting. You can do it yourself by setting some environment variables for LiteSpeed in the .htaccess file of your document root . See below -

<IfModule Litespeed>

SetEnv noabort 1 

SetEnv noconntimeout 1 

</IfModule>

Install geoip-database in Ubuntu 20

1. Update the package index:

   # sudo apt-get update

2. Install geoip-database deb package:

   # sudo apt-get install geoip-database