OpenACS / openacs-4 / packages

acs-kernel

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 58
Last Commit: 08 May
Commits this week: 0
Total Lines of Code (LoC): 87,395
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 22 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 02 Aug 2023
4:24 pm

gustafn

replaced complex and error-prone test with a more sane version

Actually, this test should be in acs-tcl, since all kernel behavior is already

there, and the directory "tcl" was left intentionally empty.

Options
    • -45
    • +4
    ./tcl/test/acs-kernel-procs.tcl
Saturday 29 Jul 2023
2:33 pm

gustafn

parameter AllowedTag: added <adp:toggle_button> to default value

Options
    • -3
    • +3
    ./acs-kernel.info
Thursday 13 Jul 2023
3:09 pm

gustafn

bumped version numbers to 5.10.1b1

Options
    • -3
    • +3
    ./acs-kernel.info
  2. … 85 more files in changeset.
Monday 10 Jul 2023
11:29 am

gustafn

file upgrade-5.10.1d10-5.18.1d19.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-5.10.1d10-5.18.1d19.sql
11:29 am

gustafn

file upgrade-5.10.1d18-5.10.1d19.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.10.1d18-5.10.1d19.sql
11:29 am

gustafn

made names of SQL functions explicit to ease calling directly from the Tcl level

Options
    • -2
    • +2
    ./acs-kernel.info
    • -2
    • +18
    ./sql/oracle/apm-create.sql
    • -0
    • +680
    ./sql/oracle/upgrade/upgrade-5.10.1d10-5.18.1d19.sql
    • -5
    • +17
    ./sql/postgresql/apm-create.sql
    • -0
    • +53
    ./sql/postgresql/upgrade/upgrade-5.10.1d18-5.10.1d19.sql
Tuesday 28 Mar 2023
1:20 pm

antoniop

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.

Options
    • -2
    • +2
    ./acs-kernel.info
    • -2
    • +2
    ./sql/oracle/acs-create.sql
    • -27
    • +1
    ./sql/oracle/community-core-create.sql
    • -0
    • +200
    ./sql/oracle/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
    • -37
    • +1
    ./sql/postgresql/community-core-create.sql
    • -0
    • +49
    ./sql/postgresql/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
  7. … 13 more files in changeset.
1:20 pm

antoniop

file upgrade-5.10.1d17-5.10.1d18.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
Friday 10 Feb 2023
8:07 pm

gernst

Added proc "membership_rel::expire" so that all membership states are now covered. Note: The Oracle part is best effort only!

Options
    • -2
    • +2
    ./acs-kernel.info
    • -1
    • +11
    ./sql/oracle/groups-body-create.sql
    • -1
    • +5
    ./sql/oracle/groups-create.sql
    • -0
    • +249
    ./sql/oracle/upgrade/upgrade-5.10.1d16-5.10.1d17.sql
    • -1
    • +25
    ./sql/postgresql/groups-body-create.sql
    • -0
    • +22
    ./sql/postgresql/upgrade/upgrade-5.10.1d16-5.10.1d17.sql
  7. … 5 more files in changeset.
8:07 pm

gernst

file upgrade-5.10.1d16-5.10.1d17.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-5.10.1d16-5.10.1d17.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.10.1d16-5.10.1d17.sql
Tuesday 07 Feb 2023
6:50 pm

gustafn

Cluster reform

- Support for dynamic cluster nodes:

Previous versions of OpenACS required to know the IP addresses of

the cluster nodes in advance, which is a show-stopper for many cloud

applications.

The new functionality allows arbitrary nodes to register as client

nodes at the canonical server, provided that these know a shared

secret. All messages of the intra-cluster talk are now

cryptographically signed using this shared secret.

In the current version, the shared secret key has to be specified in

the NaviServer configuration file (ClusterSecret). Later versions

will support the use of other measures such as generated keys, kept

as files.

Also in the new version it is still possible to use static peer

addresses (which do not have to register during startup).

- Support for multiple protocols for intra-cluster talk

Previous version of OpenACS required the communication of the

intra-cluster talk over HTTP. With these changes, multiple protocols

are supported. Most prominently HTTPS can be used, which is required

by some organization for all web communication, especially for cloud

applications. Other protocols might be added later (e.g. UDP).

