Create CSR using OpenSSL Without Prompt (Non-Interactive)

In this article you’ll find how to generate CSR (Certificate Signing Request) using OpenSSL from the Linux command line, without being prompted for values which go in the certificate’s subject field.

In the first example, i’ll show how to create both CSR and the new private key in one command.

And in the second example, you’ll find how to generate CSR from the existing key (if you already have the private key and want to keep it).

Both examples show how to create CSR using OpenSSL non-interactively (without being prompted for subject), so you can use them in any shell scripts. (more…)

Read More

Generate a Random Character String in Excel

You may find yourself faced with a need to generate a ton of random strings of characters.

For example, you may have a list of usernames that need passwords – you could be lazy and say everyone’s password is password, but I will assume you know better than that!

Generate Random Number String

To generate a random number string in Excel, simply use a formula like this:

=RANDBETWEEN(0,9)

This will randomly display a number between 0 and 9 each time the page is refreshed. (more…)

Read More