sed -i_bak -e '/key_word/d' ./test.log
Linux : process kill by name Hint pkill -f
# ps aux | grep testd # pkill -f testd
mariadb : sys_exec : trigger call shell command Hint
# yum install mariadb-devel # cd # wget https://github.com/mysqludf/lib_mysqludf_sys/archive/master.zip # mv master.zip lib_mysqludf_sys-master.zip # unzip lib_mysqludf_sys-master.zip # mv lib_mysqludf_sys-master /usr/include/mysql/ # cd /usr/include/mysql/lib_mysqludf_sys-master/ # gcc -m64 -fPIC -Wall -I/usr/include/mysql/server -I. -I/usr/include/mysql/server/private -shared lib_mysqludf_sys.c -o /usr/lib64/mariadb/plugin/lib_mysqludf_sys.so # ll /usr/lib64/mariadb/plugin/lib_mysqludf_sys.so cat /usr/include/mysql/lib_mysqludf_sys-master/lib_mysqludf_sys.sql DROP FUNCTION IF EXISTS lib_mysqludf_sys_info; DROP FUNCTION IF EXISTS sys_get; DROP FUNCTION IF […]
oracle 11g : sga memory setup Hint
SQL> show sga ; Total System Global Area 6547296256 bytes Fixed Size 2213856 bytes Variable Size 4429187104 bytes Database Buffers 2013265920 bytes Redo Buffers 102629376 bytes SQL> show PARAMETERs memory ; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ hi_shared_memory_address integer 0 memory_max_target big integer 6272M […]
oracle : dblink limit, open_links Hint
SELECT name, VALUE FROM v$parameter WHERE name = 'open_links'; ALTER SYSTEM SET open_links = 50 SCOPE = spfile; COMMIT; systemctl restart oracle.service
php7 : session_id() before session_start() Hint
ini_set('session.use_strict_mode', 0); // php.ini default ini_set('session.use_trans_sid', 0); ini_set('session.use_cookies', 1); ini_set('session.use_only_cookies', 1); ini_set('session.hash_function', 1); ini_set('session.hash_bits_per_character', 4); session_id($_REQUEST["browser_sesid"]); session_start();
Fedora 31 : set timedatectl Hint
timedatectl list-timezones | grep Seoul Asia/Seoul timedatectl set-timezone Asia/Seoul
Fedora : server port scanner Hint
# nmap -sT test.com Starting Nmap 7.80 ( https://nmap.org ) .... Nmap scan report for test.com.... Host is up (0.013s latency). Not shown: 993 filtered ports PORT STATE SERVICE 22/tcp open ssh 80/tcp open http 8080/tcp closed http-proxy Nmap done: 1 IP address (1 host up) scanned in 6.04 […]
windows 10 : remote desktop reboot command Hint
shutdown /r /t 0
mariadb-10.x : sql-mode Hint - Error 1366 - Incorrect double value: '' for column
vi /etc/my.cnf.d/mariadb-server.cnf sql-mode="" #sal_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION #sal_mode="ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"