1.3 install is always failing

Topics: Installing BugNET
Mar 7, 2013 at 8:52 PM
I went through the steps in installing given on codeplex. When I go to Install.aspx, I get the following error.

<Data>3005</Data>
<Data>An unhandled exception has occurred.</Data>
<Data>3/7/2013 2:37:17 PM</Data>
<Data>3/7/2013 8:37:17 PM</Data>
<Data>f209696cadbd440b8cbdaf63738de4f8</Data>
<Data>2</Data>
<Data>1</Data>
<Data>0</Data>
<Data>/LM/W3SVC/1/ROOT/BugNet-3-130071622371853534</Data>
<Data>Full</Data>
<Data>/BugNet</Data>
<Data>C:\inetpub\wwwroot\BugNet\</Data>
<Data>SDHAUL-1</Data>
<Data />
<Data>15300</Data>
<Data>w3wp.exe</Data>
<Data>IIS APPPOOL\DefaultAppPool</Data>
<Data>SqlException</Data>
<Data>Could not find stored procedure 'BugNet_HostSetting_GetHostSettings'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 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, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 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() at BugNET.Providers.DataProviders.SqlDataProvider.ExecuteReaderCmd[T](SqlCommand sqlCmd, GenerateListFromReader1 gcfr, List1& list) at BugNET.Providers.DataProviders.SqlDataProvider.GetHostSettings() at BugNET.BLL.HostSettingManager.LoadHostSettings() at BugNET.BLL.HostSettingManager.GetHostSettings() at BugNET.Initialization.Init(HttpContext context) at BugNET.Global.Application_BeginRequest(Object sender, EventArgs e) at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)</Data>
<Data>http://localhost/BugNet/Account/Login.aspx?ReturnUrl=/BugNet/Install/Install.aspx</Data>
<Data>/BugNet/Account/Login.aspx</Data>
<Data>127.0.0.1</Data>
<Data />
<Data>False</Data>
<Data />
<Data>IIS APPPOOL\DefaultAppPool</Data>
<Data>13</Data>
<Data>IIS APPPOOL\DefaultAppPool</Data>
<Data>False</Data>
<Data>at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 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, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 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() at BugNET.Providers.DataProviders.SqlDataProvider.ExecuteReaderCmd[T](SqlCommand sqlCmd, GenerateListFromReader1 gcfr, List1& list) at BugNET.Providers.DataProviders.SqlDataProvider.GetHostSettings() at BugNET.BLL.HostSettingManager.LoadHostSettings() at BugNET.BLL.HostSettingManager.GetHostSettings() at BugNET.Initialization.Init(HttpContext context) at BugNET.Global.Application_BeginRequest(Object sender, EventArgs e) at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)</Data>
</EventData>
</Event>
Mar 7, 2013 at 9:07 PM
Try accessing the install page directly http://localhost/BugNET/Install/Install.aspx , you may also try resetting IIS first before you do this.
Mar 7, 2013 at 9:09 PM
It doesn't help. I tried after I re-started the IIS server. I think this is a bug as I cannot even install it.
Mar 7, 2013 at 9:27 PM
Why do you guys not provide a detached database with log file? Then, in such cases as I am facing, users could simply attach the database file and get it to work
Mar 8, 2013 at 2:06 PM
sun21170 wrote:
Why do you guys not provide a detached database with log file? Then, in such cases as I am facing, users could simply attach the database file and get it to work
We don't do this because we have an installer.

