MojoPortal Setup Error

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
8/5/2011 8:25:51 AM
Gravatar
Total Posts 22

MojoPortal Setup Error

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
Gravatar
Total Posts 22

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
Gravatar
Total Posts 18439

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
Gravatar
Total Posts 22

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
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

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

8/5/2011 12:11:36 PM
Gravatar
Total Posts 22

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
Gravatar
Total Posts 22

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
Gravatar
Total Posts 22

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
Gravatar
Total Posts 355

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
Gravatar
Total Posts 22

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
Gravatar
Total Posts 18439

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

 

8/9/2011 11:57:45 AM
Gravatar
Total Posts 22

Re: MojoPortal Setup Error

Sorry to bother you Joe....I researched and found them myself.  I am a novice to this stuff, and it's first time for me.  I was able to apply the permissions, and I think I was able to modify the user.config correctly.

 

Now when I try to access the site, I get HTTP Error 500.19 Internal Server error

 

Internet Information Services 7.5
Error Summary
HTTP Error 500.19 - Internal Server Error
The requested page cannot be accessed because the related configuration data for the page is invalid. Detailed Error Information
Module IIS Web Core
Notification Unknown
Handler Not yet determined
Error Code 0x80070032
Config Error The configuration section 'system.serviceModel' cannot be read because it is missing a section declaration 
Config File \\?\C:\inetpub\wwwroot\Domain\web.config
Requested URL http://Domain:80/
Physical Path 
Logon Method Not yet determined
Logon User Not yet determined
Config Source
1143:   </system.web.extensions>
1144:   <system.serviceModel>
1145:     <services>

8/9/2011 12:06:38 PM
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

Make sure you are using a .NET 4 application pool. If all else fails you can comment out or remove the entire <system.serviceModel section, it is only needed for things like being able to authenticate from a Silverlight app, since we don't ship any Silverlight apps in mojoPortal that use it, it really isn't needed.

Actually in the 2.3.6.7 release of mojoPortal this should already be commented out.

Hope that helps,

Joe

8/9/2011 12:13:47 PM
Gravatar
Total Posts 22

Re: MojoPortal Setup Error

I'm using ASP.net 3.5.1  Looking at the Application Pool, it only gives me two choices.  No Managed Code and >Net Framework v2.0 50727

8/9/2011 12:16:51 PM
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

ok, just remove that section

8/9/2011 12:20:38 PM
Gravatar
Total Posts 22

Re: MojoPortal Setup Error

It's already commented out in web.config.

8/9/2011 12:23:40 PM
Gravatar
Total Posts 22

Re: MojoPortal Setup Error

I'm missing something somewhere because I had a site set up on this server before and it worked fine.  I don't think you actually have to create a DB and DB user for SQLite, as it's already done for you....correct?

 

This is a rebuild so, I'm not sure what step I may have left out. 

8/9/2011 12:41:36 PM
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

are you sure you installed SP1 for .NET 3.5?

Note that to use Sqlite you'll need to edit the advanced propertieson the applicaiton pool and set Enable32BitApps = true because the sqlite3.dll is a 32 bit dll

Hope that helps,

Joe

8/9/2011 1:12:06 PM
Gravatar
Total Posts 22

Re: MojoPortal Setup Error

Could IIS 7.5 be messing me up?

8/9/2011 1:30:47 PM
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

if its already commented out it should not give that error, maybe thats an older error I would look for other errors.

This is suspiciously similar to the 9th and 10 items in our FAQ, but it isn't complaining about the same section.

My question for you is why are you using .NET 3.5? For any new site I can't see any reason to use it. .NET 4 has been out a long time now and we won't continue supporting .NET 3.5 forever and there are many benefits to using .NET 4. I would install .NET 4 and start over with the mojoPortal package for .NET 4. I also don't see any benefit to using Sqlite, if you want a file based database then SQL CE is a better choice and performs better and also using that at least you have the potential to easily migrate to SQL Server later.

Hope that helps,

Joe

8/9/2011 1:31:39 PM
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

although actually any typo in Web.config could cause that error and the message could be misleading

8/9/2011 1:58:59 PM
Gravatar
Total Posts 22

Re: MojoPortal Setup Error

Replace Web.config and user.config with new clean copies.

 

Get this error now.  Also made sure that SP1 was installed.

 

