Tuxifans Website

Some ISPs have this issue where TCP connections are closed after a couple of seconds of inactivity. I’ve experienced this on a VPS, apparently due to an incorrectly configured DDoS filter.

Applications like sshd can circumvent this by enabling a feature called “keepalive” on their TCP sockets to circumvent this by sending dummy TCP acknowledgements every couple of seconds while the connection is inactive.

However, there’s no immediately obvious way to make this the default system wide. In this post I’m documenting a way to do just that using an eBPF program for all incoming connections.

Read more...

I know, there are tons of posts on the internet showing you how to do this already. Most of them however are outdated and no longer seem to actually work.

Here’s what I found to be working best:

Create User

CREATE USER myuser WITH PASSWORD 'strong_password';

Yup, it’s still as simple as that. Nothing special here.

Create Database

CREATE DATABASE mydatabase;

Couldn’t be easier.

Grant User Permissions on Database

This is where most of the guides online fail. These guides tell you to just:

Read more...

About Me

This page has no content yet, it’s just a placeholder.