Dec 27, 2022

Ubuntu : Install SNMP Agent

 Ubuntu Server v.22.04.1 64-bit - Install SNMP Daemon.

1. sudo apt update && sudo apt upgrade -y

2. sudo apt install snmpd -y

3. sudo nano /etc/snmp/snmpd.conf

4. Search for --> agentAddress     udp:161,udp6:[::1]:161

eg. agentAddress     192.168.0.100:161

Note: The "udp:161,udp6:[::1]:161" means Enabled All Access.

5. Search for --> rocommunity     public

6. Change to --> rocommunity     [Your Community String]

7. Search for --> rocommunity6     public

8. Change to --> rocommunity6     [Your Community String]

9. sudo systemctl restart snmpd


!!! HAPPY COMPUTING !!!


VMWare : Enabled SNMP Services

 VMWare ESXi v.6.7.0 (Update 3) - Enabled SNMP Services.

1. Display current SNMP status --> esxcli system snmp get

2. Enabled SNMP services --> esxcli system snmp set --enable true

3. Configure SNMP Server (aka Target) --> esxcli system snmp set --targets=[SNMP Server IP Address]@161/[Community String]

eg. esxcli system snmp set --targets=192.168.1.100@161/public

4. Configure SNMP System Location (if any) --> esxcli system snmp set --syslocation=[Location Name]

5. Configure SNMP System Contact (if any) --> esxcli system snmp set --syscontact=[Email Address]

6. Configure ESXi Firewall Rule #1 --> esxcli network firewall ruleset set --ruleset-id snmp --allowed-all true

7. Configure ESXi Firewall Rule #2 --> esxcli network firewall ruleset set --ruleset-id snmp -enabled true


Update, 11-Jan-2023.

--> Disable SNMP = esxcli system snmp set --enable false


!!! HAPPY COMPUTING !!!


Dec 15, 2022

Exchange Server 2016 : Command Line

1. Get-ExchangeServer | Format-List Name,Edition,AdminDisplayVersion

2. Get-MailboxDatabase -Status | Select Name,LastFullBackup

3. Get-AuthConfig | fl CurrentCertificateThumbPrint

4. Get-ExchangeCertificate


Exchange Server 2016 : Outlook Search Not Working

 Microsoft Exchange Server 2016 : Outlook Search Not Working.

This issue happen when the "Content Index State" is either corrupted or incorrect.

1. Open --> Exchange Management Shell

2. Get-MailboxDatabaseCopyStatus * | sort name | Select name,status,contentindexstate

3. If the "Content Index State" = FailedandSuspended = Corrupted.

4. Stop-Service MSExchangeFastSearch

5. Stop-Service HostControllerService

6. Get-MailboxDatabase [DB Name] | select EdbFilePath

7. Open --> File Explorer --> Browse to [EDB Path] (eg. F:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database)

8. Find a Sub-Folder with a GUID Name (eg. C5B6A9C4-DDA8-xxxx-xxx), DELETE the entire Sub-Folder.

9. Start-Service MSExchangeFastSearch

10. Start-Service HostControllerService

11. It will take some times to regenerate the index, be patient.

12. To check status --> Get-MailboxDatabaseCopyStatus * | sort name | Select name,status,contentindexstate

13. The status should either be "Crawling" = Work-in-Progress or "Healthy" = Good.


!!! HAPPY COMPUTING !!!


Nov 27, 2022

VMWware ESXi : Fix ESXi Hypervisor "SEsparse" Issue

 VMWare ESXi may report "SEsparse" snapshot may report guest data inconsistencies, refer to VMWare KB 59216.

This issue have also caused the Synology Active Backup for Business failed to perform scheduled backup thus generating error messages.

As per VMWare's KB 59216, the "datastore" capacity that has >2TB may encounter such issues from ESXi v.5.5 and above which means v.6.7 was also affected.

And the solution is update/patch the ESXi Host up to v.6.7 Update 1.


1. Browse to VMWare's Build Number & Listing to get the actual "Release Name" and its corresponding "Build Number" and download the patches accordingly.

2. Login to VMWare Patch Download page (you need to have an login ID, if not proceed to register an account).

3. Select --> ESXi (embedded and installable)

4. Select the appropriate ESXi version you are running, in my case my server is running on VMWare ESXi v.6.7

