500 Internal Server Error

今天在Youtube上看影片，突然出現下面這個畫面

原來YouTube是一群猴子在維護的。

T1/E1 Pinout (RJ-48C)

T1/E1 wiring may use either a RJ45, DB15 or BNC connectors. The pinout shown uses RJ45 connectors - its formal name is USOC RJ-48C and is defined in ANSI T1-403-1989. T1 is a North America (primarily) digital service providing 1.544 Mbps. E1 is a European/Rest of World standard providing digital service at 2.048 Mbps. CATegory 5(e) cabling is used to provide balanced pairs. The color coding for Cat 5(e) cabling may be 568A or 568B.

RJ45 Pin	Signal	Notes
1	RX1 (Ring - negative)
2	RX2 (TIP - positive)
3	FGND (RX GND)	Ground/Shield
4	TX1 (Ring - negative)
5	TX2 (TIP - positive)
6	FGND (TX GND)	Ground/Shield
7	NC	Unused
8	NC	Unused

收到附件檔名為winmail.dat檔時的處理方法

我想有在收信的網友們應該對 "winmail.dat" 檔案不陌生吧？當對方是使用outlook寄信時，往往會收到這個附加檔案，但是這個檔案應該怎麼轉換成Linux能處理的檔案類型呢？Linux裡面有一隻小程式名叫 "tnef"，利用這隻小程式就可以把原始的附加檔案給還原回來了。

原來winmail.dat的檔案格式是 Transport Neutral Encapsulation Format 。

Cisco Config Class

最近在忙ISMS的事情，對於每週要備份一次全校的Switch Configure總覺得很不耐煩，在萬般無奈下寫了一個Class，之後就可以透過這個Class來自動備份了，有興趣的人也可以到OpenFoundry去下載下來玩玩。內含範例程式及文件說明。

svn co http://svn.openfoundry.org/ciscoconfig ciscoconfig

DHCP OPTION 43 for Lightweight Cisco Aironet Access Points Configuration Example

authoritative;
ddns-update-style none;

option time-offset 28800;
option domain-name-servers 140.127.198.1;

#Define Space
option space Cisco_LWAPP_AP;
option Cisco_LWAPP_AP.server-address code 43 = string;

class "Vendor-Identifier" {
match option vendor-class-identifier;
}

subnet 172.17.0.0 netmask 255.255.255.0 {

option routers 172.17.0.254;
option subnet-mask 255.255.255.0;
option domain-name "AP.Example.com";
option broadcast-address 172.17.0.255;

#Wireless Controler IP Address Configure Option
subclass "Vendor-Identifier" "Airespace.AP1200" {
option vendor-class-identifier "Airespace 1200";
vendor-option-space Cisco_LWAPP_AP;
option Cisco_LWAPP_AP.server-address "172.17.10.1";
}

subclass "Vendor-Identifier" "Cisco AP c1500" {
option vendor-class-identifier "Cisco AP c1500";
vendor-option-space Cisco_LWAPP_AP;
option Cisco_LWAPP_AP.server-address "172.17.10.2";
}

subclass "Vendor-Identifier" "Cisco AP c1200" {
option vendor-class-identifier "Cisco AP c1200";
vendor-option-space Cisco_LWAPP_AP;
option Cisco_LWAPP_AP.server-address "172.17.10.3";
}

range dynamic-bootp 172.17.0.1 172.17.0.200;

default-lease-time 43200;
max-lease-time 86400;
}

Install Two HP FC1142SR 4Gb PCI-e HBA Card Using QLogic Fibre Channel HBA Driver (qla2xxx-8.02.21) in Ubuntu 8.04.1

Make Provision Driver Building Environment

1. apt-get install build-essential
2. apt-get install kernel-package
3. make sure that can find linux-source tarball (ex: linux-source-2.6.24.tar.bz2) in path: /usr/src
4. extract and decompress linux-source tarball (ex: tar -xvjf linux-source-2.6.24.tar.bz2)
5. change directory to /lib/modules/{kernel version} (ex: cd /lib/modules/`uname -r`)
6. create a link to linux-headers path with the name build. (ex: ln -s /usr/src/`uname -r` build)
7. create a link to linux-source path with the name build. (ex: ln -s /usr/src/linux-source-2.6.24 source)

