3 * This program will bulk sign user records in the database.
11 #include <moira_site.h>
16 EXEC SQL INCLUDE sqlca;
25 char buf[BUFSIZ], *data, *p;
26 struct save_queue *sq;
28 int found, status, i, wait;
29 EXEC SQL BEGIN DECLARE SECTION;
30 char login[10], mid[32], rawsig[256], *db="moira";
31 int id, timestamp, sms;
32 EXEC SQL END DECLARE SECTION;
37 initialize_gdss_error_table();
39 for (i = 1; i < argc; i++) {
40 if (!strcmp(argv[i], "-w"))
42 else if (!strcmp(argv[i], "-D"))
43 setenv("ING_SET", "set printqry");
45 fprintf(stderr, "Usage: %s [-w] [-D]\n", argv[0]);
48 /* Set the name of our kerberos ticket file */
49 krb_set_tkt_string("/tmp/tkt_sign");
52 printf("Authenticating as moira.extra:\n");
53 status = krb_get_pw_in_tkt("moira", "extra", "ATHENA.MIT.EDU",
54 "krbtgt", "ATHENA.MIT.EDU",
57 com_err(program, status + krb_err_base, " in krb_get_pw_in_tkt");
60 EXEC SQL CONNECT :db IDENTIFIED BY :db;
61 if (sqlca.sqlcode != 0) {
62 com_err(program, 0, "dbms error %d", sqlca.sqlcode);
67 EXEC SQL SELECT string_id INTO :sms FROM strings
68 WHERE string='moira.extra@ATHENA.MIT.EDU';
70 com_err(program, 0, " failed to find string moira.extra@ATHENA.MIT.EDU in database");
78 EXEC SQL DECLARE c CURSOR FOR
79 SELECT users_id, login, clearid
80 FROM users WHERE signature = CHR(0);
81 if (sqlca.sqlcode != 0) {
82 com_err(program, 0, "dbms error %d", sqlca.sqlcode);
86 if (sqlca.sqlcode != 0) {
87 com_err(program, 0, "dbms error %d", sqlca.sqlcode);
91 EXEC SQL FETCH c INTO :id, :login, :mid;
92 if (sqlca.sqlcode != 0) break;
93 if (login[0] == '#' || !isdigit(mid[0]))
95 sprintf(buf, "%d:%s:%s", id, strtrim(login), strtrim(mid));
96 sq_save_data(sq, strsave(buf));
100 EXEC SQL COMMIT WORK;
101 printf("Found %d users to sign.\n", found);
103 si.rawsig = (unsigned char *) &rawsig[0];
105 while (sq_get_data(sq, &data)) {
106 p = strchr(data, ':');
108 com_err(program, 0, " malformatted data");
115 status = GDSS_Sign(data, strlen(data), buf);
117 com_err(program, gdss2et(status), "signing data");
120 status = GDSS_Verify(data, strlen(data), buf, &si);
122 com_err(program, gdss2et(status), "verifying data");
125 if (strlen(rawsig) > 68) {
130 timestamp = si.timestamp;
131 EXEC SQL UPDATE users
132 SET signature = :rawsig, sigwho = :sms, sigdate = :timestamp
133 WHERE users_id = :id;
134 if (sqlca.sqlcode != 0) {
135 com_err(program, 0, "dbms error %d", sqlca.sqlcode);
138 EXEC SQL COMMIT WORK;