A blog about security, politics and coding in the hacking culture

I assume you've got a working configuration for any roadwarrior such as your laptop, so I explain only small adaptions. Anyway, for a basic configuration, see http://www.scribd.com/doc/8142908/pfSense-OpenVPN-Tutorial

The setup has been tested with a nexus one running Froyo (FRF91) and Cyanogenmod 6 RC3 and PFSense 1.2.3-RELEASE nanobsd on an ALIX board

Let's start with the PFSense box:
Check LZO Compression #for a slight better performance

Under "Custom Options"

add push "redirect-gateway" #since Cyanogenmod OpenVPN integration has problems with doing this itself…

Now to the Device (all options have to match the ones chosen on your pfsense wall, i think that's self-evident):
Under "Advanced" (press the menu button) choose the following:

Device to use: tun
LZO Compression: true
Redirect Gateway: FALSE #pfsense pushes this option to us
Cipher Algorithm: AES-256-CBC #since my uplink is 1Mb/s it doesn't really matter that I use something really secure, crypting on my nexus1 will do that with ease
Size of cipher key: default

Recent Versions (>=6) of Cyanogenmod and others already include the tools mentioned below, Check that before reading.

Please setup your SDK correctly e.g. w/ this guide:Installing the SDK
There are some Apps preinstalled on the Android Emulator that comes w/ the SDK which you don’t find on the Froyo image or in the Market.

Start an Emulator Instance and connect your phone in USB-Debugging mode.

“Dev Tools” (Developer.apk) [set of tools to view network usage, connections to google servers, view packages install. locations and a whole lot more!]
“Spare Parts” (SpareParts.apk) [gives you very detailed info about battery usage of specific hardware and lets you adjust the system's animations]
“Custom Locale” (CustomLocale.apk) [quickly fake your locale setting]
“Speech Recorder” (SpeechRecorder.apk) [no guess...]

Ok, so here’s how to get those tools on your device:
Connect Your Android Dev phone via USB and boot the emulator;
run the following bash one-liner:

for file in "SpeechRecorder.apk" "CustomLocale.apk" "SpareParts.apk"; do adb -e pull /system/app/$file; adb -d install ./$file; done

With this simple line condition in OpenOffice base’s hsqldb it is possible to subtract a date fragment, and in order to this, select the matching entries. My example is a query on a column containing birthdates in the german format DD-MM-YY.

It selects the entries (persons) who are under the age of 20.

SELECT “birthdate” AS “Birthdate” FROM “under20″ AS “under20″ WHERE (datediff(‘yy’, “BIRTHDATE”, CURRENT_DATE)) <= 20

Instead of  ‘yy’ it’s possible to take the following other values:

‘ms’=millisecond

‘ss’=second

‘mi’=minute

‘hh’=hour

‘dd’=day

‘mm’=month

The following script will give you a user agent randomly out of a big list of all user agents that exist.

1
2
3
4
5
6
7
8

#!/bin/bash
 
userAgents=`curl -s http://www.user-agents.org/allagents.xml | grep -B 5 '<type>B</type>' | grep '<string>' | cut -c 9- | sed 's/..........$//'`
maxLines=`echo "$userAgents" | wc -l | tr -d ' '`
randomUserAgent=$(echo "$userAgents" | sed -n $[ ( $RANDOM % ( $[ $maxLines - 1 ] + 1 ) ) + 1 ]p)
 
echo $randomUserAgent
</string>

The script searches for a type “B” in the xml document, which stands for Browser, if you want to include other types, write the letter in place of, or with one space seperated from “B”. It’s possible to specify more than 2 types.

B = Browser
C = Link-, bookmark-, server- checking D = Downloading tool
P = Proxy server, web filtering
R = Robot, crawler, spider
S = Spam or bad bot