MojoPortal Setup Error

8/5/2011 8:25:51 AM

Rick Treharne

Total Posts 22

View Posts

Tried to edit the password to "0" now I get this.

Welcome to mojoPortal Setup
Probing system...
File system permissions ok.
SQLite database connection ok.

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.

An Error Occurred:File opened that is not a database file file is encrypted or is not a database
Source:Mono.Data.Sqlite
Stack Trace at Mono.Data.Sqlite.Sqlite3.Prepare(String strSql, SqliteStatement previous, String& strRemain) at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand() at Mono.Data.Sqlite.SqliteCommand.GetStatement(Int32 index) at Mono.Data.Sqlite.SqliteDataReader.NextResult() at Mono.Data.Sqlite.SqliteDataReader..ctor(SqliteCommand cmd, CommandBehavior behave) at Mono.Data.Sqlite.SqliteCommand.ExecuteReader() at Mono.Data.Sqlite.SqliteConnection.Schema_Tables(String strCatalog, String strTable, String strType) at Mono.Data.Sqlite.SqliteConnection.GetSchema(String collectionName, String[] restrictionValues) at mojoPortal.Data.DBPortal.DatabaseHelperTableExists(String tableName) at mojoPortal.Data.DBPortal.DatabaseHelperSitesTableExists() at mojoPortal.Web.UI.Pages.SetupHome.ProbeSystem() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

8/5/2011 8:37:14 AM

Rick Treharne

Total Posts 22

View Posts

Re: MojoPortal Setup Error

Is there a way to uninstall MojoPortal and to just reinstall and start over? I abandoned this project a while back, and seriously, would just rather start over than do backtracking and troubleshooting.

8/5/2011 8:55:36 AM

Joe Audette

Total Posts 18439

View Posts

Re: MojoPortal Setup Error

Sounds like your sqlite database got corrupted or something. Sqlite databases are just a file on disk. You could download the latest version of mojoPortal for Sqlite and just replace all the files with the new version, that would overwrite the database file with a new one.

Myself I would not use Sqlite, our SqlCE package is similar in that it is a file based database but it is a little more robust than Sqlite. But if you change to SQL Ce, I would just install it again in a new location or delete all the existing files if you want to install it in the same location.

The main benefits of Sqlite and SqlCE is that it does not require any database server software installed so deployment and installation are easier, but these databases are only good for low to medium traffic sites. If you plan a site to get a lot of traffic it is better to use a server based database like MS SQL or MySql.

Hope that helps,

Joe

8/5/2011 10:42:25 AM

Rick Treharne

Total Posts 22

View Posts

Re: MojoPortal Setup Error

Ok...Thanks Joe. Downloaded latest version, tried to bring up Mojo, and this is what I received next.

Server Error in '/' Application.
--------------------------------------------------------------------------------

Index was outside the bounds of the array.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: Index was outside the bounds of the array.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[IndexOutOfRangeException: Index was outside the bounds of the array.]
   Mono.Data.Sqlite.SqliteDataReader.GetSqliteType(Int32 i) +194
   Mono.Data.Sqlite.SqliteDataReader.GetValue(Int32 i) +38
   Mono.Data.Sqlite.SqliteDataReader.get_Item(String name) +27
   mojoPortal.Business.SiteUser.GetUser(IDataReader reader) +3221
   mojoPortal.Business.SiteUser.GetUser(String loginInfo) +109
   mojoPortal.Business.SiteUser..ctor(SiteSettings settings, String login) +837
   mojoPortal.Web.SiteUtils.GetCurrentSiteUser(Boolean bypassAuthCheck) +380
   mojoPortal.Web.SiteUtils.TrackUserActivity() +756
   mojoPortal.Web.Global.Application_EndRequest(Object sender, EventArgs e) +45
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +148
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

8/5/2011 10:58:08 AM

Joe Audette

Total Posts 18439

View Posts

Re: MojoPortal Setup Error

Did you visit the /Setup/Default.aspx page?

8/5/2011 12:11:36 PM

Rick Treharne

Total Posts 22

View Posts

Re: MojoPortal Setup Error

I get a 503 error now when attempting to visit the Setup/default.aspx page. Previous error does not appear on the browser. Using I.E. 8.

8/5/2011 12:16:16 PM

Rick Treharne

Total Posts 22

View Posts

Re: MojoPortal Setup Error

For whatever reason....I stopped the site on IIS....let it sit for a while....restarted IIS....and now it appears as thought the setup script is running. Completed actually. Now on the Site Home Page though....I have Mojo Portal up....but the background is completely white..like a blank html page with just some links like Home, Site Map, My Account etc. No Pencil Icons, Gears or any other graphics.

8/5/2011 12:20:06 PM

Rick Treharne

Total Posts 22

View Posts

Re: MojoPortal Setup Error

When clicking on the Settings Link I get the System.IndexOutOfRangeException error as posted previously upstream in this thread.

Should I delete the site from IIS, delete the directories uploaded to my root, and start from scratch?

8/7/2011 5:49:53 PM

IndigoTea

Total Posts 355

View Posts

Re: MojoPortal Setup Error

Rick,

If you haven't resolved this by now, it may be for the best to start from scratch, and see if the issue recurs. With the changes and improvements between versions, it may be less of a headache for you to start fresh, and avail yourself of the latest upgrades and improvements. Keep us posted on your progress!

8/9/2011 11:28:43 AM

Rick Treharne

Total Posts 22

View Posts

Rebuilt the webesrver

Running Datacenter 2008 R2 in a virtual environment.

IIS 6.1

ASP.net 3.5.1

SQLite.

Here is where I am having trouble. In my application pool on IIS for my site, the Identity is Application Pool Identity. I know I have to assign this identity rights to the App Data folder, and Data folder to write.

I cannot seem to give permissions to ApplicationPoolIdentity to those two directories. Should I make a domain account or something, assign that as the Identity for the application pool, and then give that account rights to app data, and data folder?

8/9/2011 11:54:22 AM

Joe Audette

Total Posts 18439

View Posts

Re: MojoPortal Setup Error

Hi Rick,

In 2008/IIS7+ the ApplicationPoolIdentity accounts are hidden accounts that have dynamically assigned SID's (created and assigned when the ApplicationPool is started). But the accounts live as (hidden) users under the IIS_IUSRS group on the local machine.

Give Read/Write permissions for the IIS_IUSRS group to the folder (permissions will inherit down to all folders).

If that doesn't work for you then the easiest thing to do would be to change the identity on the app pool to NETWORK SERVICE and then give that user the permissions.

Hope that helps,

Joe