Safety is paramount

So the Icelandic volcano makes it impossible to fly in UK airspace. Hmm. The idea is that the volcanic ash, containing silica, turns to glass in jet engines and causes them to stop spinning.

Well I wonder how this one’s going to play out? Let’s see…

I’m sceptical that the ash is that much of a threat – jet engines do fly through dusty and sandy air. This dust seems to be fairly well dispersed (i.e. you can’t see it and radar, apparently, can’t see it). But even it does increase the risk, the “safety is paramount” argument just doesn’t hold water. If it really was the primary concern they’d stay on the ground instead of flying. Flying is more of a risk than staying on the ground, whatever the weather. They’re taking a risk by taking off.

So just how much risk is acceptable? Well when balanced against airline profits I’d say quite a lot. The volcano, by all accounts, shows no sign of slowing down and the weather system we have at this time of year aren’t likely to disperse the ash any time soon. Anyone who knows anything about weather isn’t going to put money on it, I assure you.

I’d give it two weeks – I doubt the cloud will disperse but by then the airlines will have put so much political pressure on NATS and the government (before an election) that they’ll decide that safety really isn’t paramount and start flying again regardless.

There’ll also probably be a big row.

There’ll also probably be a big scare as soon as someone finds a jet engine with glass in it, followed by an even bigger row.

Council surveys immigrants for BNP

Your local council is collecting the names and addresses of all non-English residents and passing them on to the British National Party. What a great idea!

That isn’t the intended plan, as far as I know, but most PC councils are doing it in the name of “diversity monitoring” or some such nonsense. Whether this is a justifiable use of taxpayers’ resources is one matter, but the fact remains that the databases they’re compiling will be making it in to the hands of every anti-immigrant group both now in the future. The government can’t keep a database like this secret for long – it requires the cooperation of every single council employee and councillor with access to the data, including the BNP councillors.

I was asked to fill in one such form today, when attending a council Easter-holiday event for kids. My usual response is to refuse to fill in this information on principle and explain, at length, why they shouldn’t be asking. I’ve never had any argument with this approach. Today, when I pointed out that this would tell the BNP where all the Muslims in the area lived, who was in the house and where their kids went to school, one of the ladies with the forms went quite pale.

Digital Economy Bill stitch-up

With any luck, this is the last piece of duff legislation in a long line of duff legislation passed by this partially inept government. It has been rushed through, with more haste than normal. To their eternal discredit the leaders of the Conservative and Liberal parties are complicit in allowing it through.

The only good news is that the tax on landlines has been dropped. This was to “pay for the next generation of Internet provision”, but with no explanation as to why taxpayers were supposed to pay for the infrastructure needed to make the larger ISPs still richer. If there’s a demand for it, the infrastructure will appear anyway because there’s money to be made.

The bad news is that the remainder of the bill is also a joke. It’s to do with protecting the rights of copyright holders (i.e. the music and media companies) by forcing ISPs to police what they’re downloading.

There’s some justice in this, on a theoretical level. ISPs are quite happy to make money from the ‘killer app’ that is media piracy, so they deserve the hassle of trying to clean it up. The problem is, as I need hardly tell you, that it’s unworkable.

The daft idea is to track pirates by their IP addresses. As anyone with an interest in cybercrime will tell you, this just doesn’t work. The criminals obscure their IP addresses, usually by hijacking the IP address belonging to an innocent third party. Under the Digital Economy Bill, it’s the innocent third party that’ll suffer.

There’s also the problem of identifying pirated content. Take it from me, this can’t be done, and the heuristics currently used to detect activity likely to be related to piracy (e.g. P2P protocols) can be rendered obsolete at any time.

Even if you could detect illicit traffic, you can’t possibly pin it down to an individual. Take one trivial example – “mobile broadband”. You can get this by walking into the mobile ‘phone shop of your choice, slapping some cash on the counter and walking out with a cellular modem with an Internet connection that’s completely untraceable. It even gets a different IP address from the service provider each time you turn it on. Are these to be banned? I don’t see it happening.

