Weblog

Populate

Created by Gustaf Neumann, last modified by Gustaf Neumann 19 Oct 2016, at 09:25 AM

Package Specification Summary for Package: populate

Bug Tracker Summary for Package: populate

Code Metrics Summary for Package: populate

Datamanager

Created by Gustaf Neumann, last modified by Gustaf Neumann 19 Oct 2016, at 09:13 AM

Package Specification Summary for Package: datamanager

Bug Tracker Summary for Package: datamanager

There is no package with the name "datamanager" known to bug-tracker.

Code Metrics Summary for Package: datamanager

Datamanager Portlet

Created by Gustaf Neumann, last modified by Gustaf Neumann 18 Oct 2016, at 08:34 AM

Package Specification Summary for Package: datamanager-portlet

Bug Tracker Summary for Package: datamanager-portlet

There is no package with the name "datamanager-portlet" known to bug-tracker.

Code Metrics Summary for Package: datamanager-portlet

Boost your application performance to serve large files!

Created by Rocael Hernández Rizzardini, last modified by Gustaf Neumann 16 Oct 2016, at 12:38 PM

In order to speed up file-deliveries, one can use the background delivery methods provided by xotcl-core. The main advantage is that with background delivery the costly connection threads are just used for permission checking and locating the file, and the time-consuming spooling of the file to the client is implemented in an asynchronous background delivery thread. Therefore, connection thread are not blocked, it is possible to spool simultaneously several hundred (thousand?) files with only a few connection threads configured.

We use this in production since several years. For example today (no semester yet) we had so far 150.000 file deliveries by background delivery.

The asynchrounous background delivery requires a small patch (2 changes, one is a backport from naviserver) and the tcl thread library (by zoran). The application code is in XOTcl is only a few lines of code and is included in xotcl-core (bgdelivery-procs.tcl).

One needs the following patch to

• aolserver 4.0.10 http://media.wu-wien.ac.at/download/aolserver-nsd-conn.patch, or
• aolserver 4.5.0 http://media.wu-wien.ac.at/download/aolserver45-nsd-conn.patch

The patch is already included in the current head version of aolserver 4.5 and in NaviServer.

With this patch and xotcl-core, one can replace
   ns_returnfile 200 $mime_type $filename

by
   ad_returnfile_background 200 $mime_type $filename

e.g. in cr_write_content in acs-content-repository/tcl/revision-procs.tcl to activate it and to deliver files from the content-repository (file-store) in the background.

The connection thread is only used for permission management, localization of the file and writing the the reply header, the actual delivery of the file is performed via asynchronous io without using up many resources. This can handle probably a couple of thousand concurrent file deliveries without running out of resources.

Check the files that has been served since the last reboot of your NaviServer/aolserver using this method from the developer support shell:

   bgdelivery do set delivery_count

Original thread:
https://openacs.org/forums/message-view?message_id=482221

Upgrade between PostgreSQL versions

Created by Gustaf Neumann, last modified by Gustaf Neumann 20 Sep 2016, at 02:06 PM

The probably easiest way to upgrade between PostgreSQL versions is as follows (described here from 9.4 to 9.5, based on the directory structure as provided by Mac Ports)

DATE=`date +"%Y-%m-%d"`
# Dump all databases from pg 9.4
PGBIN=/opt/local/lib/postgresql94/bin
sudo -u postgres $PGBIN/pg_dumpall | gzip -9 > ~/pg-dump-all-$DATE.gz

Then stop pg 9.4, start pg 9.5, then reload the dump:

# Restore all databases and roles from dump into pg 9.5
PGBIN=/opt/local/lib/postgresql95/bin
gunzip < ~/pg-dump-all-$DATE.gz |  $PGBIN/psql -U postgres

voilà, start OpenACS, and everything works fine.

In case there is a problem with restoring the dump in PostgreSQL 9.5 due to the "=>" operator of hstore, one has to update the version of hstore at least to 1.1 before dump/restore (the current version of hstore is 1.4; for details see hstore-upgrade).

In case, you want to upgrade your legacy OpenACS installation from PostgreSQL 8.* to 9, read upgrade-oacs-5-8.

Workflow example of a legislative process

