{"id":1440,"date":"2012-09-07T16:49:34","date_gmt":"2012-09-07T08:49:34","guid":{"rendered":"http:\/\/blog.nuface.tw\/?p=1440"},"modified":"2012-09-12T19:46:54","modified_gmt":"2012-09-12T11:46:54","slug":"%e4%bd%a0%e4%b9%9f%e9%80%99%e6%a8%a3%e6%83%b3%e5%97%8e%ef%bc%9f","status":"publish","type":"post","link":"https:\/\/blog.nuface.tw\/?p=1440","title":{"rendered":"\u4f60\u4e5f\u9019\u6a23\u60f3\u55ce\uff1f"},"content":{"rendered":"<p>\u6700\u8fd1\u516c\u53f8\u5167\u5728\u6d41\u50b3Excel \u75c5\u6bd2\u4fe1\uff0c\u641e\u5230\u96c6\u5718\u5167\u70fd\u7159\u56db\u8d77\uff0c\u5230\u8655\u90fd\u6709\u707d\u60c5\u3002\u6211\u8a18\u5f97\u6211\u7684Mail Server \u6709\u88dd\u9632\u6bd2\u8edf\u9ad4\u5440\uff0c\u70ba\u4ec0\u9ebc\u6c92\u628a\u75c5\u6bd2\u64cb\u4e0b\u4f86\u5462\uff1f\u539f\u4f86ClamAV \u6aa2\u6e2c\u4e0d\u51faExcel \u9019\u500b\u5de8\u96c6\u75c5\u6bd2\uff0e\uff0e\uff0e<br \/>\n<!--more--><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.nuface.tw\/wp-content\/uploads\/2012\/09\/f-prot-1.jpg\" alt=\"\u628a\u75c5\u6bd2\u9913\u6b7b\" \/><br \/>\n\u5f15\u7528\u81f3\u3000<a href=\"http:\/\/www.facebook.com\/WorkBlows\">\u5de5\u4f5c\u9ce5\u60c5\u7dd2 \u7684Facebook<\/a><\/p>\n<p>\u67e5\u4e86\u4e00\u4e0b\u8cc7\u6599\uff0c\u767c\u73fe\u539f\u4f86\u9019\u75c5\u6bd2\uff0c\u5df1\u7d93\u975e\u5e38\u4e45\u4e86\uff0c\u5728\u5927\u9678\u53eb\u505a &#8220;\u5b8f&#8221; \u75c5\u6bd2\uff0c\u6211\u5011\u9019\u53eb\u5de8\u96c6\u75c5\u6bd2\u3002<\/p>\n<p>\u4e3b\u8981\u7684\u50b3\u67d3\u65b9\u5f0f\uff0c\u662f\u4e2d\u6bd2\u7684 Excel \u6587\u4ef6\uff0c\u5728\u81ea\u52d5\u57f7\u884c\u76ee\u9304XLSTART\uff0c\u5148\u628a\u81ea\u5df1\u5beb\u9032\u53bb\uff0c\u7136\u5f8c\u518d\u611f\u67d3\u5176\u5b83\u672a\u4e2d\u6bd2\u7684Excel \u6587\u4ef6\u3002<\/p>\n<p>\u7576\u4f60\u628a\u9019\u4efd\u611f\u67d3\u7684Excel \u6587\u4ef6\uff0c\u8f49\u5bc4\u7d66\u5176\u5b83\u4eba\u6642\uff0c\u9019\u4efd\u6587\u4ef6\uff0c\u4e00\u6a23\u6703\u628a\u81ea\u5df1\u5beb\u5230XLSTART \u76ee\u9304\uff0c\u518d\u53bb\u611f\u67d3\u5176\u5b83\u672a\u4e2d\u6bd2\u7684\u6587\u4ef6\u3002<\/p>\n<p>\u767c\u4f5c\u6642\u7684\u75c7\u72c0\uff0c\u6703\u8b93Excel\u756b\u9762\u4e00\u76f4\u4e0d\u505c\u9583\u720d\uff0c\u6587\u4ef6\u7121\u6cd5\u64cd\u4f5c\uff0c\u9020\u6210\u4f7f\u7528\u8005\u56f0\u64fe\u3002\u53e6\u5916\uff0c\u7576\u696d\u52d9\u628aExcel\u8cc7\u6599\u5bc4\u7d66\u5ba2\u6236\u6642\uff0c\u88ab\u5ba2\u6236\u9000\u4fe1\uff0c\u6703\u9020\u6210\u6211\u9019\u500b\u9ce5MIS \u81c9\u4e0a\u7121\u5149\uff0e\uff0e\uff0e<\/p>\n<p>\u6709\u9451\u65bc\u6b64\uff0c\u9019\u500b\u554f\u984c\u4e00\u5b9a\u8981\u597d\u597d\u7684\u4f86\u8655\u7406\u4e00\u4e0b\u3002<\/p>\n<p>\u5148\u4e86\u89e3\u4e00\u4e0b\uff0c\u70ba\u4ec0\u9ebc\u6211\u5011\u7684User \u6703\u4e2d\u6bd2\u5462? \u4e3b\u8981\u662f\u5728\u4f7f\u7528\u8005\u7aef\u7684\u96fb\u8166\uff0c\u76ee\u524d\u90fd\u6c92\u5b89\u88dd\u9632\u6bd2\u8edf\u9ad4\u3002\u56e0\u70ba\u5927\u90e8\u4efd\u7684User\u90fd\u5df2\u7d93\u4f7f\u7528Ncomputing \u4e86\uff0c\u6c92\u6709\u5be6\u9ad4\u4e3b\u6a5f\uff0c\u800c\u5b58\u53d6\u7684\u786c\u789f\uff0c\u90fd\u5c6c\u65bcSamba \u6a94\u6848\u7cfb\u7d71\uff0c\u5728\u6a94\u6848\u7cfb\u7d71\u4e0a\u6709\u88dd\u9632\u6bd2\u8edf\u9ad4\uff0c\u5982\u679c\u6709\u75c5\u6bd2\u6a94\u6848\u5b58\u5165\uff0c\u99ac\u4e0a\u5c31\u6703\u88ab\u79fb\u9664\u3002<\/p>\n<p>\u518d\u4f86\uff0c\u4efb\u4f55\u6587\u4ef6\u7684\u50b3\u905e\u57fa\u672c\u4e0a\u90fd\u900f\u904eEmail Server\uff0c\u800cEmail Server \u4e0a\u4e5f\u6709\u88dd\u9632\u6bd2\u8edf\u9ad4\uff0c\u6240\u4ee5\u5982\u679c\u6709\u75c5\u6bd2\u6a94\u6848\u50b3\u905e\uff0c\u4e5f\u6703\u99ac\u4e0a\u88ab\u64cb\u4e0b\u4f86\u3002<\/p>\n<p>\u5728\u5c0f\u745e\u9019\u500b\u770b\u4f3c\u5929\u8863\u7121\u7e2b\u7684\u898f\u5283\u4e0b\uff0c\u5c45\u7136\u9084\u662f\u6709\u75c5\u6bd2\u947d\u4e86\u9032\u4f86 &gt;_<\/p>\n<p>\u5c0f\u745e\u7684\u8655\u7406\u65b9\u5f0f\u5982\u4e0b\uff1a<\/p>\n<p>\u5df2\u7d93\u4e2d\u6bd2\u7684\u96fb\u8166\uff0c\u5148\u624b\u52d5\u6e05\u9664\u75c5\u6bd2\uff1a<\/p>\n<ul>\n<li>\u9032\u5165\u8a72User \u7684\u5e33\u865f\u4e0b\uff0c\u76f4\u63a5\u628a XLSTART \u4e0b\u7684\u81ea\u52d5\u57f7\u884c\u5de8\u96c6\u522a\u9664<br \/>\n\u901a\u5e38\u7684\u4f4d\u7f6e\u5728 C:\\documents and settings\\user\\Application data\\Microsoft\\excel\\XLSTART \u9019\u500b\u76ee\u9304\uff0c\u5404windows \u7248\u672c\u6709\u4e9b\u4e0d\u540c\uff0c\u57fa\u672c\u4e0a\u6211\u7684\u4f7f\u7528\u8005\u7d71\u4e00\u4f7f\u7528Windows 2003\uff0c\u6bd4\u8f03\u597d\u8655\u7406\u3002<br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.nuface.tw\/wp-content\/uploads\/2012\/09\/f-prot-2.jpg\" alt=\"XLSTART\u4f4d\u7f6e\" \/><\/p>\n<\/li>\n<li>\u79fb\u9664 User \u5c0d\u9019\u500b\u76ee\u9304\u5beb\u7684\u6b0a\u9650\u79fb\u9664\uff0c\u9632\u6b62User \u6253\u958b\u4e2d\u6bd2\u7684\u6a94\u6848\u5f8c\uff0c\u53c8\u81ea\u52d5\u5beb\u5165\u9019\u500b\u76ee\u9304\u4e2d\u3002<br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.nuface.tw\/wp-content\/uploads\/2012\/09\/f-prot-3.jpg\" alt=\"XLSTART\u6b0a\u9650\u8a2d\u5b9a\" \/><\/p>\n<\/li>\n<li>\u4f7f\u7528User \u7684\u5e33\u865f\u767b\u5165\u7cfb\u7d71<br \/>\n\u6b64\u6642\u6253\u958bExcel\uff0c\u8abf\u9ad8\u5de8\u96c6\u7684\u5b89\u5168\u6027\uff0c\u81f3\u5c11\u8981\u5728\u4e2d\u7684\u7b49\u7d1a\u3002Path -&gt; Excel -&gt; \u5de5\u5177 -&gt; \u5de8\u96c6 -&gt; \u5b89\u5168\u6027<br \/>\n\u4e0b\u6b21\u6253\u958b\u6587\u4ef6\u6642\uff0c\u5982\u679c\u8a72\u6587\u4ef6\u6709\u5de8\u96c6\uff0c\u6703\u8a62\u554f\u4f60\u8981\u4e0d\u8981\u57f7\u884c\u3002<br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.nuface.tw\/wp-content\/uploads\/2012\/09\/f-prot-4.jpg\" alt=\"Excel \u5de8\u96c6\u5b89\u5168\u6027\u8a2d\u5b9a\" \/><\/p>\n<\/li>\n<li>\u63a5\u8457\u7531User \u81ea\u884c\u53bb\u6e05\u9664\u4e2d\u6bd2\u7684\u6587\u4ef6<br \/>\n\u7576User \u6253\u958bExcel \u6587\u4ef6\u6642\uff0c\u5982\u679c\u6709\u8df3\u51fa\u8996\u7a97\u8a62\u554f\u662f\u5426\u57f7\u884c\u5de8\u96c6\uff0c\u56de\u7b54\uff0d\u505c\u7528\u5de8\u96c6\u3002<br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.nuface.tw\/wp-content\/uploads\/2012\/09\/f-prot-5.jpg\" alt=\"Excel \u555f\u52d5\u5de8\u96c6\u63d0\u793a\" \/><\/p>\n<\/li>\n<li>\u6253\u958b visual Basic<br \/>\nExcel -&gt; \u5de5\u5177 -&gt; \u5de8\u96c6 -&gt; visual Basic\u7de8\u8f2f\u5668<br \/>\n\u9032\u5165\u5f8c\uff0c\u5728\u6a21\u7d44\u4e0b\uff0c\u5982\u679c\u6709StartUp \u6a21\u7d44\uff0c\u8868\u793a\u4e2d\u6bd2\u4e86\uff0c\u6e38\u6a19\u9ede\u4f4f\u8a72\u6a21\u7d44\uff0c\u6309\u53f3\u9375\uff0c\u79fb\u9664 StartUp \uff0c\u79fb\u9664\u524d\u662f\u5426\u532f\u51fa\uff1f\u7576\u7136\u4e0d\u8981\u5440\uff0e<br \/>\uff0e<br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.nuface.tw\/wp-content\/uploads\/2012\/09\/f-prot-6.jpg\" alt=\"Excel VB \u7de8\u8f2f\u5668\u4f4d\u7f6e\" \/><\/p>\n<p><img decoding=\"async\" src=\"http:\/\/blog.nuface.tw\/wp-content\/uploads\/2012\/09\/f-prot-7.jpg\" alt=\"\u79fb\u9664StartUp \u4f4d\u7f6e\" \/><\/p>\n<p><img decoding=\"async\" src=\"http:\/\/blog.nuface.tw\/wp-content\/uploads\/2012\/09\/f-prot-8.jpg\" alt=\"Startup \u79fb\u9664\u63d0\u793a\" \/><\/p>\n<\/li>\n<li>\u5c07\u6b64\u6a94\u5b58\u6a94\u5f8c\uff0c\u5373\u5b8c\u6210\u6e05\u6bd2\u7684\u52d5\u4f5c\u3002<\/li>\n<\/ul>\n<p>\u4ee5\u4e0a\u662f\u6cbb\u6a19\u7684\u52d5\u4f5c\uff0c\u6e05\u9664\u75c5\u6bd2\uff0c\u540c\u6642\u4e0d\u8b93\u75c5\u6bd2\u518d\u611f\u67d3 XLSTART\uff0c\u63a5\u8457\u8981\u8655\u7406Email Server \u7aef\uff0c\u9632\u6b62\u75c5\u6bd2\u7684\u50b3\u905e\u3002<\/p>\n<ul>\n<li>Clamav \u7121\u6cd5\u6aa2\u6e2c\u51fa\u5de8\u96c6\u75c5\u6bd2\uff0c\u6539\u7528\u51b0\u5cf6\u4e00\u5bb6\u8edf\u9ad4\u516c\u53f8\u958b\u767c\u7684 f-prot \u9019\u5957\u8edf\u9ad4\uff0chome user \u7248\u672c\u76ee\u524d\u662f\u514d\u8cbb\u7684\u3002<\/li>\n<li>\u8edf\u9ad4\u4e0b\u8f09\u8def\u5f91 http:\/\/www.f-prot.com\/download\/home_user\/<br \/>\n\u770b\u4f60\u662f 32 bit OS \u9084\u662f 64 bit OS\uff0c\u5c0f\u745e\u88dd\u7684\u662f 64 bit CentOS 5 \u6240\u4ee5\u4e0b\u8f0964 bit \u7a0b\u5f0f\u3002<\/p>\n<blockquote><p>cd \/opt<br \/>\nwget http:\/\/files.f-prot.com\/files\/unix-trial\/fp-Linux.x86.64-ws.tar.gz<br \/>\ntar \u2013zxvf fp-Linux.x86.64-ws.tar.gz<br \/>\ncd f-prot<br \/>\n.\/install-f-prot.pl<\/p><\/blockquote>\n<p>\u57fa\u672c\u4e0a\u90fd\u7167\u9810\u8a2d\u503c\u5373\u53ef\u5b89\u88dd\u6210\u529f<\/li>\n<li>\u4fee\u6539amavisd \u8a2d\u5b9a\u6a94<br \/>\n<blockquote><p>cd \/etc\/amavisd\/<br \/>\nvi amavisd.conf<\/p><\/blockquote>\n<p>\u5728\u8a2d\u5b9a\u6a94\u4e2d\u4fee\u6539<br \/>\n$final_virus_destiny = D_REJECT; #\u6539\u70ba\u9000\u56de, \u8b93\u5bc4\u4ef6\u8005\u77e5\u9053\u4e2d\u6bd2<\/p>\n<p>\u5728 @av_scanners = ( \u6bb5\u4e2d\u52a0\u5165\u5982\u4e0b\u8a2d\u5b9a<\/p>\n<blockquote><p>[&#8216;FRISK F-Prot Antivirus&#8217;, &#8216;fpscan&#8217;,<br \/>\n&#8216;&#8211;scanlevel=2 &#8211;archive=5 &#8211;verbose=1 {}&#8217;, [0],<br \/>\nqr\/Found virus\/,<br \/>\nqr\/\\[Found virus\\] \\\/ ],<\/p><\/blockquote>\n<p>\u540c\u6642\u628a ClamAV Mark \u6389\uff0c\u6539\u7528F-Prot\uff0c\u57fa\u672c\u4e0aF-prot \u53ef\u4ee5\u5e38\u99d0\u5728\u8a18\u61b6\u9ad4\u4e2d\uff0c\u5728\u6383\u6bd2\u6642\uff0c\u4ee5daemon \u65b9\u5f0f\u547c\u53eb\u3002\u4f46\u514d\u8cbb\u7248\u53ea\u652f\u63f4 command line\uff0c\u6240\u4ee5\u5728 av_scanners \u4e2d\u7684\u8a9e\u6cd5\uff0c\u6539\u70ba\u4ee5command line \u65b9\u5f0f\u6383\u6bd2\u3002<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>\u8a66\u8457\u5bc4\u51fa\u4e00\u5c01\u75c5\u6bd2\u4fe1\uff0c\u7d50\u679c\u771f\u7684\u88ab\u64cb\u4e0b\u4f86\u4e86\u3002<br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.nuface.tw\/wp-content\/uploads\/2012\/09\/f-prot-9.jpg\" alt=\"\u767c\u73fe\u75c5\u6bd2\u9000\u4fe1\" \/><\/p>\n<p>Mail Server \u7aef\u8655\u7406OK, \u81f3\u65bcSamba \u7aef\u4e5f\u53ef\u4ee5\u6539\u7528 f-prot\uff0c\u56e0\u70basamba \u6709\u652f\u63f4vscan-fprotd.so\uff0c\u4f46\u61f6\u5f97\u6539\u4e86\uff0c\u4ecd\u7136\u4f7f\u7528vscan-clamav.so \u8655\u7406\u6a94\u6848\u4f3a\u670d\u5668\u7aef\u7684\u554f\u984c\uff0c\u53cd\u6b63User \u4e5f\u50b3\u4e0d\u51fa\u53bb\uff0c\u4e5f\u7121\u6cd5\u518d\u611f\u67d3\uff0c\u5c31\u4e0d\u7406\u5b83\u4e86\u3002<\/p>\n<p>\u7d93\u904e\u9019\u4e00\u756a\u6574\u6cbb\uff0c\u7e3d\u7b97\u628a\u9019\u500b\u56f0\u64fe\u5df2\u4e45\u7684\u5de8\u96c6\u75c5\u6bd2\u641e\u5b9a\uff0c\u8d95\u5feb\u4e0a\u4f86\u9ce5blog \u4e0a\u767c\u8868\u4e00\u4e0b\uff0c\u63d0\u4f9b\u7d66\u6709\u985e\u4f3c\u554f\u984c\u7684\u670b\u53cb\u53c3\u8003\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6700\u8fd1\u516c\u53f8\u5167\u5728\u6d41\u50b3Excel \u75c5\u6bd2\u4fe1\uff0c\u641e\u5230\u96c6\u5718\u5167\u70fd\u7159\u56db\u8d77\uff0c\u5230\u8655\u90fd\u6709\u707d\u60c5\u3002\u6211\u8a18\u5f97\u6211\u7684Mail Server \u6709\u88dd\u9632 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,24],"tags":[169,33,174,171,170,173,172,175,167,168],"class_list":["post-1440","post","type-post","status-publish","format-standard","hentry","category-mistech","category-mistech-net","tag-clamav","tag-excel","tag-f-prot","tag-postfix","tag-samba","tag-startup","tag-xlstart","tag-175","tag-167","tag-168"],"_links":{"self":[{"href":"https:\/\/blog.nuface.tw\/index.php?rest_route=\/wp\/v2\/posts\/1440","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.nuface.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.nuface.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.nuface.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.nuface.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1440"}],"version-history":[{"count":14,"href":"https:\/\/blog.nuface.tw\/index.php?rest_route=\/wp\/v2\/posts\/1440\/revisions"}],"predecessor-version":[{"id":1540,"href":"https:\/\/blog.nuface.tw\/index.php?rest_route=\/wp\/v2\/posts\/1440\/revisions\/1540"}],"wp:attachment":[{"href":"https:\/\/blog.nuface.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1440"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.nuface.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1440"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.nuface.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}