Programming.BugTrackerDotNet History

Hide minor edits - Show changes to output - Cancel

 
 
October 02, 2014, at 09:29 AM by MichaelPaulukonis -
Changed lines 118-121 from:
Was handled by [@Internet Options >> Security >> Local intranet | Trusted sites >> Sites >> Advanced >> Add this website to the zone:@]


to:
Was handled by
[@Internet Options >> Security >> Local intranet | Trusted sites@]
[@
>> Sites >> Advanced >> Add this website to the zone:@]


Added line 131:
 
 
October 02, 2014, at 09:28 AM by MichaelPaulukonis -
Changed lines 72-73 from:
anon access). Follow these instrunctions for the file "loginnt.aspx":
to:
anon access). Follow these instructions for the file "loginnt.aspx":
Changed lines 82-83 from:
* Set the message type to File and select the file login.htm, including the full local path. (Note that this must be a file reference and not a URL)
to:
* Set the message type to File and select the file login.htm, including the full local path.
**
(Note that this must be a file reference and not a URL)
 
 
October 02, 2014, at 09:27 AM by MichaelPaulukonis -
Added lines 15-22:


!!! Configuration
A number of options are diabled by default, although not noted as such in the documentation.
Dig through the @@web.config@@ file to see what's what.

@@<add key="EnableRelationships" value="1"/>@@ - I changed this from @@0@@ to @@1@@

 
 
August 25, 2014, at 11:30 AM by MichaelPaulukonis -
Added lines 16-26:
!!! Unusual (???) Install
By default, the [@install_btnet.cmd@] script uses the [@Default Website@] - which is reserved on my dev machine for corporate apps.
Created a new website [@MiscApps@]
modified the script to use it.
Had to manually create new app-pool, and assign app to use it.
App-pool is ASP.NET 4.0, Network Service.
Had to grant permissions on folder to [@Network Service@]
Bob's yer uncle!
Also, it's using SQL Server 2014 Express - no changes needed to be made for this, since it's using the default instance.

!!! Migration
 
 
August 30, 2013, at 12:45 PM by OtherMichael - windows authentication follies
Added lines 31-100:

[[#winauth]]
!! Windows Integrated Authentication


(:source lang=text:)
Set WindowsAuthentication to "1" if you want to use
windows authentication instead of the logon page.

1) Configure your IIS virtual directory so that anon
access is unchecked and windows authentication is checked

2) Configure IE to automatically send username and password

3) Usernames in users table should match your
windows usernames. Passwords in users table will be
ignored.

If you want BOTH modes to work, set "WindowsAuthentication"
to "2".

Configure your IIS virtual directory as normal (allowing
anon access). Follow these instrunctions for the file "loginnt.aspx":

* From IIS Manager, right-click the file loginnt.aspx and select properties
* Select the Security tab
* Click Edit in the Anonymous Access and Authentication frame
* Ensure Anonymous Access and Basic Authentication is cleared
* Ensure Integrated Windows Authentication is selected
* Click OK
* Select the Custom Errors tab
* Select HTTP Error 401;2 and click Edit Properties
* Set the message type to File and select the file login.htm, including the full local path. (Note that this must be a file reference and not a URL)
(:sourceend:)


Except... this doesn't work for IIS7
You can't mix auth-modes for an application
In other words, you can't set for an individual page.

What I did was the following:

in web.config:

[@<add key="WindowsAuthentication" value="2"/>@]


in IIS7:

site >> application >> IIS >> Authentication
  Anonymous Authentication : Disabled
  Windows Authentication: Enables

[@site >> application >> IIS >> Error Pages >> Add@] (as 401.2 did not already exist)
  Status code: 401.2
  Response Action: Insert content from static file into the error response
  File path: login.htm

  NOTE: path was left as relative, as IIS7 choked on full path and

    HTTP Error 500.19 - Internal Server Error

    Absolute physical path "C:\inetpub\wwwroot\bugtracker.net\www\login.htm" is not allowed in system.webServer/httpErrors section in web.config file. Use relative path instead.


2) Configure IE to automatically send username and password

Was handled by [@Internet Options >> Security >> Local intranet | Trusted sites >> Sites >> Advanced >> Add this website to the zone:@]

 
 
