X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/blobdiff_plain/9fbd2090d429bfb536ec6fd95ca5c11faab73b02..67805159a972397342c342ee735c8acd640e1399:/server/qsupport.qc diff --git a/server/qsupport.qc b/server/qsupport.qc index c016c232..5e363834 100644 --- a/server/qsupport.qc +++ b/server/qsupport.qc @@ -4,1607 +4,2790 @@ * $Header$ * * Copyright (C) 1987 by the Massachusetts Institute of Technology + * For copying and distribution information, please see the file + * . * - * $Log$ - * Revision 1.11 1987-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 #include "query.h" -#include "sms_server.h" +#include "mr_server.h" #include -#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)) { - users_id = *(int *)argv[0]; - mach_id = *(int *)argv[2]; - box = argv[3]; -## range of p is pobox -## repeat retrieve (exists = any(p.#box where p.#users_id = @users_id -## and p.type = "POP" -## and p.#mach_id = @mach_id -## and p.#box = @box)) - 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 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" - 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); ##} - -/** - ** 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] = "#" - ** - **/ -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 (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); +##} - 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" + + +/* 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] = "#" + */ + +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); ##} - + + +/* 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; + + 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 (!bcmp(type, "RVD", 3)) - return (check_rvd(mach_id, name, access)); - else if (!bcmp(type, "NFS", 3)) + if (!strcmp(type, "NFS")) return (check_nfs(mach_id, name, access)); else - return(SMS_SUCCESS); -} + return(MR_SUCCESS); +##} -setup_update_filesys(q, argv) + +/* 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_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 = 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) { if (*cp1++ != *cp2) break; cp2++; } - if (*cp2 == 0) return(SMS_SUCCESS); + if (*cp2 == 0) { + status = MR_SUCCESS; +## endretrieve + } ## } - - return(SMS_NFS); + if (ingres_errno) + return(mr_errcode); + return(status); ##} - -/* 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 - 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); ##} - -/** - ** 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 +/* 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); -##} -/** - ** 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; - - users_id = *(int *)argv[0]; - type = argv[1]; - mach_id = *(int *)argv[2]; - box = argv[3]; +## char *name, *entity, *table; +## int who; -## 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; - - if (bcmp(argv[1], "POP", 3)) return(SMS_SUCCESS); - - mach_id = *(int *)argv[2]; - n = count; +## char *entity, *table, *id_name; +## int who, id; -## 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); ##} - -/** - ** 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); ##} - -/** - ** 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); ##} - -/** - ** delete_list_members - called after the delete_list query to clean up - ** members table. - ** - ** Inputs: argv[0] - list_id - ** - ** Description: - ** - foreach string member: decr string refc; ifzero, delete string - ** - delete all members entries for this list_id - ** - **/ -delete_list_members(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 - return(SMS_SUCCESS); -##} - /** - ** 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]); - 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); + /* 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)) { + 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; -followup_gars(q, sq, v, action, actarg) + 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_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); -##} - -/** - ** 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; - name = object; -## range of v is values -## repeat replace v (value = v.value + 1) where v.#name = @name - 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); -##} + +/* 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); -## range of g is groups -## repeat retrieve (exists = any(g.#list_id where g.#list_id = @list_id)) + 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); - result = (exists) ? "true" : "false"; - (*action)(1, &result, actarg); - return(SMS_SUCCESS); + mr_trim_args(q->vcnt, argv); + returned++; + (*action)(q->vcnt, argv, actarg); + free(argv[8]); + free(argv[11]); + } + + 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); ##} - -/** - ** 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=, type=NFS, machine=, - ** mount=/, 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=) - ** - 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); ##} - -/** - ** 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" +/* 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. + */ - /* add list to group table */ -## repeat append groups (#list_id = @list_id, ltid = list.tid, #gid = @gid) -## where list.#list_id = @list_id -## repeat replace tbs (modtime = "now", appends = tbs.appends + 1) -## where tbs.table = "members" +static char *lflags[5] = { "active", "public", "hidden", "maillist", "group" }; - /* and we're done */ - return(SMS_SUCCESS); -##} +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)); +} - -/** - ** 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); -##} - -/** - ** 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); +##} - return(SMS_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 + + if (ingres_errno) return(mr_errcode); + return(MR_SUCCESS); ##} + + /* Validation Routines */ @@ -1627,16 +2810,17 @@ validate_row(q, argv, v) 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) @@ -1650,56 +2834,103 @@ 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; @@ -1708,18 +2939,46 @@ validate_id(argv, 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; namefield = vo->namefield; idfield = vo->idfield; -## retrieve (id = table.idfield) where table.namefield = name -## inquire_equel (rowcount = "rowcount") + + 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) @@ -1730,13 +2989,20 @@ 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); ##} validate_date(argv, vo) @@ -1751,30 +3017,71 @@ validate_date(argv, 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 */ @@ -1786,10 +3093,10 @@ validate_typedata(q, argv, vo) ##{ ## 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 */ @@ -1801,158 +3108,94 @@ validate_typedata(q, argv, vo) /* 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); ##} - -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") +/* Lock the table named by the validation object */ - } else if (!strcmp(data_type, "machine")) { - /* MACHINE */ -## repeat retrieve (name = machine.#name) where machine.mach_id = @id -## inquire_equel (rowcount = "rowcount") - - } 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() +##{ ##} - -/* - * 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: - */