Архив автора: zeka

Установка PHP разных версий на Debian stretch

wget -q https://packages.sury.org/php/apt.gpg -O- | sudo apt-key add -

1	wget -q https://packages.sury.org/php/apt.gpg -O- \| sudo apt-key add -

echo "deb https://packages.sury.org/php/ stretch main" | sudo tee /etc/apt/sources.list.d/php.list

1	echo "deb https://packages.sury.org/php/ stretch main" \| sudo tee /etc/apt/sources.list.d/php.list

apt install  php7.0 php7.0-bcmath php7.0-bz2 php7.0-cli php7.0-curl php7.0-dba php7.0-enchant php7.0-gd php7.0-gmp php7.0-imap php7.0-interbase php7.0-intl php7.0-json php7.0-mbstring php7.0-mcrypt php7.0-mysql php7.0-odbc php7.0-opcache php7.0-pgsql php7.0-phpdbg php7.0-pspell php7.0-readline php7.0-recode php7.0-snmp php7.0-soap php7.0-sqlite3 php7.0-xml php7.0-zip

apt install php7.0 php7.0-bcmath php7.0-bz2 php7.0-cli php7.0-curl php7.0-dba php7.0-enchant php7.0-gd php7.0-gmp php7.0-imap php7.0-interbase php7.0-intl php7.0-json php7.0-mbstring php7.0-mcrypt php7.0-mysql php7.0-odbc php7.0-opcache php7.0-pgsql php7.0-phpdbg php7.0-pspell php7.0-readline php7.0-recode php7.0-snmp php7.0-soap php7.0-sqlite3 php7.0-xml php7.0-zip

apt install  php7.1 php7.1-bcmath php7.1-bz2 php7.1-cli php7.1-curl php7.1-dba php7.1-enchant php7.1-gd php7.1-gmp php7.1-imap php7.1-interbase php7.1-intl php7.1-json php7.1-mbstring php7.1-mcrypt php7.1-mysql php7.1-odbc php7.1-opcache php7.1-pgsql php7.1-phpdbg php7.1-pspell php7.1-readline php7.1-recode php7.1-snmp php7.1-soap php7.1-sqlite3 php7.1-xml php7.1-zip

apt install php7.1 php7.1-bcmath php7.1-bz2 php7.1-cli php7.1-curl php7.1-dba php7.1-enchant php7.1-gd php7.1-gmp php7.1-imap php7.1-interbase php7.1-intl php7.1-json php7.1-mbstring php7.1-mcrypt php7.1-mysql php7.1-odbc php7.1-opcache php7.1-pgsql php7.1-phpdbg php7.1-pspell php7.1-readline php7.1-recode php7.1-snmp php7.1-soap php7.1-sqlite3 php7.1-xml php7.1-zip

apt install  php7.2 php7.2-bcmath php7.2-bz2 php7.2-cli php7.2-curl php7.2-dba php7.2-enchant php7.2-gd php7.2-gmp php7.2-imap php7.2-interbase php7.2-intl php7.2-json php7.2-mbstring php7.2-mysql php7.2-odbc php7.2-opcache php7.2-pgsql php7.2-phpdbg php7.2-pspell php7.2-readline php7.2-recode php7.2-snmp php7.2-soap php7.2-sqlite3 php7.2-xml php7.2-zip

apt install php7.2 php7.2-bcmath php7.2-bz2 php7.2-cli php7.2-curl php7.2-dba php7.2-enchant php7.2-gd php7.2-gmp php7.2-imap php7.2-interbase php7.2-intl php7.2-json php7.2-mbstring php7.2-mysql php7.2-odbc php7.2-opcache php7.2-pgsql php7.2-phpdbg php7.2-pspell php7.2-readline php7.2-recode php7.2-snmp php7.2-soap php7.2-sqlite3 php7.2-xml php7.2-zip

OpenVZ Dashboard

