#!/bin/bash

sudo su

echo "deb http://dl.google.com/linux/deb/ stable non-free" >> /etc/apt/sources.list
sudo apt-get update
sudo apt-get install picasa

# and
if [ "$foo" == "a" ] && [ "$bar" == "b" ]; then

# or
if [ "$foo" == "x" ] || [ "$bar" == "y" ]; then

# both
if ( [ "$a" == "a" ] || [ "$a" == "b" ] ) && ( [ "$b" == "c" ] ); then

# enable color output systemwide for ls and grep
cat <> /etc/profile.d/alias.sh
alias ls='ls --color=auto'
alias grep='grep --color=auto'
EOF

# get exitcode prevoius command
${PIPESTATUS[0]}

# redirect stdout AND stderr to file
COMMAND &> file.out

# sequence
echo {,my-}host{1,{3..5},9,10}
echo $(seq 1 4)

# for loop
START=1
END=10
for ((i=START; i<=END; i++)); do
e

#!/bin/bash

change_rights() {
for i in $(find $1 -perm 700); do
echo "set rights for $i"
chmod a+rw $i
done

for i in $(find $1 -perm 600); do
echo "set rights for $i"
chmod a+rw $i
done
}

change_name() {
for i in $(find $1 -name "*.JPG"); do
echo "rename $i ${i//.JPG/.jpg}"
mv "$i" "${i//.JPG/.jpg}"
done
}

for DIR in /data/bilder/300dpi /data/bilder/700dpi; do
change_rights $DIR
change_name $DIR
done

#!/bin/bash

wget http://www.panticz.de/sites/default/files/ubuntu-2.6.22-14-xen.i386-kernel.tar.bz2 -P /tmp
tar -xjPf /tmp/ubuntu-2.6.22-14-xen.i386-kernel.tar.bz2

DOMAIN_NAME=mx

xen-create-image --hostname=$DOMAIN_NAME --ip=192.168.1.231 --gateway=192.168.1.5 --netmask=255.255.255.0 \
--dir=/home/xen --dist=gutsy --mirror=http://archive.ubuntu.com/ubuntu/ --arch=i386 \
--size=8Gb --memory=1Gb --swap=1Gb \
--kernel=/boot/vmlinuz-2.6.22-14-xen.i386 --initrd=/boot/initrd.img-2.6.22-14-xen.i386

cp /etc/xen/$DOMAIN_NAME.cfg /etc/xen/$DOMAIN_NAME.cfg.org
sed -i 's|file:|tap:aio

#!/bin/bash

# !!!

Then your text

#!/bin/bash

# install bridge utils
apt-get install bridge-utils

# create bridge
cat <> /etc/network/interfaces
auto br0
iface br0 inet dhcp
bridge_ports eth0
bridge_fd 2.5
EOF

# restart network
/etc/init.d/networking restart

# create an interface for a user
VBoxAddIF vbox0 $USERNAME br0

# Links
# http://wiki.ubuntuusers.de/VirtualBox
# http://wiki.debian.org/VirtualBox

#!/bin/bash

# http://www.panticz.de/Send-email-from-console

INPUT=./adr_uniq.txt
CONTENT=./nl_de.html
SUBJECT="YOUR_SUBJECT"
LOG=./nl_de_$(date -I).log

# send
for i in $(cat $INPUT); do
mail -a 'Content-type: text/html;' -s "$SUBJECT" "$i" < $CONTENT
echo "$i - $?" | tee -a $LOG
done

#!/bin/bash

# download netboot image
wget http://archive.ubuntu.com/ubuntu/dists/trusty-updates/main/installer-amd64/current/images/netboot/netboot.tar.gz -P /tmp

# extract and copy install files
tar xzf /tmp/netboot.tar.gz -C /tmp
mkdir /boot/ubuntu
cp /tmp/ubuntu-installer/amd64/initrd.gz /boot/ubuntu/
cp /tmp/ubuntu-installer/amd64/linux /boot/ubuntu/

# create GRUB menu entry
cat < /etc/grub.d/49_ubuntu
#!/bin/sh
exec tail -n +4 $0

menuentry "Network Ubuntu install" {
root (hd0,0)
kernel /boot/ubuntu/linux
initrd /boot/ubuntu/initrd.gz
}
EOF
chmod

-- show tables
select table_name from all_tables;

-- output parameter
set wrap off;
set pagesize 0;
set linesize 120;
column owner format a30;

-- show configuration
show parameters;

-- list users
select username from all_users

-- find constraint
select *
from all_constraints
where constraint_name = 'SYS_C00381400';

-- select a random row from table
SELECT column FROM
SELECT column FROM table
ORDER BY dbms_random.value
)
WHERE rownum = 1

-- update materialized view
begin
dbms_snapshot.refresh('SCHEMA.MATERIALIZED_VIEW_NAME');
end;

-- view sched