5. Now you need to compare the current build version vs. the listing and download the appropriate updates/patches.

6. Shutdown all VM(s) that are inside the Host.

7. Host --> Enter Maintenance Mode.

8. Host --> Enable SSH Service.

9. Host --> Enable Console Service.

10. Open --> Putty --> Login via SSH to the Host server.

11. At the CLI --> vmware -l          (to display current version)

12. At the CLI --> vmware -v          (to display current build)

13. At the CLI --> esxcli network firewall ruleset set -e true -r httpClient

14. Login to Host WebUI and browse the "datastore" (eg. datastore1).

15. Create a folder called "updates".

16. Upload all the downloaded patch files (eg. xxxx.zip) into the newly created folder (eg. "updates").

17. At the CLI --> esxcli software vib update -d /vmfs/volumes/datastore1/updates/xxxx.zip

18. Check the status of the updates (at top of the message), if status is "Successful" then proceed to "Reboot" the Host server.

19. Once rebooted, proceed to update the rest of the updates and each updates must be rebooted for it complete.

20. Upon reaching "Update 1", you may need to run a dependency check --> esxcli software profile update -d https://hostupdate.vmware.com/software/VUM/PRODUCTION/main/vmw-depot-index.xml -p ESXi-6.7.0-20181002001-standard

20.1 If you encountered any error, try this step to check the profile available --> esxcli software sources profile list -d /vmfs/volumes/datastore1/updates/update-from-esxi6.7-6.7_update01.zip

20.2 Then take note of the available profile (eg. ESXi-6.7.0-20181002001-standard).

20.3 Type this CLI --> esxcli software profile update -p ESXi-6.7.0-20181002001-standard -d /vmfs/volumes/datastore1/updates/update-from-esxi6.7-6.7_update01.zip

21. Once complete, reboot the Host server again.

22. Double check whether "Update 1" was successfully update.

23. At the CLI --> esxcli network firewall ruleset set -e false -r httpClient

24. Reboot the Host server again.

25. If everything is OK, proceed to "Exit Maintenance Mode" and power-on the VMs.


!!! HAPPY COMPUTING !!!

20-Dec-2022, Note: Added Steps #20.1, 20.2 & 20.3


Nov 14, 2022

Windows 10 : Internet Explorer Always Open Edge

 How to disable Edge from opening Internet Explorer (IE) sites.

  1. Open Edge browser --> Settings.
  2. At right-column panel --> Default Browser.
  3. Under section --> Internet Explorer Compatibility.
  4. Option --> Let Internet Explorer open sites in Microsoft Edge = NEVER.
  5. Close Edge and open IE, it will work now.
!!! HAPPY COMPUTING !!!

Oct 27, 2022

Cockpit Project : Installation in Ubuntu

 Cockpit Project is an Open Source software developed as a WebUI for Linux OS, currently supported multiple Linux OS such as Debian, Ubuntu, Red Hat, CentOS, Fedora, ArchLinux and many more.

Installation of Cockpit is relatively simple as the application was already bundled inside most OS Repository.

1. sudo apt install cockpit -y

2. At another computer, open browser --> https://[IP Address or Domain Name]:9090

3. The login credentials is the same account you login to the server.

More information is available at https://cockpit-project.org/


Edit, 4-Apr-2023: Added How To Video.





!!! HAPPY COMPUTING !!!


Snipe-IT : Installation in Ubuntu Server

Snipe-IT is an Open Source Asset Management software that are specifically designed for IT. The software is a web-based system thus easy-to-use and accessible anywhere. Say Good-Bye to messy and lengthy Excel file.

Depending on the access, most corporate only allow access within the corporate network. If access is allow externally, ensure that you configure SSL for the access.


1. Install Ubuntu Server v.22.04.1 64-bit, follow the on-screen instructions on installing the OS.

2. sudo apt update && sudo apt upgrade -y

3. sudo apt install wget git -y

4. sudo timedatectl set-timezone Asia/Kuala_Lumpur

5. sudo wget https://raw.githubusercontent.com/snipe/snipe-it/master/install.sh

6. sudo chmod 744 install.sh

7. sudo ./install.sh

8. Follow on-screen instructions in setting up the Apache2, MariaDB & PHP.

9. sudo chown -R www-data:www-data /var/www/html/snipeit

10. sudo chmod -R 755 /var/www/html/snipeit

