connection string installation after 2 days struggling

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.
8/12/2010 8:20:16 AM
Gravatar
Total Posts 4

connection string installation after 2 days struggling

 

 

Please can someone help me with the right connection string

 

server IP = 123.123.123.123.4

databasename = test1

database = testuser

password = testuser01?

 

i uploaded all files, gave the right permissions to the folders, but where and what do i need to change in the web.config or user.config or both.

Please help

I just want 1 installtion and go further with it.

Ber

 

8/12/2010 8:25:12 AM
Gravatar
Total Posts 18439

Re: connection string installation after 2 days struggling

If the user.config file exists then you must put the connection string there because it trumps any connection string in Web.config.

However, if you make a change to user.config it is not automatically detected, so you have to touch Web.config to make it reload settings.

http://www.mojoportal.com/webconfig.aspx

Hope it helps,

Joe

8/12/2010 8:35:26 AM
Gravatar
Total Posts 4

Re: connection string installation after 2 days struggling

Joe

 

Thank you

 

I got this from my hosting provider, but it look s different then in the web.config file

<!-- Connection String for SQL Server 2000/2005 -->
<add name="SiteSqlServer" connectionString="Data Source=123.123.123.3;Initial Catalog=bmcombm451;User ID=blabla23;Password=blabla" providerName="System.Data.SqlClient" />
</connectionStrings>

 

could you give me an example

thank you

Ber

8/12/2010 8:44:21 AM
Gravatar
Total Posts 18439

Re: connection string installation after 2 days struggling

We don't use connection strings from the connectionStrings section but from appSettings

you need something like this in user.config

<add key="MSSQLConnectionString" value="Data Source=123.123.123.3;Initial Catalog=bmcombm451;User ID=blabla23;Password=blabla" />

then touch Web.config to make it reload settings

Hope it helps,

Joe

8/12/2010 8:44:39 AM
Gravatar
Total Posts 2254

Re: connection string installation after 2 days struggling

Hi Ber,

Your hosts' example will not work because the key isn't named properly.

The included user.config.sample and web.config both have an example and the Installation Quick Start also has an example. For quick reference, here is another example, using the values from your post:

<add key="MSSQLConnectionString" value="server=123.123.123.4;UID=testuser;PWD=testuser01?;database=test1" />

You should put this in your user.config.

HTH,
Joe D.

8/12/2010 9:52:42 AM
Gravatar
Total Posts 4

Re: connection string installation after 2 days struggling

Hi

 

I tried the connection string with the correct details but i got still a yellow screen with this

 

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

Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".


<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
 

Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.


<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>
 

i tried to add that to the web.config file but still ´get that same screen.

what a shame, i really want to get it work but i still don´t know anymore

Anyone had the same experiences?

ber
 

8/12/2010 9:59:52 AM
Gravatar
Total Posts 18439

Re: connection string installation after 2 days struggling

do what the message says so you can find out what error is happening

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

8/12/2010 10:02:24 AM
Gravatar
Total Posts 18439

Re: connection string installation after 2 days struggling

most likely you need to configure for medium trust

http://www.mojoportal.com/mediumtrust.aspx

or you have the wrong version of the .NET framework, we ship separate packages for 3.5 and 4.0 .NET

8/12/2010 11:55:13 AM
Gravatar
Total Posts 4

Re: connection string installation after 2 days struggling

thank you very much for your help,

My server is running on asp.net 3.5

the filename i downloaded is this one

mojoportal-2-3-4-8-mssql-net35-deploymentfiles.zip

Is this Ok?

I will give it another try tomorrow.

I will let you know

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