KnowDB
file

First seen , last seen .

psql_wrapper.sh.mustache (7a50a114ce6ae53128d19fec5c89389833c506bb3db4ad67c4cc90ad54653c29)

See also: psql_wrapper.sh.mustache (filename)

The file psql_wrapper.sh.mustache (834 B), identified by its SHA-256 checksum. This file is found on 100 hosts in your infrastructure, at 3 different paths.

Policy sets
3.27.1 (b3b6ad10f5496f40)3.27.0 (1c477bc18a40a492)

834 B, 31 lines:

#!/bin/bash

# run an arbitrary psql command as cfpostgres user
# expectation is that a line will be output with exit_code=<n>
# this exit code <n> will then be used to exit
# This design enables cfengine policy to run a commands promise
# that can be kept, repaired or failed depending on an exit
# code from psql since psql can't get different codes from scripts.

if [ $# -ne 2 ]; then
    echo "Usage: $0 [DBNAME] [SQL STRING]"
    exit 2
fi

TMP=$(mktemp)
cd /tmp
OUT=$(su - cfpostgres --command "{{{vars.sys.bindir}}}/psql --quiet --tuples-only --no-align --no-psqlrc \"$1\" --command=\"$2\"" 2> $TMP)
RETURN_CODE=$?
ERR=$(<$TMP)

EXIT_CODE=$(echo $OUT | awk -F= '{ if ( /exit_code/ ) print $2}')

rm $TMP

if [ $RETURN_CODE -ne 0 ]; then
    echo "stdout: $OUT"
    echo "stderr: $ERR"
    exit 2; # failed
fi

exit $EXIT_CODE