Sunday, April 17, 2016

SharePoint Site Backup restore/ Forgot the SA password of SQLServer 2008

I was trying to restore the SharePoint 2010 site backup through content database method, but unfortunately the site backup which I’m trying to restore on my environment has version mismatch.

The site backup version was 14.0.7145.5000 and the current environment where I’m trying to restore it 14.0.6029.1000, but wait I’ve list of other issues as well.
Phase 1 Issues:
  •      Forgot the SA password of the SQL-Server 2008 R2
  •      Unable to login through windows credentials


For password recovery this URL helped me a lot.

I have two option:

  1. Either restore the site backup in SharePoint 
  2. Restore the content database backup (which is relatively easy and recommended way)
Restore the content database backup 

For restore the SQL backup, refer these article, howtogeek msdn

The following commands is little modified command compare to the article, but it really works for me.

use master
go

ALTER DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE;


RESTORE DATABASE [Target DatabaseName] 
FROM  
DISK = N'C:\Backup\SQLBackupFile.bak' 
WITH  FILE = 1,  
MOVE N'' TO 'c:\mssql\data\.mdf',   
MOVE N'_log' TO 'c:\mssql\log\.ldf',  
KEEP_REPLICATION,  NOUNLOAD,  REPLACE,  STATS = 10
GO

use
go

/********* Use this command if database is throwing error of "database is already use by another user"

ALTER DATABASE SET MULTI_USER;

Wednesday, January 20, 2016

workflow integration with media wiki / FlaggedRevs installation on Media Wiki

I tried hard to install / configure Flagged Revs on Mediawiki I got different errors such as :

After gave the current user (bureaucratic) to Reviewer suddenly the whole wiki stops working

Then I start with fresh installation of media wiki and did it again, sometime it happens unknowingly we configure some wrong option, and they guy like me got into trouble :). 
Anyhow when I investigate it further the php_error log file, following error was found.

Call to undefined method ObjectCache::getMainStashInstance() in C:\wamp\www\newwiki\extensions\FlaggedRevs\backend\FRUserActivity.php on line 56

With the help of  Krenair, figure it out that I've incompatible version of FlaggedRev and MediaWiki, so I download the mediawiki-1.26.2 with FlaggedRevs-REL1_26-56a565c. 

The problem solve!!

Root Cause:

Actually, as error states that getMainStashInstance is not available, so when I checked in media wiki 1.24 the function implementation was not available and Krenair helped me to figure it out in which version it will be available, lets cut it short, use the latest version of both Flagged and Mediawiki to avoid such issues.

Monday, January 11, 2016

Media WIki LDAP configuration

Step1:

First download the LDAP extension from MediaWikiExtension and follow the instructions given on the same page.

Step2.

For running the command “ php maintenance/update.php” it’s a little trick, because sometime it happens that PHP is not configured in path variable to run on command prompt, so for this follow this article.

Step3

Configure the LDAP settings in your localsettings.php, that’s a little hack, first follow the instructions mentioned in this article, actually this is the same author's blog which wrote the plugin, so it’s very informative.

Step4

If you got the error of “Unable to start TLS: Server is unavailable” then use the following code:

$wgLDAPEncryptionType = array("group"=>"clear"); 

Where “group” will be replaced by the same string used in the ldap settings in localsettings.php file. Usually it’s a domain name in LDAP string for instance:
group.root.gp

Step 5

Enjoy the LDAP login!!!

If you face any issue, you can contact to me via blog comments!