X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/blobdiff_plain/1a41acb792a980288de240697cdb8f35713e0aaf..refs/heads/LOCKING:/server/qsupport.dc diff --git a/server/qsupport.dc b/server/qsupport.dc index afa2a4a5..038e92a3 100644 --- a/server/qsupport.dc +++ b/server/qsupport.dc @@ -1,4 +1,3 @@ -/* #define GDSS */ /* * $Source$ * $Author$ @@ -11,7 +10,7 @@ */ #ifndef lint -static char *rcsid_qsupport_qc = "$Header$"; +static char *rcsid_qsupport_dc = "$Header$"; #endif lint #include @@ -21,1739 +20,20 @@ static char *rcsid_qsupport_qc = "$Header$"; #ifdef GDSS #include "gdss.h" #endif /* GDSS */ +EXEC SQL INCLUDE sqlca; +EXEC SQL INCLUDE sqlda; +#include "qrtn.h" +extern char *whoami, *strsave(); +extern int ingres_errno, mr_errcode; -extern char *whoami, *strsave(); -extern int ingres_errno, mr_errcode; - -/* Specialized Access Routines */ - -/* 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; -{ - if (cl->users_id != *(int *)argv[0]) - return(MR_PERM); - else - return(MR_SUCCESS); -} - - - -/* 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 rowcount, id; -## char qual[256]; - - 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 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, acl_id, flags, rowcount, gid; -## char acl_type[9]; - char *client_type; - int client_id, status; - - list_id = *(int *)argv[0]; -## 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 */ - 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 (((!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 */ - status = find_member(acl_type, acl_id, client_type, client_id, 0); - if (!status) return(MR_PERM); - - return(MR_SUCCESS); -##} - - -/* 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, acl_id, flags, rowcount; -## char acl_type[9]; - char *client_type; - int client_id, status; - - list_id = *(int *)argv[0]; -## 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); -##} - - -/* 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 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); -##} - - -/* 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. - */ - -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)); - - if (!strcmp(argv[0], "USER") || !strcmp(argv[0], "RUSER")) { - if (cl->users_id == *(int *)argv[1]) - return(MR_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); -##} - - - -/* 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; - char *argv[]; - client *cl; -##{ -## int rowcount, users_id, list_id; -## char *name; - int status, client_id; - char *client_type; - - 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); -##} - - - -/* 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 row; -## int nuid, rowcount; - - if (!strcmp(q->shortname, "uusr") || !strcmp(q->shortname, "uuac")) - row = 2; - else - row = 1; - if (!strcmp(argv[row], UNIQUE_UID) || atoi(argv[row]) == -1) { - if (set_next_object_id("uid", "users", 1)) - 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[row], "%d", nuid); - } - - if (!strcmp(argv[0], UNIQUE_LOGIN) || atoi(argv[row]) == -1) { - sprintf(argv[0], "#%s", argv[row]); - } - - return(MR_SUCCESS); -##} - - -/* 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; -##{ -## 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); -##} - - -/* 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); -##} - - -/* 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); -##} - - -/* 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; -##{ -## 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); -##} - - -/* 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", 1)) - 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 - ** - ** Inputs: Add - ** argv[1] - type - ** argv[2] - mach_id - ** argv[3] - name - ** argv[5] - access - ** - ** Description: - ** - for type = RVD: - ** * 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: - ** MR_NFS - specified directory not exported - ** MR_FILESYS_ACCESS - invalid filesys access - ** - **/ - -##static int var_phys_id; - -setup_afil(q, argv) - struct query *q; - char *argv[]; -##{ - char *type, *name; - int mach_id; -## 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 (!strcmp(type, "NFS")) - return (check_nfs(mach_id, name, access)); - else - return(MR_SUCCESS); -##} - - -/* Verify the arguments, depending on the FStype. Also, if this is an - * NFS filesystem, then update any quotas for that filesystem to reflect - * the new phys_id. - */ - -setup_ufil(q, argv, cl) - struct query *q; - char *argv[]; - 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; -## delete quota where quota.type="ANY" and quota.filsys_id = fid -## 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); -##} - - -/* 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; -##{ -## char dir[81]; - char caccess; - register int status; - register char *cp1; - register char *cp2; - - status = MR_NFS; -## range of np is nfsphys -## 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) { - status = MR_SUCCESS; -## endretrieve - } -## } - if (ingres_errno) - return(mr_errcode); - return(status); -##} - - -/* setup_dfil: free any quota records and fsgroup info associated with - * a filesystem when it is deleted. Also adjust the allocation numbers. - */ - -setup_dfil(q, argv, cl) - struct query *q; - char **argv; - client *cl; -##{ -## int id; - - 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); -##} - - -/* setup_dnfp: check to see that the nfs physical partition does not have - * any filesystems assigned to it before allowing it to be deleted. - */ - -setup_dnfp(q, argv, cl) - struct query *q; - char **argv; - client *cl; -##{ -## int id, exists; -## char *dir; - - id = *(int *)argv[0]; - dir = argv[1]; -## repeat retrieve (exists = any(filesys.label where filesys.mach_id = @id -## and filesys.phys_id = nfsphys.nfsphys_id and -## nfsphys.mach_id = @id and nfsphys.#dir = @dir)) - if (exists) - return(MR_IN_USE); - if (ingres_errno) - return(mr_errcode); - return(MR_SUCCESS); -##} - - -/* 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 quota, fs, id; -## char *qtype; - - 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); -##} - - -/* 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; -##{ -## set lockmode session where readlock = system -##} - - -/* setup add_kerberos_user_mapping: add the string to the string - * table if necessary. - */ - -setup_akum(q, argv, cl) -struct query *q; -char **argv; -client *cl; -##{ -## int id, rowcount; -## char *name; - - 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); -##} - - - -/* FOLLOWUP ROUTINES */ - -/* 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_modtime(q, argv, cl) - struct query *q; - char *argv[]; - client *cl; -##{ -## char *name, *entity, *table; -## int who; - - entity = cl->entity; - who = cl->client_id; - table = q->rtable; - name = argv[0]; - -## replace table (modtime = "now", modby = who, modwith = entity) -## where table.#name = name - return(MR_SUCCESS); -##} - -/* 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_modtime_by_id(q, argv, cl) - struct query *q; - char **argv; - client *cl; -##{ -## char *entity, *table, *id_name; -## int who, id; - - entity = cl->entity; - who = cl->client_id; - table = q->rtable; - id_name = q->validate->object_id; - - id = *(int *)argv[0]; -## replace table (modtime = "now", modby = who, modwith = entity) -## where table.id_name = id - return(MR_SUCCESS); -##} - - -/* 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, who; -## char *entity; - - entity = cl->entity; - who = cl->client_id; - users_id = *(int *)argv[0]; - -## repeat replace u (fmodtime = "now", fmodby = @who, fmodwith = @entity) -## where u.#users_id = @users_id - return(MR_SUCCESS); -##} - - -/* 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]; - -## repeat replace users (pmodtime = "now", pmodby = @who, pmodwith = @entity) -## where users.#users_id = @users_id - return(MR_SUCCESS); -##} - - -/* Like set_modtime, but uppercases the name first. - */ - -set_uppercase_modtime(q, argv, cl) - struct query *q; - char **argv; - client *cl; -##{ -## char *name, *entity, *table; -## int who; - - entity = cl->entity; - who = cl->client_id; - table = q->rtable; - name = argv[0]; - -## replace table (modtime = "now", modby = who, modwith = entity) -## where table.#name = uppercase(name) - return(MR_SUCCESS); -##} - - -/* 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; - char **argv; - client *cl; -##{ -## char *entity; -## int who, id; - - entity = cl->entity; - who = cl->client_id; - - id = *(int *)argv[0]; -## repeat replace machine (modtime = "now", modby = @who, modwith = @entity) -## where machine.mach_id = @id - return(MR_SUCCESS); -##} - - -/* 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; - client *cl; -##{ -## char *entity; -## int who, id; - - entity = cl->entity; - who = cl->client_id; - - id = *(int *)argv[0]; -## repeat replace cluster (modtime = "now", modby = @who, modwith = @entity) -## where cluster.clu_id = @id - return(MR_SUCCESS); -##} - - -/* 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; - client *cl; -##{ -## char *entity, *serv; -## int who, id; - - entity = cl->entity; - who = cl->client_id; - - 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); -##} - - -/* 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; - client *cl; -##{ -## 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); -##} - - -/* 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; -##{ -## 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); -##} - - -/* sets the modtime on a zephyr class, where argv[0] contains the class - * name. - */ - -set_zephyr_modtime(q, argv, cl) - struct query *q; - char *argv[]; - client *cl; -##{ -## char *class, *entity; -## int who; - - entity = cl->entity; - who = cl->client_id; - - class = argv[0]; - -## 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); -} - - -/* After retrieving a user account, fix the modby field and signature. - * The modby field is 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. Only "gua*" queries have a signature, - * these are ones tieh U_END return values. "gub*" queries also use this - * routine but don't have a signature. - */ -followup_guax(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(); -#ifdef GDSS - char sigbuf[256], *rawsig, *kname; - SigInfo si; -#endif /* GDSS */ - 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); -#ifdef GDSS - if (q->vcnt == U_END) { - com_err(whoami, 0, "compressing signature"); - rawsig = argv[U_SIGNATURE]; - bcopy(&rawsig[0], &id, sizeof(int)); - id = ntohl(id); - status = id_to_name(id, "STRING", &kname); - bcopy(&rawsig[4], &si.timestamp, sizeof(int)); - si.timestamp = ntohl(si.timestamp); - si.SigInfoVersion = 0; /* XXXXX this isn't used */ - kname_parse(si.pname, si.pinst, si.prealm, kname); - si.rawsig = (unsigned char *)&rawsig[8]; - GDSS_Recompose(&si, sigbuf); - argv[U_SIGNATURE] = strsave(sigbuf); - } -#endif /* GDSS */ - (*action)(q->vcnt, argv, actarg); - for (j = 0; j < q->vcnt; j++) - free(argv[j]); - free(argv); - } - sq_destroy(sq); - return(MR_SUCCESS); -} - - -/** - ** followup_ausr - add finger and pobox entries, set_user_modtime - ** - ** Inputs: - ** argv[0] - login (add_user) - ** argv[3] - last name - ** argv[4] - first name - ** argv[5] - middle name - ** - **/ - -followup_ausr(q, argv, cl) - struct query *q; - char *argv[]; - client *cl; -##{ -## int who, status, sigwho, id; -## char *login, *entity, *src, *dst, *name; -## char fullname[129]; -#ifdef GDSS - char databuf[32], *kname_unparse(); -## char rawsig[128]; - SigInfo si; -#endif /* GDSS */ - - /* 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]); - -#ifdef GDSS - sprintf(databuf, "%s:%s", argv[U_NAME], argv[U_MITID]); - /* skip bytes for timestamp & kname */ - si.rawsig = (unsigned char *)&rawsig[8]; - status = GDSS_Verify(databuf, strlen(databuf), argv[U_SIGNATURE], &si); - if (status == 0) { - name = kname_unparse(si.pname, si.pinst, si.prealm); - status = name_to_id(name, "STRING", &sigwho); - if (status == MR_NO_MATCH) { -## repeat retrieve (sigwho = values.value) -## where values.name = "strings_id" - sigwho++; -## repeat replace values (value = @sigwho) -## where values.name = "strings_id" -## append to strings (string_id = sigwho, string = name) - } else if (status) - return(status); - sigwho = htonl(sigwho); - bcopy(&sigwho, &rawsig[0], sizeof(int)); - si.timestamp = htonl(si.timestamp); - bcopy(&si.timestamp, &rawsig[4], sizeof(int)); - } else - return(status); -#endif /* GDSS */ - - login = argv[0]; - who = cl->client_id; - entity = cl->entity; - - /* create finger entry, pobox & set modtime on user */ -#ifdef GDSS -## repeat replace u (modtime = "now", modby=@who, modwith=@entity, -## #fullname=@fullname, mit_affil = u.mit_year, -## signature=@rawsig, -## fmodtime="now", fmodby=@who, fmodwith=@entity, -## potype="NONE", pmodtime="now", pmodby=@who, pmodwith=@entity) -## where u.#login = @login -#else /* GDSS */ -## 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 -#endif /* GDSS */ - - 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[4]); - free(argv); - } - - sq_destroy(sq); - return (MR_SUCCESS); -} - - -/* followup_glin: fix the ace_name in argv[8]. argv[7] will contain the - * ace_type: "LIST", "USER", or "NONE". Decode the id in argv[8] into the - * proper name based on the type, and repace that string in the argv. - * Also fixes the modby field by called followup_fix_modby. - */ - -followup_glin(q, sq, v, action, actarg, cl) - register struct query *q; - register struct save_queue *sq; - register struct validate *v; - register int (*action)(); - int actarg; - client *cl; -{ - char **argv, *malloc(), *realloc(), *type; - int id, i, idx, status; - - idx = 8; - if (!strcmp(q->shortname, "gsin")) - idx = 12; - - while (sq_get_data(sq, &argv)) { - mr_trim_args(q->vcnt, argv); - - id = atoi(argv[i = q->vcnt - 2]); - if (id > 0) - status = id_to_name(id, "USER", &argv[i]); - else - status = id_to_name(-id, "STRING", &argv[i]); - if (status && status != MR_NO_MATCH) - return(status); - - id = atoi(argv[idx]); - type = argv[idx - 1]; - - if (!strcmp(type, "LIST")) { - status = id_to_name(id, "LIST", &argv[idx]); - } else if (!strcmp(type, "USER")) { - status = id_to_name(id, "USER", &argv[idx]); - } else if (!strcmp(type, "KERBEROS")) { - status = id_to_name(id, "STRING", &argv[idx]); - } else if (!strcmp(type, "NONE")) { - status = 0; - free(argv[idx]); - argv[idx] = strsave("NONE"); - } else { - status = 0; - free(argv[idx]); - argv[idx] = strsave("???"); - } - if (status && status != MR_NO_MATCH) - return(status); - - if (!strcmp(q->shortname, "glin") && atoi(argv[6]) == -1) { - argv[6] = realloc(argv[6], strlen(UNIQUE_GID) + 1); - strcpy(argv[6], UNIQUE_GID); - } - - /* send the data */ - (*action)(q->vcnt, argv, actarg); - - /* free saved data */ - for (i = 0; i < q->vcnt; i++) - free(argv[i]); - free(argv); - } - - sq_destroy(sq); - return (MR_SUCCESS); -} - - -/* followup_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; - register struct save_queue *sq; - struct validate *v; - 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; - 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); -##} - - -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)) { - 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(MR_SUCCESS); -} - - -/* followup_gsha: - */ - -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; - - 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); - - /* send the data */ - (*action)(q->vcnt, argv, actarg); +EXEC SQL BEGIN DECLARE SECTION; +extern char stmt_buf[]; +EXEC SQL END DECLARE SECTION; - /* free saved data */ - for (i = 0; i < q->vcnt; i++) - free(argv[i]); - free(argv); - } - sq_destroy(sq); - return(MR_SUCCESS); -} +EXEC SQL WHENEVER SQLERROR CALL ingerr; - /* Special query routines */ /* set_pobox - this does all of the real work. @@ -1767,16 +47,18 @@ int set_pobox(q, argv, cl) struct query *q; char **argv; client *cl; -##{ -## int user, id, rowcount; -## char *box, potype[9]; +{ + EXEC SQL BEGIN DECLARE SECTION; + int user, id; + char *box, potype[9]; + EXEC SQL END DECLARE SECTION; int status; box = argv[2]; user = *(int *)argv[0]; -## repeat retrieve (id = users.pop_id, potype = users.#potype) -## where users.users_id = @user + EXEC SQL REPEATED SELECT pop_id, potype INTO :id, :potype FROM users + WHERE users_id = :user; if (ingres_errno) return(mr_errcode); if (!strcmp(strtrim(potype), "POP")) set_pop_usage(id, -1); @@ -1787,32 +69,30 @@ int set_pobox(q, argv, cl) return(MR_MACHINE); else if (status) return(status); -## repeat replace users (#potype = "POP", pop_id = @id) -## where users.users_id = @user + EXEC SQL REPEATED UPDATE users SET potype = 'POP', pop_id = :id + WHERE 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) + id=add_string(box); } else if (status) return(status); -## repeat replace users (#potype = "SMTP", box_id = @id) -## where users.users_id = @user + EXEC SQL REPEATED UPDATE users SET potype='SMTP', box_id = :id + WHERE users_id = :user; } else /* argv[1] == "NONE" */ { -## repeat replace users (#potype = "NONE") where users.users_id = @user + EXEC SQL REPEATED UPDATE users SET potype='NONE' + WHERE users_id = :user; } set_pobox_modtime(q, argv, cl); -## repeat replace tblstats (updates = tblstats.updates + 1, modtime = "now") -## where tblstats.#table = "users" + EXEC SQL REPEATED UPDATE tblstats SET updates = updates+1, modtime='now' + WHERE table_name='users'; if (ingres_errno) return(mr_errcode); return(MR_SUCCESS); -##} +} /* get_list_info: passed a wildcard list name, returns lots of stuff about @@ -1826,47 +106,64 @@ get_list_info(q, aargv, cl, action, actarg) client *cl; register int (*action)(); int actarg; -##{ - 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; +{ + char *argv[13]; + EXEC SQL BEGIN DECLARE SECTION; + char *name, acl_type[9], listname[33], active[5], public[5], hidden[5]; + char maillist[5], grouplist[5], gid_str[6], acl_name[256], desc[256]; + char modtime[27], modby[256], modwith[9]; + int id, rowcount, acl_id, hid, modby_id; + char qual[80]; + EXEC SQL END DECLARE SECTION; int returned, status; struct save_queue *sq, *sq_create(); returned = rowcount = 0; name = aargv[0]; + convert_wildcards(name); sq = sq_create(); -## range of l is list -## repeat retrieve (id = l.list_id) where l.#name = @name { + sprintf(qual,"name LIKE '%s' ESCAPE '*'",name); + optimize_sql_stmt(qual); + EXEC SQL DECLARE csr102 CURSOR FOR SELECT list_id FROM list + WHERE :qual; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr102; + if (ingres_errno) + return(mr_errcode); + while(1) + { + EXEC SQL FETCH csr102 INTO :id; + if(sqlca.sqlcode!=0) break; sq_save_data(sq, id); - rowcount++; -## } + rowcount++; + } + EXEC SQL CLOSE csr102; + 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; + argv[4] = maillist; argv[5] = grouplist; argv[6] = gid_str; + 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 + argv[6] = gid_str; + EXEC SQL REPEATED SELECT name, CHAR(active), CHAR(publicflg), + CHAR(hidden), hidden, CHAR(maillist), CHAR(grouplist), CHAR(gid), + TRIM(acl_type), acl_id, description, CHAR(modtime), modby, modwith + INTO :listname, :active, :public, :hidden, :hid, :maillist, + :grouplist, :gid_str, :acl_type, :acl_id, :desc, + :modtime, :modby_id, :modwith + FROM list WHERE list_id = :id; + if (ingres_errno) return(mr_errcode); - if (atoi(gid) == -1) + if (atoi(gid_str) == -1) argv[6] = UNIQUE_GID; argv[8] = malloc(0); @@ -1904,7 +201,7 @@ get_list_info(q, aargv, cl, action, actarg) sq_destroy(sq); if (ingres_errno) return(mr_errcode); return (MR_SUCCESS); -##} +} /* Add_member_to_list: do list flattening as we go! MAXLISTDEPTH is @@ -1917,24 +214,25 @@ int add_member_to_list(q, argv, cl) struct query *q; char **argv; client *cl; -##{ -## int id, lid, mid, exists, error, who, ref; -## char *mtype, dtype[9], *entity; +{ + EXEC SQL BEGIN DECLARE SECTION; + int id, lid, mid, error, who, ref, rowcnt; + char *mtype, dtype[9], *entity; + EXEC SQL END DECLARE SECTION; 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) + EXEC SQL REPEATED SELECT COUNT(list_id) INTO :rowcnt FROM imembers + WHERE list_id = :lid AND member_id = :mid + AND member_type = :mtype AND direct = 1; + if (rowcnt > 0) return(MR_EXISTS); if (!strcasecmp(mtype, "STRING")) { buf = malloc(0); @@ -1950,14 +248,22 @@ int add_member_to_list(q, argv, cl) 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" { + EXEC SQL DECLARE csr103 CURSOR FOR + SELECT list_id, ref_count FROM imembers + WHERE member_id = :lid AND member_type='LIST'; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr103; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr103 INTO :id, :ref; + if(sqlca.sqlcode != 0) break; aref[acount] = ref; ancestors[acount++] = id; - if (acount >= MAXLISTDEPTH) { -## endretrieve - } -## } + if (acount >= MAXLISTDEPTH) break; + } + EXEC SQL CLOSE csr103; if (ingres_errno) return(mr_errcode); if (acount >= MAXLISTDEPTH) { return(MR_INTERNAL); @@ -1968,9 +274,18 @@ int add_member_to_list(q, argv, cl) 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 { + EXEC SQL DECLARE csr104 CURSOR FOR + SELECT member_id, member_type, ref_count + FROM imembers + WHERE list_id = :mid; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr104; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr104 INTO :id, :dtype, :ref; + if(sqlca.sqlcode != 0) break; switch (dtype[0]) { case 'L': dtypes[dcount] = "LIST"; @@ -1986,15 +301,16 @@ int add_member_to_list(q, argv, cl) break; default: error++; -## endretrieve + break; } dref[dcount] = ref; descendants[dcount++] = id; if (dcount >= MAXLISTDEPTH) { error++; -## endretrieve + break; } -## } + } + EXEC SQL CLOSE csr104; if (ingres_errno) return(mr_errcode); if (error) return(MR_INTERNAL); @@ -2007,27 +323,34 @@ int add_member_to_list(q, argv, cl) 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)) + EXEC SQL REPEATED SELECT COUNT(ref_count) INTO :rowcnt + FROM imembers + WHERE list_id = :lid AND member_id = :mid + AND 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 + if (rowcnt > 0) { + if (a == 0 && d == 0) { + EXEC SQL UPDATE imembers + SET ref_count = ref_count+:ref, direct=1 + WHERE list_id = :lid AND member_id = :mid + AND member_type = :mtype; + } else { + EXEC SQL UPDATE imembers + SET ref_count = ref_count+:ref + WHERE list_id = :lid AND member_id = :mid + AND 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) + if (a == 0 && d == 0) { + EXEC SQL INSERT INTO imembers + (list_id, member_id, direct, member_type, ref_count) + VALUES (:lid, :mid, 1, :mtype, 1); + } else { + EXEC SQL INSERT INTO imembers + (list_id, member_id, member_type, ref_count) + VALUES (:lid, :mid, :mtype, 1); + } iargv[0] = (char *)lid; iargv[1] = mtype; iargv[2] = (char *)mid; @@ -2038,11 +361,12 @@ int add_member_to_list(q, argv, cl) 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 + EXEC SQL REPEATED UPDATE list + SET modtime='now', modby = :who, modwith = :entity + WHERE list_id = :lid; if (ingres_errno) return(mr_errcode); return(MR_SUCCESS); -##} +} /* Delete_member_from_list: do list flattening as we go! @@ -2052,36 +376,47 @@ 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; +{ + EXEC SQL BEGIN DECLARE SECTION; + int id, lid, mid, cnt, error, who, ref; + char *mtype, dtype[9], *entity; + EXEC SQL END DECLARE SECTION; 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)) + EXEC SQL REPEATED SELECT COUNT(list_id) INTO :cnt FROM imembers + WHERE list_id = :lid AND member_id = :mid + AND member_type = :mtype AND direct = 1; if (ingres_errno) return(mr_errcode); - if (!exists) + if (cnt == 0) 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" { + EXEC SQL DECLARE csr105 CURSOR FOR + SELECT list_id, ref_count FROM imembers + WHERE member_id = :lid AND member_type = 'LIST'; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr105; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr105 INTO :id, :ref; + if(sqlca.sqlcode!=0) break; aref[acount] = ref; ancestors[acount++] = id; - if (acount >= MAXLISTDEPTH) -## endretrieve -## } - if (ingres_errno) return(mr_errcode); + if (acount >= MAXLISTDEPTH) break; + } + EXEC SQL CLOSE csr105; + if (ingres_errno) + return(mr_errcode); if (acount >= MAXLISTDEPTH) return(MR_INTERNAL); descendants[0] = mid; @@ -2090,9 +425,17 @@ int delete_member_from_list(q, argv, cl) 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 { + EXEC SQL DECLARE csr106 CURSOR FOR + SELECT member_id, member_type, ref_count FROM imembers + WHERE list_id = :mid; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr106; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr106 INTO :id, :dtype, :ref; + if(sqlca.sqlcode!=0) break; switch (dtype[0]) { case 'L': dtypes[dcount] = "LIST"; @@ -2108,14 +451,15 @@ int delete_member_from_list(q, argv, cl) break; default: error++; -## endretrieve + break; } dref[dcount] = ref; descendants[dcount++] = id; - if (dcount >= MAXLISTDEPTH) -## endretrieve -## } - if (ingres_errno) return(mr_errcode); + if (dcount >= MAXLISTDEPTH) break; + } + EXEC SQL CLOSE csr106; + if (ingres_errno) + return(mr_errcode); if (error) return(MR_INTERNAL); } @@ -2127,37 +471,39 @@ int delete_member_from_list(q, argv, cl) 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 + EXEC SQL REPEATED SELECT ref_count INTO :cnt FROM imembers + WHERE list_id = :lid AND member_id = :mid AND 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 + EXEC SQL DELETE FROM imembers + WHERE list_id = :lid AND member_id = :mid + AND 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 + EXEC SQL UPDATE imembers + SET ref_count = ref_count - :ref, direct = 0 + WHERE list_id = :lid AND member_id = :mid + AND 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 + EXEC SQL UPDATE imembers + SET ref_count = ref_count - :ref + WHERE list_id = :lid AND member_id = :mid + AND 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 + EXEC SQL UPDATE list SET modtime = 'now', modby = :who, modwith = :entity + WHERE list_id = :lid; if (ingres_errno) return(mr_errcode); return(MR_SUCCESS); -##} +} /* get_ace_use - given a type and a name, return a type and a name. @@ -2174,13 +520,14 @@ int get_ace_use(q, argv, cl, action, actarg) client *cl; int (*action)(); int actarg; -##{ +{ int found = 0; -## char *atype; -## int aid, listid, id; + EXEC SQL BEGIN DECLARE SECTION; + char *atype; + int aid, listid, id; + EXEC SQL END DECLARE SECTION; 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") || @@ -2192,10 +539,20 @@ int get_ace_use(q, argv, cl, action, actarg) 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 = @aid { + EXEC SQL DECLARE csr107 CURSOR FOR + SELECT list_id FROM imembers + WHERE member_type='LIST' AND member_id = :aid; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr107; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr107 INTO :listid; + if(sqlca.sqlcode != 0) break; sq_save_unique_data(sq, listid); -## } + } + EXEC SQL CLOSE csr107; /* now process each one */ while (sq_get_data(sq, &id)) { if (get_ace_internal("LIST", id, action, actarg) == MR_SUCCESS) @@ -2204,10 +561,20 @@ int get_ace_use(q, argv, cl, action, actarg) } if (!strcmp(atype, "RUSER")) { -## repeat retrieve (listid = m.list_id) -## where m.member_type = "USER" and m.member_id = @aid { + EXEC SQL DECLARE csr108 CURSOR FOR + SELECT list_id FROM imembers + WHERE member_type='USER' AND member_id = :aid; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr108; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr108 INTO :listid; + if(sqlca.sqlcode != 0) break; sq_save_data(sq, listid); -## } + } + EXEC SQL CLOSE csr108; /* now process each one */ while (sq_get_data(sq, &id)) { if (get_ace_internal("LIST", id, action, actarg) == MR_SUCCESS) @@ -2218,10 +585,20 @@ int get_ace_use(q, argv, cl, action, actarg) } if (!strcmp(atype, "RKERBERO")) { -## repeat retrieve (listid = m.list_id) -## where m.member_type = "KERBEROS" and m.member_id = @aid { + EXEC SQL DECLARE csr109 CURSOR FOR + SELECT list_id FROM imembers + WHERE member_type='KERBEROS' AND member_id = :aid; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr109; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr109 INTO :listid; + if(sqlca.sqlcode != 0) break; sq_save_data(sq, listid); -## } + } + EXEC SQL CLOSE csr109; /* now process each one */ while (sq_get_data(sq, &id)) { if (get_ace_internal("LIST", id, action, actarg) == MR_SUCCESS) @@ -2231,11 +608,11 @@ int get_ace_use(q, argv, cl, action, actarg) found++; } - sq_destroy(sq); + sq_destroy(sq); if (ingres_errno) return(mr_errcode); if (!found) return(MR_NO_MATCH); return(MR_SUCCESS); -##} +} /* This looks up a single list or user for ace use. atype must be "USER" @@ -2243,74 +620,149 @@ int get_ace_use(q, argv, cl, action, actarg) * by get_ace_use above. */ -##get_ace_internal(atype, aid, action, actarg) -## char *atype; -## int aid; +get_ace_internal(atype, aid, action, actarg) + EXEC SQL BEGIN DECLARE SECTION; + char *atype; + int aid; + EXEC SQL END DECLARE SECTION; int (*action)(); int actarg; -##{ +{ char *rargv[2]; int found = 0; -## char name[33]; + EXEC SQL BEGIN DECLARE SECTION; + char name[33]; + EXEC SQL END DECLARE SECTION; rargv[1] = name; if (!strcmp(atype, "LIST")) { rargv[0] = "FILESYS"; -## repeat retrieve (name = filesys.label) -## where filesys.owners = @aid { + EXEC SQL DECLARE csr110 CURSOR FOR + SELECT label FROM filesys + WHERE owners = :aid; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr110; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr110 INTO :name; + if(sqlca.sqlcode != 0) break; (*action)(2, rargv, actarg); found++; -## } + } + EXEC SQL CLOSE csr110; rargv[0] = "QUERY"; -## repeat retrieve (name = capacls.capability) -## where capacls.list_id = @aid { + EXEC SQL DECLARE csr111 CURSOR FOR + SELECT capability FROM capacls + WHERE list_id = :aid ; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr111; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr111 INTO :name ; + if(sqlca.sqlcode != 0) break; (*action)(2, rargv, actarg); found++; -## } + } + EXEC SQL CLOSE csr111; } else if (!strcmp(atype, "USER")) { rargv[0] = "FILESYS"; -## repeat retrieve (name = filesys.label) -## where filesys.owner = @aid { + EXEC SQL DECLARE csr112 CURSOR FOR + SELECT label FROM filesys + WHERE owner = :aid; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr112; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr112 INTO :name ; + if(sqlca.sqlcode != 0) break; (*action)(2, rargv, actarg); found++; -## } + } + EXEC SQL CLOSE csr112; } rargv[0] = "LIST"; -## repeat retrieve (name = list.#name) -## where list.acl_type = @atype and list.acl_id = @aid { - (*action)(2, rargv, actarg); - found++; -## } + EXEC SQL DECLARE csr113 CURSOR FOR + SELECT name FROM list + WHERE acl_type = :atype AND acl_id = :aid; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr113; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr113 INTO :name; + if(sqlca.sqlcode != 0) break; + (*action)(2, rargv, actarg); + found++; + } + EXEC SQL CLOSE csr113; rargv[0] = "SERVICE"; -## repeat retrieve (name = servers.#name) -## where servers.acl_type = @atype and servers.acl_id = @aid { - (*action)(2, rargv, actarg); - found++; -## } + EXEC SQL DECLARE csr114 CURSOR FOR + SELECT name FROM servers + WHERE acl_type = :atype AND acl_id = :aid; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr114; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr114 INTO :name; + if(sqlca.sqlcode != 0) break; + (*action)(2, rargv, actarg); + found++; + } + EXEC SQL CLOSE csr114; 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 { + EXEC SQL DECLARE csr115 CURSOR FOR + SELECT name FROM machine m, hostaccess ha + WHERE m.mach_id = ha.mach_id AND ha.acl_type = :atype + AND ha.acl_id = :aid; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr115; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr115 INTO :name; + if(sqlca.sqlcode != 0) break; (*action)(2, rargv, actarg); found++; -## } + } + EXEC SQL CLOSE csr115; + 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++; -## } + EXEC SQL DECLARE csr116 CURSOR FOR + SELECT class FROM zephyr z + WHERE z.xmt_type = :atype AND z.xmt_id = :aid + OR z.sub_type = :atype AND z.sub_id = :aid + OR z.iws_type = :atype AND z.iws_id = :aid + OR z.iui_type = :atype AND z.iui_id = :aid; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr116; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr116 INTO :name; + if(sqlca.sqlcode != 0) break; + (*action)(2, rargv, actarg); + found++; + } + EXEC SQL CLOSE csr116; if (!found) return(MR_NO_MATCH); return(MR_SUCCESS); -##} +} /* get_lists_of_member - given a type and a name, return the name and flags @@ -2327,12 +779,14 @@ int get_lists_of_member(q, argv, cl, action, actarg) client *cl; int (*action)(); int actarg; -##{ +{ 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]; + EXEC SQL BEGIN DECLARE SECTION; + char *atype; + int aid, listid, id; + char name[33], active[5], public[5], hidden[5], maillist[5], grouplist[5]; + EXEC SQL END DECLARE SECTION; atype = argv[0]; aid = *(int *)argv[1]; @@ -2358,32 +812,53 @@ int get_lists_of_member(q, argv, cl, action, actarg) rargv[2] = public; rargv[3] = hidden; rargv[4] = maillist; - rargv[5] = group; -## range of m is imembers + rargv[5] = grouplist; 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++; -## } + EXEC SQL DECLARE csr117a CURSOR FOR + SELECT l.name, CHAR(l.active), CHAR(l.publicflg), CHAR(l.hidden), + CHAR(l.maillist), CHAR(l.grouplist) + FROM list l, imembers im + WHERE l.list_id = im.list_id AND im.direct = 1 + AND im.member_type = :atype AND im.member_id = :aid; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr117a; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr117a + INTO :name, :active, :public, :hidden, :maillist, :grouplist; + if(sqlca.sqlcode != 0) break; + (*action)(6, rargv, actarg); + found++; + } + EXEC SQL CLOSE csr117a; } 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++; -## } + EXEC SQL DECLARE csr117b CURSOR FOR + SELECT l.name, CHAR(l.active), CHAR(l.publicflg), CHAR(l.hidden), + CHAR(l.maillist), CHAR(l.grouplist) + FROM list l, imembers im + WHERE l.list_id = im.list_id + AND im.member_type = :atype AND im.member_id = :aid; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr117b; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr117b + INTO :name, :active, :public, :hidden, :maillist, :grouplist; + if(sqlca.sqlcode != 0) break; + (*action)(6, rargv, actarg); + found++; + } + EXEC SQL CLOSE csr117b; } if (ingres_errno) return(mr_errcode); if (!found) return(MR_NO_MATCH); return(MR_SUCCESS); -##} +} /* qualified_get_lists: passed "TRUE", "FALSE", or "DONTCARE" for each of @@ -2392,7 +867,7 @@ int get_lists_of_member(q, argv, cl, action, actarg) * where clause based on the arguments, then doing a retrieve. */ -static char *lflags[5] = { "active", "public", "hidden", "maillist", "group" }; +static char *lflags[5] = { "active", "publicflg", "hidden", "maillist", "grouplist" }; int qualified_get_lists(q, argv, cl, action, actarg) struct query *q; @@ -2406,7 +881,32 @@ int qualified_get_lists(q, argv, cl, action, actarg) } -/** get_members_of_list - optimized query for retrieval of list members +/* get_members_of_list - this gets only direct members */ + +get_members_of_list(q, argv, cl, action, actarg) + struct query *q; + char *argv[]; + client *cl; + int (*action)(); + int actarg; +{ + return(gmol_internal(q, argv, cl, action, actarg, 1)); +} + +/* get_end_members_of_list - this gets direct or indirect members */ + +get_end_members_of_list(q, argv, cl, action, actarg) + struct query *q; + char *argv[]; + client *cl; + int (*action)(); + int actarg; +{ + return(gmol_internal(q, argv, cl, action, actarg, 0)); +} + +/** gmol_internal - optimized query for retrieval of list members + ** used by both get_members_of_list and get_end_members_of_list ** ** Inputs: ** argv[0] - list_id @@ -2415,30 +915,49 @@ int qualified_get_lists(q, argv, cl, action, actarg) ** - retrieve USER members, then LIST members, then STRING members **/ -get_members_of_list(q, argv, cl, action, actarg) +gmol_internal(q, argv, cl, action, actarg, flag) struct query *q; char *argv[]; client *cl; int (*action)(); int actarg; -##{ -## int list_id, member_id; -## char member_name[129], member_type[9]; + int flag; +{ + EXEC SQL BEGIN DECLARE SECTION; + int list_id, member_id, direct; + char member_name[129], member_type[9]; + EXEC SQL END DECLARE SECTION; char *targv[2]; int members; struct save_queue *sq; + /* true/false flag indicates whether to display only direct members. */ + if (flag) + direct = 0; + else + direct = -1; + list_id = *(int *)argv[0]; 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)); -## } + EXEC SQL DECLARE csr118 CURSOR FOR + SELECT member_type, member_id FROM imembers + WHERE list_id = :list_id AND direct > :direct; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr118; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr118 INTO :member_type, :member_id; + if (sqlca.sqlcode != 0) break; + if (members++ > 49) + break; + sq_save_data(sq, ((int)member_type[0] << 24) | (member_id & 0xffffff)); + } + EXEC SQL CLOSE csr118; + if (members <= 49) { targv[1] = malloc(0); while (sq_remove_data(sq, &member_id)) { @@ -2476,48 +995,84 @@ get_members_of_list(q, argv, cl, action, actarg) 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 and m.direct = 1 -## sort by #member_name -## { - (*action)(2, targv, actarg); -## } + EXEC SQL DECLARE csr119 CURSOR FOR + SELECT u.login FROM users u, imembers im + WHERE im.list_id = :list_id AND im.member_type = 'USER' + AND im.member_id = u.users_id AND im.direct > :direct + ORDER BY 1; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr119; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr119 INTO :member_name; + if(sqlca.sqlcode != 0) break; + (*action)(2, targv, actarg); + } + EXEC SQL CLOSE csr119; 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 and m.direct = 1 -## sort by #member_name -## { - (*action)(2, targv, actarg); -## } + EXEC SQL DECLARE csr120 CURSOR FOR + SELECT l.name FROM list l, imembers im + WHERE im.list_id = :list_id AND im.member_type='LIST' + AND im.member_id = l.list_id AND im.direct > :direct + ORDER BY 1; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr120; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr120 INTO :member_name; + if(sqlca.sqlcode != 0) break; + (*action)(2, targv, actarg); + } + EXEC SQL CLOSE csr120; 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 and m.direct = 1 -## sort by #member_name -## { - (*action)(2, targv, actarg); -## } + EXEC SQL DECLARE csr121 CURSOR FOR + SELECT CHAR(str.string) FROM strings str, imembers im + WHERE im.list_id = :list_id AND im.member_type='STRING' + AND im.member_id = str.string_id AND im.direct > :direct + ORDER BY 1; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr121; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr121 INTO :member_name; + if(sqlca.sqlcode != 0) break; + (*action)(2, targv, actarg); + } + EXEC SQL CLOSE csr121; 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); -## } + EXEC SQL DECLARE csr122 CURSOR FOR + SELECT CHAR(str.string) FROM strings str, imembers im + WHERE im.list_id = :list_id AND im.member_type='KERBEROS' + AND im.member_id = str.string_id + AND im.direct > :direct + ORDER BY 1; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr122; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr122 INTO :member_name; + if(sqlca.sqlcode != 0) break; + (*action)(2, targv, actarg); + } + EXEC SQL CLOSE csr122; if (ingres_errno) return(mr_errcode); return(MR_SUCCESS); -##} +} /* count_members_of_list: this is a simple query, but it cannot be done @@ -2530,20 +1085,21 @@ int count_members_of_list(q, argv, cl, action, actarg) client *cl; int (*action)(); int actarg; -##{ -## int list, ct = 0; +{ + EXEC SQL BEGIN DECLARE SECTION; + int list, ct = 0; + EXEC SQL END DECLARE SECTION; 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)) + EXEC SQL REPEATED SELECT count (*) INTO :ct FROM imembers + WHERE list_id = :list AND direct=1; if (ingres_errno) return(mr_errcode); sprintf(countbuf, "%d", ct); (*action)(1, rargv, actarg); return(MR_SUCCESS); -##} +} /* qualified_get_server: passed "TRUE", "FALSE", or "DONTCARE" for each of @@ -2561,7 +1117,7 @@ int qualified_get_server(q, argv, cl, action, actarg) int (*action)(); int actarg; { - return(qualified_get(q, argv, action, actarg, "s.name != \"\"", + return(qualified_get(q, argv, action, actarg, "s.name != ''", "s", "name", sflags)); } @@ -2584,41 +1140,46 @@ int qualified_get(q, argv, action, actarg, start, range, field, flags) char *range; char *field; char *flags[]; -##{ -## char name[33], qual[256], *rvar, *rtbl, *rfield; +{ + char name[33], qual[256]; + int rowcount=0, i; 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]); + 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]); + 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 { + + rargv[0] = SQLDA->sqlvar[0].sqldata; + sprintf(stmt_buf,"SELECT CHAR(%s.%s) FROM %s %s WHERE %s",range,field,q->rtable,range,qual); + EXEC SQL PREPARE stmt INTO :SQLDA USING NAMES FROM :stmt_buf; + if(sqlca.sqlcode) + return(MR_INTERNAL); + EXEC SQL DECLARE csr123 CURSOR FOR stmt; + EXEC SQL OPEN csr123; + while(1) { + EXEC SQL FETCH csr123 USING DESCRIPTOR :SQLDA; + if(sqlca.sqlcode != 0) break; + rowcount++; (*action)(1, rargv, actarg); -## } + } + EXEC SQL CLOSE csr123; if (ingres_errno) return(mr_errcode); -## inquire_equel(rowcount = "rowcount") if (rowcount == 0) return(MR_NO_MATCH); return(MR_SUCCESS); -##} +} /* 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 + * each service and host that meets the quailifications. It does this by * building a where clause based on the arguments, then doing a retrieve. */ @@ -2631,41 +1192,54 @@ int qualified_get_serverhost(q, argv, cl, action, actarg) client *cl; int (*action)(); int actarg; -##{ -## char sname[33], mname[33], qual[256]; +{ + EXEC SQL BEGIN DECLARE SECTION; + char sname[33], mname[33], qual[256]; + EXEC SQL END DECLARE SECTION; char *rargv[2], buf[32]; -## int rowcount, i; + int i, rowcount; - sprintf(qual, "machine.mach_id = sh.mach_id and sh.service = uppercase(\"%s\")", + sprintf(qual, "m.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]); + 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]); + 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 { + EXEC SQL DECLARE csr124 CURSOR FOR + SELECT sh.service, m.name FROM serverhosts sh, machine m + WHERE :qual; + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr124; + if (ingres_errno) + return(mr_errcode); + while(1) { + EXEC SQL FETCH csr124 INTO :sname, :mname; + if(sqlca.sqlcode != 0) break; + rowcount++; (*action)(2, rargv, actarg); -## } + } + EXEC SQL CLOSE csr124; + if (ingres_errno) return(mr_errcode); -## inquire_equel(rowcount = "rowcount") if (rowcount == 0) return(MR_NO_MATCH); return(MR_SUCCESS); -##} +} /* 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, + * type for filesystem allocation (MR_FS_STUDENT, MR_FS_FACULTY, * MR_FS_STAFF, MR_FS_MISC). */ @@ -2673,12 +1247,14 @@ 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, ostatus, nstatus; +{ + EXEC SQL BEGIN DECLARE SECTION; + char *login, dir[65], *entity, directory[129], machname[33]; + int who, rowcount, mid, uid, users_id, flag, utype, nid, list_id, quota; + int size, alloc, pid, ostatus, nstatus, gidval, fsidval, npidval; + static int m_id = 0, def_quota = 0; + EXEC SQL END DECLARE SECTION; char buffer[256], *aargv[3]; - int maxsize; entity = cl->entity; who = cl->client_id; @@ -2687,42 +1263,52 @@ register_user(q, argv, cl) 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, ostatus = u.status) -## where u.#uid = @uid and (u.status = 0 or u.status = 5 or u.status = 6) -## inquire_equel(rowcount = "rowcount"); - if (rowcount == 0) + EXEC SQL REPEATED SELECT users_id, status INTO :users_id, :ostatus + FROM users + WHERE uid = :uid AND (status=0 OR status=5 OR status=6); + + if (sqlca.sqlerrd[2] == 0) return(MR_NO_MATCH); - if (rowcount > 1) + if (sqlca.sqlerrd[2] > 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)) + EXEC SQL REPEATED SELECT COUNT(login) INTO :rowcount FROM users + WHERE login = :login AND 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 (rowcount > 0) return(MR_IN_USE); + EXEC SQL REPEATED SELECT COUNT(name) INTO :rowcount FROM list + WHERE 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 (rowcount > 0) return(MR_IN_USE); + EXEC SQL REPEATED SELECT COUNT(label) INTO :rowcount FROM filesys + WHERE label = :login; if (ingres_errno) return(mr_errcode); - if (flag) return(MR_IN_USE); + if (rowcount > 0) return(MR_IN_USE); com_err(whoami, 0, "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); + EXEC SQL DECLARE csr130 CURSOR FOR + SELECT sh.mach_id, m.name FROM serverhosts sh, machine m + WHERE sh.service='POP' AND sh.mach_id=m.mach_id + AND sh.value2 - sh.value1 = + (SELECT MAX(value2 - value1) FROM serverhosts + WHERE service = 'POP'); + if (ingres_errno) + return(mr_errcode); + EXEC SQL OPEN csr130; + if (ingres_errno) + return(mr_errcode); + EXEC SQL FETCH csr130 INTO :mid, :machname; + if (sqlca.sqlerrd[2] == 0) { + EXEC SQL CLOSE csr130; + if (ingres_errno) return(mr_errcode); + return(MR_NO_POBOX); + } else { + EXEC SQL CLOSE csr130; + if (ingres_errno) return(mr_errcode); + } /* change login name, set pobox */ sprintf(buffer, "u.users_id = %d", users_id); @@ -2730,14 +1316,13 @@ register_user(q, argv, cl) nstatus = 2; if (ostatus == 5 || ostatus == 6) nstatus = 1; -## repeat replace u (#login = @login, status = @nstatus, 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"); + EXEC SQL REPEATED UPDATE users SET login = :login, status = :nstatus, + modtime='now', modby = :who, modwith = :entity, potype='POP', + pop_id = :mid, pmodtime='now', pmodby = :who, pmodwith = :entity + WHERE users_id = :users_id; + if (ingres_errno) return(mr_errcode); - if (rowcount != 1) + if (sqlca.sqlerrd[2] != 1) return(MR_INTERNAL); set_pop_usage(mid, 1); com_err(whoami, 0, "set login name to %s and pobox to %s", login, @@ -2749,21 +1334,22 @@ register_user(q, argv, cl) return(MR_NO_ID); if (set_next_object_id("list_id", "list", 0)) return(MR_NO_ID); -## repeat retrieve (list_id = values.value) where values.name = "list_id" + EXEC SQL REPEATED SELECT value INTO :list_id FROM numvalues + WHERE name='list_id'; if (ingres_errno) return(mr_errcode); -## inquire_equel(rowcount = "rowcount"); - if (rowcount != 1) + if (sqlca.sqlerrd[2] != 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" + EXEC SQL SELECT value INTO :gidval FROM numvalues WHERE name = 'gid'; + EXEC SQL REPEATED INSERT INTO list + (name, list_id, active, publicflg, hidden, maillist, grouplist, + gid, description, acl_type, acl_id, + modtime, modby, modwith) + VALUES (:login, :list_id, 1, 0, 0, 0, 1, + :gidval, 'User Group', 'USER', :users_id, + 'now', :who, :entity); if (ingres_errno) return(mr_errcode); -## inquire_equel(rowcount = "rowcount"); - if (rowcount != 1) + if (sqlca.sqlerrd[2] != 1) return(MR_INTERNAL); sprintf(buffer, "l.list_id = %d", list_id); incremental_after("list", buffer, 0); @@ -2771,96 +1357,83 @@ register_user(q, argv, cl) 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) + EXEC SQL REPEATED INSERT INTO imembers + (list_id, member_type, member_id, ref_count, direct) + VALUES (:list_id, 'USER', :users_id, 1, 1); if (ingres_errno) return(mr_errcode); -## inquire_equel(rowcount = "rowcount"); - if (rowcount != 1) + if (sqlca.sqlerrd[2] != 1) return(MR_INTERNAL); incremental_after("members", 0, aargv); - /* 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); + if (m_id == 0) { + /* Cell Name (I know, it shouldn't be hard coded...) */ + strcpy(machname, "ATHENA.MIT.EDU"); + EXEC SQL SELECT mach_id INTO :m_id FROM machine + WHERE name = :machname; + } /* create filesystem */ if (set_next_object_id("filsys_id", "filesys", 0)) 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" + incremental_clear_before(); + if (islower(login[0]) && islower(login[1])) { + sprintf(directory, "/afs/athena.mit.edu/user/%c/%c/%s", + login[0], login[1], login); + } else { + sprintf(directory, "/afs/athena.mit.edu/user/other/%s", login); + } + + EXEC SQL SELECT value INTO :fsidval FROM numvalues + WHERE numvalues.name='filsys_id'; + EXEC SQL REPEATED INSERT INTO filesys + (filsys_id, phys_id, label, type, mach_id, name, + mount, access, comments, owner, owners, createflg, + lockertype, modtime, modby, modwith) + VALUES + (:fsidval, 0, :login, 'AFS', :m_id, :directory, + '/mit/'+:login, 'w', 'User Locker', :users_id, :list_id, 1, + 'HOMEDIR', 'now', :who, :entity); + if (ingres_errno) return(mr_errcode); -## inquire_equel(rowcount = "rowcount"); - if (rowcount != 1) + if (sqlca.sqlerrd[2] != 1) return(MR_INTERNAL); - incremental_after("filesys", - "fs.filsys_id = values.value and values.name = \"filsys_id\"", - 0); - com_err(whoami, 0, "filesys on mach %d in %s/%s", m_id, - directory, login); + sprintf(buffer,"fs.filsys_id = %d",fsidval); + incremental_after("filesys", buffer, 0); /* 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); + if (def_quota == 0) { + EXEC SQL REPEATED SELECT value INTO :def_quota FROM numvalues + WHERE name='def_quota'; + if (ingres_errno) return(mr_errcode); + if (sqlca.sqlerrd[2] != 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" + EXEC SQL REPEATED INSERT INTO quota + (entity_id, filsys_id, type, quota, phys_id, modtime, modby, modwith) + VALUES + (0, :fsidval, 'ANY', :def_quota, 0, 'now', :who, :entity); if (ingres_errno) return(mr_errcode); -## inquire_equel(rowcount = "rowcount"); - if (rowcount != 1) + if (sqlca.sqlerrd[2] != 1) return(MR_INTERNAL); aargv[0] = login; - aargv[1] = "USER"; + aargv[1] = "ANY"; 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); + sprintf(buffer, "q.entity_id = 0 and q.filsys_id = %d and q.type = 'ANY'", fsidval); incremental_after("quota", buffer, aargv); - com_err(whoami, 0, "quota of %d assigned", quota); + com_err(whoami, 0, "quota of %d assigned", def_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" + EXEC SQL REPEATED UPDATE tblstats SET updates=updates+1, modtime='now' + WHERE table_name='users'; + EXEC SQL REPEATED UPDATE tblstats SET appends=appends+1, modtime='now' + WHERE table_name='list' OR table_name='filesys' OR table_name='quota'; if (ingres_errno) return(mr_errcode); return(MR_SUCCESS); -##} +} @@ -2875,440 +1448,55 @@ register_user(q, argv, cl) ** **/ -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 */ - -validate_row(q, argv, v) - register struct query *q; - char *argv[]; - register struct validate *v; -##{ -## char *rvar; -## char *table; -## char *name; -## char qual[128]; -## int rowcount; - - /* build where clause */ - build_qual(v->qual, v->argc, argv, qual); - - /* setup ingres variables */ - rvar = q->rvar; - table = q->rtable; - name = v->field; - - 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 (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) - struct query *q; - register char *argv[]; - register struct valobj *vo; - register int n; +int set_pop_usage(id, cnt) + EXEC SQL BEGIN DECLARE SECTION; + int id; + int cnt; + EXEC SQL END DECLARE SECTION; { - register int status; - - while (--n >= 0) { - switch (vo->type) { - case V_NAME: - 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_VALID) - com_err(whoami, 0, "validating %s in %s: %s", - vo->idfield, vo->table, argv[vo->index]); - status = validate_id(q, argv, vo); - break; - - case V_DATE: - 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_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_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_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 = MR_EXISTS; - break; - - case V_LOCK: - status = lock_table(vo); - break; - } - - if (status != MR_EXISTS) return(status); - vo++; - } + EXEC SQL REPEATED UPDATE serverhosts SET value1 = value1 + :cnt + WHERE serverhosts.service = 'POP' AND serverhosts.mach_id = :id; 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); -} - +/* BEGIN KLUDGE + special-case `ghal "*" "name"' since Ingres does it slowly */ -validate_id(q, argv, vo) +int get_hostalias(q, argv, cl, action, actarg) struct query *q; char *argv[]; - register struct valobj *vo; -##{ -## char *name; -## char *table; -## char *namefield; -## char *idfield; -## int id, rowcount; - int status; - register char *c; - - - name = argv[vo->index]; - table = vo->table; - namefield = vo->namefield; - idfield = vo->idfield; - - if ((!strcmp(table, "users") && !strcmp(namefield, "login")) || - !strcmp(table, "machine") || - !strcmp(table, "filesys") || - !strcmp(table, "list") || - !strcmp(table, "cluster") || - !strcmp(table, "strings")) { - 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 && !strcmp(table, "strings") && - (q->type == APPEND || q->type == UPDATE)) { -## retrieve (id = values.value) where values.#name = "strings_id" - id++; -## replace values (value = id) where values.#name = "strings_id" -## append to strings (string_id = id, string = name) - cache_entry(name, "STRING", id); - *(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(MR_EXISTS); -##} - -validate_name(argv, vo) - char *argv[]; - register struct valobj *vo; -##{ -## char *name; -## 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)) - if (ingres_errno) return(mr_errcode); - return ((rowcount == 1) ? MR_EXISTS : vo->error); -##} - -validate_date(argv, vo) - char *argv[]; - struct valobj *vo; -##{ -## char *idate; -## double dd; -## int errorno; - - idate = argv[vo->index]; - -## retrieve (dd = interval("years", date(idate) - date("today"))) -## inquire_equel (errorno = "errorno") - 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); + client *cl; + int (*action)(); + int actarg; +{ + EXEC SQL BEGIN DECLARE SECTION; + char *alias=argv[0], *machine=argv[1], qual[BUFSIZ], *p; + int id; + EXEC SQL END DECLARE SECTION; + + for(p=machine; *p; p++) { + if(*p=='%' || *p=='_') break; + if(*p=='*') { + p++; + if(*p=='%') p++; + } } - 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 exists; - register char *c; - - typename = vo->table; - 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); - -## 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 */ - -validate_typedata(q, argv, vo) - register struct query *q; - register char *argv[]; - register struct valobj *vo; -##{ -## char *name; -## char *field_type; -## char data_type[129]; -## int id, rowcount; - int status; - char *index(); - register char *c; - - /* get named object */ - name = argv[vo->index]; - - /* 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" - if (ingres_errno) return(mr_errcode); -## inquire_equel (rowcount = "rowcount") - 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 */ - 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 */ - 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, 0); - 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); - 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 */ - 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 values (value = id) where values.#name = "strings_id" -## append to strings (string_id = id, string = name) - cache_entry(name, "STRING", id); - } else if (status) return(status); - } else if (!strcmp(data_type, "none")) { - id = 0; - } else { - return(MR_TYPE); + if(!*p) { + /* machine has no wildcards, so we can do it the fast way */ + EXEC SQL REPEATED SELECT mach_id INTO :id FROM machine + WHERE name=:machine; + if(ingres_errno) return(mr_errcode); + + sprintf(qual, "a.mach_id = %d AND m.mach_id = %d AND a.name LIKE '%s' ESCAPE '*'", id, id, alias); + return do_retrieve(q, qual, 0, action, actarg); } - /* now set value in argv */ - *(int *)argv[vo->index] = id; - - return (MR_EXISTS); -##} - - -/* Lock the table named by the validation object */ - -lock_table(vo) -struct valobj *vo; -##{ -## char *table, *idfield; -## int rowcount; - - 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); -##} - - -/* Check the database at startup time. For now this just resets the - * inprogress flags that the DCM uses. - */ + /* not the special case... do the normal query */ + build_qual(q->qual, q->argc, argv, qual); + return do_retrieve(q, qual, 0, action, actarg); +} -sanity_check_database() -##{ -##} +/* END KLUDGE */