Chucks notes and stuff - project-open
https://wiki.itadmins.net/
2026-05-23T10:58:09+00:00Chucks notes and stuff
https://wiki.itadmins.net/
https://wiki.itadmins.net/lib/exe/fetch.php?media=wiki:dokuwiki.svgtext/html2020-02-24T10:16:01+00:00Anonymous (anonymous@undisclosed.example.com)apache_proxy
https://wiki.itadmins.net/doku.php?id=project-open:apache_proxy&rev=1582539361&do=diff
Apache mod_proxy with ]project-open[
Running AOL server on a port other than port 80 is a good way to have multiple versions/installs of ]po[ available for differing needs. the problem is remembering which port is for which install.
By making use of Apache with mod_proxy and mod_proxy_html you can create subdomain virtualhosts in Apache that are proxied to and from the differing AOLserver/]po[ backends.text/html2020-02-24T10:16:01+00:00Anonymous (anonymous@undisclosed.example.com)auth_authorities
https://wiki.itadmins.net/doku.php?id=project-open:auth_authorities&rev=1582539361&do=diff
Updating user to LDAP Authority
su - projop
psql
select authority_id from auth_authorities;
update users set authority_id = ##### where username = 'USERNAME';
where ##### the authority_id from the select query and USERNAME the username from the user is.text/html2020-02-24T10:16:01+00:00Anonymous (anonymous@undisclosed.example.com)bt_link
https://wiki.itadmins.net/doku.php?id=project-open:bt_link&rev=1582539361&do=diff
BugTracker "New Bug" link in Project Overview
in intranet-bug-tracker/tcl/intranet-bug-tracker-procs.tcl the function im_bug_tracker_list_component should be changed to the followings
ad_proc -public im_bug_tracker_list_component {
project_id
} {
shows a list of bugs in the current project
} {
if {![im_project_has_type $project_id "Bug Tracker Container"]} {
return ""
}
# Original code line
# set html ""
#------------------
#
set action_url "/bug-tracker/b…text/html2020-02-24T10:16:01+00:00Anonymous (anonymous@undisclosed.example.com)bugtracker_link_filters
https://wiki.itadmins.net/doku.php?id=project-open:bugtracker_link_filters&rev=1582539361&do=diff
Bugtracker Link Filters
The second major problem with the BT in ]po[ was the filter links on the left hand side. It doesn't matter what you click after installing the shown bugs are not changed. This can be fixed so
nano /web/projop/packages/bug-tracker/www/index.tcltext/html2020-02-24T10:16:01+00:00Anonymous (anonymous@undisclosed.example.com)bugtracker_pgsql_function
https://wiki.itadmins.net/doku.php?id=project-open:bugtracker_pgsql_function&rev=1582539361&do=diff
Replacement Bugtracker PostGreSQL Function
For some reason somewhere in the 3.x¹ series one of the PostGreSQL functions got replaced with a function that provides absolutely no functionality at all in ]po[. It took me about 2 days to finally track this one down so I am posting it here because I need it every once in a while when at a client. ;)text/html2020-02-24T10:16:01+00:00Anonymous (anonymous@undisclosed.example.com)postgresql
https://wiki.itadmins.net/doku.php?id=project-open:postgresql&rev=1582539361&do=diff
Various PostGreSQL info
show tables the PostGreSQL way
*
psql template1 projop -l
complete DB dump
*
pg_dump -c -O -F p -f backup.20100917-1745.sql
restore the dump
*
psql -d projop -f backup.20100917-1745.sql
starting per hand
*text/html2020-02-24T10:16:01+00:00Anonymous (anonymous@undisclosed.example.com)updating
https://wiki.itadmins.net/doku.php?id=project-open:updating&rev=1582539361&do=diff
Updating per CVS
to get new features not yet released you need to update from CVS. Be advised that some of the code can kill you install.
su - projop
cd packages
export CVSROOT=":pserver:anonymous@berlin.dnsalias.com:/home/cvsroot"
cvs login
cvs update -PdA