Slow network in MDK10:
adding the following line to /etc/modprobe.conf:
alias net-pf-10 off (and a reboot after that)
The reason of this tweak is due to the fact that the 2.6 kernel is using IPV6 (and I was/am using IPV4)
Reference:http://www.usenetlinux.com/archive/index.php/t-97081.html

Mash 發表在 痞客邦 留言(0) 人氣()


昨天用VMware 4.5.2 安裝了 Mandrake 10.0卻遇上了幾個問題...首先,鍵盤右邊的幾個字母無法正常運作,(UJM右邊的的字母變成數字123...),這是因為我使用筆記型電腦X31的緣故,解決方法如下:系統-->設定-->KDE-->周邊設定-->鍵盤,NumLock on KDE Startup設為關閉即可。

第二個問題是無論在VMware上將網路卡設為NAT或是Bridged都無法連上Internet,Google很久才發現了解決的辦法:

Mash 發表在 痞客邦 留言(0) 人氣()

今天在 MS SQL Server 2000 Enterprise Manager 的 SQL 窗格中調試如下 SQL 語句:
SELECT TOP 10 *
FROM (SELECT TOP 20 *
FROM news
WHERE class = 001
ORDER BY pubdate DESC)
ORDER BY pubdate

Mash 發表在 痞客邦 留言(0) 人氣()

1.選取度量工具(在吸管工具裡)2.在希望變成水平或垂直的景物上拉一條基準線3.影像->旋轉版面->任意4.對話框內會自動顯示需要調整的角度,直接按下確定5.適當裁減照片,完成

Mash 發表在 痞客邦 留言(0) 人氣()

SELECT COUNT(*)
FROM (SELECT DISTINCT sourceIP, destIP FROM Alerts WHERE Alerts.name='W32_sasser_worm_a' OR Alerts.name='ServiceName' OR Alerts.name='Port_Num' OR Alerts.name='sasser_transfer_upexe');


SELECT MIN(Count) FROM (
SELECT COUNT(*) as Count FROM Alerts WHERE sourceIP='218.104.83.171' AND destIP='140.115.82.108' AND name='W32_sasser_worm_a'
UNION ALL SELECT COUNT(*) as Count FROM Alerts WHERE sourceIP='218.104.83.171' AND destIP='140.115.82.108' AND name='ServiceName'
UNION ALL SELECT COUNT(*) as Count FROM Alerts WHERE sourceIP='218.104.83.171' AND destIP='140.115.82.108' AND name='Port_Num'
UNION ALL SELECT COUNT(*) as Count FROM Alerts WHERE sourceIP='218.104.83.171' AND destIP='140.115.82.108' AND name='sasser_transfer_upexe'
);

Mash 發表在 痞客邦 留言(0) 人氣()

在RDBMS下,下列SQL語法相當好用:
SELECT COUNT(DISTINCT colName) FROM tableName;但是在Access卻不支援這樣的語法,如果遇到這樣的情形,可將語法改為:
select count(*) as [ipcount] from (select distinct ip from );

Mash 發表在 痞客邦 留言(0) 人氣()

1
Blog Stats
⚠️

成人內容提醒

本部落格內容僅限年滿十八歲者瀏覽。
若您未滿十八歲,請立即離開。

已滿十八歲者,亦請勿將內容提供給未成年人士。