H blog: 2005

星期六, 12月 10, 2005

sun cluster-How to Create Cluster File Systems

星期四, 11月 24, 2005

Running a Reverse Proxy with Apache

星期六, 11月 19, 2005

SANS

SANS is the most trusted and by far the largest source for information security training and certification in the world. It also develops, maintains, and makes available at no cost, the largest collection of research documents about various aspects of information security, and it operates the Internet's early warning system - Internet Storm Center. The SANS (SysAdmin, Audit, Network, Security) Institute was established in 1989 as a cooperative research and education organization. Its programs now reach more than 165,000 security professionals, auditors, system administrators, network administrators, chief information security officers, and CIOs who share the lessons they are learning and jointly find solutions to the challenges they face. At the heart of SANS are the many security practitioners in government agencies, corporations, and universities around the world who invest hundreds of hours each year in research and teaching to help the entire information security community.

OpenSSL for Win32 using Apache

OpenSSL for Win32 using ApacheApache 2.0.52 & OpenSSL 0.9.7e (installed on Dec 26, 2004)
Old Appache HTTP Archive at http://archive.apache.org/dist/httpd/

This page will describe the required software and tools to get Secure Sockets Layer, SSL, up and running under Windows 2000 using the Apache server. Before we proceed to the following page make sure you have downloaded the required software. The only assumption made is that the Apache 2.0.52 is already installed and running with out SSL support.

Some of this document is a repeat of easily obtain documents found on the web with additional information found through experience. Regardless, this document exist mainly for myself (and you) because there is no guarantee the existing website documents will be around in the near future. In addition, setting up a server, for me, is a one time process. I set it up, forget it and move on to development and that is exactly what will happen - I will forget it. This page will be a valuable tool for reinstalling the server...with SSL support.

OpenVPN

OpenVPN is a full-featured SSL VPN solution which can accomodate a wide range of configurations, including remote access, site-to-site VPNs, WiFi security, and enterprise-scale remote access solutions with load balancing, failover, and fine-grained access-controls (articles) (examples) (security overview) (non-english languages).

星期日, 10月 09, 2005

ITPapers

ITPapers is the Web's largest library of technical IT white papers, webcasts, and case studies. Covering IT categories including Data Management, IT Management, Networking, Communications, Enterprise Applications, Storage, Security and much more, ITPapers.com is the best source for technical white papers and IT information.

星期一, 9月 12, 2005

R-Proxy - 使用Apache架設

星期三, 8月 31, 2005

DNS 線上教學計畫

星期六, 8月 06, 2005

AVI 轉 VCD SVCD DVD

星期三, 7月 13, 2005

PSP-另類影音播放機(1/18 新增影片轉檔程式心得)

星期日, 5月 29, 2005

Apache Mod SSL - ArsLinuxWiki

星期四, 5月 26, 2005

保護 apache Web 伺服器

developerWorks (Taiwan): a worldwide resource for developers

星期日, 4月 10, 2005

優客筆記簿

星期五, 4月 01, 2005

學生用伺服器建置流程

星期日, 2月 27, 2005

How XP SP2 affects the Local Machine

星期四, 2月 24, 2005

主旨:php-5.0.2-Win32.zip如何安裝？(xp)

主旨:php-5.0.2-Win32.zip如何安裝？(xp)"

星期六, 2月 19, 2005

PC INSPECTOR

星期五, 2月 11, 2005

Apache 2.0.52 / SSL, PHP 5.0.3, MySQL 4.1.9 on Linux -- WELL.DONE (c) Radek Hulan

PHP5知識交換中心 - php5,java,jsp,mysql,pgsql,flash,sql,xml,php5網管實驗室

PHP5知識交換中心 - php5,java,jsp,mysql,pgsql,flash,sql,xml,php5 網管實驗室

關聯資料表的附加功能未能啟動，解決方法

