#define FALSE 0
#define TRUE (!FALSE)
+FILE *out = stdout;
+
struct hash *users, *machines, *strings, *lists;
struct user {
char *login;
char *description;
char acl_t;
int acl_id;
+ char mailman;
+ char *mailman_server;
struct member *m;
};
void get_info(void);
+void save_mlist(int id, void *list, void *force);
int check_string(char *s);
void output_login(int dummy, void *names, void *out);
-void output_mlist(int id, void *list, void *out);
-void output_membership(struct list *l, FILE *out);
+void output_mlist(int id, struct list *l);
void put_fill(FILE *aliases, char *string);
void do_people(void);
{
time_t tm = time(NULL);
char filename[MAXPATHLEN], *targetfile;
- struct stat sb;
- int flag1, flag2;
- FILE *out = stdout;
- srand(tm);
EXEC SQL CONNECT :db;
if (argc == 2)
{
- if (stat(argv[1], &sb) == 0)
- {
- if (ModDiff(&flag1, "users", sb.st_mtime) ||
- ModDiff(&flag2, "list", sb.st_mtime))
- exit(MR_DATE);
- if (flag1 < 0 && flag2 < 0)
- {
- fprintf(stderr, "File %s does not need to be rebuilt.\n",
- argv[1]);
- exit(MR_NO_CHANGE);
- }
- }
targetfile = argv[1];
sprintf(filename, "%s~", targetfile);
if (!(out = fopen(filename, "w")))
incount = 0;
fprintf(out, "\n%s\n# Mailing lists\n%s\n\n", divide, divide);
- hash_step(lists, output_mlist, out);
+ hash_step(lists, save_mlist, FALSE);
fprintf(stderr, "Output %d lists\n", incount);
incount = 0;
void get_info(void)
{
EXEC SQL BEGIN DECLARE SECTION;
- int id, pid, iid, bid, cnt, maillistp, acl, mid;
+ int id, pid, iid, bid, eid, cnt, maillistp, acl, mid, mailman;
char mname[MACHINE_NAME_SIZE], str[STRINGS_STRING_SIZE];
char login[USERS_LOGIN_SIZE], potype[USERS_POTYPE_SIZE];
char lname[LIST_NAME_SIZE], desc[LIST_DESCRIPTION_SIZE];
- char type[LIST_ACL_TYPE_SIZE];
+ char type[LIST_ACL_TYPE_SIZE], mailman_server[MACHINE_NAME_SIZE];
EXEC SQL END DECLARE SECTION;
char *s;
struct user *u;
WHERE status = 1
AND ( mach_id IN ( SELECT UNIQUE pop_id FROM users ) OR
mach_id IN ( SELECT UNIQUE mach_id FROM filesys
- WHERE type = 'IMAP' ) )
+ WHERE type = 'IMAP' ) )
ORDER BY mach_id;
EXEC SQL OPEN m_cursor;
while (1)
}
EXEC SQL CLOSE m_cursor;
+ EXEC SQL DECLARE e_cursor CURSOR FOR
+ SELECT mach_id, name
+ FROM machine
+ WHERE status = 1
+ AND mach_id in (SELECT UNIQUE exchange_id FROM users)
+ ORDER BY mach_id;
+ EXEC SQL OPEN e_cursor;
+ while (1)
+ {
+ EXEC SQL FETCH e_cursor INTO :id, :mname;
+ if (sqlca.sqlcode)
+ break;
+ strtrim(mname);
+ if (hash_store(machines, id, strdup(mname)) < 0)
+ {
+ fprintf(stderr, "Out of memory!\n");
+ exit(MR_NO_MEM);
+ }
+ cnt++;
+ }
+ EXEC SQL CLOSE e_cursor;
+
fprintf(stderr, "Loaded %d machines\n", cnt);
cnt = 0;
users = create_hash(13001);
EXEC SQL DECLARE u_cursor CURSOR FOR
- SELECT users_id, login, potype, pop_id, imap_id, box_id
+ SELECT users_id, login, potype, pop_id, imap_id, box_id, exchange_id
FROM users
WHERE status != 3
ORDER BY users_id;
{
char *saddr = NULL, *paddr = NULL;
- EXEC SQL FETCH u_cursor INTO :id, :login, :potype, :pid, :iid, :bid;
+ EXEC SQL FETCH u_cursor INTO :id, :login, :potype, :pid, :iid, :bid,
+ :eid;
if (sqlca.sqlcode)
break;
u = malloc(sizeof(struct user));
/* If SMTP, clear pid and iid. */
if (potype[1] == 'M')
- pid = iid = 0;
+ pid = iid = eid = 0;
}
/* If IMAP, or SPLIT with IMAP, set pid to mach_id. */
WHERE filsys_id = :iid;
}
+ /* If EXCHANGE or SPLIT with EXCHANGE, set pid to eid. */
+ if (potype[0] == 'E' || (potype[0] == 'S' && eid))
+ pid = eid;
+
if (pid && (s = hash_lookup(machines, pid)))
{
paddr = malloc(strlen(u->login) + strlen(s) + 2);
lists = create_hash(15000);
EXEC SQL DECLARE l_cursor CURSOR FOR
- SELECT list_id, name, maillist, description, acl_type, acl_id
- FROM list
- WHERE active != 0
+ SELECT l.list_id, l.name, l.maillist, l.description, l.acl_type, l.acl_id,
+ l.mailman, m.name
+ FROM list l, machine m
+ WHERE active != 0 AND l.mailman_id = m.mach_id
ORDER BY list_id;
EXEC SQL OPEN l_cursor;
while (1)
{
- EXEC SQL FETCH l_cursor INTO :id, :lname, :maillistp, :desc, :type, :acl;
+ EXEC SQL FETCH l_cursor INTO :id, :lname, :maillistp, :desc, :type, :acl,
+ :mailman, :mailman_server;
if (sqlca.sqlcode)
break;
l = malloc(sizeof(struct list));
l->description = strdup(strtrim(desc));
l->acl_t = type[0];
l->acl_id = acl;
+ l->mailman = mailman;
+ l->mailman_server = strdup(strtrim(mailman_server));
l->m = NULL;
if (hash_store(lists, id, l) < 0)
{
}
-void output_login(int dummy, void *user, void *out)
-{
- struct user *u = user;
-
- incount++;
- if (u->pobox && check_string(u->login) && u->login[0] != '#')
- fprintf(out, "%s: %s\n", u->login, u->pobox);
-}
-
-int line_width, alias_width;
-
-void output_mlist(int id, void *list, void *out)
+void save_mlist(int id, void *list, void *force)
{
+ struct member *m;
struct list *l = list, *l1;
- struct user *u;
- int len = strlen(l->name);
- if (!l->maillist || !check_string(l->name))
+ if (l->maillist > 1 || (l->maillist == 0 && !force) ||
+ !check_string(l->name))
return;
- /* If standard user group appears on a list, substitute in the user. */
+ /* If user group appears on list, replace with user. */
if (l->m && l->m->next == NULL && !strcasecmp(l->name, l->m->name))
- return;
+ {
+ l->maillist = 3;
+ return;
+ }
+ l->maillist = 2;
+ output_mlist(id, l);
- put_fill(out, l->description);
+ if (l->acl_t == 'L' && (l1 = hash_lookup(lists, l->acl_id)))
+ save_mlist(0, l1, (void *)TRUE);
- if (l->acl_t == 'L' && (l1 = hash_lookup(lists, l->acl_id)))
+ for (m = l->m; m; m = m->next)
{
- fprintf(out, "owner-%s: ", l->name);
- if ((l1->maillist) && (strcmp(l->name, l1->name)))
- fprintf(out, "%s\n", l1->name);
- else
- {
- alias_width = line_width = len + 8;
- output_membership(l1, out);
- fprintf(out, "\n");
- }
+ if (m->list_id && (l1 = hash_lookup(lists, m->list_id)))
+ save_mlist(0, l1, (void *)TRUE);
}
- else if (l->acl_t == 'U' && (u = hash_lookup(users, l->acl_id)))
- fprintf(out, "owner-%s: %s\n", l->name, u->login);
+}
+
+void output_login(int dummy, void *user, void *out)
+{
+ struct user *u = user;
- fprintf(out, "%s: ", l->name);
- alias_width = line_width = len + 2;
- output_membership(l, out);
- fprintf(out, "\n\n");
incount++;
+ if (u->pobox && check_string(u->login) && u->login[0] != '#')
+ fprintf(out, "%s: %s\n", u->login, u->pobox);
}
-void output_membership(struct list *l, FILE *out)
+static const char *mailman_suffixes[] = { "-admin", "-owner", "-request",
+ "-bounces", "-confirm", "-join",
+ "-leave", "-subscribe",
+ "-unsubscribe", NULL };
+
+void output_mlist(int id, struct list *l)
{
- struct member *m;
struct list *l1;
- int word_width, linestart = 1;
+ struct member *m;
+ struct user *u;
+ int line_width, alias_width, word_width, beginning;
static int cont = 1;
char str[8];
+ int i;
+
+ put_fill(out, l->description);
+
+ if (l->mailman && strcmp(l->mailman_server, "[NONE]"))
+ {
+ for (i = 0; mailman_suffixes[i]; i++)
+ fprintf(out, "%s%s: %s%s@%s\n", l->name, mailman_suffixes[i], l->name,
+ mailman_suffixes[i], l->mailman_server);
+ fprintf(out, "owner-%s: %s-owner@%s\n%s: ", l->name, l->name,
+ l->mailman_server, l->name);
+ }
+ else if (l->acl_t == 'L' && (l1 = hash_lookup(lists, l->acl_id)))
+ fprintf(out, "owner-%s: %s\n%s: ", l->name, l1->name, l->name);
+ else if (l->acl_t == 'U' && (u = hash_lookup(users, l->acl_id)))
+ fprintf(out, "owner-%s: %s\n%s: ", l->name, u->login, l->name);
+ else
+ fprintf(out, "%s: ", l->name);
+ alias_width = line_width = strlen(l->name) + 2;
+ beginning = 1;
for (m = l->m; m; m = m->next)
{
word_width = strlen(m->name);
- if (!linestart && alias_width + word_width + 2 > MAX_ALIAS_WIDTH)
+ if (!beginning && alias_width + word_width + 2 > MAX_ALIAS_WIDTH)
{
/* Make a continuation. */
sprintf(str, "%c%c%c%c%c%c", rand() % 26 + 97, rand() % 26 + 97,
fprintf(out, ",\n\tcont%d-%s\ncont%d-%s: ", cont, str, cont, str);
cont++;
alias_width = line_width = 17 + word_width;
+ fputs(m->name, out);
}
- else if (linestart)
+ else if (beginning)
{
- /* First word on line, so we can't wrap. */
+ /* Beginning of alias, so don't wrap. */
line_width += word_width;
alias_width = line_width;
- linestart = 0;
+ fputs(m->name, out);
+ beginning = 0;
}
else if (line_width + word_width + 2 > MAX_LINE_WIDTH)
{
/* Wrap. */
- fputs(",\n\t", out);
+ fprintf(out, ",\n\t%s", m->name);
alias_width += line_width + word_width + 2;
line_width = word_width + 8;
}
{
/* Continue line. */
line_width += word_width + 2;
- fputs(", ", out);
+ fprintf(out, ", %s", m->name);
}
-
- if (m->list_id && (l1 = hash_lookup(lists, m->list_id)) && !l1->maillist)
- output_membership(l1, out);
- else
- fputs(m->name, out);
}
if (!l->m)
fprintf(out, "/dev/null");
+ fprintf(out, "\n\n");
+ incount++;
}
/* Write a word-wrapped list description to the aliases file as a
}
-/* Illegal chars: this should correspond to the array used by
- * setup_alis. */
+/* Illegal chars: this no longer corresponds to the array
+ * in setup_alis. '+' is a valid character in a string on
+ * a list, but is not a valid character in a listname.
+ */
static int illegalchars[] = {
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, /* ^@ - ^O */