ud-mailgate: remove exception for m√ľnchen.debian.net
[mirror/userdir-ldap.git] / ud-ldapshow
1 #!/usr/bin/env python
2 # -*- mode: python -*-
3 # Show some reports from the ldap database
4 # Call with nokey to generate a missing key report
5 # Call with noforward to generate a missing .forward report
6
7 import re, time, ldap, getopt, sys;
8 from userdir_ldap import *;
9
10 def ShowDups(Attrs,Len):
11    for x in Attrs:
12       if x[1].has_key("keyFingerPrint") == 0:
13          continue;
14          
15       Count = 0;
16       for I in x[1]["keyFingerPrint"]:
17          if len(I) == Len:
18             Count = Count + 1;
19       if Count > 1:
20          for I in x[1]["keyFingerPrint"]:
21            if len(I) == Len:
22               print "%s: %s" % (EmailAddress(x),I);
23
24 # Main program starts here
25 # Process options
26 (options, arguments) = getopt.getopt(sys.argv[1:], "")
27 for (switch, val) in options:
28    if (switch == '-a'):
29       DoAdd = 1;
30
31 print "Connecting to LDAP directory";
32
33 # Connect to the ldap server
34 l = connectLDAP()
35 l.simple_bind_s("","");
36
37 if arguments[0] == "nokey":
38    Attrs = l.search_s(BaseDn,ldap.SCOPE_ONELEVEL,"(!(keyFingerPrint=*))",\
39            ["uid","cn","sn","emailForward","comment"]);
40    Attrs.sort();
41    for x in Attrs:
42       print "Key Missing:",EmailAddress(x);
43       if GetAttr(x,"emailForward") != "":
44          print "  ->",GetAttr(x,"emailForward");
45       if GetAttr(x,"comment") != "":
46          print "  :",GetAttr(x,"comment");
47
48 if arguments[0] == "noforward":
49    Attrs = l.search_s(BaseDn,ldap.SCOPE_ONELEVEL,"(!(emailForward=*))",\
50            ["uid","cn","sn","emailForward","comment"]);
51    Attrs.sort();
52    for x in Attrs:
53       print "No Forward:",EmailAddress(x);
54
55 if arguments[0] == "badpriv":
56    Attrs = l.search_s(BaseDn,ldap.SCOPE_ONELEVEL,"(&(!(keyFingerPrint=*))(privateSub=*))",\
57            ["uid","cn","sn","privateSub"]);
58    Attrs.sort();
59    for x in Attrs:
60       print EmailAddress(x)+": "+GetAttr(x,"privateSub");
61
62 if arguments[0] == "nopriv":
63    Attrs = l.search_s(BaseDn,ldap.SCOPE_ONELEVEL,"(&(keyFingerPrint=*)(!(privateSub=*)))",\
64            ["uid","cn","sn","privateSub"]);
65    Attrs.sort();
66    for x in Attrs:
67       print "  ",EmailAddress(x)+": "+GetAttr(x,"privateSub");
68
69 if arguments[0] == "keymap":
70    Attrs = l.search_s(BaseDn,ldap.SCOPE_ONELEVEL,"uid=*",\
71            ["uid","cn","sn","keyFingerPrint"]);
72    Attrs.sort();
73    for x in Attrs:
74       if x[1].has_key("keyFingerPrint"):
75          for I in x[1]["keyFingerPrint"]:
76            print "%s: %s" % (EmailAddress(x),I);
77
78 if arguments[0] == "devcount":
79    Attrs = l.search_s(BaseDn,ldap.SCOPE_ONELEVEL,"(&(keyFingerPrint=*)(supplementaryGid=Debian))",\
80            ["uid"]);
81    Count = 0;
82    for x in Attrs:
83       Count = Count + 1;
84    print "There are",Count,"developers as of",time.strftime("%a, %d %b %Y %H:%M:%S +0000",time.gmtime(time.time()));
85
86 if arguments[0] == "echelon":
87    Attrs = l.search_s(BaseDn,ldap.SCOPE_ONELEVEL,\
88    "(&(|(activity-pgp=*)(activity-from=*))(&(keyFingerPrint=*)(supplementaryGid=Debian)))",\
89            ["activity-pgp","activity-from"]);
90    Count = 0;
91    PGPCount = 0;
92    for x in Attrs:
93       Count = Count + 1;
94       if x[1].has_key("activity-pgp"):
95          PGPCount = PGPCount + 1;
96    print "Echelon has seen",Count,"developers, with",PGPCount,"PGP confirms as of",time.strftime("%a, %d %b %Y %H:%M:%S +0000",time.gmtime(time.time()));
97
98 if arguments[0] == "missing":
99    Attrs = l.search_s(BaseDn,ldap.SCOPE_ONELEVEL,\
100    "(&(!(|(activity-pgp=*)(activity-from=*)))(&(keyFingerPrint=*)(supplementaryGid=Debian)))",\
101            ["uid","cn","sn","mn"]);
102    Attrs.sort();
103    for x in Attrs:
104       print EmailAddress(x);
105
106 if arguments[0] == "keystat":
107    Attrs = l.search_s(BaseDn,ldap.SCOPE_ONELEVEL,"keyFingerPrint=*",\
108            ["keyFingerPrint"]);
109    KeyCount = 0;
110    GPGCount = 0;
111    for x in Attrs:
112       if x[1].has_key("keyFingerPrint"):
113          KeyCount = KeyCount + 1;
114          for I in x[1]["keyFingerPrint"]:
115            if len(I) == 40:
116               GPGCount = GPGCount + 1;
117               break;
118    print "There are",KeyCount,"accounts with PGP2/5 keys and",GPGCount,"of them have PGP5 keys";
119
120 if arguments[0] == "multikeys":
121    Attrs = l.search_s(BaseDn,ldap.SCOPE_ONELEVEL,"uid=*",\
122            ["uid","cn","sn","keyFingerPrint"]);
123    Attrs.sort();
124    
125    
126    print "--- PGP Keys ---"
127    ShowDups(Attrs,32);
128    print "--- GPG Keys ---"
129    ShowDups(Attrs,40);
130