Forum libero

> > > [mysqld]
> > > key_buffer_size = 256M
> > > join_buffer_size = 8M
> > > max_heap_table_size = 128M
> > > max_connections = 24
> > > log_slow_queries = 1
> > > slow_query_log_file = /var/log/mysql/slow.log
> > > default-time-zone='Europe/Rome'
> > > 

> > > user www-data;
> > > worker_processes  1;
> > > error_log  /var/log/nginx/error.log;
> > > pid        /var/run/nginx.pid;
> > > events {
> > > worker_connections  1024;
> > > }
> > > http {
> > > include       /etc/nginx/mime.types;
> > > log_format fdt_log '$remote_addr [$time_iso8601 $msec] "$request" $status $body_bytes_sent "$http_referer" "$http_user_agent" "$host"';
> > > access_log  /var/log/nginx/access.log fdt_log;
> > > sendfile        on;
> > > keepalive_timeout  30;
> > > tcp_nodelay        on;
> > > gzip  on;
> > > gzip_static on;
> > > 
> > > proxy_cache_path /var/cache/nginx levels=1:2 keys_zone=STATIC:10m inactive=24h max_size=1g;
> > > 
> > > #ratelimiter
> > > map $request_method $is_ip_if_post {
> > > default "";
> > > POST $binary_remote_addr;
> > > }
> > > limit_req_zone $is_ip_if_post zone=postperip:10m rate=3r/m;
> > > 
> > > server {
> > > server_tokens off;
> > > access_log off;
> > > return 404;
> > > }
> > > 
> > > server {
> > > listen 80;
> > > server_name ilblogdiwakko.forumdeitroll.com;
> > > server_tokens off;
> > > location / {
> > > root /var/ilblogdiwakko/webroot;
> > > index index.html index.htm index.php;
> > > }
> > > location ~ \.php$ {
> > > root /var/ilblogdiwakko/webroot;
> > > fastcgi_split_path_info ^(.+\.php)(/.+)$;
> > > fastcgi_pass unix:/var/run/php5-fpm.sock;
> > > fastcgi_index index.php;
> > > include fastcgi_params;
> > > fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
> > > }
> > > }
> > > 
> > > server {
> > > listen 80;
> > > server_name ilblogdiyoda.forumdeitroll.com;
> > > server_tokens off;
> > > location / {
> > > root /var/ilblogdiyoda/webroot;
> > > index index.html index.htm index.php;
> > > }
> > > location ~ \.php$ {
> > > root /var/ilblogdiyoda/webroot;
> > > fastcgi_split_path_info ^(.+\.php)(/.+)$;
> > > fastcgi_pass unix:/var/run/php5-fpm.sock;
> > > fastcgi_index index.php;
> > > include fastcgi_params;
> > > fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
> > > }
> > > }
> > > 
> > > # il segretissimo blog di avve l'ho escluso da questa conf, è uguale a quelle degli altri due blog
> > > 
> > > server {
> > > listen 80;
> > > server_name www.forumdeitroll.com;
> > > server_tokens off;
> > > location / {
> > > root /var/www/no-www;
> > > rewrite ^ /index.html break;
> > > }
> > > }
> > > server {
> > > listen 80;
> > > listen 443 default_server ssl;
> > > 
> > > # 2015-03-28 achille: nuova conf ssl
> > > ssl_certificate /etc/nginx/keys/webserver.crt;
> > > ssl_certificate_key /etc/nginx/keys/webserver.key;
> > > ssl_ciphers AES256+EECDH:AES256+EDH;
> > > ssl_prefer_server_ciphers on;
> > > ssl_protocols TLSv1 TLSv1.1 TLSv1.2;
> > > ssl_dhparam /etc/nginx/keys/dhparam.pem;
> > > ssl_session_timeout 2m;
> > > ssl_session_cache shared:SSL:10m;
> > > resolver 8.8.4.4 8.8.8.8 valid=300s;
> > > resolver_timeout 5s;
> > > add_header X-Content-Type-Options nosniff;
> > > 
> > > server_name forumdeitroll.com;
> > > server_tokens off;
> > > add_header Server proott;
> > > if ( $uri ~ ^/FdTViewer/ ) {
> > > rewrite ^/FdTViewer(/.*)$ http://forumdeitroll.com$1 permanent;
> > > }
> > > # /opt/rrd/rrd_nginx.pl
> > > location /status {
> > > stub_status on;
> > > access_log off;
> > > }
> > > # legacy (/ps/abpi/)
> > > location /ps/ {
> > > rewrite ^/ps/(.*)?$ /punto/$1 permanent;
> > > }
> > > location /feed/fdt.pl {
> > > return 410;
> > > }
> > > # tomcat web admin
> > > location /manager/ {
> > > auth_basic "secured manager";
> > > auth_basic_user_file htpasswd;
> > > proxy_pass http://127.0.0.1:8080/manager/;
> > > }
> > > location /punto/ {
> > > root /var/www;
> > > index index.htm index.html index.php;
> > > }
> > > location / {
> > > root /var;
> > > expires 24h;
> > > try_files
> > > /www$uri
> > > /www$uri/index.htm
> > > /www$uri/index.html
> > > /lib/tomcat8/webapps/FdTViewer$uri
> > > /pathNascosto$request_uri;
> > > }
> > > location /pathNascosto/ {
> > > internal;
> > > proxy_pass http://127.0.0.1:8080/FdTViewer/;
> > > proxy_set_header X-Forwarded-For $remote_addr;
> > > gzip_proxied any;
> > > limit_req zone=postperip burst=1 nodelay;
> > > }
> > > location /Minichat {
> > > proxy_pass http://127.0.0.1:8080/FdTViewer/Minichat;
> > > proxy_set_header X-Forwarded-For $remote_addr;
> > > gzip_proxied any;
> > > }
> > > location /motorino/ {
> > > proxy_pass http://127.0.0.1:8080/motorino/;
> > > }
> > > location /mobile/ {
> > > rewrite ^(.*)$ / permanent;
> > > }
> > > location /backups/pirescue/ {
> > > root /var/www;
> > > autoindex on;
> > > }
> > > location /Tappeto {
> > > proxy_hide_header Set-Cookie;
> > > proxy_ignore_headers Set-Cookie;
> > > proxy_set_header Cookie "";
> > > proxy_pass http://127.0.0.1:8080/FdTViewer/Tappeto;
> > > proxy_set_header X-Forwarded-For $remote_addr;
> > > proxy_cache STATIC;
> > > proxy_cache_valid 200 1d;
> > > gzip_proxied any;
> > > }
> > > }
> > > }
> > > 

