Windows VPN Connection with automatic routes added without default gateway option

type c:\windows\vpn.bat

@echo off
rasdial VPN_CONNECTION_NAME USERNAME PASSWORD
for /f "tokens=15 delims= " %%A in ('ipconfig ^| find "192.168.200"') do @set GW=%%A
route add 192.168.45.0 mask 255.255.255.0 %GW%

DNS SRV records for SIP redundancy

DNS SRV records for SIP redundancy
http://blog.lithiumblue.com/2007/07/understanding-dns-srv-records-and-sip.html

SRV records for service redudnacy

You can use SRV records just like MX records for other services redundancy for services other than mail

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

previous not null values of a field in oracle

select lastprice, lag(lastprice ignore nulls,1) over (order by statdate) from daily_statistics

automount a specific directory with autofs

this is what we do
first umount your directory then mount the location you want to another directory and later create a symbolic link with the name you need

umount /usr/local/apache-tomcat-6.0.26/information-repository

rmdir /usr/local/apache-tomcat-6.0.26/information-repository

vi /etc/auto/master
/usr/local/mounts /etc/auto.nfs

vi /etc/auto.nfs
m_29 -fstype=nfs,rw 192.168.0.29:/u01/information-repository

mkdir /usr/local/mounts/m_29

ln -s /usr/local/mounts/m_29 /usr/local/apache-tomcat-6.0.26/information-repository

mount with UUID

get a blkid to find the UUID of the device you are after then in /etc/fstab do like this:

UUID=41c22818-fbad-4da6-8196-c816df0b7aa8 /disk1 ext3 defaults 0 0

split the internet into 8 parts :)

1.0.0.0/255.0.0.0
2.0.0.0/254.0.0.0
4.0.0.0/252.0.0.0
8.0.0.0/248.0.0.0
16.0.0.0/240.0.0.0
32.0.0.0/224.0.0.0
64.0.0.0/192.0.0.0
128.0.0.0/128.0.0.0

fortinet SSL VPN client automatic startup

download the client from here:

http://internal.enterprisecomponent.com/download/FortiClientSSLVPN/forticlientsslvpn_linux_4.0.2010.tar.gz

start the client and in advanced check save password and persistent connection

add the vpn client to the startup of a vnc server in ~/.vnc/xstartup

start the vncserver automatically by editing /etc/sysconfig/vncserver

and chkconifg vncserver on

cacti add simple graph for a value from script

read this babe:
http://www.cacti.net/downloads/docs/html/how_to.html

cacti monitor link

1. add the ip address you want to monitor as a new device
2. Add the "Unix-Ping Latency" graph template to it.
3. Add a new graph of the above template to your device.

BIG thanks to: http://www.networknet.nl/apps/wp/archives/367

Linux add and load MIB

1. Copy the file the same place other MIB files are
2. add mibs +DEVICE_MIB to /etc/snmp/snmp.conf
3. snmpwalk -v2c -c public IP_ADDR enterprise

linux force reboot or shutdown

Force Reboot :

echo 1 > /proc/sys/kernel/sysrq

echo b > /proc/sysrq-trigger

If you want to force shutdown machine try this.

echo 1 > /proc/sys/kernel/sysrq

echo o > /proc/sysrq-trigger

Thanks to http://linax.wordpress.com/2009/02/16/linux-force-reboot-and-shutdown/

linux create logical volume

pvcreate /dev/sdb1
vgcreate VolGroup01 /dev/sdb1
lvcreate -L953G -n LogVol00 VolGroup01
parted -l

add iscsi target and initiator in CentOS Linux

----------------- Target (Server) ----------------

#> vi /etc/tgt/targets.conf



<target iqn.2011-04.com.storage2.volgroup01.logvol00>

backing-store /dev/VolGroup01/LogVol00

</target>

#> service tgtd restart

; Take care of iptables

-----------Initiator (Client) -------------

#> iscsiadm -m discovery -t st -p 192.168.2.140

#> iscsiadm -m node

#> chkconfig iscsi on

#> service iscsi start