- Nodes (such as the canonical server) can be specified via URL

locations. These location specifier have the following advantages

over classical IP address and port.

* support different protocols (http, https, udp)

* support of IP addresses or DNS names

* when DNS names map to multiple IP addresses

(e.g. multiple IPv4 and/or multiple IPv6 addresses)

the new parameter PreferredLocationRegexp can be use

to select the wanted. When this regexp does not match

any of the addresses, the first address is used.

* ports are now optional (except UDP)

* for location specifier: https://openacs.org

- Support for cluster communication statistics

(requires xotcl-request-monitor)

These statistics show the amount of intra-server

communication. The following statistics are collected

per node:

- number of broadcast operations

- number of send operations (active flushes)

- number of receive operation (passive flushes)

For N cluster nodes, the send operations are

basically the number of broadcast operations times

the number of nodes minus one.

These statistics can also be used prior to cluster

enabling, to obtain the number of potential broadcast

operations.

Kernel Parameters

CanonicalServer : location of the canonical server

ClusterAuthorizedIP : obsolete

ClusterEnabledP : unchanged

ClusterPeerIP : obsolete

EnableLoggingP : unchanged

PreferredLocationRegexp : new

DynamicClusterPeers : new, no not edit

Differences between old and new value for "CanonicalServer":

old:

- specify IP address with port

- example: 137.208.116.31:443

new:

- specify URL location

- support different protocols (http, https, udp)

- support of IP address or domain name

- when domain name maps to different IP addresses

(e.g. multiple IPv4 and/or multiple IPv6 addresses)

PreferredLocationRegexp can be use to select the wanted.

When the provided regexp does not match any of

the addresses, take the first address.

- port is optional

- example: https://openacs.org

Sample setup

Old:

CanonicalServer : 137.208.116.31:443

ClusterAuthorizedIP : 137.208.116.31

ClusterPeerIP : 137.208.116.31:443 137.208.116.31:8443

ClusterEnabledP : 1

EnableLoggingP : 1

New:

CanonicalServer : https://openacs.org

PreferredLocationRegexp : https://

ClusterEnabledP : 1

EnableLoggingP : 1

#

# Cluster secret for intra-cluster communications in NaviServer

# configuration file. Clustering will not be enabled if no value is

# provided.

#

ns_section ns/server/$server/acs {

# ...

ns_param ClusterSecret "please change me"

}

#-----------------------------------------------------------------------

# Support for munin statistics

#

# 1) install munin plugins for naviserver (munin-plugins-ns.git)

# 2) add link to the munin plugins (replace "openacs" by the name

# of your server in the munin configuration)

# /etc/munin/plugins/naviserver_openacs_count_cluster -> /usr/share/munin/plugins/naviserver_count

# 3) in the plugin plugin configuration (e.g., etc/munin/plugin-conf.d/naviserver)

# add a section like the following (again, replace "openacs" by the server name you used)

#

# [naviserver_openacs_count_cluster]

# env.title Cluster

# env.vars cluster:broadcast cluster:sent cluster:received

#

# 4) restart munin

Options
    • -5
    • +6
    ./acs-kernel.info
  2. … 4 more files in changeset.
12:47 pm

antoniop

Deprecate acs_privacy:: api and inline the few usages in the dotlrn packages

See https://openacs.org/forums/message-view?message_id=5672076

Options
    • -3
    • +3
    ./acs-kernel.info
  2. … 5 more files in changeset.
Thursday 01 Dec 2022
5:39 pm

gustafn

new partial index for a common query

... checking for "approved" members

Options
    • -2
    • +2
    ./acs-kernel.info
    • -1
    • +7
    ./sql/postgresql/groups-create.sql
    • -0
    • +5
    ./sql/postgresql/upgrade/upgrade-5.10.1d13-5.10.1d14.sql
5:39 pm

gustafn

file upgrade-5.10.1d13-5.10.1d14.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.10.1d13-5.10.1d14.sql
Thursday 27 Oct 2022
11:00 am

gustafn

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.

Options
    • -1
    • +22
    ./sql/postgresql/upgrade/upgrade-5.10.1d11-5.10.1d12.sql
Tuesday 11 Oct 2022
11:17 am

antoniop