Pirates could also use one of the many free wireless hotspots found on any high street or hotel. Are these going to be closed down because pirates use them?

So, we have a bill that won’t solve the problem it sets out to tackle but will, instead, result in hassle for the law-abiding innocent computer users who have their IP addresses, and providers of publicly accessible Wifi networks.

You don’t have to be in favour of piracy to regard this latest piece of government nonsense as a very bad thing indeed.

Ted Relf – local hero

Ted Relf from Shadoxhurst (near Ashford, Kent) has got himself into a spot of bother with the local plod. His crime? Well he put up a sign warning people about potholes in the road outside his house.

Potholes are lethal. They’re bad enough in a motor vehicle, but for someone on a bike they’re murderous. If you can see them you swerve to avoid them and hope following traffic reacts accordingly. If they’re filled with water or it’s dark you’ll probably be thrown off, and you have to hope that following traffic will stop.

http://news.bbc.co.uk/1/hi/england/wiltshire/8594682.stm

Mr Relf’s sign was a public service, but according to Kent police, someone complained. Why is it that police and council officials feel the need to act when someone complains? If anything, this guy deserves a commendation protecting the public. Face with a complaint about the warning sign, the police should have told the complainant where to go in stead of wasting time and putting the public in danger by taking action against Mr Relf.

The police claim they’re under-funded; this proves the opposite – they’ve just lost their way.

I wonder if they were acting on orders from the local council, who may not have wanted attention drawn to the quality of the roads.

Microsoft Office Genuine Disadvantage

In April 2008 Microsoft released a ‘needed’ update for Microsoft Office 2003 (and, I believe, XP and 2007). The only purpose appears to be to check if the software installed no your machine is “genuine”, at least as far as Microsoft is concerned.

In typical Microsoft style, it didn’t always work. I’ve noticed it popping up nag screens on machines I know where running genuine software, as supplied by major OEMs. Microsoft famously had the same problem with Windows XP Genuine Advantage, resulting in a certain major mail-order PC supplier’s machines having problems. Microsoft’s servers have also suffered faults, disallowing thousands of copies of their software for no reason whatsoever.

Latterly I’ve come across several machines running Office 2003 having problems. This used to be a worrying nag screen, but in the last couple of weeks I’ve heard about genuine software being deactivated in early April. Whether this comes about remains to be seen!

I’m not clear as to why this is happening. Is it a bad de-install of Office 2007 causing the problem? It seems to affect Vista machines which were pre-loaded with Office 2007 and moved on to site licensed versions of 2003 (because everyone hates 2007). It may also be interference caused by malware modifying Office 2003.

One worrying prospect is that Microsoft is unable to manage licenses for this old product and has simply messed up.

Basically, installing anything that might decide you’re running a pirated software and shut you down is a fundamentally bad plan, and best avoided. If you decline these “needed” updates it will prevent you from installing new features (other than critical security fixes) but you can carry on as normal. The risk outweighs the benefits.

Microsoft’s trend has been to restrict the installation of its software for many years, which is a disaster if it doesn’t work. It’s yet another reason for people to switch to the open source alternatives, such as OpenOffice. The cost of the licenses from Microsoft doesn’t bother me; it’s the risk of the self-destruct code they’re building in. If you’re a large corporation you can probably drag Microsoft in and tell them to fix it pronto, and pay compensation. It’s the small guy’s who’ll suffer.

Sage 2011? Line 50 with a proper database

Today I ran in to my “old friends” Sage at a computer show; they didn’t recognise me and tried to interest me in Sage Accounting for my business. I was wearing a suit, I suppose. As you can imagine, it didn’t take long for them to catch on, after which I turned the subject to the subject of Line 50 using a proper database.

You might have got the impression I really don’t like Sage. That’s not strictly true; the issue is that I really don’t like the idea of Line 50 being sold to SMEs planning to use it for anything non-trivial. Interestingly, the people from Sage agree – at least in private. The database driven version to cure the problemhas been promised for four years, so they’re obviously aware of the issue!