Недавно перешёл на OpenVZ 7. WEB-панель ставить не хотелось, а какой-то dashboard всё же нужен… У меня мало опыта в написании bash скриптов, но решил «по быстрому» что-то наваять… Вот что получилось…

#/bin/bash

# функция, предотвращающая участия строки заголовков таблицы в сортировке
body() {
    IFS= read -r header
    printf '%s\n' "$header"
    "$@"
}

df -h > df_tmp # свободное место на дисках виртуалок
printf 'NAME\tHOSTNAME\tTMPL\tTYPE\tIP\tMEMORY\tSTATE\tOS\tSIZE\tUSED\tAVAIL\tAVAIL(%%)\n' >> tmp # заголовки таблицы

array=(/vz/root/*/) # директории виртуалок

for dir in "${array[@]}"; 
do 
	bs=$(basename $dir) # ID виртуалки
	prlctl list -i "$bs" > ct_tmp
	sed -i '1D' ct_tmp
	sed -i '/^$/d' ct_tmp
	sed -i 's/[^.]*: //g' ct_tmp
	df=($(df -h | grep "$bs" | awk '{print $2,$3,$4,$5}'))
	mapfile -t line < ct_tmp
	ip=$(echo -r "${line[27]}" | grep -oE "\b([0-9]{1,3}\.){3}[0-9]{1,3}/\b" | sed 's/\///g')
	memory=$(echo "${line[23]}" | grep -oE "\b[0-9]{1,4}Mb\b")
	printf '%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\n' "${line[2]}" "${line[36]}" "${line[7]}" "${line[4]}" "${ip}" "${memory}" "${line[5]}" "${line[6]}" "${df[0]}" "${df[1]}" "${df[2]}" "${df[3]}" >> tmp
done

cat tmp | column -t -s $'\t' | body sort -k3 -k5

rm -f tmp ct_tmp df_tmp

#/bin/bash

# функция, предотвращающая участия строки заголовков таблицы в сортировке

body() {

IFS= read -r header

printf '%s\n' "$header"

"$@"

}

df -h > df_tmp # свободное место на дисках виртуалок

printf 'NAME\tHOSTNAME\tTMPL\tTYPE\tIP\tMEMORY\tSTATE\tOS\tSIZE\tUSED\tAVAIL\tAVAIL(%%)\n' >> tmp # заголовки таблицы

array=(/vz/root/*/) # директории виртуалок

for dir in "${array[@]}";

bs=$(basename $dir) # ID виртуалки

prlctl list -i "$bs" > ct_tmp

sed -i '1D' ct_tmp

sed -i '/^$/d' ct_tmp

sed -i 's/[^.]*: //g' ct_tmp

df=($(df -h | grep "$bs" | awk '{print $2,$3,$4,$5}'))

mapfile -t line < ct_tmp

ip=$(echo -r "${line[27]}" | grep -oE "\b([0-9]{1,3}\.){3}[0-9]{1,3}/\b" | sed 's/\///g')

memory=$(echo "${line[23]}" | grep -oE "\b[0-9]{1,4}Mb\b")

printf '%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\n' "${line[2]}" "${line[36]}" "${line[7]}" "${line[4]}" "${ip}" "${memory}" "${line[5]}" "${line[6]}" "${df[0]}" "${df[1]}" "${df[2]}" "${df[3]}" >> tmp

done

cat tmp | column -t -s $'\t' | body sort -k3 -k5

rm -f tmp ct_tmp df_tmp

Скрипт в результате выводит что-то типа

