Skip to main content

Posts

Wiring a 240V socket

There are 3 pins The Active Pin:  Red or Brown The Neutral Pin:   Black or Blue The Earth: Green or Green and Yellow The new standard effectively uses Brown and Blue for cords and Red and Black for the building See also www.accesscomms.com.au/reference/powerplug.htm The Australian mains plug configuration was originally presented as provisional standard C112 in 1937, formalised as Standard C112 in 1938, redesignated AS3112 in 1981 and harmonized with the New Zealand standard and redesignated AS/NZS3112 in 1993.  Australian Standards AS/NZS 3112:2000 and AS/NZS3112:2004 for Australian Mains Plugs now define the requirements for the insulation  of the Active and Neutral pins of the plug.

Cisco VPN client

using a batch file to start a Cisco VPN connection The idea of doing this is so you can run a script afterwards.... There is no automatic way to run a .bat script when you connect to Cisco Vpn client( which possible using Anyconnect ) . But as workaround, you can run a single batch script to connect to vpn client via cli. For eg: Create a text file like this: @echo off "c:\Program Files\Cisco Systems\VPN Client\vpnclient.exe" connect <profile-name> echo "Launching application ..." <application text> Save this as a batch file and start this instead of the vpn client.

netsh

Windows has a cool command called netsh netsh>interface ip show config revealed some good results interface ip set dns “Local Area Connection” static 192.168.1.1

mysql trigger

Took me a while to get this right, but here is on delete mysql copy trigger actually works CREATE TRIGGER CopyOldMedList BEFORE DELETE ON REF_medications   FOR EACH ROW    insert into REF_medications_old       ( `medname` ,  `order` ,  `disabled`  , `action` )      VALUES       ( OLD.medname , OLD.order , NOW() , 'deleted' ) ;