linux discover and add new disk without reboot dynamically

To Discover and add new disk to a linux machine without having to reboot the server (e.g when virtual disk is added to a machine online) do the below:

ls /sys/class/scsi_host

#output is host0
#new rescan the scsi bus
echo "- - -" > /sys/class/scsi_host/host0/scan

#now you can see the new disk
fdisk -l

# add the new disk to the lvm if you want

vmware server 2 virtual console does not load

To solve the problem
find and run ./vmware-vmrc -h server:8333 -M "VM_ID"
to find "VM_ID" goto vmware webui and generate a shortcut on dekstop

ESXi scp

In ESXi to do scp using pscp simply do scp -scp to avoid doing sftp

Mikrotik DMZ

To put and IP address in DMZ
simple create a destination nat from the public IP to private without specifying anything else

get my oracle support (MOS) and metalink access cheap

Buy either
Oracle Load Testing Accelerator for Oracle E-Business Suite
Oracle Load Testing Accelerator for Siebel

linux bandwidth control

1. behind a router (easily done in mikrotik with queues)
2. using tc with iptables mangle
3. using redirection of traffic via squid proxy

MSM LSI MEGARAID

Install the latest MSM Megaraid manager regardless of whatever version actually belongs to the storage card on LSI website

windows file sharing service is server in sevices list

is called server in services.msc

openfiler scsi target not found in ESX 4.1

just edit /etc/initiators.deny and comment "ALL"

resize LVM by adding new disk to lvm

    
  fdisk /dev/sdb
  mkfs -t ext3 -c /dev/sdb1
  pvcreate /dev/sdb1
  vgextend VolGroup00 /dev/sdb1
  lvextend -L+1G /dev/VolGroup00/LogVol00 ;for adding one more GB to Logical Volume LogVol01
  resize2fs /dev/VolGroup00/LogVol00


Thanks to http://sujithemmanuel.blogspot.com/2007/04/how-to-add-disk-to-lvm.html

amplify sound volume of a video file

To amplify - increase sound volume of - a video file do

ffmpeg -i myvideo.avi -vcodec copy -vol 5000 myvideo_louder.avi

thanks to http://superuser.com/questions/13552/how-to-amplify-the-audio-in-a-video-file

VMWARE ESX 4.1 boot from ISO does not work

Remember to check the box which says "Connected", the damn thing took soooo much of my time.

boot from USB for motheboards not supporting it

plop boot manager

linux detach screen

to exit a session created by screen command without stopping what is going on in the session do a
CTRL+a then d

awk dmidecode output

dmidecode | awk 'BEGIN {RS = "\n\n"} /System Information/'
thanks to http://aixhealthcheck.com/index.php?id=246

duplicate lines in vim

yy (copy) or dd (cut) a line and then do a p (paste)

NOHUP

start applications with nohup so they will not be closed once the terminal session is closed.

copy and backup

find /tmp/test/ -name '*.csv' -exec cp --backup=numbered {} /tmp/test2/ \;

if a file exists in the destination cp will create a copy first like filename.~1~

Thanks to RAMIN the RAMPALO

monitoring software

the best product I have seen yet: http://www.manageengine.com

linux iptables SNAT

you do not have to have the ip address of a machine behind iptables set on the gateway machine before you can SNAT with the ipaddress of the machine behind the firewall. In other words you can keep your valid ip address on the machine behind the gateway and still ask your gateway to SNAT with that IP.

iphone phonebook problem

Caller ID format Fix

Linux Directory Entry condition

to be able to enter a directory it needs to be +x enabled, you ass!

Visio add text to shape with yellow dot

In detail, it goes something like this:

1. Create or select a shape (duh!)

2. Open the ShapeSheet via Window > Show ShapeSheet

Go to: Insert > Section and check Controls and Text Transform (if it isn’t grayed out)

You should now see both the Controls section and the Text Transform section in the ShapeSheet.

3. In the Text Transform section, set the TxtPin cells as follows:

TxtPinX = Controls.Row_1.X

