[patch] Patch to files/dspam-3.8.0.cron that allows the sqlite purge script and vacuum to run properly

dspam-3.8.0.cron.patch (text/plain), 1.65 KB, created by Henry So, Jr. on 2007-07-04 14:26:54 UTC

diff -u old/dspam-3.8.0.cron new/dspam-3.8.0.cron
--- old/dspam-3.8.0.cron	2007-07-04 10:05:30.781647041 -0400
+++ new/dspam-3.8.0.cron	2007-07-04 10:05:45.513359581 -0400
@@ -256,13 +256,19 @@
 		fi
 
 		# Run the SQLite3 purge script
-		find "${DSPAM_HOMEDIR}" -name "*.sdb" -exec /usr/bin/sqlite3 "{}" < "${DSPAM_SQLite3_PURGE_SQL}" \; 1>/dev/null 2>&1
+		find "${DSPAM_HOMEDIR}" -name "*.sdb" -print | while read name
+                do
+                    /usr/bin/sqlite3 "$name" < "${DSPAM_SQLite3_PURGE_SQL}"
+                done 1>/dev/null 2>&1
 
 		# Run the dspam_clean command
 		run_dspam_clean
 
 		# Optimize the SQLite tables for DSPAM
-		find "${DSPAM_HOMEDIR}" -name "*.sdb" -exec echo 'vacuum;' \| /usr/bin/sqlite3 "{}" \;
+		find "${DSPAM_HOMEDIR}" -name "*.sdb" -print | while read name
+                do
+                    echo 'vacuum;' | /usr/bin/sqlite3 "$name"
+                done
 
 		exit 0
 
@@ -293,13 +299,19 @@
 		fi
 
 		# Run the SQLite purge script
-		find "${DSPAM_HOMEDIR}" -name "*.sdb" -exec /usr/bin/sqlite "{}" < "${DSPAM_SQLite_PURGE_SQL}" \; 1>/dev/null 2>&1
+		find "${DSPAM_HOMEDIR}" -name "*.sdb" -print | while read name
+                do
+                    /usr/bin/sqlite "$name" < "${DSPAM_SQLite_PURGE_SQL}"
+                done 1>/dev/null 2>&1
 
 		# Run the dspam_clean command
 		run_dspam_clean
 
 		# Optimize the SQLite tables for DSPAM
-		find "${DSPAM_HOMEDIR}" -name "*.sdb" -exec echo 'vacuum;' \| /usr/bin/sqlite "{}" \;
+		find "${DSPAM_HOMEDIR}" -name "*.sdb" -print | while read name
+                do
+                    echo 'vacuum;' | /usr/bin/sqlite "$name"
+                done
 
 		exit 0