WP : SSL Hint

.htaccess <ifModule mod_headers.c>     # Header set Access-Control-Allow-Origin: *     #Header add Content-Security-Policy "default-src 'self';"     Header always set Content-Security-Policy "upgrade-insecure-requests;" </ifModule> <IfModule mod_rewrite.c> RewriteEngine On RewriteBase / RewriteCond %{HTTPS} off RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301] </IfModule>   Optional wp-config.php define('FORCE_SSL_ADMIN', true); define('WP_HOME',''.$_SERVER['REQUEST_SCHEME'].'://'.$_SERVER['HTTP_HOST'].'/wordpress'); define('WP_SITEURL',''.$_SERVER['REQUEST_SCHEME'].'://'.$_SERVER['HTTP_HOST'].'/wordpress');  

Read More

open ssl : letsencrypt - certbot Hint

# certbot certonly --webroot -w /home/testdomain/public_html -d www.testdomain.com   Saving debug log to /var/log/letsencrypt/letsencrypt.log Plugins selected: Authenticator webroot, Installer None Enter email address (used for urgent renewal and security notices)  (Enter 'c' to cancel): owl@owl.co.kr   - - - - - - - - - - - - - - - - - - - […]

Read More

mariadb : InnoDB : stop redo and restart Hint

1. InnoDB Stop & MYISAM Start, remove InnoDB redo / tablespace file   vi /etc/my.cnf.d/server.cnf ----------------------- # InnoDB disabled default_storage_engine=MYISAM #default_storage_engine = InnoDB   # remove InnoDB redo #innodb_log_buffer_size          = 4G #innodb_log_file_size            = 4G   # remove InnoDB tablespace  #innodb_data_file_path = ibdata1:12582912;ibdata2:100G;ibdata3:50G:autoextend -----------------------   systemctl restart […]

Read More

Fedora 31 : rsyncd.log logrotate Hint

  vi /etc/logrotate.d/syslog   or vi /etc/logrotate.d/rsyslog    /var/log/cron /var/log/maillog /var/log/messages /var/log/secure /var/log/spooler /var/log/rsyncd.log {        missingok     sharedscripts     postrotate         /usr/bin/systemctl kill -s HUP rsyslog.service >/dev/null 2>&1 || true     endscript }     logrotate --force --verbose /etc/logrotate.conf       vi /etc/cron.daily/logrotate #!/bin/sh   /usr/sbin/logrotate […]

Read More

ERROR 1118 (42000) at line 25: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.   vi /etc/my.cnf.d/server.cnf innodb_strict_mode = OFF   or    > SET GLOBAL innodb_default_row_format='dynamic'; > SET SESSION innodb_strict_mode=OFF; > ALTER TABLE `tablename` ENGINE=InnoDB […]

Read More

Linux : ps memory size human readable Hint!

ps -eo pmem,comm,pid,maj_flt,min_flt,rss,size,vsize,pcpu,time --sort -rss | numfmt --header --to=iec --field 4-5 | numfmt --header --from-unit=1024 --to=iec --field 6-8 | column -t | head -n 20   vi psmem.sh #!/bin/bash ps -eo pmem,comm,pid,maj_flt,min_flt,rss,size,vsize,pcpu,time --sort -rss | numfmt --header --to=iec --field 4-5 | numfmt --header --from-unit=1024 --to=iec --field 6-8 | column -t $@     # psmem.sh […]

Read More

mariadb : dblink Hint

-- 1. create database for dblink create database IF NOT EXISTS dblink1;   -- 2. check dblink for FEDERATED plugin support. show engines; -- FEDERATED -- install plugin federated soname 'ha_federated.so';   -- 3. create server for dblink drop server IF EXISTS dblink1; CREATE SERVER IF NOT EXISTS dblink1  FOREIGN DATA WRAPPER mysql  OPTIONS (USER […]

Read More