CVS log for loncom/lonsql

[BACK] Up to [LON-CAPA] / loncom

Request diff between arbitrary revisions


Keyword substitution: kv
Default branch: MAIN


Revision 1.98: download - view: text, markup, annotated - select for diffs
Wed Apr 24 01:44:38 2019 UTC (4 years, 11 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_12_X, version_2_11_X, version_2_11_4_uiuc, version_2_11_4_msu, version_2_11_4, version_2_11_3_uiuc, version_2_11_3_msu, version_2_11_3, HEAD
Diff to previous 1.97: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.97: +2 -1 lines
- Forgot Password utility
  - Support configurable: link lifetime, case sensitivity (for username and
    e-mail address), information required, e-mail types, and custom text.
  - Bug 6648: captcha can be enabled for public-facing web form.

Revision 1.97: download - view: text, markup, annotated - select for diffs
Mon Oct 29 02:57:30 2018 UTC (5 years, 5 months ago) by raeburn
Branches: MAIN
Diff to previous 1.96: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.96: +2 -2 lines
- Replace use of mailto (metamail package) with mail command.
  metamail was in Red Hat 7.3, but is absent from Fedora, CentOS, RHEL etc.

Revision 1.96: download - view: text, markup, annotated - select for diffs
Fri Oct 13 20:37:46 2017 UTC (6 years, 5 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_11_2_msu
Diff to previous 1.95: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.95: +14 -6 lines
- Domain configuration to override domain's helpdesk settings for e-mail
  recipients, and optionally added text, based on requester's affiliation
  (e.g., faculty, staff or student).

Revision 1.95: download - view: text, markup, annotated - select for diffs
Sun Aug 9 21:43:11 2015 UTC (8 years, 7 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_11_2_uiuc, version_2_11_2_educog, version_2_11_2
Diff to previous 1.94: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.94: +5 -4 lines
- Bug 5596
  - Message shown that initial retrieval of institutional data may take time.
  - Progress indicator displayed while enrollment in progress
  - Where institutional data are available for a user being added, that
    replaces data included in file upload.
  - Student/employee ID checking for both new users and existing users
    if rule(s) specified in localenroll.pm for domain, and enabled via:
    domain configuration > User Creation > Format rules to check for IDs.

Revision 1.94: download - view: text, markup, annotated - select for diffs
Wed Aug 5 18:47:12 2015 UTC (8 years, 7 months ago) by raeburn
Branches: MAIN
Diff to previous 1.93: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.93: +30 -1 lines
- Bug 5596.
  Add a routine to lonnet.pm -- get_multiple_instusers() which makes one call
  to lond > lonsql > localenroll.pm to retrieve institutional data
  for multiple users when adding users via file upload, to minimize number
  of sleep() commands needed. Supports up to 1s per query, on localenroll.pm
  side if adding more than 100 new users.

- Add new routine to localenroll.pm -- &get_multusersinfo() -- to retrieve
    institutional data for users being added via user file upload.

  Note: if this routine does not exist in localenroll.pm, will fall-back
  to retrieving institutional data using a separate call to &get_userinfo()
  for each user.

Revision 1.93: download - view: text, markup, annotated - select for diffs
Sun Dec 1 21:29:07 2013 UTC (10 years, 3 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_11_1, version_2_11_0_RC3, version_2_11_0_RC2, version_2_11_0
Diff to previous 1.92: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.92: +3 -3 lines
- Modify POD to eliminate errors seen with pod2man in perl 5.18

Revision 1.92: download - view: text, markup, annotated - select for diffs
Sun Sep 1 22:39:44 2013 UTC (10 years, 6 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_11_0_RC1
Diff to previous 1.91: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.91: +22 -4 lines
- Re-enable search across domains when querying metadata for resources on
  multi-domain servers. (to accommodate changes in lonsearchat rev. 1.322).

Revision 1.91: download - view: text, markup, annotated - select for diffs
Mon Nov 7 18:13:38 2011 UTC (12 years, 4 months ago) by raeburn
Branches: MAIN
CVS tags: language_hyphenation_merge, language_hyphenation, BZ4492-merge, BZ4492-feature_horizontal_radioresponse, BZ4492-feature_Support_horizontal_radioresponse, BZ4492-Support_horizontal_radioresponse
Diff to previous 1.90: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.90: +3 -3 lines
- use lonDocRoot perlvar in place of static string: '/home/httpd/html'.

Revision 1.90: download - view: text, markup, annotated - select for diffs
Tue Mar 11 01:45:47 2008 UTC (16 years ago) by raeburn
Branches: MAIN
CVS tags: version_2_9_X, version_2_9_99_0, version_2_9_1, version_2_9_0, version_2_8_X, version_2_8_99_1, version_2_8_99_0, version_2_8_2, version_2_8_1, version_2_8_0, version_2_7_X, version_2_7_99_1, version_2_7_99_0, version_2_7_1, version_2_7_0, version_2_6_X, version_2_6_99_1, version_2_6_99_0, version_2_6_3, version_2_10_X, version_2_10_1, version_2_10_0_RC2, version_2_10_0_RC1, version_2_10_0, loncapaMITrelate_1, bz6209-base, bz6209, bz5969, bz2851, PRINT_INCOMPLETE_base, PRINT_INCOMPLETE, GCI_3, GCI_2, GCI_1, BZ5971-printing-apage, BZ5434-fox
Diff to previous 1.89: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.89: +2 -2 lines
- scope

Revision 1.89: download - view: text, markup, annotated - select for diffs
Wed Sep 12 20:29:13 2007 UTC (16 years, 6 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_6_2, version_2_6_1, version_2_6_0, version_2_5_99_1, version_2_5_99_0
Diff to previous 1.88: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.88: +27 -1 lines
Namespacing of usernames.
lonnet.pm
 - &get_instuser() can check the institutional directory for a username or an ID.
                   -returns hash of user information (lastname,firstname etc.)
 - &inst_rulecheck() can check whether a username matches the formats of institutional username rules.
 - &inst_userrules() can retrieve information about username rules defined for the domain.
&get_instuser uses lonsql as a conduit to localenroll::get_userinfo() - operating in mode 1.
&inst_rulecheck() and &inst_userrules() use lond directly as the conduit to localenroll::username_check() and localenroll::username_rules() respectively

lond
 - &get_institutional_user_rules() is interface to localenroll::username_rules()
 - &institutional_username_check() is interface to localenroll::username_check()

lonsql
 - &get_inst_user() retrieves is interface to localenroll::get_userinfo()

Revision 1.88: download - view: text, markup, annotated - select for diffs
Wed Sep 12 03:40:29 2007 UTC (16 years, 6 months ago) by raeburn
Branches: MAIN
Diff to previous 1.87: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.87: +72 -55 lines
lonnet.pm
- usersearch() made more similar to other routines which use lonsql
   (records split on \n not &).
  - srchby, srchtype, and srchterm passed as separate arguments
  - backwards compatibility maintained with older lonsql
lonsql
- usersearch() query processing moved to subroutine.
- searchdomain implicitly from lonsql, isntead of arg in query
- backwards compatibility maintained with older lonnet:usersearch()
- escaping of result more consistent with other lonsql queries (replacement of & with \n in lond::reply_query_handler() now possible).

Revision 1.87: download - view: text, markup, annotated - select for diffs
Fri Aug 31 12:33:25 2007 UTC (16 years, 7 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_5_X, version_2_5_2, version_2_5_1
Diff to previous 1.86: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.86: +3 -1 lines
Institutional directory search now reported as unavailable in the case where a DC has enabled directory searching via "Modify domain configuration" but either:
 (a) localenroll::get_userinfo() has not been customized, or
 (b) an error ioccurred when querying the institutional directory.

lonsql
- &do_inst_dir_search() returns 'unavailable' if the response from localenroll::get_userinfo() is not 'ok'

lonnet.pm
- &inst_directory_query() now returns a scalar and a hash.
  - scalar is the outcome of the query: 'unavailable', 'ok' or ''.
  - hash contains the search results (if any matches)

loncreateuser.pm
- Report to user that institutional directory search is unavailable if response from &lonnet::inst_directory_query() is not 'ok'.

localenroll.pm
- documentation updated
- &get_userinfo() returns 'unavailable' by default

Revision 1.86: download - view: text, markup, annotated - select for diffs
Sat Aug 25 19:52:11 2007 UTC (16 years, 7 months ago) by raeburn
Branches: MAIN
Diff to previous 1.85: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.85: +5 -1 lines
Add "begins with" type searches - matched where target (uname, lastname, etc.) begins with search term.

Revision 1.85: download - view: text, markup, annotated - select for diffs
Sat Aug 25 13:45:56 2007 UTC (16 years, 7 months ago) by raeburn
Branches: MAIN
Diff to previous 1.84: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.84: +3 -1 lines
Remove any spaces adjacent to the comma separator in a lastname,firstname search.

Revision 1.84: download - view: text, markup, annotated - select for diffs
Wed Aug 8 22:24:36 2007 UTC (16 years, 7 months ago) by albertel
Branches: MAIN
CVS tags: version_2_5_0
Diff to previous 1.83: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.83: +28 -2 lines
- moving inst dir queries into lonsql

Revision 1.83: download - view: text, markup, annotated - select for diffs
Mon Jul 30 23:52:06 2007 UTC (16 years, 8 months ago) by albertel
Branches: MAIN
CVS tags: version_2_4_99_0
Diff to previous 1.82: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.82: +2 -2 lines
- support domain with - . in them

Revision 1.82: download - view: text, markup, annotated - select for diffs
Wed Jul 25 22:40:00 2007 UTC (16 years, 8 months ago) by raeburn
Branches: MAIN
Diff to previous 1.81: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.81: +91 -1 lines
- Add support for query set to 'usersearch'
- Searches an allusers MySQL table containing: username, domain, lastname, firstname, middlename, generation, id and permanentemail for all users in the domain.
- Can search by username, lastname or lastname,firstname
- Seach can require exact match, or can look for cases where search term is part of a longer string.

- Add support for query set to 'allusers'
- Updates MySQL table with new information for a particular user.
- Added subroutine: allusers_table_update() to access subroutines in LONCAPA::lonmetadata used to update the allusers table.

Revision 1.81: download - view: text, markup, annotated - select for diffs
Thu Apr 12 00:00:55 2007 UTC (16 years, 11 months ago) by albertel
Branches: MAIN
CVS tags: version_2_4_X, version_2_4_2, version_2_4_1, version_2_4_0, version_2_3_99_0
Diff to previous 1.80: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.80: +10 -130 lines
- switch to using lonnet.pm
- eliminate unneeded code
- remove unused packages

Revision 1.80: download - view: text, markup, annotated - select for diffs
Tue Apr 3 17:51:45 2007 UTC (16 years, 11 months ago) by raeburn
Branches: MAIN
Diff to previous 1.79: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.79: +5 -2 lines
- lonsql
  - Need to escape results from userlog queries (escaping of all results from lonsql eliminated in 1.50).
  - Allow filtering of user's activity.log for 'Role'
  - Include host in information returned for userlog query

- Autoupdate.pl
  - &lonnet::get_my_roles() by default gets roles from nohist_userroles.  Use in Autoupdate wants information about a user's own roles (from roles.db) - use context as argument
  - warning messagea when username changed (assumes fixed student ID). prints to screen
for now (log to file would be preferred)

- lonnet.pm
  - documentation for &userfileupload
  - get_my_roles() now includes optional context which determines which db file is target for dump (default is nohist_userroles, context of 'userroles' sets target to roles.db
  - documentation for &userlog_query() - now includes hostID
  - documentation updated for &get_my_roles().

Revision 1.79: download - view: text, markup, annotated - select for diffs
Wed Jan 3 01:59:42 2007 UTC (17 years, 2 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_3_X, version_2_3_2, version_2_3_1
Diff to previous 1.78: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.78: +7 -5 lines
Renaming and deletion of portfolio files now causes removal of records in MySQL portfolio_metadata and portfolio_addedfield tables for old file name.

Arguments passed to lonsql via a querysend to lond changed - $arg1 now colon-separated uname,domain,group; $arg3 -now action (e.g., delete).

Revision 1.78: download - view: text, markup, annotated - select for diffs
Tue Jan 2 12:51:31 2007 UTC (17 years, 2 months ago) by raeburn
Branches: MAIN
Diff to previous 1.77: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.77: +167 -1 lines
portfolio_metadata, portfolio_addedfields and portfolio_access tables in MySQL updated when portfolio access controls are modified or when portfolio metadata is updated.

Some routines in searchcat.pl moved to LONCAPA::lonmetadata.pm so they are available to lonsql when performing MySQL table updates on the library server which houses the portfolio files.

metadata updates and access control updates from lonmeta and lonnet::modify_access_controls are routed through lonnet::update_portfolio_table() which in turn does a querysend to dispatch a query to lonsql (via lond).

Only access control settings for public and passphrase-protected controls are stored in the portfolio_access MySQL table.

Revision 1.77: download - view: text, markup, annotated - select for diffs
Thu May 11 17:53:22 2006 UTC (17 years, 10 months ago) by albertel
Branches: MAIN
CVS tags: version_2_3_0, version_2_2_X, version_2_2_99_1, version_2_2_99_0, version_2_2_2, version_2_2_1, version_2_2_0, version_2_1_99_3, version_2_1_99_2, version_2_1_99_1, version_2_1_99_0
Diff to previous 1.76: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.76: +2 -47 lines
- removing some code duplication

Revision 1.71.2.2: download - view: text, markup, annotated - select for diffs
Mon Mar 27 19:51:42 2006 UTC (18 years ago) by albertel
Branches: version_2_1_X
CVS tags: version_2_1_3
Diff to previous 1.71.2.1: preferred, colored next main 1.72: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.71.2.1: +16 -4 lines
- backport 1.73,74

Revision 1.76: download - view: text, markup, annotated - select for diffs
Fri Feb 10 09:51:27 2006 UTC (18 years, 1 month ago) by albertel
Branches: MAIN
Diff to previous 1.75: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.75: +1 -2 lines
9- remove log spew

Revision 1.71.2.1: download - view: text, markup, annotated - select for diffs
Fri Feb 10 09:50:50 2006 UTC (18 years, 1 month ago) by albertel
Branches: version_2_1_X
Diff to previous 1.71: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.71: +8 -2 lines
- backport 1.75

Revision 1.75: download - view: text, markup, annotated - select for diffs
Fri Feb 10 09:47:36 2006 UTC (18 years, 1 month ago) by albertel
Branches: MAIN
Diff to previous 1.74: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.74: +9 -2 lines
- eval the new photo routines so lond/sql don't die in the middle of them

Revision 1.74: download - view: text, markup, annotated - select for diffs
Wed Feb 8 21:17:53 2006 UTC (18 years, 1 month ago) by www
Branches: MAIN
Diff to previous 1.73: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.73: +14 -4 lines
Bug #4531: limit search to queried domain on multidomain machines

Revision 1.73: download - view: text, markup, annotated - select for diffs
Wed Feb 8 17:11:46 2006 UTC (18 years, 1 month ago) by www
Branches: MAIN
Diff to previous 1.72: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.72: +3 -1 lines
Prepare to do filtering of lonsql results based on the domain that lond is
running under

Revision 1.72: download - view: text, markup, annotated - select for diffs
Tue Feb 7 22:30:31 2006 UTC (18 years, 1 month ago) by albertel
Branches: MAIN
Diff to previous 1.71: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.71: +5 -3 lines
- &reply() needs to connect to the correct location

Revision 1.71: download - view: text, markup, annotated - select for diffs
Tue Feb 7 16:20:39 2006 UTC (18 years, 1 month ago) by albertel
Branches: MAIN
Branch point for: version_2_1_X
Diff to previous 1.70: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.70: +2 -2 lines
- style police

Revision 1.70: download - view: text, markup, annotated - select for diffs
Tue Feb 7 05:08:27 2006 UTC (18 years, 1 month ago) by raeburn
Branches: MAIN
Diff to previous 1.69: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.69: +9 -3 lines
Add support for student photo import from an institutional repository. Availability of photos of registered students in a course controlled by course environment parameter: 'internal.studentphoto'.  This may be configured to require initial acceptance of conditions of use by course owner.  View classlist in ENRL, and Automated Enrollment Manager now includes option to display thumbnails of student photos.  Nightly enrollment update can import student photos for students added to a course.  Student photos can be updated via the Automated Enrollment Manager.

Revision 1.69: download - view: text, markup, annotated - select for diffs
Thu Nov 24 20:03:49 2005 UTC (18 years, 4 months ago) by www
Branches: MAIN
CVS tags: version_2_1_2, version_2_1_1, version_2_1_0, version_2_0_99_1
Diff to previous 1.68: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.68: +2 -2 lines
Log spam

Revision 1.68: download - view: text, markup, annotated - select for diffs
Mon Nov 7 15:43:03 2005 UTC (18 years, 4 months ago) by raeburn
Branches: MAIN
Diff to previous 1.67: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.67: +2 -2 lines
Bug 4441. Accommodation of non-word characters in institutional codes. Sanity checking now needed.

Revision 1.67: download - view: text, markup, annotated - select for diffs
Wed Apr 13 18:39:13 2005 UTC (18 years, 11 months ago) by albertel
Branches: MAIN
CVS tags: version_2_0_X, version_2_0_2, version_2_0_1, version_2_0_0, version_1_99_3, version_1_99_2, version_1_99_1_tmcc, version_1_99_1, version_1_99_0_tmcc, version_1_99_0
Diff to previous 1.66: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.66: +2 -1 lines
- if we can connect remove the file the says we can't

Revision 1.66: download - view: text, markup, annotated - select for diffs
Wed Feb 9 20:39:47 2005 UTC (19 years, 1 month ago) by albertel
Branches: MAIN
Diff to previous 1.65: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.65: +3 -5 lines
- IP removal from hosts.tab

Revision 1.65: download - view: text, markup, annotated - select for diffs
Thu Aug 26 19:29:09 2004 UTC (19 years, 7 months ago) by albertel
Branches: MAIN
CVS tags: version_1_3_X, version_1_3_3, version_1_3_2, version_1_3_1, version_1_3_0, version_1_2_X, version_1_2_99_1, version_1_2_99_0, version_1_2_1, version_1_2_0
Diff to previous 1.64: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.64: +3 -3 lines
-  4 is enough

Revision 1.64: download - view: text, markup, annotated - select for diffs
Fri Aug 20 16:42:41 2004 UTC (19 years, 7 months ago) by matthew
Branches: MAIN
Diff to previous 1.63: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.63: +5 -19 lines
Removed some commented out code, specify full path to parse_activity_log.pl,
additional logging code is intentional.

Revision 1.63: download - view: text, markup, annotated - select for diffs
Wed Jul 28 20:46:28 2004 UTC (19 years, 8 months ago) by matthew
Branches: MAIN
Diff to previous 1.62: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.62: +47 -1 lines
Updates for activity log work.

Revision 1.62: download - view: text, markup, annotated - select for diffs
Tue Jun 8 22:09:44 2004 UTC (19 years, 9 months ago) by raeburn
Branches: MAIN
CVS tags: version_1_1_99_5, version_1_1_99_4, version_1_1_99_3, version_1_1_99_2, version_1_1_99_1
Diff to previous 1.61: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.61: +19 -1 lines
Changes to support autoenroll calls from a remote server.

lond on the homeserver for the course(s) handles requests from the remote
server for institutional data (e.g., classlists, valid institutional courseIDs,
institutional section numbers for a course code, validation of course owners), by
calling the appropriate functions in the homeserver's localenroll.pm

All replies are made directly with the exception of fetch_enrollment_query, which
is shipped over to lonsql, in case retrieval of institutional classlists is a
protracted process.

lonsql on the homeserver for the course(s) calls localenroll::fetch_enrollment()
and writes XML files of enrollment data to /home/httpd/perl/tmp

Transfer of classlist data occurs later following an autoretrieve call from the
remote server. It is planned to generalize this function and add encryption to the transfer back to the client.

Autoenroll.pl called by cron on a library server, now only carries out updates for
courses in its domain, for which the library server is the course's homeserver. If a domain has multiple library servers Autoenroll.pl will need to be run on each library server.

Revision 1.61: download - view: text, markup, annotated - select for diffs
Thu May 20 14:15:29 2004 UTC (19 years, 10 months ago) by matthew
Branches: MAIN
CVS tags: version_1_1_99_0
Diff to previous 1.60: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.60: +2 -2 lines
Bug 3026: Remove logging spew.

Revision 1.60: download - view: text, markup, annotated - select for diffs
Tue May 11 21:08:20 2004 UTC (19 years, 10 months ago) by matthew
Branches: MAIN
Diff to previous 1.59: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.59: +1 -3 lines
Removed extra newline in lonsql return value.

Revision 1.59: download - view: text, markup, annotated - select for diffs
Tue May 11 20:03:05 2004 UTC (19 years, 10 months ago) by albertel
Branches: MAIN
Diff to previous 1.58: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.58: +8 -8 lines

-more xhtmlized

Revision 1.58: download - view: text, markup, annotated - select for diffs
Mon May 3 16:20:57 2004 UTC (19 years, 10 months ago) by matthew
Branches: MAIN
Diff to previous 1.57: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.57: +5 -50 lines
Removed out of date POD.  Report database errors using $sth->errstr() when
there is an error, instead of using $@.

Revision 1.57: download - view: text, markup, annotated - select for diffs
Wed Jul 30 16:49:27 2003 UTC (20 years, 8 months ago) by www
Branches: MAIN
CVS tags: version_1_1_X, version_1_1_3, version_1_1_2, version_1_1_1, version_1_1_0, version_1_0_99_3, version_1_0_99_2, version_1_0_99_1, version_1_0_99, version_1_0_3, version_1_0_2, version_1_0_1, version_1_0_0, version_0_99_5, version_0_99_4
Diff to previous 1.56: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.56: +6 -1 lines
Simple one-line status for cluster-wide automated reporting

Revision 1.56: download - view: text, markup, annotated - select for diffs
Fri Jul 25 17:07:06 2003 UTC (20 years, 8 months ago) by bowersj2
Branches: MAIN
Diff to previous 1.55: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.55: +89 -3 lines
SessionThre2.html from the Guts manual.

Revision 1.55: download - view: text, markup, annotated - select for diffs
Mon Feb 3 13:43:38 2003 UTC (21 years, 1 month ago) by albertel
Branches: MAIN
CVS tags: version_0_99_3, version_0_99_2, version_0_99_1, version_0_99_0, conference_2003
Diff to previous 1.54: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.54: +2 -2 lines
- cleaning out unnessceary comments

Revision 1.54: download - view: text, markup, annotated - select for diffs
Mon Feb 3 05:08:06 2003 UTC (21 years, 1 month ago) by harris41
Branches: MAIN
Diff to previous 1.53: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.53: +2 -3 lines
I don't know whether to laugh or cry.

Revision 1.53: download - view: text, markup, annotated - select for diffs
Mon Sep 9 14:04:02 2002 UTC (21 years, 6 months ago) by harris41
Branches: MAIN
CVS tags: version_0_6_2, version_0_6
Diff to previous 1.52: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.52: +2 -3 lines
loncapa_apache.conf should not be directly specified (and certainly not
before loncapa.conf)

Revision 1.52: download - view: text, markup, annotated - select for diffs
Tue Aug 13 19:40:57 2002 UTC (21 years, 7 months ago) by matthew
Branches: MAIN
Diff to previous 1.51: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.51: +81 -74 lines
This appears to work, but frankly I wouldn't trust it.  Fixed enough of the
errors that it runs, forks, and returns search results.  Theoretically, it
should also do the logfile searches, too.

Revision 1.51: download - view: text, markup, annotated - select for diffs
Tue Aug 6 13:48:47 2002 UTC (21 years, 7 months ago) by matthew
Branches: MAIN
Diff to previous 1.50: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.50: +636 -413 lines
Many, many changes.
THIS CODE SHOULD NOT BE USED AT THIS TIME.  It does not run.

Added POD comments everywhere.
Now use File::Find instead of requiring find.pl, which I could never find.
Now use strict.
Rearranged most of the code.
Added &do_sql_query.
&userlog and &courselog were not modified but were moved.

Revision 1.50: download - view: text, markup, annotated - select for diffs
Fri Jul 5 15:07:59 2002 UTC (21 years, 8 months ago) by matthew
Branches: MAIN
CVS tags: version_0_5_1, version_0_5, version_0_4, stable_2002_july, STABLE
Diff to previous 1.49: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.49: +4 -4 lines
Removed superflous re-escaping of results.  The offending call to escape
resulted in there being no '&' symbols in the returned file.  lond
translates '&' to "\n" when it writes the file.  lonsearchcat expects
one record per line.

Revision 1.49: download - view: text, markup, annotated - select for diffs
Mon Jun 24 14:22:05 2002 UTC (21 years, 9 months ago) by www
Branches: MAIN
Diff to previous 1.48: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.48: +24 -5 lines
Handle doubly-used delimiter "&" in activity.log, install more filters for
userlog.

Revision 1.48: download - view: text, markup, annotated - select for diffs
Tue Jun 18 21:14:23 2002 UTC (21 years, 9 months ago) by www
Branches: MAIN
Diff to previous 1.47: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.47: +3 -1 lines
Values in logs are escaped

Revision 1.47: download - view: text, markup, annotated - select for diffs
Tue Jun 18 19:39:13 2002 UTC (21 years, 9 months ago) by www
Branches: MAIN
Diff to previous 1.46: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.46: +26 -6 lines
Toward bug 121 - filters start to work now.

lonsearchcat display definitely broken due to "escape" bugfix in lonsql.

Revision 1.46: download - view: text, markup, annotated - select for diffs
Tue Jun 18 15:04:05 2002 UTC (21 years, 9 months ago) by www
Branches: MAIN
Diff to previous 1.45: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.45: +43 -18 lines
Toward bug 121.
lonnet now has routines to query course and user activity logs.
lonsql userlog already does some stuff.
Left to do: implement filters!
BUGFIX: lonsql was not escaping the query result. A ":" in any of the fields
would truncate the reply. lonsearchcat likely has to be adapted to unescape.

Revision 1.45: download - view: text, markup, annotated - select for diffs
Mon Jun 17 20:25:51 2002 UTC (21 years, 9 months ago) by www
Branches: MAIN
Diff to previous 1.44: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.44: +63 -16 lines
New routines for userlog and courselog queries.

BUGFIX: $result had the wrong scope.

Revision 1.44: download - view: text, markup, annotated - select for diffs
Mon Jun 17 14:00:09 2002 UTC (21 years, 9 months ago) by www
Branches: MAIN
Diff to previous 1.43: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.43: +18 -4 lines
Towards bug 121

If the query command is 'logquery' instead of an SQL command, lonsql will
go into another program block. Functionality to query logs should be
implemented there.

Also bugfix: a query-reply must ALWAYS have an "\n" in the end, or the
remote end will wait forever. Previous statement "append if $result" might
lead to lengthy timeout results if database is offline.

Revision 1.43: download - view: text, markup, annotated - select for diffs
Fri May 17 14:03:04 2002 UTC (21 years, 10 months ago) by matthew
Branches: MAIN
Diff to previous 1.42: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.42: +5 -4 lines
Replaced access.conf with loncapa_apache.conf.

Revision 1.42: download - view: text, markup, annotated - select for diffs
Sat May 11 21:26:53 2002 UTC (21 years, 10 months ago) by harris41
Branches: MAIN
Diff to previous 1.41: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.41: +9 -12 lines
using LONCAPA::Configuration::read_conf
BUG 129

Revision 1.41: download - view: text, markup, annotated - select for diffs
Thu Dec 20 17:43:05 2001 UTC (22 years, 3 months ago) by harris41
Branches: MAIN
CVS tags: stable_2002_spring, stable_2002_april
Diff to previous 1.40: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.40: +31 -8 lines
adding POD; removing void context map statements -Scott Harrison

Revision 1.40: download - view: text, markup, annotated - select for diffs
Thu Nov 29 14:59:52 2001 UTC (22 years, 4 months ago) by harris41
Branches: MAIN
Diff to previous 1.39: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.39: +86 -2 lines
updating documentation -Scott

Revision 1.39: download - view: text, markup, annotated - select for diffs
Thu Nov 29 13:53:56 2001 UTC (22 years, 4 months ago) by harris41
Branches: MAIN
Diff to previous 1.38: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.38: +12 -0 lines
minor edits to documentation -Scott

Revision 1.38: download - view: text, markup, annotated - select for diffs
Wed Nov 28 21:49:27 2001 UTC (22 years, 4 months ago) by harris41
Branches: MAIN
Diff to previous 1.37: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.37: +5 -1 lines
email admins if their sql setup is bad -Scott

Revision 1.37: download - view: text, markup, annotated - select for diffs
Wed Oct 17 02:15:59 2001 UTC (22 years, 5 months ago) by harris41
Branches: MAIN
CVS tags: stable_2001_fall
Diff to previous 1.36: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.36: +1 -1 lines
never output regular metadata in custom metadata output...
single or multiple lines...

Revision 1.36: download - view: text, markup, annotated - select for diffs
Thu Aug 30 13:57:04 2001 UTC (22 years, 7 months ago) by www
Branches: MAIN
Diff to previous 1.35: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.35: +4 -0 lines
One forth of the initial prefork

Revision 1.35: download - view: text, markup, annotated - select for diffs
Tue Apr 17 15:47:19 2001 UTC (22 years, 11 months ago) by harris41
Branches: MAIN
Diff to previous 1.34: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.34: +1 -1 lines
important to be case sensitive when retrieving custom-limited information
-Scott

Revision 1.34: download - view: text, markup, annotated - select for diffs
Mon Apr 16 18:51:22 2001 UTC (22 years, 11 months ago) by harris41
Branches: MAIN
Diff to previous 1.33: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.33: +35 -2 lines
only looking at current versions for home user resources .. adding
in this filter -Scott

Revision 1.33: download - view: text, markup, annotated - select for diffs
Mon Apr 16 18:36:22 2001 UTC (22 years, 11 months ago) by harris41
Branches: MAIN
Diff to previous 1.32: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.32: +1 -0 lines
subreply HAS to be called to get the information back to the lond
layer -Scott

Revision 1.32: download - view: text, markup, annotated - select for diffs
Mon Apr 16 13:47:50 2001 UTC (22 years, 11 months ago) by harris41
Branches: MAIN
Diff to previous 1.31: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.31: +0 -1 lines
 moving extraneous new line -Scott

Revision 1.31: download - view: text, markup, annotated - select for diffs
Wed Apr 11 20:05:29 2001 UTC (22 years, 11 months ago) by harris41
Branches: MAIN
Diff to previous 1.30: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.30: +15 -13 lines
using sql password present in root read-only /etc/httpd/conf/access.conf

Revision 1.30: download - view: text, markup, annotated - select for diffs
Mon Apr 2 20:16:31 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.29: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.29: +13 -1 lines
ok.. putting in safeguard to make sure lonsql NEVER starts when
the database is down -Scott

Revision 1.29: download - view: text, markup, annotated - select for diffs
Mon Apr 2 20:10:09 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.28: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.28: +0 -2 lines
make sure that the child dies immediately if cannot connect to database
-Scott

Revision 1.28: download - view: text, markup, annotated - select for diffs
Mon Apr 2 14:42:26 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.27: preferred, colored
Changes since revision 1.27: +1 -1 lines
trying to get custom information without a specific custom query -Scott

Revision 1.27: download - view: text, markup, annotated - [selected for diffs]
Tue Mar 27 20:08:23 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.26: preferred, colored
Changes since revision 1.26: +1 -1 lines
wrong argument passed to sql prepare statement -Scott

Revision 1.26: download - view: text, markup, annotated - select for diffs
Tue Mar 27 19:57:53 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.25: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.25: +32 -17 lines
okay... custom metadata passing should work now -Scott

Revision 1.25: download - view: text, markup, annotated - select for diffs
Tue Mar 27 19:11:12 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.24: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.24: +3 -1 lines
trying to make sure query is logged for debuggiing.. -Scott

Revision 1.24: download - view: text, markup, annotated - select for diffs
Tue Mar 27 19:01:05 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.23: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.23: +2 -0 lines
minor improvements... -Scott

Revision 1.23: download - view: text, markup, annotated - select for diffs
Tue Mar 27 18:38:59 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.22: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.22: +2 -2 lines
forgot a period for adding .meta suffix.. the shame -Scott

Revision 1.22: download - view: text, markup, annotated - select for diffs
Tue Mar 27 18:34:03 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.21: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.21: +1 -1 lines
enabling debug statement again -Scott

Revision 1.21: download - view: text, markup, annotated - select for diffs
Tue Mar 27 13:35:35 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.20: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.20: +3 -1 lines
more changes to support bleeping custom metadata -Scott

Revision 1.20: download - view: text, markup, annotated - select for diffs
Tue Mar 27 12:49:18 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.19: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.19: +17 -6 lines
better changes for finding and passing metadata -Scott

Revision 1.19: download - view: text, markup, annotated - select for diffs
Tue Mar 27 02:22:02 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.18: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.18: +4 -2 lines
do not send unnecessary newlines and be sure to send the url field -Scott

Revision 1.18: download - view: text, markup, annotated - select for diffs
Tue Mar 27 02:09:50 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.17: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.17: +7 -1 lines
filtering out relevant part of .meta files to send regarding custom
information -Scott

Revision 1.17: download - view: text, markup, annotated - select for diffs
Mon Mar 26 20:43:04 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.16: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.16: +4 -4 lines
okay.. need to make sure newline is in right place.. done with
debugging .-Scott

Revision 1.16: download - view: text, markup, annotated - select for diffs
Mon Mar 26 20:38:12 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.15: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.15: +1 -1 lines
oh.. the newline thing.. -Scott

Revision 1.15: download - view: text, markup, annotated - select for diffs
Mon Mar 26 20:31:25 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.14: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.14: +2 -2 lines
more debuggin grrrrrrrrrrr -Scott

Revision 1.14: download - view: text, markup, annotated - select for diffs
Mon Mar 26 20:28:34 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.13: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.13: +2 -2 lines
debugging this sob bug -Scott

Revision 1.13: download - view: text, markup, annotated - select for diffs
Mon Mar 26 20:17:20 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.12: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.12: +1 -0 lines
trying

Revision 1.12: download - view: text, markup, annotated - select for diffs
Mon Mar 26 20:01:30 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.11: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.11: +3 -0 lines
am actually passing relevant custom metadata information..
this may change the "logistics" of passing resource metadata
in the future.. -Scott

Revision 1.11: download - view: text, markup, annotated - select for diffs
Mon Mar 26 19:46:47 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.10: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.10: +8 -0 lines
beginning to traverse the resource file tree for .meta and
actually execute custom metadata query -Scott

Revision 1.10: download - view: text, markup, annotated - select for diffs
Thu Mar 22 19:25:52 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.9: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.9: +5 -0 lines
commenting in how I will reconcile sql-query results with custom metadata
query results -Scott

Revision 1.9: download - view: text, markup, annotated - select for diffs
Thu Mar 22 17:23:19 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.8: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.8: +16 -2 lines
grabbing list of all .meta files -Scott

Revision 1.8: download - view: text, markup, annotated - select for diffs
Thu Mar 22 16:10:53 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.7: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.7: +2 -0 lines
logging attempt at a custom query

Revision 1.7: download - view: text, markup, annotated - select for diffs
Thu Mar 22 15:21:54 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.6: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.6: +6 -2 lines
accepting input for custom metadata query and commented where I need
to implement directory traversal/*.meta searching -Scott

Revision 1.6: download - view: text, markup, annotated - select for diffs
Thu Mar 15 14:26:56 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.5: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.5: +1 -0 lines
just adding note about authorship -Scott

Revision 1.5: download - view: text, markup, annotated - select for diffs
Wed Mar 14 14:19:44 2001 UTC (23 years ago) by harris41
Branches: MAIN
Diff to previous 1.4: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.4: +1 -1 lines
alteration to stupid password -Scott

Revision 1.4: download - view: text, markup, annotated - select for diffs
Tue Jul 25 16:06:57 2000 UTC (23 years, 8 months ago) by www
Branches: MAIN
Diff to previous 1.3: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.3: +12 -0 lines
Check if already running

Revision 1.3: download - view: text, markup, annotated - select for diffs
Sun Jul 2 04:01:56 2000 UTC (23 years, 9 months ago) by harris41
Branches: MAIN
Diff to previous 1.2: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.2: +30 -11 lines
implemented error-free fetching

Revision 1.2: download - view: text, markup, annotated - select for diffs
Mon Jun 26 02:42:42 2000 UTC (23 years, 9 months ago) by harris41
Branches: MAIN
Diff to previous 1.1: preferred, colored to selected 1.27: preferred, colored
Changes since revision 1.1: +117 -195 lines
improving functionality

Revision 1.1: download - view: text, markup, annotated - select for diffs
Mon May 8 15:14:27 2000 UTC (23 years, 10 months ago) by harris41
Branches: MAIN
Diff to selected 1.27: preferred, colored
file for refereeing database/SQL processes

Diff request

This form allows you to request diffs between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.

Log view options

FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>