NAME            HOSTNAME              TMPL  TYPE  IP            MEMORY  STATE    OS       SIZE  USED  AVAIL  AVAIL(%)
102             openVPN.zk            no    CT    10.33.33.102  4096Mb  running  centos7  4,9G  759M  3,9G   17%
103             nginx-proxy.zk        no    CT    10.33.33.103  4096Mb  running  centos7  4,9G  998M  3,7G   22%
110             mysql-prod.zk         no    CT    10.33.33.110  8192Mb  running  centos7  15G   1,8G  13G    13%
112             postgresql.zk         no    CT    10.33.33.112  8192Mb  running  centos7  15G   836M  14G    6%
130             zeka-kiev-ua.zk       no    CT    10.33.33.130  4096Mb  running  centos7  4,9G  1,1G  3,6G   24%
131             real-english.zk       no    CT    10.33.33.131  8192Mb  running  centos7  15G   1,8G  13G    13%
140             php-7-1-nginx-fpm.zk  no    CT    10.33.33.140  8192Mb  running  centos7  15G   2,8G  12G    20%
clean-template  clean-template.zk     yes   CT                  4096Mb  stopped  centos7

NAME HOSTNAME TMPL TYPE IP MEMORY STATE OS SIZE USED AVAIL AVAIL(%)

102 openVPN.zk no CT 10.33.33.102 4096Mb running centos7 4,9G 759M 3,9G 17%

103 nginx-proxy.zk no CT 10.33.33.103 4096Mb running centos7 4,9G 998M 3,7G 22%

110 mysql-prod.zk no CT 10.33.33.110 8192Mb running centos7 15G 1,8G 13G 13%

112 postgresql.zk no CT 10.33.33.112 8192Mb running centos7 15G 836M 14G 6%

130 zeka-kiev-ua.zk no CT 10.33.33.130 4096Mb running centos7 4,9G 1,1G 3,6G 24%

131 real-english.zk no CT 10.33.33.131 8192Mb running centos7 15G 1,8G 13G 13%

140 php-7-1-nginx-fpm.zk no CT 10.33.33.140 8192Mb running centos7 15G 2,8G 12G 20%

clean-template clean-template.zk yes CT 4096Mb stopped centos7

Настройка получения и автопродления SSL сертификата Let’s Encrypt с Nginx на CentOS 7

Уже всем известно, что Let’s Encrypt позволяет получить бесплатный SSL-сертификат на https://letsencrypt.org. Здесь я опишу, как его получить и настроить на сервере под управлением CentOS 7 и Nginx. Необходимое ПО:

sudo yum install git bc

1	sudo yum install git bc

Клонируем:

sudo git clone https://github.com/letsencrypt/letsencrypt /opt/letsencrypt

1	sudo git clone https://github.com/letsencrypt/letsencrypt /opt/letsencrypt

Генерация сертификатов:

cd /opt/letsencrypt
./letsencrypt-auto certonly -a webroot --webroot-path=/path_to_root_web -d example.com -d www.example.com

1 2	cd /opt/letsencrypt ./letsencrypt-auto certonly -a webroot --webroot-path=/path_to_root_web -d example.com -d www.example.com

В результате успешного выполнения мы видим, куда сохранились созданные сертификаты /etc/letsencrypt/live/example.com/ и дату истечения действия сертификата. В целях повышения… Читать далее »

Выбрать определённую строку из файла

sed -n '2343p' filename

1	sed -n '2343p' filename

где 2343 — искомая строка Несколько строк (с 5840 по 5854):

sed -n '5840,5854p;5855q' filename

1	sed -n '5840,5854p;5855q' filename

SQL бекап gzip

Создание и восстановление заархивированного дампа SQL MySQL

mysqldump -u USER -p DATABASE | gzip > /path/to/outputfile.sql.gz
gunzip < /path/to/outputfile.sql.gz | mysql -h localhost -u USER -p DATABASE

1 2	mysqldump -u USER -p DATABASE \| gzip > /path/to/outputfile.sql.gz gunzip < /path/to/outputfile.sql.gz \| mysql -h localhost -u USER -p DATABASE

PostgreSQL

pg_dump DATABASE | gzip >/path/to/outputfile.sql.gz
gunzip < /path/to/outputfile.sql.gz | psql -h localhost DATABASE

1 2	pg_dump DATABASE \| gzip >/path/to/outputfile.sql.gz gunzip < /path/to/outputfile.sql.gz \| psql -h localhost DATABASE

