sprintf(hesiod_dir, "%s/hesiod", DCM_DIR);
#ifsql INGRES
- EXEC SQL CONNECT sms;
+ EXEC SQL CONNECT moira;
+ EXEC SQL SET LOCKMODE SESSION WHERE LEVEL=TABLE, READLOCK=SHARED;
#endsql
#ifsql INFORMIX
- EXEC SQL DATABASE sms;
+ EXEC SQL DATABASE moira;
#endsql
changed = do_passwd();
machines = create_hash(1000);
EXEC SQL DECLARE m_cursor CURSOR FOR
- SELECT NAME, MACH_ID
- FROM MACHINE;
+ SELECT name, mach_id
+ FROM machine
+ ORDER BY mach_id;
EXEC SQL OPEN m_cursor;
while (1) {
EXEC SQL FETCH m_cursor INTO :name, :id;
}
EXEC SQL CLOSE m_cursor;
#ifsql INGRES
+ EXEC SQL COMMIT;
#endsql
#ifsql INFORMIX
EXEC SQL COMMIT WORK;
EXEC SQL BEGIN DECLARE SECTION;
char login[9], shell[33], fullname[33], oa[17], op[13], hp[17];
char nn[17], ptype[9];
- int uid, flag1, flag2, id, pid;
+ int uid, flag1, flag2, id, pid, status;
EXEC SQL END DECLARE SECTION;
sprintf(poutf, "%s/passwd.db", hesiod_dir);
users = create_hash(12001);
EXEC SQL DECLARE u_cursor CURSOR FOR
SELECT login, uid, shell, fullname, nickname, office_addr,
- office_phone, home_phone, users_id, pop_id, potype
+ office_phone, home_phone, users_id, pop_id, potype, status
FROM users
- WHERE status = 1;
+ WHERE status = 1 or status = 6
+ ORDER BY users_id;
EXEC SQL OPEN u_cursor;
while (1) {
EXEC SQL FETCH u_cursor INTO :login, :uid, :shell, :fullname, :nn,
- :oa, :op, :hp, :id, :pid, :ptype;
+ :oa, :op, :hp, :id, :pid, :ptype, :status;
if (sqlca.sqlcode != 0) break;
strtrim(login);
dequote(fullname);
strcpy(u->name, login);
u->lists = NULL;
hash_store(users, id, u);
- fprintf(pout, "%s.passwd\tHS %s \"%s:*:%d:101:%s,%s,%s,%s,%s:/mit/%s:%s\"\n",
- login, HTYPE, login, uid, fullname, nn, oa, op, hp, login, shell);
- fprintf(uout, "%d.uid\tHS CNAME %s.passwd\n", uid, login);
+ if (status == 1) {
+ fprintf(pout, "%s.passwd\tHS %s \"%s:*:%d:101:%s,%s,%s,%s,%s:/mit/%s:%s\"\n",
+ login, HTYPE, login, uid, fullname, nn, oa, op, hp,
+ login, shell);
+ fprintf(uout, "%d.uid\tHS CNAME %s.passwd\n", uid, login);
+ }
if (ptype[0] == 'P' && (mach = hash_lookup(machines, pid))) {
fprintf(bout, "%s.pobox\tHS %s \"POP %s %s\"\n",
login, HTYPE, mach, login);
}
EXEC SQL CLOSE u_cursor;
#ifsql INGRES
+ EXEC SQL COMMIT;
#endsql
#ifsql INFORMIX
EXEC SQL COMMIT WORK;
/* make space for group list */
groups = create_hash(15001);
+ /* The following WHENEVER is declarative, not executed,
+ * and applies for the remainder of this file only.
+ */
EXEC SQL WHENEVER SQLERROR GOTO sqlerr;
/* get lock records */
EXEC SQL DECLARE l_cursor CURSOR FOR
SELECT name, gid, list_id
- FROM list
- WHERE grp != 0 AND active != 0;
+ 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 :name, :gid, :lid;
users = create_hash(12001);
EXEC SQL DECLARE u_cursor2 CURSOR FOR
SELECT users_id, login
- FROM users
- WHERE status = 1;
+ FROM users
+ WHERE status = 1
+ ORDER BY users_id;
EXEC SQL OPEN u_cursor2;
while (1) {
EXEC SQL FETCH u_cursor2 INTO :id, :name;
EXEC SQL DECLARE i_cursor CURSOR FOR
SELECT list_id, member_id
- FROM imembers
- WHERE member_type = "USER";
+ FROM imembers
+ WHERE member_type = 'USER'
+ ORDER BY list_id;
EXEC SQL OPEN i_cursor;
while (1) {
EXEC SQL FETCH i_cursor INTO :lid, :id;
}
EXEC SQL CLOSE i_cursor;
#ifsql INGRES
+ EXEC SQL COMMIT;
#endsql
#ifsql INFORMIX
EXEC SQL COMMIT WORK;
register char *p;
struct stat sb;
time_t ftime;
- struct save_queue *sq, *sq_create();
+ struct save_queue *sq, *sq2, *sq_create();
EXEC SQL BEGIN DECLARE SECTION;
char name[33], type[9], loc[81], access[2], mount[33], trans[257];
char comments[65];
fprintf(stderr, "Building filsys.db\n");
get_mach();
sq = sq_create();
+ sq2 = sq_create();
EXEC SQL DECLARE f_cursor CURSOR FOR
SELECT label, type, name, mach_id, access, mount, comments, filsys_id
- FROM filesys;
+ FROM filesys
+ ORDER BY filsys_id;
EXEC SQL OPEN f_cursor;
while (1) {
EXEC SQL FETCH f_cursor INTO :name, :type, :loc, :id, :access,
} else if (!strcmp(type, "FSGROUP")) {
sprintf(trans, "%s:%d", strtrim(name), fid);
sq_save_data(sq, strsave(trans));
+ } else if (!strcmp(type, "MUL")) {
+ sprintf(trans, "%s:%d", strtrim(name), fid);
+ sq_save_data(sq2, strsave(trans));
}
}
EXEC SQL CLOSE f_cursor;
SELECT DISTINCT f.type, f.name, f.mach_id, f.access, f.mount,
f.comments, f.label, g.key
FROM filesys f, fsgroup g
- WHERE f.filsys_id = g.filsys_id AND g.group_id = :fid
- ORDER BY key, label;
+ WHERE f.filsys_id = g.filsys_id AND g.group_id = :fid
+ ORDER BY key, label;
EXEC SQL OPEN f_cursor2;
while (1) {
EXEC SQL FETCH f_cursor2 INTO :type, :loc, :id, :access,:mount,
}
sq_destroy(sq);
+ while (sq_get_data(sq2, &group)) {
+ fid = atoi(index(group, ':') + 1);
+ *index(group, ':') = 0;
+ fprintf(out, "%s.filsys\tHS %s \"MUL", group, HTYPE);
+ EXEC SQL DECLARE f_cursor3 CURSOR FOR
+ SELECT DISTINCT f.label, g.key
+ FROM filesys f, fsgroup g
+ WHERE f.filsys_id = g.filsys_id AND g.group_id = :fid
+ ORDER BY key, label;
+ EXEC SQL OPEN f_cursor3;
+ while (1) {
+ EXEC SQL FETCH f_cursor3 INTO :name, :trans;
+ if (sqlca.sqlcode != 0) break;
+ fprintf(out, " %s", strtrim(name));
+ }
+ EXEC SQL CLOSE f_cursor3;
+ fprintf(out, "\"\n");
+ free(group);
+ }
+ sq_destroy(sq2);
+
EXEC SQL DECLARE a_cursor CURSOR FOR
SELECT name, trans
- FROM alias
- WHERE type = "FILESYS";
+ FROM alias
+ WHERE type = 'FILESYS';
EXEC SQL OPEN a_cursor;
while (1) {
EXEC SQL FETCH a_cursor INTO :name, :trans;
}
EXEC SQL CLOSE a_cursor;
#ifsql INGRES
+ EXEC SQL COMMIT;
#endsql
#ifsql INFORMIX
EXEC SQL COMMIT WORK;
EXEC SQL DECLARE p_cursor CURSOR FOR
SELECT mach_id, clu_id
- FROM mcmap;
+ FROM mcmap
+ ORDER BY mach_id;
EXEC SQL OPEN p_cursor;
while (1) {
EXEC SQL FETCH p_cursor INTO :mid, :cid;
}
free(machs);
#ifsql INGRES
+ EXEC SQL COMMIT;
#endsql
#ifsql INFORMIX
EXEC SQL COMMIT WORK;
}
EXEC SQL CLOSE p_cursor2;
#ifsql INGRES
+ EXEC SQL COMMIT;
#endsql
#ifsql INFORMIX
EXEC SQL COMMIT WORK;
EXEC SQL DECLARE a_cursor2 CURSOR FOR
SELECT name, trans
FROM alias
- WHERE type = "PALLADIUM";
+ WHERE type = 'PALLADIUM';
EXEC SQL OPEN a_cursor2;
while (1) {
EXEC SQL FETCH a_cursor2 INTO :name, :trans;
}
EXEC SQL CLOSE a_cursor2;
#ifsql INGRES
+ EXEC SQL COMMIT;
#endsql
#ifsql INFORMIX
EXEC SQL COMMIT WORK;
}
EXEC SQL CLOSE s_cursor;
#ifsql INGRES
+ EXEC SQL COMMIT;
#endsql
#ifsql INFORMIX
EXEC SQL COMMIT WORK;
EXEC SQL DECLARE a_cursor3 CURSOR FOR
SELECT name, trans
FROM alias
- WHERE type = "SERVICE";
+ WHERE type = 'SERVICE';
EXEC SQL OPEN a_cursor3;
while (1) {
EXEC SQL FETCH a_cursor3 INTO :service, :altserv;
}
EXEC SQL CLOSE a_cursor3;
#ifsql INGRES
+ EXEC SQL COMMIT;
#endsql
#ifsql INFORMIX
EXEC SQL COMMIT WORK;
andersk / moira.git / blobdiff