Download QLogic Fibre Channel HBA Driver Source Code

1. change to your home directory
2. wget ftp://ftp.qlogic.com/outgoing/linux/beta/8.x/qla2xxx-src-v8.02.21.tar.gz
3. extract and decompress source code tarball file (ex: tar -xvzf qla2xxx-src-v8.02.21.tar.gz)

Modify The Driver Source Code

1. edit file extras/build.sh at first line "#!/bin/sh" to "#!/bin/bash"
   in Ubuntu Linux the default "sh" had been symbolic linking to "dash", there are some functions can't be executable in build.sh scrip.
2. edit file qla_def.h, remark line 33 ~ 35.
3. edit file qla_isr.c,. replace "SA_INTERRUPT|SA_SHIRQ" with "IRQF_DISABLED|IRQF_SHARED" at line 2100.
4. edit file qla_os.c, add "struct" in front of "kmem_cache *srb_cachep;" at line 40.
5. remove ones of NULL at line 5723 in file qla_os.c
6. replace "pci_module_init" with "pci_register_driver" at line 5759 in file qla_os.c
   

Get ready to build Driver

1. change user to root.
2. execute "extras/build.sh" in qla2xxx-8.02.21 directory.

Now You Can Install this Driver, If Everything is O Kay.

1. execute "extras/build.sh install" to install Driver.
2. execute "update-initramfs -v -u -k `uname -r`" to update initramfs image.

Reboot System to Test New Initial Ramdisk and Pray It Can Work..... just kindling ^_^

If this Document can help you,
Please me. Thanks a lot.

Resetting MySQL Root Password on Unix Systems

Use the following procedure for resetting the password for any MySQL root accounts on Unix. The instructions assume that you will start the server so that it runs using the Unix login account that you normally use for running the server. For example, if you run the server using the mysql login account, you should log in as mysql before using the instructions. (Alternatively, you can log in as root, but in this case you must start start mysqld with the --user=mysql option. If you start the server as root without using --user=mysql, the server may create root-owned files in the data directory, such as log files, and these may cause permission-related problems for future server startups. If that happens, you will need to either change the ownership of the files to mysql or remove them.)

1. Log on to your system as the Unix mysql user that the mysqld server runs as.

2. Locate the .pid file that contains the server's process ID. The exact location and name of this file depend on your distribution, hostname, and configuration. Common locations are /var/lib/mysql/, /var/run/mysqld/, and /usr/local/mysql/data/. Generally, the filename has an extension of .pid and begins with either mysqld or your system's hostname.

   You can stop the MySQL server by sending a normal kill (not kill -9) to the mysqld process, using the pathname of the .pid file in the following command:

   shell> kill `cat /mysql-data-directory/host_name.pid`
   

   Note the use of backticks rather than forward quotes with the cat command; these cause the output of cat to be substituted into the kill command.

3. Create a text file and place the following statements in it. Replace the password with the password that you want to use.

   UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
   FLUSH PRIVILEGES;
   

   The UPDATE and FLUSH statements each must be written on a single line. The UPDATE statement resets the password for all existing root accounts, and the FLUSH statement tells the server to reload the grant tables into memory.

4. Save the file. For this example, the file will be named /home/me/mysql-init. The file contains the password, so it should not be saved where it can be read by other users.

5. Start the MySQL server with the special --init-file option:

   shell> mysqld_safe --init-file=/home/me/mysql-init &
   

   The server executes the contents of the file named by the --init-file option at startup, changing each root account password.

6. After the server has started successfully, delete /home/me/mysql-init.

You should now be able to connect to MySQL as root using the new password.

Alternatively, on any platform, you can set the new password using the mysql client (but this approach is less secure):

1. Stop mysqld and restart it with the --skip-grant-tables option.

2. Connect to the mysqld server with this command:

   shell> mysql
   

3. Issue the following statements in the mysql client. Replace the password with the password that you want to use.

   mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass')
      ->                   WHERE User='root';
   mysql> FLUSH PRIVILEGES;
   

You should now be able to connect to MySQL as root using the new password.