> > > <Service name="Catalina">
> > > [...]
> > > <Connector port="8080" protocol="HTTP/1.1"
> > > connectionTimeout="20000"
> > > URIEncoding="UTF-8"
> > > redirectPort="8443" />
> > > 

> > > 00 00 * * * root /opt/fdt/histodata
> > > 00 05 * * * root /opt/fdt/digest
> > > 05 04 * * * root /opt/fdt/fdt_script_executor
> > > 00 03     * * * root find /tmp -maxdepth 1 -iname '*.session' -type f -mtime +7 -delete
> > > * *     * * *   root    /opt/rrd/rrd_all.sh >/dev/null 2>&1
> > > 05 03 * * * root sh -c 'systemctl stop tomcat8; /backup-fdt/backup-fdt.zsh; systemctl start tomcat8; curl -s http://localhost:8080/FdTViewer/JSon\?action=getForums'
> > > 

> > > #!/bin/sh
> > > git daemon --base-path=/src --detach --syslog --export-all
> > > 

> > > #!/bin/sh
> > > cd /src/FdtDueZero.git
> > > git instaweb -d webrick -p 3001 -b /bin/true
> > > 

> > > select threadId, id, match(subject, text) against (? in natural language mode) as relevance
> > > from messages
> > > where relevance
> > > having relevance > 0.1
> > > 

