Skip to content

Instantly share code, notes, and snippets.

@barbietunnie
barbietunnie / lets-encrypt-ubuntu-with-certbot.md
Created December 14, 2023 10:29
How to Install Let's Encrypt SSL on Ubuntu with Certbot

How to Install Let's Encrypt SSL on Ubuntu with Certbot

Install snapd

The apt version of certbot is usually not up-to-date, so it's preferable to install it with snap.

sudo systemctl status snapd
@barbietunnie
barbietunnie / docker-scout-notes.md
Last active November 19, 2023 06:48
Docker Scout CLI notes

Docker Scout CLI notes

1. Analyze local files

  • Get an at-a-glance vulnerability summary of the source code in the current working directory

    docker scout quickview fs://.
    
  • View the details of vulnerabilities found in your local source code

@barbietunnie
barbietunnie / dependent-objects-postgresql-redshift.md
Last active November 2, 2023 11:47
Find dependent objects for a table or view in Postgresql or Redshift

Find dependent objects for a table or view in Postgresql or Redshift

SELECT dependent_ns.nspname as dependent_schema
, dependent_view.relname as dependent_view 
, source_ns.nspname as source_schema
, source_table.relname as source_table
, pg_attribute.attname as column_name
FROM pg_depend 
JOIN pg_rewrite ON pg_depend.objid = pg_rewrite.oid 
@barbietunnie
barbietunnie / rabbitmq-tips.md
Last active October 26, 2023 09:20
RabbitMQ Tips

RabbitMQ Tips

Installation

Mac

brew update
brew install rabbitmq
@barbietunnie
barbietunnie / DecryptDBeaver.java
Last active October 22, 2024 10:43
How to retrieve/decrypt password stored in DBeaver connection
import javax.crypto.Cipher;
import javax.crypto.CipherInputStream;
import javax.crypto.NoSuchPaddingException;
import javax.crypto.SecretKey;
import javax.crypto.spec.IvParameterSpec;
import javax.crypto.spec.SecretKeySpec;
import java.io.ByteArrayInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.nio.file.Files;
@barbietunnie
barbietunnie / create-read-only-postgres-user.md
Created September 27, 2023 14:49
How to create a read-only PostgreSQL user

How to create a read-only PostgreSQL user

  1. Create a new user in PostgreSQL

    CREATE USER <username> WITH PASSWORD '<password>';
    
  2. GRANT CONNECT access

@barbietunnie
barbietunnie / git-permission-error.md
Created September 19, 2023 09:21
How to resolve git error: `Unable to append to .git/logs/refs/remotes/origin/master: Permission denied`

How to resolve git error: Unable to append to .git/logs/refs/remotes/origin/master: Permission denied

It appears git was run locally as root, thus changing the ownership on some of the files tracking the location of the origin branch.

Fixing the file ownership should resolve the issue:

# run this from the root of the git working tree
sudo chown -R "${USER:-$(id -un)}" .
@barbietunnie
barbietunnie / redis-misconf-error.md
Created September 6, 2023 17:35
How to resolve MISCONF Redis is configured to save RDB snapshots error

How to resolve MISCONF Redis is configured to save RDB snapshots error

The error "MISCONF Redis is configured to save RDB snapshots, but is currently not able to persist on disk. Commands that may modify the data set are disabled. Please check Redis logs for details about the error" occurs when Redis tries to save the database in the background but fails.

One of the scenarios where it's known to happen is when redis was recently upgraded by homebrew.

To resolve the issue, ssimply restart your redis instance:

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname
@barbietunnie
barbietunnie / ansible-variable-precedence.md
Last active March 19, 2023 20:25
Ansible Variable Precedence

Ansible Variable Precedence

Here is the order of precedence from least to greatest (the last listed variables override all other variables):

  1. command line values (for example, -u my_user, these are not variables)
  2. role defaults (defined in role/defaults/main.yml) [1]
  3. inventory file or script group vars [2]
  4. inventory group_vars/all [3]
  5. playbook group_vars/all [3]
  6. inventory group_vars/* [3]