say -v Yuna -o filename.aiff -f filename.txt -r 200 lame filename.aiff filename.mp3 ffmpeg filename.mp3 -i filename.m4a -codec:a libmp3lame -qscale:a 1
CentOS 7 : rpm db error - rebuid Hint
mkdir /var/lib/rpm/out mv /var/lib/rpm/__db* /var/lib/rpm/out yum install ....
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');
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 - - - - - - - - - - - - - - - - - - - […]
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 […]
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 […]
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 […]
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 […]
Fedora 31 : grc tail log edit color config Hint
yum install grc vi /usr/share/grc/conf.log # Error regexp=\bError\b colours=bold red grc tail -f /var/log/messages
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 […]