顯示文章

這裡允許您檢視這個會員的所有文章。請注意, 您只能看見您有權限閱讀的文章。


主題 - olderboy

頁: [1] 2
1
Dear All

我知道mysql 有 mysqlbinlog 可以把每一筆執行過的sql 產生出來
但產生出來的是所有的sql command

如我今天有三個人在修改資料庫,那我想知道這筆資料是誰修改的,似乎用mysqlbinlog 好像是無法查出來的。
不知道大家都是用什麼方法來做這方面的查詢呢??

感謝大家的指導

2

網路上有關KVM這個VM的資訊,還真的相當的少
我最近在CentOS 5上,己經將KVM的module載入了,也可以順利的安裝 CentOS 及 Windows 2003 、XP,運作起來也都滿順利的沒什麼問題。
但唯獨在network的設定上,讓我感到相當的頭痛。

有看了http://kvm.qumranet.com/kvmwiki/Networking官網上所寫的方式去做,但guest OS始終無法連線到 host OS的local network 上
都一直是處於一個獨立的網段,不知有沒有人,有試過這套軟體的呢??

是否可以討論一下。

Nick

3
Linux 討論版 / 請教rewrite 寫法
« 於: 2008-07-24 11:14 »
想請教大家一下有關 rewrite的問題

我現在想做一個功能,當大家打 http://www.xxxx.idv.tw/aaabbb 時,就會把網頁導到後端的tomcat去抓取資料
那我的寫法如下:
引用
RewriteRule   ^/([a-z0-9]+)$               ajp://192.168.1.18:8009/m/vi.do?alias=$1  [P,L]

但這樣寫,我會發現一個問題,就是如果用戶,只要打 www.xxxx.idv.tw/xxx,xxx隨便打的話!!都會導到後端的tomcat去
且access_log裡顯示的是:
引用
http://www.xxxx.idv.tw/xxx?alias=xxx

為什麼access_log不是顯示:
引用
http://www.xxxx.idv.tw/m/vi.do?alias=xxx
呢??

有沒有可能有什麼辦法,可以讓只存在的名稱,才往tomcat去送呢??
我想了很久,似乎是沒有辦法這樣做的樣子

不知大家有沒有什麼想法呢??

Thanks

Olderboy

4
Linux 討論版 / About Apache's mod_cache
« 於: 2008-07-21 10:06 »
Dear All

我參考了http://httpd.apache.org/docs/2.2/mod/mod_cache.html,官網上面的文章,但也把設定值設定進去後
不知該如何去測試mod_cache是否有生效呢??

以下是我的設定內容:
引用
CacheRoot "/var/cache/mod_proxy"
CacheEnable disk http://192.168.1.118/member.do
CacheDirLevels 5
CacheDirLength 3
CacheMaxExpire 24
CacheLastModifiedFactor 0.1
CacheDefaultExpire 1

我是想把後端的tomcat上的某一些程式,做成cache放到apache上,好加快讀取的速度
但我一直覺得好像設定是沒有生效的,不知道有沒有人測試過這樣的東西呢??
我上google查了很久,似乎用的人也不多

且看起來好像是要跟proxy server搭配使用才會有效果的樣子,不知道是不是真的是如此呢??
還是可以單獨直接設定在apache上,來做cache 呢??

還請有用過的人,可以在指點一下,我也會在google上繼續找找相關的資料了~

Thanks
olderboy

5
Linux 討論版 / rewrite log
« 於: 2008-07-15 10:17 »
想請教一下大家

我在我的apache上,使用了rewrite,當我打開後,rewrite log 出現了下面的訊息

