20Noi/112
NAT pentru IP dinamic
1. Script pentru SNAT la ip dinamic folosind iptables
#!/bin/sh
WANIF="ppp0"
LANIF="eth0"
INTERNALNET="192.168.0.0/24"
IFCONFIG=/sbin/ifconfig
IPTABLES=/usr/sbin/iptables
GREP=/bin/grep
AWK=/bin/awk
# Determinam adresa IP externa automat:
WANIP="`$IFCONFIG $WANIF | $GREP 'inet addr' | $AWK '{print $2}' | sed -e 's/.*://'`"
# Se face SNAT la toate IP-urile din reteaua locala prin IP-ul extern
$IPTABLES -t nat -A POSTROUTING -s $INTERNALNET -j SNAT --to $WANIP
#END
19Noi/110
Script backup baze de date MySQL
Un mic script bash pentru backup la bazele de date MySQL:
#!/bin/sh
# Backup Baze de date MySQL
b_dir="/usr/BACKUP/"
log_dir="/var/log/backup/"
MySQL_db_dir="/usr/local/mysql/var/"
MySQK_bk_user="userul de backup"
MySQL_bk_pw="Parola pentru userul de backup"
mkdir $b_dir`date +"%d%b%y"`
mkdir $b_dir`date +"%d%b%y"`/mysql/
# MySQL
for i in `ls $MySQL_db_dir | sed -e 's/\///'` ; do
if [ -d $MySQL_db_dir$i ] ; then
cd $b_dir`date +"%d%b%y"`/mysql/
/usr/bin/mysqldump $i -u $MySQL_bk_user -p"$MySQL_bk_pw" > $i-`date +"%d%b%y"`.sql
tar cjf $i-`date +"%d%b%y"`.sql.tar.bz2 $i-`date +"%d%b%y"`.sql
rm -rf $i-`date +"%d%b%y"`.sql
fi
done
Job done. Enjoy!