Trouble installing on Jodohost - MSSQL connection error

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

What operating system were you running when the bug appeared?
What database platform is your site using?
What version of mojoPortal are you running?
What version of .NET do you use?
What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

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

12/2/2007 11:14:16 AM

Joe Audette

Total Posts 18439

View Posts

Re: Trouble installing on Jodohost - MSSQL connection error

Please type a space in the Web.config and re-upload it this should recycle the application. If your control panel has a tool to recycle also use that. Then visit yoursiteroot/Setup/Default.aspx

If you get an error again post more of the error message.

Use of System.Reflection is not supported under medium trust but this code is not called from the setup page so I don't know why its throwing this exception. System.Reflection is used only for loading WebParts from dlls in the bin but this code should not be getting invoked unless you are in WebPart Administrator page.

Joe

12/2/2007 11:17:49 AM

Joe Audette

Total Posts 18439

View Posts

Re: Trouble installing on Jodohost - MSSQL connection error

Also if you had any problems while uploading the new files try doing it again one folder at a time to make sure all the files got replaced. Also delete Janrain.dll from the bin folder if it is there from your previous upload of 2.2.3.9

Joe

12/2/2007 11:36:39 AM

daverozelle

Total Posts 14

View Posts

Re: Trouble installing on Jodohost - MSSQL connection error

OK, new user.config and new web.config files are uploaded... now the setup page just hangs and comes back not responding eventually. :( GRRR!

12/2/2007 11:42:12 AM

daverozelle

Total Posts 14

View Posts

Re: Trouble installing on Jodohost - MSSQL connection error

OK, closed browser, walked away and came back. Usually fixes all 'hanging' problems and sure enough it did. Here is my current error:

Probing system...
File system permissions ok.
MSSQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema needs to be created.

Server Error in '/' Application.
Session state has created a session id, but cannot save it because the response was already flushed by the application.
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.Web.HttpException: Session state has created a session id, but cannot save it because the response was already flushed by the application.

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:

[HttpException (0x80004005): Session state has created a session id, but cannot save it because the response was already flushed by the application.]
System.Web.SessionState.SessionIDManager.SaveSessionID(HttpContext context, String id, Boolean& redirected, Boolean& cookieAdded) +2220274
System.Web.SessionState.SessionStateModule.CreateSessionId() +55
System.Web.SessionState.SessionStateModule.DelayedGetSessionId() +64
System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs) +328
System.Web.SessionState.SessionStateModule.OnEndRequest(Object source, EventArgs eventArgs) +152
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

I have made sure the web.config and user.config are new and uploaded, and the Janrain.dll was deleted already. Any idea?

12/2/2007 11:50:27 AM

Joe Audette

Total Posts 18439

View Posts

Re: Trouble installing on Jodohost - MSSQL connection error

I have not encountered that error before. The setup page uses Response.Buffer, Response.Write and Response.Flush to update the page as things progress and the Flush is apparently causing some error in saving session state. But session state is not used in mojoPortal so if your control panel has a way to turn that off maybe it can get past this error and complete the setup. Its anIIS setting, not sure if its exposed to you in your control panel.

I do not get this error when I run in medium trust locally. Maybe I can try to cause it by configuring session state and see if I can trap that error. I'm heading out for the afternoon for a family get togather though.

Joe

12/2/2007 4:59:03 PM

daverozelle

Total Posts 14

View Posts

Re: Trouble installing on Jodohost - MSSQL connection error

The plot thickens....

I get the above mentioned error from Firefox, but I get a completely different error from IE:

Probing system...
File system permissions ok.
MSSQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema needs to be created.

An Error Occurred:Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
Source:mscorlib
Stack Trace at System.Reflection.Module.GetTypesInternal(StackCrawlMark& stackMark) at System.Reflection.Assembly.GetTypes() at mojoPortal.Business.WebHelpers.WebPartHelper.GetWebPartsFromAssemblies() at mojoPortal.Web.mojoSetup.RunningInFullTrust() 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)

Now I am REALLY confused.

12/3/2007 10:00:11 AM

Joe Audette

Total Posts 18439

View Posts

Re: Trouble installing on Jodohost - MSSQL connection error

Hi,

Well this is the same error as in one of your previous posts.

The good news is I'm able to replicate this problem here in IIS on Vista. Since this error didn't used to happen under medium trust I can only guess its a tightening of security either in IIS7 or in the recent service pak for the .NET framework.

I'm looking into it now and will post again as soon as I have a solution. I will follow up with a new package for medium trust that can get past this exception.

Thanks,

Joe

12/3/2007 11:04:08 AM

Joe Audette

Total Posts 18439

View Posts

Re: Trouble installing on Jodohost - MSSQL connection error

I have this fixed locally. I will upload a new package of files later today and post again when its available.

Thanks,

Joe

12/3/2007 3:20:24 PM

daverozelle

Total Posts 14

View Posts

Re: Trouble installing on Jodohost - MSSQL connection error

Well I can't tell you how good it feels to know that it's not just me and that I am going crazy or something. As of this afternoon, I am getting the same error message in IE and Firefox (the source=mscorlib) and am awaiting your new package...

Will I have to upload the whole site again?

12/3/2007 3:43:12 PM

Joe Audette

Total Posts 18439

View Posts

Re: Trouble installing on Jodohost - MSSQL connection error

Ok, the new package is ready to download on our download page. I made one package but easy instructions to change to medium trust configuration. Its in the Readme.txt but is as follows:

Set your connection string in the user.config file

If your site is hosted in Medium Trust:

1. delete the JanrainRain.OpenId.dll from the bin folder
2. Rename the Web.config to Web.config.old
3. Rename Web.config.mediumtrust to Web.config
4. Set RunningInMediumTrust = true in user.config

You can safely skip on re-uploading the Data folder and the ClientScript folder, those are 2 big folders so that may help. To be on the safe side I'd upload all the rest.

The download package is named mojoportal-2-2-4-0-preview-mssqlreleasefiles.zip

Should work better this time. Let me know how it goes.

Best,

Joe

12/3/2007 4:13:16 PM

daverozelle

Total Posts 14

View Posts

Re: Trouble installing on Jodohost - MSSQL connection error

Followed your instructions, and also had to update the (<add key="Lucene.Net.lockdir" value="D:\hshome\rozecommsp\mojo.rozecomm.com\Data\Sites\1\index" />) line in web.config, but it installed no problem and quickly I might add. Thank you for working with me on this, I am sure I will be back with other questions soon. :)

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