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

samba passwordless login

smbpasswd -a ali

/etc/samba/smb.conf
security=share
[public]
path = /home/ali
read only = no
guest ok = yes
public = yes
browsable = yes
force user = ali

ubuntu howto stop X from auto start

sudo update-rc.d -f gdm remove

VOIP FXO FXS

REMEMBER

FXO = Foreign Exchange Office is connected to PSTN.
FXS = Foreign Exchange Subscriber is connected to a normal phone.

http://www.patton.com/technotes/fxs_fxo.pdf

DISPLAY to connect to X from SSH

export DISPLAY=`who -um | awk '{print $8}' | tr -d '()'`:0.0

microsoft fonts for linux i386

taken and rpm-built from http://corefonts.sourceforge.net/

for rpm based Linuces
msttcorefonts-2.0-1.noarch.rpm

Wive 0.61 on DWL-G700AP

When installing Wive on DWL-G700AP remember that after putting the access point in TFTP mode you have to use the EXACT ip address "192.168.1.6" for tftp regardless of whatever the actual LAN interface IP is.

trixbox backup and restore

Install tbm-backup trixbox module in both machines, create a backup in BOTH machines, restore the backup from old machine into the new one (mysql password for asteriskuser may not be the same so before the restoration of the backup file make them the same).

windows 2003 limit bandwidth usage per IP

1. squid with delay pools support
(http://markus.revti.com/2007/06/installing-squid-cache-for-windows/)

2. softperfect bandwidth manager
(http://markus.revti.com/2009/01/squid-transparent-proxy-server-on-windows-server-2003/)

windows delete a service from command line

sc delete "service_name"

multiple domain controllers (DC) on the same LAN

Use the DHCP of one of the DCs and split the LAN into 2 SUB-LANS
this is done using a superscope in the DHCP of domain controller.

- one scope 192.168.1.0/255.255.255.128
- another scope 192.168.1.128/255.255.255.128

The two sub scopes will not be able to access one another

Put one of the servers in first scope and the other in the second one.

In the scope options each have their own DNS and default route

To make the clients become a member of a certain scope fix the clients MAC address and create a reservation

vmware guest OS on windows RRAS host OS problem

If you need to have vmware installed on a machine with RRAS, because of incompatibilities between proxy arp of RRAS and vmware your guest OS packets will not be routed, what you need to do is:
[in this example host machine has 2 NICs. One toward Internet and one local.]
1. Add a NIC to the host machine. (not virtual)
2. In the guest OS bridge one NIC to the Internet NIC of the host OS and the other to the newly added NIC of the host OS (which is connected to the local LAN)
3. Assign an IP address to the host and guest machine (the same range as the host machine)

Walla! ping outside

vnc enterprise vncconfig problem

run vncconfig with the -service parameter to change the config of the service mode not user mode
"E:\Program Files\RealVNC\VNC4\vncconfig.exe" -service

mysql import and export

export:
mysqldump -u user -p db > dump.sql

import:
mysql -u user -p db < dump.sql

howto install cpanel

It is not free, needs a licence from cpanel.net after the trial period
Installing cPanel on a linux box is as simple as:
cd /home
wget layer1.cpanel.net/latest
sh latest
from: http://paragonhost.wordpress.com/2006/11/16/howto-install-cpanel-on-a-linux-os-server/

experts exchange free readonly account

http://www.experts-exchange.com/registerFree2.jsp

Office 2003 Slow send in Vista

simply remove all office 2007 components on your PC and things will be cooooooool :)