Creating a New CA (SHA-512, 4096-bit) with PKCS #11 Smart Card Storage and Subordinate CA

<p class="wp-block-paragraph">Today, I will walk through the process of creating a new Certificate Authority (CA) using a 4096-bit RSA key and SHA-512 as the signature hash algorithm. I will also store the private key securely on a PKCS #11–compatible smart card, and then create a subordinate (sub) CA using the root CA. Throughout this guide, … Read more

PostgreSQL Notes

<p class="wp-block-paragraph">How to drop all tables sharing the same prefix in PostgreSQL?</p> <ul class="wp-block-list"> <li>Non-Cascade version:</li> </ul> <p class="wp-block-paragraph">How to drop all functions in PostgreSQL?</p> <p class="wp-block-paragraph"> How to drop all tables sharing the same prefix in PostgreSQL? Non-Cascade version: How to drop all functions in PostgreSQL?

Running PostgreSQL in Docker on my Mac

<p class="wp-block-paragraph">It’s extremely convenient to run your local tools, like RDMS, development environments and so on on Docker containers on Mac. To be honest with you, I hate installing a bunch of software on my Mac, and that’s the main reason why do I use containers for my local development.</p> <p class="wp-block-paragraph">Before doing that manual, … Read more

ElementaryOS: Resolution fix for 2560×1440

<p class="wp-block-paragraph">Edit <strong>/usr/share/X11/xorg.conf.d/10-monitor.conf</strong> and paste the following:</p> <p class="wp-block-paragraph">And reboot system with <strong>sudo reboot</strong></p> <p class="wp-block-paragraph">Thanks!</p> Edit /usr/share/X11/xorg.conf.d/10-monitor.conf and paste the following: And reboot system with sudo reboot Thanks!

Apache 2.4.6 + mod_wsgi + Python 3.6 + Django 2.2.6 on CentOS 7

<p class="wp-block-paragraph">There are many how-to’s on installing Apache with mod_wsgi, python 3.x and Django, but nothing worked for me, looks like mod_wsgi libraries installed by default with yum use Python 2.x, and I keep getting the following error message:</p> <p class="wp-block-paragraph">Installing Apache and devel package</p> <p class="wp-block-paragraph">So, I had to compile <strong>mod_wsgi</strong> library from sources, … Read more

Nagios environment variables

<p class="wp-block-paragraph">As soon as Nagios is managed by systemd, you have to change the passing environment variables from /etc/sysconfig/nagios to systemd</p> <p class="wp-block-paragraph">Edit the file</p> <p class="wp-block-paragraph">Add <strong>Environment=””</strong> or <strong>EnvironmentFile=””</strong> to [<strong>service</strong>] section</p> <p class="wp-block-paragraph">Restart systemd and nagios</p> <p class="wp-block-paragraph">Check the process environment</p> <p class="wp-block-paragraph">That will pass all variables into Nagios daemon</p> <blockquote class="wp-block-quote is-layout-flow … Read more

Happy Independence Day!

<p class="has-medium-font-size wp-block-paragraph">Wishing everybody a wonderful time on this special day in American history. Happy Fourth of July! <strong>God bless America!</strong></p> Wishing everybody a wonderful time on this special day in American history. Happy Fourth of July! God bless America!

Open-Xchange IMAP: STARTTLS failure

<p class="wp-block-paragraph">During some experiments with open-sources code, found an issue with STARTTLS on the latest open-xchange appsuite 7.10.1-Rev9</p> <p class="wp-block-paragraph">Something like this:</p> <p class="wp-block-paragraph">Looks like empty vars for SSL protocol and SSL ciphersuites are not working properly, if specify them everything works just fine.</p> <p class="wp-block-paragraph">Hope that helps, thanks!</p> During some experiments with open-sources code, … Read more

Paperkey: How to backup your GnuPG keys on paper

To create a backup of your GPG Key, you may use one of the following commands paperkey –secret-key my-secret-key.gpg –output to-be-printed.txt Or using this if you have exported (not armored) GPG Key in file: paperkey –secret-key my-secret-key.gpg –output to-be-printed.txt To restore it you will need a paperkey data in file and you public key. The … Read more