Skip to main content

Posts

Showing posts from 2013

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' ) ;