Ubuntu easy_install missing

Really just a note for myself, but if anyone else is trying to figure out how to install “easy_install” in Ubuntu the golden command (which I constantly forget) is:

sudo apt-get install python-setuptools

Coffee Break: Windows Server 2012 First Look

One of the key things I’m liking with Windows Server 2012, is the new Server Manager. The new version is alot more useful than that of Windows 2008 and Windows 2008 R2 in that it appears to work out of the box, where as the previous involved alot of “tweaking” to get WinRM working.

This has a huge impact on the use of Server 2012 Core Edition, which unless you love doing everything on the command line or in PowerShell is pretty annoying to even get started with. However, the new server manager allows you to add roles and features from your local workstation along with launching applicable role tools right from the UI.

I’ve always likes the idea of Windows Server Core, but the practicality of managing it has always been and issue along with role limitations, although this appears to have also been “fixed”.

So far so good…

Unable to use SQL Aliases in IIS Manager or Visual Studio

I Have always had a problem with IIS Manager using SQL Aliases when using the built in .Net membership providers (mainly cause its handy to test and setup the initial FBA user) but never managed to get down to the cause of the issue, just took it as one of those things.

Luckily it was never really that important to resolve so it got left as specifying the alias in the web.config file did appear to work fine. However, a colleague had a similar problem with Visual Studio when trying to regenerate a database layer, which was a bit more of an issue due to the storing of the string.

After a bit of googling we managed to track down the issue:

If like me your happy using the “cliconfg” command to specify aliases (mainly because its included in Windows Server 2008 R2 and there’s no need to install the SQL Native Client manually), its important to understand that the architecture is important, this is where “Native Client” should have given the hint. The problem is that the 32bit client and the 64bit client store their registry keys in different locations, therefore adding an alias in one doesn’t add it to the other. IIS Manager and Visual Studio are both 32bit applications and therefore use the 32bit aliases, however running the “cliconfg” command from run or a command prompt on a 64bit machine unsurprisingly loads the 64bit version of the client configuration tool. Therefore, if you run into this issue, you should run “c:WindowsSysWOW64cliconfg.exe” for the 32bit version.

Note: I have no idea why 32bit applications are stored in SysWOW64 and the 64bit ones in System32… appears like it should be the other way around to me?!

New favorite PowerShell command

Everytime I have to open log file I always wished it would update on its own so I didn’t have to close it and open it again. I know applications like visual studio notify you when a file updates but its usually not a good idea to install it on the production machine and across the network access can be painful.

In comes PowerShell to save the day… And its install on pretty much all modern windows servers these days as standard.

Get-Content -Wait

Will print out the content of the log and wait at the bottom, when new lines are added the screen is too. How did it take me so long to find this!

For those of you familiar with linux this is similar to

tail -ls

SharePoint Issue: Possability of database corruption for whole site collection

Issue Summary

There is a bug in SharePoint 2010 that can cause an entire site collection to become corrupt which can only be fixed by restoring a backup. This issue is only likely to occur with code in custom solutions as the equivalent manual actions through the web interface do not cause the same issue, therefore general SharePoint use is not affected.

When does the issue occur?

When using the SharePoint Object Model or PowerShell to programmatically set permissions on a sub site (SPWeb) by first breaking role inheritance.

At this point the site collection will be fine, however if you then create a List or Document Library you will notice that the permissions won’t be inherited as they usually are. If you select to then inherit the permissions from the parent sub site (SPWeb) the site and any other content in the site collection including system pages will not be accessible. The server will throw a HTTP 500 error and will not give any specific reason in the Event Log or the ULS logs.

Resulting Effects

  • PowerShell commands cannot be run on the Site Collection
  • No administrative functions can be carried out on the Site Collection through Central Admin
  • Details for the site collection cannot be viewed through central admin
  • Access to the settings or data through the SharePoint API will not be possible
  • Any sites or sub-sites in the collections will not be accessible

Patch Status

As of 20th July 2012, we are un aware of a fix having been released for this issue.

SharePoint 2010 and SQL Server 2012

Came across and interesting issue today when deploying SharePoint 2010 on a development machine, with “New-SPConfigurationDatabase” throwing the error:

Could not find stored procedure 'sp_dboption'.

The solution is to install SharePoint 2010 SP1, which adds support to SharePoint 2010 for SQL Server 2012