Skip to content

Instantly share code, notes, and snippets.

@esavchenkov
esavchenkov / dial-pq-via-ssh.go
Created November 6, 2023 16:17 — forked from vinzenz/dial-pq-via-ssh.go
Use postgres via SSH in Golang
package main
import (
"database/sql"
"database/sql/driver"
"fmt"
"net"
"os"
"time"
@esavchenkov
esavchenkov / rsync_from_server.md
Created November 2, 2023 17:04 — forked from lgloege/rsync_from_server.md
Use rsync to copy from a server with bastion server between them. Does not require scp or ssh tunneling.

Setup keyless login

  1. On local make an RSA key if you haven't already (ssh-keygen)
  2. Copy that key into .ssh/authorized_keys on the first (i.e. bastion) server (ssh-copy-id [email protected]) 2b. Test that you can ssh [email protected] and connect without password
  3. ssh to first.server and create an RSA key on first.server if you haven't already (ssh-keygen)
  4. ssh-copy-id to the server you want to access (what I am calling second.server) 4b. test that you can ssh from first.server to second.server without entering a password

To copy from server to local

rsync -e "ssh [email protected] ssh" [email protected]:/path/to/file /path/to/local/dest

@esavchenkov
esavchenkov / read-text-message.sh
Created July 6, 2023 06:06 — forked from FinnWoelm/read-text-message.sh
How to read text messages from USB modem
# Full instructions: http://manpages.ubuntu.com/manpages/bionic/en/man8/mmcli.8.html
# Examples: http://manpages.ubuntu.com/manpages/bionic/en/man8/mmcli.8.html#examples
# Supported modems: https://www.freedesktop.org/wiki/Software/ModemManager/SupportedDevices/
# Get list of connected modems.
mmcli --list-modems
# Output:
# Found 1 modems:
# /org/freedesktop/ModemManager1/Modem/1 [huawei] E3531
# The number at the end of the path is the modem index.
@esavchenkov
esavchenkov / read-text-message.sh
Created July 6, 2023 06:06 — forked from FinnWoelm/read-text-message.sh
How to read text messages from USB modem
# Full instructions: http://manpages.ubuntu.com/manpages/bionic/en/man8/mmcli.8.html
# Examples: http://manpages.ubuntu.com/manpages/bionic/en/man8/mmcli.8.html#examples
# Supported modems: https://www.freedesktop.org/wiki/Software/ModemManager/SupportedDevices/
# Get list of connected modems.
mmcli --list-modems
# Output:
# Found 1 modems:
# /org/freedesktop/ModemManager1/Modem/1 [huawei] E3531
# The number at the end of the path is the modem index.