Created by Antonio Pisano, last modified by Antonio Pisano 19 Sep 2016, at 02:10 PM

Membership Benefits

Created by Rocael Hernández Rizzardini, last modified by Caroline Meeks 16 Aug 2016, at 11:37 AM

.LRN Consortium: Membership Benefits

.LRN is, and aspires to continue to be, a serious platform for major organizations to commit to and build on, not simply a hobbyist project as many other more loosely-governed and managed efforts are.  To this end, the health of the project depends on the coordination of its development and promotion.  Even the legal existence of the consortium contributes to both of these things, by facilitating contracting and by signaling the seriousness of our enterprise.  Members who contribute to funding these common efforts get a voice and a vote in where we go and how we get there.  Specifically,  members are eligible to serve on our Board of Directors and its various Committees.  Members are entitled to private notice and consultation about major matters affecting the project before broader decisions and policies are announced.
 

OpenACS 5.9 HTML validity fixes

Created by Gustaf Neumann, last modified by Gustaf Neumann 15 Jul 2016, at 06:48 AM

Fixed validity of the following (mostly admin) pages:

 /acs-admin/
 /acs-admin/apm/
 /acs-admin/apm/packages-install
 /acs-admin/apm/packages-install-2
 /acs-admin/apm/packages-install-3
 /acs-admin/apm/packages-install-4
 /acs-admin/apm/version-callback-add-edit
 /acs-admin/apm/version-callbacks
 /acs-admin/apm/version-dependencies
 /acs-admin/apm/version-dependency-add
 /acs-admin/apm/version-edit
 /acs-admin/apm/version-files
 /acs-admin/apm/version-i18n-index
 /acs-admin/apm/version-parameters
 /acs-admin/apm/version-view
 /acs-admin/auth/
 /acs-admin/auth/authority
 /acs-admin/cache/
 /acs-admin/developer
 /acs-admin/install/
 /acs-admin/install/install
 /acs-admin/monitor
 /acs-admin/users/
 /acs-admin/users/bouncing-users
 /acs-admin/users/complex-search
 /acs-admin/users/one
 /acs-admin/users/registration-history
 /acs-admin/users/user-add
 /acs-content-repository/admin/
 /acs-content-repository/admin/mime-types/
 /acs-content-repository/admin/mime-types/extensions
 /acs-lang/
 /acs-lang/admin/
 /acs-lang/admin/batch-editor
 /acs-lang/admin/edit-localized-message
 /acs-lang/admin/export-messages
 /acs-lang/admin/import-messages
 /acs-lang/admin/localized-message-new
 /acs-lang/admin/lookup
 /acs-lang/admin/message-conflicts
 /acs-lang/admin/message-list
 /acs-lang/admin/package-list
 /acs-lang/admin/set-system-timezone
 /acs-service-contract/
 /admin/applications/
 /admin/applications/application-add
 /admin/attributes/edit-one
 /admin/configure
 /admin/group-types/
 /admin/group-types/delete-rel-types-exist
 /admin/group-types/rel-type-add
 /admin/groups/  (elements-by-group-type, elements-by-group-type)
 /admin/groups/delete
 /admin/groups/one
 /admin/groups/rel-type-remove
 /admin/host-node-map/
 /admin/manage-email-privacy
 /admin/object-types/
 /admin/object-types/one
 /admin/parties/one
 /admin/permissions
 /admin/rel-segments/
 /admin/rel-segments/new
 /admin/rel-segments/new-2
 /admin/rel-segments/one
 /admin/rel-types/
 /admin/rel-types/new
 /admin/rel-types/one
 /admin/rel-types/roles/
 /admin/rel-types/roles/edit
 /admin/rel-types/roles/new
 /admin/rel-types/roles/one
 /admin/relations/add
 /admin/relations/one
 /admin/relations/remove
 /admin/site-map  (folder add, rename)
 /admin/subsite-add
 /api-doc/
 /api-doc/content-page-view
 /api-doc/deprecated.html
 /api-doc/display-sql
 /api-doc/package-view
 /api-doc/plsql-subprogram-one
 /api-doc/proc-browse
 /api-doc/proc-search
 /api-doc/proc-view
 /api-doc/procs-file-view
 /api-doc/tcl-proc-view
 /calendar/admin
 /calendar/admin/calendar-edit
 /calendar/admin/permissions
 /calendar/cal-item-new
 /calendar/calendar-item-types
 /calendar/view
 /categories
 /categories/cadmin/
 /categories/cadmin/category-links-view
 /categories/cadmin/category-parent-change
 /categories/cadmin/object-map
 /categories/cadmin/synonyms-view
 /categories/cadmin/tree-copy
 /categories/cadmin/tree-copy-view
 /categories/cadmin/tree-view
 /comments
 /comments/admin
 /doc/

 /download/
 /download/admin/
 /download/admin/report-by-ip
 /download/admin/report-by-user
 /download/admin/repository-ae
 /download/admin/repository-metadata
 /download/admin/repository-reasons
 /download/admin/repository-types
 /download/help
 /ds/
 /ds/css-edit
 /ds/css-list
 /ds/request-info
 /ds/shell
 /file-storage/
 /forums/
 /forums/admin/
 /forums/admin/forum-edit.html
 /forums/admin/forum-new.html
 /forums/admin/permissions.html
 /forums/forum-view.html
 /forums/message-post
 /forums/message-view.html
 /forums/search
 /forums/user-history.html
 /members/
 /members/user-batch-add
 /news
 /news/admin
 /news/item-create
 /notifications/manage
 /notifications/request-change-frequency
 /notifications/subscribers
 /permissions/
 /permissions/one
 /pvt/home
 /request-monitor/
 /request-monitor/last100
 /request-monitor/running
 /request-monitor/stat-details
 /request-monitor/throttle-statistics
 /request-monitor/who-is-online
 /request-monitor/who-was-online-today
 /shared/community-member
 /shared/parameters
 /shared/whos-online
 /test/admin/
 /user/email-privacy-level
 /user/portrait/upload
 /xowiki/admin
 /xowiki/admin/list
 /xowiki/admin/permissions

 

