發表文章

目前顯示的是 2020的文章

shareware freeware portable apps

References   PortableAppZ https://portableappz.blogspot.com  ftuapps.dev https://ftuapps.dev/category/portable-apps/  

螢幕購買參考

 references https://www.displayspecifications.com/en https://www.displaydb.com/ https://monitor.buyerguide.info/ https://prosettings.net/best-gaming-monitor/

Windows 10 Enterprise將遠端桌面斷線使用者於固定時間登出

圖片
1. search -> gpedit.msc 2. 電腦設定->系統管理範本->Windows元件->遠端桌面服務->遠端桌面工作階段主機 ->工作階段時間限制 3. 設定已斷線工作階段的時間限制->10分鐘,以增加資源輪動提供效率 4. 為使用中但閒置的遠端桌面服務工作階段設定時間限制 -> 30分鐘,讓Session占用先行釋出記憶體  

Microsoft Excel 隨機產生密碼

圖片
 使用Microsoft Excel 產生 6 位數預設密碼字串,但每次開啟檔案都會重置密碼 1. 先在欄位新增一亂數要使用到的密碼字串,如下圖[A-Z][a-z][0-9],但為了有些造成混淆的字元,我們去掉 大寫 I, 大寫O,數字0,與數字1     2. 接著在要產生的欄位$E$2 輸入函數,如以下,假設我們要使用$F$2欄位值,來對$E$2欄位產生一個6位數密碼,利用 MID() 來傳回字元,並根據MID()函數規格,第二個參數傳回由RAND()產生的隨機字串長度之索引字元,傳回單一字元給該 $E$2欄位, 並利用& 來串起所需的6個字元成為字串 =MID($F$2,INT(RAND()*LEN($F$2))+1,1)&MID($F$2,INT(RAND()*LEN($F$2))+1,1)&MID($F$2,INT(RAND()*LEN($F$2))+1,1)&MID($F$2,INT(RAND()*LEN($F$2))+1,1)&MID($F$2,INT(RAND()*LEN($F$2))+1,1)&MID($F$2,INT(RAND()*LEN($F$2))+1,1) 3. 產生第一個欄位後,接著選取由該函數產生的欄位,在欄位右下角滑鼠指標成為 + 時,再往下拉到所要的行數   References  https://support.microsoft.com/zh-tw/office/mid%E3%80%81midb-%E5%87%BD%E6%95%B8-d5f9e25c-d7d6-472e-b568-4ecb12433028  https://support.microsoft.com/zh-tw/office/rand-%E5%87%BD%E6%95%B8-4cbfa695-8869-4788-8d90-021ea9f5be73

Windows 10 強制移除遠端桌面使用者開關機能力

圖片
1. search ->gpedit.msc

Microsoft surface pro 4 core i5-6300U Type Cover 失去效用

請先將Windows 系統與 surface pro firmware更新至最新,再依照下列BIOS步驟取消, 1.重開後,再enable  Surface Pro 4 Type cover失效 (第5頁) - Mobile01 下載適用於 Surface 的驅動程式和韌體 - Office 支援 (microsoft.com) Surface Pro4 鍵盤突然不能使用 - Microsoft Community 2.把電全部放完,再做重開,主機與鍵盤皆要放盡 3.按下power與音量鍵+常按不放,至少15秒以上 4. 在C:\Windows\System32\drivers分別放入SurfaceTypeCover.sys與SurfaceTypeCoverV3Integration.sys

AI GAN for face

 https://thispersondoesnotexist.com/  https://make.girls.moe/#/   https://s3-us-west-2.amazonaws.com/kinesis-helpers/selfie.html   AI Meme for fun  https://imgflip.com/ai-meme

Windows 重置 SID

大量映像檔複製系統可能會出現SID重複問題,故需重新啟用 1. search -> cmd.exe -> run as administrator 2. C:\Windows\System32\Sysprep\sysprep.exe or sysprep /generalize /oobe   p.s. Windows 10的clone會自動重新產生新SID reference https://www.mobile01.com/topicdetail.php?f=300&t=5456981 https://docs.microsoft.com/zh-tw/troubleshoot/windows-server/identity/security-identifiers-in-windows  

macOS add shortcut

1. press option + command 2. click app icon and drag to your own position. reference https://support.apple.com/en-us/HT201236 https://www.laptopmag.com/articles/macos-desktop-shortcuts

Closing SIP(System Integrity Protection) on macOS

圖片
1. open console 2. type instruction: csrutil status 3. reboot macOS and press command + R after first beep 4. choose utility -> terminal / console 5. type instruction: csrutil disable

