[moira.git] / gen / nfs.pc

/* $Header$
 *
 * This generates the files necessary to load an nfs server.
 *
 *  (c) Copyright 1988, 1990 by the Massachusetts Institute of Technology.
 *  For copying and distribution information, please see the file
 *  <mit-copyright.h>.
 */

#include <mit-copyright.h>
#include <stdio.h>
#include <string.h>
#include <moira.h>
#include <moira_site.h>
#include <sys/types.h>
#include <sys/stat.h>
#include <sys/time.h>
EXEC SQL INCLUDE sqlca;


#define min(x,y)	((x) < (y) ? (x) : (y))

char *whoami = "nfs.gen";
char *db = "moira/moira";
char *malloc(), *strsave();
char nfs_dir[64];
struct hash *users, *groups;


main(argc, argv)
int argc;
char **argv;
{
    char cmd[64];
    struct stat sb;
    int changed = 0;

    if (argc > 2) {
	fprintf(stderr, "usage: %s [outfile]\n", argv[0]);
	exit(MR_ARGS);
    }

    initialize_sms_error_table();
    sprintf(nfs_dir, "%s/nfs", DCM_DIR);

    EXEC SQL CONNECT :db;

    changed = do_nfs();

    EXEC SQL COMMIT;

    if (!changed) {
	fprintf(stderr, "No files updated.\n");
	if (argc == 2 && stat(argv[1], &sb) == 0)
	  exit(MR_NO_CHANGE);
    }

    if (argc == 2) {
	sprintf(cmd, "cd %s; cp %s/nfs/* .; tar cf %s .",
		nfs_dir, SMS_DIR, argv[1]);
	if (system(cmd))
	  exit(MR_TAR_FAIL);
    }

    exit(MR_SUCCESS);
}


/* Generate the files.  Returns zero if nothing changed, non-zero otherwise. */

int do_nfs()
{
    EXEC SQL BEGIN DECLARE SECTION;
    char machname[41], listname[33];
    EXEC SQL END DECLARE SECTION;
    struct save_queue *machs, *lists;
    int changed;

    machs = sq_create();
    lists = sq_create();

    /* The following is declarative, not executed,
     * and so is dependent on where it is in the file,
     * not in the order of execution of statements.
     */
    EXEC SQL WHENEVER SQLERROR GOTO sqlerr;

    EXEC SQL DECLARE s_cursor CURSOR FOR
      SELECT m.name, s.value3
      FROM machine m, serverhosts s
      WHERE m.mach_id = s.mach_id AND s.service = 'NFS' AND s.enable != 0;
    EXEC SQL OPEN s_cursor;
    while (1) {
        EXEC SQL FETCH s_cursor INTO :machname, :listname;
        if (sqlca.sqlcode != 0) break;
        sq_save_unique_string(machs, strsave(strtrim(machname)));
        sq_save_unique_string(lists, strsave(strtrim(listname)));
      }
    EXEC SQL CLOSE s_cursor;

    changed = do_lists(lists);
    EXEC SQL COMMIT;
    changed += do_machs(machs);
    return(changed);
 sqlerr:
    db_error(sqlca.sqlcode);
    exit(MR_DBMS_ERR);
}


/* Make all of the credentials lists that will be needed.  Returns 0 if
 * no files were actually changed 
 */

int do_lists(lists)
struct save_queue *lists;
{
    char file[64], *u;
    struct stat sb;
    FILE *fd;
    EXEC SQL BEGIN DECLARE SECTION;
    char *listname, *lsname, lname[33], uname[9];
    int uid, id, flag1, flag2, flag3, flag4;
    EXEC SQL END DECLARE SECTION;

    sprintf(file, "%s/list-", nfs_dir);
    /*
    if (stat(file, &sb) == 0) {
	if ((ModDiff (&flag1, "users", sb.st_mtime)) ||
	    (ModDiff (&flag2, "list", sb.st_mtime)) ||
	    (ModDiff (&flag3, "imembers", sb.st_mtime)) ||
	    (ModDiff (&flag4, "serverhosts", sb.st_mtime))) exit (MR_DATE);
	if (flag1 < 0 && flag2 < 0 && flag3 < 0 && flag4 < 0) {
	    fprintf(stderr, "The lists do not need to be rebuilt.\n");
	    return(0);
	}
    }
    */


    /* build the list of everyone, and store it in a file whose name
     * corresponds to the empty list.
     */
    do_everyone();

    fprintf(stderr, "Building specific lists\n");
    /* now do each of the lists used by an NFS server */

