From 300586b46b07f764eb45970919c89361e106d2af Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Fri, 6 Oct 2023 14:06:39 -0500 Subject: [PATCH] Add user management commands: sokwedb-user-add, sokwedb-user-delete --- .gitignore | 4 + bin/sokwedb-user-add.m4 | 145 ++++++++++++++++++++++++++++++++++++ bin/sokwedb-user-delete.m4 | 77 +++++++++++++++++++ make_files/make_commands.mk | 19 ++++- 4 files changed, 243 insertions(+), 2 deletions(-) create mode 100644 bin/sokwedb-user-add.m4 create mode 100644 bin/sokwedb-user-delete.m4 diff --git a/.gitignore b/.gitignore index 4c24851..cd6386b 100644 --- a/.gitignore +++ b/.gitignore @@ -1,3 +1,7 @@ +# Generated programs +bin/sokwedb-user-add +bin/sokwedb-user-delete + # The generated sql db/schemas/**/*.sql db/*.sql diff --git a/bin/sokwedb-user-add.m4 b/bin/sokwedb-user-add.m4 new file mode 100644 index 0000000..55ed356 --- /dev/null +++ b/bin/sokwedb-user-add.m4 @@ -0,0 +1,145 @@ +#!/bin/sh +# Copyright (C) 2012, 2023 The Meme Factory, Inc. http://www.meme.com/ +# Copyright (C) 2005, 2008, 2011 Karl O. Pinc +# +# 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 . +# +# Add a user to the database +# +# Syntax: See usage() below. +# +# Karl O. Pinc +# +# Bugs: Does not check to see if the user already exists. +# Lots of hardcoding. +# Creates an easily guessable password. +# +include(global_constants.m4)dnl +include(global_macros.m4)dnl + +usage () { +echo 'Syntax: sokwedb-user-add [-h host] adminuser username group' +echo ' sokwedb-user-add [-h host] -a|-d [--no-azure] adminuser username' +echo ' sokwedb-user-add --help' +echo '' +echo ' -a Make the account an admin account' +echo ' -d Make the account a developer account' +echo ' --no-azure The db is not on a pg azure hosted instance' +echo ' -h host Connect to the pg server on "host"' +echo ' --help Print this help' +echo ' adminuser The user to use to make the user' +echo ' username The username to add' +echo ' group The group in which to put the user' +} + +# Parse command line +export ADMIN='' +export DEV='' +export AZURE='yes' +export HOSTARGS='' +export A_ADMINUSER=$1 +while [ "$A_ADMINUSER" = '-a' \ + -o "$A_ADMINUSER" = '-d' \ + -o "$A_ADMINUSER" = '--no-azure' \ + -o "$A_ADMINUSER" = '-h' \ + -o "$A_ADMINUSER" = '--help' ] ; do + if [ "$A_ADMINUSER" = '-a' ] ; then + ADMIN='-a' + shift + elif [ "$A_ADMINUSER" = '-d' ] ; then + DEV='-d' + shift + elif [ "$A_ADMINUSER" = '--no-azure' ] ; then + AZURE="no" + shift + elif [ "$A_ADMINUSER" = '-h' ] ; then + HOSTARGS="--host $2" + shift 2 + elif [ "$A_ADMINUSER" = '--help' ] ; then + usage + exit 0 + fi + A_ADMINUSER=$1 +done +export A_USER=$2 +export A_GROUP=$3 + +if [ -z "$ADMIN" -a -z "$DEV" ] ; then + if [ "$A_GROUP" != "sdb_reader" \ + -a "$A_GROUP" != "sdb_writer" ] ; then + echo "'$A_GROUP' not sdb_reader or sdb_writer" >&2 + usage >&2 + exit 1; + fi +else + if [ ! -z "$A_GROUP" ] ; then + echo "Too many arguments" >&2 + usage >&2 + exit 1; + fi +fi + +export AZURE_GRANTS='' +if [ "$AZURE" = 'yes' ] ; then + AZURE_GRANTS="grant azure_pg_admin to $A_USER;" +fi + +if [ -n "$ADMIN" ] ; then + psql $HOSTARGS -U $A_ADMINUSER -d template1 < +# +# 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 . +# +# Add a user to the database +# +# Syntax: sokwedb-user-delete [-a] adminuser username +# +# Karl O. Pinc +# +# Bugs: Does not check to see if the user already exists. +# +include(global_constants.m4)dnl +include(global_macros.m4)dnl + +usage () { +echo 'Syntax: sokwedb-user-delete [-h host] [-a] adminuser username' +echo ' sokwedb-user-add --help' +echo '' +echo ' -a Delete an admin or developer account' +echo ' -h host Connect to the pg server on "host"' +echo ' --help Print this help' +echo ' adminuser The user to use to delete the user' +echo ' username The username to delete' +} + +# Parse command line +export ADMIN='' +export HOSTARGS='' +export A_ADMINUSER=$1 +while [ "$A_ADMINUSER" = '-a' \ + -o "$A_ADMINUSER" = '-h' \ + -o "$A_ADMINUSER" = '--help' ] ; do + if [ "$A_ADMINUSER" = '-a' ] ; then + ADMIN='-a' + shift + elif [ "$A_ADMINUSER" = '-h' ] ; then + HOSTARGS="--host $2" + shift 2 + elif [ "$A_ADMINUSER" = '--help' ] ; then + usage + exit 0 + fi +A_ADMINUSER=$1 +done +export A_USER=$2 + +if [ -z "$ADMIN" ] ; then +psql $HOSTARGS -U $A_ADMINUSER -d sokwedb_copy < $@ -- 2.34.1