TxtPinY = Controls.Row_1.Y

4. In the drawing window, reposition the control handle to a suitable default position. The text should follow along!

Taken from: http://www.visguy.com/2009/05/06/top-twelve-text-tips/

rsync from windows to linux

1.
vi /etc/xinetd.d/rsync
set disabled = no

2.
cat /etc/rsyncd.conf
max connections = 2
log file = /var/log/rsync.log
timeout = 300

[pub]
comment = Random things available for download
path = /home/oracle/work
read only = yes
list = yes
uid = oracle
gid = oinstall
auth users = pub
secrets file = /etc/rsyncd.secrets

[share2]
comment = t2
path = /home/oracle/work2
read only = yes
list = yes
uid = oracle
gid = oinstall
auth users = pub2
secrets file = /etc/rsyncd.secrets

3.
cat /etc/rsyncd.secrets
pub:pub
pub2:pub2

4.
chmod 600 /etc/rsyncd.secrets

5.
download http://www.brentnorris.net/rsync.zip

6. rsync like this:
rsync -aPv rsync://pub@192.168.0.213/pub .

Windows XP enable AHCI mode after IDE Install

1. download the corresponding Intel Matrix Storage driver for your Motherboard (ICHX)

2. c:\iata_enu.exe -a

3. copy c:\Program Files\Intel\Intel Matrix Storage Manager\IaStor.sys c:\windows\system32\drivers

4. find the corresponding AHCI.reg file from the internet for your motherboard (ICHX)

5. load the reg file into you registry

6. reboot and enable AHCI mode

7. When windows started cancel automatic hard disk detection and install Intel Matrix Storage and reboot

taken from http://forums.hexus.net/hexus-hardware/112584-how-enable-ahci-raid-mode-without-reinstalling-windows-p35-ich9-ich9r-4.html

exporting files from a specific user

/var/www/html/mp3 *(ro,sync,all_squash,anonuid=100,anongid=101)

This will answer request from nfs clients as if the request has come from the specific use anonuid:anongid

terminal services and iptables

for terminal services to work behind an iptables firewall, if the terminal server does not have a valid IP address, a full cone nat is required, which in iptables terms means that you need both a PREROUTING and a POSTROUTING statement.

oracle if function within select

DECODE

REMEMBER U ASS!

cpanel multiple forwarder

just create multiple lines of forwarders
info@x --> me@x
info@x--> you@x

windows check listening ports

netstat -an |find /i "listening"

THANKS A MIL to PETRI

linux sendmail delete outgoing mails

delete in files in /var/spool/mqueue

also you can see the queue using mailq

linux install i2o raid

to install linux on servers like supermicro X6DH8-G you should install the i2o driver, to install the i2o driver do a
"linux noprobe text" and when "add device" is displayed, load the i2o block driver and things will be LA LA LA LA

mikrotik load balancing

Load balancing, connection aggregation, multi-homing, miltiple internet connections teaming

http://wiki.mikrotik.com/wiki/NTH_load_balancing_with_masquerade

LOVE IT!

Photoshop incorrect color, white is shown as yellow

Do a View->Proof Setup->Custom

EASEUS FREE Partition Manager

EASEUS FREE Partition Manager (epm.zip)

http://www.partition-tool.com/download.htm

Terminal server has exceeded maximum number of allowed connection

Simply do an

mstsc /admin

FTP server behind iptables firewall

To enable firewall access behind firewall other than opening port 21 on the firewall one needs to
Add
IPTABLES_MODULES="ip_nat_ftp"
to
/etc/sysconfig/iptables-config

BIG Thanks to RAMPALO

mount iso in /etc/fstab

add the below to /etc/fstab
/mnt/centos.iso /media/iso iso9660 loop 0 0

windows delete share and connect to the same share with another username

windows delete share and connect to the same share with another username

net use \\servername\sharename /delete

WEEHA

mikrotik select gateway based on source address

ip firewall mange
prerouting, mark packets from a special source with a routing mark (any name you like) and add the 0.0.0.0/0 route again and choose the routing mark you specified before with a desired gatway which can be different from the original 0.0.0.0/0 route gatway