    while (sq_get_data(lists, &listname)) {
	if (strlen(listname) == 0)
	  continue;
	sprintf(file, "%s/list-%s", nfs_dir, listname);
	fd = fopen(file, "w");
	if (!fd) {
	    fprintf(stderr, "cannot open %s for output\n", file);
	    exit(MR_OCONFIG);
	}

	EXEC SQL DECLARE m_cursor CURSOR FOR
	  SELECT m.member_id
	  FROM imembers m, list l
	  WHERE m.list_id=l.list_id AND l.name = :listname AND
	    m.member_type='USER'
	  ORDER BY member_id;
	EXEC SQL OPEN m_cursor;
	while (1) {
	    EXEC SQL FETCH m_cursor INTO :id;
	    if (sqlca.sqlcode != 0) break;
	    if (u = hash_lookup(users, id))
	      fprintf(fd, "%s\n", u);
	}
	EXEC SQL CLOSE m_cursor;
	if (fclose(fd) == EOF) {
	    fprintf(stderr, "error closing %s\n", file);
	    exit(MR_CCONFIG);
	}
    }
/* don't free here either
    sq_destroy(lists);
 */
    return(1);
 sqlerr:
    db_error(sqlca.sqlcode);
    exit(MR_DBMS_ERR);
}


/*  Build the list of everybody. */
struct grp {
    struct grp *next;
    char *lid;
};
struct user {
    char name[9];
    int uid;
    struct grp *lists;
};


do_everyone()
{
    char buf[BUFSIZ], *l;
    struct user *u;
    struct grp *g;
    struct bucket *b, **p;
    EXEC SQL BEGIN DECLARE SECTION;
    char name[33];
    int gid, id, lid, maxid, uid;
    EXEC SQL END DECLARE SECTION;
    FILE *fd;
    int i;
    struct save_queue *sq;

    fprintf(stderr, "Building the list of everybody\n");
    sprintf(buf, "%s/list-", nfs_dir);
    fd = fopen(buf, "w");
    if (!fd) {
	fprintf(stderr, "cannot open %s for output\n", buf);
	exit(MR_OCONFIG);
    }

    /* make space for group list */
    groups = create_hash(15000);

    /* retrieve simple groups */
    EXEC SQL DECLARE l_cursor CURSOR FOR
     SELECT gid, list_id
     FROM list
     WHERE grouplist != 0 AND active != 0
     ORDER BY list_id;
    EXEC SQL OPEN l_cursor;
    while (1) {
        EXEC SQL FETCH l_cursor INTO :gid, :lid;
        if (sqlca.sqlcode != 0) break;
        sprintf(buf, ":%d", gid);
        hash_store(groups, lid, strsave(buf));
      }
    EXEC SQL CLOSE l_cursor;

    /* now do grplists */
    users = create_hash(10000);
    EXEC SQL DECLARE u_cursor CURSOR FOR
      SELECT users_id, login, unix_uid
      FROM users
      WHERE status = 1
      ORDER BY users_id;
    EXEC SQL OPEN u_cursor;
    while (1) {
        EXEC SQL FETCH u_cursor INTO :id, :name, :uid;
        if (sqlca.sqlcode != 0) break;
        u = (struct user *) malloc(sizeof(struct user));
        strcpy(u->name, strtrim(name));
        u->uid = uid;
        u->lists = NULL;
        hash_store(users, id, u);
      }
    EXEC SQL CLOSE u_cursor;

    EXEC SQL DECLARE m_cursor2 CURSOR FOR
      SELECT list_id, member_id
      FROM imembers
      WHERE member_type = 'USER'
      ORDER BY list_id;
    EXEC SQL OPEN m_cursor2;
    while (1) {
        EXEC SQL FETCH m_cursor2 INTO :lid, :id;
        if (sqlca.sqlcode != 0) break;
        if ((u = (struct user *) hash_lookup(users, id)) &&
	    ((l = hash_lookup(groups, lid)) != NULL)) {
	    g = (struct grp *) malloc(sizeof(struct grp));
	    g->next = u->lists;
	    u->lists = g;
	    g->lid = l;
	  }
      }
    EXEC SQL CLOSE m_cursor2;

    for (p = &(users->data[users->size - 1]); p >= users->data; p--) {
	for (b = *p; b; b = b->next) {
	    u = (struct user *)b->data;
	    sprintf(buf, "%s:%d", u->name, u->uid);
	    for (g = u->lists; g; g = g->next)
	      strcat(buf, g->lid);
	    b->data = strsave(buf);
	    fprintf(fd, "%s\n", buf);
	}
    }

    fclose(fd);
    return(1);
 sqlerr:
    db_error(sqlca.sqlcode);
    exit(MR_DBMS_ERR);
}


/* Now do each of the servers, linking the credentials list file and 
 * compiling the quota and dirs files.
 */

int do_machs(machs)
struct save_queue *machs;
{
    EXEC SQL BEGIN DECLARE SECTION;
    char *machname, listname[33], dev[33], dir[81], fstype[9];
    int uid, quota, id, gid, flag1, flag2, flag3, flag4;
    EXEC SQL END DECLARE SECTION;
    char file[64], f1[64], f2[64], *cp;
    int prevuid, quotasum, olddev, oldmach;
    FILE *fd;
    struct hash *machines;