關聯資料表的附加功能未能啟動，解決方法如下：
Source PHP 5知識交換中心伊蘇小勇者
要先建立一個 phpmyadmin 的資料庫

快速解決方案:
執行以下sql語法,把所有需要的table建立到phpmyadmin資料庫裡面
#
# 資料表格式： `PMA_bookmark`
#

CREATE TABLE `PMA_bookmark` (
`id` int(11) NOT NULL auto_increment,
`dbase` varchar(255) NOT NULL default '',
`user` varchar(255) NOT NULL default '',
`label` varchar(255) NOT NULL default '',
`query` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='Bookmarks' AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# 資料表格式： `PMA_column_info`
#

CREATE TABLE `PMA_column_info` (
`id` int(5) unsigned NOT NULL auto_increment,
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`column_name` varchar(64) NOT NULL default '',
`comment` varchar(255) NOT NULL default '',
`mimetype` varchar(255) NOT NULL default '',
`transformation` varchar(255) NOT NULL default '',
`transformation_options` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`)
) TYPE=MyISAM COMMENT='Comments for Columns' AUTO_INCREMENT=24 ;

# --------------------------------------------------------

#
# 資料表格式： `PMA_history`
#

CREATE TABLE `PMA_history` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`username` varchar(64) NOT NULL default '',
`db` varchar(64) NOT NULL default '',
`table` varchar(64) NOT NULL default '',
`timevalue` timestamp(14) NOT NULL,
`sqlquery` text NOT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`,`db`,`table`,`timevalue`)
) TYPE=MyISAM COMMENT='SQL history' AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# 資料表格式： `PMA_pdf_pages`
#

CREATE TABLE `PMA_pdf_pages` (
`db_name` varchar(64) NOT NULL default '',
`page_nr` int(10) unsigned NOT NULL auto_increment,
`page_descr` varchar(50) NOT NULL default '',
PRIMARY KEY (`page_nr`),
KEY `db_name` (`db_name`)
) TYPE=MyISAM COMMENT='PDF Relationpages for PMA' AUTO_INCREMENT=3 ;

# --------------------------------------------------------

#
# 資料表格式： `PMA_relation`
#

CREATE TABLE `PMA_relation` (
`master_db` varchar(64) NOT NULL default '',
`master_table` varchar(64) NOT NULL default '',
`master_field` varchar(64) NOT NULL default '',
`foreign_db` varchar(64) NOT NULL default '',
`foreign_table` varchar(64) NOT NULL default '',
`foreign_field` varchar(64) NOT NULL default '',
PRIMARY KEY (`master_db`,`master_table`,`master_field`),
KEY `foreign_field` (`foreign_db`,`foreign_table`)
) TYPE=MyISAM COMMENT='Relation table';

# --------------------------------------------------------

#
# 資料表格式： `PMA_table_coords`
#

CREATE TABLE `PMA_table_coords` (
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`pdf_page_number` int(11) NOT NULL default '0',
`x` float unsigned NOT NULL default '0',
`y` float unsigned NOT NULL default '0',
PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`)
) TYPE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output';

# --------------------------------------------------------

#
# 資料表格式： `PMA_table_info`
#

CREATE TABLE `PMA_table_info` (
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`display_field` varchar(64) NOT NULL default '',
PRIMARY KEY (`db_name`,`table_name`)
) TYPE=MyISAM COMMENT='Table information for phpMyAdmin';

config.inc.php 中以下相關地方修改:
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

$cfg['Servers'][$i]['bookmarktable'] = 'PMA_bookmark';

$cfg['Servers'][$i]['relation'] = 'PMA_relation';

$cfg['Servers'][$i]['table_info'] = 'PMA_table_info';

$cfg['Servers'][$i]['table_coords'] = 'PMA_table_coords';

$cfg['Servers'][$i]['pdf_pages'] = 'PMA_pdf_pages';

$cfg['Servers'][$i]['column_info'] = 'PMA_column_info';

$cfg['Servers'][$i]['history'] = 'PMA_history';