Archive for the ‘Life’ Category

On Thursday, 1 December I received a letter from my letting agent, Walker Singleton, stating they would be terminating my tenancy because they had to sell the apartment on behalf of the mortgage company. I was shocked and alarmed at the idea of having to leave me home, so I phoned their office. Multiple times. They never answered.

I eventually managed to speak to them the next day, and said that if they had to sell the apartment, I would just buy it (at the asking price!), it would be cheaper for them, it would be cheaper for me, no one would have to move, everyone is a winner.

They said no, claiming they had to sell it with vacant possession, and if I wanted it I would have to move out, wait for it go on the market, then buy it and move back in.

I went away and discussed this with a few people, and it didn’t make sense to any of us. So on the Monday I rang them back and explained to them the situation in more detail, and that HSBC had said they would give me a mortgage, so this really was an easy win for the both of us.

They said no. I asked why repeatedly but they wouldn’t give me a straight answer, just saying they couldn’t do it. I then asked if I could speak to the owner of the property, or the mortgage provider. They said that wasn’t possible, but wouldn’t explain why.

So I went to the Land Registry and got the title register for the property and found that the lender was Mortgage Express. So I phoned Mortgage Express and they put me through to Possessions. Possessions said they hadn’t taken possession yet, so I would have to speak to Late Arrears. So I phoned their help desk back again and asked to be put through to Late Arrears.

They said they couldn’t discuss anything to do with the property other than to confirm that someone had a mortgage on it, but because I wasn’t the account holder I wasn’t allowed any further information.

I also tracked the guy down on LinkedIn

Hi Richard,

I’m a tenant of yours, currently living at an apartment you own – Crown Street Buildings in Leeds. I’m just looking for some more information about what is going on, as I’ve been served an eviction notice.

Best wishes,
Chris Worfolk

He never got back to me.

So now I’ve moved out and everyone seems to have come away with a loss. Bad times.

Archive is a cool MySQL storage engine designed for fast inserts. In fact, it’s so optimised for this that it actually only supports INSERT and SELECT – you can’t run UPDATE or DELETE commands against it at all.

This is a problem when developing though, as you’ll often want to empty out the table and start again. But because it doesn’t support delete operations, it won’t actually let you truncate the table! So to answer the question posed in the article title – you can’t.

Therefore, you have two options.

Firstly, you can drop the table and re-create it. This is the recommended way from MySQL, so make sure you have a copy of the table creation command handy.

The second option, the lazy hacky way if you will, is to change the table storage engine over to InnoDB or MyISAM, truncate the table, and then turn it back to ARCHIVE ;).

Tail is a useful command which allows you to see the end of a file. This is probably most commonly used when you want to look at log files as the entries of most interest are usually at the bottom. For example, if you wanted to view the last 50 lines of a log file you could use the following command.

tail -n 50 filename.log

A cool feature of tail is that you can also follow a file – that means continually monitoring it as changes come in. So if you are looking at the Apache error log for example, you could begin tailing the log and then cause an error and you will see it instantly come through on the log.

tail -f error_log

This month’s Wendy House represented the last Wendylicious that would be taking place at Apartment 31, given we were moving out a mere three days afterwards. Sad times indeed, but enough time at least to squeeze one more night of partying in.

Need to get a list of all the PHP scripts currently running? Actually, this technique works for everything, you just need to change the argument you pass to grep, but for the purpose of this example, I’m going to say we’re looking for PHP scripts.

ps aux | grep php

This will then produce a list of all the scripts. The ps aux command gives us a list of every processing running on the system. We then pass this through to grep and search for what we want – in this case processing which contain “php”.

I love my Moomins Valentine’s card :D.

I would have written a guide on how I did this, but the blog post over on If Not True Then False covers it perfectly, so just go over there and follow their guide.

Having decided it had been far too long since we last had a house warming, there was really only one thing we could do to fix this – move. So this is our new place. Actually, it isn’t, but ours is almost identical to this one, but with nicer carpets and air conditioning.

If you’re wondering why the photos are rubbish quality, it’s because they were compressed into GIF accidentally and then re-compressed to JPEG. I could redo them, but I have more important things to do.

If you need super quick access to a file, for example a log file which isn’t going to be too big but it being used by a script which is time critical, then rather than writing it to disk, you can mount part of your file system in memory and write to it there.

This has the disadvantage that when you restart your system, you will lose the data. But for test scripts, logs or other temporary files that you don’t mind getting lost, it can really speed up performance.

Luckily, most systems come with a an area mounted in memory already – so you don’t even need to configure it!

cd /dev/shm

If said directory exists, you’ll have a memory mounted directory already and can start using it immediately.

If you want to put custom entries in your computer’s DNS (for running addresses for a local server for example) you need to edit your system’s hosts file. On Unix systems this can be found at:

/etc/hosts

On Windows systems, you need to go to:

C:\Windows\system32\drivers\etc\hosts

To add a custom entry, first enter the IP address (if you’re running a local server you’ll want to set this as 127.0.0.1), then put a tab and then the host name.