Monday, August 15, 2022

Fix Adding new SSL virtual website .. .. certificate authority file is not valid : Data does not start with line -----BEGIN CERTIFICATE-- in virtualmin


Open the file at /etc/webmin/virtual-server/domains/13694005276497

Delete including 4 lines pointing to the 4 certificate files: ssl.cert, ssl.combined, ssl.everything & ssl.key

Then re-add the ssl.

Friday, August 12, 2022

How to generate SSH keys in Windows PowerShell

 Open your PowerShell and follow the steps:

ssh

ssh-keygen -b 4096


C:\Users\WINUSER/.ssh/id_rsa.pub


notepad C:\Users\WINUSER/.ssh/id_rsa.pub

Wednesday, August 10, 2022

How to check TCP, UDP Domain Socket using NetCat

 Install the netcat Using the fllowing command:

$ yum install nc      [On CentOS/RHEL]

$ dnf install nc      [On Fedora 22+ and RHEL 8]

$ sudo apt-get install Netcat      [On Debian/Ubuntu]


NetCat commands:

$ nc -v -w 2 z 192.168.56.1 22     #scan a single port

OR

$ nc -v -w 2 z 192.168.56.1 22 80  #scan multiple ports

OR

$ nc -v -w 2 z 192.168.56.1 20-25  #scan range of ports

Saturday, August 6, 2022

How to hide IP in header from Postal MTA

Remove  text where need using the following file in postalMTA.

For SMTP Server:

lib/postal/smtp_server/client.rb

@receiving_headers = true
received_header_content = "from #{@helo_name} (#{@hostname} [#{@ip_address}]) by #{Postal.config.dns.smtp_server_hostname} with SMTP;

For HTTP:

app/models/outgoing_message_prototype.rb

mail.header['Received'] = "from #{@source_type} (#{self.resolved_hostname} [#{@ip}]) by Postal with HTTP; #{Time.now.utc.rfc2822.to_s}"
mail.message_id = "<#{@message_id}>"

How to view saved password in Outlook 2003, 2007, 2010, 2013, 2016, 2019


Use Unmask Password Tool to reveal hidden behind the asterisk icon.

Windows:

Download from Google Drive

Download from CNET



Mac:


To see if the password is available, first open the “Keychain Access” program on your Mac (click the Go menu in the Finder and choose Applications, then open Utilities and Keychain Access).

Thursday, August 4, 2022

Office 2019 Activation without Product Key using CMD

Put the following code in a TXT file and save as "file.cmd" then run the cmd file as administrator. 

@echo off

title Activate Microsoft Office 2019 ALL versions for FREE!&cls&echo ============================================================================&echo #Project: Activating Microsoft software products for FREE without software&echo ============================================================================&echo.&echo #Supported products:&echo - Microsoft Office Standard 2019&echo - Microsoft Office Professional Plus 2019&echo.&echo.&(if exist "%ProgramFiles%\Microsoft Office\Office16\ospp.vbs" cd /d "%ProgramFiles%\Microsoft Office\Office16")&(if exist "%ProgramFiles(x86)%\Microsoft Office\Office16\ospp.vbs" cd /d "%ProgramFiles(x86)%\Microsoft Office\Office16")&(for /f %%x in ('dir /b ..\root\Licenses16\ProPlus2019VL*.xrm-ms') do cscript ospp.vbs /inslic:"..\root\Licenses16\%%x" >nul)&(for /f %%x in ('dir /b ..\root\Licenses16\ProPlus2019VL*.xrm-ms') do cscript ospp.vbs /inslic:"..\root\Licenses16\%%x" >nul)&echo.&echo ============================================================================&echo Activating your Office...&cscript //nologo ospp.vbs /unpkey:6MWKP >nul&cscript //nologo ospp.vbs /inpkey:NMMKJ-6RK4F-KMJVX-8D9MJ-6MWKP >nul&set i=1

:server

if %i%==1 set KMS_Sev=kms7.MSGuides.com

