Off doing other things

Well I’ve been busy. I’ve been building an e-commerce website for my wife which has been taking up quite a bit of my time. I’ve also been working on a Wiki, including writing some really complex wiki extensions and I’m now working on a simple Database extension which will allow wiki users to create simple database tables within wiki pages and then query them

So far so good

Well my scripts automatically add the IP address to the .htaccess file if it works out they are spamming.

Blocking a couple of domains in URLS got rid of a lot of crap. Block jo.pl and it will take out a lot of your spam as thats all they seem to host!

All quiet on the Western Front – again

Well the RBLs have trapped a lot of the spammers. Also I’ve put a bit of code in that at the moment is logging the IP of any person accessing the trackback script.

The next step is to take that code and wrap it into the trackback script so that posts containing “banned” words get their IP added to the blocking list.

Well the code is now modified. All trackback posts record the IP of the poster. If the IP of the trackback is in a linked table then the trackback isn’t displayed. This allows me to quickly “block” posts by inserting one IP but leaves the trackback hidden so I can work on it.

Also if I get the same IP posting to the same entry more than once it assumes that it is spam, accepts it (in case it isnt!) and drops the IP address into my spammers table.

Gone away!!

Well after following the instructions here http://www.gotroot.com/tiki-view_blog_post.php?blogId=2&postId=34

I’ve managed to get it so that spammers on my boards get a 403 message.

The only thing I found was that the directives had to go into the apache2 config file rather than the .htaccess file which complained “order not allowed here”. I also adjusted it so that only POST is blocked..

I’m going to run with it for a few days then I’m going to add a couple more RBLs to the list and then I can hopefully put the trackback link back in.

And for those who dont want to down load the whole of the apache source files just to compile this one little bit here is the recompiled mod_access for Apache 2.0.48

http://www.tty.homelinux.org/board/mod_access.zip

Mortgages

If you have done 6 impossible things this morning, why not round it off with breakfast at Milliways

Never, ever, ever try what we have just done.

My previous Blog covered the problems with getting my wife’s name on the bank account. Well to that we had to redo the mortgage because the RBS Current Account Mortgage scheme is now dead and they do “OffSet” now which is basically the same but uses two accounts.

The CAM basically ran the mortgage as a huge overdraft with your account balance being negative. Mind you there was something good about going to an ATM and it saying Your Account Balance is £100,000DR. You May withdraw £400 today

Anyway CAM is dead so we have to set up a new joint account (which was fun) and then redo the mortgage.

So then we get a letter from the Offset Mortgage team asking for EXACTLY the same things as we had already provided for the account (Proof of ID, residency etc.). So I tell them – that the bank, their own bank has all of that so why don’t they try to talking to other parts of their company.

In the Middle of all this process we go off to the USA for Christmas. Bank is happy – they will fax us the paperwork that needs to be signed (as long as we sign the originals when we get home). So we sit and wait for a fax.. it “will be there on Monday”, it doesn’t turn up.

We phone them.. its “on its way”, nothing, we phone again, its “on its way”, nothing.

We phone again. The Offset Mortgage team have cancelled the joint application because “the bank told them it was a single application”.

By now we are both pissed off – we now have two bank accounts : our pay checks are going into the new one BUT everything else (bills etc) is still against the old CAM account… you can just see whats coming cant you?

Angry words are exchanged with the bank. They say that they will process it as a single application and then migrate it to a joint application afterwards. OK I guess thats acceptable. So they fax it through to us and I sign it and fax it back.

Now here comes another curve ball. When I moved to the CAM account my old RBS account was never removed from the system for some reason – it sat in Wigan containing no money but with a £1000 overdeaft facility. We never touched it (~more fool us!). The bank in Gloucester said they would delete it for us.

So the Offset Mortgage team settle the outstanding amount on the CAM and then where do they put the rest of the money? Yup thats right – into my OLD account in Wigan, and not the new account in Gloucester.

