# rsync only files matching pattern
rsync -avz --include "*_small.jpg" --exclude "*.jpg" dir1/ dir2/
rsync -avz --include "*/" --include "*.jpg" --exclude "*" dir1/ dir2/
rsync -avz --include "*/" --include "**.svn**" --exclude "*" just-checked-out/ old-and-modified/

# rsync over ssh
rsync -are ssh root@192.168.1.2:/data/bilder /mnt/

# test

apt-get install live-helper cdebootstrap

cat <> /usr/share/cdebootstrap/suites
Suite: hardy
Config: generic-ubuntu
Keyring: ubuntu-archive-keyring.gpg
EOF

# sed
/usr/bin/lh_chroot_sources
${LH_DISTRIBUTION}/updates
${LH_DISTRIBUTION}-updates

mkdir ~/live && cd ~/live

lh_build

http://clemensfam.org/john/?p=39

sudo su

cd /usr/src/
apt-get install dpkg-dev lm-sensors dialog build-essential
echo "deb-src http://archive.ubuntu.com/ubuntu hardy main universe multiverse restricted" >> /etc/apt/sources.list
apt-get update
apt-get source linux-image-$(uname -r)
ln -sf /usr/src/linux-2.6.24/ /usr/src/linux

# 1.3.0
wget http://downloads.sourceforge.net/sourceforge/va-ctcs/ctcs-1.3.0.tgz -P /tmp
tar xzf /tmp/ctcs-*.tgz -C /tmp
cd /tmp/ctcs-*/
make all

# 1.3.1
wget http://downloads.sourceforge.net/sourceforge/va-ctcs/ctcs-1.3.1-pre1.tgz -P /tmp
tar xzf /tmp/ctcs-*.tgz -C /tmp
cd /tmp/ctcs-

BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'update_snapshots',
job_type => 'STORED_PROCEDURE',
job_action => 'UPDATE_SNAPSHOT',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=hourly; byminute=5',
end_date => NULL,
enabled => TRUE
);
END

-- 10xe
DBMS_SCHEDULER.create_job (
job_name => 'update_invoice_positions',
job_type => 'PLSQL_BLOCK',
job_action => 'K.INVOICE;',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=hourly; byminute=0',
end_date

set pagesize 50000
set linesize 240
set echo off

column job format 9999 heading 'Job' justify right
column schema_user format a20 heading 'Oracle User' justify left
column broken format a6 heading 'Broken' justify left
column last_date format a20 heading 'Last Date' justify left

column this_date format a20 heading 'This Date' justify left
column next_date format a20 heading 'Next Date' justify left
column interval format a60 heading 'Interval' justify left
column what format a80 heading 'What'

set echo off;

clear screen;

PROMPT

PROMPT COLLECTING USER INFORMATION
PROMPT

ACCEPT database_sid CHAR PROMPT 'DATABASE TO CONNECT TO [ORCL]: ' DEFAULT ORCL
ACCEPT mhsys_password CHAR PROMPT 'PASSWORD FOR USER MHSYS [MHSYS]: ' DEFAULT MHSYS HIDE
PROMPT

prompt CONNECTING USER MHSYS
connect MHSYS/&mhsys_password@&database_sid;

set serveroutput on;
set linesize 100;
spool job_set_ndxsys.log;

prompt SHOWING JOBS
select JOB, SCHEMA_USER,
to_char(NEXT_DATE, 'DD-MON-YYYY, HH24:MI') NEXT_DATE,
INTERVAL, WHAT
from dba_jobs

order by job;

p

set serveroutput on;
set linesize 100;
set echo on;
spool job_remove.log;

select JOB, SCHEMA_USER, BROKEN, WHAT
from dba_jobs;
execute DBMS_JOB.REMOVE(&job_number_to_remove)

commit;

select JOB, SCHEMA_USER, BROKEN, WHAT
from dba_jobs;

spool off;

#!/bin/bash

USER=pako
TARGET=192.168.1.224
tar zcf - /home/${USER} | ssh root@${TARGET} "cd /home/; tar zpxvf -; chown ${USER}.${USER} -R ${USER}"

# Links
http://www.ostc.de/howtos/find-HOWTO.txt

#!/bin/bash

# delete routing for whole network
sudo route del -net 192.168.1.0 netmask 255.255.255.0 dev tap0

# add route to hosts
for ip in {30..50}; do
sudo route add 192.168.1.${ip} dev tap0
done