phpBB 3

Michael Dale

phpBB3 is finally out.

SQLite is a pain

Michael Dale

SQLite is a pain to work with.

The problems I'm having:

• Where are the DATE functions!?


• Why can I not modify a table stucture with the MODIFY command!?


• Why don't LIMITs work on deleting and updating!?

Such a pain.

The only good thing about SQLite is that it just comes with PHP5 and you don't need to install anything.

MySQL has been working perfectly as usual.

Bluetrait Event Viewer 1.5

Michael Dale

Bluetrait Event Viewer (BTEV) is a plugin I wrote for WordPress that adds an event viewer similar to the one found in Bluetrait 1 and 2.

BTEV has just been updated to version 1.5.

Version 1.5 now includes an auto prune function to remove old events.

BTEV seems pretty popular, it has almost reached 700 downloads off the WordPress site.

Plugins

Michael Dale

I'm slowing building up a collection of plugins I've written for Bluetrait...

Mac Mini

Michael Dale

I got a Mac Mini for my birthday on the 21st. Specs:

Core 2 Duo 1.83GHz

1gb Ram

80gb HDD

Leopard.

It's awesome! I'll post some pictures later.

Creating a VIP in a different subnet

Michael Dale

Recently the company I work for got another subnet to use, let's call it b.b.b.0/24 (and our current one is a.a.a.0/24).

We want to use this subnet to create more VIPs (Virtual IPs).

So we currently have:
a.a.a.2:80 -> 10.0.0.2:80

We wanted to add:
b.b.b.2:80 -> 10.0.0.3:80

Unfortunately trying to do this via the standard method fails with this error:

With the help of the juniperforum website a way was worked out.

Steps:

1) Make sure the new subnet is routed to your netscreen (in this case to our untrust int)

2) Create a new policy from UNTRUST to UNTRUST (yes this is not a mistake) with the following details:
Source Address: ANY
Destination Address: The external IP address you want to use i.e b.b.b.2
Service: The service you want
Under the advanced settings:
Enable Destination Translation
Translate to IP 10.0.0.3


3) To create more services to the IP address simply add another policy with the "Service" and "Translate to IP" details changed.

Note: This method mostly acts like a normal VIP. The only thing to look out for is that requests from the TRUST zone won't be translated.

More details can be found in the forum thread here.

Bluetrait Search 1.0

Michael Dale

I've made public the search plugin I wrote for this site.

It can be downloaded from here and is under the "Creative Commons Attribution-ShareAlike 2.5 License".

The plugin requires Bluetrait 2 and MySQL.

It probably won't be any use to anyone as Bluetrait 2 isn't even in Beta yet ;)

The problems with PHP

Michael Dale

The problems with PHP

Defensio

Michael Dale

Defensio is an anti-spam service very similar to Akismet, except that they provide in depth spam statistics for your website.

I've just written a basic Defensio plugin for Bluetrait 2 and am giving it a test.

It looks pretty cool!

Categories

Michael Dale

Well I can finally edit posts :)

So I'm slowing going through my old posts and adding some categories to them.

I need to add some more categories but I can't do that yet :p