oneliner

Check CSV BOM Using Bash

2022-03-21 · 1 min read · csv utf8 bom bash ·

BOM or Byte-Order-Mark is needed by a UTF-8 CSV in order to be opened in Excel (at least for Windows). How to check if said BOM exist using bash? See below: 1~$ head -c3 samplefile.csv | hexdump -C 200000000 ef bb bf |...| 300000003

Query Postgresql from Bash Command Line

2021-08-12 · 1 min read · postgresql db tricks ·

Share on:

1psql -c "<your_query_here>" Example, to show tables list: 1psql -c "\dt+"

View All SSL Cert in a Bundle File

2020-07-15 · 1 min read · sslcert tlscert bundle ·

Share on:

Oneliner solution using the following command: 1~$ openssl crl2pkcs7 -nocrl -certfile www.example.org-bundle.crt | openssl pkcs7 -print_certs -noout With sample output as follows: 1~$ openssl crl2pkcs7 -nocrl -certfile www.example.org-bundle.crt | openssl pkcs7 -print_certs -noout 2subject=/OU=Domain Control …

Filesystem Remount Read-Write in Linux

2020-07-12 · 1 min read · linux filesystem mount ·

Share on:

1mount -o remount,rw /dev/sda1 /

Removing Group Sticky Bit

2020-07-12 · 1 min read · permission sticky-bit ·

Share on:

1chmod g-s <dirname_here> More details in https://serverfault.com/questions/238962/how-do-i-clear-the-s-permission-on-a-directory-in-linux

One Liner CSR Creation

2020-06-07 · 1 min read · sslcert tlscert csr ·

Share on:

1openssl req -new -newkey rsa:2048 -nodes -out this.example.com.csr -keyout this.example.com.key -subj "/C=PH/ST=Cebu/L=Cebu/O=Example Organization Cebu/OU=IT Department/CN=this.example.com" What to use in the "-subj' as per https://www.endpoint.com/blog/2014/10/30/openssl-csr-with-alternative-names-one C …