JF's log

I made a little plist that clears out my consolidated.db on my (jailbroken) iphone.

Steps taken:

1. connect to the iphone using ssh:
   1. $ iproxy 2222 22
   2. $ ssh mobile@localhost -p 2222
   3. enter password
2. become root
   1. $ su -
   2. enter password
3. go to the correct directory for launchdaemons
   1. # cd /Library/LaunchDaemons
4. create a plist
   1. # nano eu.bethlehem.eu.cleartrackingdb.plist
5. copy the code below into the plist
6. add the plist to the launchcontroller
   1. # launchctl load eu.bethlehem.jf.cleartrackingdb.plist

All done

Code for in the plist:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>Label</key>
<string>eu.bethlehem.jf.cleartrackingdb</string>
<key>ProgramArguments</key>
<array>
<string>/usr/bin/sqlite3 /private/var/root/Library/Caches/locationd/consolidated.db 'DELETE FROM celllocation;vacuum;'</string>
</array>
<key>StartCalendarInterval</key>
<dict>
<key>Minute</key>
<integer>60</integer>
</dict>
</dict>
</plist>