bykvaadm

Скрипт не претендует на истину первой инстанции

Да, я знаю что есть способ ${the_best_pg_backup_method}

Это просто скрипт которым я поделился - хочешь пользуйся, не хочешь - иди мимо

jeffjohnson9046

-- Accepted answer from here: https://stackoverflow.com/questions/5408156/how-to-drop-a-postgresql-database-if-there-are-active-connections-to-it
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = '[your database name goes here]'
  AND pid <> pg_backend_pid();

cosmomathieu

Upgrade MySQL 5.5 to 5.7 Ubuntu 16

First of all , Backup All your Database.

mysqldump --all-databases > all_databases.sql

Grab the library which contains the 5.7 verson

wget https://dev.mysql.com/get/mysql-apt-config_0.8.9-1_all.deb

pyToshka

#!/bin/bash
#step 1 add group groupadd sftp_users
#step 2 run script chmod +x create_sftp_chroot && ./create_sftp_chroot test 
NEW_USER=$1
useradd -G sftp_users -s /sbin/nologin $NEW_USER
passwd $NEW_USER 
mkdir -p /home/$NEW_USER/files
chown root:root /home/$NEW_USER
chown $NEW_USER:$NEW_USER /home/$NEW_USER/files
chmod 700 /home/$NEW_USER/files

dpalomar

# base requirements
sudo apt-get update
sudo apt-get install -y software-properties-common
sudo apt-get install -y python-setuptools python-dev libffi-dev libssl-dev git sshpass tree
sudo easy_install pip
sudo -H pip install cryptography

# sudo -H pip install ansible==2.1.1.0 if you don't need virtualenv

# virtualenv

frosit

Finding infected files with following bash commands

** Command to list all infected files:

• grep -lr --include=*.php "eval(base64_decode" /path/to/webroot
• grep -lr --include=*.php "eval" .
• grep -lr --include=*.php "base64" .

Command to remove malicious code:

• grep -lr --include=*.php "eval(base64_decode" /path/to/webroot | xargs sed -i.bak 's/<?php eval(base64_decode[^;]*;/<?php\n/g'

johanndt

TL;DR

Install Postgres 9.5, and then:

sudo pg_dropcluster 9.5 main --stop
sudo pg_upgradecluster 9.3 main
sudo pg_dropcluster 9.3 main

frugan-dev

<VirtualHost *>
  ServerName auth.dev
  DocumentRoot "/var/www/auth"
  ProxyPassMatch ^(/.*\.php)$ fcgi://127.0.0.1:9000/var/www/auth
  SetEnvIf Authorization "(.*)" HTTP_AUTHORIZATION=$1
</VirtualHost>

joshua

For PPTP:
  IP Protocol=TCP, TCP Port number=1723   <- Used by PPTP control path
  IP Protocol=GRE (value 47)              <- Used by PPTP data path

For L2TP:
  IP Protocol Type=UDP, UDP Port Number=500    <- Used by IKEv1 (IPSec control path)
  IP Protocol Type=UDP, UDP Port Number=4500   <- Used by IKEv1 (IPSec control path)
  IP Protocol Type=ESP (value 50)              <- Used by IPSec data path

For SSTP:

diproart

# bitrix virtual host
# @version 1.0.1
server {

  set $id user;
  set $domain server.com;
  set $folder default;
  set $socket unix:/var/run/php5-bx-fpm.sock;
  
  charset utf-8;