diff --git a/hook.sh b/hook.sh new file mode 100755 index 0000000..e8f65b8 --- /dev/null +++ b/hook.sh @@ -0,0 +1,20 @@ +#!/bin/bash + +SQLITE="/usr/bin/sqlite3" +if [ -n $OPENVPN_DBFILE ]; then + OPENVPN_DBFILE="ovpn_session.db" +fi + +db_query(){ + result=$($SQLITE $OPENVPN_DBFILE "$1" 2>&1) + if [ $? -ne 0 ]; then + echo Error executing SQL \ + \""$(echo "$1" | tr -d "\n")"\". $result 1>&2 + return 1 + else + echo $result + fi + return 0 +} + +# db_query 'insert into a123 (number) values (1);'