Module IIS Web Core
Notification BeginRequest
Module IIS Web Core
Notification BeginRequest
Handler Not yet determined
Error Code 0x80070021
Config Error This configuration section cannot be used at this path. This happens when the section is locked at a parent level. Locking is either by default (overrideModeDefault="Deny"), or set explicitly by a location tag with overrideMode="Deny" or the legacy allowOverride="false". 
Config File \\?\C:\Websites\domain\web.config
Requested URL http://www.domain.com:80/
Physical Path C:\Websites\Domainname
Logon Method Not yet determined
Logon User Not yet determined
Config Source
1091:     <!-- Handlers for IIS 7.0 Integrated mode -->
1092:     <handlers>
1093:       <remove name="WebServiceHandlerFactory-Integrated"/>
Links and More InformationThis error occurs when there is a problem reading the configuration file for the Web server or Web application. In some cases, the event logs may contain more information about what caused this error.
View more information »

8/9/2011 2:16:37 PM
Gravatar
Total Posts 22

Re: MojoPortal Setup Error

user.config connection string.

 

<add key="SqliteConnectionString" value="version=3,URI=file:C:\\Websites\Domain Name\Data\sqlitedb\mojoportal.db" />
 

  <add key="SqliteConnectionString" value="defaultdblocation" />

 

Web.config

<add key="SqliteConnectionString" value="defaultdblocation"/>
    <!--
   you can use a fully qualified file path as shown below
   or if you are using the default db at /Data/sqlitedb/mojo.db.config
   just leave this set to "defaultdblocation"
  <add key="SqliteConnectionString" value="version=3,URI=file:C:\\Projects\mojoportal\Web\Data\sqlitedb\mojoportal.db" />
  -->

8/9/2011 2:44:15 PM
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

If there is another Web.config file in the C:\Websites folder I would try removing it as it is likely causing a conflict with the one in the Domains subfolder.

Hope that helps,

Joe

8/9/2011 3:11:13 PM
Gravatar
Total Posts 22

Re: MojoPortal Setup Error

There is only one user.config file.

IIS 7.5 ASPNET 3.5 SP1

Do the strings in user.config, and web.config look ok?

8/10/2011 1:54:40 PM
Gravatar
Total Posts 22

Re: MojoPortal Setup Error

No takers on this.  Someone has got to know why this set up is causing me issues.

8/10/2011 2:02:43 PM
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

the most recent error you posted is about a conflict with another Web.config file, as I asked you in my previous post but you responded about user.config which is not what I asked about. user.config can only override the <appSettings section

so you either have another Web.config file in a folder above the site or if not physically above it then above it as a virtual directory somehow by IIS configuration, or you have a machine that has been locked down with very tight settings in machine.config either by direct configuration or if the machine is a member of a windows domain it could be pushed down by group policy.

 

 

8/10/2011 2:06:23 PM
Gravatar
Total Posts 355

Re: MojoPortal Setup Error

I don't work with SqlLite, so I'm not much help there. Question: is Joe's suggestion to try SQL CE viable, or is there a business requirement to use the SqlLite?

8/10/2011 2:30:29 PM
Gravatar
Total Posts 55
mojoPortal Community Expert
Arvixe Web Hosting / mojoPortal Community Liaison Looking for quality mojoPortal hosting? Try Arvixe Check out the MojoPortal Blogs at Arvixe

Re: MojoPortal Setup Error

Hi,

I know less than nothing about sqlLite & this may be irrelevant but I noticed

<add key="SqliteConnectionString" value="version=3,URI=file:C:\\Websites\Domain Name\Data\sqlitedb\mojoportal.db" />

has a double backslash after c: and single backslashes afterwards.

8/10/2011 2:45:45 PM
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

You are right about the extra backslash, but this error isn't about the database, its a configuration issue with ASP.NET and IIS, it is failing to load the Web.config file and the most recent error sounds like a conflict with another Web.config file is the cause.

Only other thing is I would not use folders with spaces in the name in the path to the web site. It isn't clear to me if the path is C:\WebSites\DomainName, or C:\WebSites\Domain Name which I would not use and could cause a problem.

Best,

Joe

8/10/2011 2:51:22 PM
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

Actually I think that extra backslash is correct, that is the example in user.config, but you don't really have to specify the path if keeping it under the default location /Data/sqlitedb you can just put

<add key="SqliteConnectionString" value="defaultdblocation" />

what he posted with a path is in comments and not used, or if it is not in comments and is exactly like this:

<add key="SqliteConnectionString" value="version=3,URI=file:C:\\Websites\Domain Name\Data\sqlitedb\mojoportal.db" />


  <add key="SqliteConnectionString" value="defaultdblocation" />

