Posted inActive Directory Windows
List Workstation OS,Name,LastLogon,IP
Get-ADComputer -Filter * -Property * | Select-Object Name,OperatingSystem,DNSHostName,LastLogonDate,IPv4Address | Export-CSV AllWindows.csv -NoTypeInf...
Posted inZimbra
Zimbra: A network service error has occurred.
List trusted ip zmprov gcf zimbraHttpThrottleSafeIPs Add trusted IP zmprov mcf +zimbraHttpThrottleSafeIPs {Add-Trusted-IP} zmprov mcf +zimbraHttpThrot...
SSL For Free + SonicWall + Windows
https://www.sslforfree.com Get 3 files CA_bundle.crt,certificate.crt,Private.key http://slproweb.com/products/Win32OpenSSL.html Win32 OpenSSL v1.1.0e ...
Posted inSonicWall
SonicWALL change certificates
System-Certificates-Import 我的測試是經Comodo申請後, 由IIS再Export出黎的pfx file 先用Import a local end-user....增加mydomain.pfx 再由Import a CA certificate.....增加COMODOR...
Posted inMSSQL
EXECUTE 使用權限在物件 'xp_cmdshell'，資料庫 'master'，擁有者 'dbo' 上被拒絕。
EXECUTE 使用權限在物件 'xp_cmdshell'，資料庫 'master'，擁有者 'dbo' 上被拒絕。 資料庫-master-延伸預存程序-xp_cmdshell-權限 在public增加EXEC權限 己經可以正常修改SQL資料, 但安全問題會出現 由於目前的安全性內容不是系統管理員 ...
Posted in未分類
SQL hex to dec
SELECT CONVERT(VARCHAR(50), 0xC06DCADF544BC3D6ECE7C64F485D2846E7A93F55, 2)
Posted inZimbra
Zimbra show certificate error
zmcontrol status Unable to start TLS: SSL connect attempt failed with unknown error error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificat...
Sonicwall Chrome ERR_SSL_VERSION_OR_CIPHER_MISMATCH
https://x.x.x.x/diag.html Uncheck Enable RC4-Only Cipher Suite Support