Skip to content

Instantly share code, notes, and snippets.

View viewpnt's full-sized avatar

x00x00 viewpnt

19 followers · 83 following
View GitHub Profile
@viewpnt
viewpnt / doveadmpw.go
Last active May 15, 2020 04:26 — forked from osiloke/doveadmpw.go
This generate a dovecot password in golang, inspired by https://gist.github.com/garrettreid/8329796
package main
// Modified to accept password and salt as arguments
//https://gist.github.com/osiloke/186a0feb6e203afa01c11d43439a383f
import (
"crypto/sha512"
"encoding/base64"
"fmt"
"math/rand"
@viewpnt
viewpnt / rspamd-lists.md
Created May 11, 2020 18:28 — forked from kvaps/rspamd-lists.md
Howto create local whitelists and blacklists for Rspamd

Local whitelists and blacklists for Rspamd

  • cd /etc/rspamd
  • create rspamd.conf.local
  • create lists:
touch local_bl_from.map.inc local_bl_ip.map.inc local_bl_rcpt.map.inc \
local_wl_from.map.inc local_wl_ip.map.inc local_wl_rcpt.map.inc
  • change permissions:
@viewpnt
viewpnt / rspamd-whitelisting.md
Created May 11, 2020 18:26 — forked from ThomasLeister/rspamd-whitelisting.md
How to whitelist IP addresses or domains in Rspamd

Whitelist IP addresses based on pre-filter policy

/etc/rspamd/local.d/multimap.conf:

  IP_WHITELIST {
      type = "ip";
      prefilter = true;
      map = "/${LOCAL_CONFDIR}/local.d/ip_whitelist.map";
 action = "accept";
@viewpnt
viewpnt / centos-6-php-ius-audit.md
Created May 5, 2020 05:28 — forked from jdeathe/centos-6-php-ius-audit.md
Identify Unavailable IUS Packages Between PHP 5.6 and 7.1

Identify Unavailable IUS PHP Packages Between 5.6 and 7.1

For all installed packages prefixed with php56u, check for availability php71u package.

# yum list installed \
| grep -o '^php56u[^ ]*' \
| { \
  mapfile -t packages; \
 for package in "${packages[@]}"; do \
@viewpnt
viewpnt / gist:6f1774d8ea94facc5ccd58f23bfc51df
Created October 14, 2019 07:15 — forked from progrium/gist:5734609
Let unprivileged processes easily restart/reload Nginx without sudo or setuid hacks
# run this as root
while [ 1 ]; do echo | nc -l -U /tmp/reload_nginx && /etc/init.d/nginx reload; done
# or as an upstart job
script
echo | nc -l -U /tmp/reload_nginx && /etc/init.d/nginx reload
end script
respawn
# now any process can run this or do the equivalent with sockets to trigger reload
@viewpnt
viewpnt / gapless_sequence.sql
Created September 14, 2019 03:18 — forked from fabriziomello/gapless_sequence.sql
Gapless sequence example in PostgreSQL
CREATE TABLE public.gapless_sequence (
sequence_schema TEXT,
sequence_name TEXT,
last_value BIGINT DEFAULT 0,
step INTEGER DEFAULT 1
);
ALTER TABLE public.gapless_sequence
ADD CONSTRAINT gapless_sequence_pk PRIMARY KEY (sequence_schema, sequence_name);
@viewpnt
viewpnt / find_available_LDAP_number.sh
Created April 25, 2019 02:56 — forked from kojiujau/find_available_LDAP_number.sh
To find next available LDAP number
#!/bin/bash
dn="dc=example,dc=com"
ldap_server='192.168.1.1'
group_name='group'
available_uidNumber=`expr $(ldapsearch -x -b ${dn} -h ${ldap_server} '(objectClass=posixAccount)' uidNumber | grep "uidNumber: " | sed "s|uidNumber: ||" | uniq | sort -n | tail -n 1) + 1 `
echo ${available_uidNumber}
available_gidNumber=`expr $(ldapsearch -x -b ${dn} -h ${ldap_server} '(objectClass=posixGroup)' gidNumber | grep "gidNumber: " | sed "s|gidNumber: ||" | uniq | sort -n | tail -n 1) + 1 `
echo ${available_gidNumber}
@viewpnt
viewpnt / nginx.conf
Created September 7, 2018 03:52 — forked from sergejmueller/nginx.conf
Stop search engines from indexing .txt, .log, .xml, .css and .js files in Nginx
location ~* \.(txt|log|xml|css|js)$ {
add_header X-Robots-Tag noindex;
}
@viewpnt
viewpnt / read-access.sql
Created August 2, 2018 20:38 — forked from oinopion/read-access.sql
How to create read only user in PostgreSQL
-- Create a group
CREATE ROLE readaccess;
-- Grant access to existing tables
GRANT USAGE ON SCHEMA public TO readaccess;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;
-- Grant access to future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;
@viewpnt
viewpnt / git_cheat-sheet.md
Created July 2, 2018 22:59 — forked from davfre/git_cheat-sheet.md
git commandline cheat-sheet