So when’s it coming? Apparently in Sage 2011, due out in August 2010. “Really?” I said. “Yes, definitely. At least that’s the plan”, they said.

I pushed a bit further – would it be using mySQL as promised or would they wimp-out and use the lightweight Microsoft server. I didn’t get an answer, which confirms my fears, but even a Microsoft SQL server is better that the current arrangement.

I tried to discuss the performance issues for people upgrading to Line 50 Version 2010 with them, but I got the impression they were a bit jaded on the subject, and did a very poor job of feigning surprise.

It is safe to allow your kids to use Fronter?

Fronter is Pearson’s commercial LMS; basically Moodle, but you pay lots of money for it. It quite possibly does more, but I’m not in a position to pay for a copy to find out. However, this isn’t a review of Fronter. In fact it applies to the concept of an LMS rather than Fronter, as an instance of an LMS.

An LMS (or LCMS) is a CMS that has been developed, or optimised for learning (hence the acronym). It’s currently being pushed in to primary schools for use by children as young as six, and it’s security is far from certain.

An LMS is also known as Virtual Learning Environments (VLE) in marketing-speak. Ask any academic computer scientist and they’ll tell you Moodle is the one to go for these days. WebCT in the past; but the open source nature and sheer power of Moodle makes it king of the castle – and it’s free. So why does half the world use Blackboard (they purchased WebCT in 2005)? My best guess is that most schools don’t have the technical ability to support anything in-house, and by outsourcing you get a commercial product, sold with smiles and soothing words. It’s just not realistic to expect many primary or secondary education institutions to have the knowledge to manage its own IT – the 20% of the world using Moodle are the clued-up tertiary sector. And the folks able to use Moodle are the same folks that are likely to understand the security implications. Primary schools are unlikely to have security skills in-house, and it’d be surprising to find that level of knowledge in a secondary (high) school either, so in order to use an LMS it has to be outsourced and made simpler.

Enter Pearson with Fronter. Pearson is a large media conglomerate with an education division, best known for brands such as Prentice Hall, Longman, Addison-Wesley. Ah, THAT Pearson. So you can see they’ve got a good ‘in’ to schools, and they appear to be pushing Fronter hard in to the primary sector. It’s being used for children as young as six, and this raises significant questions when it comes to security. Would you let your child use Facebook? Of course not; so why is Fronter, with its social media features any better?

Leaving aside whether it’s appropriate to introduce very young children to any form of social networking, a close look at the security aspects of any LMS is vital. Latterly I’ve been looking at Fronter, and this is used for examples in this article, but the comments apply to any LMS – they can all be configured in a dangerous way.

Fronter is obviously keen to allay concerns, and has just hired Logica (completed March 2010) to get it through ISO 27001. Fronter will doubtless wave this badge around saying “Okay – we’re now safe and secure to international standards”. This will be true, to at extent, but ISO-27001 is so vague it can mean anything. Like ISO-9000, it basically means it can be audited within the parameters set, and potential stakeholders can review the documentation and see if it meets their requirements. Even when these parameters are available, I doubt I’d be allowed to review it (Fronter – are you listening?)

Don’t get me wrong here. I’m not knocking ISO-27001 any more than I’d knock ISO-9000. At least not per se. It’s a framework, and as such, can be used to promote good or to conceal evil. Neither do I question Fronter’s commitment to keep intruders out of its system, if for no other reason than because any breach would have a disastrous effect on its business. I’m as confident as I can be that they’re taking the matter very seriously indeed, as do any other serious LMS developers.

But the developers can’t make an LMS safe. It’s infrastructure might be secure, but its users are always going to be the weak link. Schools really don’t know about who has access to their LMS, or don’t care because it’s too difficult a problem to find out.

When your child reads something posted by another Fronter user, who actually wrote it? Much is made of ensuring that everyone in contact with children has a CRB check, but a Fronter account for a child is given out to its parents with no checks made on them whatsoever.