Known Problems

• double "id": 
  Example: /admin/rel-types/new-2?supertype=membership_rel
   
• developer-support breaks validation (adds "div" immediately after "ul" due to include):
  Example: /admin/groups/
  Solved, by adding ability to suppress div wrapper via <include ds=0 src=...>

openacs-bootstrap3-theme

Created by Gustaf Neumann, last modified by Gustaf Neumann 09 Jul 2016, at 11:48 AM

This package provides a Theme based on  the Twitter Bootstrap 3 library. The theme can be activated via /admin/configure and it can be configured via /shared/parameters.   For more information about customizing this theme and on theming in OpenACS in general, see oacs-theming.

This theme is currently in use at openacs.org

Package Specification Summary for Package: openacs-bootstrap3-theme

Bug Tracker Summary for Package: openacs-bootstrap3-theme

Code Metrics Summary for Package: openacs-bootstrap3-theme

Postgres 8.1.x to 9.1

Created by Rocael Hernández Rizzardini, last modified by Gustaf Neumann 08 Jul 2016, at 02:25 PM

PostgreSQL 8.x (e.g. 8.1.* and later up to 9.1) require a few changes in the configuration file for backward compatibility (see below).

Note that OpenACS 5.8 or newer works with PostgreSQL 9.1 (or newer) out of the box, the special configurations for postgresql.conf described below are not needed anymore.

1. Configure postgres8 with all compatibility ON in postgresql.conf:

 add_missing_from = on 
 regex_flavor = extended 
 default_with_oids = on

2. If you are upgrading an OpenACS site between versions 4.5.2 to 5.2 and not continuing to 5.3, then: After the createdb step to create the OpenACS database, generate the next function before you import the pre-existing OpenACS database.

From your shell prompt enter:

psql <dbname>

From the psql prompt enter the follow plpgsql code to create the bitfromint4 function:

 

 create or replace function bitfromint4 (integer) 
 returns bit varying as ' 
 begin 
    return $1::bit(32); 
 end;' language 'plpgsql' immutable strict; 

Exit psql:

\q 

This is the original thread 

For a full script on how to install PG 8.2 with ltree and tsearch2 look at Malte's install script