SharePoint Archives - Sathiya's Blog

Remove Blacklist Domain SPAMRATS

RATS Dyna block list is common to avoid Trojan and bots sending mail to recipients. SPAMRATS detect unhealthy and invalid rDNS records entries in server. Remove Blacklist from span filter domain, add PTR record in DNS server. In case of on-perm outgoing mail apparently get the IP from ISP.

In my scenario, mail service has hosted in O365 and multiple web application pointing to same IP. Due to this RATS Dyna marked as blacklist http://www.spamrats.com/bl?[xx.xx.xx.xx]. Whereas domain purchased in GoDaddy.com service provider. rDNS supposed to be added in service provider end refer https://in.godaddy.com/help/add-my-own-host-names-as-nameservers-12320 where we could archive and fix an issues.

Adding ‘Host name’ under advanced feature to fix rDNS issues. Here added ‘mail.sathiya.io’ to 10.xx.xx.xx; Make sure to validate an entry with mxtoolbox.com or dnschecker.org

February 25, 2020

Unexpectedly deleted search index entries

SharePoint 2019 security CVE-2019-1330 patch has been released in October’19. The patch causing search indexes the crawl of content that has many links fails because of the maximum allowable links exceeds. So multiple fails, the search index entries for the content are deleted unexpectedly.

So ContentPIMaxNumLinks properties should be updated accordingly with below SharePoint 2019 Management shell script;

$ssa = Get-SPEnterpriseSearchServiceApplication
$ssa.SetProperty(“ContentPIMaxNumLinks”, 10000)
$ssa.Update()

1

2

3

$ssa = Get–SPEnterpriseSearchServiceApplication

$ssa.SetProperty(“ContentPIMaxNumLinks”, 10000)

$ssa.Update()

Check out historical security and cumulative updates more in!

October 19, 2019

SharePoint Server 2019 Public Preview

As expected Microsoft introduced SharePoint server 2019 product in May 2018 SharePoint conference. The product has more refined feature in terms of user experience, development stuff, security concerns and scalable with Hybrid collaboration environments

Now, public preview available to experience the complete features of next milestone.

SharePoint Server 2019 Public Preview

Product	Build Number	Package Name	Download/Release CU	Release Date
SharePiont 2019	16.0.10711.37301	Public preview	Download	2018 July 24

Features

Find the major noticeable features;

Modern user experience based on online product
Content across browser and devices
Robust scalability, security and compliance capabilities

Previous production has a limitation in larger file, character restrictions, files/folder names those are improved in 2019

File can be upload upto 15GB
URL length has been Increases from 260 Unicode code units to 400.

Tip: SharePoint 2019 complete features, checkout white paper.

Cheers!

September 8, 2018

Clear SharePoint 2013 Config Cache

SharePoint 2013 Config Cache fix mostly unstable service or applications, try with cache clear script as troubleshoot them in farm level. Here the scripts makes perfect with dynamic values of GUI ID and other parameters.

Standalone farm clean can be done manually but if its multi-tier farm would time conservation so better do with powerful tool. Tweak with below dynamic script that not require any additional changes.

<#
.DESCRIPTION
    Clear SharePoint Config Cache with dynamic values
.NOTES
    Author: Sathiya.io
#>
if((Get-PSSnapin | Where {$_.Name -eq “Microsoft.SharePoint.PowerShell”}) -eq $null) {
    Add-PSSnapin Microsoft.SharePoint.PowerShell;
}
 