    fprintf(stderr, "Building machine files\n");


    machines = create_hash(100);
    while (sq_get_data(machs, &machname)) {
	EXEC SQL SELECT s.value3, m.mach_id
	  INTO :listname, :id
	  FROM serverhosts s, machine m
	  WHERE s.mach_id = m.mach_id AND m.name = :machname AND 
	    s.service = 'NFS';
	strtrim(machname);
	sprintf(f1, "%s/list-%s", nfs_dir, strtrim(listname));
	sprintf(f2, "%s/%s.cred", nfs_dir, machname);
	unlink(f2); /* ignore errors on this unlink */
	if (link(f1, f2)) {
	    fprintf(stderr, "Cannot link %s to %s\n", f1, f2);
	    exit(MR_OCONFIG);
	}
	hash_store(machines, id, machname);
    }


    olddev = oldmach = -1;
    fd = stdin;

    EXEC SQL DECLARE q_cursor CURSOR FOR
      SELECT DISTINCT q.quota, q.entity_id, q.phys_id, n.device, n.mach_id 
      FROM quota q, nfsphys n
      WHERE n.nfsphys_id = q.phys_id AND q.phys_id != 0 AND
	n.status < 16 AND q.type = 'USER'
      ORDER BY n.mach_id, q.phys_id, q.entity_id;
    EXEC SQL OPEN q_cursor;
    while (1) {
	EXEC SQL FETCH q_cursor INTO :quota, :uid, :flag1, :dev, :flag2;
	if (sqlca.sqlcode != 0) break;
	if (flag1 != olddev || flag2 != oldmach) {
	    if (quotasum)
	      fprintf(fd, "%d %d\n", prevuid, quotasum);
	    if (flag2 == 0 || !hash_lookup(machines, flag2))
	      continue;
	    if (fd != stdin)
	      fclose(fd);
	    olddev = flag1;
	    oldmach = flag2;
	    while (cp = strchr(dev, '/')) *cp = '@';
	    sprintf(file, "%s/%s.%s.quotas", nfs_dir,
		    hash_lookup(machines, flag2), strtrim(dev));
	    fd = fopen(file, "w");
	    if (!fd) {
		fprintf(stderr, "cannot open %s for output\n", file);
		exit(MR_OCONFIG);
	    }
	    prevuid = -1;
	    quotasum = 0;
	}
	if (uid != prevuid) {
	    if ((cp = hash_lookup(users, prevuid)) &&
		(cp = strchr(cp, ':')))
	      prevuid = atoi(cp+1);
	    if (quotasum)
	      fprintf(fd, "%d %d\n", prevuid, quotasum);
	    prevuid = uid;
	    quotasum = quota;
	} else {
	    quotasum += quota;
	}
    }
    EXEC SQL CLOSE q_cursor;
    if ((cp = hash_lookup(users, prevuid)) &&
	(cp = strchr(cp, ':')))
      prevuid = atoi(cp+1);
    if (quotasum)
      fprintf(fd, "%d %d\n", prevuid, quotasum);
    if (fd != stdin && fclose(fd) == EOF) {
	fprintf(stderr, "error closing %s", file);
	exit(MR_CCONFIG);
      }

    olddev = oldmach = -1;
    fd = stdin;
    EXEC SQL DECLARE q_cursor2 CURSOR FOR
      SELECT DISTINCT q.quota, q.entity_id, q.phys_id, n.device, n.mach_id,
        n.status 
      FROM quota q, nfsphys n
      WHERE n.nfsphys_id = q.phys_id AND q.phys_id != 0 AND
	n.status > 15 AND q.type = 'GROUP'
      ORDER BY mach_id, phys_id, entity_id;
    EXEC SQL OPEN q_cursor2;
    while (1) {
	EXEC SQL FETCH q_cursor2 INTO :quota, :gid, :flag1, :dev,
		:flag2, :flag3;
	if (sqlca.sqlcode != 0) break;
	if (flag1 != olddev || flag2 != oldmach) {
	    if (quotasum)
	      fprintf(fd, "%d %d\n", prevuid, quotasum);
	    if (flag2 == 0 || !hash_lookup(machines, flag2))
	      continue;
	    if (fd != stdin)
	      fclose(fd);
	    olddev = flag1;
	    oldmach = flag2;
	    while (cp = strchr(dev, '/')) *cp = '@';
	    sprintf(file, "%s/%s.%s.quotas", nfs_dir,
		    hash_lookup(machines, flag2), strtrim(dev));
	    fd = fopen(file, "w");
	    if (!fd) {
		fprintf(stderr, "cannot open %s for output\n", file);
		exit(MR_OCONFIG);
	    }
	    prevuid = -1;
	    quotasum = 0;
	}
	if (gid != prevuid) {
	    if (cp = hash_lookup(groups, prevuid))
	      prevuid = atoi(cp + 1);
	    if (quotasum)
	      fprintf(fd, "%d %d\n", prevuid, quotasum);
	    prevuid = gid;
	    quotasum = quota;
	} else {
	    quotasum += quota;
	}
    }
    EXEC SQL CLOSE q_cursor2;
    if (cp = hash_lookup(groups, prevuid))
      prevuid = atoi(cp + 1);
    if (quotasum)
      fprintf(fd, "%d %d\n", prevuid, quotasum);
    if (fd != stdin && fclose(fd) == EOF) {
	fprintf(stderr, "error closing %s", file);
	exit(MR_CCONFIG);
      }