> > > insert into threads
> > > select threadId, max(id)
> > > from messages
> > > where not exists (
> > > select threadId
> > > from threads
> > > )
> > > group by threadId
> > > ;
> > > 

> > > select a.*, sysinfo.value,
> > > concat('update sysinfo set value = ', v, ' where `key` = ''', k,'''') as u
> > > from (
> > > select concat('messages.forum.', coalesce(forum, '')) as k, count(id) as v
> > > from messages
> > > group by forum
> > > ) as a join sysinfo
> > > on k = `key`
> > > and v <> sysinfo.value
> > > ;
> > > 
> > > select a.*, sysinfo.value,
> > > concat('update sysinfo set value = ', v, ' where `key` = ''', k,'''') as u
> > > from (
> > > select concat('threads.forum.', coalesce(forum, '')) as k, count(threadId) as v
> > > from (
> > > select threadId, forum
> > > from messages
> > > group by threadId, forum
> > > ) as b
> > > group by forum
> > > ) as a join sysinfo
> > > on k = `key`
> > > and v <> sysinfo.value
> > > ;
> > > 
> > > select a.*, sysinfo.value,
> > > concat('update sysinfo set value = ', v, ' where `key` = ''', k,'''') as u
> > > from (
> > > select 'messages.total' as k, count(id) as v
> > > from messages
> > > ) as a join sysinfo
> > > on k = `key`
> > > and v <> sysinfo.value
> > > ;
> > > 
> > > select a.*, sysinfo.value,
> > > concat('update sysinfo set value = ', v, ' where `key` = ''', k,'''') as u
> > > from (
> > > select 'threads.total' as k, count(threadId) as v
> > > from (
> > > select threadId
> > > from messages
> > > group by threadId
> > > ) as b
> > > ) as a join sysinfo
> > > on k = `key`
> > > and v <> sysinfo.value
> > > ;
> > > 

> > > mysql -e "select text from messages where id = $1" -ufdtsucker -pfdtsucker -Dfdtsucker | tail -c+6 | xxd
> > > 

> > > #!/usr/bin/env sh
> > > curl https://wordpress.org/news/category/releases/feed/ | grep '<title>'
> > > find /var/ilblogdiwakko /var/ilblogdiyoda [redacted] -type f -name version.php | \
> > > xargs grep wp_version
> > > 

> > > #!/bin/sh
> > > set -x
> > > cd repo/FdtDueZero-rebuild
> > > git pull
> > > cd FdTViewer
> > > ant fetch-deps
> > > ant
> > > cp /var/lib/tomcat8/webapps/FdTViewer.war ~/backup.war
> > > mv ~/repo/FdtDueZero-rebuild/FdTViewer/FdTViewer.war ~/FdTViewer.war
> > > 

> > > #!/bin/zsh
> > > 
> > > cd /backup-fdt
> > > GG=$(date +%u)
> > > MESSAGESFILE=dump-messages-$GG.sql.xz
> > > SQLFILE=dump-fdtsucker-$GG.sql.xz
> > > ZIPFILE=full-backup-$GG.zip
> > > 
> > > rm -f $MESSAGESFILE
> > > rm -f $SQLFILE
> > > mysqldump -ufdtsucker -pfdtsucker fdtsucker messages | xz -c > $MESSAGESFILE
> > > mysqldump -ufdtsucker -pfdtsucker fdtsucker --ignore-table=fdtsucker.messages | xz -c > $SQLFILE
> > > chown root:adm $MESSAGESFILE
> > > chown root:adm $SQLFILE
> > > chmod a+r /backup-fdt/$MESSAGESFILE
> > > ln -sf /backup-fdt/$MESSAGESFILE /var/www/backups/latest.sql.xz
> > > 
> > > rm -f $ZIPFILE
> > > zip $ZIPFILE /var/log/nginx/* /var/log/tomcat8/* /tmp/fdt_user_profiles /opt/fdt/*
> > > chown root:adm $ZIPFILE
> > >