OSPF interception

To avoid interception on a segment between two OSPF nodes, do the following:

- configure the ospf intrface as nonbroadcast

- configure the nodes to be neighbor each other

To verify the settings:

# show ip ospf interface interface

# debug ip ospf hello

OSPF priorty 0

An OSPF router with 0 priority will never be a BDR or DR.

Furthermore, giving 0 priority to an OSPF router will remove the DR/BDR status from it immediately and will trigger a new election.

CCIE written passed

After several times postponing to take the exam, I finally decided to take the exam on 11 Jan 2009 and passed it.

I know that passing the written exam doesn't mean anything except that now I can register for the lab exam. However, considering my hard work to prepare this exam, I should celebrate this achievement :D

Now it's the time to read the blueprint for the lab and learn harder on the lab exam preparation.

import CSV into mysql

LOAD DATA LOCAL INFILE '/importfile.csv'
INTO TABLE test_table
FIELDS TERMINATED BY ','

Export a table on MySQL

select * into outfile '/tmp/outfile.txt' fields terminated by ',' from my_table_name;

Install TC Expect on Ubuntu

I have an Ubuntu machine, and want to install Expect on this machine using apt-get.

However, the current version of TCL doesn't have Expect. Therefore, I have to remove tcl8.3 first prior to install expect

Here are the steps

# apt-get remove tcl8.3

# apt-get install tcl

# apt-get install expect

Missing Expect on ActiveTCL

Previously, Expect is included on ActiveTCL installation. But regarding to the size of the installer, the new version doesn't have Expect included on the installer.

We need to redownload Expect and install it.

Here is the command to do that:

teacup install Expect