This script takes no input, recurses the known h-sphere table relations, looks for rows which do not have matching parent_child.child_id, outputs detail and overall stats at…
This script takes a h-sphere account_id and attempts to recurse the entire parent_child tree and fetch data from known associated tables. The list of associations is not complete but easily edited. Called with beast.php?account_id=123. It is intended only to give insight and a quick view of the H-Sphere account and associations.
Provides a HTML/Jquery/DataTables display of all H-Sphere email resources for a given account_id, call via https with script.php?account_id=123
Unwrap SSL http(s) communications using sslsplit and hosts file; for development / niche purposes only.
I route all of my non-work related home internet connectivity via an external jurisdiction (pfSense, openVPN and VPS based) which is great, however Amazon Video and Netflix traffic is significant and I don’t wish to abuse my “fair use” of the virtual server provider when the traffic is all SSL by default / only associates my connection as a user of Netflix. I use the following domains (pfsense host alias) and netblocks (pfsense net alias) to add custom routes to exclude Netflix traffic from the default route / going over VPN, but you can use the same list to include your traffic to VPN endpoints in other geographic regions.
Many members of parliament.uk choose to host their websites outside of the UK (or blindly follow their political parties choice of provider), I look at who they are.
As the subject suggests after parsing parliament.uk for a list of all MP websites and twitter accounts, I performed DNS queries against each websites domain…
I needed to get a list of all websites for UK members of parliament and have it update reasonably frequently / ability to repeat.
http://www.parliament.uk/mps-lords-and-offices/mps/ lists all the current members so a simple PHP script was written using http://simplehtmldom.sourceforge.net/ to parse the list of members, fetch each member profile and parse the name, website and twitter handles.
This script in all it’s hackyness may be found below (best run via php-cli to minimise timeout or memory issues) and example output at http://slog.carlheaton.co.uk/list-of-all-uk-members-of-parliament-name-website-twitter-handle/
Parsed contents of http://www.parliament.uk/mps-lords-and-offices/mps/ to CSV for name, website, twitter as of 2016/11/11.
Yorkshire Water supplied me some useful information for those interested in the technology, protocols and security / opsec about their automated meter readers / AMR devices, which can be found below.