From 6ab8ab3dedb672162aff67ad4392a8b09b69fa91 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Fri, 13 Oct 2023 16:24:10 +0000 Subject: [PATCH] New command to support VPN for port forwarding to pg server --- bin/sokwedb-vpn-wait | 40 +++++++++++++++++++++++++++++++++++++ make_files/make_commands.mk | 5 ++++- 2 files changed, 44 insertions(+), 1 deletion(-) create mode 100644 bin/sokwedb-vpn-wait diff --git a/bin/sokwedb-vpn-wait b/bin/sokwedb-vpn-wait new file mode 100644 index 0000000..8b82bf5 --- /dev/null +++ b/bin/sokwedb-vpn-wait @@ -0,0 +1,40 @@ +#!/bin/bash +# Copyright (C) 2023 The Meme Factory, Inc. http://www.meme.com/ +# +# This program is free software: you can redistribute it and/or modify +# it under the terms of the GNU Affero General Public License as +# published by the Free Software Foundation, either version 3 of the +# License, or (at your option) any later version. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU Affero General Public License for more details. +# +# You should have received a copy of the GNU Affero General Public License +# along with this program. If not, see . +# +# Tell the user how to use the VPN, and wait for them to exit. +# +# Syntax: sokwedb-vpn-wait +# +# Karl O. Pinc + +printf '\n' +printf ' SokweDB VPN now ACTIVE\n' +printf '\n' +printf 'You may now connect directly to the SokweDB PostgreSQL server.\n' +printf '\n' +printf ' The "hostname" of the server is: localhost\n' +printf ' The "port" of the server is: 5432 (the default)\n' +printf '\n' +printf 'You will also need your PostgreSQL username and password.\n' +printf '\n' +printf 'You can directly connect to the SokweDB PostgreSQL server only as\n' +printf 'long as this VPN remains active. Closing this window or otherwise\n' +printf 'stopping this program disconnects you from the database.\n' +printf '\n' +printf 'Close this window or press any key to shut down the VPN: ' + +read -n 1 -s +printf '\n' diff --git a/make_files/make_commands.mk b/make_files/make_commands.mk index 4538aa4..271046d 100644 --- a/make_files/make_commands.mk +++ b/make_files/make_commands.mk @@ -24,7 +24,8 @@ CMD_TARGETS := /usr/local/lib/git_email_hook.sh \ /usr/local/bin/sokwedb-user-add \ - /usr/local/bin/sokwedb-user-delete + /usr/local/bin/sokwedb-user-delete \ + /usr/local/bin/sokwedb-vpn-wait # Developers need permissions to install into the local directories DEV_GROUP := wwwdev @@ -71,6 +72,8 @@ set-install-permissions: ## A simplistic script to add a database user ## /usr/local/bin/sokwedb-user-delete ## A simplistic script to delete a database user +## /usr/local/bin/sowkedb-vpn-wait +## Tells user the VPN is up and does nothing ## /usr/local/lib/git_email_hook.sh ## A git post-receive hook which emails push summaries # Install the actual files -- 2.34.1