Executing windows app on macOS

 1. installing wine and winebottler wine https://wiki.winehq.org/MacOS winebottler https://winebottler.kronenberg.org/downloads

locate file on macOS

1. sudo launchctl load -w /System/Library/LaunchDaemons/com.apple.locate.plist 2.  sudo /usr/libexec/locate.updatedb 3. locate [filename] or mdfind -name [filename] references https://apple.stackexchange.com/questions/350610/macos-mojave-locate-not-working https://stackoverflow.com/questions/38373920/locate-linux-command-alternative-for-mac-osx

Create Httpd service with Python

圖片
@Python3 -3.6.8  python3 -m http.serve python3 -m http.server 8080 --bind 127.0.0.1 @Python2  python -m simpleHTTPServer references https://developer.mozilla.org/en-US/docs/Learn/Common_questions/set_up_a_local_testing_server  https://docs.python.org/3/library/http.server.html

vmware could not open /dev/vmmon: Broken pipe on macOS

圖片
 Allow apps from Security & Privacy -> VMware

JavaScipt 數字格式化輸出

 1. 會計單位用 http://openexchangerates.github.io/accounting.js/   2.數字專門用 http://numeraljs.com/

各設備預設帳密

 FijiXerox https://support.4it.com.au/article/fuji-xerox-default-passwords/

Acer V3-371-50BW 改 Intel AC7260 wifi bluetooth

圖片
1. 開啟後蓋後,將原本的 mini PCIe Atheros WIFI 移除,並插上 Intel AC7260 mini PCIe  2. 至Intel 網站下載兩份驅動 https://downloadcenter.intel.com/product/75439/Intel-Dual-Band-Wireless-AC-7260 Downloading WIFI wireless and WIFI bluetooth driver 3. 安裝兩個驅動  4. 記得一定需要重新開機,才可以看到兩種晶片驅動成功 5. 連線穩定,改善瞬斷,下圖為 100Mb/40Mb光纖跑5GHz無線速度

Android Huawei Recovery factory setting for Android 華爲雙清

圖片
1. 關機狀態同時按住電源鈕,與音量上鍵,會出現圖一照片。 2. 可先清除Cache分區 3. 選擇恢復出廠設置,如圖二 ,接著會出現格式化分區,如圖三 (圖一) (圖二) (圖三)

Units translator online 單位轉換計算機

https://www.acc.ntu.edu.tw/unit

Force uninstall/remove on CentOS 7

圖片
 1. rpm -e --nodeps --noscripts packages     2. yum remove --setopt=tsflags=noscripts packages Reference https://serverfault.com/questions/613256/yum-error-in-preun-scriptlet-when-removing-packages  

CentOS 8 support HEIF format

圖片
1. su - 2. dnf install qt-heif-image-plugin gimp-heif-plugin 3. dnf install libheif-* 4. heif-convert file.HEIF file.JPG 5.shell script $ for img in *.HEIC >do   >  heif-convert -q 85 $img  `basename $img .HEIC`.JPEG > done or oneline: for img in *.HEIC; do convert $img `basename $img .HEIC` .JPEG; done For MS Windows 10 Microsft Store HEVC enhacement https://www.microsoft.com/zh-tw/p/hevc-video-extensions-from-device-manufacturer/9n4wgh0z6vhq?activetab=pivot:overviewtab HEIF enhancement https://www.microsoft.com/zh-tw/p/heif-%e5%bd%b1%e5%83%8f%e5%bb%b6%e4%bc%b8%e6%a8%a1%e7%b5%84/9pmmsr1cgpwg?activetab=pivot:overviewtab References http://fritzthecat-blog.blogspot.com/2019/07/view-heic-photos-on-linux.html for Windows SONY supported https://support.d-imaging.sony.co.jp/app/heif/zh-hant / Deli https://www.deliheic.com/best-free-heic-converter.html CopyTrans https://www.copytrans.net/copytransheic/ Fasterland http://converseen.fasterland.net/download

Top 10 blacklist in the world

https://www.spamhaus.org/statistics/countries/ whiltelist http://www.whitelisted.org check spammed host http://apews.org/ http://www.blacklistalert.org/  https://www.dnsbl.info/dnsbl-database-check.php

PCIe M.2 SSD vs SATA SSD RAID-0 Benchmark

圖片
1. Capacity 256GB 2. Brand: SAMSUNG MZHPU256 with PCIe Adapter vs Sandisk 128G*2 with QNAP A2AMR Raid-0 3. Conclusion      (Figure 1) Raid-0 has less Access Time and stable accessing, But PCIe SSD has more Average Read / Write Rate in  Figure 1. Courtesy of Gnome Disks Utility  