change timezone in centos

yum -y install tzdata
cp /usr/share/zoneinfo/Asia/Tehran /etc/localtime

BIG thanks to: http://blog.connexeon.com/sysadmin/linux/change-timezone-on-centos/

mikrotik data connections with other types of interfaces

there are 2 interfaces that seem to work ethernet/ip and ip/ip both need for the two end points to have accessible valid ip addresses.
In case you use mikrotik to do PPPOE, you need to put the host OS nic in PROMISC=yes mode so that the PPPOE ack packets can be received by the gust OS.

linux enable NTSF mount in read/write mode

yum -y install dkms-fuse fuse fuse-ntfs-3g

httpd.conf and the Aliases

When the alias reads like below
Alias /cacti/ /var/www/cacti/

DirectoryIndex index.php
Options -Indexes
AllowOverride all
order deny,allow
deny from all
allow from 127.0.0.1
AddType application/x-httpd-php .php
php_flag magic_quotes_gpc on
php_flag track_vars on


to display the alias successfully in the browser do not forget the terminating slash at the end, so
http://localhost/cacti/ is right.

Persistent SSH SOCKS5 tunnel in Linux

ssh -c arcfour -o TCPKeepAlive=yes -N -f -D localhost:1080 user@remoteserver.com

instead of -c arcfour one can use -c blowfish-cbc as well. The performance of the tunnel gets better with a more lightweight cipher.

dbca logs

here you can find dbca logs $ORACLE_HOME/cfgtoollogs/dbca
thanks to OTN

Oracle dbca press finish nothing happens

If you press finish at the end of database creation of dbca and nothing happens, it is (in my case) an X problem. What I did was not to use the X server on windows instead I installed X11 on linux and used that one and it went smoothly.

check linux distribution