function Man-Main {
    try {
        $cacheFolder = $null
        $items = $null
        $item = $null
        $a = $null
        $cacheFolderName = (Get-ItemProperty -Path “HKLM:SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\15.0\Secure\ConfigDB”).id
        if($cacheFolderName -ne $null) {
            Stop-Service SPTimerV4
            $cacheFolder = “$env:ProgramData\Microsoft\SharePoint\Config\$cacheFolderName”
            $items = Get-ChildItem $cacheFolder
            foreach ($item in $items)
            {
                if ($item.Extension -eq “.xml”)
                {
                   $item.Delete()
                    #Write-Host $item.name “file has been deleted”
                }
            }
            $a = Get-Content $cacheFolder\cache.ini
            $a  = 1
            Set-Content $a -Path $cacheFolder\cache.ini
            Write-Host “Cache files are deleted successfully” -ForegroundColor Gray -BackgroundColor Green
            Start-Service SPTimerV4
        }
        else {
            return [System.String](“[WARNING]:No SharePoint instance found in the server”)
        }
    }
    catch {
        Write-Output “Error clearing SharePoint cache”
    }
}
Man-Main

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

<#

.DESCRIPTION

Clear SharePoint Config Cache with dynamic values

.NOTES

Author: Sathiya.io

#>

if((Get–PSSnapin | Where {$_.Name –eq “Microsoft.SharePoint.PowerShell”}) –eq $null) {

Add–PSSnapin Microsoft.SharePoint.PowerShell;

}

