rsync

# 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/

Create LiveCD with Debian live-helper

# test
 
apt-get install live-helper cdebootstrap
 
cat <<EOF>> /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

Compile CTCS

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-

update_customer_payment.sql

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    

job_show.sql

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'      

job_set_ndxsys.sql - will setup the package as job 12 at 21:00 hours today

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

job_remove_ndxsys.sql

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;

syncHome.sh

#!/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}"

find

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

OpenVPN connect to network with same ip range

#!/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
Syndicate content