解決 Outlook 2016 .ost 與 MS Exchange Server 不同步問題

圖片
 1. Outlook 檔案 -> 帳戶設定  1 2. 進入後帳戶設定號->電子郵件->選擇要同步的帳號->變更->取消預設勾選的同步選項 3.選下一步後->重新啟動 Outlook 2016 References https://support.microsoft.com/zh-tw/office/%E9%96%8B%E5%95%9F%E5%BF%AB%E5%8F%96-exchange-%E6%A8%A1%E5%BC%8F-7885af08-9a60-4ec3-850a-e221c1ed0c1c

新增 gpedit.msc 至 Windows 10 home edition

圖片
1. search -> cmd.exe -> right click mouse -> run as administrator > dir /b %SystemRoot%\servicing\Packages\Microsoft-Windows-GroupPolicy-ClientExtensions-Package~3*.mum > dir /b %SystemRoot%\servicing\Packages\Microsoft-Windows-GroupPolicy-ClientTools-Package~3*.mum >dism /online /norestart /add-package:"%SystemRoot%\servicing\Packages\Microsoft-Windows-GroupPolicy-ClientExtensions-Package~31bf3856ad364e35~amd64~zh-TW~10.0.19041.1.mum"  >dism /online /norestart /add-package:"%SystemRoot%\servicing\Packages\Microsoft-Windows-GroupPolicy-ClientExtensions-Package~31bf3856ad364e35~amd64~10.0.19041.1.mum"   >dism /online /norestart /add-package:"%SystemRoot%\servicing\Packages\Microsoft-Windows-GroupPolicy-ClientTools-Package~31bf3856ad364e35~amd64~zh-TW~10.0.19041.508.mum"   >dism /online /norestart /add-package:"%SystemRoot%\servicing\Packages\Microsoft-Windows-GroupPolicy-ClientTools-Package~31bf3856ad364e35~amd64~10.0.19

Power Plan Assistant for bootcamp and Microsoft .NET Framework 無法載入DLL 'fsLib.dll'

圖片
1. remove evercam and power plan assistant 2. remove MS Office 2016 3. reinstall MS Office 2016/2019  references http://www.forbootcamp.org/

phpMyAdmin 匯出頁面出現 Field:group: OpenDocument/OpenOffice試算表 has no type 錯誤

圖片
   請參考 https://github.com/williamdes/phpmyadmintest/commit/47971806316304f650ca1b3742e2a53801d2a794   如上新增綠色處       protected function cleanGroupPaths(array $form): array     {         foreach($form as &$name) {             if (mb_strpos((string) $name, ':group:') === 0) {                 $name = str_replace('/', '-', $name);             }         }         return $form;     }     public function loadForm($form_name, array $form)     {         $this->name = $form_name;          $form=$this->cleanGroupPaths($form);         $this->readFormPaths($form);         $this->readTypes();     } }

看主機板內建Windows 序號 Read Windows SN on mainboard

圖片
1. download from http://rweverything.com/download/ 2.download and unzip portable edition 3. execute rweverything -> go to ACPI icon -> MSDM tab -> Data or showkeyplus software  https://github.com/Superfly-Inc/ShowKeyPlus/releases or search -> cmd.exe -> right click to  run as administrator \> wmic path softwarelicensingservice get OA3xOriginalProductKey   references https://answers.microsoft.com/en-us/windows/forum/windows_10/windows-10-this-product-key-didnt-work-please/95a7e9cd-077f-40d6-b3df-028f8c41303a?page=2 https://docs.microsoft.com/en-us/windows/deployment/deploy-enterprise-licenses https://www.tenforums.com/software-apps/2577-showkeyplus.html https://www.nirsoft.net/utils/product_cd_key_viewer.html

解決 0x0000225 硬碟複製後產生 error code

1. Boot with installation media 2. left bottom to go to repair my OS 3. command line mode  and input below command    bootrec /fixmbr    bootrec /fixboot    bootrec /scanos    bootrec /rebuildbcd 參考 https://docs.microsoft.com/zh-tw/azure/virtual-machines/troubleshooting/boot-error-status-not-found https://www.reneelab.net/error-code-0xc0000225.html https://www.repairwin.com/fix-your-pc-needs-to-be-repaired-error-0xc0000225/ https://www.diskpart.com/articles/windows-error-0xc00000e9-7201.html

Free remote Desktop Apps for multi OS

1. Teamviewer https://www.teamviewer.com/tw/download/linux/ 2. NoMachine https://www.nomachine.com/download 3. AnyDesk https://anydesk.com/en/downloads/linux

Remote Desktop from CentOS 8 client

