Categories
SysOps

How to inspect PostgreSQL queries

Sometimes I want to inspect and verify queries made by an application or hunt a bug that involves more complex queries. The essential part of this process requires altering PostgreSQL server configuration to log SQL statements.

Categories
SysOps

How to locate scripts in the PATH

Simple shell script that will iterate through the directories in the PATH variable and print only files identified as scripts.

Categories
SysOps

How to check external IP address

I am constantly on the move, so sometimes I need to quickly verify my external IP address, as I do not want to accidentally block myself on some kind of firewall.

Categories
SysOps

How to password protect GRUB entries

I always asked myself how to password protect GRUB entries on an encrypted notebook to lock down the boot loader and protect it from unauthorized access.

Categories
SysOps

How to check file metadata using shell script

It is well described how to verify file existence or type, but there is much more information that can be easily verified inside shell script using nothing more than simple stat command.

Categories
SysOps

How to create persistent reverse SSH tunnel

Sometimes I want to access a private server at home from a different network while being on the go.
The easiest way to do this is to use autossh utility to create a secure and persistent reverse SSH tunnel to the publicly available server.

Categories
SysOps

How to use recent version of Iceweasel in Debian Wheezy

Do you want to use the latest version of Iceweasel, also known as Firefox?
Then add the repository provided by the Debian Mozilla team and choose between release, beta and aurora version.

Categories
SysOps

How to check package version

Sometimes I need to check the installed package version, compare it with the available version, or verify that the correct version is already installed. I will show you how to quickly perform these checks.

Categories
SysOps

How to enable VPN connections inside Network Manager

Default Debian installation does not include VPN support inside the Network Manager applet. The reason behind this decision is probably the variety of available solutions.

Categories
SysOps

i915 and "Hangcheck timer elapsed" error

Since Debian Jessie installation, I have encountered Hangcheck timer elapsed error. It is a really nasty bug as the only way to escape frozen X Window System is to reboot the whole operating system.