July 31, 2013, at 03:59 PM by OtherMichael -
Added lines 1-95:
!! [=BugTracker.net=]
I was satisfied with [[http://ifdefined.com/bugtrackernet.html|BugTracker.net]] from Corey Trager.
I used it for about 5-6 years at a former employer.
A co-worker originally installed it (not sure what version) and I did maintenance after he left.
I extended the code to add in some short-links to other info-systems we used, like a wiki and a project-management system.
This was an older version and was never really upgraded.
I hope to extend this concept into a more generic version, like [[PmWiki/CustomInterMap|PmWiki's "intermap"]].
->But don't get too carried away, lest it become a wiki itself.
Satisfied is faint praise, sorry about that.
There are certainly bug-tracking systems I've encountered that I do not like.
[=BugTracker=] did everything I needed.

!! installation
[[http://ifdefined.com/README.html#installation]]

I migrated an install from one machine to another with no problems.
Copied the database (detach, copy files, attach).
Copied the entire folder.
Set up virtual directory pointing to [@www@], made application, set up app pool, made identity @@Network Service@@, granted permissions on @@www@@ folder to app-pool identity (for writing log-files and attachments), updated web.config for new DB reference, and URL prefix (this had been wrong before, so does not seem to be a sticking point).
whee!


[[#ldap]]
!! LDAP integration
[[http://ifdefined.com/blog/post/LDAP-Active-Directory-integration.aspx]]

>>blockq<<
LDAP/Active Directory integration. You can configure [=BugTracker.NET=] so that users are automatically registered when they visit [=BugTracker.NET=] for the first time.
->([[http://ifdefined.com/bugtrackernet.html|source]])
>><<

!! Visual editor
It uses the [[http://ckeditor.com/|ckeditor]]

Ugh. The "visual" editor drives me bananas.
And it's displaying everything in monospace.
How can I change that?
I'd like to display only selected items (code-fragments) in monospace.

!! Organizations
'''TODO:''' is it possible to get a default organization? Or am I using the wrong schemas?
Default project can be set, but projects are usually ''below'' and organization.
IE, any given organization has multiple projects.
I'd like to set a default project for an organization, and possibly even a default organization.

!! Bug Relationships
Did I miss this somewhere in the documentation?
Relationship are mentioned [[http://ifdefined.com/doc_bug_tracker_relationships.html|here]], but they are disabled by default.
Go into [@web.config@] and update the value of [@<add key="EnableRelationships" value="0"/>@] to '''[@1@]'''

!! All change history
By default (?) some changes are not displayed -- addition of custom fields, relationships, status change, assignments, etc.
I can't find a global setting to change this.
There is a link on each bug to enable the display: [@show change history|hide change history@]
This will store the setting to effect all other bugs the user views.
I haven't dug into the code to see if this is stored in the back-end, or in the browser (cookie or local-storage).
!! Queries
Here's a sample query I've set up, overwhelmingly based on the default [@open bugs@] query.
I found that referencing the st_name directly gave more clarity, and it was already present in the query.
Pay no heed to the exact list of ignored statuses, as my list of statuses is up in the air.

(:toggle id="tog1365021491266" show="Show query" init=hide button=1:)
(:div1365021491266 id="tog1365021491266" style="border:1px solid #999; padding;5px;":)
(:source lang=sql:)
select isnull(pr_background_color,'#ffffff'), bg_id [id], isnull(bu_flag,0) [$FLAG],
bg_short_desc [desc], isnull(pj_name,'') [project], isnull(og_name,'') [organization], isnull(ct_name,'') [category], rpt.us_username [reported by],
bg_reported_date [reported on], isnull(pr_name,'') [priority], isnull(asg.us_username,'') [assigned to],
isnull(st_name,'') [status], isnull(lu.us_username,'') [last updated by], bg_last_updated_date [last updated on]
from bugs
left outer join bug_user on bu_bug = bg_id and bu_user = $ME
left outer join users rpt on rpt.us_id = bg_reported_user
left outer join users asg on asg.us_id = bg_assigned_to_user
left outer join users lu on lu.us_id = bg_last_updated_user
left outer join projects on pj_id = bg_project
left outer join orgs on og_id = bg_org
left outer join categories on ct_id = bg_category
left outer join priorities on pr_id = bg_priority
left outer join statuses on st_id = bg_status
WHERE (st_name <> 'closed' AND st_name <> 'UAT Testing' AND st_name <> 'Deploy to UAT')
AND orgs.og_name = 'ORG_NAME'
order by bg_priority
(:sourceend:)
(:div1365021491266end:)

When twiddling queries in SSMS, you'll have to comment out [@and bu_user = $ME@]


!! Steps to Recreate
I added a custom field, [@varchar 2048@]
Should be required, IMHO


[[#seealso]]
!! See Also
[[BugTracking]]