圖片
Method A 1.  download .rpm from below URL rpmfind https://www.rpmfind.net/linux/epel/testing/8/Everything/x86_64/Packages/r/rdesktop-1.9.0-3.el8.x86_64.rpm http://mirror.ancl.hawaii.edu/linux/epel/testing/8/Everything/x86_64/Packages/r/ 2. $sudo rpm -ivh rdesktop-1.9.0-3.el8.x86_64.rpm 3. $rdesktop -u user  host_ip:3389 Method B 1. Remote Desktop Viewer in Gnome 2. Input Hosts, Username, and Your favor Width and Height for remoted window

總部在中國的 WIFI / IP CAM 廠商

1. Foscam Shenzhen Foscam Intelligent Technology Co.,Ltd深圳市福斯康姆智能科技有限公司 2. Hikvision 杭州海康威視數位技術股份有限公司 3. EZViz 螢石 待補 references https://www.a1securitycameras.com/consumer-friendly-articles/security-camera-manufacturers-with-country-of-origin/

Dell EMC T440 fan noise and OS installation on Windows 10

圖片
1. because of 3rd pcie graphic card 2. Setup iDRAC ethernet and assign a virtual IP 3. use service card in front panel to login iDRAC Web service 4. Web iDRAC  include BIOS setting, or reboot to press F10 to configure setting 5. download putty.exe 6. ssh iDRAC ip and login for root of racadm >> 7. cooling for silence fan offset if your pcie card in slot 3   get system.pcieslotlfm.3   set system.pcieslotlfm.3.lfmmode 1     # disable LFMMode, if 2 is stand for custom   set system.thermalsettings.fanspeedoffset off 8. search -> cmd.exe -> run as administrator -> net stop termservice 9. download rdpwrap from github -> unzip -> run install.bat as administrator 10. net start termservice in step 8 window 11. update latest .ini from https://github.com/stascorp/rdpwrap/issues   Link for autoupdating rdpwrap.ini https://github.com/asmtron/rdpwrap/blob/master/binary-download.md 2021.03.04 worked .ini https://github.com/stascorp/rdpwrap/issues/1326 OS: Wi

解決Synology NAS 您沒有權限使用本項服務 you are not authorized to use this service

圖片
 1. 在控制台->使用者帳號停用admin帳號後,請記得先產生另一個屬於administrators群組的帳號 2. 在控制台->使用者群組->選擇users按編輯->應用程式 ,請勿 勾選拒絕 DSM(因為新增的使用者一定會出現在Users群組) 3. 若要禁止非管理者使用DSM,請進入使用者帳號->選擇帳號典編輯-> 在DSM處選擇拒絕即可

Microsoft Security Update Guide

 https://portal.msrc.microsoft.com/en-us/security-guidance  check security issue for windows or windows server https://support.microsoft.com/zh-tw/topic/windows-7-sp1-%E5%92%8C-windows-server-2008-r2-sp1-%E6%9B%B4%E6%96%B0%E8%A8%98%E9%8C%84-720c2590-fd58-26ba-16cc-6d8f3b547599 update catalog https://www.catalog.update.microsoft.com/Home.aspx    CISA https://us-cert.cisa.gov/ https://us-cert.cisa.gov/ncas/current-activity/2020/08/11/microsoft-addresses-rce-and-spoofing-vulnerabilities-under-active   references https://www.cvedetails.com/vulnerability-list/vendor_id-26/Microsoft.html    

CentOS 8 chrony for ntp update

圖片
 1.  su - 2. dnf install chronyd 3. edit /etc/chronyd.conf 4. timedatectl set-ntp yes 5. chronyc -a makesetp 6. systemctl enable chronyd 7. systemctl restart chronyd References https://www.tecmint.com/install-chrony-in-centos-ubuntu-linux/ https://chrony.tuxfamily.org/faq.html

SAS9.4 ERROR: 資料館 SASUSER 的實體名稱無效。

圖片
利用原廠指引 http://support.sas.com/kb/12/457.html 找尋 SASHome\SASFoundation\9.4\nls\en內的sasv9.cfg 將檔案內 -SASUSER 重確認正確路徑與寫入權限 https://support.sas.com/kb/50/713.html 可以看到  -SASUSER "?FOLDERID_Documents\My SAS Files\9.4" 所代表的意思

Microsoft Surface go 退出 S 模式

Windows S模式 https://support.microsoft.com/zh-tw/help/4020089/windows-10-in-s-mode-faq 退出S模式 https://support.microsoft.com/zh-tw/help/4456067/windows-10-switch-out-of-s-mode

Open Source RPA

