Skip to content

Instantly share code, notes, and snippets.

View okatkov's full-sized avatar

O Katkov okatkov

  • CyberBe Inc.
  • Russia
View GitHub Profile
SELECT table,
formatReadableSize(sum(bytes)) as size,
min(min_date) as min_date,
max(max_date) as max_date
FROM system.parts
WHERE active
GROUP BY table
@okatkov
okatkov / Activate Office 2019 for macOS VoL.md
Created March 5, 2023 08:55 — forked from zthxxx/Activate Office 2019 for macOS VoL.md
crack activate office on mac with license file

Activate MS Office 2019/2016 for macOS - Microsoft_Office_2019_VL_Serializer

Office 2019 above

2019-06-03

Note that Office2019 DO NOT support activate via simple copy/paste plist license file which is the simplest way to activate Office 2016. Fortunately, you can also use the VL Serializer tool, just install Office 2019 and Serializer, then run Serializer to activate.

Ref

@okatkov
okatkov / sshd_tunnel.sh
Created April 12, 2020 13:19 — forked from ripper/sshd_tunnel.sh
A script to launch user sshd limited to creation of reverse tunnels
#!/bin/sh
AUTHORIZED_KEYS=authorized_keys
HOST_RSA_KEY=ssh_host_rsa_key
SSHD=/usr/sbin/sshd
PORT=8443
case "$AUTHORIZED_KEYS" in /*) ;; *) AUTHORIZED_KEYS=$PWD/$AUTHORIZED_KEYS ;; esac
case "$HOST_RSA_KEY" in /*) ;; *) HOST_RSA_KEY=$PWD/$HOST_RSA_KEY ;; esac
### Keybase proof
I hereby claim:
* I am okatkov on github.
* I am 4blackcat (https://keybase.io/4blackcat) on keybase.
* I have a public key ASBcxaFRprrCtVC6kHdBIlI1YOabuv6-3oqMoStj0PMgBwo
To claim this, I am signing this object:
@okatkov
okatkov / linuxtv-dvb-apps-414-fix.patch
Created November 24, 2019 20:10
Hack to make linuxtv-dvb-apps work with Kernel >= 4.14
diff -r 3d43b280298c util/dst-utils/dst_test.c
--- a/util/dst-utils/dst_test.c Fri Mar 21 20:26:36 2014 +0100
+++ b/util/dst-utils/dst_test.c Sun Jan 07 22:41:44 2018 +0100
@@ -36,6 +36,15 @@
#define CA_NODE "/dev/dvb/adapter0/ca0"
+//https://github.com/braice/MuMuDVB/commit/596f7dbebd2590f7e77cf755af46952f340ddb97
+#ifndef CA_SET_PID
+typedef struct ca_pid {
@okatkov
okatkov / stream_to_youtube.sh
Created March 26, 2019 16:58 — forked from olasd/stream_to_youtube.sh
Stream video to youtube via ffmpeg
#! /bin/bash
#
# Diffusion youtube avec ffmpeg
# Configurer youtube avec une résolution 720p. La vidéo n'est pas scalée.
VBR="2500k" # Bitrate de la vidéo en sortie
FPS="30" # FPS de la vidéo en sortie
QUAL="medium" # Preset de qualité FFMPEG
YOUTUBE_URL="rtmp://a.rtmp.youtube.com/live2" # URL de base RTMP youtube
@okatkov
okatkov / autocert-server.go
Created February 13, 2019 19:41 — forked from samthor/autocert-server.go
Demo autocert server in Go
package main
import (
"crypto/tls"
"flag"
"fmt"
"log"
"net/http"
"os"
"os/user"
@okatkov
okatkov / _ide_helper_redis.php
Created April 27, 2018 07:47 — forked from lokielse/_ide_helper_redis.php
Laravel IDE helper for Redis
<?php
// source version: https://github.com/JetBrains/phpstorm-stubs/blob/master/redis/Redis.phpdis/Redis.php
// phpdoc version: https://github.com/nrk/predis/blob/v1.1/src/ClientInterface.php
// save this file to your project root
namespace {
exit("This file should not be included, only analyzed by your IDE");
/**
@okatkov
okatkov / redmine-plugins-install.sh
Created February 25, 2018 14:46 — forked from sameersbn/redmine-plugins-install.sh
Redmine Plugins Installation
#!/bin/bash
#
# Author: Sameer Naik <sameer@damagehead.com>
# Gist: https://gist.github.com/sameersbn/dd24dfdd13bc472d11a5
# Short Url (raw): http://goo.gl/iJcvCP
#
# Installs a bunch of plugins for the docker-redmine image
#
# Usage:
# $ mkdir -p /opt/redmine/data/plugins
@okatkov
okatkov / redmine.service
Created February 22, 2018 07:50 — forked from zinovyev/redmine.service
/etc/systemd/system/redmine.service
[Unit]
Description=Redmine server
After=syslog.target
After=network.target
[Service]
Type=simple
User=nginx
Group=nginx
ExecStart=/bin/bash -c 'source /usr/local/rvm/scripts/rvm && ruby /opt/redmine/bin/rails server unicorn -eproduction'