Category Archives: Command line

Migrating Roundcube from MySQL to PostgreSQL

If You think there’s an easy and fully automated way of migrating a Roundcube installation running for years on MySQL – to a PostgreSQL database – forget it. You will probably have to take a few steps before automation could be applied to this process. In this post I’m trying to describe all steps of Read the full article…

Filtering/sanitizing IP addresses lists on command line

Sometimes You have to obtain via command line on a list of IP addresses and you need to be sure it will not contain any IP addresses assigned to the machine You’re working on – especially, when You’re planning to use this list during automated modification of firewall rules.

Extracting the public and private key from a PKCS #12 container using OpenSSL

Extract the private key from mycert.pfx: openssl pkcs12 -in mycert.pfx -nocerts -out my-private-key.pem Convert .pfx/.p12 to .pem: openssl pkcs12 -in mycert.pfx -out mycert.pem Extract the public key: openssl x509 -inform pem -in mycert.pem -pubkey -out my-public-key.pem