I suggest that you change the app pool identity to the network service account make sure it has write privileges on the BugNET directory.
Mar 8, 2013 at 4:17 PM
I did that but still the same problem. The exception logged in event log is as below.
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 3/8/2013 10:16:03 AM
Event time (UTC): 3/8/2013 4:16:03 PM
Event ID: c704eaade5764e7992bba780d5d30705
Event sequence: 2
Event occurrence: 1
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/ROOT/BugNet-2-130072329616389282 
Trust level: Full 
Application Virtual Path: /BugNet 
Application Path: C:\inetpub\wwwroot\BugNet\ 
Machine name: SDHAUL-1 
Process information:
Process ID: 9464 
Process name: w3wp.exe 
Account name: IIS APPPOOL\DefaultAppPool 
Exception information:
Exception type: SqlException 
Exception message: Could not find stored procedure 'BugNet_HostSetting_GetHostSettings'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
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, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
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()
at BugNET.Providers.DataProviders.SqlDataProvider.ExecuteReaderCmd[T](SqlCommand sqlCmd, GenerateListFromReader
1 gcfr, List`1& list)
at BugNET.Providers.DataProviders.SqlDataProvider.GetHostSettings()
at BugNET.BLL.HostSettingManager.LoadHostSettings()
at BugNET.BLL.HostSettingManager.GetHostSettings()
at BugNET.Initialization.Init(HttpContext context)
at BugNET.Global.Application_BeginRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)



Request information:
Request URL: http://localhost/BugNet/Account/Login.aspx?ReturnUrl=/BugNet/install/install.aspx 
Request path: /BugNet/Account/Login.aspx 
User host address: ::1 
User:  
Is authenticated: False 
Authentication Type:  
Thread account name: IIS APPPOOL\DefaultAppPool 
Mar 8, 2013 at 4:24 PM
You must have changed the wrong app pool because the error says:
Thread account name: IIS APPPOOL\DefaultAppPool
Mar 8, 2013 at 6:40 PM
I changed the app pool to Network Service but it still gives the same problem. The error information from event log is as pasted below.

Process information:
Process ID: 5280 
Process name: w3wp.exe 
Account name: NT AUTHORITY\NETWORK SERVICE 
Exception information:
Exception type: SqlException 
Exception message: Could not find stored procedure 'BugNet_HostSetting_GetHostSettings'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
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, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource
1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
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()
at BugNET.Providers.DataProviders.SqlDataProvider.ExecuteReaderCmd[T](SqlCommand sqlCmd, GenerateListFromReader1 gcfr, List1& list)
at BugNET.Providers.DataProviders.SqlDataProvider.GetHostSettings()
at BugNET.BLL.HostSettingManager.LoadHostSettings()
at BugNET.BLL.HostSettingManager.GetHostSettings()
at BugNET.Initialization.Init(HttpContext context)
at BugNET.Global.Application_BeginRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)



Request information:
Request URL: http://localhost/BugNet/Account/Login.aspx?ReturnUrl=/bugnet/install/install.aspx 
Request path: /BugNet/Account/Login.aspx 
User host address: ::1 
User:  
Is authenticated: False 
Authentication Type:  
Thread account name: NT AUTHORITY\NETWORK SERVICE 
Mar 8, 2013 at 6:46 PM
It looks as if the request to the install page is failing authentication and redirecting to the login page. Have you changed any authentication settings on the virtual directory or in the web.config file?
Mar 8, 2013 at 8:50 PM
Forms Authentication is enabled on this web site. You can see the screen shot here: http://screencast.com/t/mBOxCP1BJp
Mar 8, 2013 at 8:53 PM
sun21170 wrote:
Forms Authentication is enabled on this web site. You can see the screen shot here: http://screencast.com/t/mBOxCP1BJp
You have anonymous access disabled, this will not allow anyone to access the website. If you enable this you should be able to run the installer properly.
Mar 8, 2013 at 8:56 PM
Also, the web config has the following settings:

<customErrors defaultRedirect="~/Errors/Error.aspx" mode="On" />
    <!-- Authentication Settings -->
    <authentication mode="Forms">
        <forms name="BugNET" loginUrl="~/Account/Login.aspx" timeout="2880" />
    </authentication>
    <!--<authentication mode="Windows" />-->
    <!--
    <authorization> 
        <deny users="?" /> 
    </authorization>
    -->
    <globalization culture="en-US" uiCulture="en" requestEncoding="UTF-8" responseEncoding="UTF-8" fileEncoding="UTF-8" />
    <httpRuntime maxRequestLength="4000" executionTimeout="1000" />
</system.web>
Mar 8, 2013 at 9:27 PM
But this should be done in web.config, and I am just using the web.config you guys have in your download. I mean when I enable anonymous authentication, it will make a change in web.config file. Then anyone can login later on without any authentication. Right?
Mar 8, 2013 at 9:31 PM
YES. Now it installs and I get a login screen when go to home page. So it works now. I think this is desperately needed: Please let your users know that anonymous access is needed to the website folder else install will fail.

THANKS
Mar 8, 2013 at 9:33 PM
Please add the following to your web.config, since that is what is needed to allow anonymous access.

<security>
  <authentication>
    <windowsAuthentication enabled="false" />
    __<anonymousAuthentication enabled="true" />__
  </authentication>
</security>
Mar 8, 2013 at 9:56 PM
When you change the settings in IIS it modifies the web.config. In order to use forms auth you must enable anonymous auth otherwise no one can reach the login page. Users will still need an account to access the app.


On Friday, March 8, 2013, sun21170 wrote:

From: sun21170

But this should be done in web.config, and I am just using the web.config you guys have in your download. I mean when I enable anonymous authentication, it will make a change in web.config file. Then anyone can login later on without any authentication. Right?

Read the full discussion online.

To add a post to this discussion, reply to this email (bugnet@discussions.codeplex.com)

To start a new discussion for this project, email bugnet@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe or change your settings on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com



--
Sent from Gmail Mobile
Mar 8, 2013 at 10:08 PM
Edited Mar 8, 2013 at 10:14 PM
I still believe that you should include the following in your web.config to avoid problems with installation for future users of your app.

<anonymousAuthentication enabled="true" />
Mar 8, 2013 at 10:14 PM
Other than the install experience I had, I really like the app as I have been playing around with it. Its super excellent and very intuitive to use. Thanks for creating such a good product.
Mar 8, 2013 at 10:16 PM
You are welcome. Thank you for your patience and suggestions on how to improve the installation experience.

On Friday, March 8, 2013, sun21170 wrote:

From: sun21170

Other than the install experience I had, I really like the app as I have been playing around with it. Its super excellent and very intuitive to use. Thanks for creating such a good product.

Read the full discussion online.

To add a post to this discussion, reply to this email (bugnet@discussions.codeplex.com)

To start a new discussion for this project, email bugnet@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe or change your settings on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com



--
Sent from Gmail Mobile