SharePoint Stuff



Author Archive

Luke Smith

I’ve been working with Microsoft Technologies for over 20 years, my main focus now being Microsoft Online Services. I manage the Cloud Services at ElysianIT Limited and as a P-SELLER at Microsoft. I have worked with many organisations from SMC to Enterprise. I’ve been working with Microsoft Technologies since DOS 5.0, to date I have been working on Microsoft’s latest cloud technology Windows Azure, Windows 10 Office 365 and Microsoft SharePoint

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

Name = PHP_INI_SCAN_DIR
Value = D:\home\site\ini

Click Save

Then Under Development Tools select Advanced Toolees (KUDU) or navigate to https://.scm.azurewebsites.net

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.
upload_max_filesize=30M
post_max_size=30M
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.

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

Azure Gateway – Point-to-Site Windows VPN Client – Error processing ID payload

Written by Luke Smith. Posted in Uncategorized

Issue

You have configured a Point-to-Site VPN on the Azure Gateway

The Azure Gateway also has Site-to-Site Connections using BGP or Static Routes

The Point-to-Site is configured for SSTP and IKEv2

You configure the VPN and notice that only SSTP is used and when trying to manually set IKEv2 the client fails with the following error:

“Error processing ID payload”

Resolution 1

First check how many routes are being published on the VPN

  1. Select an Azure VM > Select Network > Select Network Card > Select Effective Routes
  2. Count the number of Routes

If you have more than 25 routes (published on the VPN) you will need to limit the routes by summarizing them below 25 routes.

The Windows VPN Client built into Windows 10 (1607 and above) doesn’t support more than 25 routes hence they this fails.

If you are not able to limit these routes you will need to Use SSTP

NB: SSTP only allows 128 concurrent connection

Resolution 2

If you are running Windows 10 builds 1607-1709 update to the latest windows 10 build or apply the following changes\fixes:

Install the update.

OS version

Date

Number/Link

Windows Server 2016

Windows 10 Version 1607

January 17, 2018

KB4057142

Windows 10 Version 1703

January 17, 2018

KB4057144

Windows 10 Version 1709

March 22, 2018

KB4089848

Set the registry key value. Create or set “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\RasMan\ IKEv2\DisableCertReqPayload” REG_DWORD key in the registry to 1.

Resolution 3

If you are running Windows 10 builds below 1607 you will need to update to the latest windows 10 build