Office365 SharePoint - Rename Multiple Files in Document Library

Unfortunately, Office 365 SharePoint doesn't let you to do too much using the built-in PowerShell cmdlets. Sometimes this trick can also come in handy with On Premise SharePoint installations when you just need a quick way to manipulate files in a library. Using PowerShell commands this is much more complicated.
Last day I ran into an issue (maybe I'll post that later) when I had to rename multiple files in a Document Library that resides on an Office 365 SharePoint instance.

What I did was the following:

Step1 - Add the website to the IE's Trusted Sites

First of all, you have to use Internet Explorer. Open in Explorer mode only works with this browser. Add the website to the trusted site's list then restart the browser. Otherwise it will complain later.

Now browse to your SharePoint Library again.

Step 2 - Open the Library in Explorer

Go to Library -> Open with Explorer

Step 3 - Map the location as a Network Drive

Now that you can see the library in Explorer, you need to grab the URL from the Address bar (ctrl + c) and map a network drive:

Press the ALT + T -> Map Network Drive

Choose a drive letter, paste your path and Finish. You may not want to reconnect the drive at logon.

Now, that you can see your files as a drive you can use your favorite tool to manipulate them.

Step 4 - Use your favorite tool to manipulate the files

I just used cmd to rename all pdf files but you can do much, much more with Total Commander if you have to.

Of course, this method work with SharePoint Server (On Premise) as well.

Renewing JIRA's the SSL Certificate on Windows

Basically this is JAVA specific stuff.

Environment:

• Windows Server 2008 R2
• JIRA Standalone (6.2) (Installed in C:\JIRA)
• JDK 1.7 (Installed to C:\JDK)

AFAIK this method applies to all JIRA and JAVA/JDK editions.

Step 1: Identifying the JKS (Java KeyStore) file location

This is the file where the certificates used by Tomcat are stored. The JKS file is linked with JIRA in the server.xml file that is located under the JIRA INSTALL DIRECTORY\conf\server.xml (In this example C:\JIRA\conf\server.xml). Open in notepad and search for JKS to find the section we're insterested in. 

SSLEnabled="true" acceptCount="100" clientAuth="false" connectionTimeout="20000" disableUploadTimeout="true" enableLookups="false" keyAlias="tomcat" keystoreFile="C:\JIRA\cert\jira.jks" keystorePass="somepass" keystoreType="JKS" maxHttpHeaderSize="8192" maxSpareThreads="75" maxThreads="150" minSpareThreads="25" port="443" protocol="org.apache.coyote.http11.Http11Protocol" scheme="https" secure="true" sslProtocol="TLS" useBodyEncodingForURI="true" />

Step 2: Creating a CSR

For this you use keytool.exe that is located in your JDK instance's bin directory. You will be asked for the keystore password that can also be found on the xml mentioned earlier. Make sure to mention the -alias parameter with the keyAlias attribute from the settings.xml file.

C:\JDK\bin> keytool -certreq -keystore "C:\JIRA\cert\jira.jks" -alias tomcat

No questions asked, the request will use the same properties as your current certificate. Now copy-paste the CSR from the console and send it to your CA that will issue the certificate for you.

Step 3: Installing the new certificate

Once you got the new certificate save it as a .cer file (I'll save it as C:\JIRA\cert\jira.cer in this example) and open its properties to export *all* the CA certificates from the certification path:

Click on View Certificate -> Details -> Copy to File and export it in the DER encoded binary X.509 format.

After the exports, in this example I'll have 3 certificates to import into the KeyStore file:

• jira.cer (the certificate I got from the CA)

• ca-root.cer (the first certificate exported in the Certification Path)

• ca-intermediary.cer (the second certificate exported in the Certification Path)

So go back to the Command Prompt, you JAVA instance's bin directory and use keytool.exe to import all these certificates. When you're asked if you want to import the certificate, type yes at the console.

C:\JDK\bin>keytool.exe -importcert -keystore "C:\JIRA\cert\jira.jks" -storepass somepass -trustcacerts -alias ca-root -file "C:\JIRA\cert\ca-root.cer" C:\JDK\bin>keytool.exe -importcert -keystore "C:\JIRA\cert\jira.jks" -storepass somepass -trustcacerts -alias ca-intermediate -file "C:\JIRA\cert\ca-intermediate.cer" C:\JDK\bin>keytool.exe -importcert -keystore "C:\JIRA\cert\jira.jks" -storepass somepass -trustcacerts -alias tomcat -file "C:\JIRA\cert\jira.cer"

Restart Tomcat (JIRA) and you're done.

Top FREE Cloud Storage Providers - 2014

Short and on subject (as always :).

Did some research on the market and currently these are the top Cloud Storage Providers that offer the Most Free Space and have Desktop and Mobile (iOS, Android) Sync Clients.
Everyone is starting the list with Dropbox but that's outdated offering a shameful of 2GB.

1. Mega.co.nz - 50 GB
2. FireDrive - 50 GB
3. Bitcasa.com - 20 GB (Sync up to 3 devices)
4. Copy.com - 15 GB (Or you get 20GB if you register from this referral)
5. Google Drive - 15 GB
6. 4sync.com - 15 GB
7. MediaFire.com - 10 GB
8. Box.com - 10 GB (250 MB max file size)
9. Microsoft OneDrive - 7 GB

Note - I personally recommend Copy.com, it's a great service. Works almost just like Dropbox but you get a ton of space. You get an additional 5GB for every referred friend.

Although you can scrape up a bunch of free space this way I don't recommend installing more than two sync clients on your computer because it can seriously affect the computers performance.

I will update this list as soon as something interesting comes up.

Additional Resources

• http://www.cnet.com/how-to/how-to-score-50gb-of-free-cloud-storage-from-box/
• http://mobileoffice.about.com/b/2014/02/25/get-up-to-8gb-more-of-free-onedrive-storage-space.htm

Updates

• 5/3/14 - Adding FireDrive to #2 offering a mind-blowing free space of 50GB and no file size limit.

VBoxManage modifyhd Code CO_E_SERVER_EXEC_FAILURE (0x80080005) - Server execution failed

This is a lol one. I tried extending the hard disk of a Virtual Machine and received the following error:

C:\Program Files\Oracle\VirtualBox>VBoxManage.exe modifyhd "E:\Virtual Machines\JIRA\Windows Server 2008.vdi" --resize 40960
VBoxManage.exe: error: Failed to create the VirtualBox object!
VBoxManage.exe: error: Code CO_E_SERVER_EXEC_FAILURE (0x80080005) - Server execution failed (extended info not available)
VBoxManage.exe: error: Most likely, the VirtualBox COM server is not running or failed to start.

The Solution

Do *not* start Command Prompt as admin!

Cannot set unknown member 'CompositeTask.PreserveIncompleteTasks'. HTTP headers received from the server

The problem

Today I encountered a strange issue when trying to publish a basic SharePoint 2013 Workflow that has a Start Task Process action in it.

The error I received was the following:

Cannot set unknown member 'CompositeTask.PreserveIncompleteTasks'. HTTP headers received from the server


Microsoft.Workflow.Client.ActivityValidationException: Workflow XAML failed validation due to the following errors:
Cannot set unknown member 'CompositeTask.PreserveIncompleteTasks'. HTTP headers received from the server - ActivityId: 51341428-f7a1-4856-8303-fcbc699335ea. NodeId: SPSRV. Scope: /SharePoint/default/8f0c9dfe-6f01-499c-a356-a417da9b39b4/53d5e7f1-0360-4909-8997-71eaf26b140d. Client ActivityId : a1627f9c-bdfc-80a3-b6fd-cf246a4e8993. ---> System.Net.WebException: The remote server ret

Solution

Checking the logs didn't provide any useful clue. Digging the net I found a post (linked at the bottom) that suggested re-registering the SharePoint 2013 Workflow Service. So I did that.

Register-SPWorkflowService -SPSite https://portal.mydomain.net -WorkflowHostUri https://spsrv:12290 -Force

Question: Will this command affect my currently running workflows?
Answer: No, all workflows will continue running smoothly, even if they are in progress, paused or waiting for an item to change. Tested.

Resources

• http://social.technet.microsoft.com/Forums/en-US/15e9a231-7737-44fb-9207-3945c44b1001/spd2013-workflow-publish-failed-for-ept-site-workflow?forum=projserv2010setup
• http://ranaictiu-technicalblog.blogspot.com/2013/02/sharepoint-2013-workflow-manager.html

SharePoint: Are there any Users currently on the site?

Problem

Ever wondered is there anyone connected to the SharePoint Site before doing an iisreset or a server reboot? Or how much the site is used on a daily basis?

Solution

The Performance Monitor tool is just about perfect for this. You can make a custom console, save it and use later. Or you can collect data over time to have a better overview on the server usage (Data Collector Sets section, not covered in this post).

Below I'll detail step by step how to create a custom MMC Console.

1. First, start a blank mmc console
   
   
   
   
   
2. Add a Performance Monitor Snap-In
   
   
   
   
   
   
   
3. You've got a blank Performance Monitor Console. Now you have to add the Counters.
   
   
   
   
4. Click on the green Plus Sign and find the following counters:
   
   Web Service Category
   - Current Anonymous Users
   - Current Non-Anonymous Users
   
   At the Instances section you can select a particular website or just _Total.
   
   
   
   I also like to add other helpful counters like CPU Usage, Memory, etc. For more info on counters please consult this blog post.
   
   
   
5. Go to View -> Customize and remove the clutter
   
   
   
   
   
6. Go to File -> Save As and save the console for later use. There you go.
   
   

Obviously, you can use this to monitor any kind of IIS Website like TFS, etc.

Updating Permissions on List Items via PowerShell

The following script crawls all document libraries from a path of site and looks for *budget*.xls* and will replace all permissions on the Item with Read.
The script is useful to cut access for a pattern of files.

if ((Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null)
{
 Add-PSSnapin Microsoft.SharePoint.PowerShell
}

$site = get-spsite -identity "http://myspportal"

foreach($web in $site.AllWebs)
    {

    if ($web.Url.Contains("http://myspportal/HR/"))     # Look for only under HR
        {

        $Lists = $web.Lists | Where-Object {$_.Title -Like "*Reports*"}   # Pattern to look for in LISTS names
        $roleReadOnly = $web.RoleDefinitions["Read"]

        foreach($list in $lists)
            {
            
             foreach($item in $list.Items | Where-Object {$_.Name -like "*budget*.xls*"})     # Filename pattern is *budget*.xls*
                {
                Write-Host $item.ParentList.ParentWeb.Url+'/'+$item.URL + '      ' + $item.Name
                if ($item.HasUniqueRoleAssignments -eq $false)
                    {
                    $item.BreakRoleInheritance($true);
                    }

                foreach ($ra in $item.RoleAssignments | Where-Object {$_.RoleDefinitionBindings.Name -eq "Contribute" -or $_.RoleDefinitionBindings.Name -eq "Full Control" -or $_.RoleDefinitionBindings.Name -eq "Edit"})
                    {
                        $ra.RoleDefinitionBindings.RemoveAll()
                        $ra.RoleDefinitionBindings.Add($roleReadOnly)
                        $ra.Update()
                    }

                }
            }
        }
    }

SharePoint 2010 vs 2013 Workflow Inconsistencies

These days I was tearing my hair out. I am rewriting some old workflows on my SharePoint system and can't decide whether to use v 2010 or 2013 workflows. There are definitely some useful features in the 2013 workflows but there are also some very basic features missing.

Here they are:

There is no impersonation step

This is somewhat understandable. Impersonation step in unreliable because when the employee who deployed the workflow leaves the company and the AD user is removed, the workflow will fail to start.

Cannot set permission on items

There is no way to replace permission on items. This was very useful in some cases.

Lookup Field - Additional Fields

Consider having a Lookup field linked to another list that is retrieving some additional columns. For example the Title is the main column, and you also retrieve the ID and Status fields. In 2010 you can work with these additional columns, but in 2013 only the main Lookup column is showing up.

In 2010 Workflow:

In 2013 Workflow:

This is crazy. Yes, you could retrieve the ID as the main column instead, then do a Lookup on the other list in the workflow. But in this case the New Item form shows a dropdown with some numbers instead the lookup field of your choice. Here you can use InfoPath to customize - which is retiring.

There is no Else-If

Serously??
Even the Else branch is missing from the auto-complete.

Wait for field to not equal a value

In 2010 Workflow you have all the options:

In 2013 Workflow there is only the Equal:

Start List/Site Workflow

Via a 2013 WF you can only start a v2010 workflow. Wtf??

That's it for now... I'll update this post once I find some more annoyances.

Tomcat 7 FindClass org/apache/catalina/startup/Bootstrap failed

Environment

• Windows Server 2008 R2
• Tomcat 7 x64
• jdk1.7.0_45 x64

 Problem

After upgrading from Tomcat 6 to 7 the new Tomcat instance did not want to start up. This is what I saw in the logs:

[2014-01-09 19:08:46] [info]  [ 2516] Commons Daemon procrun (1.0.15.0 64-bit) started
[2014-01-09 19:08:46] [info]  [ 2516] Running 'Tomcat7' Service...
[2014-01-09 19:08:46] [info]  [ 6004] Starting service...
[2014-01-09 19:08:47] [error] [ 6080] FindClass org/apache/catalina/startup/Bootstrap failed
[2014-01-09 19:08:47] [error] [ 6004] Failed to start Java
[2014-01-09 19:08:47] [error] [ 6004] ServiceStart returned 4
[2014-01-09 19:08:47] [info]  [ 2516] Run service finished.
[2014-01-09 19:08:47] [info]  [ 2516] Commons Daemon procrun finished

2014-01-09 19:08:46 Commons Daemon procrun stderr initialized
java.lang.NoClassDefFoundError: org/apache/juli/logging/LogFactory
    at org.apache.catalina.startup.Bootstrap.(Bootstrap.java:60)
Caused by: java.lang.ClassNotFoundException: org.apache.juli.logging.LogFactory
    at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
    ... 1 more
Exception in thread "main" 

All I found on the net was that Java 5 is not compatible with Tomcat 7. But I had the latest Java 7.

Solution

With trial and error I found the solution:

I had to include tomcat-juli.jar also in the Java Classpath!

I opened an administrative Command Prompt and edited the Tomcat instance's Properties

D:\apps\tomcat7\bin> tomcat7w.exe //ES//Tomcat7

Compress Old Files with PowerShell

The Story

The following PowerShell script will compress files that are older than the specified amount of time. It is handy for archiving IIS Logs, SQL Backups, etc.
The script uses 7-zip so you obviously have to have it installed (or the exe copied somewhere). It's using maximum compression which is resource intensive, if you don't want that just remove the "-mx9 -m0=lzma2" parameters.

The Script

$path = "C:\inetpub\logs\LogFiles\"
$mask = "*.log"

$days = 7

$files = dir $path -Recurse -Include $mask | where {($_.LastWriteTime -lt (Get-Date).AddDays(-$days).AddHours(-$hours).AddMinutes(-$mins)) -and ($_.psIsContainer -eq $false)}


ForEach ($file in $files) {

    & "C:\Program Files\7-Zip\7z.exe" u -mx9 -t7z -m0=lzma2 ($file.FullName + ".7z") $file.FullName
    if ($LASTEXITCODE -eq 0) {
        Remove-Item $file
    }

}

Resources

• http://stackoverflow.com/questions/16613656/how-can-i-check-if-a-file-is-older-than-a-certain-time-with-powershell
• http://stackoverflow.com/questions/1673967/how-to-run-exe-in-powershell-with-parameters-with-spaces-and-quotes
• http://blogs.msdn.com/b/daiken/archive/2007/02/12/compress-files-with-windows-powershell-then-package-a-windows-vista-sidebar-gadget.aspx
• http://stackoverflow.com/questions/2081795/invoke-an-exe-from-powershell-and-get-feedback-on-succes-or-failure

Set Permissions on Multiple Sites using PowerShell

These days I had a request to add an Active Directory group with Contributor rights on a SharePoint Site Collection. Since many sites had broken inheritance, using the UI was not an option so I created a small PowerShell Script that enumerates all Webs and if the Inheritance is broken, it adds the group with the specified Role.

Notes:

• The If command uses the $web.Url.Contains directive in order to modify the rights only on a subset of sites. If all Webs have to be crawled, use if ($web.HasUniquePerm -and $web.RequestAccessEnabled) instead.
• This script modifies permissions only on webs. Lists and Items with unique permission will not be touched.

if ((Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null)
{
 Add-PSSnapin Microsoft.SharePoint.PowerShell
}


$site = Get-SPSite -Identity "http://spdev/sites/SiteCollection"


foreach($web in $site.AllWebs)
    {

    if ($web.HasUniquePerm -and $web.RequestAccessEnabled -and ($web.Url.Contains("/SiteCollection/BU1") -or $web.Url.Contains("/SiteCollection/BU2")))
        {
            $account = $web.EnsureUser("Domain\QATeam")
            $role = $web.RoleDefinitions["Contribute"]

            $assignment = New-Object Microsoft.SharePoint.SPRoleAssignment($account)
            $assignment.RoleDefinitionBindings.Add($role)

            $web.RoleAssignments.Add($assignment)
        }
    $web.Dispose()
    }
$site.Dispose()

References

• http://social.technet.microsoft.com/Forums/sharepoint/en-US/4373cef1-2471-4199-aa16-784684fc82de/adding-permission-to-list-using-powershell

SharePoint Start Workflow on All Items of a List via PowerShell

To start a List Workflow in SharePoint on All Items of a list is a pain through GUI but it's a piece of cake in PowerShell. Note that the Workflow will not start instantly (as opposed to triggering through the UI) but in maximum 5 minutes because it's started through the SharePoint Timer Service.

#updated on 10/17/2013

# URL of the Site
$web = Get-SPWeb -Identity "https://sharepointsrv/site1"

$manager = $web.Site.WorkFlowManager

# Name of the list
$list = $web.Lists["Shared Documents"]

# Name of the Workflow
$assoc = $list.WorkflowAssociations.GetAssociationByName("On Item Created","en-US")

$data = $assoc.AssociationData
$items = $list.Items
foreach($item in $items)
 {
 $wf = $manager.StartWorkFlow($item,$assoc,$data,$true)
 }
 
$manager.Dispose()
$web.Dispose()
#

References

• http://social.technet.microsoft.com/Forums/sharepoint/en-US/dffdceab-f2fe-4886-8e2a-ea26cf08c78a/how-to-start-a-speific-workflow-programatically-in-sharepoint-2010-via-powershell

ls - no colors on Ubuntu

I have some older Ubuntu servers that don't display colors when executing the ls command over Putty. So I took a .bashrc file from a different Ubuntu server and copied over the relevant section that contains the ls --color command. After that I applied the ~/.bashrc file so I don't have to restart the session. This will set the foloring for grep and vi as well.

~$ vim ~/.bashrc

if [ "$TERM" != "dumb" ]; then
    eval "`dircolors -b`"
    alias ls='ls --color=auto'
    alias grep='grep --color=auto'
    alias fgrep='fgrep --color=auto'
    alias egrep='egrep --color=auto'
    alias vi='vim'

else
    alias ls="ls -F"
    alias ll='ls -alF'
    alias la='ls -A'
    alias l='ls -CF'
fi


~$ source ~/.bashrc

References

• http://askubuntu.com/questions/194039/no-terminal-colors-in-ubuntu-server-12-04
• http://silviowangler.blogspot.ro/2010/09/apply-changes-in-bashrc-immediately.html

SharePoint 2013 Meeting Workspace Page Not Found

The Problem

I have some legacy Meeting Workspaces imported over from SharePoint 2010 that are still in use. Recently I enabled the Navigate Up button on a test site collection using this guide because users are really missing that feature. After applying the new master page to all subsites, I observed that the meeting workspace is no longer working. If I click on a meeting from a different date, a Page Not Found error is displayed on the site.

The logs:

 20635 08/22/2013 15:56:05.84   w3wp.exe (0x15D0)                         0x2EDC  SharePoint Foundation           Logging Correlation Data        xmnv  Medium    Name=Request (GET:https://spdevsrv:443/sites/dev1/WeeklyStatus/undefined?InstanceID=20130710&Paged=Next&p_StartTimeUTC=20130703T120000Z&View=%7bFEF87B6F%2d54D6%2d44CD%2d8055%2dFA404C0A5B50%7d)  57843b9c-4d5d-80a3-b6fd-c40b260782c1
 20636 08/22/2013 15:56:05.84   w3wp.exe (0x15D0)                         0x2EDC  SharePoint Foundation           Authentication Authorization    agb9s  Medium    Non-OAuth request. IsAuthenticated=True, UserIdentityName=0#.w|domain\user, ClaimsCount=43  57843b9c-4d5d-80a3-b6fd-c40b260782c1
 20637 08/22/2013 15:56:05.85   w3wp.exe (0x15D0)                         0x58E8  SharePoint Foundation           General                         af71  Medium    HTTP Request method: GET  57843b9c-4d5d-80a3-b6fd-c40b260782c1
 20638 08/22/2013 15:56:05.85   w3wp.exe (0x15D0)                         0x58E8  SharePoint Foundation           General                         af75  Medium    Overridden HTTP request method: GET  57843b9c-4d5d-80a3-b6fd-c40b260782c1
 20639 08/22/2013 15:56:05.85   w3wp.exe (0x15D0)                         0x58E8  SharePoint Foundation           General                         af74  Medium    HTTP request URL: /sites/dev1/WeeklyStatus/undefined?InstanceID=20130710&Paged=Next&p_StartTimeUTC=20130703T120000Z&View=%7bFEF87B6F%2d54D6%2d44CD%2d8055%2dFA404C0A5B50%7d  57843b9c-4d5d-80a3-b6fd-c40b260782c1
 20640 08/22/2013 15:56:05.85   w3wp.exe (0x15D0)                         0x58E8  SharePoint Foundation           Files                           aise3  Medium    Failure when fetching document. 0x80070002  57843b9c-4d5d-80a3-b6fd-c40b260782c1
 20641 08/22/2013 15:56:05.87   w3wp.exe (0x15D0)                         0x5198  SharePoint Foundation           Monitoring                      b4ly  Medium    Leaving Monitored Scope (Request (GET:https://spdevsrv:443/sites/dev1/WeeklyStatus/undefined?InstanceID=20130710&Paged=Next&p_StartTimeUTC=20130703T120000Z&View=%7bFEF87B6F%2d54D6%2d44CD%2d8055%2dFA404C0A5B50%7d)). Execution Time=37.2469  57843b9c-4d5d-80a3-b6fd-c40b260782c1

The Solution

You need to apply the mwsdefaultv15.master page to all Meeting Workspace sites. Since the SharePoint Server Publishing feature is not enabled (and cannot be enabled) on this type of site, you have to do the job in PowerShell.

$web =  Get-SPWeb -Identity "https://spdevsrv:443/sites/dev1"
$web.MasterUrl = "/sites/dev1/_catalogs/masterpage/mwsdefaultv15.master"
$web.CustomMasterUrl = "/sites/dev1/_catalogs/masterpage/mwsdefaultv15.master"
$web.Update()
$web.Dispose()

If you have a bunch of Meeting Workspaces then the script below might come in handy. For the sake of safety please back up your Site Collection first.

$site = Get-SPSite -Identity "https://spdevsrv:443/sites/dev1"
$webs = $site.AllWebs

$CorrectMasterPage = "/_catalogs/masterpage/mwsdefaultv15.master"

foreach($web in $webs)
 {
 if (($web.WebTemplate -eq "MPS") -and ($web.WebTemplateId -eq 2))
  {
  write-host "Updating" $web.Url
  $MasterPageURL = $web.ServerRelativeUrl + $CorrectMasterPage
  $web.MasterUrl = $MasterPageURL
  $web.CustomMasterUrl = $MasterPageURL
  $web.Update()
  }
 $web.Dispose()
 }

References

• http://www.manageprojectsonsharepoint.com/blog/2012/12/19/restore-navigate-up-on-sharepoint-2013/
• http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=226
• http://social.technet.microsoft.com/Forums/en-US/34039e09-7b66-4bf6-9087-4bac24f6cae8/meeting-workspace-woes-custom-master-page

Find SharePoint Web Template Name using PowerShell

You can find out the Template Name and Id of a SharePoint Site using the following PowerShell command:

$web =  Get-SPWeb -Identity "http://spsrv/sites/web1/"
Write-Host $web.WebTemplate "," $web.WebTemplateId

To list all Template Names and IDs:

Get-SPWebTemplate | select ID, Name, Title | Sort-Object ID

References:

• http://blogs.technet.com/b/praveenh/archive/2013/04/04/get-a-list-of-web-templates-and-ids-in-a-sharepoint-site.aspx
• http://social.technet.microsoft.com/Forums/sharepoint/en-US/07cf57c3-8965-4f85-8911-2c95aa78fed5/how-to-get-the-name-of-the-template-in-sharepoint-2010-using-powershell

MySQL Backup Script in Bash / Cron Job

The following is a handy cron job that backs up a MySQL database, compress it with gzip and will delete the ones older than 30 days. Make sure the user running the job has write permissions (in my case the user levente@testsrv) on the backup output directory. The mysql backup job will be executed daily at 2:15am and the cleanup job at 2:20am.

levente@testsrv:~$ crontab -e


# ....
# For more information see the manual pages of crontab(5) and cron(8)
#
# m h  dom mon dow   command

 15 2 * * * mysqldump -u mysqluser -pmysqlpassword db_name | gzip > /var/backups/mysql/db_name_`date '+\%Y\%m\%d-\%H\%M\%S'`.sql.gz
 20 2 * * * find /var/backups/mysql/db_name* -mtime +30 -exec rm {} \;

If you want to run the MySQL backup script directly at the shell, you have to remove the backslash characters before the % because these are escaped in cron.

levente@testsrv:~$ mysqldump -u mysqluser -pmysqlpassword db_name | gzip > /var/backups/mysql/db_name_`date '+%Y%m%d-%H%M%S'`.sql.gz

Installing/Enabling RPMForge on CentOS 6.5 (latest binaries)

The steps needed to install RPMForge on CentOS are already described on this excellent page, I'll just update the script to use the latest binaries.

rnd=$RANDOM
wget -O /tmp/rpmforge-`echo $rnd`.rpm http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm
rpm --import http://apt.sw.be/RPM-GPG-KEY.dag.txt
rpm -i /tmp/rpmforge-`echo $rnd`.rpm
rm -f /tmp/rpmforge-`echo $rnd`.rpm
#

To test you can try installing something from the RPMForge repositories, like htop:

yum install htop

Configuring Web Proxy on CentOS

If your internet connection is behind a web proxy, you need to configure the following on your CentOS server:

System-wide proxy settings - add the following lines to your /etc/environment file:

# vi /etc/environment

http_proxy="http://proxysrv:8080/"
https_proxy="https://proxysrv:8080/"
ftp_proxy="ftp://proxysrv:8080/"
no_proxy=".mylan.local,.domain1.com,host1,host2"

To apply these settings without restarting the machine run the following commands on the bash shell:

export http_proxy="http://proxysrv:8080/"
export https_proxy="https://proxysrv:8080/"
export ftp_proxy="ftp://proxysrv:8080/"
export no_proxy=".mylan.local,.domain1.com,host1,host2"

You also need to configure yum:

# vi /etc/yum.conf

proxy=http://proxysrv:8080/

CentOS 6.4 on HyperV - No Neworking on eth0

Just installed CentOS 6.4 from the CentOS-6.4-x86_64-bin-DVD1.iso image as a HyperV virtual machine.

After installation I observed that the eth0 adapter is not configured.
This blog post helped me to start networking, thanks Rutger Thomschutz!

Based on the blog post mentioned I did the following:

vi /etc/sysconfig/network-scripts/ifcfg-eth0

# changed ONBOOT to Yes
ONBOOT = yes

Created the hard links, brang up the adapter and rebooted the server:

# edit 9/10/2013 - in most cases you don't have to create the links below. 

# ln /etc/sysconfig/network-scripts/ifcfg-eth0 /etc/sysconfig/networking/devices/ifcfg-eth0
# ln /etc/sysconfig/network-scripts/ifcfg-eth0 /etc/sysconfig/networking/profiles/default/ifcfg-eth0
ifconfig eth0 up
reboot now
#

Icecast + VLC Installation and Configuration Guide

Making VLC work with IceCast is not hard but there are some minor settings that were not obvious to me and I spent some time to figure them out.

IceCast

First, download and install IceCast. That's pretty much a next next next installation. When done start the IceCast Server.

Now, if you open this address with a browser, you can see that the server is running.

Eventually, you may want to edit the IceCast configuration to customize the port, the number of streams and the passwords. (Configuration -> Edit Configration).

VLC

I have VLC Media Player 2.0.8 Installed. I am going to stream some mp3 files to IceCast.

First, I have to enable MP3 streaming at the IceCast Output plugin module.

In VLC, go to Preferences (Enable advanced settings) -> Stream Output -> Access Output -> Shoutcast and check Stream MP3. On this page you can also set the name of the radio station, genre and other details.

Now, let's add the mp3 files for streaming:

• In VLC go to Media -> Stream
• Add the mp3 files
• Click Stream

• Click Next

• Select IceCast from the dropdown and click Add

• I'll enter localhost for the address since both VLC and IceCast are on the same machine. Otherwise I would enter the IP Address of the computer running IceCast.
• I'll enter radio1 for the mount point. It is highly recommended to specify a mount point, I couldn't make this working without entering one.
• source:hackme is the Login:pass combo in my case because I did not change the default password in the configration file. You should do that. The login is always "source".
• I won't activate transcoding since my files are already in mp3 format.
• Click Stream

Now I can see that the music is "playing" in VLC.

For the proof of concept, I will open this stream on a different computer with foobar2000. Note the /radio1 at the end of the URL, this is the mount point.

Notes

When everything is running, opening the Stream URL in the browser will bring up the IceCast status & admin page with some useful info. The default admin credentials are admin / hackme.

Additional resources

IceCast Official Documentation - http://www.icecast.org/docs/icecast-2.3.3/