    olddev = oldmach = -1;
    fd = stdin;

    EXEC SQL DECLARE q_cursor3 CURSOR FOR
      SELECT DISTINCT f.name, f.lockertype, u.unix_uid, l.gid, f.phys_id, 
		f.mach_id, n.device 
      FROM users u, list l, nfsphys n, filesys f
      WHERE u.users_id = f.owner AND 
              l.list_id = f.owners AND
  	      f.createflg != 0 AND f.phys_id != 0 AND
              f.type = 'NFS' AND 
              f.phys_id = n.nfsphys_id
      ORDER BY mach_id, phys_id;
    EXEC SQL OPEN q_cursor3;
    while (1) {
	EXEC SQL FETCH q_cursor3 INTO :dir, :fstype, :uid, :gid, :flag1,
			:flag2, :dev;
	if (sqlca.sqlcode != 0) break;
	if ((flag1 != olddev || flag2 != oldmach) &&
	    hash_lookup(machines, flag2)) {
	    if (fd != stdin)
	      fclose(fd);
	    olddev = flag1;
	    oldmach = flag2;
	    while (cp = strchr(dev, '/')) *cp = '@';
	    sprintf(file, "%s/%s.%s.dirs", nfs_dir,
		    hash_lookup(machines, flag2), strtrim(dev));
	    fd = fopen(file, "w");
	    if (!fd) {
		fprintf(stderr, "cannot open %s for output\n", file);
		exit(MR_OCONFIG);
	    }
	}
	fprintf(fd, "%s %d %d %s\n", strtrim(dir), uid, gid, strtrim(fstype));
    }    
    EXEC SQL CLOSE q_cursor3;
    if (fclose(fd) == EOF) {
	fprintf(stderr, "error closing %s", file);
	exit(MR_CCONFIG);
    }
    return(1);
 sqlerr:
    db_error(sqlca.sqlcode);
    exit(MR_DBMS_ERR);
}
Commit	Line	Data
f852c398	1	/* $Header$
	2	*
	3	* This generates the files necessary to load an nfs server.
	4	*
	5	* (c) Copyright 1988, 1990 by the Massachusetts Institute of Technology.
	6	* For copying and distribution information, please see the file
	7	* <mit-copyright.h>.
	8	*/
	9
	10	#include <mit-copyright.h>
	11	#include <stdio.h>
9c04b191	12	#include <string.h>
f852c398	13	#include <moira.h>
	14	#include <moira_site.h>
	15	#include <sys/types.h>
	16	#include <sys/stat.h>
	17	#include <sys/time.h>
	18	EXEC SQL INCLUDE sqlca;
	19
	20
	21	#define min(x,y) ((x) < (y) ? (x) : (y))
	22
	23	char *whoami = "nfs.gen";