Виртуализация на основе OpenVZ + OpenVPN

В данном руководстве будет рассмотрена настройка выделенного сервера с виртуализацией на основе OpenVZ. Доступ к контейнерам извне будет возможен посредством OpenVPN Итак: ОС — Centos 6.7, IP сервера — 1.2.3.4, внутренняя сеть 10.55.0.0/24 Установка

wget -P /etc/yum.repos.d/ https://ftp.openvz.org/openvz.repo

rpm --import https://ftp.openvz.org/RPM-GPG-Key-OpenVZ

yum install vzkernel1

wget -P /etc/yum.repos.d/ https://ftp.openvz.org/openvz.repo

rpm --import https://ftp.openvz.org/RPM-GPG-Key-OpenVZ

yum install vzkernel1

/etc/sysctl.conf

# On Hardware Node we generally need
# packet forwarding enabled and proxy arp disabled
net.ipv4.ip_forward = 1
net.ipv6.conf.default.forwarding = 1
net.ipv6.conf.all.forwarding = 1
net.ipv4.conf.default.proxy_arp = 0

# Enables source route verification
net.ipv4.conf.all.rp_filter = 1

# Enables the magic-sysrq key
kernel.sysrq = 1

# We do not want all our interfaces to send redirects
net.ipv4.conf.default.send_redirects = 1
net.ipv4.conf.all.send_redirects = 0

# On Hardware Node we generally need

# packet forwarding enabled and proxy arp disabled

net.ipv4.ip_forward = 1

net.ipv6.conf.default.forwarding = 1

net.ipv6.conf.all.forwarding = 1

net.ipv4.conf.default.proxy_arp = 0

# Enables source route verification

net.ipv4.conf.all.rp_filter = 1

# Enables the magic-sysrq key

kernel.sysrq = 1

# We do not want all our interfaces to send redirects

net.ipv4.conf.default.send_redirects = 1

net.ipv4.conf.all.send_redirects = 0

vim /etc/modprobe.d/openvz.conf

options nf_conntrack ip_conntrack_disable_ve0=0

1	options nf_conntrack ip_conntrack_disable_ve0=0

SELinux

echo "SELINUX=disabled" > /etc/sysconfig/selinux

1	echo "SELINUX=disabled" > /etc/sysconfig/selinux

yum install vzctl vzquota ploop

1	yum install vzctl vzquota ploop

iptables

yum install iptables-services -y
systemctl mask firewalld
systemctl enable iptables
systemctl stop firewalld
systemctl start iptables
iptables --flush

yum install iptables-services -y

systemctl mask firewalld

systemctl enable iptables

systemctl stop firewalld

systemctl start iptables

iptables --flush

iptables -F
iptables -X
iptables -t nat -F
iptables -t nat -X
iptables -t mangle -F
iptables -t mangle -X
iptables -P INPUT ACCEPT
iptables -P FORWARD ACCEPT
iptables -P OUTPUT ACCEPT

iptables -A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT

iptables -A FORWARD -s 10.33.0.0/24 -j ACCEPT
iptables -A FORWARD -d 10.33.0.0/24 -j ACCEPT

iptables -t nat -A PREROUTING --dst 1.2.3.4 -p udp --dport 2295 -j DNAT --to-destination 10.55.55.199:2295
iptables -t nat -A POSTROUTING -p udp -m udp -s 10.55.55.199 --sport 2295 -j SNAT --to-source 1.2.3.4:2295

iptables -t nat -A PREROUTING -p tcp -d 1.2.3.4 --dport 80 -i eth0 -j DNAT --to-destination 10.55.55.203:80
iptables -t nat -A PREROUTING -p tcp -d 1.2.3.4 --dport 443 -i eth0 -j DNAT --to-destination 10.55.55.203:443

iptables -t nat -A POSTROUTING -o eth0 -j MASQUERADE

