Bypass the PowerShell Execution Policy

  • Use the “Bypass” Execution Policy Flag
This is a nice flag added by Microsoft that will bypass the execution policy when you’re executing scripts from a file. When this flag is used Microsoft states that “Nothing is blocked and there are no warnings or prompts”. This technique does not result in a configuration change or require writing to disk.
PowerShell.exe -ExecutionPolicy Bypass -File .runme.ps1
  • Use the “Unrestricted” Execution Policy Flag
This similar to the “Bypass” flag. However, when this flag is used Microsoft states that it “Loads all configuration files and runs all scripts. If you run an unsigned script that was downloaded from the Internet, you are prompted for permission before it runs.” This technique does not result in a configuration change or require writing to disk.
PowerShell.exe -ExecutionPolicy UnRestricted -File .runme.ps1
  • Use the “Remote-Signed” Execution Policy Flag
Create your script then follow the tutorial written by Carlos Perez to sign it. Finally,run it using the command below:
PowerShell.exe -ExecutionPolicy Remote-signed -File .runme.ps1

Transfer email accounts and messages between cPanel servers

You can transfer the email accounts and messages for a particular domain, from one cPanel server to another, by following the steps below.
 
Let's call the domain yourdomain.com for example. Make sure that you have yourdomain.com added as Parked or Addon in cPanel at the destination server.
 
Transferring the email accounts
Open your preferred FTP client, connect to the hosting account where the email accounts/messages currently are and navigate to the etc/ folder (located under /home/cpaneluser/etc/). There you will see a folder named yourdomain.com (the name of the domain you want to transfer the accounts/messages for). Download this folder anywhere to your local computer. This folder contains the email addresses (server configuration setup, encrypted passwords, etc.) associated with the corresponding domain.
 
Now connect with your FTP client to the server where you want to transfer the accounts. Navigate again to the etc/ folder and upload the previously downloaded yourdomain.com folder.
 
With this, the transfer of the email accounts is completed.
 
Before proceeding with the messages transfer you should remove or rename the downloaded yourdomain.com directory on your local computer.
 
Transferring the email messages
Simply repeat the process from step 1. This time, however, you should navigate to the mail/ folder (located under /home/cpaneluser/mail/). Download the directory called yourdomain.com to your local computer. This directory contains the messages for yourdomain.com. After that connect to the other account where you want to transfer the messages and upload the folder yourdomain.com to the mail/ directory.
 
With this, the transfer of your email accounts and messages is completed.
 
Now you can access cPanel -> Email accounts of the destination hosting account and check your transferred emails.
 
Your DNS provider will be able to assist you with the MX record changes, so you can point the mail-flow for yourdomain.com to the new hosting server.
 

Coloured equation in Impress

There is a color statement in Math that can be combined with a limited palette (RGB+CMYK+white) to set the hue of elements.
 
The basic form is:
 
color <keyword> { math element }
 
Valid <keyword> entries appear to be: red, green, blue, cyan, magenta, yellow, black, white. For example:
 
color red {sum from{color magenta {i=1}} to{color cyan{100}} color blue {i.}}
 

Disable APIPA (Automatic Private IP Addressing)

APIPA (Automatic Private IP Addressing) – Mechanism in a small network that clients will automatically allocated themselves an IP address in the range of 169.254.x.x if no DHCP server can be contacted.

 

It may be desirable to disable this and to do this perform the following:

 
  1. Start the registry editor (Regedit.exe)
  2. Move to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\Interfaces
  3. Select the required interface
  4. From the Edit menu select New – DWORD value
  5. Enter a name of IPAutoconfigurationEnabled and press Enter
  6. Double click the new value and set to 0. Click OK
  7. Close the registry editor

 

If you have multiple adapters and wish to disable for all just create and set HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\IPAutoconfigurationEnabled to 0.
 

Unprotect/Remove Excel Password

  1. Change the extension of you Excel file from .xlsx to .zip
  2. Extract these XML files outside the folder,they represent the worksheets in the Excel file.
    1. Location: xl -> worksheets -> *.xml
  3. Modified codes using simple “Notepad”.
    1. Open XML File & Delete  Excel v. 2007-10 “sheetProtection password=… />” v. 2013 – “sheetProtection algorithmName=…/>”
  4. Save & Close Xml File
  5. The modified XML file should be put again in the zipped file to replace the old XML files.
  6. Run File
 
 
 

VLC for openSUSE

VLC VideoLan client
VLC Repositories for openSUSE contains all the required libraries that are not shipped with original openSUSE. (VLC is also provided by Packman, do not add both repositories.)
 
Version: Tumbleweed http://download.videolan.org/pub/vlc/SuSE/Tumbleweed/
 
Version: Leap 15.0 http://download.videolan.org/pub/vlc/SuSE/Leap_15.0/
 
 
zypper dup:
 
After adding VLC repository be sure to switch system package to those in VLC as a mix of both can cause a variety of issues.
 
Version: both zypper dup –from SuSE –allow-vendor-change

 

Credits: https://en.opensuse.org/Additional_package_repositories#VLC_VideoLan_client

System file check to look for corrupt files.

Right click at Start button > click Command Prompt (Admin) > at the flashing prompt, copy/paste this…….
sfc /scannow

> press Enter.
It will take quite sometime.
When finished, it will give you one of the 3 reports……………(paraphrasing)
1. No integrity violation.
2. Found corrupt files and repair successful.
3. Found corrupt files but unable to repair.

If the report is #1, your solution lies elsewhere.
If the report is #2, check if your problems have been resolved.
If the report is #3, use this method…………….
In the same Command Prompt (Admin) windows, copy and paste this command………..

dism /online /cleanup-image /restorehealth

> press Enter.
Again it will take some time.

 

Credits

Why don’t I have the option to “continue to website (not reccomended)” when I encounter a website with a certificate error IE?

If you are launching from a pinned site or desktop shortcut you don't get the option to continue.  

Around that by creating a shortcut to IE on the desktop with 'run as administrator' privileges and passing the website in the command line. 

Like "C:\Program Files\Internet Explorer\iexplore.exe" https:\\192.168.0.1

 

Credits