Have you ever wondered what the likelihood of a randomly selected parent failing a CRB check might be? Well I reckon it’s about 1 in 5; in other words not much better than 50:50 that one adult in the house has a criminal record of some sort. (Figures aren’t compiled; I have extrapolated this from an answer in Hansard 25 Apr 2008 : Column 2328W). Worrying? So How many are likely to be on the “Sex Offenders Register”? Currently the English notification system lists 48,000 adults. It’s widely realised that most don’t appear on this because they haven’t been caught, and dodgy teenagers don’t figure in the stats at all, but certainly exist. Projecting this to working age parents (or guardians) you end up with an average of about three sex offenders being parents at a school of 1000 pupils. In other words, you can say pretty safely that there are probably registered sex offenders able to control accounts on most Infant and Junior schools using an LMS.

This leaves schools with a bit of a dilemma. If parents realised that they children were using a social media site shared by CRB failures and sex offenders they’d insist the plug was pulled. But at the very least, schools need to ask for informed consent from the parents before exposing their children to this risk – or turn off the ability to communicate in the LMS software (the safe option) and simply use it for staff to pupil communication. What schools often claim is that their staff monitor all content and messages. This will be done with the best of intentions, but will it be kept up long-term and how effective will it be on a large volume of traffic? If you’ve ever moderated a forum, you’ll understand the difficulty. However, teachers are smart people and usually have a sixth sense about where to watch for trouble.

Monitoring is undoubtedly good thing compared to a free-for-all, but does fail to address the fact that multiple channels are often used for nefarious purposes. A message posted on the LMS might seem innocuous in itself, but could easily be key part of an external conversation. Anyone who thinks children don’t routinely use code words adults won’t understand simply doesn’t know children.

So far I have considered login details falling in to the lap of undesirable elements via children in the household. But supposing an unconnected local paedophile wished to target a LMS directly. Is this possible? Of course, and here’s a scenario to make the point.

A fair number of schools now use outsourced emailing systems such as ParentMail, inTouch and CallParents to contact parents, and may simply use the mechanism to distribute attached files rather than proper text messages in the email body. Parents tend to trust emails from these services as they believe they know the sender (i.e. the their child’s school), and are conditioned into opening file attachments. It’s trivially easy to forge a ParentMail email, sending any file attachment the attacker pleases. Stealing login-in credentials in such circumstances would be almost child’s play, but if a key logger was too much trouble then a phishing email should work just as well. Assuming some effort is being made to target a child, an email to the parents saying “Please click here to log in to Fronter”, using context information from the school’s web site and parent details from Facebook is trivially easy. I haven’t heard of this happening, but I can’t believe it hasn’t.

Assuming the LMS developer has any sense of responsibility or desire to stay in business, it’s pretty clear that the security measures against infiltration of a LMS such as Fronter depend on policy rather than technology. If children are allowed to exchange messages with each other the only thing that will stop an infiltrator will be the vigilance of the monitoring staff. Supervision whilst using the system, whilst at home and at school, is just common sense. But there are still technical issues to address.

Some LMS require certain insecure features to be enabled on web browsers, such as Java. For security reasons, many people have risky technologies disabled. You certainly wouldn’t allow them in a secure commercial environment, so why take the risk at home? And worse, how much more of a risk is it if you allow a naïve child to use client-side code? Yet this is exactly what schools using an LMS are asking parents to do – drop the security on their home computers to allow access to attractive interactive features. There’s probably little risk that the LMS will contain compromised code unless pupils are allowed to develop their own content, but it’s not impossible especially using a targeted attack.

An LMS is an attractive vehicle for delivering malware for various reasons. In junior schools particularly, the inexperience of the pupils could allow things to be activated that adults would normally be suspicious of. Also, there’s a temptation for the institution to consider the LMS part of the Intranet and give it trusted status on local endpoints, meaning anything injected in to the LMS is likely to run with trusted privileges even when the Internet is locked down. This isn’t logical – if the endpoint is vulnerable to Internet-based web pages and LMS users can upload content, it’s not actually any more secure.

