3C健忘人 - 疑難排除不求人 - no more ask for IT help

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/

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

 使用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

1. search ->gpedit.msc

請先將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

 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

大量映像檔複製系統可能會出現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  

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

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

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

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

@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

 Allow apps from Security & Privacy -> VMware

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

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

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無線速度

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

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

 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  

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

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

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  

 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

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...

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

   請參考 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);   ...

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

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

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

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

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/

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.c...

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

 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    

 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

利用原廠指引 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" 所代表的意思

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

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

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

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/

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

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

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...

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

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