Check file name and set rights

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

Create XEN Zimbra domain (Zimbra Collaboration Suite)

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

Install Ubuntu Hardy from HDD

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

Oracle queries

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

MySQL Queries

-- view hostname
select @@hostname;

-- view version
select version();

-- view engines
show engines;

-- list databases
show databases;

-- change database
use mysql;

-- show tables in database
show tables;

-- show table informations
show table status;

-- show engines
show engines;

-- show bin_log info
show variables like '%log_bin%';

-- list users
select user, host from mysql.user;

-- delete user
DROP USER 'USER_NAME'@'%';

-- set user password
--SET PASSWORD FOR 'USER_NAME'@'%' = PASSWORD('NEW_PASSWORD')
use mysql;
update user set password=PASSWORD(