Tuesday, January 17, 2012

Bugtracker.net Installation

This is a complete list of steps that I followed in order to set up bugtracker.net for an internal organization running on Windows Server 2003 R2 and SQL Server 2008 with integrated authentication.


1.       install ASP.Net 4.0
2.       download source
a.       unzip to directory (c:\btnet)
b.      add virtual directory in c:\btnet\www
                                                                           i.      using %windir%\system32\inetsrv\InetMgr.exe
                                                                         ii.      set asp.net version to 4.0
3.       create database btnet
a.       add user btnet:btn3t to server and database dbo
b.      run c:\btnet\www\setup.sql on this database
4.       edit c:\btnet\www\web.config
a.       line 118
<add key="ConnectionString" value="server=(local);database=btnet;user id=btnet;password=btn3t;Trusted_Connection=no;"/>
b.      line 424         - 427
<add key="AppTitle" value="COMPANY Issue Tracking"/>
<add key="SingularBugLabel" value="Item"/>
<add key="PluralBugLabel" value="Items"/>
c.       add line 24
<customErrors mode="Off"/>
d.      Line 124
<add key="AbsoluteUrlPrefix" value="http://hostname/btnet/"/>
e.      Find/replace all instances of App_Data with c:\btnet\www\App_Data so that the logfiles and such get created in the correct location
5.       set some custom html          
a.       replace in c:\btnet\www\custom\custom_logo.html
<td width=100 valign=middle><a href="/btnet/bugs.aspx"><div class=logo>COMPANY Issue Tracking</div></a></td>
6.       set some custom css to match company standards
a.       append  to c:\btnet\www\custom\btnet_custom.css
.logo
{
background-color:#3b8fc8;
width:125px;
}
.smallnote, .pst, .click_to_so
{
color: #3b8fc8;
}

.menubar
{
border-bottom: 1px solid #3b8fc8;
}
.cmt
{
border: 1px #3b8fc8 solid;
}
7.       open localhost/btnet
8.       login as admin/admin
a.       add self as admin user
                                                                           i.      admin tab at the top
                                                                         ii.      users
                                                                        iii.      add new user
                                                                       iv.      type in your username
                                                                         v.      type in any password, it won't use this for auth
9.       set up windows auth
a.       from iis manager
                                                                           i.      find btnet virtual directory
                                                                         ii.      right click -> properties
1.       directory security -> auth edit
a.       uncheck enable anonymous access
b.      check integrated windows security
b.      edit c:\btnet\www\web.config
                                                                           i.      line 297
<add key="WindowsAuthentication" value="1"/>
                                                                         ii.      line 355
<add key="EnableWindowsUserAutoRegistration" value="1"/>
c.       now users will be able to sign in with their existing accounts and the bugtracker will auto create accounts for them
                                                                           i.      the admin can then adjust properties on these users