XMLRPC Generator Available

The Airbana XML RPC Generator is now available here.

Site operators who don’t want to program an XML formatter for entries in their DB (or don’t have a DB backend) can add upto 4 prices (although the format is quite simple to add more) and then click the green ‘Go’ button.

Simply copy and paste this text into a file called XMLRPC.php and drop it into the root directory of your website (the same place where the index.html / index.php is).

Airbana Infrastructure

There have been several queries recently regarding the infrastructure of Airbana and to save people the effort of pulling the browser side code apart I’ve put together this quick post.

Hardware

All Airbana Servers are running as follows:
Intel Core 2 Duo’s
2Gb of RAM (Web Servers)
4Gb of RAM (DB Servers)
RAID 1 SATA Disks

Software

Dynamic content servers
CentOS 5.2
MySQL 5.0.45
Apache 2.2.3
PHP 5.1.6

Static Caching Servers
Windows Server 2008
IIS7

Network Infrastructure

The network at the Data center
Cisco 6509
Foundry ServerIron Load Balancer
Multi Gigabit Peers with Linx, Tiscali and Level3

Layout

It wouldn’t be a blog post without pictures:

Version 3 How-To & XMLRPC

With the core features of Version 3 complete the How-To section has been updated to show the new features and usability of Airbana.

The first draft of the XMLRPC help has also been published.

The API Help and examples is still being written as it is quite indepth and some features / function calls have changed since it was drafted.

8 days to go and counting!

Airbana Version 3 Preview

Version 3 of Airbana is drawing closer to release (On target for 1st July 2008!) but I thought a quick ‘preview’ of the new design might liven this blog up a bit.

As you can see I’m making much better use of the screen and the new design now squeezes into lower resolution browsers.

As part of the Version 3 release I’ve done away with Registering as the feedback received indicates that more people would participate in the site if they didn’t have to give personal details.

You’ll still have access to the SMS features but you will only be able to send a limited amount per day per phone number to keep my costs down.

All sites will now be editable and the Wiki will feature edit history and entry rollback functionality.

There are lots of other interesting additions and tweaks coming not least of all is the final release of the Airbana Advanced Programming Interface (API) which will allow other sites / widgits etc to access and utilise the Airbana database.

Attempted Defacement Attack

Since the site went live several months ago it has been subjected to several ‘attacks’ most are the usual assortment of SQL injection worms etc but there have been several manual probes which have consisted of URL manipulation, POST injection etc.

Thankfully none of these have succeded as the code is pretty sturdy and validates all input and ensures that all parts of an AJAX request or a POST follow a very strict set of rules / process precedant.

Today at around 18:20 someone started poking around the site, loading up the interactive parts of the site. Then they started trying to manually call AJAX functions or inject SQL statements here and there (mainly geared around deleting the sites they had been playing with earlier).

5 minutes later an automated script started hammering the Wiki sections of 40% of the sites on record (the sites targeted earlier were part of this). The script added either complete jibberish or an offensive message.

Because of the potential for this sort of activity a script I’ve come to call the ‘Oversight monitor’ triggered and sent me a text, thankfully I’ve cleared up the DB and have temporarily removed the vector this person was using.

You can still edit the Wiki sections via the Map interfaces as these use Javascript functionality that is considerably harder for scripts to mess with.

It looks like I’m going to have to add Captchas or some other method to prevent this sort of thing from happening again.