圖片
1. download from https://ui.vision/ chrome, firefox, edge 2. download xmodule for x events from https://ui.vision/rpa/x 3. check demo code and you can add your own Macro

CentOS GRUB2 修改開機預設

圖片
1.Switch to root and show options at booting $ su - $ awk -F\'  '$1=="menuentry" {print $i++" : " $2}' /etc/grub2-efi.cfg or $ grep "^menuentry" /etc/grub2-efi.cfg | cut -d "'" -f2 (figure 1) 2. check saved entry at /etc/grub2.cfg $  grub2-editenv list 3.  set default, the first index is 0, if you want to change to second core $ grub2-set-default 1 參考資料 https://wiki.centos.org/zh-tw/HowTos/Grub2

NetCat(nc / ncat) on CentOS Linux

圖片
1. IF server IP : 192.168.10.10 , client IP: 192.168.10.78 Server: listen for connections $ ncat -l 8081 or bind a shell to tcp port 8081, limit access to hosts on local network, and limit the maximum nuber of simultaneous connection to 1 $ ncat --exec "/bin/bash" --max-conns 1 --allow 192.168.10.0/24 -l 8081 --keep-open 2. client connect to server port 8081 $ ncat 192.168.10.10 8081  # stand by typing any instruction 3. Send a file over TCP port 8081 from  client to server 192.168.10.10$ ncat -l 8081 > tmpfile.log 192.168.10.78$ ncat 192.168.10.10 8081 < tmpfile.log    # real file in this path 4. the udp option is -u, because ncat default protocol is tcp (Figure 1. snipping of Man page ) references https://www.linuxtechi.com/nc-ncat-command-examples-linux-systems/ https://www.tecmint.com/netcat-nc-command-examples/

Windows 10 Edge 我的最愛路徑

圖片
1.先從以下位址複製舊的我的最愛列,可能在舊硬碟的磁碟槽  2. 再於edge瀏覽器選擇匯入就瀏覽器設定,就可以匯入舊的我的最愛列 舊版IE我的最愛位址 參考 https://answers.microsoft.com/zh-hans/edge/forum/all/windows-10/609d2783-5756-432e-b436-2d63b90ff1b4

MS Windows 10 桌布預設位置

圖片
1. 開啟顯示隱藏檔。自訂桌面圖位置 C:\Users\AccountName\AppData\Roaming\Microsoft\Windows\Theme 移機後可從該處複製原本桌布圖過去。 2. 系統預設圖位置 參考資料 https://support.microsoft.com/zh-tw/help/13768/desktop-themes-featured

Firewalld reject IPs on CentOS 7/8

圖片
Use rich-rule $ firewall-cmd --permanent --add-rich-rule="rule family='ipv4' source address='10.0.10.0/24' reject" or add port $ firewall-cmd --permanent --add-rich-rule="rule family='ipv4' source address='10.0.10.0/24' port port='110' protocol='tcp' reject" $firewall-cmd --reload @reject dovecot postfix from external IP and accept internal IP firewall-cmd --permanent --add-rich-rule='rule family=ipv4 port port="25" protocol="tcp" reject' firewall-cmd --permanent --add-rich-rule='rule family=ipv4 port port="110" protocol="tcp" reject' firewall-cmd --permanent --add-rich-rule='rule family=ipv4 port port="143" protocol="tcp" reject' firewall-cmd --permanent --add-rich-rule='rule family=ipv4 source address='192.168.0.0/16' accept' firewall-cmd --permanent --add-rich-rule='rule family=ipv4 source address='127

Browsers stop re-open previous tab

圖片
Google chrome https://www.guidingtech.com/stop-chrome-opening-old-tabs-startup/ Microsoft Edge https://www.howto-connect.com/start-microsoft-edge-without-opening-previous-tabs/ Mozilla FIrefox https://support.mozilla.org/en-US/kb/restore-previous-session

Stop Re-open unclosed windows on Windows 10 while rebooting

圖片
1. search -> regedit.exe -> run as administrator 2. delete Keys at computer\HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\RunOnce 3. delete Keys at computer\HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run 4. check File manger -> option -> disable recovery windows (Figure 3) 5. goto control.exe -> hardware -> power setting -> confirm to change unusage setting   a. check power button behavior   b. disable fast startup option 6. stop privacy setting as figure 5 account setting -> Login option -> privacy (Figure 1) (Figure 2) (Figure 3) (Figure 4) (Figure 5) 參考資料 https://support.microsoft.com/zh-tw/help/2838187 https://help.uaudio.com/hc/en-us/articles/213195423-How-To-Disable-Fast-Startup-in-Windows-10