SharePoint Stuff

Azure MySQL In App Manager – Increase Import Size

Written by Luke Smith. Posted in Microsoft

When importing a database using phpmyadmin via the Azure App Service MySQL In App Manage you find the Import Maximum size is set to 8,192KiB (Max:8,192KiB).

To increase the php upload size please run through the following steps:

In the Azure Portal, select your App Service
Navigate to Configuration
Select Application Settings
Click New Application settings

Value = D:\home\site\ini

Click Save

Then Under Development Tools select Advanced Toolees (KUDU) or navigate to

From the menu select Debug Console\CMD

Go to site directory and press the “+” button and create an “ini” directory.
In the ini directory, create an “extensions.ini” file.
Press the edit button next to the file.
Add the following to the file and save. This will modify the Master values.
Go to the wwwroot directory and create a “.user.ini” file.
Edit the file and add the same values as mentioned in step 7 above. This will modify the Local values.
Restart the site using the Azure Portal.
PHPMyAdmin Import page will also reflect the changes.

Office 365 DLP Acction Encrypt email messages Missing

Written by admin. Posted in Microsoft


When you create an Office 365 Data Loss Protection (DLP) Policy the Action to “Encrypt email messages (applies only to content in Exchange)” is missing.


Exchange Online Azure AD Rights Management needs to be eneabled.

Download the Exchange Online PowerShell from:

(Get-AadrmConfiguration).LicensingIntranetDistributionPointUrl -match “https:\/\/[0-9A-Za-z\.-]*” | Out-Null; $matches[0]

#Copy URL into $list below
$irmConfig = Get-IRMConfiguration
$list = $irmConfig.LicensingLocation
$list += ““
Set-IRMConfiguration -LicensingLocation $list
Set-IRMConfiguration -internallicensingenabled $true

Lansweeper Windows Firewall Requriements

Written by Luke Smith. Posted in Uncategorized

The following rules need to be in place for lansweeper to run:


netsh advfirewall firewall add rule name=”ICMP Allow incoming V4 echo request” protocol=”icmpv4:8,any” dir=in action=allow

netsh firewall set service RemoteAdmin enable

netsh firewall add portopening protocol=tcp port=135 name=DCOM_TCP135