Cleanup leftover util user messages, that we won't persist anymore

Options
    • -2
    • +2
    ./acs-kernel.info
    • -0
    • +6
    ./sql/postgresql/upgrade/upgrade-5.10.1d12-5.10.1d13.sql
11:17 am

antoniop

file upgrade-5.10.1d12-5.10.1d13.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.10.1d12-5.10.1d13.sql
Saturday 08 Oct 2022
10:07 pm

gustafn

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

Options
    • -2
    • +2
    ./acs-kernel.info
    • -308
    • +1
    ./sql/postgresql/acs-objects-create.sql
    • -5
    • +1
    ./sql/postgresql/acs-objects-drop.sql
    • -250
    • +42
    ./sql/postgresql/acs-permissions-create.sql
    • -4
    • +4
    ./sql/postgresql/acs-permissions-drop.sql
    • -0
    • +57
    ./sql/postgresql/upgrade/upgrade-5.10.1d11-5.10.1d12.sql
  7. … 4 more files in changeset.
10:07 pm

gustafn

file upgrade-5.10.1d11-5.10.1d12.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.10.1d11-5.10.1d12.sql
Saturday 30 Jul 2022
2:00 pm

gustafn

file upgrade-5.10.1d9-5.10.1d10.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.10.1d9-5.10.1d10.sql
2:00 pm

gustafn

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.

Options
    • -2
    • +2
    ./acs-kernel.info
    • -0
    • +340
    ./sql/postgresql/upgrade/upgrade-5.10.1d9-5.10.1d10.sql
Friday 22 Jul 2022
7:37 pm

gustafn

Added membership "expired" to membership states. "expired" can be

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

Options
    • -2
    • +2
    ./acs-kernel.info
    • -2
    • +2
    ./sql/oracle/groups-create.sql
    • -0
    • +9
    ./sql/oracle/upgrade/upgrade-5.10.1d8-5.10.1d9.sql
    • -2
    • +2
    ./sql/postgresql/groups-create.sql
    • -0
    • +9
    ./sql/postgresql/upgrade/upgrade-5.10.1d8-5.10.1d9.sql
7:37 pm

gustafn

file upgrade-5.10.1d8-5.10.1d9.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-5.10.1d8-5.10.1d9.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.10.1d8-5.10.1d9.sql
Wednesday 06 Jul 2022
5:37 pm

gustafn

added ADP:ICON to the list of accepted tags (for new instances)

Options
    • -3
    • +3
    ./acs-kernel.info
  2. … 1 more file in changeset.
Wednesday 02 Mar 2022
6:41 pm

gustafn

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.

Options
    • -1
    • +7
    ./sql/postgresql/upgrade/upgrade-5.10.0-5.10.1d1.sql
Wednesday 23 Feb 2022
7:24 pm

gustafn

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.

Options
    • -2
    • +2
    ./acs-kernel.info
    • -6
    • +6
    ./sql/oracle/utilities-create.sql
    • -0
    • +312
    ./sql/oracle/upgrade/upgrade-5.10.1d6-5.10.1d7.sql
    • -158
    • +157
    ./sql/postgresql/utilities-create.sql
    • -0
    • +167
    ./sql/postgresql/upgrade/upgrade-5.10.1d6-5.10.1d7.sql
7:24 pm

gustafn

file upgrade-5.10.1d6-5.10.1d7.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-5.10.1d6-5.10.1d7.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.10.1d6-5.10.1d7.sql
Monday 21 Feb 2022
6:57 pm

gustafn

file upgrade-5.10.1d5-5.10.1d6.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.10.1d5-5.10.1d6.sql
6:53 pm

gustafn

fix broken function_args definition

Options
    • -2
    • +2
    ./acs-kernel.info
    • -2
    • +2
    ./sql/postgresql/security-create.sql
    • -0
    • +2
    ./sql/postgresql/upgrade/upgrade-5.10.1d5-5.10.1d6.sql
  4. … 3 more files in changeset.
Thursday 17 Feb 2022
11:36 am

gustafn

Fixes for Oracle 19c: uppercase consistently in schema queries

All names in the schema data model are in Oracle in uppercase.

Options
    • -8
    • +8
    ./sql/oracle/utilities-create.sql