Wednesday, September 19, 2018

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


Wednesday, September 12, 2018

Resize Freebsd Space

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

Monday, July 16, 2018

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

Monday, April 2, 2018

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

Monday, October 30, 2017

Upgrade Ubuntu Ubuntu 16.04.1 LTS to Ubuntu 16.04.3 LTS

First of all you have to check Ubuntu end of life:
https://www.ubuntu.com/info/release-end-of-life

2. You can used this step to upgrade your ubuntu;
Ref: https://www.digitalocean.com/community/tutorials/how-to-upgrade-to-ubuntu-16-04-lts

3. But when you run apt-get upgrade
    You got error run apt-get -f install .
This maybe because of your /boot is already fully utilize 100%.

Here is the step to solve it : Ref: https://askubuntu.com/questions/345588/what-is-the-safest-way-to-clean-up-boot-partition

Or you can used Ref: http://www.mogilowski.net/lang/en-us/2014/04/14/remove-old-kernel-packages-from-ubuntu/

4. If you have problem while upgrading nginx:
EG: Errors were encountered while processing: nginx-extras

  •   You have to check what web service that you use? 
5. Check your version 
lsb_release -a


Tuesday, October 3, 2017

Upgrade freebsd 10.3 to 11

Ref:
1. https://sysadmin-note.ru/obnovlenie-freebsd-s-10-3-do-11-0/
2. https://www.linuxsecrets.com/en/entry/51-freebsd/2017/08/30/2926-upgrading-freebsd-11-0-to-11-1