引用
98.223.148.4 - - [15/Jul/2008:10:11:16 +0800] [124.108.97.193/sid#9bca100][rid#9c3e9a8/initial/redir#1] (4) RewriteCond: input='/error/HTTP_UNAUTHORIZED.html.var' pattern='.cab$' => not-matched
98.223.148.4 - - [15/Jul/2008:10:11:16 +0800] [124.108.97.193/sid#9bca100][rid#9c3e9a8/initial/redir#1] (3) applying pattern '/(.*)$' to uri '/error/HTTP_UNAUTHORIZED.html.var'
98.223.148.4 - - [15/Jul/2008:10:11:16 +0800] [124.108.97.193/sid#9bca100][rid#9c3e9a8/initial/redir#1] (4) RewriteCond: input='/error/HTTP_UNAUTHORIZED.html.var' pattern='a.jpg$' => not-matched
98.223.148.4 - - [15/Jul/2008:10:11:16 +0800] [124.108.97.193/sid#9bca100][rid#9c3e9a8/initial/redir#1] (3) applying pattern '/(.*)$' to uri '/error/HTTP_UNAUTHORIZED.html.var'
98.223.148.4 - - [15/Jul/2008:10:11:16 +0800] [124.108.97.193/sid#9bca100][rid#9c3e9a8/initial/redir#1] (4) RewriteCond: input='/error/HTTP_UNAUTHORIZED.html.var' pattern='VerifyHumanInput.gif$' => not-matched
98.223.148.4 - - [15/Jul/2008:10:11:16 +0800] [124.108.97.193/sid#9bca100][rid#9c3e9a8/initial/redir#1] (3) applying pattern '^(.+)' to uri '/error/HTTP_UNAUTHORIZED.html.var'
98.223.148.4 - - [15/Jul/2008:10:11:16 +0800] [124.108.97.193/sid#9bca100][rid#9c3e9a8/initial/redir#1] (4) RewriteCond: input='/error/HTTP_UNAUTHORIZED.html.var' pattern='^/abraincrush$' => not-matched
98.223.148.4 - - [15/Jul/2008:10:11:16 +0800] [124.108.97.193/sid#9bca100][rid#9c3e9a8/initial/redir#1] (3) applying pattern '^(.+)' to uri '/error/HTTP_UNAUTHORIZED.html.var'
98.223.148.4 - - [15/Jul/2008:10:11:16 +0800] [124.108.97.193/sid#9bca100][rid#9c3e9a8/initial/redir#1] (4) RewriteCond: input='/error/HTTP_UNAUTHORIZED.html.var' pattern='^/m$' => not-matched
98.223.148.4 - - [15/Jul/2008:10:11:16 +0800] [124.108.97.193/sid#9bca100][rid#9c3e9a8/initial/redir#1] (3) applying pattern '/(.*)$' to uri '/error/HTTP_UNAUTHORIZED.html.var'
98.223.148.4 - - [15/Jul/2008:10:11:16 +0800] [124.108.97.193/sid#9bca100][rid#9c3e9a8/initial/redir#1] (4) RewriteCond: input='/error/HTTP_UNAUTHORIZED.html.var' pattern='^/group$' => not-matched
98.223.148.4 - - [15/Jul/2008:10:11:16 +0800] [124.108.97.193/sid#9bca100][rid#9c3e9a8/initial/redir#1] (3) applying pattern '^(.+)' to uri '/error/HTTP_UNAUTHORIZED.html.var'
98.223.148.4 - - [15/Jul/2008:10:11:16 +0800] [124.108.97.193/sid#9bca100][rid#9c3e9a8/initial/redir#1] (4) RewriteCond: input='/error/HTTP_UNAUTHORIZED.html.var' pattern='^/dwr$' => not-matched
98.223.148.4 - - [15/Jul/2008:10:11:16 +0800] [124.108.97.193/sid#9bca100][rid#9c3e9a8/initial/redir#1] (3) applying pattern '^(.+)' to uri '/error/HTTP_UNAUTHORIZED.html.var'
98.223.148.4 - - [15/Jul/2008:10:11:16 +0800] [124.108.97.193/sid#9bca100][rid#9c3e9a8/initial/redir#1] (4) RewriteCond: input='/error/HTTP_UNAUTHORIZED.html.var' pattern='^/js$' => not-matched


從98.223.148.4這個IP,為什麼會一直來try我寫的rewrite rule丫
我在google查了一下,但也找不出為什麼,不知有人有這樣的情形嗎??


下面是我寫的rewrite rule

引用
RewriteEngine On
RewriteLog "/var/log/httpd/rewrite.log"
RewriteLogLevel 5
RewriteCond   %{HTTP_HOST}                 ^[^.]+\.stage\.iu\.com$
RewriteCond   %{REQUEST_URI}               ^/$
RewriteRule   ^(.+)                        %{HTTP_HOST}$1          [C]
RewriteRule   ^([^.]+)\.stage\.iu\.com(.*) /group/$1 [P,L]
RewriteCond   %{REQUEST_URI}           .do$  [OR]
RewriteCond   %{REQUEST_URI}           .jsp$ [OR]
RewriteCond   %{REQUEST_URI}           .jar$ [OR]
RewriteCond   %{REQUEST_URI}           .zip$ [OR]
RewriteCond   %{REQUEST_URI}           .cab$
RewriteRule   /(.*)$                       ajp://10.10.12.1:8009/$1 [P,L]
RewriteCond   %{REQUEST_FILENAME}          b.jpg$
RewriteRule   /(.*)$                       ajp://10.10.12.7:8009/$1 [P,L]
RewriteCond   %{REQUEST_FILENAME}          put.gif$
RewriteRule   /(.*)$                       ajp://10.10.12.1:8009/$1 [P,L]
RewriteCond   %{REQUEST_URI}               ^/m$
RewriteRule   ^(.+)                        ajp://10.10.12.1:8009/$1 [R,L]
RewriteCond   %{REQUEST_URI}               ^/group$
RewriteRule   /(.*)$                       ajp://10.10.12.1:8009/$1 [P,L]
RewriteCond   %{REQUEST_URI}               ^/dwr$
RewriteRule   ^(.+)                        ajp://10.10.12.1:8009/$1 [R,L]
RewriteCond   %{REQUEST_URI}               ^/js$
RewriteRule   ^(.+)                        ajp://10.10.12.1:8009/$1 [R,L]
RewriteCond   %{REQUEST_URI}               ^/js/jsp$
RewriteRule   ^(.+)                        ajp://10.10.12.1:8009/$1 [R,L]
RewriteCond   %{REQUEST_URI}               ^/js/message$
RewriteRule   ^(.+)                        ajp://10.10.12.1:8009/$1 [R,L]

6
Linux 討論版 / [請教] rewrite寫法
« 於: 2008-07-03 18:34 »
Dear All

我的apache version:2.2.9
我想用 mod_proxy + mod_rewrite 來跟 tomcat 做一個連結
下面是我寫的一些rule,但我想請教一下,不知是否有更簡潔的寫法呢??
且不知下面這樣的寫法,會不會造成效能不好呢??

代碼: [選擇]
<VirtualHost "_default_:80">
ServerAlias *.stage.imiyu.com
ErrorDocument 404 /index.html
AddDefaultCharset utf-8
ProxyRequests On
ProxyVia On
RewriteEngine On
RewriteLog "/var/log/httpd/rewrite.log"
RewriteLogLevel 3
RewriteCond   %{HTTP_HOST}                 ^[^.]+\.stage\.imiyu\.com$
RewriteCond   %{REQUEST_URI}                 ^/$
RewriteRule   ^(.+)                        %{HTTP_HOST}$1          [C]
RewriteRule   ^([^.]+)\.stage\.imiyu\.com(.*) /group/$1 [P,L]
RewriteCond   %{SCRIPT_FILENAME} .do$  [OR]
RewriteCond   %{SCRIPT_FILENAME} .jsp$ [OR]
RewriteCond   %{SCRIPT_FILENAME} .jar$ [OR]
RewriteCond   %{SCRIPT_FILENAME} .zip$ [OR]
RewriteCond   %{SCRIPT_FILENAME} .cab$
RewriteRule   /(.*)$    ajp://10.10.12.118:8009/$1 [P,L]
RewriteCond   %{REQUEST_FILENAME} a.jpg$
RewriteRule   /(.*)$    ajp://10.10.12.117:8009/$1 [P,L]
RewriteCond   %{REQUEST_FILENAME} VerifyHumanInput.gif$
RewriteRule   /(.*)$    ajp://10.10.12.118:8009/$1 [P,L]
RewriteCond   %{REQUEST_URI}               ^/braincrush$
RewriteRule   ^(.+)                        /BrainCrush.do?method=PlayGame [R,L]
</Virtualhost>

想跟大家請教一下,不知大家有沒有不同的想法,可以大家一起研究一下呢??
Thanks

Nick

7
PHP程式設計討論區 / php iconv的問題
« 於: 2008-06-27 10:42 »
 ???

我現在遇到一個很奇怪的問題

我寫了一行程式如下:
引用
#!/usr/local/bin/php -q
<?php
$string="Hello!! world";
print iconv("UTF-8","BIG5//TRANSLIT",$string);
?>

我如在 linux下,直接下command: php test.php
竟是出現空白,iconv的功能完全不見了

但如我改用 lynx test.php ,就是用browser來跑的話!!竟就沒有這個問題,是可以執行的
我也有去看過我的phpinfo,但裡面也是有包含iconv這個founction的

我的php version:5.2.5
     linux version:centos 4.6


不知大家有遇到過這樣的怪問題嗎??
用google找了一段時間了,一直沒有找到相同的問題
還請大家指點一下了  Thanks

Nick

8
Linux 討論版 / 請教有關iconv轉換
« 於: 2008-05-28 12:05 »
Dear 大大

下面是一個簡單的php程式
當我把他放在linux下面,執行 php -q test.php時
他竟出現的是 空白,完全沒有顯示出字來,但當我把這幾行程式放到其它的linux上時,去執行,就又可以顯示
看起來像是linux上的問題,但我一直查不出來,不知有沒有大大有遇過的,可以指點一下嗎??

#!/usr/local/bin/php
<?php
$string="Hello!! world";
#fputs(STDOUT,$string);
print iconv("UTF-8","big5//TRANSLIT",$string);
?>


Thanks

9
database 討論版 / 請教oracle exp/imp
« 於: 2008-03-14 16:38 »
想請教各位

如我用 oracle的 exp/imp 來做備份/還原
是否是兩台主機的目錄是要相同的呢??

且如我一台是用file system,另一台是用asm ,是不是這樣也是不行的呢??

我有去找跟 exp/imp 有關的文件,但似乎都沒提到這一點,還想請大家幫忙一下 
Thanks

Nick ???

10
database 討論版 / 請教有關MySQL Cluster的問題
« 於: 2008-01-17 09:52 »
Dear 大大

目前我想把MySQL 從單一台主機改為用MySQL Cluster

代碼: [選擇]
CREATE TABLE `MMS` (
  `mmTxID` varchar(20) NOT NULL default '',
  `TxType` tinyint(2) default '0',
  `UID` int(15) unsigned NOT NULL default '0',
  `CHTID` varchar(30) NOT NULL default '',
  `UIDTO` int(15) unsigned default NULL,
  `CHTIDTO` varchar(30) default NULL,
  `Phone` varchar(12) default NULL,
  `Mesg` text,
  `Item` int(5) NOT NULL default '0',
  `Cmd` varchar(30) default NULL,
  `Cost` varchar(4) NOT NULL default '0',
  `TxID` varchar(30) NOT NULL default '',
  `Redir` char(3) NOT NULL default '',
  `TStamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `STATUS` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`mmTxID`),
  KEY `UID` (`UID`),
  FULLTEXT KEY `Mesg` (`Mesg`)
) ENGINE=NDBCLUSTER DEFAULT CHARSET=utf8;

但這個table裡,有一個FULLTEXT KEY `Mesg` (`Mesg`)
我去查過MySQL的文件,他們說不支援FULLTEXT,那不知可以換成什麼樣的資料型態呢??
在建立的時候,出現的錯誤如下:

引用
ERROR 1214 (HY000) at line 47: The used table type doesn't support FULLTEXT indexes

還請各位大大指點一下,因小弟對SQL不是很熟悉,但老闆又要我做這方面的修改,只好請大大們指點一下了~~ Thanks

11
Network 討論版 / 有關traceroute的問題
« 於: 2008-01-03 16:51 »
想請教各位大大說

我在台固的機房用traceroute 202.144.209.2去查詢到威寶的路由
發現traceroute會停在 6  60-199-6-93.static.tfn.net.tw (60.199.6.93)  1.141 ms !N  0.913 ms !N  0.911 ms !N 就停住了
打電話去報修,台固都說這是因為威寶修改了設定,所以造成他們的路由出錯,問題是出在威寶。
但我總覺的,這樣怪怪的,下面的結果連TFN的網路都沒出去就停了,怎會是威寶修改設定所造成的問題呢??
不知我的認知有沒有錯,還請大大們幫我看一下囉!!謝謝

代碼: [選擇]
traceroute to 202.144.209.2 (202.144.209.2), 30 hops max, 38 byte packets
 1  10.10.11.240 (10.10.11.240)  0.350 ms  0.304 ms  0.279 ms
 2  60-199-254-62.static.tfn.net.tw (60.199.254.62)  1.326 ms  1.009 ms  0.882 ms
 3  211-78-211-5.static.tfn.net.tw (211.78.211.5)  1.100 ms  0.844 ms  0.741 ms
 4  61-31-194-253.static.tfn.net.tw (61.31.194.253)  1.216 ms  0.791 ms  0.688 ms
 5  10.68.34.1 (10.68.34.1)  1.117 ms  0.888 ms  0.732 ms
 6  60-199-6-93.static.tfn.net.tw (60.199.6.93)  1.141 ms !N  0.913 ms !N  0.911 ms !N

12
PHP程式設計討論區 / 請教snmpget的問題
« 於: 2006-03-24 10:07 »
想請教大大們
我想要用 php 的 snmpget 去抓取 SYBASE 的 SNMP 的值
但我試了一下後,發現

php 的 snmpget 似乎只能抓取 NT 的 snmp ,不知大大們
如何去抓取非 NT / 2000 的 MIB 值呢??

13
Network 討論版 / [問題]有關瀾發郵件的問題
« 於: 2004-07-06 21:59 »
小弟最近遇到一個很奇特的問題,想說請教一下各位大大們~

相信大家都知道,瀾發廣告信件會被國外的某些組織給封鎖住IP
那小弟的公司,因有承租虛擬主機的業務,那發現到,現在有一些用戶利用外面的一些專門在瀾放電子
郵件,但連結的內容是連結到我們公司的網站上,那國外的那些組織,也似乎找不出來是那一個IP在瀾
發郵件,就警告我們,到最後,竟把我們的IP給block了,那這個問題現在很困擾著我,因為,我們明明
就沒有瀾放郵件,但國外就偏偏把我們給封鎖住了,我們還得去申訴才行,那不知大大們有遇過這種情形
嗎??因,如是這樣的話!!那我只要用一個浮動IP去發,連結到別人的網站去,不就可以輕易的害到
那個網站了嗎??

不知大大們有何見解呢??這真的是一個很頭痛,也很怪的問題~

14
請教一下大大們,下面這幾行PHP的程式,可以抓出本機Apache送出去標頭~
那小弟想要抓取別台Server,例如:192.168.0.110這台Server的標頭~
那不知該如何去寫了~~還請大大指導一下~~小弟對程式這方面,還在努力的摸索中~~

<?php
   $headers = getallheaders();
   while (list ($header, $value) = each ($headers)) {
              echo "$header: $value<br>\n";
   }
?>

15
http://www.study-area.org/tips/ddns.htm
上面這個網址,小弟己經看過了~~那也實作架設起Server好了~~

但小弟現在有一個小小的問題~~
因上面文章的 DDNS Server是透過 Server 產生的 Key 值來做認證的~~
那小弟之前有申請過一個 DDNS 的服務,他是會寄一封mail給你,告訴你帳號和密碼和網址,那你要用那組帳號和密碼去做提入的動作~~

那小弟有查詢了一下資料,似乎沒有這方面的資料說!!
不知有那位大大可以指點一下的呢??

16
小弟參考了下面的網站來實作了~
http://www.study-area.org/tips/mysql_replication.htm

但目前確有遇到一個問題,還請大大們指點一下~~

小弟目前有兩台Web Server 在上面同時也架起了 MySQL ,也做了雙向的 Replication,兩台同是是 Master/Salve~~

那因在 MySQL的 Table 中,有一個欄位是遞增的,當在同一時間寫入了兩個資料,第一筆的資料寫到第一台的MySQL,第二筆資料確寫到了第二台的 MySQL
那因為欄位是遞增的,所以,兩台的MySQL就在還沒同步的情況下,出現了兩筆相同的遞增號碼,當然,這時同步時,就出現了問題了~~

那不知道大大們有何解決的方法嗎??

17
小弟最近抓了 kernel-v2.6.3的 kernel 回來自行升級~~
那小弟也升級上去了,一切都很正常沒有問題~~

但小弟之前升級的測試是在一般的PC上升級的~~
那現在想要升級一台 Server,是支援雙CPU的~~
那在kernel未升級前,用 uname -r 看了一下
出現: 2.4.20smp

那不知道在 http://kernel.org 上抓的 kernel-v2.6.3 的回來可以升級在這種雙CPU的Server 上嗎??
因小弟試著升級過了,但是失敗了~~升級不成功~~
不知 smp 這樣的 kernl 該如何升級呢??

還請大大們指點一下了,謝謝~~

18
程式討論版 / [問題]XML和 XSL 的程式問題
« 於: 2003-12-31 17:15 »
小弟請教一下各位大大們~~
小弟用 flipalbum 產生了一個 .opf 內置 xml 語法的檔案~~
但是當我傳到web 上後~~
竟無法看到網頁,而一直出現error

無法顯示 XML 網頁
無法使用 XSL 樣式表檢視 XML 輸入。請更正錯誤,然後按 重新整理按鈕,或者稍後再試一次。


--------------------------------------------------------------------------------

參照未被宣告的具名區首碼: 'dc'。處理資源 'http://www.cycc.idv.tw/20031224.opf' 發生錯誤。第 6 行, 位置 20

         <dc:Title>20031224</dc:Title>
-------------------^



想請大大們幫忙看一下了,謝謝~~

<?xml version = "1.0" encoding = "UTF-8"?>



<package unique-identifier = "{AFE8086D-5C90-45B0-873E-EA9DA9005A44}">

   <metadata>

      <dc-metadata>

         <dc:Title>20031224</dc:Title>

         <dc:Subject>20031224</dc:Subject>

         <dc:Description/>

      </dc-metadata>

      <x-metadata>

         <meta name = "EbooksysVersion" content = "1.30"/>

         <meta name = "page_inset" content = "top: 3   bottom: 5   inner: 5   outer: 5  "/>

         <meta name = "centerfold" content = "no"/>

         <meta name = "book_background" content = "texture:20031224_opf_files/Vacation-Travel Book Bkgnd (online).jpg"/>

         <meta name = "page_background" content = "texture:20031224_opf_files/Vacation-Travel Left (online).jpg"/>

         <meta name = "right_page_background" content = "texture:20031224_opf_files/Vacation-Travel Right (online).jpg"/>

         <meta name = "centerfold_page_background" content = "texture:20031224_opf_files/Vacation-Travel Centrefold (online).jpg"/>

         <meta name = "background_music" content = "no"/>

         <meta name = "flipping_sound" content = "yes"/>

         <meta name = "openbook" content = "yes"/>

         <meta name = "window_frame" content = "yes"/>

         <meta name = "file_name" content = "no"/>

         <meta name = "page_number" content = "yes transparent:yes border:no backcolor:16777215 position: bottom alignment:center fontname:[MS Sans Serif] fontsize:8 fontcolor:0 fontstyle:[]"/>

         <meta name = "autoflip" content = "no"/>

         <meta name = "cover_overhang_size" content = "3"/>

         <meta name = "book_binder" content = "numrings: 1 ringtype: Default"/>

         <meta name = "thumbnail_size" content = "large"/>

         <meta name = "resize" content = "yes"/>

         <meta name = "bookmark" content = "type: text autosize: no shape: roundrect 3deffect: yes gradienteffect: yes slope: 15 gap: -8"/>

         <meta name = "marker" content = "type: flowers"/>

      </x-metadata>

   </metadata>

   <manifest>

      <item id = "item0" href = "20031224_opf_files/_fdname.flp" media-type = "application/x-flp"/>

      <item id = "resource0_0_0" href = "20031224_opf_files/Vacation-Travel Front Cover (online).jpg" media-type = "application/x-resource"/>

      <item id = "item1" href = "20031224_opf_files\20031224.tmb" media-type = "application/x-tmb"/>

      <item id = "item2" href = "" media-type = "application/x-toc"/>

      <item id = "item3" href = "20031224_opf_files\DSCN0397.jpg" media-type = "application/x-flp"/>

      <item id = "item4" href = "20031224_opf_files\DSCN0398.jpg" media-type = "application/x-flp"/>

      <item id = "item5" href = "20031224_opf_files\DSCN0399.jpg" media-type = "application/x-flp"/>

      <item id = "item6" href = "20031224_opf_files\DSCN0400.jpg" media-type = "application/x-flp"/>

      <item id = "item7" href = "20031224_opf_files\DSCN0401.jpg" media-type = "application/x-flp"/>

      <item id = "item8" href = "20031224_opf_files\DSCN0402.jpg" media-type = "application/x-flp"/>

      <item id = "item9" href = "20031224_opf_files\DSCN0403.jpg" media-type = "application/x-flp"/>

      <item id = "item10" href = "20031224_opf_files\DSCN0404.jpg" media-type = "application/x-flp"/>

      <item id = "item11" href = "20031224_opf_files\DSCN0405.jpg" media-type = "application/x-flp"/>

      <item id = "item12" href = "20031224_opf_files\DSCN0406.jpg" media-type = "application/x-flp"/>

      <item id = "item13" href = "20031224_opf_files\DSCN0407.jpg" media-type = "application/x-flp"/>

      <item id = "item14" href = "20031224_opf_files\DSCN0408.jpg" media-type = "application/x-flp"/>

      <item id = "item15" href = "20031224_opf_files\DSCN0409.jpg" media-type = "application/x-flp"/>

      <item id = "item16" href = "20031224_opf_files\DSCN0410.jpg" media-type = "application/x-flp"/>

      <item id = "item17" href = "20031224_opf_files\DSCN0411.jpg" media-type = "application/x-flp"/>

      <item id = "item18" href = "20031224_opf_files\DSCN0412.jpg" media-type = "application/x-flp"/>

      <item id = "item19" href = "20031224_opf_files\DSCN0413.jpg" media-type = "application/x-flp"/>

      <item id = "item20" href = "20031224_opf_files\DSCN0414.jpg" media-type = "application/x-flp"/>

      <item id = "item21" href = "20031224_opf_files\DSCN0415.jpg" media-type = "application/x-flp"/>

      <item id = "item22" href = "20031224_opf_files\DSCN0416.jpg" media-type = "application/x-flp"/>

      <item id = "item23" href = "20031224_opf_files\DSCN0417.jpg" media-type = "application/x-flp"/>

      <item id = "item24" href = "20031224_opf_files\DSCN0418.jpg" media-type = "application/x-flp"/>

      <item id = "item25" href = "20031224_opf_files\DSCN0419.jpg" media-type = "application/x-flp"/>

      <item id = "item26" href = "20031224_opf_files\DSCN0420.jpg" media-type = "application/x-flp"/>

      <item id = "item27" href = "20031224_opf_files\DSCN0421.jpg" media-type = "application/x-flp"/>

      <item id = "item28" href = "20031224_opf_files\DSCN0422.jpg" media-type = "application/x-flp"/>

      <item id = "item29" href = "20031224_opf_files\DSCN0423.jpg" media-type = "application/x-flp"/>

      <item id = "item30" href = "20031224_opf_files\DSCN0424.jpg" media-type = "application/x-flp"/>

      <item id = "item31" href = "20031224_opf_files\DSCN0425.jpg" media-type = "application/x-flp"/>

      <item id = "item32" href = "20031224_opf_files\DSCN0426.jpg" media-type = "application/x-flp"/>

      <item id = "item33" href = "20031224_opf_files\DSCN0427.jpg" media-type = "application/x-flp"/>

      <item id = "item34" href = "20031224_opf_files\DSCN0428.jpg" media-type = "application/x-flp"/>

      <item id = "item35" href = "20031224_opf_files\DSCN0429.jpg" media-type = "application/x-flp"/>

      <item id = "item36" href = "20031224_opf_files\DSCN0430.jpg" media-type = "application/x-flp"/>

      <item id = "item37" href = "20031224_opf_files\DSCN0431.jpg" media-type = "application/x-flp"/>

      <item id = "item38" href = "20031224_opf_files\DSCN0432.jpg" media-type = "application/x-flp"/>

      <item id = "item39" href = "20031224_opf_files\DSCN0433.jpg" media-type = "application/x-flp"/>

      <item id = "item40" href = "20031224_opf_files\DSCN0434.jpg" media-type = "application/x-flp"/>

      <item id = "item41" href = "20031224_opf_files\DSCN0435.jpg" media-type = "application/x-flp"/>

      <item id = "item42" href = "20031224_opf_files\DSCN0436.jpg" media-type = "application/x-flp"/>

      <item id = "item43" href = "20031224_opf_files\DSCN0437.jpg" media-type = "application/x-flp"/>

      <item id = "item44" href = "20031224_opf_files\DSCN0438.jpg" media-type = "application/x-flp"/>

      <item id = "item45" href = "20031224_opf_files\DSCN0439.jpg" media-type = "application/x-flp"/>

      <item id = "item46" href = "20031224_opf_files\DSCN0440.jpg" media-type = "application/x-flp"/>

      <item id = "item47" href = "20031224_opf_files\DSCN0441.jpg" media-type = "application/x-flp"/>

      <item id = "item48" href = "20031224_opf_files\DSCN0442.jpg" media-type = "application/x-flp"/>

      <item id = "item49" href = "20031224_opf_files\DSCN0443.jpg" media-type = "application/x-flp"/>

      <item id = "item50" href = "20031224_opf_files\DSCN0444.jpg" media-type = "application/x-flp"/>

      <item id = "item51" href = "20031224_opf_files\DSCN0445.jpg" media-type = "application/x-flp"/>

      <item id = "item52" href = "20031224_opf_files\DSCN0446.jpg" media-type = "application/x-flp"/>

      <item id = "item53" href = "20031224_opf_files\DSCN0447.jpg" media-type = "application/x-flp"/>

      <item id = "item54" href = "20031224_opf_files\DSCN0448.jpg" media-type = "application/x-flp"/>

      <item id = "item55" href = "20031224_opf_files\DSCN0449.jpg" media-type = "application/x-flp"/>

      <item id = "item56" href = "20031224_opf_files\DSCN0450.jpg" media-type = "application/x-flp"/>

      <item id = "item57" href = "20031224_opf_files\DSCN0451.jpg" media-type = "application/x-flp"/>

      <item id = "item58" href = "20031224_opf_files\DSCN0452.jpg" media-type = "application/x-flp"/>

      <item id = "item59" href = "20031224_opf_files\DSCN0453.jpg" media-type = "application/x-flp"/>

      <item id = "item60" href = "20031224_opf_files\DSCN0454.jpg" media-type = "application/x-flp"/>

      <item id = "item61" href = "20031224_opf_files\DSCN0455.jpg" media-type = "application/x-flp"/>

      <item id = "item62" href = "20031224_opf_files\DSCN0456.jpg" media-type = "application/x-flp"/>

      <item id = "item63" href = "20031224_opf_files\DSCN0457.jpg" media-type = "application/x-flp"/>

      <item id = "item64" href = "20031224_opf_files\DSCN0458.jpg" media-type = "application/x-flp"/>

      <item id = "item65" href = "20031224_opf_files\DSCN0459.jpg" media-type = "application/x-flp"/>

      <item id = "item66" href = "20031224_opf_files\DSCN0460.jpg" media-type = "application/x-flp"/>

      <item id = "item67" href = "20031224_opf_files\DSCN0475.jpg" media-type = "application/x-flp"/>

      <item id = "item68" href = "20031224_opf_files\DSCN0476.jpg" media-type = "application/x-flp"/>

      <item id = "item69" href = "20031224_opf_files\DSCN0478.jpg" media-type = "application/x-flp"/>

      <item id = "item70" href = "20031224_opf_files\DSCN0479.jpg" media-type = "application/x-flp"/>

      <item id = "item71" href = "20031224_opf_files\DSCN0480.jpg" media-type = "application/x-flp"/>

      <item id = "item72" href = "20031224_opf_files\DSCN0481.jpg" media-type = "application/x-flp"/>

      <item id = "item73" href = "20031224_opf_files\DSCN0483.jpg" media-type = "application/x-flp"/>

      <item id = "item74" href = "20031224_opf_files\DSCN0484.jpg" media-type = "application/x-flp"/>

      <item id = "item75" href = "20031224_opf_files\DSCN0485.jpg" media-type = "application/x-flp"/>

      <item id = "item76" href = "20031224_opf_files\DSCN0486.jpg" media-type = "application/x-flp"/>

      <item id = "item77" href = "20031224_opf_files\DSCN0487.jpg" media-type = "application/x-flp"/>

      <item id = "item78" href = "20031224_opf_files\DSCN0488.jpg" media-type = "application/x-flp"/>

      <item id = "item79" href = "20031224_opf_files\DSCN0489.jpg" media-type = "application/x-flp"/>

      <item id = "item80" href = "20031224_opf_files\DSCN0490.jpg" media-type = "application/x-flp"/>

      <item id = "item81" href = "20031224_opf_files\DSCN0491.jpg" media-type = "application/x-flp"/>

      <item id = "item82" href = "20031224_opf_files\DSCN0492.jpg" media-type = "application/x-flp"/>

      <item id = "item83" href = "20031224_opf_files\DSCN0493.jpg" media-type = "application/x-flp"/>

      <item id = "item84" href = "20031224_opf_files\DSCN0494.jpg" media-type = "application/x-flp"/>

      <item id = "item85" href = "20031224_opf_files\DSCN0495.jpg" media-type = "application/x-flp"/>

      <item id = "item86" href = "20031224_opf_files\DSCN0496.jpg" media-type = "application/x-flp"/>

      <item id = "item87" href = "20031224_opf_files\DSCN0497.jpg" media-type = "application/x-flp"/>

      <item id = "item88" href = "20031224_opf_files\DSCN0498.jpg" media-type = "application/x-flp"/>

      <item id = "item89" href = "20031224_opf_files\DSCN0499.jpg" media-type = "application/x-flp"/>

      <item id = "item90" href = "20031224_opf_files\DSCN0500.jpg" media-type = "application/x-flp"/>

      <item id = "item91" href = "20031224_opf_files\DSCN0501.jpg" media-type = "application/x-flp"/>

      <item id = "item92" href = "20031224_opf_files\DSCN0502.jpg" media-type = "application/x-flp"/>

      <item id = "item93" href = "20031224_opf_files\DSCN0503.jpg" media-type = "application/x-flp"/>

      <item id = "item94" href = "20031224_opf_files\DSCN0504.jpg" media-type = "application/x-flp"/>

      <item id = "item95" href = "20031224_opf_files\DSCN0505.jpg" media-type = "application/x-flp"/>

      <item id = "item96" href = "20031224_opf_files\DSCN0506.jpg" media-type = "application/x-flp"/>

      <item id = "item97" href = "20031224_opf_files\DSCN0507.jpg" media-type = "application/x-flp"/>

      <item id = "item98" href = "20031224_opf_files\DSCN0508.jpg" media-type = "application/x-flp"/>

      <item id = "item99" href = "20031224_opf_files\DSCN0509.jpg" media-type = "application/x-flp"/>

      <item id = "item100" href = "20031224_opf_files\DSCN0510.jpg" media-type = "application/x-flp"/>

      <item id = "item101" href = "20031224_opf_files\DSCN0511.jpg" media-type = "application/x-flp"/>

      <item id = "item102" href = "20031224_opf_files\DSCN0512.jpg" media-type = "application/x-flp"/>

      <item id = "item103" href = "20031224_opf_files\DSCN0513.jpg" media-type = "application/x-flp"/>

      <item id = "item104" href = "20031224_opf_files\DSCN0514.jpg" media-type = "application/x-flp"/>

      <item id = "item105" href = "20031224_opf_files\DSCN0515.jpg" media-type = "application/x-flp"/>

      <item id = "item106" href = "20031224_opf_files\DSCN0516.jpg" media-type = "application/x-flp"/>

      <item id = "item107" href = "20031224_opf_files\DSCN0517.jpg" media-type = "application/x-flp"/>

      <item id = "item108" href = "20031224_opf_files\DSCN0519.jpg" media-type = "application/x-flp"/>

      <item id = "item109" href = "20031224_opf_files\DSCN0520.jpg" media-type = "application/x-flp"/>

      <item id = "item110" href = "20031224_opf_files\DSCN0521.jpg" media-type = "application/x-flp"/>

      <item id = "item111" href = "20031224_opf_files\DSCN0522.jpg" media-type = "application/x-flp"/>

      <item id = "item112" href = "20031224_opf_files\DSCN0523.jpg" media-type = "application/x-flp"/>

      <item id = "item113" href = "20031224_opf_files\DSCN0524.jpg" media-type = "application/x-flp"/>

      <item id = "item114" href = "20031224_opf_files\DSCN0525.jpg" media-type = "application/x-flp"/>

      <item id = "item115" href = "20031224_opf_files\DSCN0526.jpg" media-type = "application/x-flp"/>

      <item id = "item116" href = "20031224_opf_files\DSCN0527.jpg" media-type = "application/x-flp"/>

      <item id = "item117" href = "20031224_opf_files\DSCN0528.jpg" media-type = "application/x-flp"/>

      <item id = "item118" href = "20031224_opf_files\DSCN0529.jpg" media-type = "application/x-flp"/>

      <item id = "item119" href = "20031224_opf_files\DSCN0530.jpg" media-type = "application/x-flp"/>

      <item id = "item120" href = "20031224_opf_files\DSCN0531.jpg" media-type = "application/x-flp"/>

      <item id = "item121" href = "20031224_opf_files\DSCN0533.jpg" media-type = "application/x-flp"/>

      <item id = "item122" href = "20031224_opf_files\DSCN0534.jpg" media-type = "application/x-flp"/>

      <item id = "item123" href = "20031224_opf_files\DSCN0535.jpg" media-type = "application/x-flp"/>

      <item id = "item124" href = "20031224_opf_files\DSCN0536.jpg" media-type = "application/x-flp"/>

      <item id = "item125" href = "20031224_opf_files\DSCN0537.jpg" media-type = "application/x-flp"/>

      <item id = "item126" href = "20031224_opf_files\DSCN0538.jpg" media-type = "application/x-flp"/>

      <item id = "item127" href = "20031224_opf_files\DSCN0539.jpg" media-type = "application/x-flp"/>

      <item id = "item128" href = "20031224_opf_files\DSCN0540.jpg" media-type = "application/x-flp"/>

      <item id = "item129" href = "20031224_opf_files\DSCN0541.jpg" media-type = "application/x-flp"/>

      <item id = "item130" href = "20031224_opf_files\DSCN0542.jpg" media-type = "application/x-flp"/>

      <item id = "item131" href = "20031224_opf_files\DSCN0543.jpg" media-type = "application/x-flp"/>

      <item id = "item132" href = "20031224_opf_files\DSCN0544.jpg" media-type = "application/x-flp"/>

      <item id = "item133" href = "20031224_opf_files\DSCN0546.jpg" media-type = "application/x-flp"/>

      <item id = "item134" href = "20031224_opf_files\DSCN0547.jpg" media-type = "application/x-flp"/>

      <item id = "item135" href = "20031224_opf_files\DSCN0548.jpg" media-type = "application/x-flp"/>

      <item id = "item136" href = "20031224_opf_files\DSCN0549.jpg" media-type = "application/x-flp"/>

      <item id = "item137" href = "20031224_opf_files\DSCN0550.jpg" media-type = "application/x-flp"/>

      <item id = "item138" href = "20031224_opf_files\DSCN0551.jpg" media-type = "application/x-flp"/>

      <item id = "item139" href = "20031224_opf_files\DSCN0552.jpg" media-type = "application/x-flp"/>

      <item id = "item140" href = "20031224_opf_files\DSCN0553.jpg" media-type = "application/x-flp"/>

      <item id = "item141" href = "20031224_opf_files\DSCN0554.jpg" media-type = "application/x-flp"/>

      <item id = "item142" href = "20031224_opf_files\DSCN0555.jpg" media-type = "application/x-flp"/>

      <item id = "item143" href = "20031224_opf_files\DSCN0556.jpg" media-type = "application/x-flp"/>

      <item id = "item144" href = "20031224_opf_files\DSCN0557.jpg" media-type = "application/x-flp"/>

      <item id = "item145" href = "" media-type = "application/x-idx"/>

      <item id = "item146" href = "" media-type = "application/x-flp"/>

      <item id = "resource146_0_0" href = "20031224_opf_files/Vacation-Travel Back Cover (online).jpg" media-type = "application/x-resource"/>

   </manifest>

   <spine>

      <itemref page_background = "texture:resource0_0_0" pageside = "right" index = "no" idref = "item0"/>

      <itemref index = "no" centerfold = "no" idref = "item1"/>

      <itemref index = "no" centerfold = "no" idref = "item2"/>

      <itemref idref = "item3" bookmark = "text:普陀寺 bgcolor:8454016"/>

      <itemref idref = "item4"/>

      <itemref idref = "item5"/>

      <itemref idref = "item6"/>

      <itemref idref = "item7"/>

      <itemref idref = "item8"/>

      <itemref idref = "item9"/>

      <itemref idref = "item10"/>

      <itemref idref = "item11" bookmark = "text:神山- 禪圓 bgcolor:16711680"/>

      <itemref idref = "item12"/>

      <itemref idref = "item13"/>

      <itemref idref = "item14"/>

      <itemref idref = "item15"/>

      <itemref idref = "item16"/>

      <itemref idref = "item17" bookmark = "text:神山 -  樹頂吊橋 bgcolor:255"/>

      <itemref idref = "item18"/>

      <itemref idref = "item19"/>

      <itemref idref = "item20"/>

      <itemref idref = "item21"/>

      <itemref idref = "item22"/>

      <itemref idref = "item23"/>

      <itemref idref = "item24"/>

      <itemref idref = "item25"/>

      <itemref idref = "item26"/>

      <itemref idref = "item27"/>

      <itemref idref = "item28"/>

      <itemref idref = "item29"/>

      <itemref idref = "item30"/>

      <itemref idref = "item31"/>

      <itemref idref = "item32"/>

      <itemref idref = "item33"/>

      <itemref idref = "item34"/>

      <itemref idref = "item35"/>

      <itemref idref = "item36" bookmark = "text:神山 - 植物圓 bgcolor:16711935"/>

      <itemref idref = "item37"/>

      <itemref idref = "item38"/>

      <itemref idref = "item39"/>

      <itemref idref = "item40"/>

      <itemref idref = "item41"/>

      <itemref idref = "item42"/>

      <itemref idref = "item43"/>

      <itemref idref = "item44"/>

      <itemref idref = "item45" bookmark = "text:沙巴基金大廈 bgcolor:4227072"/>

      <itemref idref = "item46"/>

      <itemref idref = "item47"/>

      <itemref idref = "item48"/>

      <itemref idref = "item49"/>

      <itemref idref = "item50"/>

      <itemref idref = "item51"/>

      <itemref idref = "item52"/>

      <itemref idref = "item53"/>

      <itemref idref = "item54"/>

      <itemref idref = "item55"/>

      <itemref idref = "item56" bookmark = "text:清真寺 bgcolor:16744576"/>

      <itemref idref = "item57"/>

      <itemref idref = "item58"/>

      <itemref idref = "item59"/>

      <itemref idref = "item60"/>

      <itemref idref = "item61"/>

      <itemref idref = "item62" bookmark = "text:泛太泙飯店 bgcolor:33023"/>

      <itemref idref = "item63"/>

      <itemref idref = "item64"/>

      <itemref idref = "item65"/>

      <itemref idref = "item66"/>

      <itemref idref = "item67"/>

      <itemref idref = "item68"/>

      <itemref idref = "item69"/>

      <itemref idref = "item70"/>

      <itemref idref = "item71"/>

      <itemref idref = "item72"/>

      <itemref idref = "item73"/>

      <itemref idref = "item74"/>

      <itemref idref = "item75"/>

      <itemref idref = "item76"/>

      <itemref idref = "item77"/>

      <itemref idref = "item78"/>

      <itemref idref = "item79"/>

      <itemref idref = "item80"/>

      <itemref idref = "item81"/>

      <itemref idref = "item82"/>

      <itemref idref = "item83"/>

      <itemref idref = "item84"/>

      <itemref idref = "item85"/>

      <itemref idref = "item86"/>

      <itemref idref = "item87"/>

      <itemref idref = "item88"/>

      <itemref idref = "item89"/>

      <itemref idref = "item90"/>

      <itemref idref = "item91"/>

      <itemref idref = "item92"/>

      <itemref idref = "item93"/>

      <itemref idref = "item94"/>

      <itemref idref = "item95"/>

      <itemref idref = "item96"/>

      <itemref idref = "item97"/>

      <itemref idref = "item98"/>

      <itemref idref = "item99"/>

      <itemref idref = "item100"/>

      <itemref idref = "item101"/>

      <itemref idref = "item102"/>

      <itemref idref = "item103"/>

      <itemref idref = "item104"/>

      <itemref idref = "item105"/>

      <itemref idref = "item106"/>

      <itemref idref = "item107"/>

      <itemref idref = "item108"/>

      <itemref idref = "item109"/>

      <itemref idref = "item110"/>

      <itemref idref = "item111"/>

      <itemref idref = "item112"/>

      <itemref idref = "item113"/>

      <itemref idref = "item114"/>

      <itemref idref = "item115"/>

      <itemref idref = "item116"/>

      <itemref idref = "item117"/>

      <itemref idref = "item118"/>

      <itemref idref = "item119"/>

      <itemref idref = "item120"/>

      <itemref idref = "item121"/>

      <itemref idref = "item122"/>

      <itemref idref = "item123"/>

      <itemref idref = "item124"/>

      <itemref idref = "item125"/>

      <itemref idref = "item126"/>

      <itemref idref = "item127"/>

      <itemref idref = "item128"/>

      <itemref idref = "item129"/>

      <itemref idref = "item130"/>

      <itemref idref = "item131"/>

      <itemref idref = "item132"/>

      <itemref idref = "item133"/>

      <itemref idref = "item134"/>

      <itemref idref = "item135"/>

      <itemref idref = "item136"/>

      <itemref idref = "item137"/>

      <itemref idref = "item138"/>

      <itemref idref = "item139"/>

      <itemref idref = "item140"/>

      <itemref idref = "item141"/>

      <itemref idref = "item142"/>

      <itemref idref = "item143"/>

      <itemref idref = "item144"/>

      <itemref index = "no" centerfold = "no" idref = "item145"/>

      <itemref page_background = "texture:resource146_0_0" pageside = "left" index = "no" idref = "item146"/>

   </spine>

</package>

19
Linux 討論版 / [問題]mysql的一個問題~~
« 於: 2003-09-11 10:59 »
小弟目前在 mysql 上有一點小小的問題,還請大大們指點一下了~~

目前,小弟有兩台 WEB SERVER 做 load balance,這兩台 WEB SERVER 上都安裝了 mysql~~
而,小弟是用 nfs mount 了一個 staroge 的空間在 Linux 上~~
將,WEB 的資料和 mysql 的 database,放在 nfs mount 起來的 staroge 內~
同時將兩台mysql 的 mysql.server 內的 datadir 改路徑去讀取同一個 DB
那~~對 兩台 server 上的 mysql 而言,就都是 localhost 了~~
那小弟也寫了一個 web 的程式~~去讀取 mysql的資料~~
在 mysql 的 connect 上,就都設定為 localhost ~~該沒錯吧!!因你從第一台 WEB SERVER 進來讀取資料,對他而言就是 localhost ;從第二台 WEB SERVER 進來讀取資料~對他而言也是 localhost ~~
但是~~這樣的話!!我在測試線上交易的時候~~
卻容易出現說~~DATABASE 損毀了~~
不知道有沒有大大這樣做過呢??
因小弟現正為這個問題苦惱呢??

20
小弟想請教一下大大們~~
小弟目前有兩台web server~~來做balance,而web的資料存在後端的server上~~但是目前mysql的資料卻還是在其中一台server上,那小弟我也想將mysql的db 改放到後端的server 上,那不知在mysql中何處可以修改db存放的路徑呢??

那這兩台server 是否都要安裝mysql,在將db 指向到後端呢??如此是否就可以同時讀取一個db呢??還請大大指點一下小弟了呢??感激不盡~~

21
請教一下大大~~

如何在兩方都是透過 NAT 的情況下,使用 Netmeeting??
像我們公司現在內部的都是透過 Linux 做 NAT 來上網的~~
而另一方,不管是客戶還是分公司的同仁也好~~
也都是透過 NAT 來上網的~~有可能是用 IP 分配器或 Linux 或 NT ~~
那目前我們是架了一台 ILS Server 來使用~~
但是仍會發現~~似乎仍是無法 Cell 到在公司內網的同仁~~
不知到是否有解決的方案呢??
因為想讓每個同仁,都可以透過 Netmeeting 來和客戶或者是分公司的同仁來討論事情~~
還請大大們指點一下了~~謝謝~~

22
小弟我,在網路上找了許久,才將這個部份實作出來的~~現在就 post 我安裝的步驟給各位大大分享一下~~

但是小弟我還是有個問題~~就是 Cyrus-SASL 的 SMTP  認證~~
我還是無法成功的使用~~
如有那位大大成功的安裝在一起的話!!還請告訴我喔!!謝謝~~


Postfix+Courier-IMAP+MySQL+Cyrus-SASL 安裝步驟

1.安裝MySQL

請到 http://www.mysql.com/downloads/download.php?file=Downloads%2FMySQL-3.23%2Fmysql-3.23.56.tar.gz&mirror=http%3A%2F%2Fgd.tuwien.ac.at%2Fdb%2Fmysql%2F 下載 MySQL

[root@dns local]# tar zxvf mysql-3.23.56.tar.gz
[root@dns local]# cd mysql-3.23.56
[root@dns mysql-3.23.56]# ./configure --prefix=/usr/local/mysql --with-charset=big5
[root@dns mysql-3.23.56]# make
[root@dns mysql-3.23.56]# make install
[root@dns mysql-3.23.56]# ./script/mysql_install_db
[root@dns mysql-3.23.56]# /usr/local/mysql/share/mysql/mysql.server start
[root@dns mysql-3.23.56]# /usr/local/mysql/bin/mysqladmin -uroot password xxxxxx


到此,MySQL安裝完畢囉!!

2.MySQL SETUP

2-1.Create the database

USE mysql;
INSERT INTO user (Host, User, Password) VALUES ('localhost','postfix',password('postfix'));
INSERT INTO db (Host, Db, User, Select_priv) VALUES ('localhost','postfix','postfix','Y');
CREATE DATABASE postfix;

2-2.Create the Alias Table

USE postfix;
CREATE TABLE alias (
  address varchar(255) NOT NULL default '',
  goto text NOT NULL,
  domain varchar(255) NOT NULL default '',
  create_date datetime NOT NULL default '0000-00-00 00:00:00',
  change_date datetime NOT NULL default '0000-00-00 00:00:00',
  active tinyint(4) NOT NULL default '1',
  PRIMARY KEY (address)
) TYPE=MyISAM COMMENT='Virtual Aliases - mysql_virtual_alias_maps';

2-3.Create the Domain Table

USE postfix;
CREATE TABLE domain (
  domain varchar(255) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  create_date datetime NOT NULL default '0000-00-00 00:00:00',
  change_date datetime NOT NULL default '0000-00-00 00:00:00',
  active tinyint(4) NOT NULL default '1',
  PRIMARY KEY (domain)
) TYPE=MyISAM COMMENT='Virtual Domains - mysql_virtual_domains_maps';

2-4.Create the Mailbox Table

USE postfix;
CREATE TABLE mailbox (
  username varchar(255) NOT NULL default '',
  password varchar(255) NOT NULL default '',
  name varchar(255) NOT NULL default '',
  maildir varchar(255) NOT NULL default '',
  domain varchar(255) NOT NULL default '',
  create_date datetime NOT NULL default '0000-00-00 00:00:00',
  change_date datetime NOT NULL default '0000-00-00 00:00:00',
  active tinyint(4) NOT NULL default '1',
  PRIMARY KEY (username)
) TYPE=MyISAM COMMENT='Virtual Mailboxes - mysql_virtual_mailbox_maps';


3.安裝SASL

請到 ftp://ftp.andrew.cmu.edu/pub/cyrus-mail/cyrus-sasl-2.1.13.tar.gz 下載
[root@dns local]# tar zxvf cyrus-sasl-2.1.13.tar.gz
[root@dns local]# cd cyrus-sasl-2.1.13
[root@dns cyrus-sasl-2.1.13]# ./configure --with-mysql=/usr/local/mysql/
[root@dns cyrus-sasl-2.1.13]# make
[root@dns cyrus-sasl-2.1.13]# make install
[root@dns cyrus-sasl-2.1.13]# ln -s /usr/local/lib/sasl2 /usr/lib/sasl2


4.安裝Postfix

請到 ftp://postfix.cdpa.nsysu.edu.tw/postfix/postfix-release/official/postfix-2.0.9.tar.gz 下載
請先編緝 /etc/ld.so.conf 加入
/usr/local/mysql/lib/mysql
/usr/local/lib
[root@dns local]# ldconfig
[root@dns local]# tar zxvf postfix-2.0.9.tar.gz
[root@dns local]# cd postfix-2.0.9
[root@dns postfix-2.0.9]# make makefiles 'CCARGS=-DHAS_MYSQL -I/usr/local/mysql/include/mysql -DUSE_SASL_AUTH -I/usr/local/include/sasl' 'AUXLIBS=-L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lm -L/usr/local/lib -lsasl2'
[root@dns postfix-2.0.9]# make
[root@dns postfix-2.0.9]# make install
[root@dns postfix-2.0.9]# mkdir /usr/local/virtual
[root@dns postfix-2.0.9]# chown -R 1001:1001 /usr/local/virtual
[root@dns postfix-2.0.9]# chmod -R 751 /usr/local/virtual


5.設定Postfix

main.cf
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:1001
virtual_mailbox_base = /usr/local/virtual
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_mailbox_limit = 51200000
virtual_transport = virtual
virtual_uid_maps = static:1001

5-1.mysql_virtual_alias_maps.cf

user = postfix
password = postfix
hosts = localhost
dbname = postfix
table = alias
select_field = goto
where_field = address

5-2.mysql_virtual_domains_maps.cf

user = postfix
password = postfix
hosts = localhost
dbname = postfix
table = domain
select_field = description
where_field = domain

5-3.mysql_virtual_mailbox_maps.cf

user = postfix
password = postfix
hosts = localhost
dbname = postfix
table = mailbox
select_field = maildir
where_field = username


6.安裝 Courier-IMAP

請到 http://umn.dl.sourceforge.net/sourceforge/courier/courier-imap-1.7.2.tar.bz2 下載
[root@dns local]# bunzip2 courier-imap-1.7.2.tar.bz2
[root@dns local]# tar xvf courier-imap-1.7.2.tar
[root@dns local]# cd courier-imap-1.7.2
[root@dns courier-imap-1.7.2]# ./configure --disable-root-check --without-authuserdb --without-authpam --without-authldap --without-authpwd --without-authshadow --without-authvchkpw --without-authpgsql --without-authcram --without-authcustom --without-authdaemon --with-mysql-libs=/usr/local/mysql/lib/mysql/ --with-mysql-includes=/usr/local/mysql/include/mysql/ --with-authmysql
[root@dns courier-imap-1.7.2]# make
[root@dns courier-imap-1.7.2]# make install


7.編緝 Courier-IMAP

7-1.authmysqlrc

DEFAULT_DOMAIN          domain.tld
MYSQL_CRYPT_PWFIELD     password
MYSQL_DATABASE          postfix
MYSQL_GID_FIELD         1001
MYSQL_HOME_FIELD        '/usr/local/virtual'
MYSQL_LOGIN_FIELD       username
MYSQL_MAILDIR_FIELD     maildir
MYSQL_NAME_FIELD        name
MYSQL_OPT               0
MYSQL_PASSWORD          postfix
# MYSQL_PORT            0
# MYSQL_QUOTA_FIELD     quota
MYSQL_SERVER            localhost
# MYSQL_SOCKET          /var/mysql/mysql.sock
MYSQL_UID_FIELD         1001
MYSQL_USERNAME          postfix
MYSQL_USER_TABLE        mailbox
# MYSQL_WHERE_CLAUSE    server='mailhost.example.com'


8.安裝 Postfix Admin

請到 http://www.high5.net/howto/postfixadmin-1.5.0-5.tgz 下載
[root@dns htdocs]# tar zxvf postfixadmin-1.5.0-5.tgz

8-1.Postfix Admin Install

[root@dns local]# /usr/local/mysql/bin/mysql -uroot -pxxxxxx
mysql> USE mysql
mysql> INSERT INTO user (Host, User, Password) VALUES ('localhost','postfixadmin',password('postfixadmin'));
mysql> INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv) VALUES ('localhost', 'postfix', 'postfixadmin', 'Y', 'Y', 'Y', 'Y');

8-2.Postfix Admin Setup

[root@dns local]# /usr/local/mysql/bin/mysql -uroot -pxxxxxx
mysql> USE postfix;
mysql> CREATE TABLE admin (
mysql> username varchar(255) NOT NULL default '',
mysql> password varchar(255) NOT NULL default '',
mysql> domain varchar(255) NOT NULL default '',
mysql> create_date datetime NOT NULL default '0000-00-00 00:00:00',
mysql> change_date datetime NOT NULL default '0000-00-00 00:00:00',
mysql> active tinyint(4) NOT NULL default '1',
mysql> PRIMARY KEY (username)
mysql> ) TYPE=MyISAM COMMENT='Virtual Admins - Store Virtual Domain Admins';

23
想請問一下大大們~~
有哪些是支援 maildir 格式的 webmail,且也有支援 IMAP 的呢??
我有裝 小松鼠 但是這套有點醜醜的~~

24
想請問一下大大們說!!
小弟我,安裝Postfix+MYSQL+COURIER-IMAP(virtual domain),都OK了~~
目前正在整理資料中~~

但是小弟我有一個小問題,就是 SMTP 的認證的問題~~
小弟我想用 Cyrus-SASL 來做 SMTP 的認證~~
但是他的認證方式,有用 pam 和 pwcheck 這兩種方法~~都是到 /etc/shadow 去做使用者的認證的~~
但是我安裝Postfix+MYSQL+COURIER-IMAP,這是透過 MYSQL 內去做使用者的認證的~~
不知道,是否有大大可提供一下,認證的方式呢??
要不然,不知該如何開 relay 給使用者用的呢??

25
請教一下大大們~~
不知該如何將 postfix 的 queue 刪除呢??
我不想一啟動後,就又一直在寄信了~~

26
想請教一下各位大大們說!!
我參考了下面的這個網址去實作了 Virtual Domain 的 E-mail
http://high5.net/howto/#postfix_setup_mailbox

但是呢??我的帳號和密碼,卻一直無法進入到 DB 內去 Check ~~
這真的是很讓我頭痛說!!

首先、我先安裝 MySQL
第二、我安裝 Postfix-2.1.13的版本
make makefiles 'CCARGS=-DHAS_MYSQL -I/usr/local/mysql/include/mysql -DUSE_SASL_AUTH -I/usr/local/include/sasl -I/usr/local/bdb/include' 'AUXLIBS=-L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lm -L/usr/local/lib -lsasl2 -L/usr/local/bdb/lib'

這是我在安裝 Postfix 時,下的參數,以求支援 MySQL

第三、我就安裝 Courier-IMAP ~~

./configure --disable-root-check --without-authuserdb --without-authpam --without-authldap --without-authpwd --without-authshadow --without-authvchkpw --without-authpgsql --without-authcram --without-authcustom --without-authdaemon --with-mysql-libs=/usr/local/mysql/lib/mysql/ --with-mysql-includes=/usr/local/mysql/include/mysql/ --with-authmysql

我就如此安裝好了~~
但是,當我打 telnet  localhost 110
user nick@so-buy.com.tw
pass angela

卻一直出現 Login FAILED~~
似乎是沒有到 MySQL 內去 Check 密碼和帳號說!!
不知到底是那出現了問題了呢??
還請大大們指點一下了~~
那 FreeBSD 那的文章,我也看過了,但還是解決不了說!!
只好請大大們幫個忙了~~

[/url]

27
Linux 討論版 / maillog~~的訊息問題~~
« 於: 2003-01-26 21:40 »
請問一下大大們~~

maillog 內出現了queued mail for delivery 這個訊息是代表什麼意思呢??
信好像沒有寄出去耶!!
但是其它的 mail address 卻都可以收到!。只有少數幾個這樣子說!!
這是什麼問題呢??還請各位大大幫幫忙替小弟解答一下囉!!

28
Linux 討論版 / 一些 postfix 的問題請教
« 於: 2002-12-01 10:30 »
想請問一下大大,兩個有關 postfix 的設定問題?

第一、不知道有沒有人設定過,在postfix內,設定為“寄件失敗,並不通知寄件人”的功能呢??

第二、如我用“密件寄送”去寄送 100 幫mail 的話!!我查看過 log 檔了,發現他並不會寫入 maillog 中,除了最後一封 mail 有寫入 log 裡,但是其它的都完全沒有寫入,那不知道,有人有遇過這個問題嗎??這有會是那一個設定沒有設定好呢??

還請各位大大,幫忙查一下了~~

29
ㄟ各位大大~~
麻煩看一下了,這太困擾我了~~

我的安裝步驟如下:

使用pkg_add -v 指令安裝 jpeg,png,freetype,xpm,gd 等Package

安裝完後執行 cp /usr/local/lib/libgd.a /usr/local/include/gd

cd apache_1.3.26

./configure --prefix=/usr/local/apache_1.3.26

cd ../php-4.1.2

./configure --disable-debug --with-mysql=/usr/local/mysql --with-apache=/usr/local/apache_1.3.26 --with-gd=/usr/local/include/gd --with-zlib=/usr/local --enable-track-vars

make

就出現了下面的訊息了~~

In file included from gd.c:83:
gd_ctx.c: In function `_php_image_output_ctx':
gd_ctx.c:70: structure has no member named `free'
gd_ctx.c:98: structure has no member named `free'
gd.c: In function `_php_image_create_from':
gd.c:1176: structure has no member named `free'
*** Error code 1

Stop in /usr/local/php-4.1.2/ext/gd.
*** Error code 1

Stop in /usr/local/php-4.1.2/ext/gd.
*** Error code 1

Stop in /usr/local/php-4.1.2/ext.
*** Error code 1

Stop in /usr/local/php-4.1.2.
test#


還請各位大大幫看一下了~~

30
想請問一下各位大大說!!
我現在用下ghost -IAL 的參數可以將整個linux的系統完整的復製到另一個HD上
且開機也沒有另何的問題~~

但是,我該如何去製作一個屬於自己的recovery CD呢??
因為這是公司要用的~~
但是我只知道如何ghost,卻不知道該如何去將ghost的畫面修改為公司的recovery CD的樣子呢??

還請有做過的大大幫個忙,指點小弟我一下~~
謝謝~~

頁: [1] 2