SampleSite on Windows 7

Great!

No big deal setting up a samplesite on Windows 7. Some small things had to be made to get the installation through.

Windows funktioner:
* Microsoft .NET Framework
* Internet Information Services with ASP.NET
(Since I was on a swedish machine I hade to copy the directory 'sv' to a duplicate named 'EN' c:\Windows\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation\SQL\, guess there still are some bugs in the EPi-installer)

In SQL Server 2008 Express:
* Enable Named Pipes and TCP/IP protocol
* Set automatic start of SQL Server Browser service

I installed the SQL Server 2008 with Microsoft Web Platform Installer.


Now the site is up, let's see how developing works out.

Alter sort order in EPiServer

Just a quick one. To programatically alter or set the sort order of a page in EPiServer you can do like this:

PageData pageClone = page.CreateWritableClone();

pageClone["PageChildOrderRule"] = EPiServer.Filters.FilterSortOrder.Alphabetical;

EPiServer.DetaFactory.Instance.Save(pageClone, Episerver.DataAccess.SaveAction.Publish);

Alfresco - setup a test environment

Alfresco is not that easy to configure! There are lots of settings in a whole bunch of direcotories and files! So how do I set up this to use AD login?

So I thought I'd share with you a quick way to set up a test environment. This is probably not the best solution for a permanent setup. Anyway, here are the steps to follow:

Install Win 2003 and connect it to your domain.

Download and install the free Alfresco-Communit-2.3-Full-Setup from http://wiki.alfresco.com/wiki/Download_Community_Edition.

Change in file C:\Alfresco\tomcat\shared\classes\alfresco-global-properties

• Change from authentication.chain=alfrescoNtlm1:alfrescoNtlm to authentication.chain=alfrescoNtlm1:alfrescoNtlm,passthru1:passthru

Change in file C:\Alfresco\tomcat\webapps\alfresco\WEB-INF\classes\alfresco\subsystems\Authentication\passthru\passthru-authentication-context.properties

• Set passthru.authentication.useLocalServer to true.
• Set passthru.authentication.domain to your domain.

Change in file C:\Alfresco\tomcat\webapps\alfresco\WEB-INF\classes\alfresco\subsystems\Authentication\passthru\ntlm-filter.properties

• Set ntlm.authentication.sso.enabled to false.

Finally start Alfresco Server through the start menu and enter http://hostname:8080/alfresco after the Tomcat console window has printed the text Server startup in xxxxxx ms.

Upgrade EPiServer from 4.61 tol 4.62

Now it's time to try to upgrade our EPiServer site! First bringing it up to 4.62 and after that to CMS 5.

First step went on with just a tiny problem "Failed to register ASP.NET client scripts on this site" that was quickly solved after following these instructions. In short: temporary rename the v3.0 and v3.5 folders in C:\WINDOWS\Microsoft.NET\Framework.

Now stepping on to the next greater level! Move to EPiServer CMS 5!

Upgrade Ubuntu distribution without graphical interface

I've just installed a base Ubuntu machine now, JEOS, really great thing when setting up a system in VMware. But anyway, what I thought of right now is how simple it was to update to next dist! I installed jeos-8.04-1 which was a Hardy dist which is a bit old. So I made a try to upgrade it. So here is a short list of the steps I took. (As root)

1. apt-get update && apt-get upgrade
2. apt-get install joe (just to have a nice editor)
3. Open and edit /etc/apt/sources.list
4. Replace all hardy with intrepid everywhere
5. apt-get update && apt-get dist-upgrade
6. reboot

Then do the same thing if you want to upgrade to jaunty! Parhaps it works jumping right into jaunty, but I took it step by step.

Check this if you have a graphical interface:
how-to-upgrade-ubuntu-710-to-ubuntu-804

Howto make an if statement in a job step in MSSQL

I ran into a little problem where I wanted to check a flag in a table to see if the sql job should be run or not.

I'm not sure if it's the right way or the nicest way to do this, but it works.

In the first step do:

if (SELECT count(*) FROM update WHERE ) = 0

begin

RAISERROR( 'Not ready to update.' , 16, 1 )

end

Got the syntax from this tread http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23094297.html

Set the On success to Goto next step (as default) to proceed with following job steps. You could set the On failure to Quit with success to avoid the errors in the history since it's an expected error that is raised.