Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Run database installation scriptRun database installation script
Previous
 
Next
New Post
8/30/2010 6:04 AM
 
Hi everyone,

I'm doing a Dotnetnuke community install on a fresh win2k8 R2 server with SQL 2008 R2. The install steams to go fine untill i hit the "Run Database Installation Scripts" page. There it fires up and just sits there endlessly with "Installing Database - Version 05.00.00...Installing Database - Version 05.00.00..." in the text box. I have left it there for over an hour and just never get an error.

I have retried the install and get the same situation over and over. I have more than tripple verified the DB credentials using cut/past to remove any typo issues,...

I'm using SQL authentication with a user that is full dbo on the dotnetnuke DB. I'm seeing no auth error's or other issues in the eventviewer,...

Any ideas on what this might be or where I can find a more detailed log to troubleshoot this issue.

Many thanks,

Tom
 
New Post
8/30/2010 7:49 AM
 
did you make sure, the ASP.net user has full permission in DNN installation folder, including reading the upgrade scripts and writing the log files.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
8/30/2010 8:07 AM
 
Thanks for the reply,

yes, I also tripple checked the directory rights. At the moment i have it set IIS_IUSRS (read access), DefaultAppPool (Read/write), Network Service (Read/write).

I have this set at my top level Directory and inherited down, as far as i have been able to verify this is applied on all levels.

Where can i find the log and scripts directory to verify ? Any other thoughts?

Tom
MVP Forefront
 
New Post
8/30/2010 8:17 AM
 
Well I found the log directory C:\inetpub\wwwroot\<mydir>\Portals\_default\Logs and there i have a LogFailures.xml.resources file. If i delete this file and restart the process i can see the fire being recreated and filling with data so it does seem like the asp user has all the rights he needs?

the last lines in the log are very unmeaningfull for me:

at DotNetNuke.Entities.Controllers.HostController.GetSettingsDictionaryCallBack(CacheItemArgs cacheItemArgs)</PropertyValue></LogProperty><LogProperty><PropertyName>Source</PropertyName><PropertyValue /></LogProperty></LogProperties></log><log LogGUID="712925e7-9254-408c-b64d-464d6263ae0b" LogFileID="" LogTypeKey="APPLICATION_SHUTTING_DOWN" LogUserID="-1" LogUserName="" LogPortalID="-1" LogPortalName="" LogCreateDate="1/1/0001 12:00:00 AM" LogCreateDateNum="0" BypassBuffering="True" LogServerName="" LogConfigID=""><LogProperties><LogProperty><PropertyName>Shutdown Details</PropertyName><PropertyValue>The AppDomain shut down because of the hosting environment.</PropertyValue></LogProperty></LogProperties></log><log LogGUID="275556c0-772e-4713-a102-1e47cb6be45f" LogFileID="" LogTypeKey="SCHEDULER_SHUTTING_DOWN" LogUserID="-1" LogUserName="" LogPortalID="-1" LogPortalName="" LogCreateDate="1/1/0001 12:00:00 AM" LogCreateDateNum="0" BypassBuffering="False" LogServerName="" LogConfigID=""><LogProperties><LogProperty><PropertyName>Initiator</PropertyName><PropertyValue>Stopped by Application_End</PropertyValue></LogProperty></LogProperties></log><log LogGUID="1dfcf92f-7cd3-42e4-850e-59822b5cbbc1" LogFileID="" LogTypeKey="GENERAL_EXCEPTION" LogUserID="-1" LogUserName="" LogPortalID="-1" LogPortalName="" LogCreateDate="1/1/0001 12:00:00 AM" LogCreateDateNum="0" BypassBuffering="False" LogServerName="" LogConfigID=""><LogProperties><LogProperty><PropertyName>AssemblyVersion</PropertyName><PropertyValue>5.5.0</PropertyValue></LogProperty><LogProperty><PropertyName>PortalID</PropertyName><PropertyValue>-1</PropertyValue></LogProperty><LogProperty><PropertyName>PortalName</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>UserID</PropertyName><PropertyValue>-1</PropertyValue></LogProperty><LogProperty><PropertyName>UserName</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>ActiveTabID</PropertyName><PropertyValue>-1</PropertyValue></LogProperty><LogProperty><PropertyName>ActiveTabName</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>RawURL</PropertyName><PropertyValue>/bubbledivers/Install/InstallWizard.aspx</PropertyValue></LogProperty><LogProperty><PropertyName>AbsoluteURL</PropertyName><PropertyValue>/bubbledivers/Install/InstallWizard.aspx</PropertyValue></LogProperty><LogProperty><PropertyName>AbsoluteURLReferrer</PropertyName><PropertyValue>http://rserverx.decaluwe.local/bubbledivers/Install/InstallWizard.aspx</PropertyValue></LogProperty><LogProperty><PropertyName>UserAgent</PropertyName><PropertyValue>Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729)</PropertyValue></LogProperty><LogProperty><PropertyName>DefaultDataProvider</PropertyName><PropertyValue>DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider</PropertyValue></LogProperty><LogProperty><PropertyName>ExceptionGUID</PropertyName><PropertyValue>82756ab1-cce5-4d11-b18a-89ec2e1cc978</PropertyValue></LogProperty><LogProperty><PropertyName>InnerException</PropertyName><PropertyValue>Could not find stored procedure 'dbo.GetHostSettings'.</PropertyValue></LogProperty><LogProperty><PropertyName>FileName</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>FileLineNumber</PropertyName><PropertyValue>0</PropertyValue></LogProperty><LogProperty><PropertyName>FileColumnNumber</PropertyName><PropertyValue>0</PropertyValue></LogProperty><LogProperty><PropertyName>Method</PropertyName><PropertyValue>System.Data.SqlClient.SqlConnection.OnError</PropertyValue></LogProperty><LogProperty><PropertyName>StackTrace</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>Message</PropertyName><PropertyValue>System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.GetHostSettings'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues)
   at DotNetNuke.Data.SqlDataProvider.GetHostSettings()
   at DotNetNuke.Entities.Controllers.HostController.GetSettingsDictionaryCallBack(CacheItemArgs cacheItemArgs)</PropertyValue></LogProperty><LogProperty><PropertyName>Source</PropertyName><PropertyValue /></LogProperty></LogProperties></log><log LogGUID="fb2415aa-41af-4256-9438-a3e9bc520e58" LogFileID="" LogTypeKey="APPLICATION_SHUTTING_DOWN" LogUserID="-1" LogUserName="" LogPortalID="-1" LogPortalName="" LogCreateDate="1/1/0001 12:00:00 AM" LogCreateDateNum="0" BypassBuffering="True" LogServerName="" LogConfigID=""><LogProperties><LogProperty><PropertyName>Shutdown Details</PropertyName><PropertyValue>The AppDomain shut down because of a change to the application level configuration.</PropertyValue></LogProperty></LogProperties></log><log LogGUID="15a226ee-29fc-4808-9b37-ec9b78ff8e4a" LogFileID="" LogTypeKey="SCHEDULER_SHUTTING_DOWN" LogUserID="-1" LogUserName="" LogPortalID="-1" LogPortalName="" LogCreateDate="1/1/0001 12:00:00 AM" LogCreateDateNum="0" BypassBuffering="False" LogServerName="" LogConfigID=""><LogProperties><LogProperty><PropertyName>Initiator</PropertyName><PropertyValue>Stopped by Application_End</PropertyValue></LogProperty></LogProperties></log></logs>
 
New Post
8/31/2010 12:55 AM
 
read/write to th application pool user isn't enough.  set the appl. pool user to full access and also for the newtwork service.
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Run database installation scriptRun database installation script


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out