rescue missing vmdk disk

recreate vmdk from *-flat.vmdk file
vmkfstool -c $SIZE -a lsilogic -d thin temp.vmdk
edit the temp file and replace temp-flat with your own flat file name
thanks to http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1002511

windows variables

use %%A within batch files and %A outside in the shell

automatic windows VPN/PPP dial using rasdial

rasdial %CONNECTION_NAME% username password

windows awk using for /f command

example:

C:\Documents and Settings\Ali>for /f "tokens=15 delims= " %A in ('ipconfig ^| find "192.168.7"') do @set GW=%A

windows extract ip address from command line

for /f "tokens=15 delims= " %A in ('ipconfig ^| find "192.168.7"') do @set GW=%A

ubuntu chkconfig equivalent

use sysv-rc-conf

Windows automatic dial VPN PPTP connection

rasdial CONNECTION_NAME USERNAME PASSWORD

veeam scp problem windows 64 bit (x64)

download courflags from
http://www.virtualvcp.com/content/view/26/1/
then do a
courflags "C:\Program Files (x86)\Veeam\Veeam Backup and FastSCP\VeeamShell.exe" /32BIT+"

big thanks to
http://www.everything-virtual.com/?p=279

vmware server 2 remote client problem on linux

goto somewhere like the below

cd ~/.mozilla/firefox/r1ejwkml.default/extensions/VMwareVMRC@vmware.com/plugins

and run
./vmware-vmrc -h "localhost:8333"

dd progress status

while [ `pgrep ^dd` ]; do kill -USR1 `pgrep ^dd`;sleep 1;done

ssh disable slow dns

in /etc/ssh/sshd_config
UseDNS no

rsync vs scp

Remember not to try to rsync like scp, DO NOT SPECIFY PATH, instead look at the [] sections in rsyncd.conf called MODULES and use the below syntax

rsync * 192.168.1.1::MODULE_NAME

REMEMBER YOU ASS

usb dongle to vmware esx guest

use a network USB hub or a USB server software like kernelpro.com

MS SQL Server update based on two tables

update r
set    pass = x.pass
from   InternetUser r inner join InternetUser x
on     r.id = x.id
where r.pass = 'kjfkd9wjj2390eds9d';

simple socks server

simple socks server using ssh

ssh -f -N -D 0.0.0.0:1080 localhost

windows server domain policy

Simple thing took sooo much of my time
to change domain group policies that effect all domain machines change the Domain Security Policy under Administrative Tools not Local Group Policy by adding it under an mmc

Also to see which group policies are in effect in the domain look at gpresult /v >gposettings.txt

resize disk vmware vsphere

resize the disk from vsphere client,

in linux client do a

echo 1 > /sys/bus/scsi/devices/0\:0\:0\:0/rescan

# replace 0\:0\:0\:0 with your own disk scsi id and then

resize2fs /dev/sda

PS: In case a new disk was added to the SCSI bus you need to

echo "- - -" > /sys/class/scsi_host/host0/scan

shrink vmware vmdk virtual disk ESXi 4

use vmware converter to create a copy of the virtual machine which needs to be powered ON for the converter to see the actual data, resize the disks also choose advanced thin for the disk type and have fun, remove the old machine later.

vmware converter helper server error

When vmware can not find the vmware helper server for conversion make sure that

1. conveter and esx server and the machine being converted are on the same lan (check the vlan property before converting)

2. the vlan on which the helper and these other machines are does have a DHCP server on, otherwise configure static IP for the helper

use listagg to convert columns into rows

SELECT id, LISTAGG(str, ',') WITHIN GROUP (ORDER BY str) AS name

FROM new_test

GROUP BY id;

gives you

1 a,b,c

2 d,e

3 f

from

1 a

1 b

1 c

2 d

2 e

3 f