sed -i_bak -e '/key_word/d' ./test.log
Linux : process kill by name Hint pkill -f
# ps aux | grep testd # pkill -f testd
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
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 […]
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"
php-fpm : display_error config Hint
Client Browser Display Error Config vi /etc/opt/remi/php56/php.ini display_errors = Off ;display_errors = On ;log_errors = On log_errors = Off ;html_errors = On html_errors = Off Sever Error Log Config vi /etc/opt/remi/php56/php-fpm.conf ;log_level = notice log_level = error vi /etc/opt/remi/php56/php-fpm.d/www.conf php_admin_value[error_log] = /var/opt/remi/php56/log/php-fpm/www-error.log php_admin_flag[log_errors] = on
Fedora 31 / CentOS 8 : php7x + remi-php56(+oci8, 11g) Multiple version Hint - Thanks Remi
https://rpms.remirepo.net/wizard/ --------------------------------------------------- dnf install https://rpms.remirepo.net/fedora/remi-release-31.rpm dnf --enablerepo=remi install php56 dnf --enablerepo=remi install php56-php-* --skip-broken dnf --enablerepo=remi-test install php56-php-xxx php56 --version php56 --modules --------------------------------------------------- yum install php56-php php56-php-common php56-php-cli php56-php-dba php56-php-pecl-apcu php56-php-pear php56-php-pgsql php56-php-soap php56-php-intl php56-php-gd php56-php-ldap php56-php-mysqlnd php56-php-xmlrpc php56-php-process php56-php-recode php56-php-odbc php56-php-snmp php56-php-bcmath php56-php-embedded php56-php-mbstring php56-php-devel php56-php-pecl-memcache #oci8 would be better customize and match with […]
Fedora 31 : php memcached Install Hint
yum install memcached systemctl enable memcached.service systemctl start memcached.service systemctl status memcached.service echo "stats settings" | nc localhost 11211 yum install php-pecl-memcache yum install php-pecl-memcached --------------------------------------------------- if Error memcached[185446]: failed to listen on TCP port 11211: Cannot assign request --------------------------------------------------- vi /etc/sysconfig/memcached #OPTIONS="-l 127.0.0.1,::1" OPTIONS="-l 127.0.0.1"