rslonik

for site in `ee site list | grep -v example.com | sort | sed 's/\x1B\[[0-9;]*[JKmsu]//g'`
do
	echo $site
	#scp host:file.txt /var/www/$site/htdocs/
done

rslonik

update wp_mailster_subscribers set email = replace(email, '.comm', '.com');
update wp_mailster_subscribers set email = replace(email, '.combr', '.com.br');
update wp_mailster_subscribers set email = replace(email, 'gmail.com.br', 'gmail.com');
update wp_mailster_subscribers set email = replace(email, 'gamil.com', 'gmail.com');
update wp_mailster_subscribers set email = replace(email, 'hotmal.com', 'hotmail.com');
update wp_mailster_subscribers set email = replace(email, 'homail.com', 'hotmail.com');

rslonik

ERROR 1709 (HY000) at line 59: Index column size too large. The maximum column size is 767 bytes.

SET GLOBAL innodb_file_format = Barracuda;
SET GLOBAL innodb_large_prefix=on;
SET GLOBAL innodb_default_row_format = dynamic;

rslonik

if ($request_uri ~* "onesignal") {
  set $skip_cache 0;
}

rslonik

vim /usr/lib/tmpfiles.d/sshd.conf
# remove the "/var"
d /run/sshd 0755 root root
systemd-tmpfiles --create

now the dir will be created at boot and ssh will show up

-------
https://serverfault.com/questions/941855/why-am-i-missing-var-run-sshd-after-every-boot
-------

rslonik

How to install php7.2-fpm with EasyEngine (Ubuntu)

---

Add php7.2 repository

sudo add-apt-repository ppa:ondrej/php
sudo apt-get update

Install php7.2-fpm

rslonik

nginx -V Precisa ter o módulo --with-http_geoip_module instalado.

mkdir /etc/nginx/geoip cd /etc/nginx/geoip

Baixar a base GeoIP em CSV e converter pra DAT https://dev.maxmind.com/geoip/geoip2/geolite2/ wget https://geolite.maxmind.com/download/geoip/database/GeoLite2-Country-CSV.zip

rslonik

SELECT
	wp_posts.post_title AS Product,
	wp_postmeta1.meta_value AS SKU,
	wp_postmeta2.meta_value AS Price,
	GROUP_CONCAT( wp_terms.name ORDER BY wp_terms.name SEPARATOR ', ' ) AS ProductCategories
FROM wp_posts
LEFT JOIN wp_postmeta wp_postmeta1
	ON wp_postmeta1.post_id = wp_posts.ID
	AND wp_postmeta1.meta_key = '_sku'
LEFT JOIN wp_postmeta wp_postmeta2

rslonik

/var/www/site.com/conf/nginx/ssl.conf
https://gist.github.com/kiki67100/f5b421ddac9d500297b0e6471e5ef737

ssl_protocols TLSv1 TLSv1.1 TLSv1.2;
ssl_ciphers EECDH+CHACHA20:EECDH+AES128:RSA+AES128:EECDH+AES256:RSA+AES256:EECDH+3DES:RSA+3DES:!MD5;
ssl_prefer_server_ciphers on;

rslonik

# Video Name - without spaces
name: "HomeVideoStories"                                                                                                                                                  

# Square image 40x40
watermark: "https://videostories.co/wp-content/uploads/2017/03/videostories-40-allwhite.png"

# Any size up to 500x500
logo: "https://videostories.co/wp-content/uploads/2017/03/videostories-allwhite.png"

# Used in the ending background