can't install on sql2000 - aruba - with strange message

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.
7/21/2009 9:37:03 AM
Gravatar
Total Posts 122

can't install on sql2000 - aruba - with strange message

hallo... I'm in trouble since 2 weeks and I can't figure out !!!

I want to host on a provider witch assigned me those elements

Server: webs1142
Host DataBase: 62.149.153.21
Nome DataBase: MSSqlmiki
Login DataBase: MSSqlmiki
PassWord DataBase: a6ce9ad6

database is SQL2005-2007

The provider created a user called MSSqlmiki with dbo permissions as
- db-datareader
- db-datawriter


The provider (www.aruba.it, ...one of the greatest in italy) DOES NOT accept to change user permission
and says that instead of using "[dbo]." in scripts or db calls I have to put "[MSSqlmiki]."

 

Now, the scenario is the following:

0) I used mojoportal-2-3-1-0-mssql-deploymentfiles.zip

1) I'have done a replace on ALL exixsting [dbo] entries with [MSSqlmiki]

2) I'have set user_config parameter as

<add key="MSSQLConnectionString" value="server=webs1142;UID=MSSqlmiki;PWD=a6ce9ad6;database=MSSqlmiki" />

3) I'have set web_config parameter as

<add key="MSSQLConnectionString" value="server=webs1142;UID=MSSqlmiki;PWD=a6ce9ad6;database=MSSqlmiki" />

4) I run http:\\webname\setup\default.aspx and get always this message:

<<We're sorry but a server error has occurred while trying to process your request.

The error has been logged and will be reviewed by our staff as soon as possible. It is possible that the error was just a momentary hiccup and you may wish to use the back button and try again or go back to the home page. >>


What can I do ?????? HELPPP !!
thanck you all from Michele Ciotti - Italy

7/21/2009 12:49:56 PM
Gravatar
Total Posts 18439

Re: can't install on sql2000 - aruba - with strange message

Hi,

First need to find out what the error is, see http://www.mojoportal.com/basic-troubleshooting.aspx for information to help find out the error.

There was no need to do find and replace on the scripts so its probablly best to restore them as they were.

You can edit this setting in Web.config or ideally put it in user.config

<add key="MSSQLOwnerPrefix" value="[dbo]." />

you should change it to 

<add key="MSSQLOwnerPrefix" value="[MSSqlmiki]." />

and we have a built in thing that will replace the [dbo]. in the scripts before executing them. As long as I've been consistent in the use of [dbo]. then it should hopefully work.

Hope it helps,

Joe

7/21/2009 3:34:34 PM
Gravatar
Total Posts 122

Re: can't install on sql2000 - aruba - with strange message

hi mister... sob.. nothing changes.. and I can't find the famous /Data/currentlog.config sigh !!!

I:

1) reloaded all files

2) changed user.config

<add key="MSSQLConnectionString" value="server=62.149.153.21;UID=MSSql31184;PWD=a6ce9ad6;database=MSSql31184" />

added key:

<add key="MSSQLOwnerPrefix" value="[MSSql31184]." />

3) leaved web.config in standard mode

resault:

<<We're sorry but a server error has occurred while trying to process your request.

The error has been logged and will be reviewed by our staff as soon as possible. It is possible that the error was just a momentary hiccup and you may wish to use the back button and try again or go back to the home page.
>>

now it's not a matter of one beer, its a full dinner when you will come to rome.. hehehehe

help me !!!

 

 

 

 

 

7/22/2009 6:37:27 AM
Gravatar
Total Posts 18439

Re: can't install on sql2000 - aruba - with strange message

Hi,

Dinner in Rome would be a dream come true, maybe one day ;-)

I think you missed part of the troubleshooting tips, it was poorly written/organised, I've updated the article to make it clearer. Please see the part about disabling the friendly error page so you can see the real error and the part about what it means if the log file does not exist.

http://www.mojoportal.com/basic-troubleshooting.aspx

Hope it helps,

Joe

7/22/2009 8:44:22 AM
Gravatar
Total Posts 122

Re: can't install on sql2000 - aruba - with strange message

hi,

I've done it (change web.config) but this comes back:

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

Reference to an object not set to an instance of object.
Description:An unhandled exception occurred during the execution of the current web request. For more information about the error and where it originated in the code, see the analysis of the stack.

Exception Details:System.NullReferenceException: Reference to an object not set to an instance of object.

Error in source code:

During the execution of the current web request has been generated an unhandled exception. For information about the location and the exception, see the analysis of the stack from the exception below.

Analysis of the stack:


[NullReferenceException: Reference to an object not set to an instance of object.]
Brettle.Web.NeatUpload.MultiRequestUploadModule.get_UploadPath () +38
Brettle.Web.NeatUpload.UploadHttpModule.Application_BeginRequest (Object sender, EventArgs e) +309
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute () +68
System.Web.HttpApplication.ExecuteStep (IExecutionStep step, Boolean & completedSynchronously) +75

 


