19
Jun
SSL telnet
openssl s_client -connect example.com:443 -ssl3Archive for the ‘Mẹo vặt của hiếu râu’ Category
http://www.mysqltutorial.org/mysql-stored-function/
CREATE DEFINER=`hieunt`@`localhost` FUNCTION `get_range_counter`(`p_idRule` INT, `p_rType` VARCHAR(50))
RETURNS int(11)
LANGUAGE SQL
NOT DETERMINISTIC
READS SQL DATA
SQL SECURITY DEFINER
COMMENT ''
BEGIN
DECLARE ret INT;
select sum(b.rE-b.rB+1) as DIP INTO ret
from tbl_rule_detail b
where b.rType=p_rType and b.idRule= p_idRule;
if p_rType='SP' or p_rType='DP' then
if ret>=65536 then set ret=0; end if;
else
if ret>=2147483647 then set ret=0; end if;
end if;
return (ret);
END
//—————–
select a.id,b.code_ticket ,a.SourceVlan,a.SourceIP,a.SourcePort,a.DesVLan,a.DesIP,a.DesPort,a.Protocol,
get_range_counter(a.id,'SIP') as SIP,
get_range_counter(a.id,'SP') as SP,
get_range_counter(a.id,'DIP') as DIP,
get_range_counter(a.id,'DP') as DP
from tbl_rule_request a, tbl_tickets b
where TO_DAYS(a.LastSeen)>TO_DAYS(NOW())-2 and a.idTicket=b.id
having (SIP>20)or (DIP>20) or SP>10 or DP>10
order by (DP+SP+DIP+SIP) DESC
19
Jun
sendmail authinfo
FEATURE(`smrsh’, `/usr/sbin/smrsh’)dnl
FEATURE(`authinfo’, `hash -o /etc/mail/authinfo.db’)dnl
FEATURE(`mailertable’, `hash -o /etc/mail/mailertable.db’)dnl
FEATURE(`virtusertable’, `hash -o /etc/mail/virtusertable.db’)dnl
/etc/mail/authinfo
AuthInfo:[1.1.1.1] “U:yourusername” “P:yourpassword” “M:LOGIN PLAIN”
/etc/mail/mailertable
testmail.com esmtp:[1.1.1.1]
#make
O LogLevel=15
sendmail restart
23
Jan
mod_reqtimeout.so
Apache slowris attack
LoadModule reqtimeout_module modules/mod_reqtimeout.so
RequestReadTimeout header=10-30,MinRate=500 body=10,MinRate=2000
13
Jan
xen virt-manager tap2
http://wiki.centos.org/HowTos/Xen/Xen4QuickStart
http://wiki.centos.org/HowTos/Xen/Xen4QuickStart/Xen4Libvirt
vi /usr/lib/python2.6/site-packages/virtinst/VirtualDisk.py
replace “tap” ==> “tap2″
python -m compileall /usr/lib/python2.6/site-packages/virtinst/
27
Oct
Phonegap - Hellow world
download android sdk, adt, unzip vao c:\adt
$ android create avd –name avd19 –target android-19
download nodejs http://nodejs.org/download/ , chon windows bin 32 hoac 64 bits, copy vao c:\adt\node.exe
download npm, http://nodejs.org/dist/npm/ , unzip vao c:\adt\
download http://ant.apache.org/ , unzip vao c:\adt\ant , set PATH=c:\adt\ant\bin
C:\> npm install -g phonegap
$ phonegap create my-app
$ cd my-app
$ phonegap install android
$ phonegap run android
$ plugman install –platform android –project “c:\adt\my-app\platforms\android” –plugin org.apache.cordova.device
$ phonegap local plugin add org.apache.cordova.device
DEBUG tool
$ npm -g install weinre
$ weinre --boundHost yourIP
open web http://yourIP:8080/client
put this line to www/index.html
<script src="http://yourIP:8080/target/target-script-min.js"></script>
cd /path/to/dir
find . -type f -name ‘*.html’ -exec grep -l “abcxyz” {} +
find . -type f -name ‘*.html’ -exec grep “abcxyz” {} +
for i in `ls /var/spool/mqueue/qf*`; do grep ‘abcxyz’ $i && rm -f $i; done
enable epel
wget http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
rpm -ivh epel-release-6-8.noarch.rpm
yum install glances
glances
mysql_query(”SET character_set_results = ‘utf8′, character_set_client = ‘utf8′, character_set_connection = ‘utf8′, character_set_database = ‘utf8′, character_set_server = ‘utf8′”);
======= on public ip vps ===============================
#ip tunnel add gre1 mode gre local [public_ip] remote [openvz_ip]
#ifconfig gre1 192.168.1.1 pointopoint 192.168.1.2
#route add [local_ip] gw 192.168.1.2
*nat
:PREROUTING ACCEPT [25003:1664683]
:POSTROUTING ACCEPT [168001:10091407]
:OUTPUT ACCEPT [168000:10091367]
-A PREROUTING -d [public_ip] -p tcp -m tcp –dport 80 -j DNAT –to-destination [local_ip]:80
-A PREROUTING -d [public_ip] -p tcp -m tcp –dport 22 -j DNAT –to-destination [local_ip]:22
-A POSTROUTING -s [local_ip] ! -d [public_ip] -j SNAT –to-source [public_ip]
COMMIT
#echo 1 > /proc/sys/net/ipv4/ip_forward
========== ON OPENVZ =====================
#ip tunnel add gre1 mode gre remote [public_ip] local [openvz_ip]
#ifconfig gre1 192.168.1.2 pointopoint 192.168.1.1
#ifconfig gre1 192.168.1.2 pointopoint 192.168.1.1
echo “201 gre_1″ >> /etc/iproute2/rt_tables
# /sbin/ip rule add from [local_ip] table gre_1 # /sbin/ip route add throw [openvz_ip] table gre_1 # /sbin/ip route add default via 192.168.1.1 table gre_1