function Man–Main {

try {

$cacheFolder = $null

$items = $null

$item = $null

$a = $null

$cacheFolderName = (Get–ItemProperty –Path “HKLM:SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\15.0\Secure\ConfigDB”).id

if($cacheFolderName –ne $null) {

Stop–Service SPTimerV4

$cacheFolder = “$env:ProgramData\Microsoft\SharePoint\Config\$cacheFolderName”

$items = Get–ChildItem $cacheFolder

foreach ($item in $items)

{

if ($item.Extension –eq “.xml”)

{

$item.Delete()

#Write-Host $item.name “file has been deleted”

}

$a = Get–Content $cacheFolder\cache.ini

$a = 1

Set–Content $a –Path $cacheFolder\cache.ini

Write–Host “Cache files are deleted successfully” –ForegroundColor Gray –BackgroundColor Green

Start–Service SPTimerV4

}

else {

return [System.String](“[WARNING]:No SharePoint instance found in the server”)

}

catch {

Write–Output “Error clearing SharePoint cache”

}

Man–Main

Cheers!

July 1, 2018

SharePoint crawling not working with non-default zone (public facing site)

Its been very long time to back in here to share the work around fixes. I have been configured public facing branding site in SharePoint 2013 multi tier environment.

Servers in the farm

SPAPP-V01
SPAPP-V02
SPWFE-V01
SPWFE-V02
SPSQL-AG (Availability group listener)
SPSQL-V01
SPSQL-V02
SPSQL-V03

Web application has been extended to Internet zone, which is exposed in public via F5, SSL configured on IIS.

AAM looks like

http://SPAPP-V01:8080 Default http://SPAPP-V01:8080
https://www.sathiya.io Internet https://www.sathiya.io
http://www.sathiya.io Internet https://www.sathiya.io
http://sathiya.io Internet https://www.sathiya.io
https://sathiya.io Internet https://www.sathiya.io

SharePoint search was configured with below topology;
SPAPP-V01 : Admin, Crawler, Content Processing, Analytics Processing & Index Partition
SPAPP-V02 : Admin, Crawler, Content Processing, Analytics Processing & Index Partition
SPWFE-V01 : Query Processing
SPWFE-V02 : Query Processing (more…)

April 30, 2017

Simple HTML Maintenance Page

We everyone are looking for very simple HTML and classy site maintenance page for hosting. Nowhere we go.

html maintenance page snippet

<!doctype html>
<title>Site Maintenance!</title>
<style>
  body { text-align: center; padding: 150px; }
  h1 { font-size: 50px; }
  body { font: 20px Helvetica, sans-serif; color: #333; }
  article { display: block; text-align: left; width: 650px; margin: 0 auto; }
  a { color: #dc8100; text-decoration: none; }
  a:hover { color: #333; text-decoration: none; }
</style>

<article>
    <h1>We&rsquo;ll be back soon!</h1>
    <div>
        <p>Sorry for the inconvenience but we&rsquo;re performing some maintenance at the moment. Please feel free to <a href=”mailto:contact@sathiya.io”>contact us</a>, otherwise we&rsquo;ll be back online shortly!</p>
        <p>&mdash; IT Admin <a href=”http://sathiya.io” target=”_new”>Sathiya.io</a></p>
    </div>
</article>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

<!doctype html>

<title>Site Maintenance!</title>

<style>

body { text-align: center; padding: 150px; }

h1 { font-size: 50px; }

body { font: 20px Helvetica, sans-serif; color: #333; }

article { display: block; text-align: left; width: 650px; margin: 0 auto; }

a { color: #dc8100; text-decoration: none; }

a:hover { color: #333; text-decoration: none; }

</style>

<div>

<p>Sorry for the inconvenience but we’re performing some maintenance at the moment. Please feel free to <a href=“mailto:contact@sathiya.io”>contact us</a>, otherwise we’ll be back online shortly!</p>

<p>— IT Admin <a href=“http://sathiya.io” target=“_new”>Sathiya.io</a></p>

</div>

</article>

Cheers…!

April 6, 2016

Apps Configuration for SharePoint 2013

SharePoint apps feature has been looks great in your site. Here the simple steps to configure an apps and few tweaks to ride it.

Before you jump into the configuration check bellow points;Configuration the domain names in DNS

Create dedicated forward lookup zone for SharePoint apps
- On DNS server, click Start to navigate Administrator Tools and open DNS (or) goto run dnsmgmt.msc
- In DNS manager, right click Forward Lookup Zones and click New Zone
- In the wizard, click Next
- In the Zone Type windows, accept the default of Primary Zone then click Next
- In the Active Directory Zone Replication Scope page, select the appropriate replication method for your environment
- In Zone Name, enter your app domain name which will be used for SharePoint apps
- On the Dynamic Updates windows, select the appropriate types which is apt for you environment
- Click finish to complete the zone creation
Create a wildcard Alias (CNAME) for access an apps
- In DNS manager, click newly created zone and add New Alias to point to the SharePoint server
- In the New Resource Record windows, enter the Alias name as Wildcard entry (*)
- Next you have to select the fully qualified domain name (FQDN) for target host
- Click Ok to finish the steps
To verify the new domain name
- Go to command prompt
- From the command prompt you can enter wildcard sub domain host like ping app-ABCDEF12345.sathiyaspapp.com, if you get an reply from source system. Sound great to move on.

Create a new wildcard SSL certificate (If you have SSL)
Configure the Subscription Settings and App Management service applications
- To enable the Subscription and App management services from CA
  - Go to SharePoint central administrator site
  - Click Manage services on server under System Settings
  - Start App Management Service and Microsoft SharePoint Foundation Subscription Settings Service
  - Now you are ready to configure the apps
Configure the App Management service application from CA
- Go to SharePoint CA
- Click Manage service applications under Application Management section
- Top ribbon click New to add App Management Service Application
- Enter appropriate details like Name, database, app pool account and name
- Click Ok to create the service application

Configure the App URLs

Navigate Apps from Central administrator

Click Configure App URLs under App Management

An error my throw if the subscription setting service didn’t configured like “The Subscription Settings service and corresponding application and proxy needs to be running in order to make changes to these settings.”

Solution: Have to create an service application from PowerShell. (P.S: We can’t create this service application from CA)

$account = Get-SPManagedAccount sathiya\spappPool
$appPool = New-SPServiceApplicationPool -Name SubscriptionServiceAppPool -Account $account 
$serviceApp = New-SPSubscriptionSettingsServiceApplication -ApplicationPool $appPool -name “Subscription Settings Service Application” -DatabaseName “LIVESP13-SubscriptionSettingsDB”
$serviceAppProxy = New-SPSubscriptionSettingsServiceApplicationProxy -ServiceApplication $serviceApp

1

2

3

4

$account = Get–SPManagedAccount sathiya\spappPool

$appPool = New–SPServiceApplicationPool –Name SubscriptionServiceAppPool –Account $account

$serviceApp = New–SPSubscriptionSettingsServiceApplication –ApplicationPool $appPool –name “Subscription Settings Service Application” –DatabaseName “LIVESP13-SubscriptionSettingsDB”

$serviceAppProxy = New–SPSubscriptionSettingsServiceApplicationProxy –ServiceApplication $serviceApp

In the App domain field, type the domain name which we have created for SharePoint apps
In the App prefix field you can use any text for identify it
Click Ok
Powershell

Configure app URLs by using Windows PowerShell

Set-SPAppDomain sathiyspapps.com Set-SPAppSiteSubscriptionName -Name “app” -Confirm:$false

1
2

Set–SPAppDomain sathiyspapps.com
Set–SPAppSiteSubscriptionName –Name “app” –Confirm:$false
The environment is ready to add apps and use it. If you are a system account then you will get an error “Everything is fine, but we had a small problem getting your license. Please go back to the SharePoint Store to get this app again and you won’t be charged for it.” because the System Account couldn’t make it. So use other account to add an app to your site.

Cheers…!

March 8, 2016

Download Installed SharePoint Solutions

Tweaks of SharePoint PowerShell script to download installed SharePoint solutions from the farm. All solution has deployed on server hives folder and the database but there is not option to download them. Try with below script to attain it.

Snippet:

$farm = Get-SPFarm
$solution = $farm.Solutions.Item(“SiteSolution.wsp”).SolutionFile
$solutions.SaveAs(“c:\wsp\SiteSolution.wsp”)

1

2

3

$farm = Get–SPFarm

$solution = $farm.Solutions.Item(“SiteSolution.wsp”).SolutionFile

$solutions.SaveAs(“c:\wsp\SiteSolution.wsp”)

Cheers…!

March 4, 2016

Upgrade SharePoint 2013 Enterprise 15.0.4569.1000 to 15.0.4641.1000

To upgrade SharePoint server 2013 Enterprise from 15.0.4569.1000 to 15.0.4641.1000 had a long investigation and searching on web made me confusion. Even I didn’t find any clear way that to reach there. So I kept my finger crossed and jump into my another SP Farm which has the same build. Finally got a clue and spins a toss. What does it? Just keep down your’s eyes 🙂

Once we upgraded SP1 then have to install Aug 2014 CU’s (KB2883086, KB2883085, KB2883078, KB2880559, KB2760213).

After that we have to install the security update for SP server KB2880994 file.

Finally you will get an updated SharePoint server 2013 enterprise with Build 15.0.4641.1000.

Cheers…!

February 26, 2016

Verifying SMTP SharePoint Outbound mail settings

Once we configured the SharePoint outbound mail server then our responsible to test the setup. Here the small powershell snippet will do!

### The script will return True or False
$toemail = “sathiya@sathiya.io”
$subject = “Test – SharePoint Outbound mail”
$body = “This mail for testing purpose…! Please ignore your action!”
$site = New-Object Microsoft.SharePoint.SPSite “http://sharepoint/”
$web = $site.OpenWeb()
[Microsoft.SharePoint.Utilities.SPUtility]::SendEmail($web,0,0,$toemail,$subject,$body)

1

2

3

4

5

6

7

### The script will return True or False

$toemail = “sathiya@sathiya.io”

$subject = “Test – SharePoint Outbound mail”

$body = “This mail for testing purpose…! Please ignore your action!”

$site = New-Object Microsoft.SharePoint.SPSite “http://sharepoint/”

$web = $site.OpenWeb()

[Microsoft.SharePoint.Utilities.SPUtility]::SendEmail($web,0,0,$toemail,$subject,$body)

If you get “True” the configuration perfectly alright, else you have to check the ULS log to find an issue. Suppose if you are not getting a mail you have to check smtp log or address to exchange/wintel team.

February 10, 2016

Category: SharePoint

SharePoint Server 2019 Public Preview

Features

html maintenance page snippet