11. sudo reboot

12. At another computer, open browser and point the Snipe-IT server IP Address or hostname (depending on how you setup the server).

13. Follow on-screen instructions in setting up the first Administrator account.





!!! HAPPY COMPUTING !!!


Sep 8, 2022

Adobe Reader : Incorrect Printer Selection

 Recently encountered a weird problems with Adobe Reader, any opened PDF file when wanted to print...

Either the list of available printer is not available or some list of printer is listed but not the one you wanted select...

Also when checking Control Panel --> Devices and Printers, the said printer is correctly installed but was not able to make it as default printer, error message displayed "Adobe Error 0x00000709, Cannot set default printer....."

1) Open regedit.exe --> HKEY_CURRENT_USER\Software\Microsoft\WindowsNT\CurrentVersion\Windows

2) Right-Click --> Windows --> Select --> Permissions --> Select --> Full Control.

3) Right-Click --> Device --> Select --> Modify --> [Printer's Name].

4) Restart Computer.


!!! HAPPY COMPUTING !!!


Aug 27, 2022

Zabbix Server : Installation (Part 1)

 Zabbix Monitoring Server is an Open Source software suitable for Personal and Commercial use. This installation guide is based on Ubuntu Server v.22.04 LTS 64-bit thus I will not be going thru the OS installation steps but will highlight some important steps prior to installing Zabbix.