if %i%==2 set KMS_Sev=kms8.MSGuides.com

if %i%==3 set KMS_Sev=kms9.MSGuides.com

if %i%==4 goto notsupported

cscript //nologo ospp.vbs /sethst:%KMS_Sev% >nul&echo ============================================================================&echo.&echo.

cscript //nologo ospp.vbs /act | find /i "successful" && (echo.&echo ============================================================================&echo.&echo #My official blog: MSGuides.com&echo.&echo #How it works: bit.ly/kms-server&echo.&echo #Please feel free to contact me at msguides.com@gmail.com if you have any questions or concerns.&echo.&echo #Please consider supporting this project: donate.msguides.com&echo #Your support is helping me keep my servers running everyday!&echo.&echo ============================================================================&choice /n /c YN /m "Would you like to visit my blog [Y,N]?" & if errorlevel 2 exit) || (echo The connection to my KMS server failed! Trying to connect to another one... & echo Please wait... & echo. & echo. & set /a i+=1 & goto server)

explorer "http://MSGuides.com"&goto halt

:notsupported

echo.&echo ============================================================================&echo Sorry! Your version is not supported.&echo Please try installing the latest version here: bit.ly/aiomsp

:halt

pause >nul

Thursday, June 16, 2022

How to Install Desktop(GUI) on CentOS 7

 Step 1: Prerequisites


a) You should have a running RHEL/CentOS 7 System.

b) You should have sudo or root access to run privileged commands.

c) You should have yum utility available in your System.
Step 2: Update Your Server

Before installing a new package, it is always a good idea to update the System with the latest available versions using yum update command as shown below. If any of the packages needs upgradation then upgrade it by using yum upgrade command.

Step 3: Check Package Groups

You can check all the available package groups by using yum grouplist or yum group list command. As you can see from the below output, we need to basically install GNOME Desktop and Graphical Administration Tools package groups.
Step 4: Install GNOME Desktop(GUI)

To install GNOME Desktop and Graphical Administration Tools package groups, you need to use either yum groupinstall "GNOME Desktop" "Graphical Administration Tools" or yum group install "GNOME Desktop" "Graphical Administration Tools" command as shown below.
Step 5: Enable GUI

After successful installation of GNOME Desktop environment, you need to enable and make the graphical mode as default. This can be done by using systemctl set-default graphical command as shown below.
Step 6: Reboot Server

Finally reboot the Server using reboot command to start the Graphical mode.
Step 7: Setup GNOME Desktop(GUI)

After reboot, you should be able to see the GNOME Desktop environment like below.

Once you logged in, you should be able to see the below Window to select your language. By default, English will be selected so I will leave it as it is and Click on Next.

In the next step, you need to setup your Keyboard layout. By default, it will be selected as English(US) so I will leave as it is and Click on Next. You are free to choose any Keyboard layout here based on your preference.

In the next window, you will see an option to turn Location Services ON or OFF. Turning ON will allow applications to determine your geographical location. By default, it will selected as ON so for the moment I will leave as it is and Click on Next. If you don't want to any application to see your geographical location then you can switch OFF your Location Services.

In the next windows, you will be asked to connect your accounts to easily access your email, online calendar, contacts, documents and photos. You can either connect it or skip for the moment. I am choosing to skip this as of now so I will click on Skip.

This concludes your setup and now you are ready to use your System. To finish the setup Click on Start Using CentOS Linux.

This will bring you to the Server Desktop where you can start using your System as shown below.
Step 8: Uninstall GNOME Desktop(GUI)

In case, you decide not to use GNOME Desktop anymore then you can uninstall it by using yum groupremove "GNOME Desktop" "Graphical Administration Tools" or yum group remove "GNOME Desktop" "Graphical Administration Tools" command as shown below.

How to get Ranking of the Students in Excel using RANK Function

=RANK(number,ref,[order]) To rank in descending order, we will use the formula =RANK(B2,($C$5:$C$10),0) If we want unique ranks, we can use...