Author: Jason

  • FreeTDS is a bag of razorblades use, Microsoft ODBC Driver for Linux instead

    According to @mst FreeTDS is a bag of razorblades.
    That’s right folks, don’t use it. The new way to go is Microsoft ODBC Driver for SQL Server on Linux.
    Unfortunately its a nightmare to install on debian. Luckily some very smart people wrote a lovely little howto: Install and Configure the MS ODBC Driver on Debian.

  • BPay View feedback

    Dear CommBank,
    While I think NetBank is great, the BPayView part seriously lets it down. I tweeted my feelings about this and you asked for feedback, so here it is:
    1. It silently lets the biller prevent you from viewing older bills. eg. I cannot view Sydney Water bills older than 6 months. but you don’t know this until you try to view the bill, you seen the “This bill is unable to be opened at this time.” and then you call tech support and they inform you that Sydney Water prevents bills older than 6 months from being viewed.
    2. It auto archives bills after 18 months. This should be at least 2 years if not 7 in my opinion
    3. if you open a bill and try to save the PDF, the PDF is not named something sensible so you can quickly save it and move on to the next bill, making saving bills a tiresome slow process.
    4. There should be an option to email the bills to you as a PDF as and when they become available.
    5. The archived bills view is useless a it does not show the date of the bill or anything useful about the bill except the amount. This is maddeningly annoying.
    6. You cannot open archived bills. well this wouldn’t be such a problem if points 2,4 and 5 were taken care of.

  • Letter to the minister for small business about slow Internet in Australia

    Today I wrote to the minister for small business complaining about the crap Internet in this country. I urge you to write to your MPs also if you think the lack of NBN is a problem.

    Dear Mr Billson,
    I’d just like to express my concern over the woeful state of Internet in Australia.
    As a small business owner, I’m finding it prohibitively expensive to get a decent Internet connection for my business and since the government scuttled the NBN its looking increasingly like fast Internet is basically only for big businesses or people with a lot of money.
    Please can you do something to get cheap fast Internet for small business?
    I did write to Mr Turnbull about this and the best he could come up with was to blame Labor. I’m sick of hearing excuses. I need action in order for my business to remain viable and continue providing employment to Australian Tax Payers. Fast and cheap Internet is part of what I need to do that.
    Thanks for listening

  • Clock Part 3

    Clock Part 3

    I finally finished the outer case of my clock. Only 19 layers of 3mm acrylic stacked on top of each other.

    IMG_5445
    Laser cutting the rear panel and finger slot
    red perspex box with clock electronics showing, rear lid off
    Rear panel with finger slot and barrel jack holder
    rear panel of clock with wire going into the finger slot
    Barrel Jack inside the finger slot

    I built a finger slot into the back of the clock so it’s easier to carry, but also to house the barrel jack for mounting the clock flush to the wall, allowong me to hide the power cord in the wall (oneday)

    pile of acrylic sheets neetly lined up
    This is the pile of acrylic I had to cut out of the inside of the clock.

    That pile on the left was cut out to make the cavity in the case.

  • Clock Part 2

    Previously…
    A bit more progress on my clock. I installed the dirty pink gel filter to increase the contrast ratio of the 7 segment displays, and started cutting the final case out of red 101 acrylic. Lots of laminations.

    a digital clock showing the time of 11:22
    Clock

    side of digital clock showing laminations of the case and the inner electronics and wires
    Side of clock

     

  • Launch emacs from cygwin

    Launch emacs from cygwin

    I have written about about using emacs in cygwin and how to launch emacs from cygwin, but I had some problems with the batch file approach in that emacs’ path differ from bash’s. Then ack fails to work from within emacs which makes me sad.
    After googling around a bit, I saw a few suggestion that trie to fix the path in emacs, but I think a better approach is to launch emacs from within bash so it inherits the bash environment.
    Here is my attempt using vbscript:

    Dim WinScriptHost
    Set WinScriptHost = CreateObject("WScript.Shell")
    strCmd = "C:\cygwin\bin\bash --login -c '/usr/local/bin/emacsclient -c -a /usr/local/bin/emacs.exe"
        If WScript.Arguments.Count = 1 Then
            'strCmd = strCmd & " " &"""" & WScript.Arguments(0) & """'"
    		wScript.Echo strCmd
    	else
    		strCmd = strCmd & "'" 'close single quote
        End If
    WinScriptHost.Run strCmd,0
    Set WinScriptHost = Nothing

    Save that script somewhere and then make a Windows Shortcut to it but incle the wscript.exe in the target:

    C:\Windows\System32\wscript.exe C:\Users\jason\launchemacs1.vbs

    You can then launch it from the Start Menu in Windows 7.

  • I wrote to Turnbull to complain about the lack of NBN. Here is his reply

    After traveling to New Zealand for #lca2015 and experiencing fibre to the home at my friends house, I decided to write to Malcolm Turnbull to express my concern about the slow rollout of the NBN in Australia.
    He actually personally replied directly to my email only 4 hours later. In the interest of openness I am putting the whole email below. I have rearranged it to fix the topposting.
    The tl;dr is “It’s all Labor’s fault”
    My email to Mal. (I think we can say we are on first name terms now)

    From: Jason Lewis
    Sent: Tuesday, 20 January 2015 1:52 PM
    To: Turnbull, Malcolm (MP)
    Subject: NBN Roll-out
    Dear Mr Turnbull,
    I’m writing to express my concern with the woefully slow roll-out of the
    NBN.
    I’ve recently been travelling in other countries where fibre to the home
    is already commonplace and it makes the Australian broadband offering
    feel terribly inadequate.
    I feel this will lead to a further reduction in Australia’s
    international competitiveness.
    Please devote more resources to speeding up the roll-out.
    Thanks,
    Jason

    And his response:

    Dear Jason,
    Thanks for your candid comments.
    Unfortunately Labor significantly underestimated the cost and complexity of this project and, as a result, released rollout schedules that were unrealistic and inaccurate.
    For instance, Labor originally forecast that 2.7 million houses would be passed by fibre by 30 June 2014. In NBN Co’s last Corporate Plan released in August 2012, it was revised to 1.3 million houses passed by fibre. The comprehensive Strategic Review completed in December 2013 however, found that the NBN would only pass 467,000 houses with fibre by 30 June 2014. The actual number reached by 1 July 2014 was 492,000 premises – less than one-fifth of the original target.
    I highlighted the problems which Labor created with their false rollout expectations in a recent blog available here: www.malcolmturnbull.com.au/media/trying-to-make-sense-of-the-confused-and-confusing-mr-clare1
    In addition, the Government recently undertook a Broadband Availability and Quality Report, which found that there are more than 1.6 million premises across Australia with very poor or no fixed broadband access at all. However, Labor made no effort to prioritise these areas in their rollout.
    The Government has instructed NBN Co to revise its current rollout schedule to meet three key objectives:

    1. To ensure that the underserved areas in Australia are prioritised in the NBN Co rollout. On average, areas with very poor broadband will receive upgrades two years sooner.
    2. To ensure that the NBN upgrades are delivered sooner and more affordably, by using a mix of technologies. The Strategic Review found that under the model adopted by the Coalition, the project will be finished four years sooner than would have otherwise been the case.
    3. To ensure that information provided in the public domain is accurate and can be relied upon by businesses and households waiting for broadband upgrades.

    The fact is that the NBN, up to the election, had reached only three per cent of Australian premises after four years and $6.4 billion of funding.
    NBN Co is now determining which technologies are most cost effective and should be utilised on an area-by-area basis so as to minimise peak funding, optimise economic returns and deliver broadband upgrades sooner. This is highly demanding and complex work which involves renegotiating deals with Telstra and Optus to take over portions of their fixed line networks. Naturally this is taking time to complete.
    In the meantime, NBN Co has continued to expand its fibre network in areas where construction contracts had been signed at the time of the election. Across the country, more than 500,000 premises have been passed by NBN fibre and work is underway to extend the network to reach a further 600,000 premises.
    Sites that are not currently represented on the NBN Co maps are being reviewed in line with rollout priorities. Importantly, the network will continue to be built on a state-of-the-art platform, but will use existing infrastructure where it makes sense to do so. In areas where work has not commenced, NBN Co will be making decisions about construction on the basis of review findings. NBN Co is significantly advanced in planning the multi-technology mix and rollout plans will be publicly released once they are completed. More information about the NBN rollout will be published by NBN Co on its website www.nbnco.com.au when it is available.
    You may also be interested to know that the Government has secured the progressive transfer of the necessary parts of Telstra’s copper and HFC (pay TV) cable networks to NBN Co at no additional expense. Telstra’s 1.4 million shareholders have been ‘kept whole’ in keeping with the Government’s pre-election commitment.
    These agreements are a key milestone in shifting the NBN to the Multi Technology Mix the company has determined is its optimal strategy. The December 2013 Strategic Review found the shift to a multi-technology NBN will reduce its cost by $30 billion, and save at least four years in construction time.
    Importantly, under these agreements, NBN Co will make use of Telstra’s copper and HFC networks (i.e. the network used to deliver pay television) rather than decommissioning and wasting these assets, as Labor had planned.
    Yours sincerely,
    Malcolm Turnbull

  • #lca2015: Using FOI to get source code

    Michael Cordover has spent significant time and money chasing down the code used for counting Australian Election results. He goes into the reasons why that is important. Another great talk from #lca2015.

  • I just donated to Wikipedia

    After reading a blog post from someone who donated to Wikipedia because they use it a lot, I realised I use it a lot too, so I decided to donate too. Unfortunately I can’t quite remember who’s post it was, but thank you whoever you are!
    I donated $30. You should too if you like Wikipedia, and you use it.

  • Apache [warn] RSA server certificate CommonName (CN) does NOT match server name!?

    Apache was giving me lots of errors like this on my host that has multiple virtual hosts on it.

    [Mon Nov 10 13:54:01 2014] [warn] RSA server certificate CommonName (CN) `www.xxx.com.au' does NOT match server name!?
    [Mon Nov 10 13:54:01 2014] [warn] RSA server certificate CommonName (CN) `www.yyy.com.au' does NOT match server name!?
    [Mon Nov 10 13:54:01 2014] [warn] RSA server certificate CommonName (CN) `www.zzz.co.uk' does NOT match server name!?
    [Mon Nov 10 13:54:01 2014] [warn] RSA server certificate CommonName (CN) `www.cocolo.com.au' does NOT match server name!?
    [Mon Nov 10 13:54:01 2014] [warn] RSA server certificate CommonName (CN) `www.aaa.com.au' does NOT match server name!?
    [Mon Nov 10 13:54:01 2014] [notice] Apache/2.2.22 (Debian) PHP/5.4.4-14+deb7u14 mod_ssl/2.2.22 OpenSSL/1.0.1e configured -- resuming normal operations
    

    After a little investigation it turned out the CN in the certificate was set to www.domain but the vhost’s ServerName was set to www-less.
    The solution turned out to be to ensure the vhost ServerName == the CN in the certificate. You can examine certificate with:

    certtool -i < domain.cert

    And in the vhost, make sure there is a ServerAlias for the www-less version:

    ServerName www.domainname.com.au
    ServerAlias domainname.com.au
    .
    .
    .
    
    

    a few less warnings in the logs now. Phew!