sintret

https://www.faqforge.com/linux/how-to-renew-the-ispconfig-3-ssl-certificate/
cd /tmp
wget http://www.ispconfig.org/downloads/ISPConfig-3-stable.tar.gz
tar xvfz ISPConfig-3-stable.tar.gz
cd ispconfig3_install/install
php -q update.php

//START//

This is for ispconfig for debian 9

sintret

# Example MariaDB config file for large systems.
#
# This is for a large system with memory = 512M where the system runs mainly
# MariaDB.
#
# MariaDB programs look for option files in a set of
# locations which depend on the deployment platform.
# You can copy this option file to one of those
# locations. For information about these locations, do:
# 'my_print_defaults --help' and see what is printed under

sintret

CONNECT TO PIPELINE BITBUCKET
-------------------

      Go to settings then click SSH Keys then generate
      Copy your ssh-rsa then
      input your domain and fetch


LINUX COMMAND

sintret

https://www.vultr.com/docs/installing-netdata-on-debian-9

sudo apt-get install zlib1g-dev uuid-dev libmnl-dev gcc make git autoconf autoconf-archive autogen automake pkg-config curl

cd ~
git clone https://github.com/firehol/netdata.git --depth=1
cd netdata
./netdata-installer.sh

sintret

Multiple PHP
http://hanangpriambodo.com/2019/04/05/install-multiple-php-di-centos-7/


https://www.cyberciti.biz/faq/howto-install-setup-nginx-on-debian-linux-9/


https://www.howtoforge.com/tutorial/how-to-install-nginx-with-php-and-mysql-lemp-on-debian-9/

sintret

SELECT a.phone, b.phone, a.companyId , b.companyId , a.id,b.id
FROM member a, member b
WHERE a.phone = b.phone 
AND a.companyId = b.companyId
AND a.id <> b.id


SELECT phone, COUNT(*) c FROM member GROUP BY phone HAVING c > 1;

SELECT GROUP_CONCAT(companyId), phone, COUNT(*) c FROM member GROUP BY phone HAVING c > 1;

sintret

delete all folder in windows
rd /s /q "path"


pass wifi win 8/10

netsh wlan show profiles
netsh wlan show profile name=INJANI24G key=clear

sintret

wget -p -k http://www.example.com/

sintret

date
echo 'Asia/Jakarta' | tee /etc/timezone
dpkg-reconfigure -f noninteractive tzdata
dpkg-reconfigure tzdata




centos

sintret

netstat -tpln
kill -9 PID