--------------------------------------------------------------------------------
Version information:Version of Microsoft. NET Framework: 2.0.50727.3082; ASP.NET Version: 2.0.50727.3082

Here is how I changed web.config:

<!-- CUSTOM ERROR MESSAGES
Set customErrors mode="On" or "RemoteOnly" to enable custom error messages, "Off" to disable.
Add <error> tags for each of the errors you want to handle.

"On" Always display custom (friendly) messages.
"Off" Always display detailed ASP.NET error information.
"RemoteOnly" Display custom (friendly) messages only to users not running
on the local Web server. This setting is recommended for security purposes, so
that you do not display application detail information to remote clients.


-->
<customErrors mode="Off" defaultRedirect="Error.htm">
<error statusCode="413" redirect="~/NeatUpload/Error413.aspx" />
</customErrors>
<!-- set enabled to true if you want to trace -->
<trace enabled="false" writeToDiagnosticsTrace="true" requestLimit="50" pageOutput="true" traceMode="SortByTime" localOnly="false" />

 

7/22/2009 8:52:16 AM
Gravatar
Total Posts 18439

Re: can't install on sql2000 - aruba - with strange message

Possible causes

1. Based on the version at the bottom of the error I have a feeling this machine does not have .NET 3.5 SP1 installed

2. It is also likely that you are hosted in Medium Trust, see  http://www.mojoportal.com/mediumtrust.aspx

Hope it helps,

Joe

7/22/2009 9:18:56 AM
Gravatar
Total Posts 122

Re: can't install on sql2000 - aruba - with strange message

hi Joe... a little task more performed...

now I get this exception... and i dont know what it means..

Checking the system ...
Encountered problems of file system privileges.

An Error Occurred:Can not find a part of the path 'D: \ Inetpub \ webs \ itawanit \ Data \ Sites \ 1 \ GalleryImages \ test.config'.
Source:mscorlib
Stack Trace in System.IO.__Error.WinIOError (Int32 errorCode, String maybeFullPath) in System.IO.FileStream.Init (String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, Fileshare share, Int32 Buffersize, FileOptions options, SECURITY_ATTRIBUTES secAttrs , msgPath String, Boolean bFromProxy) at System.IO.FileStream .. ctor (String path, FileMode mode, FileAccess access, Fileshare share, Int32 Buffersize, FileOptions options) in System.IO.StreamWriter.CreateFile (String path, Boolean append) in System.IO.StreamWriter .. ctor (String path, Boolean append, Encoding encoding, Int32 Buffersize) in System.IO.StreamWriter .. ctor (String path, Boolean append) at System.IO.File.CreateText (String path) in mojoPortal.Web.mojoSetup.TouchTestFile (String pathToFile) in mojoPortal.Web.UI.Pages.SetupHome.GetFolderDetailsHtml () in mojoPortal.Web.UI.Pages.SetupHome.ProbeSystem () in mojoPortal.Web.UI.Pages.SetupHome . Page_Load (Object sender, EventArgs e) at System.Web.UI.Control.OnLoad (EventArgs e) System.Web.UI.Control.LoadRecursive () at System.Web.UI.Page.ProcessRequestMain (Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

7/22/2009 9:25:11 AM
Gravatar
Total Posts 18439

Re: can't install on sql2000 - aruba - with strange message

That means its trying to create test files to make sure it has correct file system permissions but it can't create the files because permissions are wrong. 

You need to make the /Data folder writable by the web process so it can create files and sub folders there as needed.

Hope it helps,

Joe

7/22/2009 9:49:47 AM
Gravatar
Total Posts 122

Re: can't install on sql2000 - aruba - with strange message

hi joe,

i'm checking with ARUBA (hosting provider) if it is possible to give full permissions  to "\DATA" ...

for now it seems not possible because they told me that their ONLY folder that has full permissions is called "\public"

do you have even made customizable the name of this directory ??? How ??

best regards

Michele Ciotti

7/22/2009 10:04:07 AM
Gravatar
Total Posts 18439

Re: can't install on sql2000 - aruba - with strange message

Sorry but no, the Data folder must be writable there is no way to configure to use a different folder unless maybe you can create a virtual directory "Data" that maps to public and then put the files in public, maybe that can work.

Hopeit helps,

Joe 

7/22/2009 10:06:17 AM
Gravatar
Total Posts 122

Re: can't install on sql2000 - aruba - with strange message

hi joe...

checked (sob !!)...

they confirm me that only the directory "\public" has the right permissions !!!

then they proposed me to change to a linux platform.. but with Mysql , obviuously not 2.0 or 3.5 aspnet, etc...

Does mojoportal work on linux ??

... I'm living a drama !!! (but the rome - dinner is still confirmed.. hehehe)

Michele

 

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