service iptables save
service iptables restart

iptables -F

iptables -X

iptables -t nat -F

iptables -t nat -X

iptables -t mangle -F

iptables -t mangle -X

iptables -P INPUT ACCEPT

iptables -P FORWARD ACCEPT

iptables -P OUTPUT ACCEPT

iptables -A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT

iptables -A FORWARD -s 10.33.0.0/24 -j ACCEPT

iptables -A FORWARD -d 10.33.0.0/24 -j ACCEPT

iptables -t nat -A PREROUTING --dst 1.2.3.4 -p udp --dport 2295 -j DNAT --to-destination 10.55.55.199:2295

iptables -t nat -A POSTROUTING -p udp -m udp -s 10.55.55.199 --sport 2295 -j SNAT --to-source 1.2.3.4:2295

iptables -t nat -A PREROUTING -p tcp -d 1.2.3.4 --dport 80 -i eth0 -j DNAT --to-destination 10.55.55.203:80

iptables -t nat -A PREROUTING -p tcp -d 1.2.3.4 --dport 443 -i eth0 -j DNAT --to-destination 10.55.55.203:443

iptables -t nat -A POSTROUTING -o eth0 -j MASQUERADE

service iptables save

service iptables restart

Создаём контейнеры

vzctl create 199 --ostemplate centos-7-x86_64
vzctl set 199 --save --name openvpn \
    --ipadd 10.55.55.199 --hostname openvpn.co \
    --nameserver 8.8.8.8 --nameserver 8.8.4.4 \
    --onboot yes --cpus 1 --ram 512M --swap 1G --diskspace 5G
vzctl start 199

vzctl create 210 --ostemplate centos-7-x86_64
vzctl set 210 --save --name postgress.dev --ipadd 10.55.55.210 \
    --hostname postgres_dev.co \
    --nameserver 8.8.8.8 --nameserver 8.8.4.4 \
    --onboot yes --ram 8G --swap 8G --diskspace 10G
vzctl start 210

vzctl create 211 --ostemplate centos-7-x86_64
vzctl set 211 --save --name mysql.dev --ipadd 10.55.55.211 \
    --hostname mysql_dev.co \
    --nameserver 8.8.8.8 --nameserver 8.8.4.4 \
    --onboot yes --ram 8G --swap 8G --diskspace 10G
vzctl start 211

vzctl create 220 --ostemplate centos-7-x86_64
vzctl set 220 --save --name web.dev --ipadd 10.55.55.220 \
    --hostname web.co \
    --nameserver 8.8.8.8 --nameserver 8.8.4.4 \
    --onboot yes --ram 4G --swap 4G --diskspace 10G
vzctl start 220

vzctl create 199 --ostemplate centos-7-x86_64

vzctl set 199 --save --name openvpn \

--ipadd 10.55.55.199 --hostname openvpn.co \

--nameserver 8.8.8.8 --nameserver 8.8.4.4 \

--onboot yes --cpus 1 --ram 512M --swap 1G --diskspace 5G

vzctl start 199

vzctl create 210 --ostemplate centos-7-x86_64

vzctl set 210 --save --name postgress.dev --ipadd 10.55.55.210 \

--hostname postgres_dev.co \

--nameserver 8.8.8.8 --nameserver 8.8.4.4 \

--onboot yes --ram 8G --swap 8G --diskspace 10G

vzctl start 210

vzctl create 211 --ostemplate centos-7-x86_64

vzctl set 211 --save --name mysql.dev --ipadd 10.55.55.211 \

--hostname mysql_dev.co \

--nameserver 8.8.8.8 --nameserver 8.8.4.4 \

--onboot yes --ram 8G --swap 8G --diskspace 10G

vzctl start 211

vzctl create 220 --ostemplate centos-7-x86_64

vzctl set 220 --save --name web.dev --ipadd 10.55.55.220 \

--hostname web.co \

--nameserver 8.8.8.8 --nameserver 8.8.4.4 \