9c04b191	24	char *db = "moira/moira";
f852c398	25	char malloc(), strsave();
f852c398	26	char nfs_dir[64];
22bc6c27	27	struct hash users, groups;
22bc6c27	28
f852c398	29
	30	main(argc, argv)
	31	int argc;
	32	char **argv;
	33	{
	34	char cmd[64];
	35	struct stat sb;
	36	int changed = 0;
	37
	38	if (argc > 2) {
	39	fprintf(stderr, "usage: %s [outfile]\n", argv[0]);
	40	exit(MR_ARGS);
	41	}
	42
	43	initialize_sms_error_table();
	44	sprintf(nfs_dir, "%s/nfs", DCM_DIR);
	45
9c04b191	46	EXEC SQL CONNECT :db;
f852c398	47
	48	changed = do_nfs();
	49
9c04b191	50	EXEC SQL COMMIT;
f852c398	51
	52	if (!changed) {
	53	fprintf(stderr, "No files updated.\n");
	54	if (argc == 2 && stat(argv[1], &sb) == 0)
	55	exit(MR_NO_CHANGE);
	56	}
	57
	58	if (argc == 2) {
	59	sprintf(cmd, "cd %s; cp %s/nfs/* .; tar cf %s .",
	60	nfs_dir, SMS_DIR, argv[1]);
	61	if (system(cmd))
	62	exit(MR_TAR_FAIL);
	63	}
	64
	65	exit(MR_SUCCESS);
	66	}
	67
	68
	69	/* Generate the files. Returns zero if nothing changed, non-zero otherwise. */
	70
	71	int do_nfs()
	72	{
	73	EXEC SQL BEGIN DECLARE SECTION;
c1d0f286	74	char machname[41], listname[33];
f852c398	75	EXEC SQL END DECLARE SECTION;
	76	struct save_queue machs, lists;
	77	int changed;
	78
	79	machs = sq_create();
	80	lists = sq_create();
	81
22bc6c27	82	/* The following is declarative, not executed,
	83	* and so is dependent on where it is in the file,
	84	* not in the order of execution of statements.
	85	*/
f852c398	86	EXEC SQL WHENEVER SQLERROR GOTO sqlerr;
9c04b191	87
f852c398	88	EXEC SQL DECLARE s_cursor CURSOR FOR
	89	SELECT m.name, s.value3
	90	FROM machine m, serverhosts s
22bc6c27	91	WHERE m.mach_id = s.mach_id AND s.service = 'NFS' AND s.enable != 0;
f852c398	92	EXEC SQL OPEN s_cursor;
	93	while (1) {
	94	EXEC SQL FETCH s_cursor INTO :machname, :listname;
	95	if (sqlca.sqlcode != 0) break;
	96	sq_save_unique_string(machs, strsave(strtrim(machname)));
	97	sq_save_unique_string(lists, strsave(strtrim(listname)));
	98	}
	99	EXEC SQL CLOSE s_cursor;
	100
	101	changed = do_lists(lists);
22bc6c27	102	EXEC SQL COMMIT;
f852c398	103	changed += do_machs(machs);
	104	return(changed);
	105	sqlerr:
9c04b191	106	db_error(sqlca.sqlcode);
9c04b191	107	exit(MR_DBMS_ERR);
f852c398	108	}
	109
	110
	111	/* Make all of the credentials lists that will be needed. Returns 0 if
9c04b191	112	* no files were actually changed
9c04b191	113	*/
f852c398	114
	115	int do_lists(lists)
	116	struct save_queue *lists;
	117	{
	118	char file[64], *u;
f852c398	119	struct stat sb;
	120	FILE *fd;
	121	EXEC SQL BEGIN DECLARE SECTION;
	122	char listname, lsname, lname[33], uname[9];
	123	int uid, id, flag1, flag2, flag3, flag4;
	124	EXEC SQL END DECLARE SECTION;
	125
	126	sprintf(file, "%s/list-", nfs_dir);
22bc6c27	127	/*
f852c398	128	if (stat(file, &sb) == 0) {
	129	if ((ModDiff (&flag1, "users", sb.st_mtime)) \|\|
	130	(ModDiff (&flag2, "list", sb.st_mtime)) \|\|
	131	(ModDiff (&flag3, "imembers", sb.st_mtime)) \|\|
	132	(ModDiff (&flag4, "serverhosts", sb.st_mtime))) exit (MR_DATE);
	133	if (flag1 < 0 && flag2 < 0 && flag3 < 0 && flag4 < 0) {
	134	fprintf(stderr, "The lists do not need to be rebuilt.\n");
	135	return(0);
	136	}
	137	}
22bc6c27	138	*/
f852c398	139
f852c398	140
	141	/* build the list of everyone, and store it in a file whose name
	142	* corresponds to the empty list.
	143	*/
22bc6c27	144	do_everyone();
f852c398	145
	146	fprintf(stderr, "Building specific lists\n");
	147	/* now do each of the lists used by an NFS server */
	148
	149	while (sq_get_data(lists, &listname)) {
	150	if (strlen(listname) == 0)
	151	continue;
	152	sprintf(file, "%s/list-%s", nfs_dir, listname);
	153	fd = fopen(file, "w");
	154	if (!fd) {
	155	fprintf(stderr, "cannot open %s for output\n", file);
	156	exit(MR_OCONFIG);
	157	}
	158
	159	EXEC SQL DECLARE m_cursor CURSOR FOR
	160	SELECT m.member_id
	161	FROM imembers m, list l
	162	WHERE m.list_id=l.list_id AND l.name = :listname AND
22bc6c27	163	m.member_type='USER'
22bc6c27	164	ORDER BY member_id;
f852c398	165	EXEC SQL OPEN m_cursor;
	166	while (1) {
	167	EXEC SQL FETCH m_cursor INTO :id;
	168	if (sqlca.sqlcode != 0) break;
	169	if (u = hash_lookup(users, id))
	170	fprintf(fd, "%s\n", u);
	171	}
	172	EXEC SQL CLOSE m_cursor;
2ab080f0	173	if (fclose(fd) == EOF) {
f852c398	174	fprintf(stderr, "error closing %s\n", file);
	175	exit(MR_CCONFIG);
	176	}
	177	}
	178	/* don't free here either
	179	sq_destroy(lists);
	180	*/
	181	return(1);
	182	sqlerr:
9c04b191	183	db_error(sqlca.sqlcode);
9c04b191	184	exit(MR_DBMS_ERR);
f852c398	185	}
	186
	187
	188	/* Build the list of everybody. */
	189	struct grp {
	190	struct grp *next;
	191	char *lid;
	192	};
	193	struct user {
	194	char name[9];
	195	int uid;
	196	struct grp *lists;
	197	};
	198
	199