Many LMS allow file uploads for assignment submission, which provides a route to compromise the PCs used by the academic staff. Given that criminals will have access to some pupil’s login details by virtue of the fact they’re also parents, uploading a trojan to a staff computer is a real threat. For example, Fronter reassures users on its web site that uploads are scanned using Clam-AV. Commendable, but they are inadvertently giving the criminals the intelligence needed to bypass this specific scanner.

Another issue with file uploads concerns endpoint security software. If the endpoint has been secured, file transfers from the browser or elsewhere will be disabled. In order to use the LMS, this often has to be globally enabled. For example, using Ranger to block file upload/download dialogues with Fronter appears impossible because it uses the generic object selector. Ranger detects the window title and either blocks it or lets it through for every web site. Discrimination isn’t possible.

Whilst I’ve used Fronter in many of these examples because it is to hand, I am talking about general issues of security when allowing young children to use an LMS. The developers of such systems take good care to make sure the platform is inherently secure, but dangers remain from at least two sources. Firstly, there may be only a thin veneer of control over who has access to the system if pupils have access outside of school. Secondly, in order to run an LMS it is often necessary to disable endpoint security measures in such a way that it becomes venerable to threats from wider sources.

Kay Gilderdale prosecution was right

This is a very sad case. Kay Gilderdale’s 31-year-old daughter Lynn was seriously ill and wanted to end her own life. Her mother supported this decision and provided the means (morphine). When this was apparently not working, she herself injected air with the intention of killing her. Lynn actually died of the morphine overdose, but her mother’s intention was to kill her with the air.

I wasn’t there, and couldn’t begin to judge the rights and wrongs of whether a mother should be helping her daughter to die but I’m sure she had good reasons. These were clearly exceptional circumstances, before and after the jury decided to acquit her.

However, the judge, Mr Justice Bean, questioned the decision to prosecute her for attempted murder in the first place and now the newspapers and politicians are jumping on the band wagon.

I think we need a reality check here.

When someone deliberately kills someone else, or tries to, that’s murder. It’s not for newspapers or politicians to decide. When a murder is committed we have a long-established system where a jury (not judge) decides what should be done about it. On the face of it, the jury has come to a sensible decision; the system works and we shouldn’t be messing with it. All murders should be prosecuted and only a jury should decide if there’s any mitigating justification – not politicians, newspapers or journalists.

Yes, it’s been tough on Mrs Gilderdale and I have every sympathy for her. Perhaps the trial could have been hurried up, to reduce her ordeal. But this doesn’t mean we should be messing with trial-by-jury when someone’s been killed as only a jury should be deciding where to draw the line.

Bugs in IE? Which browser should I use?

Internet Exploder has been hit by the cyber-criminals again. Yawn. Actually, this time it’s serious. It affects all versions of Internet Explorer since six, and it’s going to take Microsoft a while to fix it, and I suspect they won’t for earlier releases (anything less than version eight).

Continuing to use Internet Explorer in the mean time is risky, so using an alternative would be a good idea. But which one?

There are strong opinions as to which browser to use, more often related to the companies that produce them than to their technical merits. In the circumstances I thought a quick guide was in order.

Internet Explorer

Produced by Micro$oft and therefore beyond the pale. Actually, it’s pretty good although slow and cumbersome. It trails behind the others in innovative features. A lot of kid web designers specify that their sites are “optimised” for Internet Exploder, which is a reason to avoid such web sites – or use Internet Explorer. As it comes pre-installed with Windows, it’s the most common web browser out there and is therefore the one attacked most often by criminals. However, I’ve seen no evidence that it’s inherently less secure.

It’s Windows-only, and the current version requires XP SP2 or newer.

Download Internet Explorer if you must

Firefox

This one comes from the Mozilla foundation and is championed by the anti-Microsoft brigade. They claim that Internet Explorer is full of bugs, insecure and bad. Firefox is all of the above, but “good”. More bugs and security problems turn up in Firefox than IE, and it has very regular updates to fix them.

Firefox, like Internet Explorer is big and slow – and some of the versions will cause your PC to grind to a halt. The current release (3.5.7) seems okay, but the writers tend to break it too frequently for my liking.

