Using Percona Toolkit on a remote MySQL server via SSH tunnel

The easiest way to install Percona Toolkit on MacOS is via brew:

brew install percona-toolkit

Create an SSH Tunnel to the MySQL database server, assigning it to local port 3307 (this could however be any unused port):

ssh -fNg -L 3307:127.0.0.1:3306 <user>@<dbserver>

Test the MySQL connection via the newly created SSH tunnel:

mysql -h 127.0.0.1 -P 3307 -u<user> -p

In order to remove the SSH Tunnel, find the process running with port 3307 (or which ever port you used during the tunnel creation):

ps aux | grep ssh

Now attempt to kill the process:

kill <id>

If this doesn’t work, and only as a last resort, use the -9 flag:

kill -9 <id>

Communicate with intelligence using this satellite dish prop

Qty Description Cost
1 Universal Solid Metal 60cm Digital Satellite TV Dish £14.99
1 USB 2.0 panel mount (Female A socket) £1.90
1 Aluminium die cast metal case (92.5×38.5x31mm) £3.93
1 Data storage module £0.90
1 Black rubber anti dust USB plug £0.14

Total Cost: ≈ £22.00

Building on the technology developed for the HDD units, this satellite dish provides a unique objective with some degree of interactivity. The base satellite dish used here has been modified to be self standing, rather than wall mounted.

As often is the case, two of these were made at the same time to reduce the overall cost of each item, resulting in producing both for around £50 (including the additional cost of paint not mentioned above).

Continue reading “Communicate with intelligence using this satellite dish prop”

Cache in on these USB driven Hard Drive Disk (HDD) replicas

Qty Description Cost
6 Aluminium die cast metal case (112x61x31mm) £4.00
6 USB 2.0 panel mount (Female A socket) £1.90
1 A4 Sheet of custom artwork waterproof stickers £4.00
6 Data storage module £0.90
6 Black rubber anti dust USB plug £0.14

Total Cost: ≈ £45.00 (Enough material to produce 6 HDD.)

At a cost of around £7.50 each, these fairly heavy duty Hard Drive replicas can provide some great interactive functionality by connecting them via USB to another device. Continue reading “Cache in on these USB driven Hard Drive Disk (HDD) replicas”

Stabilise your uranium during transportation using these sci-fi safe vials

Qty Description Cost
1 Aluminium Round Bar (41.28mm x 500mm) £24.00
1 Aluminium Round Bar (57.15mm x 800mm) £43.00
2 Clear Acrylic Tube (50mm x 5mm x 500mm) £22.00
5 Light Emitting Fluorescent Acrylic Rod (Green) £48.00
20 M4 A2 Countersunk Allen Screw Bolt (40mm) £3.00
60 M4 A2 Countersunk Allen Screw Bolt (20mm) £3.00
5 12V Battery Clip Holder £12.00
5 Latching push button switch £10.00
5 Ultra Bright 12V White LEDs (5mm) £1.00

Optionally, use a large executive briefcase to store the vials (£25.00).

Total Cost: ≈ £166.00 (Enough material to produce 5 vials, possibly more.)

These vials are the result of an idea to introduce additional physical objects into airsoft scenarios, which went from a random sketch to the start production in less than one week. As per usual, this would be a trail and error based process, where the manufacturing was done by hand, resulting in the five vials taking around 8 hours each to produce.

Continue reading “Stabilise your uranium during transportation using these sci-fi safe vials”

Building a full size coffin prop that won't be the death of your bank account

Qty Description Cost
1 Hardwood plywood 1829x607x9mm £15.00
2 Hardwood plywood 1829x607x12mm £30.00
6 Kiln-dried sawn softwood 19x32x2400mm £5.00
6 Chest Handle £15.00
1 Varnish (750ml) £10.00
6 Corner metal 20mm (Optional) £50.00

Additionally, a range of screws and wood stain that we already had in stock were also used to produce this item.

Total Cost: ≈ £75.00 (or £125.00 including metal edging.)

The overall size of this prop was heavily determined by the size of plywood available at the local DIY store. With the most suitable lengths available being 1829mm, this would be used as the height of the coffin and the sides would be half the width of the plywood (607mm / 2). This allowed for it to be cut down the middle and produce little waste.

Continue reading “Building a full size coffin prop that won't be the death of your bank account”

Don't brick yourself with this straight forward airsoft mortar

Qty Description Cost
1 Scaffolding pole (40mm inner diameter) FREE
1 Zinc Chain (0.5m) £2.00
1 Two point sling £5.00
1 Steel Square Tube (16mm x 16mm x 2m) £8.00

Total Cost: £15.00

One of the first pieces constructed, very much like the RPG, this uses a 40mm inner diameter scaffold and a number of other small offcuts. to produce an effective, yet simple mortar ideal for airsoft scenario use. This design is not based on any authentic equipment, instead it was created as a proof of concept in preparation for future models.

Continue reading “Don't brick yourself with this straight forward airsoft mortar”

Rocket yourself to success with your very own rocket propelled grenade launcher

Qty Description Cost
1 Bi-pod Foregrip (Picatinny Rail) £8.00
1 Scaffolding pole (40mm inner diameter) FREE
1 Rubber 33-35mm Scope Recoil Eye Protector £12.00
1 Grip and trigger (salvaged) FREE
1 Two point sling £5.00

Total Cost: £25.00

This piece was constructed entirely by my dad, using a lot of salvaged or re-used parts that kept the cost down significantly. The scope, rails, grip and trigger system was taken and modified from an old VFC Scar airsoft weapon. Using the correct diameter pole allows 38mm thermobaric smoke grenades (or similar projectiles) to be propelled a good distance and prove very affective.

Continue reading “Rocket yourself to success with your very own rocket propelled grenade launcher”

Restrain from going over the top with simple prison shackles

Qty Description Cost
1 Flat iron (1m) £6.00
1 Steel Round Metal Rod 10mm (1m) £5.00
1 Iron Rod 6mm (1m) £2.00
1 Zinc Chain (2m) £7.00
1 Brass Combination Padlock £5.00

Total Cost: £25.00

If you’re intending to make a single shackle, there will be a lot of leftover material if using this materials list. It’s more cost effective to make more than one, such as 3 or 6, as you can use a 1m length of flat iron to produce 3 shackles.

Continue reading “Restrain from going over the top with simple prison shackles”

Leave an impression with blocks of fake C4 explosive

Qty Description Cost
6 Newclay 1kg Air Drying Model Clay £15.00
1 A4 Recycled Kraft Paper 100gsm 50 sheets £6.00
1 Shrink Wrap Film 88g (100 sheets) £4.00

Total Cost: £25.00

In addition to the these items you will need access to printing facilities, sticky tape and the basic ability to use a graphics editing program, such as Adobe Photoshop. If you aim to shrink wrap the blocks an Impulse heat sealer is ideal.

Continue reading “Leave an impression with blocks of fake C4 explosive”