2.1 Install Restore from Server Crash

rated by 0 users
Answered (Verified) This post has 2 verified answers | 11 Replies | 1 Follower

mytechroom
Not Ranked
10 Posts
Points 155
By: mytechroom
Posted: Sun, Mar 30 2008 11:46 PM

I have a 2.1 CS server that I have restored from backup. I have read some posts about how to restore a CS however when trying this I get an error on the page saying:

Oops something went wrong!

Either the site is offline or an unhandled error occurred. We apologize and have logged the error. Please try your request again or if you know who your site administrator is let them know too

I cant seem to find any logs, can someone help shed some light to this issue?

Thanks. 

 

 
  • Post Points: 20 |

Answered (Verified) Verified Answers

Alex Crome
Top 10 Contributor
2,780 Posts
Points 41,105
TelligentSupportTeam
Answered (Verified) By: Alex Crome
Posted: Sat, Apr 5 2008 1:04 PM In reply to

There's some form of problem with your database's connection string or SQL server as CS is unable to connect to the database.  Are you using SQL Express?  If so, try changing your server from (local) to (local)\SQLExpress.  If that's not the case then there's not a lot we can do from our end as the only information we're getting is CS cannot communicate with SQL Server - and that's either a problem with ASP.Net or SQL server, neither of which is Community Server.

As for support, if you have been maintaining your Gold Support, then you should contact Telligent directly as that's the only situation in which they guarantee a response to the question.

For the upgrade path, if you've maintained your Gold Support, then you'll be able to upgrade to CS2007 (and 2008 when it comes out) at no extra cost.  If not, you'll have to contact sales@telligent.com for further details about upgrading your license.

 
Answered (Verified)
  • Post Points: 20 |
Alex Crome
Top 10 Contributor
2,780 Posts
Points 41,105
TelligentSupportTeam
Answered (Verified) By: Alex Crome
Posted: Sat, Apr 5 2008 5:41 PM In reply to

That's perfectly standard.  Simply, ASP.Net will shut down the website if it hasn't been accessed for a length of time (typically 20 mins) to save resources.  If you want to change this, you'll need to change the settings on CS's App Pool in Internet Information Services.

 
Answered (Verified)
  • Post Points: 20 |

All Replies

Alex Crome
Top 10 Contributor
2,780 Posts
Points 41,105
TelligentSupportTeam
By: Alex Crome
Posted: Mon, Mar 31 2008 2:51 PM In reply to

in your web.config file, find the <customErrors> section, and change the mode attribute to "Off" (Note, this is CASE SENSITIVE, and must be Off, NOT OFF or off).

This won't fix your problem, but it'll tell you what the real error is, which you should be able to use to fix the problem.

 

When you've fixed the problem, make sure to set the mode attribute back to "RemoteOnly"

 
  • Post Points: 20 |
mytechroom
Not Ranked
10 Posts
Points 155
By: mytechroom
Posted: Tue, Apr 1 2008 12:20 PM In reply to

 Thank you that helped, However now I am seeing that I am having problems connecting to the DB. It gives this error:

When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I have checked the SQL Server configuration and Named Pipes as well as TCP/IP is enabled. No Firewall Enabled etc.

Any Ideas?

 

 
  • Post Points: 20 |
Alex Crome
Top 10 Contributor
2,780 Posts
Points 41,105
TelligentSupportTeam
By: Alex Crome
Posted: Tue, Apr 1 2008 2:27 PM In reply to

You probably need to update the connection strings to point to the restored database.  In your web.config file, can you check that the connectionstring specified for LocalSqlServer is valid for your database.  If you're not sure, you may have to ask your webhost for what the connection string should be.

 
  • Post Points: 20 |
mytechroom
Not Ranked
10 Posts
Points 155
By: mytechroom
Posted: Tue, Apr 1 2008 8:03 PM In reply to

 I dont see an area for LocalSQLServer setting but I do see these lines the DBName is valid.

<connectionStrings>
  <add name="SiteSqlServer" connectionString="server=(local);uid=;Trusted_Connection=yes;pwd=;database=DBNAME" />
 </connectionStrings>

<appSettings>
<add key="SiteSqlServer" value="server=(local);uid=;pwd=;Trusted_Connection=yes;database=DBNAME" />

 

 
  • Post Points: 5 |
mytechroom
Not Ranked
10 Posts
Points 155
By: mytechroom
Posted: Sat, Apr 5 2008 12:47 PM In reply to

 Is anyone moderating this topic any more?


