Mirror of JVM's Blog

2008년 7월 18일 금요일

[Link] IIS Admin Blog + ASP Free Forums

How to install MySQL and PHP on IIS 6.0

/** db와 user를 생성하고 사용 권한을 주는 기본적인 명령 **/
mysql> CREATE DATABASE databasename;

mysql> CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

mysql> GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , ALTER ON 'databasename' . * TO 'username'@'localhost';

// 이 명령을 실행하면 error가 발생하는 데 syntax가 잘못되었다고 하지만 어디가 정확히 잘못된 것인지 찾지 못해 db생성은 phpMyAdmin을 사용하였다.

mysql> FLUSH PRIVILEGES;

mysql> CREATE DATABASE databasename;

mysql> GRANT ALL PRIVILEGES ON databasename.* TO "dbusername"@"hostname"
-> IDENTIFIED BY "password";

mysql> FLUSH PRIVILEGES;

Using PHP with MS SQL Server

2008년 7월 17일 목요일

[Link] Getting Started With OpenSolaris 2008.05

Getting Started With OpenSolaris 2008.05

Document Information

1. Getting Started With OpenSolaris 2008.05

2. Getting Started With the Image Packaging System

IPS Overview

IPS for End Users (Tasks)

Installing Developer Software (Tasks)

IPS for Developers (Commands)

IPS For Developers (Tasks)

Further Information

pkg(1) Command Reference

Glossary

NetBeans Packages

Sun Studio Express 5/08 Packages

Web Stack Packages

3. Upgrading and Managing Your Boot Environments

[scrap] Howto use Blastewave and Sunfreeware Repositories in OpenSolaris 2008.05

[Source] EDV - Ende der Vernunft

First how much stuff is in it?

jvm@is7:~# pkg list -a | wc -l
9214

Now add the repos.

jvm@is7:~# pkg set-authority -O http://blastwave.network.com:10000 blastwave
jvm@is7:~# pkg set-authority -O http://pkg.sunfreeware.com:9000 sunfreeware.com

And update.

jvm@is7:~# pkg refresh

So you get.

jvm@is7:~# pkg list -a | wc -l
11224

2008년 7월 11일 금요일

YouTube Video Quality Investigation

http://www.youtube.com/watch?v=U6KoEfczGEo 에서 공급한 동영상 소스

more..

DoA님께서 블로그에 올리신 소스

more..

http://www.youtube.com/watch?v=U6KoEfczGEo&fmt=18 에서 capture.

수정된 고화질용 소스

/** 고화질 요청이 적용되지 않음. **/

DoA님께서 블로그에 올리신 고화질용 소스

/** 고화질 요청이 적용되었음. **/

제목처럼 거창한 작업은 아니지만 나름대로 상당히 번거로운 포스팅이 되고 말았다.
위에서 알 수 있듯이 http://www.youtube.com/watch?v=U6KoEfczGEo&fmt=18 를 통해 고화질 비디오를 보는 것은 가능하였으나 동영상 소스 삽입은 동작하지 않았다.
이러한 현상이 일부 비디오에 해당하는 문제인지 전체 YouTube에 해당하는 문제인지는 아직 알 수 없다.
예전에 블로그에 올린 YouTube 비디오들은 다 사전에 두 버전을 비교해보았었기 때문에 당연히 작동한다고 믿고 있었던 것이 잘못된 것이었다.

2008년 7월 7일 월요일

Route Poisoning

[Source] Wikipedia, the free encyclopedia

Route poisoning is a way to prevent routing loops.
Distance-vector routing protocols use route poisoning to indicate to other routers that a route is no longer reachable and should be removed from their routing tables.
A variation of route poisoning is split horizon with poison reverse whereby a router sends updates with unreachable hop counts back to the sender for every route received to help prevent routing loops.

A route is considered unreachable if the hop count exceeds the maximum allowed. Route poisoning is a method of quickly removing outdated routing information from other router's routing tables by changing its hop count to be unreachable (higher than the maximum number of hops allowed) and sending a routing update.

In the case of the Routing Information Protocol (RIP), to perform route poisoning on a route its hop count is changed to 16, deeming it unreachable (sometimes referred to as an Infinite metric) and a routing update is sent.

Ethernet0 on GW_Router went down.
The Router is poisoning the routes and multicasting the new path costs via Ethernet1.

When a router receives a route poisoning, it sends an update back to the router from which it received the route poisoning, this is called poison reverse. This is to ensure that all routers on a segment have received the poisoned route information.

The security protocols to secure wireless computer networks

[Source] Wikipedia, the free encyclopedia

Wired Equivalent Privacy (WEP)

WEP is a deprecated algorithm to secure IEEE 802.11 wireless networks. Wireless networks broadcast messages using radio and are thus more susceptible to eavesdropping than wired networks.
Beginning in 2001, several serious weaknesses were identified by cryptanalysts with the result that today a WEP connection can be cracked with readily available software within minutes.

Two methods of authentication can be used with WEP: Open System authentication and Shared Key authentication.

Encryption Algorithm : stream cipher RC4 for confidentiality, CRC-32 checksum for integrity.

Wi-Fi Protected Access (WPA and WPA2)

WPA is a certification program created by the Wi-Fi Alliance.
The WPA certification mark indicates compliance with a security protocol designed to enhance the security of wireless networks.

There are two flavors of this protocol: enterprise and personal.
Enterprise is meant for use with an IEEE 802.1X authentication server, which distributes different keys to each user.
Personal WPA utilizes less scalable "pre-shared key" (PSK) mode, where every allowed computer is given the same passphrase.
The WPA and WPA2 standard has officially adopted five EAP(Extensible Authentication Protocol) types as its official authentication mechanisms.

Data is encrypted using the RC4 stream cipher, with a 128-bit key and a 48-bit initialization vector(IV). One major improvement in the protocol over WEP is the Temporal Key Integrity Protocol (TKIP), which dynamically changes keys as the system is used.

In addition to authentication and encryption, the protocol also provides vastly improved payload integrity. The cyclic redundancy check (CRC) used in WEP is inherently insecure; A more secure message authentication code (MIC : message integrity code) is used in the protocol.

WPA2 introduces a new AES(Advanced Encryption Standard)-based algorithm, CCMP(Counter Mode with Cipher Block Chaining Message Authentication Code Protocol), that is considered fully secure. CCMP uses AES algorithm. Unlike TKIP, key management and message integrity is handled by a single component built around AES.

Comparison

	Authentication	Encryption Algorithm	Encryption Method
WEP	Open System authentication Shared Key authentication	RC4	WEP
WPA	802.1x / EAP / PSK	RC4	TKIP
WPA2	802.1x / EAP / PSK	AES	CCMP