As of writing the current Zabbix Server v.6.2, more information is available at (https://www.zabbix.com/)

After completed installing Ubuntu Server, you will need to do the following :-

1. sudo timedatectl set-timezone Asia/Kuala_Lumpur

2. sudo apt update && sudo apt upgrade -y

3. sudo apt install nano net-tools wget git -y

4. sudo apt install mysql-server php apache2 -y

5. sudo reboot

6. sudo apt install php-gd php-bcmath php-ctype php-xml php-xmlreader php-xmlwriter php-net-socket php-mbstring php-ldap -y

7. sudo apt install php-session -y

8. sudo apt install php-gettext -y

9. sudo reboot

10. sudo apt update

11. sudo wget https://repo.zabbix.com/zabbix/6.2/ubuntu/pool/main/z/zabbix-release/zabbix-release_6.2+ubuntu22.04_all.deb

12. sudo dpkg -i zabbix-release_6.2+ubuntu22.04_all.deb

13. sudo apt update

14. sudo apt install zabbix-server-mysql zabbix-frontend-php zabbix-apache-conf zabbix-sql-scripts zabbix-agent

15. sudo reboot

16. sudo mysql -uroot -p    (key-in 'password' when prompted)

17. Under MYSQL prompt :-

  • create database zabbix character set utf8mb4 collate utf8mb4_bin;
  • create user zabbix@localhost identified by 'password';
  • grant all privileges on zabbix.* to zabbix@localhost;
  • set global log_bin_trust_function_creators = 1;
  • quit;
18. sudo zcat /usr/share/doc/zabbix-sql-scripts/mysql/server.sql.gz | mysql -uzabbix -p zabbix        (key-in 'password' when prompted)

19. sudo mysql -uroot -p        (key-in 'password' when prompted)

20. Under MYSQL prompt :-

  • set global log_bin_trust_function_creators = 0;
  • quit;
21. sudo nano /etc/zabbix/zabbix_server.conf
  • DBPassword=password
22. sudo systemctl restart zabbix-server zabbix-agent apache2

23. sudo systemctl enable zabbix-server zabbix-agent apache2

24. sudo reboot

25. At another computer, open browser --> http://[Zabbix's IP Address]/zabbix
  • DB Type = MySQL
  • DB Name = zabbix
  • DB User = zabbix
  • DB Password = password
  • Zabbix Server Name = [Any Name]
  • Time Zone = (UTF+08:00) Asia/Kuala_Lumpur
26. Default Zabbix Login :-
  • Username = Admin          (case sensitive)
  • Password = zabbix          (case sensitive)

!!! HAPPY COMPUTING !!!

Aug 17, 2022

LUBUNTU : Command Line

 LUBUNTU v.20.04.1 64-bit : Command Line

1. sudo apt update

2. sudo apt upgrade -y

3. sudo wget https://dl.google.com/linux/direct/google-chrome-stable_current_amd64.deb

4. sudo dpkg -i ~/downloads/google-chrome-stable_current_amd64.deb

5. sudo apt install fonts-liberation


Jun 30, 2022

Acer TravelMate P214-53 : Unable to detect NVMe Drive.

 Acer TravelMate P214-53 : Unable to detect NVMe Drive.

  1. Press --> F2 key to enter into BIOS.
  2. Goto --> Security tab --> Supervisor Password --> Enter a temporary password (eg. 1234)
  3. Disabled Secure Boot.
  4. Then --> Save & Exit.
  5. After restart, enter back into BIOS again and CLEAR the Supervisor Password but leave the Secure Boot option Disabled.
  6. Save & Exit.
  7. Download --> Intel RST for VMD Drivers --> Intel Download Center.
  8. Unzip drivers into USB Flash Drive.
  9. Boot Windows 10 installer as usual, you will not able to see any HDD/SSD detected.
  10. Click --> Load --> Browse --> Select --> Intel RST VMD folder.
  11. After load completed, you can now see the NVMe drive is detected.
  12. Proceed to format and install Windows 10 accordingly.
Special Note :
Sometimes the Intel RST Drivers although was loaded and able to detect the NVMe drive successfully, but Windows installer will prompt error message "0x80300001", just proceed to restart the computer again and boot into Windows install as usual and re-load the drivers again.

Apr 29, 2022

Zabbix : Install Zabbix-Agent in CentOS

 1. sudo rpm -Uvh https://repo.zabbix.com/zabbix/6.0/rhel/7/x86_64/zabbix-agent-6.0.3-1.el17.x86_64.rpm

* Check for latest version in https://repo.zabbix.com/zabbix.

2. sudo yum update

3. sudo yum install zabbix-agent -y

4. sudo nano /etc/zabbix/zabbix-agentd.conf

        --> Server = [Zabbix Server IP Address]

        --> Hostname = [CentOS hostname]

5. sudo iptables -A INPUT -p tcp -s [Zabbix server IP address] --dport 10050 -m state --state NEW,ESTABLISEHD -j ACCEPT

* If "firewalld" was install, add port 10050 into exception list.

6. sudo systemctl restart zabbix-agent

7. sudo systemctl enable zabbix-agent

8. sudo systemctl status zabbix-agent

9. Continue to add client host into Zabbix server via browser, select --> CentOS with Zabbix Agent


Zabbix : Install Zabbix-Agent in Ubuntu

 1. sudo wget https://repo.zabbix.com/zabbix/6.0/ubuntu/pool/main/z/zabbix-release/zabbix-release_6.0-1+ubuntu20.04_all.deb

* Visit https://repo.zabbix.com/zabbix for latest version.


2. sudo dpkg -i zabbix-release_6.0-1+ubuntu20.04_all.deb

3. sudo apt-get update

4. sudo apt-get install zabbix-agent -y

5. sudo nano /etc/zabbix/zabbix-agentd.conf

        --> Server = [Zabbix Server IP Address]

        --> ServerActive = [Zabbix Server IP Address]

        --> Hostname = [Ubuntu Client Hostname]


6. sudo systemctl restart zabbix-agent

7. sudo systemctl enable zabbix-agent

8. sudo systemctl status zabbix-agent

9. sudo ufw allow 10050/tcp          * check status --> sudo ufw status

OR --> sudo iptables -A INPUT -p tcp -s [Zabbix server IP address] --dport 10050 -m state --state NEW,ESTABLISEHD -j ACCEPT

* Some firewall may block or NAT the address, thus instead of using the Zabbix server IP address, use the firewall IP address.


10. Use another PC to browse the zabbix server (eg. http://[Zabbix Server IP Address]/zabbix) and login using your admin's credentials.

11. Continue to add the client into the monitoring --> Configuration --> Hosts --> Create Host

        --> Add --> Agent --> Linux with Zabbix Agent


Apr 27, 2022

Batch - IF Calculation

 Batch File Command "IF"

  • EQU = Equal to...
  • NEQ = Not Equal to...
  • LSS = Less than...
  • LEQ = Less than or Equal to...
  • GTR = Greater than...
  • GEQ = Greater than or Equal to...
Example :-

IF %INPUT% EQU 100 ECHO "EQUAL VALUE"
IF %INPUT% GEQ 100 ECHO "VALUE IS GREATER THAN OR EQUAL TO 100"