Dave Heavy Industries Dave Heavy Industries – blog


NGINX snmp monitoring

So far as I could tell, nginx doesn't provide any stats out to snmp. This is something we like to watch closely so I put together the following based on a script I found here - http://www.kutukupret.com/2011/05/31/how-to-graph-nginx-statistics/




#junipered - to be promised a service or a product that was not delivered
#ciscoed - When you deliver the products and solutions that the customer wants, when the customer wants it.
... apparently.


HTC Desire S Flashing problems… M4G2DE

After a huge amount of effort, lots of "status 1" lots of "can't open /cache/recovery/log " ... I stumbled across this site - http://forum.xda-developers.com/showthread.php?t=1150917


iinet cisco 877 config

This is the config I'm recommending for people running cisco 877's on iinet. feel free to post back with any amendments.
config working on IOS 12.4(24)T3


TPG Username

last one - TPG Usernames for use on dialing up from your router..
should be in the format username@tpg.com.au

Filed under: Uncategorized No Comments


Again, keep getting asked this one, TPG uses PPPoE which works a little differently in terms of MTU and MSS.

I found the best settings for me were
MTU 1492
MSS 1452

on a cisco router this is achieved by

interface Vlan1
ip tcp adjust-mss 1452
interface Dialer1
ip mtu 1492

Filed under: Uncategorized No Comments

TPG DNS Servers

Keep getting asked this one, for some reason.
here they are, the TPG DNS (Domain Name Servers)

Tagged as: , No Comments

Ableton Live 8.2.5 now officially supported on OS X 10.7 Lion

Been asked about this a bit over the last few weeks. It's official.. go forth and update to 10.7


Unable to post link to facebook

Strange one this morning. Our e-comm guys reported they were unable to post any links to their page, their own wall, other peoples walls... anywhere on facebook really. only "The message could not be posted to this Wall." was presented to them as an error.. useful??!?? I think not. After a bit of investigation, I found that it was some pages but not others. The home page for example worked, but a product would not. A content page would, but a category page would not. Ugh.

They all use the same template so I thought surely the html would be very similar... and it was. I ran the pages through the w3c validator, and made a bunch of unecessary changes to do with short-tags and pulled my hair out some more.

A few more coffees and some tweeting and googling brought to my attention that the error "The message could not be posted to this Wall." could be due to facebook blocking that url due to abuse... maybe one of our competitors complained to upset our social strategy? no - then all of the urls would be broken (only lost an hour here :| )

I went back to the HTML, removed anything fancy and it still didn't work. I decided not to let this get the better of me, and I went through the html line by line looking for anything out of the ordinary... and there it was.

Canonical link was missing a slash. <link rel="canonical" href="https:/somedomain.com" />. Now this was set by our e-commerce system, not by the template or development, and none of that has changed for a really long time, meaning that something at facebooks end has tightened up the validation. Anyway, not pointing fingers, commented it out and Posts are now sharing as expected. ugh.




MS SQL Server – index fragmentation – amended

From http://wp.daveheavyindustries.com/2011/02/07/ms-sql-server-index-fragmentation/

Having had to use this on a very large database, I've made some small changes to the index fragmentation statistics script. this time to include table names (object_name) as well as database_name.


Youtube – Embed video on HTTPS site

Ever wanted to embed a youtube video on a https (SSL) site without a security warning?


Operation Parrot Drone – Introduction

Well.. I picked up one of these amazing devices last year direct from china.. Loads of fun. A friend in my building did the same and plenty of dog fights later, we had some engine failures (after discovering the flying just above another drone makes their drown drop to the ground... conflicting altitude sensor??). While they are being fixed... I decided to have a think about what I'd like to get out of the drones...


Distance between two points with curvature

The earth isn't flat. Sometimes you feel like over engineering a simple problem just because you can.

Late last year I put together a mobile web interface and used google maps for a store locator. I also had to use ASP Classic.
In the mids of this it struck me that a customer might find they were a few meters off from the actual distance from their current position, to what I'm reporting. Clearly this just won't do -so I re-worked it to compensate....in ASP CLASSIC, where most of the math is non existent.



3TB Drive Woes

Well, I just started upgrading the first drive in a 4 drive array in a HP AIO storage server. The problem is that the 3TB drive I put in only registered as 768GB, somewhat short of 3TB.


WordPress permalink via SQL

Today someone asked how to get the wordpress permalink from another language via SQL. Well, after a little bit of head scratching I have come up with a relatively easy way of doing this... enjoy!


Joomla / WordPress hosting

I've got plenty of hosting resources spare at the moment, get in contact with me if you'd like any wordpress/joomla sites hosted. Will offer very competitive rates or beer currency for community projects.

Get in contact with me !



MS SQL Server – index fragmentation

Sometimes it doesn't make sense to rebuild all of your indexes as part of a maintenance plan. You may have mirroring running with large db tables, and your indexes may be several GB. As part of your maintenance schedule, I recommend manually finding fragmented indexes and rebuilding them yourself (or scripting this)

To do this you, you need to locate the indexes -- anything over 50% can be considered a problem.