Author: @ginK
-
Ansible – Encrypt/Decrypt Hosts Configration File
— ENCRYPT — Generate file key $ echo “Masukkan Passwordnya Disini” | openssl dgst -sha256 -binary | openssl base64 > ~/.ssh/.ansible.key $ cat ~/.ssh/.ansible.key 3Bvdpr9FE40FyCmRfEIxS0B6kAKdIpsK98R68kQWXQk== Encrypt file hosts $ ansible-vault encrypt –vault-password-file ~/.ssh/.ansible.key hosts Encryption successful Check file hosts $ cat hosts $ANSIBLE_VAULT;1.1;AES256 62663966306532643833653330666334333130323436636266626137626430343139353538303530 6639663736376664346438613133663036623432396234320a316166656638373834393235333335 38316431393431343632613165626633663231643533393363646238303731636163313161346132 6435326638343233350a333363613661373434303361616332613765316664393333393264333732 30393737633332356236616162343930363264616636613430353030306433356364616635366331 34353635336534363433353232383732363135613133333634623630326566333361623461386166 62326636656635623037646264363233633233653662656566353633383137383432366665313062 30656464626564326537316164336465343266393761396565323161346666643033333566633366 33303134376234323531313866616137383631613363396139383663393962626138643465336631 30356564636231393430306263613064396161353637373437613137333930363163303733303331 35336563313736343036366633373332313765636565323732363638666637666366316663333432 62623563333766303136653136376632373138666462333366373738366261333636303531393737…
-
Ansible Mikrotik Backup Configuration
$ vi ansible.cfg [defaults] inventory = $HOME/ansible/hosts remote_tmp = $HOME/ansible/tmp/ansible-${USER}/tmp local_tmp = $HOME/ansible/tmp/ansible-${USER}/tmp host_key_checking = False timeout = 15 log_path = $HOME/ansible/ansible.log $ vi hosts [mikrotik] 192.168.21.21 ansible_host=192.168.21.21 192.168.116.116 ansible_host=192.168.116.116 [mikrotik:vars] ansible_user = agink ansible_password = xxxPas5worDxxx # ansible_private_key_file = ~/.ssh/id_macos ansible_port = 2121 ansible_connection = network_cli ansible_network_os = routeros gather_facts = false $ vi…
-
Install Ansible
Install Ansible on MacOS —————————— $ curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py $ python get-pip.py –user $ python -m pip install –user ansible $ python -m pip install –user paramiko — python 2.7 — $ sudo python get-pip.py $ sudo python -m pip install ansible — python 3.x — $ sudo python3 get-pip.py $ sudo python3 -m…
-
Scripts Backup Databases MySQL
$ sudo vi /root/.my.cnf [client] host=127.0.0.1 user=root password=’yourRootMySQLpassword’ $ sudo vi /etc/scripts/backup_db.sh #!/bin/sh ####### SCRIPTS BACKUP ###### # create : AGINK ############################# tgl=`date “+%Y%m%d-%H%M%S”` home_path=/home/agink backup_path=$home_path/backup/db sqlpass=’yourRootMySQLpassword’ echo “#— Backup processing…!!!” echo “” echo “Database dump…” echo “” DATABASELIST=”$(echo “show databases;” | mysql | grep -vwE “(DATABASE|Database|information_schema|mysql|performance_schema)”)” for database in $DATABASELIST; do …
-
Ubuntu : Install PHP5.6 & PHP7.4
sudo apt-get install software-properties-common sudo add-apt-repository ppa:ondrej/php sudo apt-get update For PHP5.6 sudo apt install php5.6 php5.6-amqp php5.6-bcmath php5.6-bz2 php5.6-cgi php5.6-cli php5.6-common php5.6-curl php5.6-dba php5.6-dev php5.6-enchant php5.6-fpm php5.6-gd php5.6-gearman php5.6-geoip php5.6-gmp php5.6-gnupg php5.6-grpc php5.6-http php5.6-igbinary php5.6-imagick php5.6-imap php5.6-inotify php5.6-interbase php5.6-intl php5.6-json php5.6-ldap php5.6-lua php5.6-lz4 php5.6-mailparse php5.6-mbstring php5.6-mcrypt php5.6-memcache php5.6-memcached php5.6-mongo php5.6-mongodb php5.6-msgpack php5.6-mysql php5.6-mysqlnd-ms php5.6-oauth…
-
Nginx Proxy : Error Code Respon 400 | The plain HTTP request was sent to HTTPS port
Problem : URL is http://domain.com:443/…. protocol http is difference than port Solution : edit nginx vhost like this : upstream domain.com { server 192.168.1.15:8401; } server { if ($host = domain.com) { return 301 https://$host$request_uri; } if ($host = www.domain.com) { return 301 https://$host$request_uri; } …
-
CentOS 7 : /lib64/libstdc++.so.6: version `CXXABI_1.3.8′ not found
$ sudo yum groupinstall “Development Tools” $ sudo yum install glibc-static libstdc+±static $ wget http://ftp.tsukuba.wide.ad.jp/software/gcc/releases/gcc-7.1.0/gcc-7.1.0.tar.bz2 $ tar -xvf gcc-7.1.0.tar.bz2 $ cd gcc-7.1.0/ $ sudo ./contrib/download_prerequisites $ sudo mkdir build $ cd build $ sudo ../configure –enable-checking=release –enable-languages=c,c++ –disable-multilib $ sudo make -j8 $ sudo make install -j8 $ sudo cp /usr/local/lib64/libstdc++.so.6.0.23 /usr/lib64 $ cd /usr/lib64…
-
MySQL – Backup Stored Procedures, Functions & Triggers
Backup database include stored procedures mysqldump -u db_user -p –routines DB_NAME > DB_BACKUP_FILES.sql or mysqldump -u db_user -p -R DB_NAME > DB_BACKUP_FILES.sql Backup only stored procedures mysqldump -u db_user -p –routines –no-create-info –no-data –no-create-db –skip-opt DB_NAME > SP_BACKUP.sql
-
Backup Websites Using Rsync
WEBSERVER PROD (192.168.0.172) ——————————————– $ sudo apt install -y rsync WEBSERVER BACKUP (192.168.0.182) ———————————————– $ sudo apt install -y rsync $ rsync -e ssh -rlpgoDvc [email protected]:/home/agink.id/genose.agink.id/ /home/agink.id/genose.agink.id/ $ ssh-keygen Generating public/private rsa key pair. Enter file in which to save the key (/home/agink.id/genose.agink.id/.ssh/id_rsa): /home/agink.id/genose.agink.id/.ssh/id_rsa already exists. Overwrite (y/n)? y Enter passphrase (empty for no passphrase):…
-
Backup / Export Docker containers to other hosts
Source Host ———– Commit the current container docker commit <name or ID of the container instance> my_container_image Save the container docker save my_container_image | gzip > my_container_image.tar.gz Copy the image and container to the destination host (e.g., cp, scp or rsync). Destination Host —————- Load the container gunzip -c my_container_image.tar.gz | docker load or…