better error reporting

1 files changed, 9 insertions, 1 deletions

diff --git a/src/dyndns-command.sh b/src/dyndns-command.sh
index 8530058..375d50b 100755
--- a/src/dyndns-command.sh
+++ b/src/dyndns-command.sh
@@ -14,7 +14,15 @@ powerdns_sqlite_add_replace_record()
         local sql_domain="$(sql_string "$3")"
         local record_type="$(sql_string "$4")"
 
-        sqlite3 /etc/powerdns/powerdns.sqlite3 <<END
+        DBDIR=/etc/powerdns
+        DBNAME=powerdns.sqlite3
+        DB=$DBDIR/$DBNAME
+
+        test -r $DB    && test -w $DB    || die "Wrong permissions on $DB"
+        test -r $DBDIR && test -w $DBDIR || die "Wrong permissions on $DBDIR"
+
+        sqlite3 $DB <<END
+${SQL_ECHO:+.echo on}
 BEGIN;
         DELETE FROM records WHERE type=$record_type AND name=$sql_new_domain;