I guess what I am needing is a clear guidline as to how to successfully move this Install to another server.  I have read some topics about this but its not working. (http://communityserver.org/forums/t/494618.aspx) How do I get help? This is on my server, I am fluent in SQL and IIS, I am an IT Admin... this should not be so difficult.

I paid for this system 2 years ago, and have never had problems with this system till our crash.
So this is not a FREE version, also I am a bit confused as to what the upgrade path is. Like this fellow: (http://communityserver.org/forums/t/494252.aspx)

Its not really clear how to upgrade from 2.1. I have also tried to follow the directions about running the SQL scripts, but it just bombs out with errors all over. (Of course I made backups thank GOD)

I would like to just get this site back up PLEASE.
Thank you.

 

 
  • Post Points: 20 |
Alex Crome
Top 10 Contributor
2,780 Posts
Points 41,105
TelligentSupportTeam
Answered (Verified) By: Alex Crome
Posted: Sat, Apr 5 2008 1:04 PM In reply to

There's some form of problem with your database's connection string or SQL server as CS is unable to connect to the database.  Are you using SQL Express?  If so, try changing your server from (local) to (local)\SQLExpress.  If that's not the case then there's not a lot we can do from our end as the only information we're getting is CS cannot communicate with SQL Server - and that's either a problem with ASP.Net or SQL server, neither of which is Community Server.

As for support, if you have been maintaining your Gold Support, then you should contact Telligent directly as that's the only situation in which they guarantee a response to the question.

For the upgrade path, if you've maintained your Gold Support, then you'll be able to upgrade to CS2007 (and 2008 when it comes out) at no extra cost.  If not, you'll have to contact sales@telligent.com for further details about upgrading your license.

 
Answered (Verified)
  • Post Points: 20 |
mytechroom
Not Ranked
10 Posts
Points 155
By: mytechroom
Posted: Sat, Apr 5 2008 2:30 PM In reply to

 

Wow your right I overlooked that it was local\SQLExpress. Thanks that did it!

It used to be Full SQL installed.

I cant believe it was that simple.

 

 
  • Post Points: 5 |
mytechroom
Not Ranked
10 Posts
Points 155
By: mytechroom
Posted: Sat, Apr 5 2008 5:03 PM In reply to

 Why would this event be posted to the log?

CS.Web Stopped CS.Web Stopped

_shutDownMessage=HostingEnvironment caused shutdown

_shutDownStack= at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
at System.Environment.get_StackTrace()
at System.Web.HttpRuntime.ShutdownAppDomain()
at System.Web.Hosting.HostingEnvironment.ShutdownThisAppDomainOnce()
at System.Web.Hosting.HostingEnvironment.InitiateShutdownWorkItemCallback(Object state)
at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)

 

 
  • Post Points: 20 |
Alex Crome
Top 10 Contributor
2,780 Posts
Points 41,105
TelligentSupportTeam
Answered (Verified) By: Alex Crome
Posted: Sat, Apr 5 2008 5:41 PM In reply to

That's perfectly standard.  Simply, ASP.Net will shut down the website if it hasn't been accessed for a length of time (typically 20 mins) to save resources.  If you want to change this, you'll need to change the settings on CS's App Pool in Internet Information Services.

 
Answered (Verified)
  • Post Points: 20 |
mytechroom
Not Ranked
10 Posts
Points 155
By: mytechroom
Posted: Sat, Apr 5 2008 11:11 PM In reply to

 Ok great. I have not maintained my Gold support. I was going to use this license for a comercial site but as it turns I never did. So I am wondering if I can upgrade to the Standard version 2007?

I tried this already Like I mentioned but the SQL upgrade script threw a bunch of errors. saying that tables did not exist etc.

 

 
  • Post Points: 20 |
Alex Crome
Top 10 Contributor
2,780 Posts
Points 41,105
TelligentSupportTeam
By: Alex Crome
Posted: Sun, Apr 6 2008 3:29 AM In reply to

 Your best bet will be to contact Telligent Sales directly as the'll know best - sales@telligent.com.  That will probably also be the best bet to get help for your Tables not Existing problems.

One other thing to consider when upgrading is with CS08 just arround the corner, do you want to want to go straight for a CS08 licence instead of a 2007 licence?

 
  • Post Points: 5 |
Page 1 of 1 (12 items) | RSS
Powered by Community Server (Commercial Edition), by Telligent Systems

Copyright© 2008 Telligent Systems Inc. All rights reserved
CommunityServer.com  •  Telligent.com