Posted on | by @thinkcyber | Leave a Comment on 
UPDATE  `MySQL_Table` SET  `MySQL_Table_Column` = REPLACE(`MySQL_Table_Column`, 'oldString', 'newString') WHERE  `MySQL_Table_Column` LIKE 'oldString%';

When Should I use MySQL Search and Replace?

Doing a Search and Replace via SQL could be dangerous if you have links that you’re unaware of which shouldn’t be changed. You should Search and Replace only when you’re convinced that you have to change the text in your Database. You should always perform a Database backup before proceeding with any manual changes.

Linux and Unix Copy files

Posted on | by @thinkcyber | Leave a Comment on Linux and Unix Copy files

To copy a directory with all subdirectories and files, use the cp command. Below is an example command of how you would use the cp command to copy files. Additional information about this command and other examples are available through the above cp link.

cp -r /home/hope/files/* /home/hope/backup

In the example above, the cp command would copy all files, directories, and subdirectories in the /home/hope/files directory to the /home/hope/backup directory.

Letsencrypt (Certbot) Generate The Wildcard SSL Certificate

Posted on | by @thinkcyber | Leave a Comment on Letsencrypt (Certbot) Generate The Wildcard SSL Certificate

Now with the help of Certbot will generate wildcard certificate for our test domain erpnext.xyz

sudo certbot certonly --manual --preferred-challenges=dns --email nome@erpnext.xyz --server https://acme-v02.api.letsencrypt.org/directory --agree-tos -d *.erpnext.xyz

After executing the above command, the Certbot will share a text record to add to your DNS.


Please deploy a DNS TXT record under the name
_acme-challenge.erpnext.xyz with the following value:

J50GNXkhGmKCfn-0LQJcknVGtPEAQ_U_WajcLXgqWqo

Then you will receive:

Press Enter to Continue
Waiting for verification...
Cleaning up challenges

IMPORTANT NOTES:
 - Congratulations! Your certificate and chain have been saved at:
   /etc/letsencrypt/live/erpnext.xyz-0001/fullchain.pem
   Your key file has been saved at:
   /etc/letsencrypt/live/erpnext.xyz-0001/privkey.pem
  Your cert will expire on 2019-08-31. To obtain a new or tweaked
   version of this certificate in the future, simply run certbot
   again. To non-interactively renew *all* of your certificates, run
   "certbot renew"
 - If you like Certbot, please consider supporting our work by:

   Donating to ISRG / Let's Encrypt:   https://letsencrypt.org/donate
   Donating to EFF:                    https://eff.org/donate-le

done!

How do up upgrade LetsEncrypt certbot to version 0.22 which supports wildcard certificates?

Posted on | by @thinkcyber | Leave a Comment on How do up upgrade LetsEncrypt certbot to version 0.22 which supports wildcard certificates?

Check version number

certbot --version || /path/to/certbot-auto --version

If you have already installed Certbot, you should add a parameter to apt-get install to upgrade only a specific package

sudo apt-get update
sudo apt-get install --only-upgrade certbot

Ubuntu 14.04 – PHP Version Upgraded

Posted on | by @thinkcyber | Leave a Comment on Ubuntu 14.04 – PHP Version Upgraded 
php -v

Shows:

PHP 5.6.25-2+deb.sury.org~trusty+1 (cli)
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologiescode

In the page the php code phpinfo();

phpinfo();

Shows:
PHP Version 5.5.9-1ubuntu4.19

Now to correct this you need to:

sudo a2dismod php5
sudo a2enmod php5.6
sudo service apache2 restart

Cheers

Letsencrypt Combining plugins

Posted on | by @thinkcyber | Leave a Comment on Letsencrypt Combining plugins

Combining plugins

Sometimes you may want to specify a combination of distinct authenticator and installer plugins. To do so, specify the authenticator plugin with --authenticator or -a and the installer plugin with --installer or -i.

For instance, you could create a certificate using the webroot plugin for authentication and the apache plugin for installation.

certbot run -a webroot -i apache -w /var/www/html -d example.com

Link: Get more info at Certbot.