However, Firefox is on the leading-edge of browser design and pushes forward with useful new features before Microsoft has thought of them. It’s also very good from a security perspective in dealing with encryption and suchlike, and is probably the professional browser of choice for this reason.

Firefox is also cross-platform – available for UNIX, Linux, Windows, Macintosh and so on.

Download Firefox

Google Chrome

This is a wonderful, small, efficient browser from Google. It follows the web standards very well, which means web pages produced to work around problems with Internet Explorer will not look the same on Chrome.

It has one big weakness: it will remember web site passwords, but not in a secure way. Therefore don’t use Chrome for logging in to anything secure. I do hope they’ll fix this soon, but it’s taken a long time.

Download Chrome

Opera

If you like Norway, you’ll love Opera. It’s available from Windows, Mac, Linux, Nintendo Wii and various handheld devices. Its users seem to like it, although it doesn’t have a significant desktop market share except on the Macintosh. I haven’t tried the latest version as I’m happy with Firefox and Chrome, but it’s worth a look if you’re not.

Download Opera

Safari

This is written by Apple and only runs on a Macintosh (or iPhone &c). I would mention the fact it’s proven pretty insecure, but that would upset Mac aficionados, who don’t take such criticisms seriously anyway.

Summary

They’re all insecure. Take your pick. Just avoid IE for a month or so, and be careful if you have to use an earlier version as they might not get around to fixing it.

Why is Sage Line 50 so slow?

NB. If you want to know how to make Sage run faster click here for later posts, and read the comments below (there are a lot!).

As regular readers will know, I don’t think much of Sage accounting software, especially Sage Line 50. It’s fatally flawed because it stores its data in disk files, shared across a network using a file server. I suspect these.DTA files are pretty much unchanged since Graham Wylie’s original effort running under CP/M on an Amstrad PCW. There is continual talk that the newer versions will use a proper database, indeed in 2006 they announced a deal to work with mySQL. But the world has been been waiting for the upgrade ever since. It’s always coming in “next year’s” release but “next year” never comes.The latest (as of December 2009) is that they’re ‘testing’ a database version with some customers and it might come out in version seventeen.

In fact it’s in Sage’s interests to keep Line 50 running slower than a slug in treacle. Line 50 is the cheap end of the range – if it ran at a decent speed over a network, multi-user, people wouldn’t buy the expensive Line 200 (aka MMS). The snag is that Line 50 is sold to small companies that do need more than one or two concurrent users and do have a significant number of transactions a day.

So why is Line 50 so slow? The problem with Sage’s strategy of storing data in shared files is that when you have multiple users the files are opened/locked/read/written by multiple users across a network at the same time. It stands to reason. On a non-trivial set of books this will involve a good number of files, some of them very large. Networks are comparatively slow compared to local disks, and certainly not reliable, so you’re bound to end up with locked file conflicts and would be lucky if data wasn’t corrupted from time to time. As the file gets bigger and the number of users grows, the problem gets worse exponentially. The standard Sage solution seems to be to tell people their hardware in inadequate whenever timeouts occur. In a gross abuse of their consultancy position, some independent Sage vendors have been known to sell hapless lusers new high-powered servers, which does make the problem appear to go away. Until, of course, the file gets a bit bigger. Anyone who knows anything about networking will realise this straight away that this is a hopeless situation, but not those selling Sage – at least in public.

One Sage Solution Provider, realising that this system was always going to time-out in such circumstances, persuaded the MD of the company using it to generate all reports by sitting at the server console. To keep up the pretence this was a multi-user system, he even persuaded them to install it on a Windows Terminal Server machine so more than one person could use it by means of a remote session.

If that weren’t bad enough, apparently it didn’t even work when sitting at the console, and they’ve advised the customers to get a faster router. I’m not kidding – this really did happen.

The fact is that Sage Line 50 does not run well over a network due to a fundamental design flaw. It’s fine if it’s basically single-user on one machine, and I have clients using it this way. If you want to run multiple users, especially if your books are non-trivial, you need Sage 200/MMS – or a different accounting package altogether.