Sunday, November 7, 2010

Setting up mojoportal on windows 7 64bit with sqlite

Yes ... these are all technically evaluated requirements :)

Just downloaded and extracted the "mojoportal-2-3-5-5-sqlite-net35-deploymentfiles.zip" file. 
Renamed "user.config.sample" to "user.config"
Defined a new website in IIS 7.5.

Anyways, First off I noticed my IIS was not working with ASP.net Error
Calling LoadLibraryEx on ISAPI filter 
Fixed it using the following: 
cd C:\Windows\Microsoft.NET\Framework\v2.0.50727
aspnet_regiis -ir

Next I got the following error: 
There is a duplicate 'system.web.extensions/scripting/scriptResourceHandler' section defined

This is because we are using .NET 4.0 on a .NET 3.5 website :) 
Just go to IIS application pools and change the runtime to .net 2.0 as shown: 


Got the following error:

An attempt was made to load a program with an incorrect format

Lazy of me. They did mention this one. http://www.mojoportal.com/sqlitesetup.aspx
Did exactly as they pointed out: 



Again navigated to:
http://localhost:8080/Setup/Default.aspx

Got the following Error:
Could not load file or assembly 'WebStore.UI' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded


Downloaded the source code changeset linked to the 2.3.5.5 release.
Extracted and Opened mojoportal.net35.sln
Right clicked "WebStore.UI.net35" Project in the solution and chose "Build"
Luckily ... it just built :)

Copied the WebStore.UI file from "\WebStore.UI\bin" folder in the source to the website.

This time setup ran fine :) But I got the following Error:
mojoSetup has detected that the database user does not have permission to alter the database schema. You need to correct this or provide a connection string with sufficient permission.

I deleted the "mojo.db.config" that came with the zip file.
ran the following after cd "Data\sqlitedb"
sqlite3.exe mojo.db.config

.read initdb.config
.exit

Now setup ran fine and everything works :)

Long live mojoPortal!

Enjoy!