* $Header$
*
* Copyright (C) 1987 by the Massachusetts Institute of Technology
+ * For copying and distribution information, please see the file
+ * <mit-copyright.h>.
*
- * $Log$
- * Revision 1.17 1988-01-04 12:09:00 mar
- * fixup pobox access checking & make id assignment more paranoid (wesommer)
- *
-Revision 1.16 87/11/12 18:16:56 wesommer
-Add support for delete_user_by_uid.
-Fix access_pop.
-Check a few return codes.
-
-Revision 1.15 87/09/11 15:31:58 wesommer
-add_user_group modified to side-effect the time for tbs for groups as
-well as the other things.
-
-Revision 1.15 87/09/10 22:44:49 wesommer
-One more table needs to be modified when adding the user-group.
-
-Revision 1.14 87/09/04 17:50:03 mike
-Renamed delete_list_members to followup_delete_list. New routine removes
-list from maillists and groups tables in addition to the members table.
-
-Added routines validate_label and validate_label_2 used in validating
-filesys labels for get_filesys and delete_filesys respectively.
-
-Revision 1.13 87/09/01 16:24:01 wesommer
-A list should be considered modified if its acl changes.
-
-Revision 1.12 87/08/29 00:05:54 mike
-Fixed bug in check_nfs.
-Added code to upcasify machine names in validate_id.
-
-Revision 1.11 87/08/28 14:55:45 mike
-Modified delete_locker to require only one argument, the login name.
-Modified get_groups_of_all_users and get_all_poboxes to disable INGRES
-table locking.
-
-Revision 1.10 87/08/25 15:56:54 mike
-- Fixed bugs in get_groups_of_all_users
-- Added tblstats updates to add_user_group
-- Added routines: add_hostaccess (ashi), delete_hostaccess (dshi),
- followup_ushp, and followup_usha
-
-Revision 1.9 87/08/22 17:41:34 wesommer
-More of Mike's changes.
-
-Revision 1.8 87/08/18 15:05:20 wesommer
-Fixed definition of add_locker.
-
-Revision 1.7 87/08/04 01:49:41 wesommer
-Rearranged messages.
-
-Revision 1.6 87/08/04 01:10:02 wesommer
-Changes by mike; checked in prior to my hacking.
-
-Revision 1.5 87/07/30 14:54:13 wesommer
-Added debugging code in an attempt to catch a flakey problem.
-
-Revision 1.4 87/07/30 00:30:21 wesommer
-replaced appends = appends+1 with appends = tbs.appends+1
-
-Revision 1.3 87/07/30 00:26:11 wesommer
-Changes by mike prior to "appends" fix.
-
-Revision 1.2 87/07/29 16:00:39 wesommer
-Fixed add_locker.
-
-Revision 1.1 87/07/29 15:13:57 wesommer
-Initial revision
-
*/
#ifndef lint
static char *rcsid_qsupport_qc = "$Header$";
#endif lint
+#include <mit-copyright.h>
#include "query.h"
-#include "sms_server.h"
+#include "mr_server.h"
#include <ctype.h>
-#define SMS_SUCCESS 0
-extern char *whoami;
+extern char *whoami, *strsave();
+extern int ingres_errno, mr_errcode;
+
/* Specialized Access Routines */
-/**
- ** access_user - verify that client name equals specified login name
- **
- ** Used by: update_user_shell
- ** update_finger_by_login
- **
- ** - since field validation routines are called first, a users_id is
- ** now in argv[0] instead of the login name. Therefore, we must
- ** convert the client name to a users_id.
- **/
+/* access_user - verify that client name equals specified login name
+ *
+ * - since field validation routines are called first, a users_id is
+ * now in argv[0] instead of the login name.
+ */
access_user(q, argv, cl)
struct query *q;
char *argv[];
client *cl;
-##{
- register struct krbname *krb;
-## int client_id;
-## char *client_name;
-## int rowcount;
-
- client_name = cl->kname.name;
-## repeat retrieve (client_id = users.users_id)
-## where users.login = @client_name
-## inquire_equel (rowcount = "rowcount")
- if (rowcount != 1) return(SMS_PERM);
- if (client_id != *(int *)argv[0]) return(SMS_PERM);
+{
+ if (cl->users_id != *(int *)argv[0])
+ return(MR_PERM);
+ else
+ return(MR_SUCCESS);
+}
- return(SMS_SUCCESS);
-##}
-/**
- ** access_pop - same as access_user plus verifies that a user has only one
- ** mailbox of type "POP"
- **
- ** Inputs:
- ** argv[0] - users_id
- ** argv[1] - type
- ** argv[2] - mach_id
- ** argv[3] - box
- **
- ** Description:
- ** - if q->name = "add_pobox" and type = "POP",
- ** verify that no POP box already exists for user
- ** - call access_user
- **
- **/
-access_pop(q, argv, cl)
+/* access_login - verify that client name equals specified login name
+ *
+ * argv[0...n] contain search info. q->
+ */
+
+access_login(q, argv, cl)
struct query *q;
char *argv[];
client *cl;
##{
-## int users_id;
-## int mach_id;
-## char *box;
-## int exists;
+## int rowcount, id;
+## char qual[256];
- if (!bcmp(q->name, "add_pobox", 10) && !bcmp(argv[1], "POP", 4)) {
- box = argv[3];
- if (strcmp(cl->kname.name, box) != 0) return SMS_PERM;
-
- users_id = *(int *)argv[0];
- mach_id = *(int *)argv[2];
-
-## range of p is pobox
-## repeat retrieve (exists = any(p.#box where p.#users_id = @users_id
-## and p.type = "POP"))
- if (exists) return(SMS_EXISTS);
- }
-
- return(access_user(q, argv, cl));
+ build_qual(q->qual, q->argc, argv, qual);
+## range of u is users
+## retrieve (id = u.users_id) where qual
+## inquire_equel(rowcount = "rowcount")
+ if (rowcount != 1 || id != cl->users_id)
+ return(MR_PERM);
+ else
+ return(MR_SUCCESS);
##}
-/**
- ** access_list - check access for adding or deleting list members
- **
- ** Inputs: argv[0] - list_id
- ** cl->krb.name - client name
- **
- ** - check that client is a member of the access control list
- ** - OR, if q->shortname == {amtl | dfml} and
- ** if list.flags & LF_PUBLIC, allow access if client = member
- **
- **/
+
+
+/* access_list - check access for most list operations
+ *
+ * Inputs: argv[0] - list_id
+ * q - query name
+ * argv[2] - member ID (only for queries "amtl" and "dmfl")
+ * argv[7] - group IID (only for query "ulis")
+ * cl - client name
+ *
+ * - check that client is a member of the access control list
+ * - OR, if the query is add_member_to_list or delete_member_from_list
+ * and the list is public, allow access if client = member
+ */
access_list(q, argv, cl)
struct query *q;
char *argv[];
client *cl;
##{
-## int list_id;
-## int acl_id;
-## int flags;
- int member_id;
+## int list_id, acl_id, flags, rowcount, gid;
+## char acl_type[9];
char *client_type;
- int client_id;
- int status;
- int exists;
+ int client_id, status;
list_id = *(int *)argv[0];
-## repeat retrieve (acl_id = list.#acl_id, flags = list.#flags)
+## repeat retrieve (acl_id = list.#acl_id, acl_type = list.#acl_type,
+## gid = list.#gid, flags = list.#public)
## where list.#list_id = @list_id
+## inquire_equel(rowcount = "rowcount")
+ if (rowcount != 1)
+ return(MR_INTERNAL);
/* parse client structure */
- status = get_client(cl, &client_type, &client_id);
- if (status != SMS_SUCCESS) return(status);
+ if ((status = get_client(cl, &client_type, &client_id)) != MR_SUCCESS)
+ return(status);
/* if amtl or dmfl and list is public allow client to add or delete self */
- if (!bcmp("amtl", q->shortname, 4) || !bcmp("dmfl", q->shortname, 4)) {
- if ((flags & LF_PUBLIC) && !bcmp("USER", argv[1], 4)) {
- member_id = *(int *)argv[2];
- if (member_id == client_id) return(SMS_SUCCESS);
- }
+ if (((!strcmp("amtl", q->shortname) && flags) ||
+ (!strcmp("dmfl", q->shortname))) &&
+ (!strcmp("USER", argv[1]))) {
+ if (*(int *)argv[2] == client_id) return(MR_SUCCESS);
+ /* if update_list, don't allow them to change the GID */
+ } else if (!strcmp("ulis", q->shortname)) {
+ if ((!strcmp(argv[7], UNIQUE_GID) && (gid != -1)) ||
+ (strcmp(argv[7], UNIQUE_GID) && (gid != atoi(argv[7]))))
+ return(MR_PERM);
}
/* check for client in access control list */
- exists = find_member(acl_id, client_type, client_id, 0);
- if (!exists) return(SMS_PERM);
+ status = find_member(acl_type, acl_id, client_type, client_id, 0);
+ if (!status) return(MR_PERM);
- return(SMS_SUCCESS);
+ return(MR_SUCCESS);
##}
-/**
- ** access_maillist - access_list + disallow adding user-group to maillists
- **
- ** Inputs:
- ** argv[0] - list_id
- **
- **/
-access_maillist(q, argv, cl)
+/* access_visible_list - allow access to list only if it is not hidden,
+ * or if the client is on the ACL
+ *
+ * Inputs: argv[0] - list_id
+ * cl - client identifier
+ */
+
+access_visible_list(q, argv, cl)
struct query *q;
char *argv[];
client *cl;
##{
-## int list_id;
-## int exists;
-## char list_name[32];
- int status;
-
- status = access_list(q, argv, cl);
- if (status != SMS_SUCCESS) return(status);
- if (bcmp(q->name, "add_maillist", 12)) return(status);
+## int list_id, acl_id, flags, rowcount;
+## char acl_type[9];
+ char *client_type;
+ int client_id, status;
list_id = *(int *)argv[0];
-## range of g is groups
-## repeat retrieve (exists = any(g.#list_id where g.#list_id = @list_id))
- if (!exists) return(SMS_SUCCESS);
-## repeat retrieve (list_name = list.name) where list.#list_id = @list_id
-## repeat retrieve (exists = any(users.login where users.login = @list_name))
- return ((exists) ? SMS_USER_GROUP : SMS_SUCCESS);
+## repeat retrieve (flags = list.hidden, acl_id = list.#acl_id,
+## acl_type = list.#acl_type) where list.#list_id = @list_id
+## inquire_equel(rowcount = "rowcount")
+ if (rowcount != 1)
+ return(MR_INTERNAL);
+ if (!flags)
+ return(MR_SUCCESS);
+
+
+ /* parse client structure */
+ if ((status = get_client(cl, &client_type, &client_id)) != MR_SUCCESS)
+ return(status);
+
+ /* check for client in access control list */
+ status = find_member(acl_type, acl_id, client_type, client_id, 0);
+ if (!status)
+ return(MR_PERM);
+
+ return(MR_SUCCESS);
##}
-/**
- ** Setup routine for add_group
- **
- ** Inputs: none
- **
- ** Description: allocate next gid and store in values table
- **
- **/
-setup_add_group(q, argv, cl, access_check)
+/* access_vis_list_by_name - allow access to list only if it is not hidden,
+ * or if the client is on the ACL
+ *
+ * Inputs: argv[0] - list name
+ * cl - client identifier
+ */
+
+access_vis_list_by_name(q, argv, cl)
struct query *q;
char *argv[];
client *cl;
- int access_check;
##{
-## int ngid;
-## int exists;
-## int rowcount;
- int status;
+## int acl_id, flags, rowcount;
+## char acl_type[9], *listname;
+ char *client_type;
+ int client_id, status;
+
+ listname = argv[0];
+## repeat retrieve (flags = list.hidden, acl_id = list.#acl_id,
+## acl_type = list.#acl_type) where list.#name = @listname
+## inquire_equel(rowcount = "rowcount");
+ if (rowcount > 1)
+ return(MR_WILDCARD);
+ if (rowcount == 0)
+ return(MR_NO_MATCH);
+ if (!flags)
+ return(MR_SUCCESS);
+
+ /* parse client structure */
+ if ((status = get_client(cl, &client_type, &client_id)) != MR_SUCCESS)
+ return(status);
+
+ /* check for client in access control list */
+ status = find_member(acl_type, acl_id, client_type, client_id, 0);
+ if (!status)
+ return(MR_PERM);
+
+ return(MR_SUCCESS);
+##}
+
- status = access_list(q, argv, cl);
+/* access_member - allow user to access member of type "USER" and name matches
+ * username, or to access member of type "LIST" and list is one that user is
+ * on the acl of, or the list is visible.
+ */
- if (status != SMS_SUCCESS || access_check) return(status);
+access_member(q, argv, cl)
+ struct query *q;
+ char *argv[];
+ client *cl;
+{
+ if (!strcmp(argv[0], "LIST") || !strcmp(argv[0], "RLIST"))
+ return(access_visible_list(q, &argv[1], cl));
-## range of g is groups
-## range of v is values
-## repeat retrieve (ngid = v.value) where v.name = "gid"
- exists = 1;
- while (exists) {
- ngid++;
-## repeat retrieve (exists = any(g.#gid where g.#gid = @ngid))
+ if (!strcmp(argv[0], "USER") || !strcmp(argv[0], "RUSER")) {
+ if (cl->users_id == *(int *)argv[1])
+ return(MR_SUCCESS);
}
-## repeat replace v (value = @ngid) where v.name = "gid"
-## inquire_equel (rowcount = "rowcount")
- if (rowcount != 1) return SMS_INGRES_ERR;
- else return(SMS_SUCCESS);
+ return(MR_PERM);
+}
+
+
+/* access_qgli - special access routine for Qualified_get_lists. Allows
+ * access iff argv[0] == "TRUE" and argv[2] == "FALSE".
+ */
+
+access_qgli(q, argv, cl)
+ struct query *q;
+ char *argv[];
+ client *cl;
+{
+ if (!strcmp(argv[0], "TRUE") && !strcmp(argv[2], "FALSE"))
+ return(MR_SUCCESS);
+ return(MR_PERM);
+}
+
+
+/* access_service - allow access if user is on ACL of service. Don't
+ * allow access if a wildcard is used.
+ */
+
+access_service(q, argv, cl)
+ struct query *q;
+ char *argv[];
+ client *cl;
+##{
+## int acl_id, rowcount;
+## char *name, acl_type[9];
+ int client_id, status;
+ char *client_type;
+
+ name = argv[0];
+## repeat retrieve (acl_id = servers.#acl_id, acl_type = servers.#acl_type)
+## where servers.#name = uppercase(@name)
+## inquire_equel(rowcount = "rowcount")
+ if (rowcount > 1)
+ return(MR_PERM);
+
+ /* parse client structure */
+ if ((status = get_client(cl, &client_type, &client_id)) != MR_SUCCESS)
+ return(status);
+
+ /* check for client in access control list */
+ status = find_member(acl_type, acl_id, client_type, client_id, 0);
+ if (!status) return(MR_PERM);
+
+ return(MR_SUCCESS);
##}
-\f
-/**
- ** Setup routine for add_user
- **
- ** Inputs: argv[0] - login
- ** argv[1] - uid
- **
- ** Description:
- **
- ** - if argv[1] == "#" then set argv[1] = next(uid)
- ** - if argv[0] == "#" then set argv[0] = "#<uid>"
- **
- **/
-setup_add_user(q, argv, cl, access_check)
+
+
+/* access_filesys - verify that client is owner or on owners list of filesystem
+ * named by argv[0]
+ */
+
+access_filesys(q, argv, cl)
struct query *q;
- register char *argv[];
+ char *argv[];
client *cl;
- int access_check;
##{
-## int nuid;
-## int exists;
+## int rowcount, users_id, list_id;
+## char *name;
+ int status, client_id;
+ char *client_type;
- if (access_check) return(SMS_SUCCESS);
+ name = argv[0];
+## repeat retrieve (users_id = filesys.owner, list_id = filesys.owners)
+## where filesys.label = @name
+## inquire_equel(rowcount = "rowcount")
- if (!bcmp(argv[1], "#", 2)) {
-## range of u is users
-## range of v is values
-## repeat retrieve (nuid = v.value) where v.name = "uid"
- exists = 1;
- while (exists) {
- nuid++;
-## repeat retrieve (exists = any(u.#uid where u.#uid = @nuid))
- }
-## repeat replace v (value = @nuid) where v.name = "uid"
+ if (rowcount != 1)
+ return(MR_PERM);
+ if (users_id == cl->users_id)
+ return(MR_SUCCESS);
+ if ((status = get_client(cl, &client_type, &client_id)) != MR_SUCCESS)
+ return(status);
+ status = find_member("LIST", list_id, client_type, client_id, 0);
+ if (status)
+ return(MR_SUCCESS);
+ else
+ return(MR_PERM);
+##}
+
+
+\f
+/* Setup Routines */
+
+/* Setup routine for add_user
+ *
+ * Inputs: argv[0] - login
+ * argv[1] - uid
+ *
+ * Description:
+ *
+ * - if argv[1] == UNIQUE_UID then set argv[1] = next(uid)
+ * - if argv[0] == UNIQUE_LOGIN then set argv[0] = "#<uid>"
+ */
+
+setup_ausr(q, argv, cl)
+ struct query *q;
+ register char *argv[];
+ client *cl;
+##{
+## int nuid, rowcount;
+## char *mit_id;
+
+#ifdef notdef
+ /* this is currently disabled because we need an index on ID's
+ * before it can run in finite time.
+ */
+ mit_id = argv[U_MITID];
+## retrieve (rowcount = any(u.#mit_id where u.#mit_id = mit_id))
+ if (ingres_errno) return(mr_errcode);
+ if (rowcount) return(MR_EXISTS);
+#endif notdef
+
+ if (!strcmp(argv[1], UNIQUE_UID) || atoi(argv[1]) == -1) {
+ if (set_next_object_id("uid", "users"))
+ return(MR_INGRES_ERR);
+## repeat retrieve (nuid = values.value) where values.name = "uid"
+## inquire_equel(rowcount = "rowcount")
+ if (rowcount != 1)
+ return(MR_INTERNAL);
sprintf(argv[1], "%d", nuid);
}
- if (!bcmp(argv[0], "#", 2)) {
+ if (!strcmp(argv[0], UNIQUE_LOGIN) || atoi(argv[1]) == -1) {
sprintf(argv[0], "#%s", argv[1]);
}
- return(SMS_SUCCESS);
+ return(MR_SUCCESS);
##}
-/**
- ** followup_add_user - add finger entry, set_user_modtime
- ** followup_delete_user - delete finger entry
- **
- ** Inputs:
- ** argv[0] - login (add_user)
- ** argv[0] - users_id (delete_user)
- **
- **/
-followup_add_user(q, argv)
+/* setup_dusr - verify that the user is no longer being referenced
+ * and may safely be deleted.
+ */
+
+int setup_dusr(q, argv)
struct query *q;
- char *argv[];
+ char **argv;
##{
-## char *login;
-## int users_id;
-## char first[33];
-## char middle[33];
-## char last[33];
-## char fullname[128];
- register char *cp1;
- register char *cp2;
+## int flag, id;
+
+ id = *(int *)argv[0];
+
+ /* For now, only allow users to be deleted if their status is 0 */
+## repeat retrieve (flag = u.status) where u.users_id = @id
+ if (flag != 0 && flag != 4)
+ return(MR_IN_USE);
+
+## repeat delete quota where quota.entity_id = @id and quota.type = "USER"
+## repeat delete krbmap where krbmap.users_id = @id
+## repeat retrieve (flag = any(imembers.member_id where imembers.member_id=@id
+## and imembers.member_type = "USER"))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(filesys.label where filesys.owner=@id))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(list.name where list.acl_id=@id and
+## list.acl_type = "USER"))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(servers.name where servers.acl_id=@id and
+## servers.acl_type = "USER"))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag=any(hostaccess.acl_id where hostaccess.acl_id=@id and
+## hostaccess.acl_type = "USER"))
+ if (flag)
+ return(MR_IN_USE);
+ if (ingres_errno)
+ return(mr_errcode);
+ return(MR_SUCCESS);
+##}
- login = argv[0];
- /* get user information */
-## range of u is users
-## repeat retrieve (users_id = u.#users_id, last = u.#last,
-## first = u.#first, middle = u.#middle)
-## where u.#login = @login
+/* setup_spop: verify that there is already a valid POP machine_id in the
+ * pop_id field. Also take care of keeping track of the post office usage.
+ */
+int setup_spop(q, argv)
+struct query *q;
+char **argv;
+##{
+## int id, mid, flag;
+## char type[9];
+
+ id = *(int *)argv[0];
+## repeat retrieve (type = u.potype, mid = u.pop_id,
+## flag = any(machine.name where machine.mach_id = u.pop_id
+## and u.pop_id != 0 and u.users_id = @id))
+## where u.users_id = @id
+ if (!flag)
+ return(MR_MACHINE);
+ if (strcmp(strtrim(type), "POP"))
+ set_pop_usage(mid, 1);
+ return(MR_SUCCESS);
+##}
- /* build fullname */
- cp2 = fullname;
- cp1 = first;
- while (*cp1) *cp2++ = *cp1++;
- *cp2++ = ' ';
- cp1 = middle;
- if (*cp1 == 0) cp2--;
- while (*cp1) *cp2++ = *cp1++;
- *cp2++ = ' ';
- cp1 = last;
- while (*cp2++ = *cp1++) ;
-
- /* create a finger entry */
-## repeat append finger (#users_id = @users_id, #fullname = @fullname)
-
- /* set modtime (creation time) on user */
-## repeat replace u (modtime = "now") where u.#users_id = @users_id
-
- return(SMS_SUCCESS);
+
+/* setup_dpob: Take care of keeping track of the post office usage.
+ */
+int setup_dpob(q, argv)
+struct query *q;
+char **argv;
+##{
+## int id, user;
+## char type[9];
+
+ user = *(int *)argv[0];
+## repeat retrieve (type = u.potype, id = u.pop_id)
+## where u.users_id = @user
+ if (ingres_errno) return(mr_errcode);
+
+ if (!strcmp(strtrim(type), "POP"))
+ set_pop_usage(id, -1);
+ return(MR_SUCCESS);
##}
-followup_delete_user(q, argv)
+
+/* setup_dmac - verify that the machine is no longer being referenced
+ * and may safely be deleted.
+ */
+
+int setup_dmac(q, argv)
struct query *q;
- char *argv[];
+ char **argv;
##{
-## int users_id;
+## int flag, id;
+
+ id = *(int *)argv[0];
+## repeat retrieve (flag = any(users.login where users.potype = "POP"
+## and users.pop_id=@id))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(serverhosts.mach_id
+## where serverhosts.mach_id=@id))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(nfsphys.mach_id where nfsphys.mach_id=@id))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(hostaccess.mach_id where hostaccess.mach_id=@id))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(printcap.mach_id where printcap.mach_id=@id))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(printcap.quotaserver where printcap.quotaserver=@id))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(palladium.mach_id where palladium.mach_id=@id))
+ if (flag)
+ return(MR_IN_USE);
+
+## repeat delete mcmap where mcmap.mach_id = @id
+ if (ingres_errno) return(mr_errcode);
+ return(MR_SUCCESS);
+##}
- users_id = *(int *)argv[0];
-## repeat delete finger where finger.#users_id = @users_id
- return(SMS_SUCCESS);
+
+/* setup_dclu - verify that the cluster is no longer being referenced
+ * and may safely be deleted.
+ */
+
+int setup_dclu(q, argv)
+ struct query *q;
+ char **argv;
+##{
+## int flag, id;
+
+ id = *(int *)argv[0];
+## repeat retrieve (flag = any(mcmap.mach_id where mcmap.clu_id=@id))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(svc.clu_id where svc.clu_id=@id))
+ if (flag)
+ return(MR_IN_USE);
+ if (ingres_errno)
+ return(mr_errcode);
+ return(MR_SUCCESS);
##}
-\f
+
+
+/* setup_alis - if argv[5] is non-zero and argv[6] is UNIQUE_ID, then allocate
+ * a new gid and put it in argv[6]. Otherwise if argv[6] is UNIQUE_ID but
+ * argv[5] is not, then remember that UNIQUE_ID is being stored by putting
+ * a -1 there. Remember that this is also used for ulis, with the indexes
+ * at 6 & 7.
+ */
+
+int setup_alis(q, argv)
+struct query *q;
+char **argv;
+##{
+## int ngid;
+ char *malloc();
+ int idx;
+
+ if (!strcmp(q->shortname, "alis"))
+ idx = 6;
+ else if (!strcmp(q->shortname, "ulis"))
+ idx = 7;
+
+ if (!strcmp(argv[idx], UNIQUE_GID) || atoi(argv[idx]) == -1) {
+ if (atoi(argv[idx - 1])) {
+ if (set_next_object_id("gid", "list"))
+ return(MR_INGRES_ERR);
+## repeat retrieve (ngid = values.value) where values.name = "gid"
+ if (ingres_errno) return(mr_errcode);
+ sprintf(argv[idx], "%d", ngid);
+ } else {
+ strcpy(argv[idx], "-1");
+ }
+ }
+
+ return(MR_SUCCESS);
+##}
+
+
+/* setup_dlist - verify that the list is no longer being referenced
+ * and may safely be deleted.
+ */
+
+int setup_dlis(q, argv)
+ struct query *q;
+ char **argv;
+##{
+## int flag, id;
+
+ id = *(int *)argv[0];
+## repeat retrieve (flag = any(imembers.member_id where imembers.member_id=@id
+## and imembers.member_type = "LIST"))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(imembers.member_id where imembers.list_id=@id))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(filesys.label where filesys.owners=@id))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(capacls.tag where capacls.list_id=@id))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(list.name where list.acl_id=@id and
+## list.acl_type = "LIST" and list.list_id != @id))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(servers.name where servers.acl_id=@id and
+## servers.acl_type = "LIST"))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(quota.entity_id where quota.entity_id=@id and
+## quota.type = "GROUP"))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag=any(hostaccess.acl_id where hostaccess.acl_id=@id and
+## hostaccess.acl_type = "LIST"))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = any(zephyr.class
+## where zephyr.xmt_type = "LIST" and zephyr.xmt_id = @id or
+## zephyr.sub_type = "LIST" and zephyr.sub_id = @id or
+## zephyr.iws_type = "LIST" and zephyr.iws_id = @id or
+## zephyr.iui_type = "LIST" and zephyr.iui_id = @id))
+ if (flag)
+ return(MR_IN_USE);
+ if (ingres_errno)
+ return(mr_errcode);
+ return(MR_SUCCESS);
+##}
+
+
+/* setup_dsin - verify that the service is no longer being referenced
+ * and may safely be deleted.
+ */
+
+int setup_dsin(q, argv)
+ struct query *q;
+ char **argv;
+##{
+## int flag;
+## char *name;
+
+ name = argv[0];
+## repeat retrieve (flag = any(serverhosts.service
+## where serverhosts.service=uppercase(@name)))
+ if (flag)
+ return(MR_IN_USE);
+## repeat retrieve (flag = servers.inprogress) where servers.#name = @name
+ if (flag)
+ return(MR_IN_USE);
+ if (ingres_errno)
+ return(mr_errcode);
+ return(MR_SUCCESS);
+##}
+
+
+/* setup_dshi - verify that the service-host is no longer being referenced
+ * and may safely be deleted.
+ */
+
+int setup_dshi(q, argv)
+ struct query *q;
+ char **argv;
+##{
+## int flag, id;
+## char *name;
+
+ name = argv[0];
+ id = *(int *)argv[1];
+## repeat retrieve (flag=serverhosts.inprogress)
+## where serverhosts.service=uppercase(@name) and serverhosts.mach_id=@id
+ if (flag)
+ return(MR_IN_USE);
+ if (ingres_errno)
+ return(mr_errcode);
+ return(MR_SUCCESS);
+##}
+
+
/**
** setup_add_filesys - verify existance of referenced file systems
- ** setup_update_filesys - same, except argv[1..5] --> argv[2..6]
**
- ** Inputs: Add Update
- ** argv[0] - label label
- ** argv[1] - type new label
- ** argv[2] - mach_id type
- ** argv[3] - name mach_id
- ** argv[4] - mount name
- ** argv[5] - access mount
- ** argv[6] - access
+ ** Inputs: Add
+ ** argv[1] - type
+ ** argv[2] - mach_id
+ ** argv[3] - name
+ ** argv[5] - access
**
** Description:
** - for type = RVD:
- ** * verify mach_id/name in rvdvirt
- ** * verify access in {r, x, R, X}
+ ** * allow anything
** - for type = NFS:
** * extract directory prefix from name
** * verify mach_id/dir in nfsphys
** * verify access in {r, w, R, W}
**
+ ** Side effect: sets variable var_phys_id to the ID of the physical
+ ** filesystem (nfsphys_id for NFS, 0 for RVD)
+ **
** Errors:
- ** SMS_RVD - no such rvd
- ** SMS_NFS - specified directory not exported
- ** SMS_FILESYS_ACCESS - invalid filesys access
+ ** MR_NFS - specified directory not exported
+ ** MR_FILESYS_ACCESS - invalid filesys access
**
**/
-setup_add_filesys(q, argv)
+##static int var_phys_id;
+
+setup_afil(q, argv)
struct query *q;
char *argv[];
-{
- char *type;
+##{
+ char *type, *name;
int mach_id;
- char *name;
- char *access;
+## int ok;
+## char ftype[32], *access;
type = argv[1];
mach_id = *(int *)argv[2];
name = argv[3];
access = argv[5];
+ var_phys_id = 0;
- if (!bcmp(type, "RVD", 3))
- return (check_rvd(mach_id, name, access));
- else if (!bcmp(type, "NFS", 3))
+ sprintf(ftype, "fs_access_%s", type);
+## retrieve (ok = any(alias.trans where alias.name = ftype and
+## alias.type = "TYPE" and alias.trans = access))
+ if (ingres_errno) return(mr_errcode);
+ if (ok == 0) return(MR_FILESYS_ACCESS);
+
+ if (!strcmp(type, "NFS"))
return (check_nfs(mach_id, name, access));
else
- return(SMS_SUCCESS);
-}
+ return(MR_SUCCESS);
+##}
+
+
+/* Verify the arguments, depending on the FStype. Also, if this is an
+ * NFS filesystem, then update any quotas for that filesystem to reflect
+ * the new phys_id.
+ */
-setup_update_filesys(q, argv)
+setup_ufil(q, argv, cl)
struct query *q;
char *argv[];
-{
- char *type;
- int mach_id;
- char *name;
- char *access;
+ client *cl;
+##{
+ int mach_id, status;
+ char *type, *name;
+## int fid, total, who;
+## char *entity, ftype[32], *access;
type = argv[2];
mach_id = *(int *)argv[3];
name = argv[4];
access = argv[6];
+ var_phys_id = 0;
+ fid = *(int *)argv[0];
+ who = cl->client_id;
+ entity = cl->entity;
+
+ sprintf(ftype, "fs_access_%s", type);
+## retrieve (total = any(alias.trans where alias.name = ftype and
+## alias.type = "TYPE" and alias.trans = access))
+ if (ingres_errno) return(mr_errcode);
+ if (total == 0) return(MR_FILESYS_ACCESS);
+
+ if (!strcmp(type, "NFS")) {
+ status = check_nfs(mach_id, name, access);
+## replace quota (phys_id = var_phys_id) where quota.filsys_id = fid
+ if (ingres_errno) return(mr_errcode);
+ return(status);
+ } else if (!strcmp(type, "AFS")) {
+ total = 0;
+## retrieve (total = sum(quota.quota where quota.filsys_id = fid
+## and quota.phys_id != 0))
+ if (ingres_errno) return(mr_errcode);
+ if (total != 0) {
+## append quota (quota = total, filsys_id = fid,
+## phys_id = 0, entity_id = 0, type = "ANY",
+## modtime = "now", modby = who, modwith = entity)
+ if (ingres_errno) return(mr_errcode);
+ }
+ } else {
+## replace quota (phys_id = 0) where quota.filsys_id = fid
+ if (ingres_errno) return(mr_errcode);
+ }
+ return(MR_SUCCESS);
+##}
- if (!bcmp(type, "RVD", 3))
- return (check_rvd(mach_id, name, access));
- else if (!bcmp(type, "NFS", 3))
- return (check_nfs(mach_id, name, access));
- else
- return(SMS_SUCCESS);
-}
-
-##check_rvd(mach_id, name, access)
-## int mach_id;
-## char *name;
- char *access;
-##{
-## int rowcount;
- char caccess;
-
-## range of rv is rvdvirt
-## retrieve (rowcount = any(rv.#name where rv.#mach_id = mach_id and
-## rv.#name = name))
- if (rowcount == 0) return(SMS_RVD);
-
- caccess = (isupper(*access)) ? tolower(*access) : *access;
- if (caccess != 'r' && caccess != 'x') return(SMS_FILESYS_ACCESS);
- return(SMS_SUCCESS);
-##}
+/* Find the NFS physical partition that the named directory is on.
+ * This is done by comparing the dir against the mount point of the
+ * partition. To make sure we get the correct match when there is
+ * more than one, we sort the query in reverse order by dir name.
+ */
##check_nfs(mach_id, name, access)
## int mach_id;
char *name;
char *access;
##{
-## int rowcount;
-## char dir[32];
+## char dir[81];
char caccess;
register int status;
register char *cp1;
register char *cp2;
- caccess = (isupper(*access)) ? tolower(*access) : *access;
- if (caccess != 'r' && caccess != 'w') return(SMS_FILESYS_ACCESS);
-
- status = SMS_NFS;
+ status = MR_NFS;
## range of np is nfsphys
-## retrieve (dir = np.#dir) where np.#mach_id = mach_id
-## {
+## repeat retrieve (var_phys_id = np.#nfsphys_id, dir = trim(np.#dir))
+## where np.#mach_id = @mach_id sort by #dir:d {
cp1 = name;
cp2 = dir;
while (*cp2) {
cp2++;
}
if (*cp2 == 0) {
- status = SMS_SUCCESS;
+ status = MR_SUCCESS;
## endretrieve
}
## }
-
+ if (ingres_errno)
+ return(mr_errcode);
return(status);
##}
-\f
-/* Followup Routines */
-set_user_modtime(q, argv)
- struct query *q;
- char *argv[];
-##{
-## char *login;
- login = argv[0];
-## repeat replace u (modtime = "now") where u.#login = @login
- return(SMS_SUCCESS);
-##}
+/* setup_dfil: free any quota records and fsgroup info associated with
+ * a filesystem when it is deleted. Also adjust the allocation numbers.
+ */
-set_user_modtime_by_id(q, argv)
- struct query *q;
- char *argv[];
+setup_dfil(q, argv, cl)
+ struct query *q;
+ char **argv;
+ client *cl;
##{
-## int users_id;
+## int id;
- users_id = *(int *)argv[0];
-## repeat replace users (modtime = "now") where users.#users_id = @users_id
- return(SMS_SUCCESS);
+ id = *(int *)argv[0];
+## range of q is quota
+## range of n is nfsphys
+## repeat replace n (allocated=n.allocated-sum(q.quota where q.filsys_id=@id))
+## where n.nfsphys_id = filesys.phys_id and filesys.filsys_id = @id
+
+## repeat delete q where q.filsys_id = @id
+## repeat delete fsgroup where fsgroup.filsys_id = @id
+## repeat delete fsgroup where fsgroup.group_id = @id
+ if (ingres_errno) return(mr_errcode);
+ return(MR_SUCCESS);
##}
-set_list_modtime(q, argv)
- struct query *q;
- char *argv[];
-##{
-## char *list_name;
- list_name = argv[0];
-## repeat replace list (modtime = "now") where list.name = @list_name
- return(SMS_SUCCESS);
-##}
+/* setup_dnfp: check to see that the nfs physical partition does not have
+ * any filesystems assigned to it before allowing it to be deleted.
+ */
-set_list_modtime_by_id(q, argv)
- struct query *q;
- char *argv[];
+setup_dnfp(q, argv, cl)
+ struct query *q;
+ char **argv;
+ client *cl;
##{
-## int list_id;
-
- list_id = *(int *)argv[0];
-## repeat replace list (modtime = "now") where list.#list_id = @list_id
-## repeat replace list (modtime = "now") where list.#acl_id = @list_id
- return(SMS_SUCCESS);
+## int id, exists;
+
+ id = *(int *)argv[0];
+## repeat retrieve (exists = any(filesys.label where filesys.phys_id = @id))
+ if (exists)
+ return(MR_IN_USE);
+ if (ingres_errno)
+ return(mr_errcode);
+ return(MR_SUCCESS);
##}
-set_finger_modtime(q, argv)
- struct query *q;
- char *argv[];
+
+/* setup_dqot: Remove allocation from nfsphys before deleting quota.
+ * argv[0] = filsys_id
+ * argv[1] = type if "update_quota" or "delete_quota"
+ * argv[2 or 1] = users_id or list_id
+ */
+
+setup_dqot(q, argv, cl)
+ struct query *q;
+ char **argv;
+ client *cl;
##{
-## int users_id;
+## int quota, fs, id;
+## char *qtype;
- users_id = *(int *)argv[0];
-## repeat replace f (modtime = "now") where f.#users_id = @users_id
- return(SMS_SUCCESS);
+ fs = *(int *)argv[0];
+ if (!strcmp(q->name, "update_quota") || !strcmp(q->name, "delete_quota")) {
+ qtype = argv[1];
+ id = *(int *)argv[2];
+ } else {
+ qtype = "USER";
+ id = *(int *)argv[1];
+ }
+
+## range of q is #quota
+## repeat retrieve (quota = q.#quota) where q.type = @qtype and
+## q.entity_id = @id and q.filsys_id = @fs
+## repeat replace nfsphys (allocated = nfsphys.allocated - @quota)
+## where nfsphys.nfsphys_id = filesys.#phys_id and filesys.filsys_id = @fs
+ if (ingres_errno) return(mr_errcode);
+ return(MR_SUCCESS);
##}
-\f
-/**
- ** followup_amtl - followup for amtl and dmfl; when adding a list
- ** member to a maillist, add list to maillist table,
- ** unless list is a user-group.
- ** Then set_list_modtime_by_id.
- **
- ** Inputs:
- ** argv[0] - list_id
- ** argv[1] - member_type
- ** argv[2] - member_id
- **
- **/
-followup_amtl(q, argv)
- struct query *q;
- char *argv[];
+
+/* setup_sshi: don't exclusive lock the machine table during
+ * set_server_host_internal.
+ */
+
+setup_sshi(q, argv, cl)
+ struct query *q;
+ char **argv;
+ client *cl;
##{
-## int list_id;
-## int member_id;
-## int exists;
-## char list_name[33];
+## set lockmode session where readlock = system
+##}
- list_id = *(int *)argv[0];
-## repeat replace list (modtime = "now") where list.#list_id = @list_id
-## repeat replace list (modtime = "now") where list.#acl_id = @list_id
+/* setup add_kerberos_user_mapping: add the string to the string
+ * table if necessary.
+ */
- /* if query is not amtl or if member_type is not LIST then return */
- if (bcmp(q->shortname, "amtl", 4) || bcmp(argv[1], "LIST", 4))
- return(SMS_SUCCESS);
+setup_akum(q, argv, cl)
+struct query *q;
+char **argv;
+client *cl;
+##{
+## int id, rowcount;
+## char *name;
- member_id = *(int *)argv[2];
-## range of l is list
-## range of ml is maillists
-## range of g is groups
-
- /* is parent list a mailing list? */
-## repeat retrieve (exists = any(ml.#list_id where ml.#list_id=@list_id))
-
- /* if not then return */
- if (!exists) return(SMS_SUCCESS);
-
- /* is member_list a user-group? */
- /* is it a group? */
-## repeat retrieve (exists = any(g.#list_id where g.#list_id = @member_id))
- if (exists) {
- /* get list_name */
-## repeat retrieve (list_name = l.#name) where l.#list_id = @member_id
- /* is list_name a username? */
-## repeat retrieve (exists = any(users.login
-## where users.login = @list_name))
- /* yes, return error */
- if (exists) return(SMS_USER_GROUP);
+ name = argv[1];
+ if (name_to_id(name, "STRING", &id) != MR_SUCCESS) {
+ if (q->type != APPEND) return(MR_STRING);
+## range of v is values
+## retrieve (id = v.value) where v.#name = "strings_id"
+ id++;
+## replace v (value = id) where v.#name = "strings_id"
+## append to strings (string_id = id, string = name)
+ cache_entry(name, "STRING", id);
}
+ if (ingres_errno) return(mr_errcode);
+ *(int *)argv[1] = id;
+ return(MR_SUCCESS);
+##}
- /* list is not a user-group; add list to maillist table */
-## repeat append maillists (#list_id = @member_id, ltid = l.tid)
-## where l.#list_id = @member_id
- return(SMS_SUCCESS);
-##}
\f
-/**
- ** followup_add_pobox
- ** followup_delete_pobox - followup routines for pobox queries
- **
- ** Description:
- ** add_pobox: set pobox creation time
- ** increment pop usage in serverhosts
- **
- ** delete_pobox: decrement pop usage in serverhosts
- **
- **/
-
-followup_add_pobox(q, argv)
- struct query *q;
- char *argv[];
-{
- set_pobox_creation(q, argv);
- set_pop_usage(q, argv, 1);
- return(SMS_SUCCESS);
-}
+/* FOLLOWUP ROUTINES */
-followup_delete_pobox(q, argv)
- struct query *q;
- char *argv[];
-{
- set_pop_usage(q, argv, -1);
- return(SMS_SUCCESS);
-}
+/* generic set_modtime routine. This takes the table name from the query,
+ * and will update the modtime, modby, and modwho fields in the entry in
+ * the table whose name field matches argv[0].
+ */
-set_pobox_creation(q, argv)
+set_modtime(q, argv, cl)
struct query *q;
char *argv[];
+ client *cl;
##{
-## int users_id;
-## int mach_id;
-## char *type;
-## char *box;
+## char *name, *entity, *table;
+## int who;
- users_id = *(int *)argv[0];
- type = argv[1];
- mach_id = *(int *)argv[2];
- box = argv[3];
-
-## range of p is pobox
-## repeat replace p (created = "now")
-## where p.#users_id = @users_id and p.#type = @type and
-## p.#mach_id = @mach_id and p.#box = @box
+ entity = cl->entity;
+ who = cl->client_id;
+ table = q->rtable;
+ name = argv[0];
- return (SMS_SUCCESS);
+## replace table (modtime = "now", modby = who, modwith = entity)
+## where table.#name = name
+ return(MR_SUCCESS);
##}
-/**
- ** set_pop_usage - incr/decr usage count for pop server in serverhosts talbe
- **
- ** Inputs:
- ** q->name - "add_pobox" or "delete_pobox"
- ** argv[1] - type
- ** argv[2] - mach_id
- **
- ** Description:
- ** - incr/decr value field in serverhosts table for pop/mach_id
- **
- **/
+/* generic set_modtime_by_id routine. This takes the table name from
+ * the query, and the id name from the validate record,
+ * and will update the modtime, modby, and modwho fields in the entry in
+ * the table whose id matches argv[0].
+ */
-set_pop_usage(q, argv, count)
+set_modtime_by_id(q, argv, cl)
struct query *q;
- char *argv[];
+ char **argv;
+ client *cl;
##{
-## int mach_id;
-## int n;
+## char *entity, *table, *id_name;
+## int who, id;
- if (bcmp(argv[1], "POP", 3)) return(SMS_SUCCESS);
-
- mach_id = *(int *)argv[2];
- n = count;
-
-## range of sh is serverhosts
-## repeat replace sh (value1 = sh.value1 + @n)
-## where sh.service = "pop" and sh.#mach_id = @mach_id
+ entity = cl->entity;
+ who = cl->client_id;
+ table = q->rtable;
+ id_name = q->validate->object_id;
- return(SMS_SUCCESS);
+ id = *(int *)argv[0];
+## replace table (modtime = "now", modby = who, modwith = entity)
+## where table.id_name = id
+ return(MR_SUCCESS);
##}
-/**
- ** delete_user_poboxes - delete all poboxes for a user
- **
- ** Inputs:
- ** argv[0] - users_id
- **
- **/
-delete_user_poboxes(q, argv)
+/* Sets the finger modtime on a user record. The users_id will be in argv[0].
+ */
+
+set_finger_modtime(q, argv, cl)
struct query *q;
char *argv[];
+ client *cl;
##{
-## int users_id;
-## int n;
-## int mach_id;
- register int i;
- int mach_ids[10];
+## int users_id, who;
+## char *entity;
+ entity = cl->entity;
+ who = cl->client_id;
users_id = *(int *)argv[0];
- /* get machine ids for pop server(s) on which the user currently exists */
-## range of p is pobox
- i = 0;
-## repeat retrieve (mach_id = p.#mach_id)
-## where p.#users_id = @users_id and p.type = "POP"
-## {
- mach_ids[i++] = mach_id;
- if (i == 10) {
-## endretrieve
- }
-## }
+## repeat replace u (fmodtime = "now", fmodby = @who, fmodwith = @entity)
+## where u.#users_id = @users_id
+ return(MR_SUCCESS);
+##}
- /* decrement counts on serverhost entries */
-## range of sh is serverhosts
- while (--i >= 0) {
- mach_id = mach_ids[i];
-## repeat replace sh (value1 = sh.value1 - 1)
-## where sh.service = "pop" and sh.#mach_id = @mach_id
- }
- /* delete user's poboxes */
-## repeat delete p where p.#users_id = @users_id
+/* Sets the pobox modtime on a user record. The users_id will be in argv[0].
+ */
+
+set_pobox_modtime(q, argv, cl)
+ struct query *q;
+ char **argv;
+ client *cl;
+##{
+## int users_id, who;
+## char *entity;
+
+ entity = cl->entity;
+ who = cl->client_id;
+ users_id = *(int *)argv[0];
- return(SMS_SUCCESS);
+## repeat replace users (pmodtime = "now", pmodby = @who, pmodwith = @entity)
+## where users.#users_id = @users_id
+ return(MR_SUCCESS);
##}
-\f
-/**
- ** add_new_quota
- ** delete_current_quota - adjust nfsphys values on xxx_quota queries.
- **
- ** Inputs:
- ** argv[0] - mach_id
- ** argv[1] - device
- ** argv[2] - users_id
- ** argv[3] - quota (add_new_quota only)
- **
- ** Description:
- ** delete_current_quota:
- ** - find nfsquota entry
- ** - decrement nfsphys.allocated by nfsquota.quota
- ** add_new_quota
- ** - increment nfsphys.allocated by quota
- **
- **/
-add_new_quota(q, argv)
+/* Like set_modtime, but uppercases the name first.
+ */
+
+set_uppercase_modtime(q, argv, cl)
struct query *q;
- register char *argv[];
+ char **argv;
+ client *cl;
##{
-## int mach_id;
-## char *device;
-## int quota;
-
- mach_id = *(int*)argv[0];
- device = argv[1];
- quota = *(int *)argv[3];
+## char *name, *entity, *table;
+## int who;
-## range of np is nfsphys
-## repeat replace np (allocated = np.allocated + @quota)
-## where np.#mach_id = @mach_id and np.#device = @device
+ entity = cl->entity;
+ who = cl->client_id;
+ table = q->rtable;
+ name = argv[0];
- return(SMS_SUCCESS);
+## replace table (modtime = "now", modby = who, modwith = entity)
+## where table.#name = uppercase(name)
+ return(MR_SUCCESS);
##}
-delete_current_quota(q, argv, cl, access_check)
+
+/* Sets the modtime on the machine whose mach_id is in argv[0]. This routine
+ * is necessary for add_machine_to_cluster becuase the table that query
+ * operates on is "mcm", not "machine".
+ */
+
+set_mach_modtime_by_id(q, argv, cl)
struct query *q;
- register char *argv[];
+ char **argv;
client *cl;
- int access_check;
##{
-## int mach_id;
-## int users_id;
-## char *device;
-## int quota;
+## char *entity;
+## int who, id;
- if (access_check) return(SMS_SUCCESS);
+ entity = cl->entity;
+ who = cl->client_id;
- mach_id = *(int *)argv[0];
- device = argv[1];
- users_id = *(int *)argv[2];
-
-## range of np is nfsphys
-## range of nq is nfsquota
-## repeat retrieve (quota = nq.#quota)
-## where nq.#mach_id = @mach_id and nq.#device = @device and
-## nq.#users_id = @users_id
-## repeat replace np (allocated = np.allocated - @quota)
-## where np.#mach_id = @mach_id and np.#device = @device
-
- return(SMS_SUCCESS);
+ id = *(int *)argv[0];
+## repeat replace machine (modtime = "now", modby = @who, modwith = @entity)
+## where machine.mach_id = @id
+ return(MR_SUCCESS);
##}
-\f
-/**
- ** add_hostaccess - create entry in hostaccess table upon adding a new
- ** machine to the serverhosts table where service =
- ** "hostaccess".
- **
- ** Inputs:
- ** argv[0] - service
- ** argv[1] - mach_id
- **
- **/
-add_hostaccess(q, argv)
+
+/* Sets the modtime on the cluster whose mach_id is in argv[0]. This routine
+ * is necessary for add_cluster_data and delete_cluster_data becuase the
+ * table that query operates on is "svc", not "cluster".
+ */
+
+set_cluster_modtime_by_id(q, argv, cl)
struct query *q;
- char *argv[];
+ char **argv;
+ client *cl;
##{
-## int mach_id;
+## char *entity;
+## int who, id;
- /* only work with service = "hostaccess" */
- if (bcmp(argv[0], "hostaccess", 10)) return(SMS_SUCCESS);
+ entity = cl->entity;
+ who = cl->client_id;
- mach_id = *(int *)argv[1];
-## repeat append hostaccess (#mach_id = @mach_id, status = 0)
-## repeat replace tblstats (modtime = "now", appends = tblstats.appends + 1)
-## where tblstats.table = "hostaccess"
- return(SMS_SUCCESS);
+ id = *(int *)argv[0];
+## repeat replace cluster (modtime = "now", modby = @who, modwith = @entity)
+## where cluster.clu_id = @id
+ return(MR_SUCCESS);
##}
-/* followup to delete_server_host_info */
-delete_hostaccess(q, argv)
+/* sets the modtime on the serverhost where the service name is in argv[0]
+ * and the mach_id is in argv[1].
+ */
+
+set_serverhost_modtime(q, argv, cl)
struct query *q;
- char *argv[];
+ char **argv;
+ client *cl;
##{
-## int mach_id;
+## char *entity, *serv;
+## int who, id;
- /* only work with service = "hostaccess" */
- if (bcmp(argv[0], "hostaccess", 10)) return(SMS_SUCCESS);
+ entity = cl->entity;
+ who = cl->client_id;
- mach_id = *(int *)argv[1];
-## repeat delete hostaccess where hostaccess.#mach_id = @mach_id
-## repeat replace tblstats (modtime = "now", deletes = tblstats.deletes + 1)
-## where tblstats.table = "hostaccess"
- return(SMS_SUCCESS);
+ serv = argv[0];
+ id = *(int *)argv[1];
+## repeat replace sh (modtime = "now", modby = @who, modwith = @entity)
+## where sh.service = uppercase(@serv) and sh.mach_id = @id
+ return(MR_SUCCESS);
##}
-followup_ushp(q, argv)
+
+/* sets the modtime on the nfsphys where the mach_id is in argv[0] and the
+ * directory name is in argv[1].
+ */
+
+set_nfsphys_modtime(q, argv, cl)
struct query *q;
- char *argv[];
+ char **argv;
+ client *cl;
##{
-## int mach_id;
-## int status;
-
- mach_id = *(int *)argv[0];
-## range of ha is hostaccess
-## repeat retrieve (status = ha.#status) where ha.#mach_id = @mach_id
- status |= 1;
-## repeat replace ha (#status = @status) where ha.#mach_id = @mach_id
- return(SMS_SUCCESS);
+## char *entity, *dir;
+## int who, id;
+
+ entity = cl->entity;
+ who = cl->client_id;
+
+ id = *(int *)argv[0];
+ dir = argv[1];
+## repeat replace np (modtime = "now", modby = @who, modwith = @entity)
+## where np.#dir = @dir and np.mach_id = @id
+ return(MR_SUCCESS);
##}
-followup_usha(q, argv)
+
+/* sets the modtime on a filesystem, where argv[0] contains the filesys
+ * label.
+ */
+
+set_filesys_modtime(q, argv, cl)
struct query *q;
char *argv[];
+ client *cl;
##{
-## int mach_id;
-## int status;
-
- mach_id = *(int *)argv[0];
-## range of ha is hostaccess
-## repeat retrieve (status = ha.#status) where ha.#mach_id = @mach_id
- status |= 2;
-## repeat replace ha (#status = @status) where ha.#mach_id = @mach_id
- return(SMS_SUCCESS);
+## char *label, *entity;
+## int who;
+
+ entity = cl->entity;
+ who = cl->client_id;
+
+ label = argv[0];
+ if (!strcmp(q->shortname, "ufil"))
+ label = argv[1];
+
+## repeat replace fs (modtime = "now", modby = @who, modwith = @entity,
+## #phys_id = @var_phys_id) where fs.#label = @label
+ return(MR_SUCCESS);
##}
-\f
-/**
- ** followup_delete_list - called after the delete_list query to clean up
- ** members table; also deletes list from maillist
- ** and groups tables.
- **
- ** Inputs: argv[0] - list_id
- **
- ** Description:
- ** - foreach string member: decr string refc; ifzero, delete string
- ** - delete all members entries for this list_id
- **
- **/
-followup_delete_list(q, argv)
+
+/* sets the modtime on a zephyr class, where argv[0] contains the class
+ * name.
+ */
+
+set_zephyr_modtime(q, argv, cl)
struct query *q;
- register char *argv[];
+ char *argv[];
+ client *cl;
##{
-## int list_id;
-## int string_id;
-## int refc;
-## int rowcount;
- struct save_queue *sq;
- struct save_queue *sq_create();
+## char *class, *entity;
+## int who;
- list_id = *(int *)argv[0];
- sq = sq_create();
+ entity = cl->entity;
+ who = cl->client_id;
-## range of m is members
-## repeat retrieve (string_id = m.member_id)
-## where m.#list_id = @list_id and m.member_type = "STRING"
-## {
- sq_save_data(sq, string_id);
-## }
+ class = argv[0];
- while (sq_get_data(sq, &string_id)) {
-## range of s is strings
-## repeat retrieve (refc = s.#refc) where s.#string_id = @string_id
-## inquire_equel (rowcount = "rowcount")
- if (rowcount == 0) continue;
- if (--refc == 0) {
-## repeat delete s where s.#string_id = @string_id
- } else {
-## repeat replace s (#refc = @refc) where s.#string_id = @string_id
- }
+## repeat replace z (modtime = "now", modby = @who, modwith = @entity)
+## where z.#class = @class
+ return(MR_SUCCESS);
+##}
+
+
+/* fixes the modby field. This will be the second to last thing in the
+ * argv, the argv length is determined from the query structure. It is
+ * passed as a pointer to an integer. This will either turn it into a
+ * username, or # + the users_id.
+ */
+followup_fix_modby(q, sq, v, action, actarg, cl)
+ struct query *q;
+ register struct save_queue *sq;
+ struct validate *v;
+ register int (*action)();
+ register int actarg;
+ client *cl;
+{
+ register int i, j;
+ char **argv, *malloc();
+ int id, status;
+
+ i = q->vcnt - 2;
+ while (sq_get_data(sq, &argv)) {
+ id = atoi(argv[i]);
+ if (id > 0)
+ status = id_to_name(id, "USER", &argv[i]);
+ else
+ status = id_to_name(-id, "STRING", &argv[i]);
+ if (status && status != MR_NO_MATCH)
+ return(status);
+ (*action)(q->vcnt, argv, actarg);
+ for (j = 0; j < q->vcnt; j++)
+ free(argv[j]);
+ free(argv);
}
sq_destroy(sq);
+ return(MR_SUCCESS);
+}
-## repeat delete m where m.#list_id = @list_id
-## repeat delete maillists where maillists.#list_id = @list_id
-## repeat delete groups where groups.#list_id = @list_id
- return(SMS_SUCCESS);
-##}
-\f
/**
- ** followup_grvd - Support routine for get_rvd_servers query
+ ** followup_ausr - add finger and pobox entries, set_user_modtime
**
** Inputs:
- ** q - grvd query structure
- ** sq - save_queue struture: contains list of {machine, oper_acl_id,
- ** admin_acl_id, shutdown_acl_id} records.
- ** v - validate structure (not used)
- ** action - action routine
- ** actarg - action routine argument
- **
- ** Description:
- ** - translate acl_ids to list names
+ ** argv[0] - login (add_user)
+ ** argv[3] - last name
+ ** argv[4] - first name
+ ** argv[5] - middle name
**
**/
-followup_grvd(q, sq, v, action, actarg)
+followup_ausr(q, argv, cl)
struct query *q;
- struct save_queue *sq;
- struct validate *v;
- int (*action)();
- int actarg;
+ char *argv[];
+ client *cl;
##{
- char **argv;
- char *targv[4];
-## char oper[33];
-## char admin[33];
-## char shutdown[33];
-## int list_id;
+## int who;
+## char *login, *entity;
+## char fullname[129];
- targv[0] = oper;
- targv[1] = admin;
- targv[2] = shutdown;
+ login = argv[0];
+ who = cl->client_id;
+ entity = cl->entity;
-## range of l is list
+ /* build fullname */
+ if (strlen(argv[4]) && strlen(argv[5]))
+ sprintf(fullname, "%s %s %s", argv[4], argv[5], argv[3]);
+ else if (strlen(argv[4]))
+ sprintf(fullname, "%s %s", argv[4], argv[3]);
+ else
+ sprintf(fullname, "%s", argv[3]);
+
+ /* create finger entry, pobox & set modtime on user */
+## repeat replace u (modtime = "now", modby=@who, modwith=@entity,
+## #fullname=@fullname, mit_affil = u.mit_year,
+## fmodtime="now", fmodby=@who, fmodwith=@entity,
+## potype="NONE", pmodtime="now", pmodby=@who, pmodwith=@entity)
+## where u.#login = @login
+
+ return(MR_SUCCESS);
+##}
+
+
+/* followup_gpob: fixes argv[2] based on the IDs currently there and the
+ * type in argv[1]. Then completes the upcall to the user.
+ *
+ * argv[2] is of the form "123:234" where the first integer is the machine
+ * ID if it is a pop box, and the second is the string ID if it is an SMTP
+ * box. argv[1] should be "POP", "SMTP", or "NONE". Boxes of type NONE
+ * are skipped.
+ */
+
+followup_gpob(q, sq, v, action, actarg, cl)
+ register struct query *q;
+ register struct save_queue *sq;
+ register struct validate *v;
+ register int (*action)();
+ int actarg;
+ client *cl;
+{
+ char **argv, *index();
+ char *ptype, *p;
+ int mid, sid, status;
+ /* for each row */
while (sq_get_data(sq, &argv)) {
- sscanf(argv[0], "%d", &list_id);
-## repeat retrieve (oper = l.name) where l.#list_id = @list_id
- sscanf(argv[1], "%d", &list_id);
-## repeat retrieve (admin = l.name) where l.#list_id = @list_id
- sscanf(argv[2], "%d", &list_id);
-## repeat retrieve (shutdown = l.name) where l.#list_id = @list_id
-
- (*action)(3, targv, actarg);
+ mr_trim_args(2, argv);
+ ptype = argv[1];
+ p = index(argv[2], ':');
+ *p++ = 0;
+ mid = atoi(argv[2]);
+ sid = atoi(p);
+
+ if (!strcmp(ptype, "POP")) {
+ status = id_to_name(mid, "MACHINE", &argv[2]);
+ if (status == MR_NO_MATCH)
+ return(MR_MACHINE);
+ } else if (!strcmp(ptype, "SMTP")) {
+ status = id_to_name(sid, "STRING", &argv[2]);
+ if (status == MR_NO_MATCH)
+ return(MR_STRING);
+ } else /* ptype == "NONE" */ {
+ goto skip;
+ }
+ if (status) return(status);
+
+ if (!strcmp(q->shortname, "gpob")) {
+ sid = atoi(argv[4]);
+ if (sid > 0)
+ status = id_to_name(sid, "USER", &argv[4]);
+ else
+ status = id_to_name(-sid, "STRING", &argv[4]);
+ }
+ if (status && status != MR_NO_MATCH) return(status);
+
+ (*action)(q->vcnt, argv, actarg);
+ skip:
+ /* free saved data */
free(argv[0]);
free(argv[1]);
- free(argv[2]);
+ free(argv[4]);
+ free(argv);
}
sq_destroy(sq);
- return(SMS_SUCCESS);
-##}
+ return (MR_SUCCESS);
+}
+
+
+/* followup_glin: fix the ace_name in argv[8]. argv[7] will contain the
+ * ace_type: "LIST", "USER", or "NONE". Decode the id in argv[8] into the
+ * proper name based on the type, and repace that string in the argv.
+ * Also fixes the modby field by called followup_fix_modby.
+ */
+
+followup_glin(q, sq, v, action, actarg, cl)
+ register struct query *q;
+ register struct save_queue *sq;
+ register struct validate *v;
+ register int (*action)();
+ int actarg;
+ client *cl;
+{
+ char **argv, *malloc(), *realloc(), *type;
+ int id, i, idx, status;
+
+ idx = 8;
+ if (!strcmp(q->shortname, "gsin"))
+ idx = 12;
+
+ while (sq_get_data(sq, &argv)) {
+ mr_trim_args(q->vcnt, argv);
+
+ id = atoi(argv[i = q->vcnt - 2]);
+ if (id > 0)
+ status = id_to_name(id, "USER", &argv[i]);
+ else
+ status = id_to_name(-id, "STRING", &argv[i]);
+ if (status && status != MR_NO_MATCH)
+ return(status);
+
+ id = atoi(argv[idx]);
+ type = argv[idx - 1];
+
+ if (!strcmp(type, "LIST")) {
+ status = id_to_name(id, "LIST", &argv[idx]);
+ } else if (!strcmp(type, "USER")) {
+ status = id_to_name(id, "USER", &argv[idx]);
+ } else if (!strcmp(type, "KERBEROS")) {
+ status = id_to_name(id, "STRING", &argv[idx]);
+ } else if (!strcmp(type, "NONE")) {
+ status = 0;
+ free(argv[idx]);
+ argv[idx] = strsave("NONE");
+ } else {
+ status = 0;
+ free(argv[idx]);
+ argv[idx] = strsave("???");
+ }
+ if (status && status != MR_NO_MATCH)
+ return(status);
+
+ if (!strcmp(q->shortname, "glin") && atoi(argv[6]) == -1) {
+ argv[6] = realloc(argv[6], strlen(UNIQUE_GID) + 1);
+ strcpy(argv[6], UNIQUE_GID);
+ }
+
+ /* send the data */
+ (*action)(q->vcnt, argv, actarg);
+
+ /* free saved data */
+ for (i = 0; i < q->vcnt; i++)
+ free(argv[i]);
+ free(argv);
+ }
+
+ sq_destroy(sq);
+ return (MR_SUCCESS);
+}
+
-followup_gars(q, sq, v, action, actarg)
+/* followup_gqot: Fix the entity name, directory name & modby fields
+ * argv[0] = filsys_id
+ * argv[1] = type
+ * argv[2] = entity_id
+ * argv[3] = ascii(quota)
+ */
+
+followup_gqot(q, sq, v, action, actarg, cl)
struct query *q;
- struct save_queue *sq;
+ register struct save_queue *sq;
struct validate *v;
- int (*action)();
- int actarg;
+ register int (*action)();
+ register int actarg;
+ client *cl;
##{
+ register int j;
+ char **argv, *malloc();
+## int id, rowcount;
+## char *name, *label;
+ int status, idx;
+
+ if (!strcmp(q->name, "get_quota") ||
+ !strcmp(q->name, "get_quota_by_filesys"))
+ idx = 4;
+ else
+ idx = 3;
+ while (sq_get_data(sq, &argv)) {
+ if (idx == 4) {
+ switch (argv[1][0]) {
+ case 'U':
+ status = id_to_name(atoi(argv[2]), "USER", &argv[2]);
+ break;
+ case 'G':
+ case 'L':
+ status = id_to_name(atoi(argv[2]), "LIST", &argv[2]);
+ break;
+ case 'A':
+ free(argv[2]);
+ argv[2] = strsave("system:anyuser");
+ break;
+ default:
+ id = atoi(argv[2]);
+ argv[2] = malloc(8);
+ sprintf(argv[2], "%d", id);
+ }
+ }
+ id = atoi(argv[idx]);
+ free(argv[idx]);
+ argv[idx] = malloc(256);
+ name = argv[idx];
+ if (id == 0) {
+ label = argv[0];
+## repeat retrieve (name = filesys.#name) where filesys.#label = @label
+ } else {
+## repeat retrieve (name = nfsphys.dir) where nfsphys.nfsphys_id = @id
+ }
+## inquire_equel(rowcount = "rowcount")
+ if (rowcount != 1) {
+ sprintf(argv[idx], "#%d", id);
+ }
+
+ id = atoi(argv[idx+3]);
+ if (id > 0)
+ status = id_to_name(id, "USER", &argv[idx+3]);
+ else
+ status = id_to_name(-id, "STRING", &argv[idx+3]);
+ if (status && status != MR_NO_MATCH)
+ return(status);
+ (*action)(q->vcnt, argv, actarg);
+ for (j = 0; j < q->vcnt; j++)
+ free(argv[j]);
+ free(argv);
+ }
+ sq_destroy(sq);
+ return(MR_SUCCESS);
+##}
+
+
+/* followup_aqot: Add allocation to nfsphys after creating quota.
+ * argv[0] = filsys_id
+ * argv[1] = type if "add_quota" or "update_quota"
+ * argv[2 or 1] = id
+ * argv[3 or 2] = ascii(quota)
+ */
+
+followup_aqot(q, argv, cl)
+ struct query *q;
char **argv;
- char *targv[4];
-## char oper[33];
-## char admin[33];
-## char shutdown[33];
-## int list_id;
+ client *cl;
+##{
+## int quota, id, fs, who;
+## char *entity, *qtype;
+
+ fs = *(int *)argv[0];
+ if (!strcmp(q->name, "add_quota") || !strcmp(q->name, "update_quota")) {
+ qtype = argv[1];
+ id = *(int *)argv[2];
+ quota = atoi(argv[3]);
+ } else {
+ qtype = "USER";
+ id = *(int *)argv[1];
+ quota = atoi(argv[2]);
+ }
+ who = cl->client_id;
+ entity = cl->entity;
+
+## repeat replace q (modtime = "now", modby = @who, modwith = @entity)
+## where q.filsys_id = @fs and q.type = @qtype and q.entity_id = @id
+## repeat replace nfsphys (allocated = nfsphys.allocated + @quota)
+## where nfsphys.nfsphys_id = filesys.#phys_id and filesys.filsys_id = @fs
+ if (ingres_errno) return(mr_errcode);
+ return(MR_SUCCESS);
+##}
- targv[1] = oper;
- targv[2] = admin;
- targv[3] = shutdown;
-## range of l is list
+followup_gpce(q, sq, v, action, actarg, cl)
+ struct query *q;
+ register struct save_queue *sq;
+ struct validate *v;
+ register int (*action)();
+ register int actarg;
+ client *cl;
+{
+ register int i, j;
+ char **argv, *malloc();
+ int id, status;
+ i = q->vcnt - 2;
while (sq_get_data(sq, &argv)) {
- sscanf(argv[1], "%d", &list_id);
-## repeat retrieve (oper = l.name) where l.#list_id = @list_id
- sscanf(argv[2], "%d", &list_id);
-## repeat retrieve (admin = l.name) where l.#list_id = @list_id
- sscanf(argv[3], "%d", &list_id);
-## repeat retrieve (shutdown = l.name) where l.#list_id = @list_id
-
- targv[0] = argv[0];
- (*action)(4, targv, actarg);
- free(argv[0]);
- free(argv[1]);
- free(argv[2]);
- free(argv[3]);
+ id = atoi(argv[PCAP_QSERVER]);
+ status = id_to_name(id, "MACHINE", &argv[PCAP_QSERVER]);
+ if (status) return (status);
+ id = atoi(argv[i]);
+ if (id > 0)
+ status = id_to_name(id, "USER", &argv[i]);
+ else
+ status = id_to_name(-id, "STRING", &argv[i]);
+ if (status && status != MR_NO_MATCH)
+ return(status);
+ (*action)(q->vcnt, argv, actarg);
+ for (j = 0; j < q->vcnt; j++)
+ free(argv[j]);
+ free(argv);
}
+ sq_destroy(sq);
+ return(MR_SUCCESS);
+}
+
+
+/* followup_gzcl:
+ */
+
+followup_gzcl(q, sq, v, action, actarg, cl)
+ register struct query *q;
+ register struct save_queue *sq;
+ register struct validate *v;
+ register int (*action)();
+ int actarg;
+ client *cl;
+{
+ int id, i, status;
+ char **argv;
+
+ while (sq_get_data(sq, &argv)) {
+ mr_trim_args(q->vcnt, argv);
+
+ id = atoi(argv[i = q->vcnt - 2]);
+ if (id > 0)
+ status = id_to_name(id, "USER", &argv[i]);
+ else
+ status = id_to_name(-id, "STRING", &argv[i]);
+ if (status && status != MR_NO_MATCH)
+ return(status);
+
+ for (i = 1; i < 8; i+=2) {
+ id = atoi(argv[i+1]);
+ if (!strcmp(argv[i], "LIST")) {
+ status = id_to_name(id, "LIST", &argv[i+1]);
+ } else if (!strcmp(argv[i], "USER")) {
+ status = id_to_name(id, "USER", &argv[i+1]);
+ } else if (!strcmp(argv[i], "KERBEROS")) {
+ status = id_to_name(id, "STRING", &argv[i+1]);
+ } else if (!strcmp(argv[i], "NONE")) {
+ status = 0;
+ free(argv[i+1]);
+ argv[i+1] = strsave("NONE");
+ } else {
+ status = 0;
+ free(argv[i+1]);
+ argv[i+1] = strsave("???");
+ }
+ if (status && status != MR_NO_MATCH)
+ return(status);
+ }
+ /* send the data */
+ (*action)(q->vcnt, argv, actarg);
+
+ /* free saved data */
+ for (i = 0; i < q->vcnt; i++)
+ free(argv[i]);
+ free(argv);
+ }
sq_destroy(sq);
- return(SMS_SUCCESS);
-##}
-\f
-/**
- ** set_next_object_id - set next object id in values table
- **
- ** Inputs: object - object name in values table
- **
- ** - called before an APPEND operation to set the next object id to
- ** be used for the new record
- **
- **/
+ return(MR_SUCCESS);
+}
-set_next_object_id(object)
- char *object;
-##{
-## char *name;
-## int rowcount;
- name = object;
-## range of v is values
-## repeat replace v (value = v.value + 1) where v.#name = @name
-## inquire_equel (rowcount = "rowcount")
- if (rowcount != 1)
- return SMS_INGRES_ERR;
- else return(SMS_SUCCESS);
-##}
+/* followup_gsha:
+ */
-/**
- ** get_query_need - check modtime of query's associated table against given
- ** time and return true if greater (false if not)
- **
- ** Inputs:
- ** argv[0] - query name
- ** argv[1] - time to compare against
- **
- **/
+followup_gsha(q, sq, v, action, actarg, cl)
+ register struct query *q;
+ register struct save_queue *sq;
+ register struct validate *v;
+ register int (*action)();
+ int actarg;
+ client *cl;
+{
+ char **argv;
+ int i, id, status;
-get_query_need(q, argv, action, actarg)
- struct query *q;
- register char *argv[];
- int (*action)();
-##{
- struct query *q1;
-## char *last_get_time;
-## char *table;
-## int need;
- char *result;
- struct query *get_query_by_name();
+ while (sq_get_data(sq, &argv)) {
+ mr_trim_args(q->vcnt, argv);
+
+ id = atoi(argv[4]);
+ if (id > 0)
+ status = id_to_name(id, "USER", &argv[4]);
+ else
+ status = id_to_name(-id, "STRING", &argv[4]);
+ if (status && status != MR_NO_MATCH)
+ return(status);
+
+ id = atoi(argv[2]);
+ if (!strcmp(argv[1], "LIST")) {
+ status = id_to_name(id, "LIST", &argv[2]);
+ } else if (!strcmp(argv[1], "USER")) {
+ status = id_to_name(id, "USER", &argv[2]);
+ } else if (!strcmp(argv[1], "KERBEROS")) {
+ status = id_to_name(id, "STRING", &argv[2]);
+ } else if (!strcmp(argv[1], "NONE")) {
+ status = 0;
+ free(argv[2]);
+ argv[2] = strsave("NONE");
+ } else {
+ status = 0;
+ free(argv[2]);
+ argv[2] = strsave("???");
+ }
+ if (status && status != MR_NO_MATCH)
+ return(status);
- q1 = get_query_by_name(argv[0]);
+ /* send the data */
+ (*action)(q->vcnt, argv, actarg);
- last_get_time = argv[1];
- table = q1->rtable;
+ /* free saved data */
+ for (i = 0; i < q->vcnt; i++)
+ free(argv[i]);
+ free(argv);
+ }
+ sq_destroy(sq);
+ return(MR_SUCCESS);
+}
- if (q1->type != RETRIEVE) return(SMS_NO_MATCH);
-## range of tbs is tblstats
-## repeat retrieve (need = any(tbs.modtime where tbs.#table = @table and
-## tbs.modtime > @last_get_time))
-
- result = (need) ? "true" : "false";
- (*action)(1, &result, actarg);
- return(SMS_SUCCESS);
-##}
+\f
+/* Special query routines */
-/**
- ** get_list_is_group
- ** get_list_is_maillist
- **
- ** Inputs:
- ** argv[0] - list_id
- **
- ** Returns:
- ** {true | false}
- **
- **/
+/* set_pobox - this does all of the real work.
+ * argv = user_id, type, box
+ * if type is POP, then box should be a machine, and its ID should be put in
+ * pop_id. If type is SMTP, then box should be a string and its ID should
+ * be put in box_id. If type is NONE, then box doesn't matter.
+ */
-get_list_is_group(q, argv, action, actarg)
+int set_pobox(q, argv, cl)
struct query *q;
- char *argv[];
- int (*action)();
+ char **argv;
+ client *cl;
+##{
+## int user, id, rowcount;
+## char *box, potype[9];
+ int status;
+
+ box = argv[2];
+ user = *(int *)argv[0];
+
+## repeat retrieve (id = users.pop_id, potype = users.#potype)
+## where users.users_id = @user
+ if (ingres_errno) return(mr_errcode);
+ if (!strcmp(strtrim(potype), "POP"))
+ set_pop_usage(id, -1);
+
+ if (!strcmp(argv[1], "POP")) {
+ status = name_to_id(box, "MACHINE", &id);
+ if (status == MR_NO_MATCH)
+ return(MR_MACHINE);
+ else if (status)
+ return(status);
+## repeat replace users (#potype = "POP", pop_id = @id)
+## where users.users_id = @user
+ set_pop_usage(id, 1);
+ } else if (!strcmp(argv[1], "SMTP")) {
+ if (index(box, '/') || index(box, '|'))
+ return(MR_BAD_CHAR);
+ status = name_to_id(box, "STRING", &id);
+ if (status == MR_NO_MATCH) {
+## repeat retrieve (id = values.value) where values.name = "strings_id"
+ id++;
+## repeat replace values (value = @id) where values.name = "strings_id"
+## append to strings (string_id = id, string = box)
+ } else if (status)
+ return(status);
+## repeat replace users (#potype = "SMTP", box_id = @id)
+## where users.users_id = @user
+ } else /* argv[1] == "NONE" */ {
+## repeat replace users (#potype = "NONE") where users.users_id = @user
+ }
+
+ set_pobox_modtime(q, argv, cl);
+## repeat replace tblstats (updates = tblstats.updates + 1, modtime = "now")
+## where tblstats.#table = "users"
+ if (ingres_errno) return(mr_errcode);
+ return(MR_SUCCESS);
+##}
+
+
+/* get_list_info: passed a wildcard list name, returns lots of stuff about
+ * each list. This is tricky: first build a queue of all requested
+ * data. Rest of processing consists of fixing gid, ace_name, and modby.
+ */
+
+get_list_info(q, aargv, cl, action, actarg)
+ register struct query *q;
+ char **aargv;
+ client *cl;
+ register int (*action)();
int actarg;
##{
-## int exists;
-## int list_id;
- char *result;
+ char *argv[13], *malloc(), *realloc();
+## char *name, acl_type[9], listname[33], active[5], public[5], hidden[5];
+## char maillist[5], group[5], gid[6], acl_name[256], desc[256], modtime[27];
+## char modby[256], modwith[9];
+## int id, rowcount, acl_id, hid, modby_id;
+ int returned, status;
+ struct save_queue *sq, *sq_create();
- list_id = *(int *)argv[0];
+ returned = rowcount = 0;
+ name = aargv[0];
+
+ sq = sq_create();
+## range of l is list
+## repeat retrieve (id = l.list_id) where l.#name = @name {
+ sq_save_data(sq, id);
+ rowcount++;
+## }
+ if (ingres_errno) return(mr_errcode);
+ if (rowcount == 0)
+ return(MR_NO_MATCH);
+
+ argv[0] = listname; argv[1] = active; argv[2] = public; argv[3] = hidden;
+ argv[4] = maillist; argv[5] = group; argv[6] = gid; argv[7] = acl_type;
+ argv[9] = desc; argv[10] = modtime; argv[12] = modwith;
+
+ while (sq_get_data(sq, &id)) {
+ if (id == 0)
+ continue;
+ argv[6] = gid;
+## repeat retrieve (listname = l.#name, active = text(l.#active),
+## public = text(l.#public), hidden = text(l.#hidden),
+## hid = l.#hidden, maillist = text(l.#maillist),
+## group = text(l.#group), gid = text(l.#gid),
+## acl_type = trim(l.#acl_type), acl_id = l.#acl_id,
+## desc = l.#desc, modtime = l.#modtime, modby_id = l.#modby,
+## modwith =l.#modwith)
+## where l.list_id = @id
+ if (ingres_errno) return(mr_errcode);
+
+ if (atoi(gid) == -1)
+ argv[6] = UNIQUE_GID;
+
+ argv[8] = malloc(0);
+ if (!strcmp(acl_type, "LIST")) {
+ status = id_to_name(acl_id, "LIST", &argv[8]);
+ } else if (!strcmp(acl_type, "USER")) {
+ status = id_to_name(acl_id, "USER", &argv[8]);
+ } else if (!strcmp(acl_type, "KERBEROS")) {
+ status = id_to_name(acl_id, "STRING", &argv[8]);
+ } else if (!strcmp(acl_type, "NONE")) {
+ status = 0;
+ free(argv[8]);
+ argv[8] = strsave("NONE");
+ } else {
+ status = 0;
+ free(argv[8]);
+ argv[8] = strsave("???");
+ }
+ if (status && status != MR_NO_MATCH) return(status);
+
+ argv[11] = malloc(0);
+ if (modby_id > 0)
+ status = id_to_name(modby_id, "USER", &argv[11]);
+ else
+ status = id_to_name(-modby_id, "STRING", &argv[11]);
+ if (status && status != MR_NO_MATCH) return(status);
-## range of g is groups
-## repeat retrieve (exists = any(g.#list_id where g.#list_id = @list_id))
+ mr_trim_args(q->vcnt, argv);
+ returned++;
+ (*action)(q->vcnt, argv, actarg);
+ free(argv[8]);
+ free(argv[11]);
+ }
- result = (exists) ? "true" : "false";
- (*action)(1, &result, actarg);
- return(SMS_SUCCESS);
+ sq_destroy(sq);
+ if (ingres_errno) return(mr_errcode);
+ return (MR_SUCCESS);
##}
-get_list_is_maillist(q, argv, action, actarg)
+
+/* Add_member_to_list: do list flattening as we go! MAXLISTDEPTH is
+ * how many different ancestors a member is allowed to have.
+ */
+
+#define MAXLISTDEPTH 1024
+
+int add_member_to_list(q, argv, cl)
struct query *q;
- char *argv[];
- int (*action)();
- int actarg;
+ char **argv;
+ client *cl;
##{
-## int exists;
-## int list_id;
- char *result;
+## int id, lid, mid, exists, error, who, ref;
+## char *mtype, dtype[9], *entity;
+ int ancestors[MAXLISTDEPTH], aref[MAXLISTDEPTH], acount, a;
+ int descendants[MAXLISTDEPTH], dref[MAXLISTDEPTH], dcount, d;
+ int status;
+ char *dtypes[MAXLISTDEPTH];
+ char *iargv[3], *buf;
+
+## range of m is imembers
+ lid = *(int *)argv[0];
+ mtype = argv[1];
+ mid = *(int *)argv[2];
+ /* if the member is already a direct member of the list, punt */
+## repeat retrieve (exists = any(m.list_id where m.list_id=@lid and
+## m.member_id = @mid and m.member_type = @mtype
+## and m.direct = 1))
+ if (exists)
+ return(MR_EXISTS);
+ if (!strcasecmp(mtype, "STRING")) {
+ buf = malloc(0);
+ status = id_to_name(mid, "STRING", &buf);
+ if (status) return(status);
+ if (index(buf, '/') || index(buf, '|')) {
+ free(buf);
+ return(MR_BAD_CHAR);
+ }
+ free(buf);
+ }
- list_id = *(int *)argv[0];
+ ancestors[0] = lid;
+ aref[0] = 1;
+ acount = 1;
+## repeat retrieve (id = m.list_id, ref = m.ref_count)
+## where m.member_id = @lid and m.member_type = "LIST" {
+ aref[acount] = ref;
+ ancestors[acount++] = id;
+ if (acount >= MAXLISTDEPTH) {
+## endretrieve
+ }
+## }
+ if (ingres_errno) return(mr_errcode);
+ if (acount >= MAXLISTDEPTH) {
+ return(MR_INTERNAL);
+ }
+ descendants[0] = mid;
+ dtypes[0] = mtype;
+ dref[0] = 1;
+ dcount = 1;
+ error = 0;
+ if (!strcmp(mtype, "LIST")) {
+## repeat retrieve (id = m.member_id, dtype = m.member_type,
+## ref = m.ref_count)
+## where m.list_id = @mid {
+ switch (dtype[0]) {
+ case 'L':
+ dtypes[dcount] = "LIST";
+ break;
+ case 'U':
+ dtypes[dcount] = "USER";
+ break;
+ case 'S':
+ dtypes[dcount] = "STRING";
+ break;
+ case 'K':
+ dtypes[dcount] = "KERBEROS";
+ break;
+ default:
+ error++;
+## endretrieve
+ }
+ dref[dcount] = ref;
+ descendants[dcount++] = id;
+ if (dcount >= MAXLISTDEPTH) {
+ error++;
+## endretrieve
+ }
+## }
+ if (ingres_errno) return(mr_errcode);
+ if (error)
+ return(MR_INTERNAL);
+ }
+ for (a = 0; a < acount; a++) {
+ lid = ancestors[a];
+ for (d = 0; d < dcount; d++) {
+ mid = descendants[d];
+ mtype = dtypes[d];
+ if (mid == lid && !strcmp(mtype, "LIST")) {
+ return(MR_LISTLOOP);
+ }
+## repeat retrieve (exists = any(m.ref_count where m.list_id = @lid
+## and m.member_id = @mid
+## and m.member_type = @mtype))
+ ref = aref[a] * dref[d];
+ if (exists) {
+ if (a == 0 && d == 0)
+## replace m (ref_count = m.ref_count+ref, direct = 1)
+## where m.list_id = lid and m.member_id = mid and
+## m.member_type = mtype
+ else
+## replace m (ref_count = m.ref_count+ref)
+## where m.list_id = lid and m.member_id = mid and
+## m.member_type = mtype
+ } else {
+ incremental_clear_before();
+ if (a == 0 && d == 0)
+## append imembers (list_id=lid, member_id = mid, direct = 1,
+## member_type=mtype, ref_count = 1)
+ else
+## append imembers (list_id=lid, member_id = mid,
+## member_type=mtype, ref_count = ref)
+ iargv[0] = (char *)lid;
+ iargv[1] = mtype;
+ iargv[2] = (char *)mid;
+ incremental_after("members", 0, iargv);
+ }
+ }
+ }
+ lid = *(int *)argv[0];
+ entity = cl->entity;
+ who = cl->client_id;
+## repeat replace list (modtime = "now", modby = @who, modwith = @entity)
+## where list.#list_id = @lid
+ if (ingres_errno) return(mr_errcode);
+ return(MR_SUCCESS);
+##}
-## range of ml is maillists
-## repeat retrieve (exists = any(ml.#list_id where ml.#list_id = @list_id))
- result = (exists) ? "true" : "false";
- (*action)(1, &result, actarg);
- return(SMS_SUCCESS);
+/* Delete_member_from_list: do list flattening as we go!
+ */
+
+int delete_member_from_list(q, argv, cl)
+ struct query *q;
+ char **argv;
+ client *cl;
+##{
+## int id, lid, mid, cnt, exists, error, who, ref;
+## char *mtype, dtype[9], *entity;
+ int ancestors[MAXLISTDEPTH], aref[MAXLISTDEPTH], acount, a;
+ int descendants[MAXLISTDEPTH], dref[MAXLISTDEPTH], dcount, d;
+ char *dtypes[MAXLISTDEPTH];
+ char *iargv[3];
+
+## range of m is imembers
+ lid = *(int *)argv[0];
+ mtype = argv[1];
+ mid = *(int *)argv[2];
+ /* if the member is not a direct member of the list, punt */
+## repeat retrieve (exists = any(m.list_id where m.list_id=@lid and
+## m.member_id = @mid and m.member_type = @mtype
+## and m.direct = 1))
+ if (ingres_errno) return(mr_errcode);
+ if (!exists)
+ return(MR_NO_MATCH);
+ ancestors[0] = lid;
+ aref[0] = 1;
+ acount = 1;
+## repeat retrieve (id = m.list_id, ref = m.ref_count)
+## where m.member_id = @lid and m.member_type = "LIST" {
+ aref[acount] = ref;
+ ancestors[acount++] = id;
+ if (acount >= MAXLISTDEPTH)
+## endretrieve
+## }
+ if (ingres_errno) return(mr_errcode);
+ if (acount >= MAXLISTDEPTH)
+ return(MR_INTERNAL);
+ descendants[0] = mid;
+ dtypes[0] = mtype;
+ dref[0] = 1;
+ dcount = 1;
+ error = 0;
+ if (!strcmp(mtype, "LIST")) {
+## repeat retrieve (id = m.member_id, dtype = m.member_type,
+## ref = m.ref_count)
+## where m.list_id = @mid {
+ switch (dtype[0]) {
+ case 'L':
+ dtypes[dcount] = "LIST";
+ break;
+ case 'U':
+ dtypes[dcount] = "USER";
+ break;
+ case 'S':
+ dtypes[dcount] = "STRING";
+ break;
+ case 'K':
+ dtypes[dcount] = "KERBEROS";
+ break;
+ default:
+ error++;
+## endretrieve
+ }
+ dref[dcount] = ref;
+ descendants[dcount++] = id;
+ if (dcount >= MAXLISTDEPTH)
+## endretrieve
+## }
+ if (ingres_errno) return(mr_errcode);
+ if (error)
+ return(MR_INTERNAL);
+ }
+ for (a = 0; a < acount; a++) {
+ lid = ancestors[a];
+ for (d = 0; d < dcount; d++) {
+ mid = descendants[d];
+ mtype = dtypes[d];
+ if (mid == lid && !strcmp(mtype, "LIST")) {
+ return(MR_LISTLOOP);
+ }
+## repeat retrieve (cnt = m.ref_count)
+## where m.list_id = @lid and m.member_id = @mid
+## and m.member_type = @mtype
+ ref = aref[a] * dref[d];
+ if (cnt <= ref) {
+ iargv[0] = (char *)lid;
+ iargv[1] = mtype;
+ iargv[2] = (char *)mid;
+ incremental_before("members", 0, iargv);
+## delete m where m.list_id = lid and m.member_id = mid and
+## m.member_type = mtype
+ incremental_clear_after();
+ } else if (a == 0 && d == 0) {
+## replace m (ref_count = m.ref_count-ref, direct = 0)
+## where m.list_id = lid and m.member_id = mid and
+## m.member_type = mtype
+ } else {
+## replace m (ref_count = m.ref_count-ref)
+## where m.list_id = lid and m.member_id = mid and
+## m.member_type = mtype
+ }
+ }
+ }
+ lid = *(int *)argv[0];
+ entity = cl->entity;
+ who = cl->client_id;
+## repeat replace list (modtime = "now", modby = @who, modwith = @entity)
+## where list.#list_id = @lid
+ if (ingres_errno) return(mr_errcode);
+ return(MR_SUCCESS);
##}
-\f
-/**
- ** add_locker - special query routine for creating a user locker
- **
- ** Inputs:
- ** argv[0] - users_id
- ** argv[1] - machine_id
- ** argv[2] - device
- ** argv[3] - initial quota
- **
- ** Description:
- ** - get prefix directory (dir) for mount point on specified machine/device
- ** - create filesys entry (label=<login>, type=NFS, machine=<machine>,
- ** mount=<dir>/<login>, access=w, acl=dbadmin)
- ** - increment allocated in nfsphys by quota
- ** - create nfsquota entry
- **
- ** Errors:
- ** - SMS_NFSPHYS - machine/device does not exist in nfsphys
- ** - SMS_FILESYS_EXISTS - file system already exists
- **
- **/
-add_locker(q, argv)
- register struct query *q;
+/* get_ace_use - given a type and a name, return a type and a name.
+ * The ace_type is one of "LIST", "USER", "RLIST", or "RUSER" in argv[0],
+ * and argv[1] will contain the ID of the entity in question. The R*
+ * types mean to recursively look at every containing list, not just
+ * when the object in question is a direct member. On return, the
+ * usage type will be one of LIST, SERVICE, FILESYS, QUOTA, QUERY, or ZEPHYR.
+ */
+
+int get_ace_use(q, argv, cl, action, actarg)
+ struct query *q;
char *argv[];
+ client *cl;
+ int (*action)();
+ int actarg;
##{
-## int users_id;
-## int mach_id;
-## char *device;
-## int quota;
-## int rowcount;
-## char login[9];
-## char dir[32];
-## int allocated;
-## char locker[64];
-## char mount[64];
-## int user_acl;
-
- /* copy arguments */
- users_id = *(int *)argv[0];
- mach_id = *(int *)argv[1];
- device = argv[2];
- sscanf(argv[3], "%d", "a);
+ int found = 0;
+## char *atype;
+## int aid, listid, id;
+ struct save_queue *sq, *sq_create();
+
+## range of m is imembers
+ atype = argv[0];
+ aid = *(int *)argv[1];
+ if (!strcmp(atype, "LIST") || !strcmp(atype, "USER") ||
+ !strcmp(atype, "KERBEROS")) {
+ return(get_ace_internal(atype, aid, action, actarg));
+ }
-## range of u is users
-## range of f is filesys
-## range of np is nfsphys
-## range of tbs is tblstats
+ sq = sq_create();
+ if (!strcmp(atype, "RLIST")) {
+ sq_save_data(sq, aid);
+ /* get all the list_id's of containing lists */
+## repeat retrieve (listid = m.list_id)
+## where m.member_type = "LIST" and m.member_id = @id {
+ sq_save_unique_data(sq, listid);
+## }
+ /* now process each one */
+ while (sq_get_data(sq, &id)) {
+ if (get_ace_internal("LIST", id, action, actarg) == MR_SUCCESS)
+ found++;
+ }
+ }
- /* get login name */
-## repeat retrieve (login = u.#login) where u.#users_id = @users_id
+ if (!strcmp(atype, "RUSER")) {
+## repeat retrieve (listid = m.list_id)
+## where m.member_type = "USER" and m.member_id = @aid {
+ sq_save_data(sq, listid);
+## }
+ /* now process each one */
+ while (sq_get_data(sq, &id)) {
+ if (get_ace_internal("LIST", id, action, actarg) == MR_SUCCESS)
+ found++;
+ }
+ if (get_ace_internal("USER", aid, action, actarg) == MR_SUCCESS)
+ found++;
+ }
- /* get user's acl id */
-## repeat retrieve (user_acl = list.list_id) where list.name = @login
+ if (!strcmp(atype, "RKERBERO")) {
+## repeat retrieve (listid = m.list_id)
+## where m.member_type = "KERBEROS" and m.member_id = @aid {
+ sq_save_data(sq, listid);
+## }
+ /* now process each one */
+ while (sq_get_data(sq, &id)) {
+ if (get_ace_internal("LIST", id, action, actarg) == MR_SUCCESS)
+ found++;
+ }
+ if (get_ace_internal("KERBEROS", aid, action, actarg) == MR_SUCCESS)
+ found++;
+ }
- /* get filesystem directory prefix; give error if machine/device
- pair not in nfsphys table */
- printf("np.mach_id = %d and np.device = %s\n", mach_id, device);
-
-## repeat retrieve (dir = np.#dir, allocated = np.#allocated)
-## where np.#mach_id = @mach_id and np.#device = @device
-## inquire_equel (rowcount = "rowcount")
- if (rowcount == 0) return(SMS_NFSPHYS);
-
- /* make sure a filesys with user's name does not already exist */
-## repeat retrieve (rowcount = any(f.label where f.label = @login))
- if (rowcount != 0) return(SMS_FILESYS_EXISTS);
-
- /* create a new filesys */
- sprintf(locker, "%s/%s", dir, login);
- sprintf(mount, "/mit/%s", login);
-## repeat append filesys
-## (#label = @login, type = "NFS", #mach_id = @mach_id,
-## name = @locker, access = "w", order = 1, #mount = @mount,
-## acl_id = @user_acl)
-## repeat replace tbs (appends = tbs.appends + 1, modtime = "now")
-## where tbs.table = "filesys"
-
- /* increment usage count in nfsphys table */
- allocated += quota;
-## replace np (#allocated = allocated)
-## where np.#mach_id = mach_id and np.#device = device
-## repeat replace tbs (updates = tbs.updates + 1, modtime = "now")
-## where tbs.table = "nfsphys"
-
- /* create nfsquota entry */
-## append nfsquota (#users_id = users_id, #mach_id = mach_id,
-## #device = device, #quota = quota)
-## repeat replace tbs (appends = tbs.appends + 1, modtime = "now")
-## where tbs.table = "nfsquota"
-
- return(SMS_SUCCESS);
+ sq_destroy(sq);
+ if (ingres_errno) return(mr_errcode);
+ if (!found) return(MR_NO_MATCH);
+ return(MR_SUCCESS);
##}
-/**
- ** delete_locker - special query routine for deleting a user locker
- **
- ** Inputs:
- ** argv[0] - users_id
- **
- ** Description:
- ** - get login name from users_id
- ** - get filesys entry from login
- ** - use filesys.mach_id and filesys.name to determine machine/device
- ** pair for nfsphys and nfsquota
- ** - delete filesys entry (label=<login>)
- ** - decrement allocated in nfsphys by quota
- ** - delete nfsquota entry
- **
- ** Errors:
- ** - SMS_FILESYS - no filesys exists for user
- **
- **/
-delete_locker(q, argv)
- register struct query *q;
- register char *argv[];
+/* This looks up a single list or user for ace use. atype must be "USER"
+ * or "LIST", and aid is the ID of the corresponding object. This is used
+ * by get_ace_use above.
+ */
+
+##get_ace_internal(atype, aid, action, actarg)
+## char *atype;
+## int aid;
+ int (*action)();
+ int actarg;
##{
-## int users_id;
-## int mach_id;
-## int quota;
-## int rowcount;
-## char login[9];
-## char lname[64];
-## char ndev[32];
- register char *c;
+ char *rargv[2];
+ int found = 0;
+## char name[33];
+
+ rargv[1] = name;
+ if (!strcmp(atype, "LIST")) {
+ rargv[0] = "FILESYS";
+## repeat retrieve (name = filesys.label)
+## where filesys.owners = @aid {
+ (*action)(2, rargv, actarg);
+ found++;
+## }
+
+ rargv[0] = "QUERY";
+## repeat retrieve (name = capacls.capability)
+## where capacls.list_id = @aid {
+ (*action)(2, rargv, actarg);
+ found++;
+## }
+ } else if (!strcmp(atype, "USER")) {
+ rargv[0] = "FILESYS";
+## repeat retrieve (name = filesys.label)
+## where filesys.owner = @aid {
+ (*action)(2, rargv, actarg);
+ found++;
+## }
+ }
- /* copy arguments */
- users_id = *(int *)argv[0];
+ rargv[0] = "LIST";
+## repeat retrieve (name = list.#name)
+## where list.acl_type = @atype and list.acl_id = @aid {
+ (*action)(2, rargv, actarg);
+ found++;
+## }
-## range of u is users
-## range of f is filesys
-## range of np is nfsphys
-## range of nq is nfsquota
-## range of tbs is tblstats
+ rargv[0] = "SERVICE";
+## repeat retrieve (name = servers.#name)
+## where servers.acl_type = @atype and servers.acl_id = @aid {
+ (*action)(2, rargv, actarg);
+ found++;
+## }
- /* get login name */
-## repeat retrieve (login = u.#login) where u.#users_id = @users_id
+ rargv[0] = "HOSTACCESS";
+## repeat retrieve (name = machine.#name)
+## where machine.mach_id = hostaccess.mach_id and
+## hostaccess.acl_type = @atype and hostaccess.acl_id = @aid {
+ (*action)(2, rargv, actarg);
+ found++;
+## }
+ rargv[0] = "ZEPHYR";
+## repeat retrieve (name = zephyr.class)
+## where zephyr.xmt_type = @atype and zephyr.xmt_id = @aid or
+## zephyr.sub_type = @atype and zephyr.sub_id = @aid or
+## zephyr.iws_type = @atype and zephyr.iws_id = @aid or
+## zephyr.iui_type = @atype and zephyr.iui_id = @aid {
+ (*action)(2, rargv, actarg);
+ found++;
+## }
- /* get mach_id and locker name from filesys entry; then delete it */
-## repeat retrieve (mach_id = f.#mach_id, lname = f.#name)
-## where f.#label = @login
-## inquire_equel (rowcount = "rowcount")
- if (rowcount == 0) return(SMS_FILESYS);
-## repeat delete f where f.#label = @login
-
- /* get prefix directory */
- c = (char *)rindex(lname, '/');
- *c = 0;
-
- /* get nfs device */
-## repeat retrieve (ndev = np.device)
-## where np.#mach_id = @mach_id and np.dir = @lname
-
- /* get quota from nfsquota entry; then delete entry */
-## repeat retrieve (quota = nq.#quota)
-## where nq.#mach_id = @mach_id and nq.#device = @ndev and
-## nq.#users_id = @users_id
-## repeat delete nq where nq.#mach_id = @mach_id and nq.#device = @ndev and
-## nq.#users_id = @users_id
-
- /* decrement nfsphys.allocated */
-## repeat replace np (allocated = np.allocated - @quota)
-## where np.#mach_id = @mach_id and np.#device = @ndev
-
- /* adjust table statistics */
-## repeat replace tbs (deletes = tbs.deletes + 1, modtime = "now")
-## where tbs.table = "filesys"
-## repeat replace tbs (updates = tbs.updates + 1, modtime = "now")
-## where tbs.table = "nfsphys"
-## repeat replace tbs (deletes = tbs.deletes + 1, modtime = "now")
-## where tbs.table = "nfsquota"
-
- return(SMS_SUCCESS);
+ if (!found) return(MR_NO_MATCH);
+ return(MR_SUCCESS);
##}
-\f
-/**
- ** add_user_group - create a group for a user and add user to group
- **
- ** Inputs:
- ** argv[0] - login
- **
- ** Description:
- ** - verify specified user exists
- ** - create a list of same name as user
- ** - add user as a member of the list
- **
- **/
-add_user_group(q, argv)
+
+/* get_lists_of_member - given a type and a name, return the name and flags
+ * of all of the lists of the given member. The member_type is one of
+ * "LIST", "USER", "STRING", "RLIST", "RUSER", or "RSTRING" in argv[0],
+ * and argv[1] will contain the ID of the entity in question. The R*
+ * types mean to recursively look at every containing list, not just
+ * when the object in question is a direct member.
+ */
+
+int get_lists_of_member(q, argv, cl, action, actarg)
struct query *q;
char *argv[];
+ client *cl;
+ int (*action)();
+ int actarg;
##{
-## char *login;
-## int exists;
-## int users_id;
-## int list_id;
-## int gid;
+ int found = 0, direct = 1;
+ char *rargv[6];
+## char *atype;
+## int aid, listid, id;
+## char name[33], active[5], public[5], hidden[5], maillist[5], group[5];
+
+ atype = argv[0];
+ aid = *(int *)argv[1];
+ if (!strcmp(atype, "RLIST")) {
+ atype = "LIST";
+ direct = 0;
+ }
+ if (!strcmp(atype, "RUSER")) {
+ atype = "USER";
+ direct = 0;
+ }
+ if (!strcmp(atype, "RSTRING")) {
+ atype = "STRING";
+ direct = 0;
+ }
+ if (!strcmp(atype, "RKERBEROS")) {
+ atype = "KERBEROS";
+ direct = 0;
+ }
- login = argv[0];
+ rargv[0] = name;
+ rargv[1] = active;
+ rargv[2] = public;
+ rargv[3] = hidden;
+ rargv[4] = maillist;
+ rargv[5] = group;
+## range of m is imembers
+ if (direct) {
+## repeat retrieve (name = list.#name, active = text(list.#active),
+## public = text(list.#public), hidden = text(list.#hidden),
+## maillist = text(list.#maillist), group = text(list.#group))
+## where list.list_id = m.list_id and m.direct = 1 and
+## m.member_type = @atype and m.member_id = @aid {
+ (*action)(6, rargv, actarg);
+ found++;
+## }
+ } else {
+## repeat retrieve (name = list.#name, active = text(list.#active),
+## public = text(list.#public), hidden = text(list.#hidden),
+## maillist = text(list.#maillist), group = text(list.#group))
+## where list.list_id = m.list_id and
+## m.member_type = @atype and m.member_id = @aid {
+ (*action)(6, rargv, actarg);
+ found++;
+## }
+ }
- /* verify user exists */
-## repeat retrieve (users_id = users.#users_id) where users.#login = @login
-## inquire_equel (exists = "rowcount")
- if (exists != 1) return(SMS_USER);
+ if (ingres_errno) return(mr_errcode);
+ if (!found) return(MR_NO_MATCH);
+ return(MR_SUCCESS);
+##}
- /* verify list does not exist */
-## repeat retrieve (exists = any(list.name where list.name = @login))
- if (exists) return(SMS_LIST);
- /* get new list_id */
-## repeat retrieve (list_id = values.value) where values.name = "list_id"
- list_id++;
-## repeat replace values (value = @list_id) where values.name = "list_id"
-
- /* create the list */
-## range of tbs is tblstats
-## repeat append list (name = @login, #list_id = @list_id, flags = 1,
-## desc = "User Group", acl_id = @list_id,
-## expdate = "today" + "5 years", modtime = "now")
-## repeat replace tbs (modtime = "now", appends = tbs.appends + 1)
-## where tbs.table = "list"
-
- /* add user to list */
-## repeat append members (#list_id = @list_id, member_type = "USER",
-## member_id = @users_id)
-## repeat replace tbs (modtime = "now", appends = tbs.appends + 1)
-## where tbs.table = "members"
-
- /* get new gid */
-## range of g is groups
-## range of v is values
-## repeat retrieve (gid = v.value) where v.name = "gid"
- exists = 1;
- while (exists) {
- gid++;
-## repeat retrieve (exists = any(g.#gid where g.#gid = @gid))
- }
-## repeat replace v (value = @gid) where v.name = "gid"
- /* add list to group table */
-## repeat append groups (#list_id = @list_id, ltid = list.tid, #gid = @gid)
-## where list.#list_id = @list_id
+/* qualified_get_lists: passed "TRUE", "FALSE", or "DONTCARE" for each of
+ * the five flags associated with each list. It will return the name of
+ * each list that meets the quailifications. It does this by building a
+ * where clause based on the arguments, then doing a retrieve.
+ */
-## repeat replace tbs (modtime = "now", appends = tbs.appends + 1)
-## where tbs.table = "groups"
+static char *lflags[5] = { "active", "public", "hidden", "maillist", "group" };
-## repeat replace tbs (modtime = "now", appends = tbs.appends + 1)
-## where tbs.table = "members"
+int qualified_get_lists(q, argv, cl, action, actarg)
+ struct query *q;
+ char *argv[];
+ client *cl;
+ int (*action)();
+ int actarg;
+{
+ return(qualified_get(q, argv, action, actarg, "l.list_id != 0",
+ "l", "name", lflags));
+}
- /* and we're done */
- return(SMS_SUCCESS);
-##}
-\f
-/**
- ** get_members_of_list - optimized query for retrieval of list members
+/** get_members_of_list - optimized query for retrieval of list members
**
** Inputs:
** argv[0] - list_id
**
** Description:
** - retrieve USER members, then LIST members, then STRING members
- **
**/
-get_members_of_list(q, argv, action, actarg)
+get_members_of_list(q, argv, cl, action, actarg)
struct query *q;
char *argv[];
+ client *cl;
int (*action)();
int actarg;
##{
-## int list_id;
-## char member_name[129];
+## int list_id, member_id;
+## char member_name[129], member_type[9];
char *targv[2];
+ int members;
+ struct save_queue *sq;
list_id = *(int *)argv[0];
- targv[0] = "USER";
- targv[1] = member_name;
+ members = 0;
+ sq = sq_create();
+
+## repeat retrieve (member_type = imembers.#member_type,
+## member_id = imembers.#member_id)
+## where imembers.#list_id = @list_id and imembers.direct = 1 {
+ if (members++ > 49)
+## endretrieve
+ sq_save_data(sq, (member_type[0] << 24) | (member_id & 0xffffff));
+## }
+ if (members <= 49) {
+ targv[1] = malloc(0);
+ while (sq_remove_data(sq, &member_id)) {
+ switch (member_id >> 24) {
+ case 'U':
+ targv[0] = "USER";
+ id_to_name(member_id & 0xffffff, "USER", &targv[1]);
+ (*action)(2, targv, actarg);
+ break;
+ case 'L':
+ targv[0] = "LIST";
+ id_to_name(member_id & 0xffffff, "LIST", &targv[1]);
+ (*action)(2, targv, actarg);
+ break;
+ case 'S':
+ targv[0] = "STRING";
+ id_to_name(member_id & 0xffffff, "STRING", &targv[1]);
+ (*action)(2, targv, actarg);
+ break;
+ case 'K':
+ targv[0] = "KERBEROS";
+ id_to_name(member_id & 0xffffff, "STRING", &targv[1]);
+ (*action)(2, targv, actarg);
+ break;
+ default:
+ sq_destroy(sq);
+ return(MR_INTERNAL);
+ }
+ }
+ free(targv[1]);
+ sq_destroy(sq);
+ return(MR_SUCCESS);
+ }
+ sq_destroy(sq);
-## range of m is members
+ targv[1] = member_name;
+ targv[0] = "USER";
+## range of m is imembers
## repeat retrieve (member_name = users.login)
-## where m.#list_id = @list_id and m.member_type = "USER"
-## and m.member_id = users.users_id
+## where m.#list_id = @list_id and m.#member_type = "USER"
+## and m.#member_id = users.users_id and m.direct = 1
## sort by #member_name
## {
(*action)(2, targv, actarg);
## }
+ if (ingres_errno) return(mr_errcode);
targv[0] = "LIST";
## repeat retrieve (member_name = list.name)
-## where m.#list_id = @list_id and m.member_type = "LIST"
-## and m.member_id = list.#list_id
+## where m.#list_id = @list_id and m.#member_type = "LIST"
+## and m.#member_id = list.#list_id and m.direct = 1
## sort by #member_name
## {
(*action)(2, targv, actarg);
## }
+ if (ingres_errno) return(mr_errcode);
targv[0] = "STRING";
## repeat retrieve (member_name = strings.string)
-## where m.#list_id = @list_id and m.member_type = "STRING"
-## and m.member_id = strings.string_id
+## where m.#list_id = @list_id and m.#member_type = "STRING"
+## and m.#member_id = strings.string_id and m.direct = 1
+## sort by #member_name
+## {
+ (*action)(2, targv, actarg);
+## }
+ if (ingres_errno) return(mr_errcode);
+
+ targv[0] = "KERBEROS";
+## repeat retrieve (member_name = strings.string)
+## where m.#list_id = @list_id and m.#member_type = "KERBEROS"
+## and m.#member_id = strings.string_id and m.direct = 1
## sort by #member_name
## {
(*action)(2, targv, actarg);
## }
+ if (ingres_errno) return(mr_errcode);
- return(SMS_SUCCESS);
+ return(MR_SUCCESS);
##}
-/**
- ** get_groups_of_user - optimized query for retrieval of all groups to
- ** which a user belongs
- **
- **/
-get_groups_of_user(q, argv, action, actarg)
+/* count_members_of_list: this is a simple query, but it cannot be done
+ * through the dispatch table.
+ */
+
+int count_members_of_list(q, argv, cl, action, actarg)
struct query *q;
char *argv[];
+ client *cl;
int (*action)();
int actarg;
##{
-## int users_id;
-## char list_name[33];
-## char gid[11];
-## int rowcount;
- char *targv[2];
-
- users_id = *(int *)argv[0];
- targv[0] = list_name;
- targv[1] = gid;
+## int list, ct = 0;
+ char *rargv[1], countbuf[5];
+
+ list = *(int *)argv[0];
+ rargv[0] = countbuf;
+## repeat retrieve (ct = count(imembers.list_id
+## where imembers.list_id = @list and
+## imembers.direct = 1))
+ if (ingres_errno) return(mr_errcode);
+ sprintf(countbuf, "%d", ct);
+ (*action)(1, rargv, actarg);
+ return(MR_SUCCESS);
+##}
-## range of m is members
-## repeat retrieve (list_name = list.name, gid = text(groups.#gid))
-## where m.member_id = @users_id and m.member_type = "USER" and
-## m.list_id = groups.list_id and groups.ltid = list.tid
-## sort by #list_name
-## {
- (*action)(2, targv, actarg);
-## }
-## inquire_equel (rowcount = "rowcount")
+/* qualified_get_server: passed "TRUE", "FALSE", or "DONTCARE" for each of
+ * the three flags associated with each service. It will return the name of
+ * each service that meets the quailifications. It does this by building a
+ * where clause based on the arguments, then doing a retrieve.
+ */
- return ((rowcount = 0) ? SMS_NO_MATCH : SMS_SUCCESS);
-##}
+static char *sflags[3] = { "enable", "inprogress", "harderror" };
-get_groups_of_all_users(q, argv, action, actarg)
+int qualified_get_server(q, argv, cl, action, actarg)
struct query *q;
char *argv[];
+ client *cl;
int (*action)();
int actarg;
-##{
-## char login[9];
-## char group[33];
-## char gid[11];
- char *targv[3];
-## int errorno;
-
- targv[0] = login;
- targv[1] = group;
- targv[2] = gid;
-
-## range of u is users
-## range of l is list
-## range of m is members
-## range of g is groups
-
-## set lockmode session where readlock = nolock
-
-## repeat retrieve (login = u.#login, group = l.name, gid = text(g.#gid))
-## where m.member_type = "USER" and m.member_id = u.users_id and
-## u.status != 0 and m.list_id = g.list_id and
-## g.ltid = l.tid
-## sort by #login, #group
-## {
- (*action)(3, targv, actarg);
-## }
+{
+ return(qualified_get(q, argv, action, actarg, "s.name != \"\"",
+ "s", "name", sflags));
+}
-## inquire_equel (errorno = "errorno")
-## set lockmode session where readlock = system
- return((errorno) ? SMS_INGRES_ERR : SMS_SUCCESS);
-##}
-\f
-/**
- ** get_all_poboxes - optimized query for retrieval of all poboxes
- **
- ** Description:
- ** - retrieve LOCAL boxes, then POP boxes, then FOREIGN boxes
- **
- **/
+/* generic qualified get routine, used by qualified_get_lists,
+ * qualified_get_server, and qualified_get_serverhost.
+ * Args:
+ * start - a simple where clause, must not be empty
+ * range - the name of the range variable
+ * field - the field to return
+ * flags - an array of strings, names of the flag variables
+ */
-get_all_poboxes(q, argv, action, actarg)
+int qualified_get(q, argv, action, actarg, start, range, field, flags)
struct query *q;
char *argv[];
int (*action)();
int actarg;
+ char *start;
+ char *range;
+ char *field;
+ char *flags[];
##{
-## char login[9];
-## char machine[129];
-## char box[129];
- char *targv[4];
-
- targv[0] = login;
- targv[2] = machine;
- targv[3] = box;
-
- targv[1] = "LOCAL";
-
-## set lockmode session where readlock = nolock
-## range of p is pobox
-## repeat retrieve (login=users.#login, machine = #machine.name, box=p.#box)
-## where p.type = "LOCAL" and p.users_id = users.users_id
-## and p.mach_id = #machine.mach_id
-## {
- (*action)(4, targv, actarg);
+## char name[33], qual[256], *rvar, *rtbl, *rfield;
+ char *rargv[1], buf[32];
+## int rowcount, i;
+
+ strcpy(qual, start);
+ for (i = 0; i < q->argc; i++) {
+ if (!strcmp(argv[i], "TRUE")) {
+ sprintf(buf, " and %s.%s != 0", range, flags[i]);
+ (void) strcat(qual, buf);
+ } else if (!strcmp(argv[i], "FALSE")) {
+ sprintf(buf, " and %s.%s = 0", range, flags[i]);
+ (void) strcat(qual, buf);
+ }
+ }
+
+ rargv[0] = name;
+ rvar = range;
+ rtbl = q->rtable;
+ rfield = field;
+## range of rvar is rtbl
+## retrieve (name = rvar.rfield) where qual {
+ (*action)(1, rargv, actarg);
## }
+ if (ingres_errno) return(mr_errcode);
+## inquire_equel(rowcount = "rowcount")
+ if (rowcount == 0)
+ return(MR_NO_MATCH);
+ return(MR_SUCCESS);
+##}
- targv[1] = "POP";
-## repeat retrieve (login=users.#login, machine = #machine.name, box=p.#box)
-## where p.type = "POP" and p.users_id = users.users_id
-## and p.mach_id = #machine.mach_id
-## {
- (*action)(4, targv, actarg);
-## }
- targv[1] = "FOREIGN";
-## repeat retrieve (login=users.#login, machine=strings.string, box=p.#box)
-## where p.type = "FOREIGN" and p.users_id = users.users_id
-## and p.mach_id = strings.string_id
-## {
- (*action)(4, targv, actarg);
-## }
-## set lockmode session where readlock = system
+/* qualified_get_serverhost: passed "TRUE", "FALSE", or "DONTCARE" for each of
+ * the five flags associated with each serverhost. It will return the name of
+ * each service and host that meets the quailifications. It does this by
+ * building a where clause based on the arguments, then doing a retrieve.
+ */
- return(SMS_SUCCESS);
-##}
+static char *shflags[6] = { "service", "enable", "override", "success",
+ "inprogress", "hosterror" };
-get_new_poboxes(q, argv, action, actarg)
+int qualified_get_serverhost(q, argv, cl, action, actarg)
struct query *q;
char *argv[];
+ client *cl;
int (*action)();
int actarg;
##{
-## char *created;
-## char login[9];
-## char machine[129];
-## char box[129];
- char *targv[4];
-
- created = argv[0];
-
- targv[0] = login;
- targv[2] = machine;
- targv[3] = box;
-
- targv[1] = "LOCAL";
-## range of p is pobox
-## repeat retrieve (login=users.#login, machine = #machine.name, box=p.#box)
-## where p.type = "LOCAL" and p.users_id = users.users_id
-## and p.mach_id = #machine.mach_id and
-## p.#created > @created
-## {
- (*action)(4, targv, actarg);
+## char sname[33], mname[33], qual[256];
+ char *rargv[2], buf[32];
+## int rowcount, i;
+
+ sprintf(qual, "machine.mach_id = sh.mach_id and sh.service = uppercase(\"%s\")",
+ argv[0]);
+ for (i = 1; i < q->argc; i++) {
+ if (!strcmp(argv[i], "TRUE")) {
+ sprintf(buf, " and sh.%s != 0", shflags[i]);
+ strcat(qual, buf);
+ } else if (!strcmp(argv[i], "FALSE")) {
+ sprintf(buf, " and sh.%s = 0", shflags[i]);
+ strcat(qual, buf);
+ }
+ }
+
+ rargv[0] = sname;
+ rargv[1] = mname;
+## range of sh is serverhosts
+## retrieve (sname = sh.service, mname = machine.name) where qual {
+ (*action)(2, rargv, actarg);
## }
+ if (ingres_errno) return(mr_errcode);
+## inquire_equel(rowcount = "rowcount")
+ if (rowcount == 0)
+ return(MR_NO_MATCH);
+ return(MR_SUCCESS);
+##}
- targv[1] = "POP";
-## repeat retrieve (login=users.#login, machine = #machine.name, box=p.#box)
-## where p.type = "POP" and p.users_id = users.users_id
-## and p.mach_id = #machine.mach_id and
-## p.#created > @created
-## {
- (*action)(4, targv, actarg);
-## }
- targv[1] = "FOREIGN";
-## repeat retrieve (login=users.#login, machine=strings.string, box=p.#box)
-## where p.type = "FOREIGN" and p.users_id = users.users_id
-## and p.mach_id = strings.string_id and
-## p.#created > @created
-## {
- (*action)(4, targv, actarg);
+/* register_user - change user's login name and allocate a pobox, group,
+ * filesystem, and quota for them. The user's status must start out as 0,
+ * and is left as 2. Arguments are: user's UID, new login name, and user's
+ * type for filesystem allocation (MR_FS_STUDENT, MR_FS_FACULTY,
+ * MR_FS_STAFF, MR_FS_MISC).
+ */
+
+register_user(q, argv, cl)
+ struct query *q;
+ char **argv;
+ client *cl;
+##{
+## char *login, dir[65], *entity, *directory, machname[33];
+## int who, rowcount, mid, uid, users_id, flag, utype, nid, list_id, quota;
+## int size, alloc, pid, m_id;
+ char buffer[256], *aargv[3];
+ int maxsize;
+
+ entity = cl->entity;
+ who = cl->client_id;
+
+ uid = atoi(argv[0]);
+ login = argv[1];
+ utype = atoi(argv[2]);
+
+## range of u is users
+## range of l is list
+## range of sh is serverhosts
+## range of n is nfsphys
+## range of m is machine
+
+ /* find user */
+## repeat retrieve (users_id = u.#users_id)
+## where u.#uid = @uid and (u.status = 0 or u.status = 5 or u.status = 6)
+## inquire_equel(rowcount = "rowcount");
+ if (rowcount == 0)
+ return(MR_NO_MATCH);
+ if (rowcount > 1)
+ return(MR_NOT_UNIQUE);
+
+ /* check new login name */
+## repeat retrieve (flag = any(u.#login where u.#login = @login and
+## u.#users_id != users_id))
+ if (ingres_errno) return(mr_errcode);
+ if (flag) return(MR_IN_USE);
+## repeat retrieve (flag = any(l.#name where l.#name = @login))
+ if (ingres_errno) return(mr_errcode);
+ if (flag) return(MR_IN_USE);
+## repeat retrieve (flag = any(filesys.#label where filesys.#label = @login))
+ if (ingres_errno) return(mr_errcode);
+ if (flag) return(MR_IN_USE);
+ com_err(whoami, 0, "new login name OK");
+
+ /* choose place for pobox, put in mid */
+## repeat retrieve (mid = sh.mach_id, machname = m.name)
+## where sh.service = "POP" and m.mach_id = sh.mach_id and
+## sh.value2 - sh.value1 = max(sh.value2-sh.value1 where sh.service="POP")
+ if (ingres_errno) return(mr_errcode);
+## inquire_equel(rowcount = "rowcount");
+ if (rowcount == 0)
+ return(MR_NO_POBOX);
+
+ /* change login name, set pobox */
+ sprintf(buffer, "u.users_id = %d", users_id);
+ incremental_before("users", buffer, 0);
+## repeat replace u (#login = @login, status = 2, modtime = "now",
+## modby = @who, modwith = @entity, potype="POP",
+## pop_id = @mid, pmodtime="now", pmodby=@who,
+## pmodwith=@entity)
+## where u.#users_id = @users_id
+## inquire_equel(rowcount = "rowcount");
+ if (ingres_errno) return(mr_errcode);
+ if (rowcount != 1)
+ return(MR_INTERNAL);
+ set_pop_usage(mid, 1);
+ com_err(whoami, 0, "set login name to %s and pobox to %s", login,
+ strtrim(machname));
+ incremental_after("users", buffer, 0);
+
+ /* create group list */
+ if (set_next_object_id("gid", "list"))
+ return(MR_NO_ID);
+ if (set_next_object_id("list_id", "list"))
+ return(MR_NO_ID);
+## repeat retrieve (list_id = values.value) where values.name = "list_id"
+ if (ingres_errno) return(mr_errcode);
+## inquire_equel(rowcount = "rowcount");
+ if (rowcount != 1)
+ return(MR_INTERNAL);
+ incremental_clear_before();
+## repeat append list (name = @login, #list_id = @list_id, active = 1,
+## public = 0, hidden = 0, maillist = 0, group = 1,
+## #gid = values.value, desc = "User Group",
+## acl_type = "USER", acl_id = @users_id, modtime = "now",
+## modby = @who, modwith = @entity)
+## where values.name = "gid"
+ if (ingres_errno) return(mr_errcode);
+## inquire_equel(rowcount = "rowcount");
+ if (rowcount != 1)
+ return(MR_INTERNAL);
+ sprintf(buffer, "l.list_id = %d", list_id);
+ incremental_after("list", buffer, 0);
+ aargv[0] = (char *) list_id;
+ aargv[1] = "USER";
+ aargv[2] = (char *) users_id;
+ incremental_clear_before();
+## repeat append imembers (#list_id = @list_id, member_type = "USER",
+## member_id = @users_id, ref_count = 1, direct = 1)
+ if (ingres_errno) return(mr_errcode);
+## inquire_equel(rowcount = "rowcount");
+ if (rowcount != 1)
+ return(MR_INTERNAL);
+ incremental_after("members", 0, aargv);
+ com_err(whoami, 0, "group list created");
+
+ /* decide where to put filesystem */
+ maxsize = 0;
+ directory = NULL;
+## repeat retrieve (mid = n.mach_id, dir = trim(n.#dir), nid = n.nfsphys_id,
+## flag = n.status, size = n.#size, alloc = n.allocated) {
+ if ((flag & utype) && (size != 0) && (size - alloc > maxsize)) {
+ maxsize = size - alloc;
+ if (directory)
+ free(directory);
+ directory = strsave(dir);
+ pid = nid;
+ m_id = mid;
+ }
## }
+ if (ingres_errno) return(mr_errcode);
+ if (maxsize == 0)
+ return(MR_NO_FILESYS);
+
+ /* create filesystem */
+ if (set_next_object_id("filsys_id", "filesys"))
+ return(MR_NO_ID);
+ incremental_clear_before();
+## repeat append filesys (filsys_id = values.value, phys_id = @pid,
+## label = @login, type = "NFS", mach_id = @m_id,
+## name = @directory + "/" + @login,
+## mount = "/mit/" + @login,
+## access = "w", comments = "User Locker",
+## owner = @users_id, owners = @list_id, createflg = 1,
+## lockertype = "HOMEDIR", modtime = "now",
+## modby = @who, modwith = @entity)
+## where values.name = "filsys_id"
+ if (ingres_errno) return(mr_errcode);
+## inquire_equel(rowcount = "rowcount");
+ if (rowcount != 1)
+ return(MR_INTERNAL);
+ incremental_after("filesys",
+ "fs.filsys_id = values.value and values.name = \"filsys_id\"",
+ 0);
+ com_err(whoami, 0, "filesys created on mach %d in %s/%s", m_id,
+ directory, login);
+
+ /* set quota */
+## repeat retrieve (quota = values.value) where values.name = "def_quota"
+ if (ingres_errno) return(mr_errcode);
+## inquire_equel(rowcount = "rowcount");
+ if (rowcount != 1)
+ return(MR_NO_QUOTA);
+ incremental_clear_before();
+## repeat append #quota (entity_id = @users_id, filsys_id = values.value,
+## type = "USER",
+## #quota = @quota, phys_id = @pid, modtime = "now",
+## modby = @who, modwith = @entity)
+## where values.name = "filsys_id"
+ if (ingres_errno) return(mr_errcode);
+## inquire_equel(rowcount = "rowcount");
+ if (rowcount != 1)
+ return(MR_INTERNAL);
+## repeat replace nfsphys (allocated = nfsphys.allocated + @quota)
+## where nfsphys.nfsphys_id = filesys.#phys_id and
+## filesys.filsys_id = values.value and values.name = "filsys_id"
+ if (ingres_errno) return(mr_errcode);
+## inquire_equel(rowcount = "rowcount");
+ if (rowcount != 1)
+ return(MR_INTERNAL);
+ aargv[0] = login;
+ aargv[1] = "USER";
+ aargv[2] = login;
+ sprintf(buffer, "q.entity_id = %d and q.filsys_id = values.value and q.type = \"USER\" and values.name = \"filsys_id\"", users_id);
+ incremental_after("quota", buffer, aargv);
+ com_err(whoami, 0, "quota of %d assigned", quota);
+ if (ingres_errno) return(mr_errcode);
+
+ cache_entry(login, "USER", users_id);
+
+## repeat replace tblstats (updates = tblstats.updates + 1, modtime = "now")
+## where tblstats.table = "users"
+## repeat replace tblstats (appends = tblstats.appends + 1, modtime = "now")
+## where tblstats.table = "list" or tblstats.table = "filesys" or
+## tblstats.table = "quota"
+ if (ingres_errno) return(mr_errcode);
+ return(MR_SUCCESS);
+##}
+
+
+
+/** set_pop_usage - incr/decr usage count for pop server in serverhosts talbe
+ **
+ ** Inputs:
+ ** id of machine
+ ** delta (will be +/- 1)
+ **
+ ** Description:
+ ** - incr/decr value field in serverhosts table for pop/mach_id
+ **
+ **/
+
+static int set_pop_usage(id, count)
+int id;
+int count;
+##{
+## int mach_id = id;
+## int n = count;
+
+## repeat replace serverhosts (value1 = serverhosts.value1 + @n)
+## where serverhosts.service = "POP" and serverhosts.#mach_id = @mach_id
- return(SMS_SUCCESS);
+ if (ingres_errno) return(mr_errcode);
+ return(MR_SUCCESS);
##}
+
+
\f
/* Validation Routines */
table = q->rtable;
name = v->field;
- if (log_flags & LOG_RES)
+ if (log_flags & LOG_VALID)
/* tell the logfile what we're doing */
com_err(whoami, 0, "validating row: %s", qual);
/* look for the record */
## range of rvar is table
## retrieve (rowcount = count(rvar.name where qual))
- if (rowcount == 0) return(SMS_NO_MATCH);
- if (rowcount > 1) return(SMS_NOT_UNIQUE);
- return(SMS_EXISTS);
+ if (ingres_errno) return(mr_errcode);
+ if (rowcount == 0) return(MR_NO_MATCH);
+ if (rowcount > 1) return(MR_NOT_UNIQUE);
+ return(MR_EXISTS);
##}
validate_fields(q, argv, vo, n)
while (--n >= 0) {
switch (vo->type) {
case V_NAME:
- if (log_flags & LOG_RES)
+ if (log_flags & LOG_VALID)
com_err(whoami, 0, "validating %s in %s: %s",
vo->namefield, vo->table, argv[vo->index]);
status = validate_name(argv, vo);
break;
case V_ID:
- if (log_flags & LOG_RES)
+ if (log_flags & LOG_VALID)
com_err(whoami, 0, "validating %s in %s: %s",
vo->idfield, vo->table, argv[vo->index]);
status = validate_id(argv, vo);
break;
case V_DATE:
- if (log_flags & LOG_RES)
+ if (log_flags & LOG_VALID)
com_err(whoami, 0, "validating date: %s", argv[vo->index]);
status = validate_date(argv, vo);
break;
case V_TYPE:
- if (log_flags & LOG_RES)
+ if (log_flags & LOG_VALID)
com_err(whoami, 0, "validating %s type: %s",
vo->table, argv[vo->index]);
status = validate_type(argv, vo);
break;
case V_TYPEDATA:
- if (log_flags & LOG_RES)
+ if (log_flags & LOG_VALID)
com_err(whoami, 0, "validating typed data (%s): %s",
argv[vo->index - 1], argv[vo->index]);
status = validate_typedata(q, argv, vo);
break;
- case V_FOLLOWUP:
- status = SMS_EXISTS;
+ case V_RENAME:
+ if (log_flags & LOG_VALID)
+ com_err(whoami, 0, "validating rename %s in %s",
+ argv[vo->index], vo->table);
+ status = validate_rename(argv, vo);
+ break;
+
+ case V_CHAR:
+ if (log_flags & LOG_VALID)
+ com_err(whoami, 0, "validating chars: %s", argv[vo->index]);
+ status = validate_chars(argv[vo->index]);
break;
case V_SORT:
- status = SMS_EXISTS;
+ status = MR_EXISTS;
break;
+ case V_LOCK:
+ status = lock_table(vo);
+ break;
}
- if (status != SMS_EXISTS) return(status);
+ if (status != MR_EXISTS) return(status);
vo++;
}
- return(SMS_SUCCESS);
+ if (ingres_errno) return(mr_errcode);
+ return(MR_SUCCESS);
+}
+
+
+/* validate_chars: verify that there are no illegal characters in
+ * the string. Legal characters are printing chars other than
+ * ", *, ?, \, [ and ].
+ */
+static int illegalchars[] = {
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, /* ^@ - ^O */
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, /* ^P - ^_ */
+ 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, /* SPACE - / */
+ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, /* 0 - ? */
+ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, /* @ - O */
+ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, /* P - _ */
+ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, /* ` - o */
+ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, /* p - ^? */
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
+};
+
+validate_chars(s)
+register char *s;
+{
+ while (*s)
+ if (illegalchars[*s++])
+ return(MR_BAD_CHAR);
+ return(MR_EXISTS);
}
+
validate_id(argv, vo)
char *argv[];
register struct valobj *vo;
## char *table;
## char *namefield;
## char *idfield;
-## int id;
-## int rowcount;
+## int id, rowcount;
+ int status;
register char *c;
+
name = argv[vo->index];
table = vo->table;
- /* minor kludge to upcasify machine names */
- if (!bcmp(table, "machine", 7))
- for (c = name; *c; c++) if (islower(*c)) *c = toupper(*c);
namefield = vo->namefield;
idfield = vo->idfield;
- if (!bcmp(namefield, "uid", 4)) {
+
+ if ((!strcmp(table, "users") && !strcmp(namefield, "login")) ||
+ !strcmp(table, "machine") ||
+ !strcmp(table, "filesys") ||
+ !strcmp(table, "list") ||
+ !strcmp(table, "cluster") ||
+ !strcmp(table, "string")) {
+ if (!strcmp(table, "machine"))
+ for (c = name; *c; c++) if (islower(*c)) *c = toupper(*c);
+ status = name_to_id(name, table, &id);
+ if (status == 0) {
+ *(int *)argv[vo->index] = id;
+ return(MR_EXISTS);
+ } else if (status == MR_NO_MATCH || status == MR_NOT_UNIQUE)
+ return(vo->error);
+ else
+ return(status);
+ }
+
+ if (!strcmp(namefield, "uid")) {
## retrieve (id = table.idfield) where table.namefield = int4(name)
+ if (ingres_errno) return(mr_errcode);
## inquire_equel (rowcount = "rowcount")
} else {
## retrieve (id = table.idfield) where table.namefield = name
+ if (ingres_errno) return(mr_errcode);
## inquire_equel (rowcount = "rowcount")
}
if (rowcount != 1) return(vo->error);
*(int *)argv[vo->index] = id;
- return(SMS_EXISTS);
+ return(MR_EXISTS);
##}
validate_name(argv, vo)
## char *table;
## char *namefield;
## int rowcount;
+ register char *c;
name = argv[vo->index];
table = vo->table;
namefield = vo->namefield;
+ if (!strcmp(table, "servers") && !strcmp(namefield, "name")) {
+ for (c = name; *c; c++)
+ if (islower(*c))
+ *c = toupper(*c);
+ }
## retrieve (rowcount = countu(table.namefield
## where table.namefield = name))
- return ((rowcount == 1) ? SMS_EXISTS : vo->error);
+ if (ingres_errno) return(mr_errcode);
+ return ((rowcount == 1) ? MR_EXISTS : vo->error);
##}
-/* Special validation routine for get_filesys */
-validate_label(q, argv)
- struct query *q;
- char *argv[];
-{
- register char *label;
- register char *c;
-
- label = argv[0];
- c = (char *)index(label, '*');
- if (c == label) return(SMS_NOT_UNIQUE);
- return(SMS_SUCCESS);
-}
-
-/* Special validation routine for delete_filesys */
-validate_label_2(q, argv)
- struct query *q;
- char *argv[];
-{
- if (index(argv[0], '*') != 0) return(SMS_NOT_UNIQUE);
- return(SMS_SUCCESS);
-}
-
validate_date(argv, vo)
char *argv[];
struct valobj *vo;
## retrieve (dd = interval("years", date(idate) - date("today")))
## inquire_equel (errorno = "errorno")
- if (errorno != 0 || dd > 5.0) return(SMS_DATE);
- return(SMS_SUCCESS);
+ if (errorno != 0 || dd > 5.0) return(MR_DATE);
+ return(MR_EXISTS);
+##}
+
+
+validate_rename(argv, vo)
+char *argv[];
+struct valobj *vo;
+##{
+## char *name, *table, *namefield, *idfield;
+## int id;
+ int status;
+ register char *c;
+
+ c = name = argv[vo->index];
+ while (*c)
+ if (illegalchars[*c++])
+ return(MR_BAD_CHAR);
+ table = vo->table;
+ /* minor kludge to upcasify machine names */
+ if (!strcmp(table, "machine"))
+ for (c = name; *c; c++) if (islower(*c)) *c = toupper(*c);
+ namefield = vo->namefield;
+ idfield = vo->idfield;
+ id = -1;
+ if (idfield == 0) {
+ if (!strcmp(argv[vo->index], argv[vo->index - 1]))
+ return(MR_EXISTS);
+## retrieve (id = any(table.namefield where table.namefield = name))
+ if (ingres_errno) return(mr_errcode);
+ if (id)
+ return(vo->error);
+ else
+ return(MR_EXISTS);
+ }
+ status = name_to_id(name, table, &id);
+ if (status == MR_NO_MATCH || id == *(int *)argv[vo->index - 1])
+ return(MR_EXISTS);
+ else
+ return(vo->error);
##}
+
validate_type(argv, vo)
char *argv[];
register struct valobj *vo;
##{
## char *typename;
## char *value;
-## int rowcount;
+## int exists;
register char *c;
typename = vo->table;
- value = argv[vo->index];
+ c = value = argv[vo->index];
+ while (*c)
+ if (illegalchars[*c++])
+ return(MR_BAD_CHAR);
/* uppercase type fields */
for (c = value; *c; c++) if (islower(*c)) *c = toupper(*c);
-## range of a is alias
-## repeat retrieve (rowcount = count(a.trans where a.name = @typename and
-## a.type = "TYPE" and
-## a.trans = @value))
- return ((rowcount == 1) ? SMS_EXISTS : vo->error);
+## repeat retrieve (exists = any(alias.trans where alias.name = @typename and
+## alias.type = "TYPE" and alias.trans = @value))
+ if (ingres_errno) return(mr_errcode);
+ return (exists ? MR_EXISTS : vo->error);
##}
/* validate member or type-specific data field */
##{
## char *name;
## char *field_type;
-## char data_type[17];
-## int id;
-## int refc;
-## int rowcount;
+## char data_type[129];
+## int id, rowcount;
+ int status;
+ char *index();
register char *c;
/* get named object */
/* get corresponding data type associated with field type name */
## repeat retrieve (data_type = alias.trans)
## where alias.#name = @field_type and alias.type = "TYPEDATA"
+ if (ingres_errno) return(mr_errcode);
## inquire_equel (rowcount = "rowcount")
- if (rowcount != 1) return(SMS_TYPE);
+ if (rowcount != 1) return(MR_TYPE);
/* now retrieve the record id corresponding to the named object */
-
+ if (index(data_type, ' '))
+ *index(data_type, ' ') = 0;
if (!strcmp(data_type, "user")) {
/* USER */
-## repeat retrieve (id = users.users_id) where users.login = @name
-## inquire_equel (rowcount = "rowcount")
- if (rowcount != 1) return(SMS_USER);
-
+ status = name_to_id(name, data_type, &id);
+ if (status && (status == MR_NO_MATCH || status == MR_NOT_UNIQUE))
+ return(MR_USER);
+ if (status) return(status);
} else if (!strcmp(data_type, "list")) {
/* LIST */
-## repeat retrieve (id = list.list_id) where list.#name = @name
-## inquire_equel (rowcount = "rowcount")
- if (rowcount != 1) return(SMS_LIST);
-
+ status = name_to_id(name, data_type, &id);
+ if (status && status == MR_NOT_UNIQUE)
+ return(MR_LIST);
+ if (status == MR_NO_MATCH) {
+ /* if idfield is non-zero, then if argv[0] matches the string
+ * that we're trying to resolve, we should get the value of
+ * values.[idfield] for the id.
+ */
+ if (vo->idfield && !strcmp(argv[0], argv[vo->index])) {
+ set_next_object_id(q->validate->object_id, q->rtable);
+ name = vo->idfield;
+## repeat retrieve (id = values.value) where values.#name = @name
+## inquire_equel(rowcount = "rowcount")
+ if (rowcount != 1) return(MR_LIST);
+ } else
+ return(MR_LIST);
+ } else if (status) return(status);
} else if (!strcmp(data_type, "machine")) {
/* MACHINE */
for (c = name; *c; c++) if (islower(*c)) *c = toupper(*c);
-## repeat retrieve (id = machine.mach_id) where machine.#name = @name
-## inquire_equel (rowcount = "rowcount")
- if (rowcount != 1) return(SMS_MACHINE);
-
+ status = name_to_id(name, data_type, &id);
+ if (status && (status == MR_NO_MATCH || status == MR_NOT_UNIQUE))
+ return(MR_MACHINE);
+ if (status) return(status);
} else if (!strcmp(data_type, "string")) {
/* STRING */
-## range of s is strings
-## repeat retrieve (id = s.string_id, refc = s.#refc)
-## where s.string = @name
-## inquire_equel (rowcount = "rowcount")
- if (rowcount == 0) {
- if (q->type != APPEND) return(SMS_STRING);
-## range of v is values
-## retrieve (id = v.value) where v.#name = "strings_id"
+ status = name_to_id(name, data_type, &id);
+ if (status && status == MR_NOT_UNIQUE)
+ return(MR_STRING);
+ if (status == MR_NO_MATCH) {
+ if (q->type != APPEND && q->type != UPDATE) return(MR_STRING);
+## retrieve (id = values.value) where values.#name = "strings_id"
id++;
-## replace v (value = id) where v.#name = "strings_id"
-## append to strings (string_id = id, string = name, #refc = 1)
- } else if (rowcount == 1) {
- if (q->type == APPEND || q->type == DELETE) {
- refc += (q->type == APPEND) ? 1 : -1;
- if (refc > 0) {
-## replace s (#refc = refc) where s.string_id = id
- } else {
-## delete s where s.string_id = id
- }
- }
- }
+## replace values (value = id) where values.#name = "strings_id"
+## append to strings (string_id = id, string = name)
+ } else if (status) return(status);
+ } else if (!strcmp(data_type, "none")) {
+ id = 0;
} else {
- return(SMS_TYPE);
+ return(MR_TYPE);
}
/* now set value in argv */
*(int *)argv[vo->index] = id;
- return (SMS_EXISTS);
+ return (MR_EXISTS);
##}
-\f
-translate_ids(q, sq, v, action, actarg)
- register struct query *q;
- register struct save_queue *sq;
- register struct validate *v;
- register int (*action)();
- int actarg;
-##{
-## char *name;
-## char *field_type;
-## char data_type[17];
-## int id;
-## int rowcount;
- register int i;
- struct valobj *vo;
- char **argv;
-
- for (i = 0; i < v->objcnt; i++) {
- vo = &v->valobj[i];
- if (vo->type == V_FOLLOWUP) break;
- }
-
- /* for each row */
- while (sq_get_data(sq, &argv)) {
-
- /* get object id */
- i = vo->index;
- sscanf(argv[i], "%d", &id);
- free(argv[i]);
- name = (char *)malloc(129);
- argv[i] = name;
-
- /* get field type string (known to be at index-1) */
- field_type = argv[vo->index-1];
-
- /* get corresponding data type associated with field type name */
-## repeat retrieve (data_type = alias.trans)
-## where alias.#name = @field_type and alias.type = "TYPEDATA"
-## inquire_equel (rowcount = "rowcount")
- if (rowcount != 1) {
- sprintf(name, "%d", id);
- (*action)(q->vcnt, argv, actarg);
- continue;
- }
-
- /* retrieve object name */
-
- if (!strcmp(data_type, "user")) {
- /* USER */
-## repeat retrieve (name = users.login) where users.users_id = @id
-## inquire_equel (rowcount = "rowcount")
-
- } else if (!strcmp(data_type, "list")) {
- /* LIST */
-## repeat retrieve (name = list.#name) where list.list_id = @id
-## inquire_equel (rowcount = "rowcount")
- } else if (!strcmp(data_type, "machine")) {
- /* MACHINE */
-## repeat retrieve (name = machine.#name) where machine.mach_id = @id
-## inquire_equel (rowcount = "rowcount")
+/* Lock the table named by the validation object */
- } else if (!strcmp(data_type, "string")) {
- /* STRING */
-## repeat retrieve (name = strings.string)
-## where strings.string_id = @id
-## inquire_equel (rowcount = "rowcount")
-
- } else {
- rowcount = 0;
- }
+lock_table(vo)
+struct valobj *vo;
+##{
+## char *table, *idfield;
+## int rowcount;
- /* if there wasn't a corresponding object name, then use the id */
- if (rowcount != 1) sprintf(name, "%d", id);
+ table = vo->table;
+ idfield = vo->idfield;
+## replace table (modtime = "now") where table.idfield = 0
+ if (ingres_errno) return(mr_errcode);
+## inquire_equel (rowcount = "rowcount")
+ if (rowcount != 1)
+ return(vo->error);
+ else
+ return(MR_EXISTS);
+##}
- /* send the data */
- (*action)(q->vcnt, argv, actarg);
- /* free saved data */
- for (i = 0; i < q->vcnt; i++)
- free(argv[i]);
- free(argv);
- }
+/* Check the database at startup time. For now this just resets the
+ * inprogress flags that the DCM uses.
+ */
- sq_destroy(sq);
- return (SMS_SUCCESS);
+sanity_check_database()
+##{
##}
-\f
-/*
- * Local Variables:
- * mode: c
- * c-indent-level: 4
- * c-continued-statement-offset: 4
- * c-brace-offset: -4
- * c-argdecl-indent: 4
- * c-label-offset: -4
- * End:
- */