--onboot yes --ram 4G --swap 4G --diskspace 10G

vzctl start 220

vzlist

CTID NPROC STATUS   IP_ADDR       HOSTNAME
199   21   running  10.55.55.199  openvpn.co
210   21   running  10.55.55.210  postgres_dev.co
211   21   running  10.55.55.211  mysql_dev.co
220   21   running  10.55.55.220  web.co

CTID NPROC STATUS IP_ADDR HOSTNAME

199 21 running 10.55.55.199 openvpn.co

210 21 running 10.55.55.210 postgres_dev.co

211 21 running 10.55.55.211 mysql_dev.co

220 21 running 10.55.55.220 web.co

OpenVPN

vzctl enter 199

1	vzctl enter 199

Проверяем наличие… Читать далее »

PostgreSQL :: узнать размер таблиц базы данных

SELECT pg_size_pretty(pg_relation_size('my_table'));
SELECT pg_size_pretty(pg_total_relation_size('my_table'));
SELECT pg_size_pretty(pg_indexes_size('my_table'));
SELECT
    relname AS "relation",
    pg_size_pretty(pg_total_relation_size (C .oid)) AS "total_size"
FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C .relnamespace)
WHERE nspname NOT IN ('pg_catalog', 'information_schema')
  AND C .relkind <> 'i'
  AND nspname !~ '^pg_toast'
ORDER BY
    pg_total_relation_size(C.oid) DESC
LIMIT 5;
SELECT pg_size_pretty(pg_database_size ('my_database'));
SELECT
    pg_database.datname,
    pg_size_pretty(pg_database_size(pg_database.datname)) AS size
FROM pg_database;

SELECT pg_size_pretty(pg_relation_size('my_table'));

SELECT pg_size_pretty(pg_total_relation_size('my_table'));

SELECT pg_size_pretty(pg_indexes_size('my_table'));

SELECT

relname AS "relation",

pg_size_pretty(pg_total_relation_size (C .oid)) AS "total_size"

FROM pg_class C

LEFT JOIN pg_namespace N ON (N.oid = C .relnamespace)

WHERE nspname NOT IN ('pg_catalog', 'information_schema')

AND C .relkind <> 'i'

AND nspname !~ '^pg_toast'

ORDER BY

pg_total_relation_size(C.oid) DESC

LIMIT 5;

SELECT pg_size_pretty(pg_database_size ('my_database'));

SELECT

pg_database.datname,

pg_size_pretty(pg_database_size(pg_database.datname)) AS size

FROM pg_database;

Узнать размер всех таблиц базы данных можно с помощью такого запроса:

SELECT 
    relname AS name,
    relfilenode AS oid,
    (relpages::bigint * 8192 / (1024*1024))::bigint AS size_mb,
    reltuples AS cnt 
FROM pg_class 
WHERE relname IN (
    SELECT tablename FROM pg_catalog.pg_tables WHERE schemaname = 'public'
) 
ORDER BY cnt DESC;

SELECT

relname AS name,

relfilenode AS oid,

(relpages::bigint * 8192 / (1024*1024))::bigint AS size_mb,

reltuples AS cnt

FROM pg_class

WHERE relname IN (

SELECT tablename FROM pg_catalog.pg_tables WHERE schemaname = 'public'

)

ORDER BY cnt DESC;

MySQL :: узнать размер таблиц базы данных

Узнать размер всех таблиц базы данных можно с помощью такого запроса:

SELECT 
    table_name AS table_name,
    engine, 
    ROUND(data_length/1024/1024,2) AS total_size_mb,
    table_rows 
FROM information_schema.tables
WHERE table_schema=DATABASE();

SELECT

table_name AS table_name,

engine,

ROUND(data_length/1024/1024,2) AS total_size_mb,

table_rows

FROM information_schema.tables

WHERE table_schema=DATABASE();

Centos 7 apache nginx php-fpm git — установка

