ip-billing.sh ldap.gen longjobs.gen longjobs.sh mailhub.sh \
mailman.gen mailman.sh nagios-printers.gen nagios-printers.sh ndb.sh \
nfs.sh null.sh postoffice.sh print.sh sapprint.gen sapprint.sh \
- spwatch.gen tsm.gen warehouse.gen warehouse.sh winstats.gen winstats.sh \
+ spwatch.gen tsm.gen tsm.sh warehouse.gen warehouse.sh winstats.gen winstats.sh \
www.sh zephyr.sh install_dirs install_quotas zero_quotas
.SUFFIXES: .pc .gen
while (($root_list_id, $hostname) = $sth0->fetchrow_array) {
open(OUT, ">$outdir/$hostname");
+ $sth = $dbh->prepare("SELECT l.name, l.gid FROM list l " .
+ "WHERE l.list_id = " .
+ $dbh->quote($root_list_id)) ||
+ exit $MR_DBMS_ERR;
+ $sth->execute;
+
+ while (($name, $gid) = $sth->fetchrow_array) {
+ $row = "$name:$gid:";
+ $row =~ s/\0//g;
+ print OUT $row;
+ $maybecomma = "";
+ }
+
+ $sth = $dbh->prepare("SELECT u.login FROM users u, imembers i " .
+ "WHERE i.list_id = " . $dbh->quote($root_list_id) .
+ "AND i.direct = 1 " .
+ "AND i.member_type = 'USER' " .
+ "AND u.users_id = i.member_id") || exit $MR_DBMS_ERR;
+ $sth->execute;
+
+ while (($login) = $sth->fetchrow_array) {
+ $row = "$maybecomma$login";
+ $row =~ s/\0//g;
+ print OUT $row;
+ $maybecomma = ",";
+ }
+
+ $row = "\n";
+ $row =~ s/\0//g;
+ print OUT $row;
+
$sth = $dbh->prepare("SELECT l.name, l.gid FROM list l, imembers i " .
"WHERE i.list_id = " . $dbh->quote($root_list_id) .
"AND i.member_type = 'LIST' " .
"WHERE users_id = " .
$dbh->quote($id)) ||
exit $MR_DBMS_ERR;
- $member = $member . "\@mit.edu";
}
elsif ($type eq "STRING") {
($member) = $dbh->selectrow_array("SELECT string " .
--- /dev/null
+#!/bin/sh
+# $Id$
+
+outfile=/tsm-mit/data/tsmlists
+loadprog=/tsm-mit/bin/loadAdminTable.pl
+
+PATH="/etc:/bin:/usr/bin:/usr/etc:/usr/athena/etc"
+
+if [ -d /var/athena ] && [ -w /var/athena ]; then
+ exec >/var/athena/moira_update.log 2>&1
+else
+ exec >/tmp/moira_update.log 2>&1
+fi
+
+# The following exit codes are defined and MUST BE CONSISTENT with the
+# error codes the library uses:
+MR_MISSINGFILE=47836473
+MR_MKCRED=47836474
+
+if [ ! -f $outfile ]; then
+ exit $MR_MISSINGFILE
+fi
+
+if [ ! -x $loadprog ]; then
+ exit $MR_MISSINGFILE
+fi
+
+$loadprog
+
+if [ $? != 0 ]; then
+ exit $MR_MKCRED
+fi
+
+exit 0