<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>[12436] CalendarServer/trunk/bin/proxyclean</title>
</head>
<body>
<style type="text/css"><!--
#msg dl.meta { border: 1px #006 solid; background: #369; padding: 6px; color: #fff; }
#msg dl.meta dt { float: left; width: 6em; font-weight: bold; }
#msg dt:after { content:':';}
#msg dl, #msg dt, #msg ul, #msg li, #header, #footer, #logmsg { font-family: verdana,arial,helvetica,sans-serif; font-size: 10pt; }
#msg dl a { font-weight: bold}
#msg dl a:link { color:#fc3; }
#msg dl a:active { color:#ff0; }
#msg dl a:visited { color:#cc6; }
h3 { font-family: verdana,arial,helvetica,sans-serif; font-size: 10pt; font-weight: bold; }
#msg pre { overflow: auto; background: #ffc; border: 1px #fa0 solid; padding: 6px; }
#logmsg { background: #ffc; border: 1px #fa0 solid; padding: 1em 1em 0 1em; }
#logmsg p, #logmsg pre, #logmsg blockquote { margin: 0 0 1em 0; }
#logmsg p, #logmsg li, #logmsg dt, #logmsg dd { line-height: 14pt; }
#logmsg h1, #logmsg h2, #logmsg h3, #logmsg h4, #logmsg h5, #logmsg h6 { margin: .5em 0; }
#logmsg h1:first-child, #logmsg h2:first-child, #logmsg h3:first-child, #logmsg h4:first-child, #logmsg h5:first-child, #logmsg h6:first-child { margin-top: 0; }
#logmsg ul, #logmsg ol { padding: 0; list-style-position: inside; margin: 0 0 0 1em; }
#logmsg ul { text-indent: -1em; padding-left: 1em; }#logmsg ol { text-indent: -1.5em; padding-left: 1.5em; }
#logmsg > ul, #logmsg > ol { margin: 0 0 1em 0; }
#logmsg pre { background: #eee; padding: 1em; }
#logmsg blockquote { border: 1px solid #fa0; border-left-width: 10px; padding: 1em 1em 0 1em; background: white;}
#logmsg dl { margin: 0; }
#logmsg dt { font-weight: bold; }
#logmsg dd { margin: 0; padding: 0 0 0.5em 0; }
#logmsg dd:before { content:'\00bb';}
#logmsg table { border-spacing: 0px; border-collapse: collapse; border-top: 4px solid #fa0; border-bottom: 1px solid #fa0; background: #fff; }
#logmsg table th { text-align: left; font-weight: normal; padding: 0.2em 0.5em; border-top: 1px dotted #fa0; }
#logmsg table td { text-align: right; border-top: 1px dotted #fa0; padding: 0.2em 0.5em; }
#logmsg table thead th { text-align: center; border-bottom: 1px solid #fa0; }
#logmsg table th.Corner { text-align: left; }
#logmsg hr { border: none 0; border-top: 2px dashed #fa0; height: 1px; }
#header, #footer { color: #fff; background: #636; border: 1px #300 solid; padding: 6px; }
#patch { width: 100%; }
#patch h4 {font-family: verdana,arial,helvetica,sans-serif;font-size:10pt;padding:8px;background:#369;color:#fff;margin:0;}
#patch .propset h4, #patch .binary h4 {margin:0;}
#patch pre {padding:0;line-height:1.2em;margin:0;}
#patch .diff {width:100%;background:#eee;padding: 0 0 10px 0;overflow:auto;}
#patch .propset .diff, #patch .binary .diff {padding:10px 0;}
#patch span {display:block;padding:0 10px;}
#patch .modfile, #patch .addfile, #patch .delfile, #patch .propset, #patch .binary, #patch .copfile {border:1px solid #ccc;margin:10px 0;}
#patch ins {background:#dfd;text-decoration:none;display:block;padding:0 10px;}
#patch del {background:#fdd;text-decoration:none;display:block;padding:0 10px;}
#patch .lines, .info {color:#888;background:#fff;}
--></style>
<div id="msg">
<dl class="meta">
<dt>Revision</dt> <dd><a href="http://trac.calendarserver.org//changeset/12436">12436</a></dd>
<dt>Author</dt> <dd>wsanchez@apple.com</dd>
<dt>Date</dt> <dd>2014-01-23 15:53:21 -0800 (Thu, 23 Jan 2014)</dd>
</dl>
<h3>Log Message</h3>
<pre>Nuke</pre>
<h3>Removed Paths</h3>
<ul>
<li><a href="#CalendarServertrunkbinproxyclean">CalendarServer/trunk/bin/proxyclean</a></li>
</ul>
</div>
<div id="patch">
<h3>Diff</h3>
<a id="CalendarServertrunkbinproxyclean"></a>
<div class="delfile"><h4>Deleted: CalendarServer/trunk/bin/proxyclean (12435 => 12436)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/bin/proxyclean 2014-01-23 23:40:51 UTC (rev 12435)
+++ CalendarServer/trunk/bin/proxyclean 2014-01-23 23:53:21 UTC (rev 12436)
</span><span class="lines">@@ -1,200 +0,0 @@
</span><del>-#!/usr/bin/env python
-
-##
-# Copyright (c) 2008-2014 Apple Inc. All rights reserved.
-#
-# Licensed under the Apache License, Version 2.0 (the "License");
-# you may not use this file except in compliance with the License.
-# You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing, software
-# distributed under the License is distributed on an "AS IS" BASIS,
-# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-# See the License for the specific language governing permissions and
-# limitations under the License.
-##
-
-import sys
-import commands
-import getopt
-import os
-
-try:
- import _calendarserver_preamble
-except ImportError:
- sys.exc_clear()
-
-from plistlib import readPlist
-
-try:
- import opendirectory
- import dsattributes
-except ImportError:
- sys.path.append("/usr/share/caldavd/lib/python")
- import opendirectory
- import dsattributes
-
-def usage(e=None):
- if e:
- print e
- print ""
-
- name = os.path.basename(sys.argv[0])
- print "usage: %s [-c] [-f FILE]" % (name,)
- print ""
- print "Tool to remove invalid OD record GUIDs from the proxy DB."
- print ""
- print "options:"
- print " -h: print this help"
- print " -c: change sqlite DB - without this just report what would happen"
- print " -f: caldavd.plist file to read (default: /etc/caldavd/caldavd.plist)"
-
- if e:
- sys.exit(64)
- else:
- sys.exit(0)
-
-def extractPlistPieces(plistdbpath):
-
- plist = readPlist(plistdbpath)
-
- try:
- dsnode = plist["DirectoryService"]["params"]["node"]
- except KeyError:
- raise ValueError("Unable to read DirectoryService/params/node key from plist: %s" % (plistdbpath,))
-
- try:
- dataroot = plist["DataRoot"]
- except KeyError:
- raise ValueError("Unable to read DataRoot key from plist: %s" % (plistdbpath,))
-
- # Find the appropriate sqlite db
- proxydbpath_data = os.path.join(dataroot, "calendaruserproxy.sqlite")
- if not os.path.exists(proxydbpath_data):
- try:
- docroot = plist["DocumentRoot"]
- except KeyError:
- "Unable to read DocumentRoot key from plist: %s" % (plistdbpath,)
- raise
- proxydbpath_doc = os.path.join(docroot, "principals", ".db.calendaruserproxy")
- if not os.path.exists(proxydbpath_doc):
- raise("Unable to find proxy db at '%s' or '%s'" % (proxydbpath_data, proxydbpath_doc))
- else:
- proxydbpath = proxydbpath_doc
- else:
- proxydbpath = proxydbpath_data
-
- print ""
- print "Parsed: %s" % (plistdbpath,)
- print "Found DS Node: %s" % (dsnode,)
- print "Found proxy DB path: %s" % (proxydbpath)
- print ""
- return dsnode, proxydbpath
-
-def loadUserRecords(dsnode):
-
- print "Loading /Users records from OD: %s" % (dsnode,)
- od = opendirectory.odInit(dsnode)
- results = opendirectory.listAllRecordsWithAttributes(
- od,
- dsattributes.kDSStdRecordTypeUsers,
- [dsattributes.kDS1AttrGeneratedUID,]
- )
-
- result = set()
- for record in results.itervalues():
- guid = record.get(dsattributes.kDS1AttrGeneratedUID, None)
- if guid:
- result.add(guid)
-
- print "Found %d /Users records" % (len(result),)
- print ""
-
- return result
-
-def cleanProxies(existing_guids, proxydbpath, do_changes):
-
- # Get proxy entries
- print "Reading proxy DB: %s" % (proxydbpath,)
- result = commands.getoutput("sqlite3 %s \"select * from GROUPS\"" % (proxydbpath,))
- if not result:
- print "Proxy DB empty. Nothing to do."
- return
-
- lines = result.split("\n")
- print "Found %d proxy DB records" % (len(lines),)
-
- proxying = set()
- proxying_total = 0
- users = set()
- users_total = 0
- for line in lines:
- proxy, user = line.split("|")
- if proxy.split("#")[0] not in existing_guids:
- proxying.add(proxy)
- proxying_total += 1
- if user not in existing_guids:
- users.add(user)
- users_total += 1
-
- if do_changes:
- print "Changes will be made to the proxy DB"
- else:
- print "Changes will not be made to the proxy DB"
-
- print ""
- print "Found %d invalid group names (total records %d)" % (len(proxying), proxying_total,)
- print "============================"
- for key in sorted(proxying):
- print key
- if do_changes:
- commands.getoutput("sqlite3 %s \"delete from GROUPS where GROUPNAME = '%s'\"" % (proxydbpath, key,))
- print "============================"
-
- print ""
- print "Found %d invalid members (total records %d)" % (len(users), users_total,)
- print "============================"
- for key in sorted(users):
- print key
- if do_changes:
- commands.getoutput("sqlite3 %s \"delete from GROUPS where MEMBER = '%s'\"" % (proxydbpath, key,))
- print "============================"
- print ""
- print "Done."
-
-if __name__ == "__main__":
- try:
- (optargs, args) = getopt.getopt(sys.argv[1:], "cf:h", ["help"])
- except getopt.GetoptError, e:
- usage(e)
-
- if len(args) != 0:
- usage("Wrong number of arguments.")
-
- plistdbpath = "/etc/caldavd/caldavd.plist"
- do_changes = False
-
- for opt, arg in optargs:
- if opt in ("-h", "--help"):
- usage()
- elif opt == "-c":
- do_changes = True
- elif opt == "-f":
- plistdbpath = arg
-
- try:
- print "CalendarServer proxy DB clean-up tool"
- print "====================================="
-
- if not os.path.exists(plistdbpath):
- raise ValueError("caldavd.plist file does not exist: %s" % (plistdbpath,))
-
- dsnode, proxydbpath = extractPlistPieces(plistdbpath)
- guids = loadUserRecords(dsnode)
- cleanProxies(guids, proxydbpath, do_changes)
- sys.exit(0)
- except ValueError, e:
- print ""
- print "Failed: %s" % (str(e),)
</del></span></pre>
</div>
</div>
</body>
</html>