Пошаговая инструкция по установка окружения веб-разработчика на чистой VPS CentOS 7

cat /etc/redhat-release
yum update

# Общие пакеты
yum install sudo curl vim mc net-tools bind-utils mlocate gcc-c++

# Apache
yum install httpd
systemctl enable httpd

# PHP 5.6
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm
yum install php56w php56w-opcache php56w-xml php56w-mcrypt php56w-gd php56w-devel php56w-intl php56w-mbstring php56w-bcmath php56w-pdo php56w-mysql php56w-pgsql php56w-pear php56w-pecl-apcu php56w-fpm php56w-process
systemctl enable php-fpm

# Nginx
vim /etc/yum.repos.d/nginx.repo
    [nginx]
    name=nginx repo
    baseurl=https://nginx.org/packages/centos/$releasever/$basearch/
    gpgcheck=0
    enabled=1
yum install nginx
systemctl enable nginx

# GIT
wget https://github.com/git/git/archive/v2.6.3.tar.gz
tar -zxf v2.6.3.tar.gz
cd git-2.6.3/
yum install curl-devel expat-devel gettext-devel openssl-devel zlib-devel asciidoc xmlto docbook2x perl-devel docbook2X
ln -s /usr/bin/db2x_docbook2texi /usr/bin/docbook2x-texi
make configure
./configure --prefix=/usr
make all doc info
make install install-doc install-html install-info

# MySql 5.6
wget https://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum install mysql-server
systemctl start mysqld
systemctl enable mysqld
mysql_secure_installation

# PostgreSQL 9.4
yum install https://yum.postgresql.org/9.4/redhat/rhel-6-x86_64/pgdg-redhat94-9.4-1.noarch.rpm
yum install postgresql94-server postgresql94-contrib
/usr/pgsql-9.4/bin/postgresql94-setup initdb
systemctl enable postgresql-9.4.service
systemctl start postgresql-9.4.service

cat /etc/redhat-release

yum update

# Общие пакеты

yum install sudo curl vim mc net-tools bind-utils mlocate gcc-c++

# Apache

yum install httpd

systemctl enable httpd

# PHP 5.6

rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm

yum install php56w php56w-opcache php56w-xml php56w-mcrypt php56w-gd php56w-devel php56w-intl php56w-mbstring php56w-bcmath php56w-pdo php56w-mysql php56w-pgsql php56w-pear php56w-pecl-apcu php56w-fpm php56w-process

systemctl enable php-fpm

# Nginx

vim /etc/yum.repos.d/nginx.repo

[nginx]

name=nginx repo

baseurl=https://nginx.org/packages/centos/$releasever/$basearch/

gpgcheck=0

enabled=1

yum install nginx

systemctl enable nginx

# GIT

wget https://github.com/git/git/archive/v2.6.3.tar.gz

tar -zxf v2.6.3.tar.gz

cd git-2.6.3/

yum install curl-devel expat-devel gettext-devel openssl-devel zlib-devel asciidoc xmlto docbook2x perl-devel docbook2X

ln -s /usr/bin/db2x_docbook2texi /usr/bin/docbook2x-texi

make configure

./configure --prefix=/usr

make all doc info

make install install-doc install-html install-info

# MySql 5.6

wget https://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

rpm -ivh mysql-community-release-el7-5.noarch.rpm

yum install mysql-server

systemctl start mysqld

systemctl enable mysqld

mysql_secure_installation

# PostgreSQL 9.4

yum install https://yum.postgresql.org/9.4/redhat/rhel-6-x86_64/pgdg-redhat94-9.4-1.noarch.rpm

yum install postgresql94-server postgresql94-contrib

/usr/pgsql-9.4/bin/postgresql94-setup initdb

systemctl enable postgresql-9.4.service

systemctl start postgresql-9.4.service

Linux :: Список открытых портов

Посмотреть список открытых портов в ОС Linux можно командой:

netstat -tulpn

1	netstat -tulpn