Skip to content

Instantly share code, notes, and snippets.

View sergeycherepanov's full-sized avatar
:bowtie:
Focusing

S.Cherepanov sergeycherepanov

:bowtie:
Focusing
View GitHub Profile
@sergeycherepanov
sergeycherepanov / dump.md
Last active January 26, 2017 15:58
full mysql dump without system db
MYSQLUSER='root' MYSQLPASSWORD='' MYSQLHOST='127.0.0.1' MYSQLPORT=3306; mysqldump -u$MYSQLUSER -p$MYSQLPASSWORD -h$MYSQLHOST -P$MYSQLPORT --databases `mysql --skip-column-names -u$MYSQLUSER -p$MYSQLPASSWORD -h$MYSQLHOST -P$MYSQLPORT -e "SELECT GROUP_CONCAT(schema_name SEPARATOR ' ') FROM information_schema.schemata WHERE schema_name NOT IN ('mysql','performance_schema','information_schema');"` > dump.sql
@sergeycherepanov
sergeycherepanov / kubernetes.sh
Last active July 18, 2017 20:41
kubernetes on ubuntu xenial (16.04)
#!/bin/bash
# install tools
apt-get update && apt-get install -y apt-transport-https curl
# Setup kubernetes apt repository
curl -s https://packages.cloud.google.com/apt/doc/apt-key.gpg | apt-key add -
echo "deb http://apt.kubernetes.io/ kubernetes-xenial main" | tee /etc/apt/sources.list.d/kubernetes.list
# Install kubernetes
apt-get update
@sergeycherepanov
sergeycherepanov / telegraf_pradam.com.conf
Last active July 31, 2017 12:51
http_response_alert.tick
stream
|from()
.database('telegraf')
.measurement('http_response')
.groupBy('server')
|where(lambda: "company" == 'pradam.com')
|alert()
.id('HTTPCHECK {{ index .Tags "server" }}')
.crit(lambda: "http_response_code" > 400)
.crit(lambda: "response_string_match" != 1)
@sergeycherepanov
sergeycherepanov / ru_RU.lang
Last active August 14, 2017 17:46
cookingforblockheads
item.cookingforblockheads:recipeBookTier0.name=Кулинария для чайников
item.cookingforblockheads:recipeBookTier1.name=Кулинария для чайников I
item.cookingforblockheads:recipeBookTier2.name=Кулинария для чайников II
tooltip.cookingforblockheads:recipeBookTier0=#NoFilter Edition
tooltip.cookingforblockheads:recipeBookTier0.description=Показывает все рецепты продуктов.
tooltip.cookingforblockheads:recipeBookTier1=Книга рецептов
tooltip.cookingforblockheads:recipeBookTier1.description=Показывает еду, которую вы можете сделать из \nингредиентов, которые у вас есть в инвентаре.
tooltip.cookingforblockheads:recipeBookTier2=Ремесленная книга
tooltip.cookingforblockheads:recipeBookTier2.description=Можете создавать еду, используя то, \nчто у вас есть в вашем инвентаре.
PRIVATE_IFACE=$(ip -4 link show | grep 'ens[0-9]' -o | head -1)
PUBLIC_IFACE=$(ip -4 link show | grep 'ens[0-9]' -o | tail -1)
PRIVATE_SUBNET=$(ip -4 addr show ens4 | grep inet | grep '[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}\/[0-9]\+' -o | awk -F\. '{print $1 "." $2 "." $3 ".0"}')
echo "${PRIVATE_SUBNET}" | grep '^172\.[0-9]\{1,3\}\.[0-9]\{1,3\}\.0$' || {
echo "Invalid private network '${PRIVATE_SUBNET}' must be 172.x.x.x"
exit 1
}
sysctl -w net.ipv4.ip_forward=1
iptables -A FORWARD --src ${PRIVATE_SUBNET}/24 -i ${PRIVATE_IFACE} -j ACCEPT
iptables -A FORWARD -j DROP
@sergeycherepanov
sergeycherepanov / sshd_config
Last active October 11, 2017 17:17
Server does not support diffie-hellman-group14-sha1 for keyexchange
Ciphers 3des-cbc,blowfish-cbc,cast128-cbc,arcfour,arcfour128,arcfour256,aes128-cbc,aes192-cbc,aes256-cbc,rijndael-cbc@lysator.liu.se,aes128-ctr,aes192-ctr,aes256-ctr,aes128-gcm@openssh.com,aes256-gcm@openssh.com,chacha20-poly1305@openssh.com
KexAlgorithms curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group-exchange-sha256,diffie-hellman-group14-sha1,diffie-hellman-group-exchange-sha1,diffie-hellman-group1-sha1

fluentd.conf

<source>
  @type tail
  path /tmp/log-test.log #...or where you placed your Apache access log
  pos_file /tmp/log-test.log.pos # This is where you record file position
  tag foobar.json #fluentd tag!
  format json # one JSON per line
  time_key time_field # optional; default = time
@sergeycherepanov
sergeycherepanov / queues.json
Created January 23, 2018 15:22
RabbitMQ metrics
{
"arguments": {
"x-max-priority": 4
},
"auto_delete": false,
"backing_queue_status": {
"avg_ack_egress_rate": 0.0,
"avg_ack_ingress_rate": 0.0,
"avg_egress_rate": 0.0,
"avg_ingress_rate": 0.0,
map $_project_name $project_name {
default undefined;
}
map $_pool $pool {
default undefined;
}
map $_php_version $php_version {
default undefined;