cat /etc/*-release

Linksys WAP54GS to act as router with dd-wrt

to make WAP54GS a router
1. Install dd-wrt
2. change the assignment of WAN port from vlan1 to vlan0
3. TADA!!!!!

/etc/sysconfig/desktop

/etc/sysconfig/desktop to choose the window manager permanently

vmware change MAC

in the virtual machine (config) vmx file:

# ethernet0.addressType = "generated"
# RANGE ALLOWED: 00:50:56:00:00:00-00:50:56:3F:FF:FF
ethernet0.addressType = "static"
# ethernet0.generatedAddress = "00:0c:29:94:43:71"
ethernet0.Address = "00:0c:29:94:43:70"

rsync without SSH

rsync -av rsync://server/rsync_share_name

slow sendmail startup

When sendmail is slow at startup do either of these things in /etc/hosts
127.0.0.1 localhost.localname machinename

or

192.168.1.100 machinename.domainname

if you have only machinename sendmail will be slow

firefox download flash

do a about:cache?device=disk and search for the URL or filename


many thanks to
http://labnol.blogspot.com/2005/11/save-flash-from-firefox-and-ie.html

MYSQL grant REMEBER 'user'@'server'

REMEMBER THIS:
grant all on DB1 to 'user'@'localhost' identified by 'password';

putty connect to session instead of server from command line

to make putty connect to session (based on the name of the session) instead of server from command line DO:

putty @SESSION_NAME

putty default font permanent

To change the default font in putty change the font settings in the Default Settings in the main window

linux upgrade problem

If you get something like "there are multiple partitions labelled /, they must be unique" simply use remove the label by:

tune2fs /dev/sda2 -L ''

# HOORAY

error reading information on service keytable: No such file or directory

if you get
error reading information on service keytable: No such file or directory
error: %trigger(kbd-1.08-10.2.i386) scriptlet failed, exit status 1

rpm -e kbd-1.08-10.2 --noscripts

Grub set default boot option just once

echo "savedefault --default=1 --once" | grub --batch
reboot

Remote upgrade linux RHEL redhat 3 to 4

1. mount the installation cd and copy vmlinuz and initrd.img to /boot renaming them to vmlinuz_remote and initrd_remote.img
2. vi /etc/grub.conf
# grub.conf generated by anaconda
#
# Note that you do not have to rerun grub after making changes to this file
# NOTICE: You have a /boot partition. This means that
# all kernel and initrd paths are relative to /boot/, eg.
# root (hd0,0)
# kernel /vmlinuz-version ro root=/dev/hda2
# initrd /initrd-version.img
#boot=/dev/hda
default=0
timeout=10
splashimage=(hd0,0)/grub/splash.xpm.gz
title Red Hat Enterprise Linux AS (2.4.21-15.EL)
root (hd0,0)
kernel /vmlinuz-2.4.21-15.EL ro root=LABEL=/
initrd /initrd-2.4.21-15.EL.img
title Remote Install
root (hd0,0)
kernel /vmlinuz_remote ks=hd:hda1:/ks.cfg vnc vncconnect=192.168.162.1 ramdisk_size=8192
initrd /initrd_remote.img

replace the above devices with the ones on your system(hd:hda1->points to /boot)
3. vi /boot/ks.cfg
#System language
lang en_US
#Language modules to install
langsupport --default=en_US
#System keyboard
keyboard us
#System mouse
mouse generic3ps/2
#network
network --bootproto static --ip 192.168.162.129 --netmask 255.255.255.0 --gateway 192.168.162.1 --nameserver 192.168.162.1 --hostname l
#Use interactive kickstart installation method
interactive
#Use hard drive installation media USE YOUR OWN HARDDRIVE
harddrive --dir=/iso --partition=hda2 #replace with your own device (this points to /)
bootloader --location=mbr
#Reboot after installation
reboot
#Upgrade existing installation
upgrade
%pre

#!/bin/sh

mkdir /tmp/boot # create mount point
#-USE YOUR OWN HARDDRIVE ADDR
# mount filesystem on /dev/sda1 onto /tmp/boot (hiding mount's boot dir)
# /dev/hda1 point to /boot
mount -t ext3 /dev/hda1 /tmp/boot
# so below here /tmp/boot/... is actually /boot/... on harddrive device
# 'date' preserves original grub.conf through multiple boot attempts
cp /tmp/boot/grub/grub.conf /tmp/boot/grub/grub.conf.$(date"+%Y%m%d-%H%M%S")
cp /tmp/boot/grub/grub.conf /tmp/boot/grub/grub.sve
cp /tmp/boot/grub/grub.bak /tmp/boot/grub/grub.conf

4. put your CD or DVD iso in /iso, they can be multiple isos

5. just to be safe try loading the second option to grub you just added once as below, so if things went wrong you can come back

echo "savedefault --default=1 --once" | grub --batch
reboot

Linux YP NIS config with autofs

1. mkdir /data/user10

2. useradd -g users -d /data/user10 user10

3. vi /etc/auto.master
# add this
/data auto.data --ghost

4. vi /etc/auto.data
* /data/& #something like this

5. vi /var/yp/Makefile
make an auto.data entry just like auto.home

6. do a make in var/yp

7. on the client service autofs restart

ubuntu network configuration

root@ali-desktop:~# cat /etc/network/interfaces
auto lo
iface lo inet loopback

auto usb0

iface usb0 inet static
address 192.168.111.2
netmask 255.255.255.0

auto eth0
iface eth0 inet dhcp

Couldn't make mmap of X bytes - mmap

mount -t tmpfs none /var/cache/apt
mkdir -p /var/cache/apt/archives/partial
apt-get update

pango ARM cross compile

./configure --prefix=/home1 --host=arm-ip-linux-gnueabi LDFLAGS=-L$YOUR_OWN_COMPILED_GLIB_DIR (eg /opt/lib)

GLIB ARM Cross compile

IPLinux GLIB BUILD

cat config.cache
glib_cv_stack_grows=yes
ac_cv_func_posix_getpwuid_r=yes
ac_cv_func_posix_getgrgid_r=yes
glib_cv_uscore=yes

./configure --host=arm-linux --cache=config.cache