Skip to content

Instantly share code, notes, and snippets.

View coder4web's full-sized avatar

Aleksey Deryagin coder4web

13 followers · 1 following
View GitHub Profile
@coder4web
coder4web / aws_mercurial_install.sh
Last active February 27, 2018 10:05
How To Install Mercurial SCM on Amazon AMI
# https://www.mercurial-scm.org/
# https://www.mercurial-scm.org/wiki/UnixInstall#System-wide_installation
# rooted version :)
sudo -i
yum list mercurial
#Loaded plugins: priorities, update-motd, upgrade-helper
#Error: No matching Packages to list
yum groupinstall "Development Tools"
@coder4web
coder4web / proftpd server setup (debian, centos)
Last active August 12, 2016 06:39
# ------------------------
# debian
# ------------------------
apt-cache policy proftpd-basic
apt-get install proftpd
proftpd --version
proftpd -vv
nano /etc/proftpd/proftpd.conf
Include /etc/proftpd/conf.d/
@coder4web
coder4web / postgresql_monit.sql
Last active September 8, 2021 14:56
PostgreSQL 11/12 monitoring
-- logs
SET log_statement = 'all';
-- list database(s)
\l+ [database]
-- list schema(s)
\dn
-- list tables in all schemas
@coder4web
coder4web / centos_kernel_upgrade.sh
Last active March 10, 2020 08:22
How to Install or Upgrade to Kernel 5.x in CentOS 7
# @see https://www.tecmint.com/install-upgrade-kernel-version-in-centos-7/
uname -sr
# Linux 3.10.0-1062.12.1.el7.x86_64
rpm --import https://www.elrepo.org/RPM-GPG-KEY-elrepo.org
rpm -Uvh http://www.elrepo.org/elrepo-release-7.0-4.el7.elrepo.noarch.rpm
yum --disablerepo="*" --enablerepo="elrepo-kernel" list available
yum --enablerepo=elrepo-kernel install kernel-ml
@coder4web
coder4web / vertica_monit.sql
Last active April 3, 2018 14:43
Vertica management and monitoring
-- List of schemas
\dn
-- list all tables
\dt
-- list only tables with "public" schema
\dt public.*
-- database size
@coder4web
coder4web / zabbix_setup.sh
Last active March 23, 2019 17:04
Zabbix setup (CentOS. RHEL)
# ------------------------
# agent
# ------------------------
sudo rpm -ivh http://repo.zabbix.com/zabbix/3.4/rhel/7/x86_64/zabbix-release-3.4-2.el7.noarch.rpm
sudo yum list zabbix-agent
sudo yum install zabbix-agent
sudo firewall-cmd --zone=public --add-port=10050/tcp
sudo firewall-cmd --zone=public --add-port=10050/tcp --permanent
sudo semanage permissive -a zabbix_agent_t
sudo systemctl enable zabbix-agent.service
@coder4web
coder4web / postgresql_roles.sql
Last active July 17, 2018 13:24
PostgreSQL roles
\z
-- Full access
GRANT ALL privileges ON DATABASE db TO admin_user;
GRANT ALL ON schema public TO admin_user;
GRANT ALL ON ALL TABLES IN SCHEMA public TO admin_user;
GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO admin_user;
-- Read-only access
CREATE ROLE readonly;
@coder4web
coder4web / ubuntu_dualboot.sh
Last active August 31, 2018 14:35
Ubuntu dual-boot HOW-TO
# boot - How can I reinstall GRUB to the EFI partition? - Ask Ubuntu
# https://askubuntu.com/a/831241/19938
# Note : sdX = disk | sdXX = efi partition | sdXXX = system partition
sudo mount /dev/sdXXX /mnt
sudo mount /dev/sdXX /mnt/boot/efi
for i in /dev /dev/pts /proc /sys /run; do sudo mount -B $i /mnt$i; done
sudo chroot /mnt
grub-install /dev/sdX
update-grub
@coder4web
coder4web / osm_tile_server_centos7.sh
Last active June 7, 2021 08:58
CentOS 7 Open Street Map Tile Server
# Based on next manuals:
# Ubuntu 18.04 LTS: https://switch2osm.org/manually-building-a-tile-server-18-04-lts/
# CentOS 7 - https://www.hyperlearning.ai/en/knowledgebase/blog/centos-7-open-street-map-tile-server
# Updated to latest CentOS / deps packages
# Dependencies
sudo yum install git gdal sqlite geos boost curl libcurl libicu bzip2-devel zlib-devel libxml2-devel python-setuptools proj-devel proj proj-epsg proj-nad libicu-devel gdal-devel sqlite-devel libcurl-devel geos-devel protobuf-devel protobuf-c-devel lua-devel cmake proj boost-thread proj-devel autoconf automake libtool pkgconfig ragel gtk-doc glib2 glib2-devel libtool-ltdl-devel python-devel boost-devel cabextract xorg-x11-font-utils fontconfig perl-DBD-Pg mesa-libGLU-devel
sudo yum install cairo pycairo cairo-devel pycairo-devel freetype freetype-devel harfbuzz harfbuzz-devel harfbuzz-icu libjpeg libjpeg-devel libpng libpng-devel libtiff libtiff-devel libwebp libwebp-devel
sudo mkdir -p /usr/local/src/osm_tile_server
@coder4web
coder4web / postgrespro.sh
Last active November 10, 2019 21:29
Postgres Pro install, setup and maintenance
# @see https://postgrespro.ru/docs/postgrespro/11/binary-installation-on-linux.html
#-------------------------------
# Debian 8/9/10:
#-------------------------------
sudo apt-get install lsb-release
sudo sh -c 'echo "deb http://repo.postgrespro.ru/pgpro-11/debian $(lsb_release -cs) main" > /etc/apt/sources.list.d/postgrespro.list'
wget --quiet -O - http://repo.postgrespro.ru/pgpro-11/keys/GPG-KEY-POSTGRESPRO | sudo apt-key add -
sudo apt-get update