the bottom one wins

Best,

Joe

8/10/2011 2:55:27 PM
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

looking back at the error again, I would suggest make sure you are using an Integrated App pool not Classic

Hope that helps,

Joe

8/10/2011 2:57:04 PM
Gravatar
Total Posts 22

Re: MojoPortal Setup Error

I've tried numerous ways to specify paths including using the default DB location, and still get the 500.19 error.

 

Internet Information Services 7.5
Error Summary
HTTP Error 500.19 - Internal Server Error
The requested page cannot be accessed because the related configuration data for the page is invalid. Detailed Error Information
Module IIS Web Core
Notification BeginRequest
Handler Not yet determined
Error Code 0x80070021
Config Error This configuration section cannot be used at this path. This happens when the section is locked at a parent level. Locking is either by default (overrideModeDefault="Deny"), or set explicitly by a location tag with overrideMode="Deny" or the legacy allowOverride="false". 
Config File \\?\C:\Websites\Domain\web.config
Requested URL http://www.Domain.com:80/
Physical Path C:\Websites\Domain
Logon Method Not yet determined
Logon User Not yet determined
Config Source
1091:     <!-- Handlers for IIS 7.0 Integrated mode -->
1092:     <handlers>
1093:       <remove name="WebServiceHandlerFactory-Integrated"/>

8/10/2011 2:59:07 PM
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

The database talk was just side discussion it is not the cause of this error

Config Source
1091:     <!-- Handlers for IIS 7.0 Integrated mode -->
1092:     <handlers>
1093:       <remove name="WebServiceHandlerFactory-Integrated"/>

make sure you are using an Integrated Application pool

8/10/2011 2:59:56 PM
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

what is the structure of your url?

8/10/2011 3:09:49 PM
Gravatar
Total Posts 22

Re: MojoPortal Setup Error

Integrated is by default, and it is set as integrated.

By Structure do you mean path?

C:\Websites\Domain

The domain folder is where I dumped the contents of the mojoportal WWWRoot folder.

8/10/2011 3:16:46 PM
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

Are you actually accessing the site with http://www.Domain.com or some other url? 

Is it a root level site pointed directly at the C:\Websites\Domain folder?

Or does the url have another segment in it?

Or is it not a root site but under Default Web Site/some folder?

Is there another Web.config file in the C:\Websites folder? or in C:\?

8/10/2011 3:34:14 PM
Gravatar
Total Posts 22

Re: MojoPortal Setup Error

http://www.domain.com is how I am accessing the site in the browser.

The path for the website is C:\websites\Domain

The path in IIS 7.5 for the website is C:\websites\Domain

The contents copied from the WWWRoot folder from Mojoportal was copied into the C:\Websites\Domain folder.

I am running ASP.NET 3.5 SP1

 

There is only one web.config in the C:\websites\domain folder. 

I should note also that this is a virtual server, and that at one time I had mojo working here fine (older version)  The disk was formatted and OS reinstalled.  Datacenter 2008.

8/10/2011 3:58:06 PM
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

So you're using a hosts file entry to test with that domain I guess?

DataCenter 2008 seems a strange os for a single VM. Is it a cluster or web farm?

Is the machine part of a  windows domain where configurations could be pushed down by active directory and group policy rules?

8/10/2011 4:04:36 PM
Gravatar
Total Posts 22

Re: MojoPortal Setup Error

Its not a single VM...Data Center 2008 is typically used on ESXI servers "VMware" because it keeps costs low.  I have about 8 virtual servers.  The issue isn't virtualization.  I have other webservices running on other VMs just fine.

And I am not using a host file.  I believe I followed mojo installation instructions to a "T" albeit for a novice with websites, there could have been some more detail....kinda like mojo portal for dummies.  :-)

8/10/2011 4:10:25 PM
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

so you actually own the domain name http://www.domain.com? that is why I asked about a hosts file to see if you were spoofing the domain for testing

ok not just one vm but is it a cluster or web farm where a particular web request could hit any node? or is it single vm running the site?

8/10/2011 4:15:20 PM
Gravatar
Total Posts 18439

Re: MojoPortal Setup Error

I'm about out of ideas, maybe Data Center 2008 has more restrictive configuration by default than other flavors of Win 2008

sorry you are having this trouble but I've done about all I can to try to help you.

you never did answer why not .NET 4 and why Sqlite but those are tangential questions, but you also never answered about whether the machine is a domain member and that was relevant to the problem.

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.