22bc6c27	200	do_everyone()
f852c398	201	{
f852c398	202	char buf[BUFSIZ], *l;
f852c398	203	struct user *u;
	204	struct grp *g;
	205	struct bucket b, *p;
	206	EXEC SQL BEGIN DECLARE SECTION;
	207	char name[33];
	208	int gid, id, lid, maxid, uid;
	209	EXEC SQL END DECLARE SECTION;
	210	FILE *fd;
	211	int i;
	212	struct save_queue *sq;
	213
	214	fprintf(stderr, "Building the list of everybody\n");
	215	sprintf(buf, "%s/list-", nfs_dir);
	216	fd = fopen(buf, "w");
	217	if (!fd) {
	218	fprintf(stderr, "cannot open %s for output\n", buf);
	219	exit(MR_OCONFIG);
	220	}
	221
	222	/* make space for group list */
	223	groups = create_hash(15000);
	224
	225	/* retrieve simple groups */
	226	EXEC SQL DECLARE l_cursor CURSOR FOR
	227	SELECT gid, list_id
	228	FROM list
22bc6c27	229	WHERE grouplist != 0 AND active != 0
22bc6c27	230	ORDER BY list_id;
f852c398	231	EXEC SQL OPEN l_cursor;
	232	while (1) {
	233	EXEC SQL FETCH l_cursor INTO :gid, :lid;
	234	if (sqlca.sqlcode != 0) break;
	235	sprintf(buf, ":%d", gid);
	236	hash_store(groups, lid, strsave(buf));
	237	}
	238	EXEC SQL CLOSE l_cursor;
	239
	240	/* now do grplists */
	241	users = create_hash(10000);
	242	EXEC SQL DECLARE u_cursor CURSOR FOR
9c04b191	243	SELECT users_id, login, unix_uid
f852c398	244	FROM users
22bc6c27	245	WHERE status = 1
22bc6c27	246	ORDER BY users_id;
f852c398	247	EXEC SQL OPEN u_cursor;
	248	while (1) {
	249	EXEC SQL FETCH u_cursor INTO :id, :name, :uid;
	250	if (sqlca.sqlcode != 0) break;
	251	u = (struct user *) malloc(sizeof(struct user));
	252	strcpy(u->name, strtrim(name));
	253	u->uid = uid;
	254	u->lists = NULL;
	255	hash_store(users, id, u);
	256	}
	257	EXEC SQL CLOSE u_cursor;
	258
	259	EXEC SQL DECLARE m_cursor2 CURSOR FOR
	260	SELECT list_id, member_id
	261	FROM imembers
22bc6c27	262	WHERE member_type = 'USER'
22bc6c27	263	ORDER BY list_id;
f852c398	264	EXEC SQL OPEN m_cursor2;
	265	while (1) {
	266	EXEC SQL FETCH m_cursor2 INTO :lid, :id;
	267	if (sqlca.sqlcode != 0) break;
	268	if ((u = (struct user *) hash_lookup(users, id)) &&
	269	((l = hash_lookup(groups, lid)) != NULL)) {
	270	g = (struct grp *) malloc(sizeof(struct grp));
	271	g->next = u->lists;
	272	u->lists = g;
	273	g->lid = l;
	274	}
	275	}
	276	EXEC SQL CLOSE m_cursor2;
	277
	278	for (p = &(users->data[users->size - 1]); p >= users->data; p--) {
	279	for (b = *p; b; b = b->next) {
	280	u = (struct user *)b->data;
	281	sprintf(buf, "%s:%d", u->name, u->uid);
	282	for (g = u->lists; g; g = g->next)
	283	strcat(buf, g->lid);
	284	b->data = strsave(buf);
	285	fprintf(fd, "%s\n", buf);
	286	}
	287	}
	288
	289	fclose(fd);
22bc6c27	290	return(1);
f852c398	291	sqlerr:
9c04b191	292	db_error(sqlca.sqlcode);
9c04b191	293	exit(MR_DBMS_ERR);
f852c398	294	}
	295
	296
	297	/* Now do each of the servers, linking the credentials list file and
	298	* compiling the quota and dirs files.
	299	*/
	300
	301	int do_machs(machs)
	302	struct save_queue *machs;
	303	{
	304	EXEC SQL BEGIN DECLARE SECTION;
	305	char *machname, listname[33], dev[33], dir[81], fstype[9];
	306	int uid, quota, id, gid, flag1, flag2, flag3, flag4;
	307	EXEC SQL END DECLARE SECTION;
9c04b191	308	char file[64], f1[64], f2[64], *cp;
f852c398	309	int prevuid, quotasum, olddev, oldmach;
	310	FILE *fd;
	311	struct hash *machines;
	312
	313	fprintf(stderr, "Building machine files\n");
	314
f852c398	315
	316	machines = create_hash(100);
	317	while (sq_get_data(machs, &machname)) {
	318	EXEC SQL SELECT s.value3, m.mach_id
	319	INTO :listname, :id
	320	FROM serverhosts s, machine m
22bc6c27	321	WHERE s.mach_id = m.mach_id AND m.name = :machname AND
22bc6c27	322	s.service = 'NFS';
f852c398	323	strtrim(machname);
	324	sprintf(f1, "%s/list-%s", nfs_dir, strtrim(listname));
	325	sprintf(f2, "%s/%s.cred", nfs_dir, machname);
	326	unlink(f2); /* ignore errors on this unlink */
	327	if (link(f1, f2)) {
	328	fprintf(stderr, "Cannot link %s to %s\n", f1, f2);
	329	exit(MR_OCONFIG);
	330	}
	331	hash_store(machines, id, machname);
	332	}
	333
	334
	335	olddev = oldmach = -1;
	336	fd = stdin;
	337
	338	EXEC SQL DECLARE q_cursor CURSOR FOR
22bc6c27	339	SELECT DISTINCT q.quota, q.entity_id, q.phys_id, n.device, n.mach_id
	340	FROM quota q, nfsphys n
	341	WHERE n.nfsphys_id = q.phys_id AND q.phys_id != 0 AND
	342	n.status < 16 AND q.type = 'USER'
	343	ORDER BY n.mach_id, q.phys_id, q.entity_id;
f852c398	344	EXEC SQL OPEN q_cursor;
	345	while (1) {
	346	EXEC SQL FETCH q_cursor INTO :quota, :uid, :flag1, :dev, :flag2;
	347	if (sqlca.sqlcode != 0) break;
	348	if (flag1 != olddev \|\| flag2 != oldmach) {
22bc6c27	349	if (quotasum)
	350	fprintf(fd, "%d %d\n", prevuid, quotasum);
	351	if (flag2 == 0 \|\| !hash_lookup(machines, flag2))
	352	continue;
	353	if (fd != stdin)
	354	fclose(fd);
f852c398	355	olddev = flag1;
f852c398	356	oldmach = flag2;
9c04b191	357	while (cp = strchr(dev, '/')) *cp = '@';
f852c398	358	sprintf(file, "%s/%s.%s.quotas", nfs_dir,
	359	hash_lookup(machines, flag2), strtrim(dev));
	360	fd = fopen(file, "w");
	361	if (!fd) {
	362	fprintf(stderr, "cannot open %s for output\n", file);
	363	exit(MR_OCONFIG);
	364	}
	365	prevuid = -1;
	366	quotasum = 0;
	367	}
	368	if (uid != prevuid) {
22bc6c27	369	if ((cp = hash_lookup(users, prevuid)) &&
9c04b191	370	(cp = strchr(cp, ':')))
22bc6c27	371	prevuid = atoi(cp+1);
f852c398	372	if (quotasum)
	373	fprintf(fd, "%d %d\n", prevuid, quotasum);
	374	prevuid = uid;
	375	quotasum = quota;
	376	} else {
	377	quotasum += quota;
	378	}
	379	}
	380	EXEC SQL CLOSE q_cursor;
22bc6c27	381	if ((cp = hash_lookup(users, prevuid)) &&
9c04b191	382	(cp = strchr(cp, ':')))
22bc6c27	383	prevuid = atoi(cp+1);
f852c398	384	if (quotasum)
f852c398	385	fprintf(fd, "%d %d\n", prevuid, quotasum);
2ab080f0	386	if (fd != stdin && fclose(fd) == EOF) {
f852c398	387	fprintf(stderr, "error closing %s", file);
	388	exit(MR_CCONFIG);
	389	}
	390
	391	olddev = oldmach = -1;
	392	fd = stdin;
	393	EXEC SQL DECLARE q_cursor2 CURSOR FOR
22bc6c27	394	SELECT DISTINCT q.quota, q.entity_id, q.phys_id, n.device, n.mach_id,
	395	n.status
	396	FROM quota q, nfsphys n
	397	WHERE n.nfsphys_id = q.phys_id AND q.phys_id != 0 AND
	398	n.status > 15 AND q.type = 'GROUP'
	399	ORDER BY mach_id, phys_id, entity_id;
f852c398	400	EXEC SQL OPEN q_cursor2;
	401	while (1) {
	402	EXEC SQL FETCH q_cursor2 INTO :quota, :gid, :flag1, :dev,
	403	:flag2, :flag3;
	404	if (sqlca.sqlcode != 0) break;
	405	if (flag1 != olddev \|\| flag2 != oldmach) {
22bc6c27	406	if (quotasum)
	407	fprintf(fd, "%d %d\n", prevuid, quotasum);
	408	if (flag2 == 0 \|\| !hash_lookup(machines, flag2))
	409	continue;
	410	if (fd != stdin)
	411	fclose(fd);
f852c398	412	olddev = flag1;
f852c398	413	oldmach = flag2;
9c04b191	414	while (cp = strchr(dev, '/')) *cp = '@';
f852c398	415	sprintf(file, "%s/%s.%s.quotas", nfs_dir,
	416	hash_lookup(machines, flag2), strtrim(dev));
	417	fd = fopen(file, "w");
	418	if (!fd) {
	419	fprintf(stderr, "cannot open %s for output\n", file);
	420	exit(MR_OCONFIG);
	421	}
	422	prevuid = -1;
	423	quotasum = 0;
	424	}
	425	if (gid != prevuid) {
22bc6c27	426	if (cp = hash_lookup(groups, prevuid))
22bc6c27	427	prevuid = atoi(cp + 1);
f852c398	428	if (quotasum)
	429	fprintf(fd, "%d %d\n", prevuid, quotasum);
	430	prevuid = gid;
	431	quotasum = quota;
	432	} else {
	433	quotasum += quota;
	434	}
	435	}
	436	EXEC SQL CLOSE q_cursor2;
22bc6c27	437	if (cp = hash_lookup(groups, prevuid))
22bc6c27	438	prevuid = atoi(cp + 1);
f852c398	439	if (quotasum)
f852c398	440	fprintf(fd, "%d %d\n", prevuid, quotasum);
2ab080f0	441	if (fd != stdin && fclose(fd) == EOF) {
f852c398	442	fprintf(stderr, "error closing %s", file);
	443	exit(MR_CCONFIG);
	444	}
	445
	446	olddev = oldmach = -1;
22bc6c27	447	fd = stdin;
f852c398	448
f852c398	449	EXEC SQL DECLARE q_cursor3 CURSOR FOR
9c04b191	450	SELECT DISTINCT f.name, f.lockertype, u.unix_uid, l.gid, f.phys_id,
f852c398	451	f.mach_id, n.device
	452	FROM users u, list l, nfsphys n, filesys f
	453	WHERE u.users_id = f.owner AND
	454	l.list_id = f.owners AND
	455	f.createflg != 0 AND f.phys_id != 0 AND
22bc6c27	456	f.type = 'NFS' AND
f852c398	457	f.phys_id = n.nfsphys_id
	458	ORDER BY mach_id, phys_id;
	459	EXEC SQL OPEN q_cursor3;
	460	while (1) {
	461	EXEC SQL FETCH q_cursor3 INTO :dir, :fstype, :uid, :gid, :flag1,
	462	:flag2, :dev;
	463	if (sqlca.sqlcode != 0) break;
9c04b191	464	if ((flag1 != olddev \|\| flag2 != oldmach) &&
9c04b191	465	hash_lookup(machines, flag2)) {
22bc6c27	466	if (fd != stdin)
22bc6c27	467	fclose(fd);
f852c398	468	olddev = flag1;
f852c398	469	oldmach = flag2;
9c04b191	470	while (cp = strchr(dev, '/')) *cp = '@';
f852c398	471	sprintf(file, "%s/%s.%s.dirs", nfs_dir,
	472	hash_lookup(machines, flag2), strtrim(dev));
	473	fd = fopen(file, "w");
	474	if (!fd) {
	475	fprintf(stderr, "cannot open %s for output\n", file);
	476	exit(MR_OCONFIG);
	477	}
	478	}
	479	fprintf(fd, "%s %d %d %s\n", strtrim(dir), uid, gid, strtrim(fstype));
	480	}
	481	EXEC SQL CLOSE q_cursor3;
2ab080f0	482	if (fclose(fd) == EOF) {
f852c398	483	fprintf(stderr, "error closing %s", file);
	484	exit(MR_CCONFIG);
	485	}
	486	return(1);
	487	sqlerr:
9c04b191	488	db_error(sqlca.sqlcode);
9c04b191	489	exit(MR_DBMS_ERR);
f852c398	490	}