- Close All Open Excel.
- Go to C:\Documents and Settings\[userID]\Application Data\Microsoft\Excel
- Delete the XLB file.
- Open Excel (the XLB file will be recreated - like the normal.dot)
Windows and linux information and one stop centre for myself. Having difficulties to remember all things at once. This blog will remain be my references on the internet. Other people can take benefit from it. Thank you for visiting
Monday, September 19, 2011
Excel 2007 No Right Click Menu - AGAIN!!
If a user doesn't have the option menu on right click in Excel, do the following:
Thursday, August 11, 2011
Iptables block facebook
There are many “solutions” for blocking your company employees accessing Yahoo Messenger, hi5, Facebook or any other distracting services, but none of them is working properly.
So here is a perfect solution:
What you need:
- linux router for your network
- iptables firewall at least v1.3.7
Here are the rules:
Deny Yahoo Messenger packets:
iptables -I FORWARD -m string --string 'YMSG' --algo bm -j DROP
iptables -I FORWARD -m string --string 'messenger' --algo bm -j DROP
iptables -I FORWARD -m string --string 'meebo' --algo bm -j DROP
iptables -I FORWARD -m string --string 'buddy' --algo bm -j DROP
iptables -I FORWARD -m string --string 'webmessenger' --algo bm -j DROP
iptables -I FORWARD -m string --string 'web-messenger' --algo bm -j DROP
Deny facebook traffic rule:
iptables -I FORWARD -m string --string 'facebook' --algo bm -j DROP
Deny hi5 traffic rule:
iptables -I FORWARD -m string --string 'hi5' --algo bm -j DROP
and so on… you can modify these rules to fit your needs, you just need to edit the –string parameter
--string ''
Using this solution to filter specified traffic you don’t have to worry about port, protocol, application , source or destination.
Hope it helps someone.
So here is a perfect solution:
What you need:
- linux router for your network
- iptables firewall at least v1.3.7
Here are the rules:
Deny Yahoo Messenger packets:
iptables -I FORWARD -m string --string 'YMSG' --algo bm -j DROP
iptables -I FORWARD -m string --string 'messenger' --algo bm -j DROP
iptables -I FORWARD -m string --string 'meebo' --algo bm -j DROP
iptables -I FORWARD -m string --string 'buddy' --algo bm -j DROP
iptables -I FORWARD -m string --string 'webmessenger' --algo bm -j DROP
iptables -I FORWARD -m string --string 'web-messenger' --algo bm -j DROP
Deny facebook traffic rule:
iptables -I FORWARD -m string --string 'facebook' --algo bm -j DROP
Deny hi5 traffic rule:
iptables -I FORWARD -m string --string 'hi5' --algo bm -j DROP
and so on… you can modify these rules to fit your needs, you just need to edit the –string parameter
--string '
Using this solution to filter specified traffic you don’t have to worry about port, protocol, application , source or destination.
Hope it helps someone.
Block Internet Messenger With Iptables
normally we will use port filtering with iptables to block the internal user from accessing unwanted application or website but here the tips for you to do it :
If you’re a network administrator and you’re using Linux on your servers, you can stop the rest of the users from using IM applications by blocking their access to the most-used IM protocols:
ICQ and AOL:
# iptables -A FORWARD –dport 5190 -j DROP
# iptables -A FORWARD -d login.oscar.aol.com -j DROP
MSN:
# iptables -A FORWARD -p TCP –dport 1863 -j DROP
# iptables -A FORWARD -d 64.4.13.0/24 -j DROP
Yahoo Messenger:
# iptables -A FORWARD -p TCP –dport 5000:5010 -j REJECT
# iptables -A FORWARD -d cs.yahoo.com -j REJECT
# iptables -A FORWARD -b scsa.yahoo.com -j REJECT
If you’re a network administrator and you’re using Linux on your servers, you can stop the rest of the users from using IM applications by blocking their access to the most-used IM protocols:
ICQ and AOL:
# iptables -A FORWARD –dport 5190 -j DROP
# iptables -A FORWARD -d login.oscar.aol.com -j DROP
MSN:
# iptables -A FORWARD -p TCP –dport 1863 -j DROP
# iptables -A FORWARD -d 64.4.13.0/24 -j DROP
Yahoo Messenger:
# iptables -A FORWARD -p TCP –dport 5000:5010 -j REJECT
# iptables -A FORWARD -d cs.yahoo.com -j REJECT
# iptables -A FORWARD -b scsa.yahoo.com -j REJECT
Friday, July 15, 2011
Final Cut Alternative For Linux
I'm new to video editing..just explore the net and found the Final Cut Video Editing alternative
1. Cinelerra http://www.cinelerra.org
2. Lumiera http://www.lumiera.com - born as a rewrite of Cinelerra
these two software of course an Open Source but not available yet for windows :P
Thursday, July 14, 2011
Load Balance Within Two or More ISP Using Slackware
i've got this from the net.. not sure where did i found it.. its a couple years in my note since playing with slackware and it does really work.
====== START =======
#!/bin/bash
#
# bal_local Load-balance internet connection over two local links
#
# Version: 1.0.0 - Fri, Sep 26, 2008
#
# Author: Niels Horn
#
# Set devices:
DEV1=${1-eth0} # default eth0
DEV2=${2-ppp0} # default ppp0
# Get IP addresses of our devices:
ip1=`ifconfig $DEV1 | grep inet | awk '{ print $2 }' | awk -F: '{ print $2 }'`
ip2=`ifconfig $DEV2 | grep inet | awk '{ print $2 }' | awk -F: '{ print $2 }'`
# Get default gateway for our devices:
gw1=`route -n | grep $DEV1 | grep '^0.0.0.0' | awk '{ print $2 }'`
gw2=`route -n | grep $DEV2 | grep '^0.0.0.0' | awk '{ print $2 }'`
echo "$DEV1: IP=$ip1 GW=$gw1"
echo "$DEV2: IP=$ip2 GW=$gw2"
### Definition of routes ###
# Check if tables exists, if not -> create them:
if [ -z "`cat /etc/iproute2/rt_tables | grep '^251'`" ] ; then
echo "251 rt_dev1" >> /etc/iproute2/rt_tables
fi
if [ -z "`cat /etc/iproute2/rt_tables | grep '^252'`" ] ; then
echo "252 rt_dev2" >> /etc/iproute2/rt_tables
fi
# Define routing tables:
ip route add default via $gw1 table rt_dev1
ip route add default via $gw2 table rt_dev2
# Create rules:
ip rule add from $ip1 table rt_dev1
ip rule add from $ip2 table rt_dev2
# If we already have a 'nexthop' route, delete it:
if [ ! -z "`ip route show table main | grep 'nexthop'`" ] ; then
ip route del default scope global
fi
# Balance links based on routes:
ip route add default scope global nexthop via $gw1 dev $DEV1 weight 1 nexthop via $gw2 dev $DEV2 weight 1
# Flush cache table:
ip route flush cache
# All done..
chmod +x the script and call it with ./yourscript eth0 ppp0 after connected to the internet. change accordingly to fit your need such as adding more ISP
====== START =======
#!/bin/bash
#
# bal_local Load-balance internet connection over two local links
#
# Version: 1.0.0 - Fri, Sep 26, 2008
#
# Author: Niels Horn
#
# Set devices:
DEV1=${1-eth0} # default eth0
DEV2=${2-ppp0} # default ppp0
# Get IP addresses of our devices:
ip1=`ifconfig $DEV1 | grep inet | awk '{ print $2 }' | awk -F: '{ print $2 }'`
ip2=`ifconfig $DEV2 | grep inet | awk '{ print $2 }' | awk -F: '{ print $2 }'`
# Get default gateway for our devices:
gw1=`route -n | grep $DEV1 | grep '^0.0.0.0' | awk '{ print $2 }'`
gw2=`route -n | grep $DEV2 | grep '^0.0.0.0' | awk '{ print $2 }'`
echo "$DEV1: IP=$ip1 GW=$gw1"
echo "$DEV2: IP=$ip2 GW=$gw2"
### Definition of routes ###
# Check if tables exists, if not -> create them:
if [ -z "`cat /etc/iproute2/rt_tables | grep '^251'`" ] ; then
echo "251 rt_dev1" >> /etc/iproute2/rt_tables
fi
if [ -z "`cat /etc/iproute2/rt_tables | grep '^252'`" ] ; then
echo "252 rt_dev2" >> /etc/iproute2/rt_tables
fi
# Define routing tables:
ip route add default via $gw1 table rt_dev1
ip route add default via $gw2 table rt_dev2
# Create rules:
ip rule add from $ip1 table rt_dev1
ip rule add from $ip2 table rt_dev2
# If we already have a 'nexthop' route, delete it:
if [ ! -z "`ip route show table main | grep 'nexthop'`" ] ; then
ip route del default scope global
fi
# Balance links based on routes:
ip route add default scope global nexthop via $gw1 dev $DEV1 weight 1 nexthop via $gw2 dev $DEV2 weight 1
# Flush cache table:
ip route flush cache
# All done..
chmod +x the script and call it with ./yourscript eth0 ppp0 after connected to the internet. change accordingly to fit your need such as adding more ISP
Saturday, June 11, 2011
Tuesday, June 7, 2011
Remove Blogger Navbar
Want to make your blog page ever nice without navigation bar like mine?
go to Design then edit HTML
then put
#navbar-iframe { display: none !important;}
just before the
/* Variable definitions
====================
save your template and you're done!
go to Design then edit HTML
then put
#navbar-iframe { display: none !important;}
just before the
/* Variable definitions
====================
save your template and you're done!
Friday, June 3, 2011
3D Cross Eye image
Naik juling mata aku tengok benda ni.. mula-mula tak faham tapi last2 jadi jugak.. cara nak tengok gambar ni dalam bentuk 3 dimensi :
1. praktik cara melihat hujung hidung anda dengan dua dua mata.. naik juling mata tu..
2. gunakan teknik yang sama untuk cantumkan gambar hasilnya akan kelihatan 3 gambar. fokuskan gambar yang di tengah iaitu gambar 3 dimensi. sesuatu yang menarik menanti anda.
Saturday, May 14, 2011
Wrestling with RTL8187
phew!!! just struggling to replace built-in kernel driver for rtl 8187 which using RTL8187se. The built-in kernel driver give me such problem on unconsistent speed and disconnected from the net. Here is the solution :
wget http://download.aircrack-ng.org/drivers/rtl8187_linux_26.1010.zip
wget http://dl.dropbox.com/u/1522424/rtl8187_2.6.34.patch
unzip rtl8187_linux_26.1010.zip
cd rtl8187_linux_26.1010.0622.2006
tar xzf drv.tar.gz
tar xzf stack.tar.gz
patch -Np1 -i ../rtl8187_2.6.34.patch
make
make install
rmmod r8187 rtl8187 mac80211 cfg80211
modprobe r8187 Hope this help!
Thursday, April 21, 2011
I'm Tired!!!
don't have enough time to post the new adventure in linux os.. even with my blog page.. quite busy with activities that make me happy with it after getting so long to think about what's going on with my life. shocked and dissapointed ! thank you for what we call it Frie**ship
Subscribe to:
Comments (Atom)
Simple Python Calculator This script will allows your to calculate the integers given with the chosen operation. You can add, substract, mu...
-
when trying to apt-get update i got this error message :- W: There is no public key available for the following key IDs xxxxxxxxxxxx t...
-
Skrip ini aku guna kat server aku.. backup mysql setiap hari. Hanya perlu ubah pada bahagian setting sahaja. chmod dan set cron untuk daily ...
-
This tutorial will help you get AWStats and Lighttpd working together. AWStats is an excellent log analyzer, and works well with Lighttpd. T...
