3 * This generates the zone files necessary to load a hesiod server.
4 * The following zones are generated: passwd, uid, pobox, group,
5 * grplist, gid, filsys, cluster, pcap, sloc, service.
7 * (c) Copyright 1988, 1990 by the Massachusetts Institute of Technology.
8 * For copying and distribution information, please see the file
12 #include <mit-copyright.h>
15 #include <moira_site.h>
16 #include <sys/types.h>
20 EXEC SQL INCLUDE sqlca;
24 #define HTYPE "UNSPECA"
29 /* max number of bytes of a data record that can be returned in a hesiod
30 * query. This is 512 - overhead (~66) [derived empirically]
32 #define MAXHESSIZE 446
36 #define min(x,y) ((x) < (y) ? (x) : (y))
37 struct hash *machines = NULL;
38 struct hash *users = NULL;
39 char *whoami = "hesiod.gen";
51 char *malloc(), *strsave();
63 fprintf(stderr, "usage: %s [outfile]\n", argv[0]);
67 initialize_sms_error_table ();
68 sprintf(hesiod_dir, "%s/hesiod", DCM_DIR);
71 EXEC SQL CONNECT moira;
72 EXEC SQL SET LOCKMODE SESSION WHERE LEVEL=TABLE, READLOCK=SHARED;
75 EXEC SQL DATABASE moira;
78 changed = do_passwd();
79 changed += do_filsys();
80 changed += do_cluster();
81 changed += do_printcap();
82 changed += do_palladium();
84 changed += do_service();
85 changed += do_groups();
91 EXEC SQL CLOSE DATABASE;
95 fprintf(stderr, "No files updated.\n");
96 if (argc == 2 && stat(argv[1], &sb) == 0)
101 fprintf(stderr, "Building tar file.\n");
102 sprintf(cmd, "cd %s; tar cf %s .", hesiod_dir, argv[1]);
113 EXEC SQL BEGIN DECLARE SECTION;
116 EXEC SQL END DECLARE SECTION;
121 machines = create_hash(1000);
122 EXEC SQL DECLARE m_cursor CURSOR FOR
125 WHERE status = 1 and mach_id != 0
127 EXEC SQL OPEN m_cursor;
129 EXEC SQL FETCH m_cursor INTO :name, :id;
130 if (sqlca.sqlcode != 0) break;
131 hash_store(machines, id, strsave(strtrim(name)));
133 if (sqlca.sqlcode < 0) db_error(sqlca.sqlcode);
134 EXEC SQL CLOSE m_cursor;
139 EXEC SQL COMMIT WORK;
146 FILE *pout, *uout, *bout;
147 char poutf[64], uoutf[64], poutft[64], uoutft[64], boutf[64], boutft[64];
148 struct stat psb, usb, bsb;
152 EXEC SQL BEGIN DECLARE SECTION;
153 char login[9], shell[33], fullname[33], oa[17], op[13], hp[17];
154 char nn[17], ptype[9];
155 int uid, flag1, flag2, id, pid, status;
156 EXEC SQL END DECLARE SECTION;
158 sprintf(poutf, "%s/passwd.db", hesiod_dir);
159 sprintf(uoutf, "%s/uid.db", hesiod_dir);
160 sprintf(boutf, "%s/pobox.db", hesiod_dir);
162 if (stat(poutf, &psb) == 0 && stat(uoutf, &usb) == 0 &&
163 stat(boutf, &bsb) == 0) {
164 ftime = min(min(psb.st_mtime, usb.st_mtime), bsb.st_mtime);
165 if (ModDiff (&flag1, "users", ftime) ||
166 ModDiff (&flag2, "machine", ftime))
168 if (flag1 < 0 && flag2 < 0) {
169 fprintf(stderr, "Files passwd.db, uid.db, and pobox.db do not need to be rebuilt.\n");
174 sprintf(poutft, "%s~", poutf);
175 pout = fopen(poutft, "w");
177 perror("cannot open passwd.db~ for write");
180 sprintf(uoutft, "%s~", uoutf);
181 uout = fopen(uoutft, "w");
183 perror("cannot open uid.db~ for write");
186 sprintf(boutft, "%s~", boutf);
187 bout = fopen(boutft, "w");
189 perror("cannot open pobox.db for write");
193 fprintf(stderr, "Building passwd.db, uid.db, and pobox.db\n");
196 users = create_hash(12001);
197 EXEC SQL DECLARE u_cursor CURSOR FOR
198 SELECT login, uid, shell, fullname, nickname, office_addr,
199 office_phone, home_phone, users_id, pop_id, potype, status
201 WHERE status = 1 or status = 5 or status = 6
203 EXEC SQL OPEN u_cursor;
205 EXEC SQL FETCH u_cursor INTO :login, :uid, :shell, :fullname, :nn,
206 :oa, :op, :hp, :id, :pid, :ptype, :status;
207 if (sqlca.sqlcode != 0) break;
215 u = (struct user *) malloc(sizeof(struct user));
216 strcpy(u->name, login);
218 hash_store(users, id, u);
220 fprintf(pout, "%s.passwd\tHS %s \"%s:*:%d:101:%s,%s,%s,%s,%s:/mit/%s:%s\"\n",
221 login, HTYPE, login, uid, fullname, nn, oa, op, hp,
223 fprintf(uout, "%d.uid\tHS CNAME %s.passwd\n", uid, login);
225 if (pid != 0 && (mach = hash_lookup(machines, pid))) {
226 fprintf(bout, "%s.pobox\tHS %s \"POP %s %s\"\n",
227 login, HTYPE, mach, login);
230 if (sqlca.sqlcode < 0) db_error(sqlca.sqlcode);
231 EXEC SQL CLOSE u_cursor;
236 EXEC SQL COMMIT WORK;
239 if (fclose(pout) || fclose(uout) || fclose(bout)) {
240 fprintf(stderr, "Unsuccessful file close of passwd.db, uid.db, or pobox.db\n");
252 FILE *iout, *gout, *lout;
253 char ioutf[64], goutf[64], loutf[64], buf[2048], *l;
255 register struct bucket *b, **p;
258 struct stat isb, gsb, lsb;
260 EXEC SQL BEGIN DECLARE SECTION;
262 int gid, id, lid, flag1, flag2, flag3, len;
263 EXEC SQL END DECLARE SECTION;
266 sprintf(ioutf, "%s/gid.db", hesiod_dir);
267 sprintf(goutf, "%s/group.db", hesiod_dir);
268 sprintf(loutf, "%s/grplist.db", hesiod_dir);
270 if (stat(ioutf, &isb) == 0 && stat(goutf, &gsb) == 0 && stat(loutf, &lsb) == 0) {
271 ftime = min(isb.st_mtime, min(gsb.st_mtime, lsb.st_mtime));
272 if (ModDiff (&flag1, "users", ftime) ||
273 ModDiff (&flag2, "list", ftime) ||
274 ModDiff (&flag3, "imembers", ftime))
276 if (flag1 < 0 && flag2 < 0 && flag3 < 0) {
277 fprintf(stderr, "Files gid.db, group.db and grplist.db do not need to be rebuilt.\n");
282 sprintf(buf, "%s~", ioutf);
283 iout = fopen(buf, "w");
285 perror("cannot open gid.db for write");
288 sprintf(buf, "%s~", goutf);
289 gout = fopen(buf, "w");
291 perror("cannot open group.db for write");
294 sprintf(buf, "%s~", loutf);
295 lout = fopen(buf, "w");
297 perror("cannot open grplist.db for write");
301 fprintf(stderr, "Building gid.db, group.db, and grplist.db\n");
303 /* make space for group list */
304 groups = create_hash(15001);
306 /* The following WHENEVER is declarative, not executed,
307 * and applies for the remainder of this file only.
309 EXEC SQL WHENEVER SQLERROR GOTO sqlerr;
311 /* get lock records */
312 EXEC SQL SELECT modtime INTO :name FROM imembers WHERE list_id = 0;
313 EXEC SQL SELECT modtime INTO :name FROM users WHERE users_id = 0;
314 EXEC SQL SELECT modtime INTO :name FROM list WHERE list_id = 0;
317 EXEC SQL DECLARE l_cursor CURSOR FOR
318 SELECT name, gid, list_id
320 WHERE grouplist != 0 AND active != 0
322 EXEC SQL OPEN l_cursor;
324 EXEC SQL FETCH l_cursor INTO :name, :gid, :lid;
325 if (sqlca.sqlcode != 0) break;
327 sprintf(buf, "%s:%d", name, gid);
328 hash_store(groups, lid, strsave(buf));
329 fprintf(iout, "%d.gid\tHS CNAME %s.group\n", gid, name);
330 fprintf(gout, "%s.group\tHS %s \"%s:*:%d:\"\n",
331 name, HTYPE, name, gid);
333 EXEC SQL CLOSE l_cursor;
338 /* now do grplists */
340 users = create_hash(12001);
341 EXEC SQL DECLARE u_cursor2 CURSOR FOR
342 SELECT users_id, login
346 EXEC SQL OPEN u_cursor2;
348 EXEC SQL FETCH u_cursor2 INTO :id, :name;
349 if (sqlca.sqlcode != 0) break;
350 u = (struct user *) malloc(sizeof(struct user));
351 strcpy(u->name, strtrim(name));
353 hash_store(users, id, u);
355 EXEC SQL CLOSE u_cursor2;
358 EXEC SQL DECLARE i_cursor CURSOR FOR
359 SELECT list_id, member_id
361 WHERE member_type = 'USER'
363 EXEC SQL OPEN i_cursor;
365 EXEC SQL FETCH i_cursor INTO :lid, :id;
366 if (sqlca.sqlcode != 0) break;
367 if (((l = hash_lookup(groups, lid)) != NULL) &&
368 (u = (struct user *) hash_lookup(users, id))) {
369 g = (struct grp *) malloc(sizeof(struct grp));
375 EXEC SQL CLOSE i_cursor;
380 EXEC SQL COMMIT WORK;
383 for (p = &(users->data[users->size - 1]); p >= users->data; p--) {
384 for (b = *p; b; b = b->next) {
385 if ((g = ((struct user *)b->data)->lists) == NULL)
387 fprintf(lout, "%s.grplist\tHS %s \"",
388 ((struct user *)b->data)->name, HTYPE);
390 for (; g; g = g->next) {
391 if (len + strlen(g->lid) + 1 < MAXHESSIZE) {
395 len += strlen(g->lid) + 1;
397 com_err(whoami, 0, "truncated grp list for user %s",
398 ((struct user *)b->data)->name);
406 if (fclose(iout) || fclose(gout) || fclose(lout)) {
407 fprintf(stderr, "Unsuccessful close of gid.db, group.db, or grplist.db\n");
415 db_error(sqlca.sqlcode);
423 char outf[64], outft[64], *mach, *group;
427 struct save_queue *sq, *sq2, *sq_create();
428 EXEC SQL BEGIN DECLARE SECTION;
429 char name[33], type[9], loc[81], access[2], mount[33], trans[257];
431 int flag1, flag2, flag3, flag4, id, fid;
432 EXEC SQL END DECLARE SECTION;
435 sprintf(outf, "%s/filsys.db", hesiod_dir);
437 if (stat(outf, &sb) == 0) {
440 if (ModDiff(&flag1, "filesys", ftime)) exit (MR_DATE);
441 if (ModDiff(&flag2, "machine", ftime)) exit (MR_DATE);
442 if (ModDiff(&flag3, "alias", ftime)) exit (MR_DATE);
443 if (ModDiff(&flag4, "fsgroup", ftime)) exit (MR_DATE);
445 if (flag1 < 0 && flag2 < 0 && flag3 < 0 && flag4 < 0) {
446 fprintf(stderr, "File filsys.db does not need to be rebuilt.\n");
451 sprintf(outft, "%s~", outf);
452 out = fopen(outft, "w");
454 perror("cannot open filsys.db for write");
458 fprintf(stderr, "Building filsys.db\n");
463 /* get lock records */
465 EXEC SQL SELECT modtime INTO :name from filesys where filsys_id = 0;
466 EXEC SQL SELECT modtime INTO :name from fsgroup where filsys_id = 0;
468 EXEC SQL DECLARE f_cursor CURSOR FOR
469 SELECT label, type, name, mach_id, access, mount, comments, filsys_id
472 EXEC SQL OPEN f_cursor;
474 EXEC SQL FETCH f_cursor INTO :name, :type, :loc, :id, :access,
475 :mount, :comments, :fid;
476 if (sqlca.sqlcode != 0) break;
478 if (!strcmp(type, "NFS") || !strcmp(type, "RVD")) {
479 if (mach = hash_lookup(machines, id)) {
480 fprintf(out, "%s.filsys\tHS %s \"%s %s %s %s %s\"\n",
481 strtrim(name), HTYPE, type, strtrim(loc), mach,
482 strtrim(access), strtrim(mount));
484 } else if (!strcmp(type, "AFS")) {
485 fprintf(out, "%s.filsys\tHS %s \"AFS %s %s %s\"\n",
486 strtrim(name), HTYPE, strtrim(loc), strtrim(access),
488 } else if (!strcmp(type, "ERR")) {
489 fprintf(out, "%s.filsys\tHS %s \"ERR %s\"\n",
490 strtrim(name), HTYPE, strtrim(comments));
491 } else if (!strcmp(type, "FSGROUP")) {
492 sprintf(trans, "%s:%d", strtrim(name), fid);
493 sq_save_data(sq, strsave(trans));
494 } else if (!strcmp(type, "MUL")) {
495 sprintf(trans, "%s:%d", strtrim(name), fid);
496 sq_save_data(sq2, strsave(trans));
499 EXEC SQL CLOSE f_cursor;
501 while (sq_get_data(sq, &group)) {
502 fid = atoi(index(group, ':')+1);
503 *index(group, ':') = 0;
505 EXEC SQL DECLARE f_cursor2 CURSOR FOR
506 SELECT DISTINCT f.type, f.name, f.mach_id, f.access, f.mount,
507 f.comments, f.label, g.key
508 FROM filesys f, fsgroup g
509 WHERE f.filsys_id = g.filsys_id AND g.group_id = :fid
511 EXEC SQL OPEN f_cursor2;
513 EXEC SQL FETCH f_cursor2 INTO :type, :loc, :id, :access,:mount,
514 :comments, :name, :trans;
515 if (sqlca.sqlcode != 0) break;
517 if (!strcmp(type, "NFS") || !strcmp(type, "RVD")) {
518 if (mach = hash_lookup(machines, id)) {
519 fprintf(out, "%s.filsys\tHS %s \"%s %s %s %s %s\"\n",
520 group, HTYPE, type, strtrim(loc), mach,
521 strtrim(access), strtrim(mount));
523 } else if (!strcmp(type, "AFS")) {
524 fprintf(out, "%s.filsys\tHS %s \"AFS %s %s %s\"\n",
525 group, HTYPE, strtrim(loc), strtrim(access),
527 } else if (!strcmp(type, "ERR")) {
528 fprintf(out, "%s.filsys\tHS %s \"ERR %s\"\n",
529 group, HTYPE, strtrim(comments));
532 EXEC SQL CLOSE f_cursor2;
537 while (sq_get_data(sq2, &group)) {
538 fid = atoi(index(group, ':') + 1);
539 *index(group, ':') = 0;
540 fprintf(out, "%s.filsys\tHS %s \"MUL", group, HTYPE);
541 EXEC SQL DECLARE f_cursor3 CURSOR FOR
542 SELECT DISTINCT f.label, g.key
543 FROM filesys f, fsgroup g
544 WHERE f.filsys_id = g.filsys_id AND g.group_id = :fid
546 EXEC SQL OPEN f_cursor3;
548 EXEC SQL FETCH f_cursor3 INTO :name, :trans;
549 if (sqlca.sqlcode != 0) break;
550 fprintf(out, " %s", strtrim(name));
552 EXEC SQL CLOSE f_cursor3;
553 fprintf(out, "\"\n");
558 EXEC SQL DECLARE a_cursor CURSOR FOR
561 WHERE type = 'FILESYS';
562 EXEC SQL OPEN a_cursor;
564 EXEC SQL FETCH a_cursor INTO :name, :trans;
565 if (sqlca.sqlcode != 0) break;
566 fprintf(out, "%s.filsys\tHS CNAME %s.filsys\n",
567 strtrim(name), strtrim(trans));
569 EXEC SQL CLOSE a_cursor;
574 EXEC SQL COMMIT WORK;
578 fprintf(stderr, "Unsuccessful close of filsys.db\n");
584 db_error(sqlca.sqlcode);
590 * Modified from sys/types.h:
592 int setsize; /* = howmany(setbits, NSETBITS) */
594 typedef long set_mask;
595 #define NSETBITS (sizeof(set_mask) * NBBY) /* bits per mask */
597 #define howmany(x, y) (((x)+((y)-1))/(y))
600 #define SET_SET(n, p) ((p)[(n)/NSETBITS] |= (1 << ((n) % NSETBITS)))
601 #define SET_CLR(n, p) ((p)[(n)/NSETBITS] &= ~(1 << ((n) % NSETBITS)))
602 #define SET_ISSET(n, p) ((p)[(n)/NSETBITS] & (1 << ((n) % NSETBITS)))
603 #define SET_CREATE() ((set_mask *)malloc(setsize * sizeof(set_mask)))
604 #define SET_ZERO(p) bzero((char *)(p), setsize * sizeof(set_mask))
605 #define SET_CMP(p1, p2) (bcmp((p1), (p2), setsize * sizeof(set_mask)))
612 for (i = 0; i < setsize * NSETBITS; i++)
613 if (SET_ISSET(i, set))
622 char outf[64], outft[64], *mach, machbuf[41], *p;
625 EXEC SQL BEGIN DECLARE SECTION;
626 int flag1, flag2, flag3, flag4, maxmach, maxclu, mid, cid, id;
627 char name[41], label2[17], data[33];
628 EXEC SQL END DECLARE SECTION;
629 set_mask **machs, *ms, *ps;
632 sprintf(outf, "%s/cluster.db", hesiod_dir);
634 if (stat(outf, &sb) == 0) {
636 if (ModDiff (&flag1, "cluster", ftime)
637 || ModDiff (&flag2, "machine", ftime)
638 || ModDiff (&flag3, "mcmap", ftime)
639 || ModDiff (&flag4, "svc", ftime)) exit (MR_DATE);
640 if (flag1 < 0 && flag2 < 0 && flag3 < 0 && flag4 < 0) {
641 fprintf(stderr, "File cluster.db does not need to be rebuilt.\n");
646 sprintf(outft, "%s~", outf);
647 out = fopen(outft, "w");
649 perror("cannot open cluster.db for write");
653 fprintf(stderr, "Building cluster.db\n");
656 /* get lock records */
657 EXEC SQL SELECT modtime INTO :name FROM machine where mach_id = 0;
658 EXEC SQL SELECT modtime INTO :name FROM cluster where clu_id = 0;
659 EXEC SQL SELECT modtime INTO :name FROM mcmap where mach_id = 0;
660 EXEC SQL SELECT modtime INTO :name FROM svc where clu_id = 0;
662 EXEC SQL SELECT MAX(clu_id) INTO :maxclu FROM cluster;
664 setsize = howmany(maxclu, NSETBITS);
666 EXEC SQL SELECT MAX(mach_id) INTO :maxmach FROM machine;
668 machs = (set_mask **)malloc((maxmach + 1) * sizeof(set_mask **));
669 bzero(machs, (maxmach + 1) * sizeof(int));
671 EXEC SQL DECLARE p_cursor CURSOR FOR
672 SELECT mach_id, clu_id
675 EXEC SQL OPEN p_cursor;
677 EXEC SQL FETCH p_cursor INTO :mid, :cid;
678 if (sqlca.sqlcode != 0) break;
679 if (!(ms = machs[mid])) {
680 ms = machs[mid] = SET_CREATE();
685 EXEC SQL CLOSE p_cursor;
687 for (mid = 1; mid < maxmach; mid++) {
691 if (nbitsset(ms) > 1) {
693 for (cid = 1; cid < maxclu; cid++) {
694 if (SET_ISSET(cid, ms)) {
695 EXEC SQL DECLARE d_cursor CURSOR FOR
696 SELECT serv_label, serv_cluster
699 EXEC SQL OPEN d_cursor;
701 EXEC SQL FETCH d_cursor INTO :label2, :data;
702 if (sqlca.sqlcode != 0) break;
706 "mrinternal-%d.cluster\tHS %s \"%s %s\"\n",
707 mid, HTYPE, label2, data);
709 EXEC SQL CLOSE d_cursor;
714 for (cid = 1; cid < maxclu; cid++)
715 if (SET_ISSET(cid, ms)) break;
717 EXEC SQL SELECT name INTO :name FROM cluster WHERE clu_id = :cid;
721 if (mach = hash_lookup(machines, mid)) {
722 for (p = machbuf; *mach && *mach != '.'; mach++)
726 fprintf(out, "%s.cluster\tHS CNAME %s.cluster\n",
729 fprintf(out, "%s.cluster\tHS CNAME mrinternal-%d.cluster\n",
732 for (id = mid + 1; id < maxmach; id++) {
733 if ((ps = machs[id]) && !SET_CMP(ms, ps)) {
736 if (mach = hash_lookup(machines, id)) {
737 for (p = machbuf; *mach && *mach != '.'; mach++)
741 fprintf(out, "%s.cluster\tHS CNAME %s.cluster\n",
745 "%s.cluster\tHS CNAME mrinternal-%d.cluster\n",
754 EXEC SQL DECLARE d_cursor2 CURSOR FOR
755 SELECT c.name, d.serv_label, d.serv_cluster
756 FROM svc d, cluster c
757 WHERE c.clu_id = d.clu_id;
758 EXEC SQL OPEN d_cursor2;
760 EXEC SQL FETCH d_cursor2 INTO :name, :label2, :data;
761 if (sqlca.sqlcode != 0) break;
765 fprintf(out, "%s.cluster\tHS %s \"%s %s\"\n",
766 name, HTYPE, label2, data);
773 EXEC SQL COMMIT WORK;
777 fprintf(stderr, "Unsuccessful close of cluster.db\n");
783 db_error(sqlca.sqlcode);
791 char outf[64], outft[64];
794 EXEC SQL BEGIN DECLARE SECTION;
795 char name[17], rp[17], sd[33];
796 int flag1, flag2, ka, pc, rm, rq;
797 EXEC SQL END DECLARE SECTION;
799 sprintf(outf, "%s/printcap.db", hesiod_dir);
801 if (stat(outf, &sb) == 0) {
803 if (ModDiff (&flag1, "printcap", ftime)
804 || ModDiff (&flag2, "machine", ftime))
806 if (flag1 < 0 && flag2 < 0) {
807 fprintf(stderr, "File printcap.db does not need to be rebuilt.\n");
812 sprintf(outft, "%s~", outf);
813 out = fopen(outft, "w");
815 perror("cannot open printcap.db for write");
819 fprintf(stderr, "Building printcap.db\n");
822 EXEC SQL DECLARE p_cursor2 CURSOR FOR
823 SELECT name, rp, dir, mach_id, auth, price, quotaserver
825 EXEC SQL OPEN p_cursor2;
827 EXEC SQL FETCH p_cursor2 INTO :name, :rp, :sd, :rm, :ka, :pc, :rq;
828 if (sqlca.sqlcode != 0) break;
832 fprintf(out, "%s.pcap\tHS %s \"%s:rp=%s:rm=%s:sd=%s:ka#%d:pc#%d",
833 name, HTYPE, name, rp, hash_lookup(machines, rm), sd, ka, pc);
835 fprintf(out, ":rq=%s\"\n", hash_lookup(machines, rq));
839 EXEC SQL CLOSE p_cursor2;
844 EXEC SQL COMMIT WORK;
848 fprintf(stderr, "Unsuccessful close of pcap.db\n");
854 db_error(sqlca.sqlcode);
862 char outf[64], outft[64];
865 EXEC SQL BEGIN DECLARE SECTION;
866 char name[33], trans[129];
867 int flag, flag1, ident, rm;
868 EXEC SQL END DECLARE SECTION;
870 sprintf(outf, "%s/palladium.db", hesiod_dir);
872 if (stat(outf, &sb) == 0) {
874 if ((ModDiff (&flag, "palladium", ftime)) ||
875 (ModDiff (&flag1, "alias", ftime))) exit (MR_DATE);
876 if (flag < 0 && flag1 < 0) {
877 fprintf(stderr, "File palladium.db does not need to be rebuilt.\n");
882 sprintf(outft, "%s~", outf);
883 out = fopen(outft, "w");
885 perror("cannot open palladium.db for write");
889 fprintf(stderr, "Building palladium.db\n");
892 EXEC SQL DECLARE p_cursor3 CURSOR FOR
893 SELECT name, ident, mach_id
895 EXEC SQL OPEN p_cursor3;
897 EXEC SQL FETCH p_cursor3 INTO :name, :ident, :rm;
898 if (sqlca.sqlcode != 0) break;
901 "%s.palladium\tHS %s \"%s %d %s interface directory\"\n",
902 name, HTYPE, hash_lookup(machines, rm), ident, name);
904 EXEC SQL CLOSE p_cursor3;
906 EXEC SQL DECLARE a_cursor2 CURSOR FOR
909 WHERE type = 'PALLADIUM';
910 EXEC SQL OPEN a_cursor2;
912 EXEC SQL FETCH a_cursor2 INTO :name, :trans;
913 if (sqlca.sqlcode != 0) break;
916 fprintf(out, "%s.palladium\tHS %s \"%s\"\n", name, HTYPE, trans);
918 EXEC SQL CLOSE a_cursor2;
923 EXEC SQL COMMIT WORK;
927 fprintf(stderr, "Unsuccessful close of palladium.db\n");
933 db_error(sqlca.sqlcode);
941 char outf[64], outft[64], *mach;
944 EXEC SQL BEGIN DECLARE SECTION;
946 int flag1, flag2, id;
947 EXEC SQL END DECLARE SECTION;
949 sprintf(outf, "%s/sloc.db", hesiod_dir);
951 if (stat(outf, &sb) == 0) {
953 if ((ModDiff (&flag1, "serverhosts", ftime)) ||
954 (ModDiff (&flag2, "machine", ftime))) exit (MR_DATE);
955 if (flag1 < 0 && flag2 < 0) {
956 fprintf(stderr, "File sloc.db does not need to be rebuilt.\n");
961 sprintf(outft, "%s~", outf);
962 out = fopen(outft, "w");
964 perror("cannot open sloc.db for write");
968 fprintf(stderr, "Building sloc.db\n");
971 EXEC SQL DECLARE s_cursor CURSOR FOR
972 SELECT DISTINCT service, mach_id
975 EXEC SQL OPEN s_cursor;
977 EXEC SQL FETCH s_cursor INTO :service, :id;
978 if (sqlca.sqlcode != 0) break;
980 if (mach = hash_lookup(machines, id))
981 fprintf(out, "%s.sloc\tHS %s %s\n", service, HTYPE, mach);
983 EXEC SQL CLOSE s_cursor;
988 EXEC SQL COMMIT WORK;
992 fprintf(stderr, "Unsuccessful close of sloc.db\n");
999 db_error(sqlca.sqlcode);
1006 char outf[64], outft[64];
1009 EXEC SQL BEGIN DECLARE SECTION;
1010 char service[33], protocol[9], altserv[129];
1012 EXEC SQL END DECLARE SECTION;
1014 sprintf(outf, "%s/service.db", hesiod_dir);
1016 if (stat(outf, &sb) == 0) {
1017 ftime = sb.st_mtime;
1018 if (ModDiff (&flag1, "services", ftime)) exit (MR_DATE);
1020 fprintf(stderr, "File service.db does not need to be rebuilt.\n");
1025 sprintf(outft, "%s~", outf);
1026 out = fopen(outft, "w");
1028 perror("cannot open service.db for write");
1032 fprintf(stderr, "Building service.db\n");
1034 EXEC SQL DECLARE s_cursor2 CURSOR FOR
1035 SELECT name, protocol, port
1037 EXEC SQL OPEN s_cursor2;
1039 EXEC SQL FETCH s_cursor2 INTO :service, :protocol, :port;
1040 if (sqlca.sqlcode != 0) break;
1041 lowercase(protocol); /* Convert protocol to lowercase */
1044 fprintf(out, "%s.service\tHS %s \"%s %s %d\"\n",
1045 service, HTYPE, service, protocol, port);
1047 EXEC SQL CLOSE s_cursor2;
1049 EXEC SQL DECLARE a_cursor3 CURSOR FOR
1052 WHERE type = 'SERVICE';
1053 EXEC SQL OPEN a_cursor3;
1055 EXEC SQL FETCH a_cursor3 INTO :service, :altserv;
1056 if (sqlca.sqlcode != 0) break;
1059 fprintf(out, "%s.service\tHS CNAME %s.service\n", service, altserv);
1061 EXEC SQL CLOSE a_cursor3;
1066 EXEC SQL COMMIT WORK;
1070 fprintf(stderr, "Unsuccessful close of service.db\n");
1076 db_error(sqlca.sqlcode);