So we now have my salary in the new account in Gloucester, some Mortgage money in the old account in Wigan, and the CAM account has GONE with all the bills transferred over to the new account

So there we are in the USA doing digital banking shuffling money round from account to account before they decide the close the old Wigan account (which we can only access via Digital Banking).

To be honest – the Royal Bank of Scotland have been useless. It would have been easier to move to a different bank.. it certainly could be any more difficult. It seems that the Offset Mortgage part of RBS is totally disconnected from the rest of the RBS and they deal with them in exactly the same wasy as they would with another bank.

Crazy, Crazy.

Still I did have fun in the US.. Never eaten Deep Fried Turkey before 😉

Banks

Saturday we went to the bank to put my wife’s name on the account. Can’t be too complicated can it? Can’t take more than a few minutes can it?

BZZZTTTTT – WRONG!!

The bank say that a passport, marriage certificate and payslips (with the same address on as me) are not acceptable as proof that she is who she says she is and that she lives where she says she lives.

To put my wife on the account the bank says it needs a utility bill or a credit card bill with my wifes name on it.

She has none of these – the bills are all in my name as are the credit cards (with her simply having secondary cards).

So for anyone out there who wants to put a partner on the account but she doesn’t get bills – dont try to do it with the Royal Bank of Scotland because its not possible.

So much for customer service

Hackers, crackers and other annoyances

My server was getting swamped the other day, checking into it I found that it was links from LiveJournal to a pic in my photo albums which someone had used to illustrate a tack poem. Livejournal users had then copied this poem round each other, and republished it – and every view was leeching the pic off my server.

Now I guess its a compliment that they liked my squirrel pic but it was used without permission and with no credit.

So I stopped it.. specifically that image cannot be accessed when the referrer URL is livejournal.

So then I started looking round and found lots of attempts to hijack awstats for hacking other servers. So I’ve put in a redirect based on IP to stop this happening.

I also tightened up my SSH logins – and record unauthorised accesses onto that (which populates the website black list).

Today I had some scum from Israel (specifically a user of Barak I.T.C) use a java application to post Viagra spam on my forum. So if you were on 85.65.58.1 a few minutes ago – I saw you, deleted your post and blocked your IP.

Its sad that the internet is now full of people who try to break into, hijack or otherwise misuse other peoples resources.

Still thats the way of the world I suppose.

Oddly enough its THIS blog entry that the spamming scum keep picking on. I wonder why.

Health Service?? Where does the Service come into it?

Saw the doctor the other week about a medical condition and he said he’d contact the hospital.

Letter arrived on Friday – I need to phone the hospital to make an appointment. Wife phoned the number before 5pm – no reply.

I have been trying almost continually for the past 3 hours to get through on their number but it is always busy.

What annoys me is the following statement on the letter:

YOU MUST CONTACT US WITHIN 2 WEEKS. IF WE DO NOT HEAR FROM YOU, WE WILL ASSUME YOU NO LONGER REQUIRE THE APPOINTMENT. YOUR NAME WILL BE REMOVED FROM OUR PENDING LIST AND YOUR GP INFORMED

And yes it really is in bold block capitals.

So they can be snotty with me and then provide a crap booking service.

I pay for this out of my Taxes – surely they can employ more than 1 person to answer the phone (which I think is the ONLY number to book appointments on for the entire Hospital Trust)

Things

Its lunch time – I’m sitting here watching the horses canter round the field and I can see a small group of tourists walking along the top of the Malvern Hills.

Its so much quieter here than in the Birmingham Business Park, the scenery is much better too, and there are several good pubs within a short commute.

So apart from work what have I been doing? Not doing the kitchen renovations if you must know – the disaster that is the window (Thanks a bunch Cheltenham Council for using jerry builders to build the Priors Farm estate) really is a big disincentive. I’ve also been doing some coding on an extension to CanalPlan which should implement social networking, blogging and “tracking”. OK its not going to do all of that to start off with but…

Of course this means me learning how to handle sessions in PHP and interfacing PHP with a Database. Still its all good fun (!).