Update , Upgrade Freebsd / Ubuntu

Freebsd 11

# freebsd-update fetch
# freebsd-update install
#freebsd-update upgrade -r 11.1-RELEASE
# pkg update
# pkg upgrade

If Error on library :
# pkg-static upgrade  -f


Ubuntu 16 ++

#apt-get update
#apt-get upgrade
#apt-get dist-upgrade
#do-release-upgrade

Reverse Proxy

Ref:
1. https://www.techandme.se/set-up-nginx-reverse-proxy/
2. https://docs.nginx.com/nginx/admin-guide/web-server/reverse-proxy/
3. https://www.knthost.com/nginx/nginx-ssl-perfect-forward-secrecy
4. https://www.knthost.com/nginx/nginx-reverse-proxy-setup-freebsd
5. https://chase-seibert.github.io/blog/2011/12/21/nginx-ssl-reverse-proxy-tutorial.html
6. https://www.digitalocean.com/community/tutorials/how-to-configure-nginx-with-ssl-as-a-reverse-proxy-for-jenkins


sudo apt-get update && sudo apt-get install nginx

Resize Freebsd Space

Ref: https://www.freebsd.org/doc/handbook/disks-growing.html

Migrate MSSQL

Refference :
1. https://stackoverflow.com/questions/18866321/how-to-copy-sql-server-2008-r2-database-from-one-machine-to-another
2. https://social.technet.microsoft.com/Forums/Azure/en-US/5d5840bf-f0ec-4455-880d-7e71a367ba2c/migrate-from-2008-r2-to-2016?forum=sqlsetupandupgrade

Change root mysql maria DB

#mysqld_safe --skip-grant-tables &
#mysql -u root -p

MariaDB [(none)]> use mysql;
MariaDB [(none)]> update user set password=PASSWORD("mynewpassword") where User='root';
MariaDB [(none)]> update user set plugin="mysql_native_password";
MariaDB [(none)]> quit;

#/etc/init.d/mysql stop
#sudo kill -9 $(pgrep mysql)
#/etc/init.d/mysql start