Tuesday, September 11, 2012

Sybase Backup Schedule



#!/bin/ksh
###############################Loading Sybase Enviroment variables
#
# Sybase Product Environment variables
#
SYBASE_ASE="ASE-15_0"
export SYBASE_ASE
PATH="/usr/sybase/ASE-15_0/bin:/usr/sybase/ASE-15_0/install":$PATH
export PATH
LD_LIBRARY_PATH="/usr/sybase/ASE-15_0/lib":$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
LD_LIBRARY_PATH_64="/usr/sybase/ASE-15_0/lib":$LD_LIBRARY_PATH_64
export LD_LIBRARY_PATH_64
SYBASE="/usr/sybase"
export SYBASE
SYBASE_OCS="OCS-15_0"
export SYBASE_OCS
PATH="/usr/sybase/OCS-15_0/bin":$PATH
export PATH
LD_LIBRARY_PATH="/usr/sybase/OCS-15_0/lib:/usr/sybase/OCS-15_0/lib3p64:/usr/sybase/OCS-15_0/lib3p":$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
INCLUDE="/usr/sybase/OCS-15_0/include":$INCLUDE
export INCLUDE
LIB="/usr/sybase/OCS-15_0/lib":$LIB
export LIB
LD_LIBRARY_PATH_64="/usr/sybase/OCS-15_0/lib:/usr/sybase/OCS-15_0/lib3p64:/usr/sybase/OCS-15_0/lib3p":$LD_LIBRARY_PATH_64
export LD_LIBRARY_PATH_64
SYBASE_JRE6_32="/usr/sybase/shared/JRE-6_0_6"
export SYBASE_JRE6_32
SYBASE_JRE6_64="/usr/sybase/shared/JRE-6_0_6"
export SYBASE_JRE6_64
SYBASE_JRE6="/usr/sybase/shared/JRE-6_0_6"
export SYBASE_JRE6
PATH="/usr/sybase/UAF-2_0/bin":$PATH
export PATH
SYBASE_UA="/usr/sybase/UAF-2_0"
export SYBASE_UA
SYBASE_PLATFORM="sunx"
export SYBASE_PLATFORM
PATH="/usr/sybase/DBISQL/bin":$PATH
export PATH
SCROOT="/usr/sybase/shared/sybcentral600"
export SCROOT
PATH="/usr/sybase/ASEP/bin":$PATH
export PATH
echo $sybaseTH="/usr/sybase/RPL-15_0/bin":$PATH
export PATH
SYBASE_WS="WS-15_0"
export SYBASE_WS
PATH="/usr/sybase/ASE-15_0/jobscheduler/bin":$PATH
export PATH
SYBROOT="/usr/sybase"
export SYBROOT
##################################


isql -Usa -Ppassword -Sservername  << EOF
print "Dumping db1 database"
print "--------------------------------------"
go

dump database databasename to '/usr/sybase/backup/databasedumpfile'  at backupservername_BS
go

Sunday, July 8, 2012

Caching dailymotion.com using SQUID

How to cache Dailymotion video using SQUID 

 You have to follow  the same way of caching youtube and other  videos
and add this line 

acl videocache_allow_url url_regex -i proxy[a-z0-9\-][a-z0-9][a-z0-9][a-z0-9]?\.dailymotion\.com\/video\/[a-z0-9]\/[a-z0-9]\/

reload your squid server and have fun

#tailf /var/log/squid/access 


192.168.1.55 - - [08/Jul/2012:09:14:13 +0200] "GET http://proxy-53.dailymotion.com/video/029/480/47084920_mp4_h264_aac_hq.flv? HTTP/1.1" 200 2176756 TCP_HIT:NONE