• last updated 56 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Silence potentially confusing warning during first installation

Small update for cluster support

- Improved visualization of cluster nodes that we lost contact to

- New kernel parameters to reduce hard-coded values and to make purpose more explicit

* new parameter ClusterHeartbeatInterval (default 20s),

was hardcoded before to the new default value

* renamed PreferredLocationRegexp -> ClusterPreferredLocationRegexp

* renamed EnableLoggingP -> ClusterEnableLoggingP

- Bumped version numbers:

* acs-kernel to 5.10.1b3

* acs-tcl to 5.10.1b2

* acs-admin to 5.10.1b2

acs-kernel acs-admin acs-tcl/

    • -0
    • +24
    ./upgrade/upgrade-5.10.1b2-5.10.1b3.sql
  1. … 7 more files in changeset.
file upgrade-5.10.1b2-5.10.1b3.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.1b2-5.10.1b3.sql
  1. … 1 more file in changeset.
fixed typo

  1. … 3 more files in changeset.
file upgrade-5.10.1d18-5.10.1d19.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.1d18-5.10.1d19.sql
made names of SQL functions explicit to ease calling directly from the Tcl level

    • -0
    • +53
    ./upgrade/upgrade-5.10.1d18-5.10.1d19.sql
  1. … 3 more files in changeset.
Remove no_alarms_until column

Rationale: the column or the related api is never used in upstream code to check whether notifications should be sent or not or not. The UI to manage the column's value was not linked anywhere. On the instances accessible by me downstream, no tuple was found where this column had a value.

    • -0
    • +49
    ./upgrade/upgrade-5.10.1d17-5.10.1d18.sql
  1. … 17 more files in changeset.
file upgrade-5.10.1d17-5.10.1d18.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.1d17-5.10.1d18.sql
  1. … 1 more file in changeset.
Added proc "membership_rel::expire" so that all membership states are now covered. Note: The Oracle part is best effort only!

    • -0
    • +22
    ./upgrade/upgrade-5.10.1d16-5.10.1d17.sql
  1. … 9 more files in changeset.
file upgrade-5.10.1d16-5.10.1d17.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.1d16-5.10.1d17.sql
  1. … 1 more file in changeset.
new partial index for a common query

... checking for "approved" members

    • -0
    • +5
    ./upgrade/upgrade-5.10.1d13-5.10.1d14.sql
  1. … 1 more file in changeset.
file upgrade-5.10.1d13-5.10.1d14.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.1d13-5.10.1d14.sql
make update script more robust in case the table acs_privilege_descendant_map was already dropped

The old version worked on pg14, but as it looks, not on earlier pg versions.

    • -1
    • +22
    ./upgrade/upgrade-5.10.1d11-5.10.1d12.sql
Cleanup leftover util user messages, that we won't persist anymore

    • -0
    • +6
    ./upgrade/upgrade-5.10.1d12-5.10.1d13.sql
  1. … 1 more file in changeset.
file upgrade-5.10.1d12-5.10.1d13.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.1d12-5.10.1d13.sql
Cleanup of acs_object_context_index' and friends in creation scripts

This change completes the commit [1] from 2019, where the cleanup was performed

acs_object_context_index and its maintenance functions just as an update script.

This change addresses this also in the creation scripts and in packages, still

depending on the old functions.

[1] https://fisheye.openacs.org/changelog/OpenACS?cs=oacs-5-10%3Ahectorr%3A20190708160122

    • -0
    • +57
    ./upgrade/upgrade-5.10.1d11-5.10.1d12.sql
  1. … 5 more files in changeset.
file upgrade-5.10.1d11-5.10.1d12.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.1d11-5.10.1d12.sql
file upgrade-5.10.1d9-5.10.1d10.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.1d9-5.10.1d10.sql
Adjust legacy data types of acs_object_types.object_type and acs_objects.object_type

This change addresses the problem mentioned in

https://cvs.openacs.org/changelog/OpenACS?cs=oacs-5-10%3Agustafn%3A20220729185340

https://github.com/openacs/openacs-core/commit/be44691f06627678122bd913bc3c95c80e93f403

which happens in some legacy applications (such as

e.g. openacs.org) where the data types of the following two

attributes are different.

acs_object_types.object_type

acs_objects.object_type

On new installations (at least concerning the last 10 years) these

data types are the same. So, probably an update script was missing

ages ago.

Since this change affects the basic object structure, MANY views

depend on this datatype and have to be dropped and recreate to

allow the correction of the datatype.

Therefore, we do not want to run this script on all sites, but

only on those where it is necessary.

    • -0
    • +340
    ./upgrade/upgrade-5.10.1d9-5.10.1d10.sql
  1. … 1 more file in changeset.
Added membership "expired" to membership states. "expired" can be

used for "dormant" accounts, which are neither "banned" nor "deleted".

    • -0
    • +9
    ./upgrade/upgrade-5.10.1d8-5.10.1d9.sql
  1. … 3 more files in changeset.
file upgrade-5.10.1d8-5.10.1d9.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.1d8-5.10.1d9.sql
  1. … 1 more file in changeset.
Improve robustness of upgrade script for legacy applications

In case, an installation has the legacy view (must be from very old installations)

in place, it is necessary to drop it before registered_users, otherwise

PostgreSQL will complain that it cannot drop view registered_users because

other objects depend on it.

Many thanks to Franz Penz to report this potential problem for old sites.

Align names used in utility db functions in Oracle and PostgreSQL

Over the years, the names used in the function for PostgreSQL and

Oracle drifted away, which is a problem when using call-by-name

convention for stored procedures. Furthermore, recent Oracle versions

do not allow attributes named "table" (for table_name). So the longer

version is now used uniformily. Fortunately, nsf allow abbreviation

for named parameters (like Tcl does), such one can use both

"-table_name" and "-table".

Bumped version number to 5.10.1d7.

    • -0
    • +167
    ./upgrade/upgrade-5.10.1d6-5.10.1d7.sql
  1. … 3 more files in changeset.
file upgrade-5.10.1d6-5.10.1d7.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.1d6-5.10.1d7.sql
  1. … 1 more file in changeset.
file upgrade-5.10.1d5-5.10.1d6.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.1d5-5.10.1d6.sql
fix broken function_args definition

    • -0
    • +2
    ./upgrade/upgrade-5.10.1d5-5.10.1d6.sql
  1. … 4 more files in changeset.
Improve spelling

    • -1
    • +1
    ./upgrade/upgrade-5.10.0d3-5.10.0d4.sql
    • -1
    • +1
    ./upgrade/upgrade-5.9.1d10-5.9.1d11.sql
Fixed update script for applications having the view "upgrade-5.10.0-5.10.1d1.sql" not defined.

This view is a legacy view ancient times, which is no included in standard installations

since ages.... It was however defined on openacs.org.

--

-- Some legacy applications might contain still the VIEW

-- "registered_users_of_package_id", which is defined in

--

-- acs-subsite/sql/postgresql/user-profiles-create.sql

--

-- This file is NOT included in new installations since over 20 years,

-- so it is not maintained and treated as a leftover from ancient

-- times. Therefore, the view registered_users_of_package_id is not

-- recreated by this update script.

    • -7
    • +20
    ./upgrade/upgrade-5.10.0-5.10.1d1.sql
refresh also "registered_users_of_package_id", which seems required on some (?) sites

    • -0
    • +10
    ./upgrade/upgrade-5.10.0-5.10.1d1.sql
file upgrade-5.10.1d2-5.10.1d3.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade/upgrade-5.10.1d2-5.10.1d3.sql
  1. … 1 more file in changeset.