Sunday, May 16, 2021

Upgrade PHP 7.3, 7.4 or 8.0 on CentOS 8

Install Remi Release repo and clear cache:

yum -y install http://rpms.remirepo.net/enterprise/remi-release-8.rpm && yum clean all


Install PHP packages version 7.3/7.4 /or 8.0:

yum -y install php73-php-{cli,pdo,fpm,zip,gd,xml,mysqlnd,opcache} 

yum -y install php74-php-{cli,pdo,fpm,zip,gd,xml,mysqlnd,opcache} 

yum -y install php80-php-{cli,pdo,fpm,zip,gd,xml,mysqlnd,opcache}

Saturday, May 1, 2021

How to extract Gmail, Yahoo, Hotmail, Live etc. in excel:

 (Suppose you applied the following formula in D column)

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

Now to the next of D column you can write following formula to separate specific ESP

=if(d2=”gmail.com”,”Gmail”,if(d2=”live.com”,”Live”,if(d2=”hotmail.com”,”Hotmail”,if(d2=”yahoo.com”,”Yahoo”,if(d2=”aol”,”Aol”)))))


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))

Wednesday, April 28, 2021

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



Sunday, April 25, 2021

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

How to get Ranking of the Students in Excel using RANK Function

=RANK(number,ref,[order]) To rank in descending order, we will use the formula =RANK(B2,($C$5:$C$10),0) If we want unique ranks, we can use...