SELECT @@SQL_MODE, @@GLOBAL.SQL_MODE; SET @old_sql_mode = @@global.sql_mode; SET sql_mode = ''; SET SQL_MODE = CONCAT(@@SQL_MODE, ',EMPTY_STRING_IS_NULL'); SET SQL_MODE = REPLACE(@@SQL_MODE, 'EMPTY_STRING_IS_NULL', ''); SET sql_mode = @old_sql_mode; /* SET sql_mode = 'ORACLE, EMPTY_STRING_IS_NULL'; PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,EMPTY_STRING_IS_NULL,SIMULTANEOUS_ASSIGNMENT */
bash : prepend string to file
# sed -i '1s;^;SET sql_mode="ORACLE,EMPTY_STRING_IS_NULL"\;\n;' test.sql
Linux : search keyword & delete lines in textfile Hint
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 […]