3 # Samba4 AD database checker
5 # Copyright (C) Andrew Tridgell 2011
7 # This program is free software; you can redistribute it and/or modify
8 # it under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # This program is distributed in the hope that it will be useful,
13 # but WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with this program. If not, see <http://www.gnu.org/licenses/>.
22 from samba import dsdb
23 from samba import common
24 from samba.dcerpc import misc
27 class dsdb_DN(object):
28 '''a class to manipulate DN components'''
30 def __init__(self, samdb, dnstring, syntax_oid):
31 if syntax_oid in [ dsdb.DSDB_SYNTAX_BINARY_DN, dsdb.DSDB_SYNTAX_STRING_DN ]:
32 colons = dnstring.split(':')
34 raise Exception("invalid DN prefix")
35 prefix_len = 4 + len(colons[1]) + int(colons[1])
36 self.prefix = dnstring[0:prefix_len]
37 self.dnstring = dnstring[prefix_len:]
39 self.dnstring = dnstring
42 self.dn = ldb.Dn(samdb, self.dnstring)
43 except Exception, msg:
44 print("ERROR: bad DN string '%s'" % self.dnstring)
48 return self.prefix + str(self.dn.extended_str(mode=1))
50 class dbcheck(object):
51 """check a SAM database for errors"""
53 def __init__(self, samdb, samdb_schema=None, verbose=False, fix=False, yes=False, quiet=False):
55 self.samdb_schema = (samdb_schema or samdb)
56 self.verbose = verbose
60 self.remove_all_unknown_attributes = False
61 self.remove_all_empty_attributes = False
62 self.fix_all_normalisation = False
63 self.fix_all_DN_GUIDs = False
64 self.remove_all_deleted_DN_links = False
65 self.fix_all_target_mismatch = False
67 def check_database(self, DN=None, scope=ldb.SCOPE_SUBTREE, controls=[], attrs=['*']):
68 '''perform a database check, returning the number of errors found'''
70 res = self.samdb.search(base=DN, scope=scope, attrs=['dn'], controls=controls)
71 self.report('Checking %u objects' % len(res))
74 error_count += self.check_object(object.dn, attrs=attrs)
75 if error_count != 0 and not self.fix:
76 self.report("Please use --fix to fix these errors")
77 self.report('Checked %u objects (%u errors)' % (len(res), error_count))
82 def report(self, msg):
83 '''print a message unless quiet is set'''
88 ################################################################
89 # a local confirm function that obeys the --fix and --yes options
90 def confirm(self, msg, allow_all=False, forced=False):
91 '''confirm a change'''
98 return common.confirm(msg, forced=forced, allow_all=allow_all)
100 ################################################################
101 # a local confirm function with support for 'all'
102 def confirm_all(self, msg, all_attr):
103 '''confirm a change with support for "all" '''
108 if getattr(self, all_attr) == 'NONE':
110 if getattr(self, all_attr) == 'ALL':
114 c = common.confirm(msg, forced=forced, allow_all=True)
116 setattr(self, all_attr, 'ALL')
119 setattr(self, all_attr, 'NONE')
124 ################################################################
125 # handle empty attributes
126 def err_empty_attribute(self, dn, attrname):
127 '''fix empty attributes'''
128 self.report("ERROR: Empty attribute %s in %s" % (attrname, dn))
129 if not self.confirm_all('Remove empty attribute %s from %s?' % (attrname, dn), 'remove_all_empty_attributes'):
130 self.report("Not fixing empty attribute %s" % attrname)
135 m[attrname] = ldb.MessageElement('', ldb.FLAG_MOD_DELETE, attrname)
137 self.report(self.samdb.write_ldif(m, ldb.CHANGETYPE_MODIFY))
139 self.samdb.modify(m, controls=["relax:0"], validate=False)
140 except Exception, msg:
141 self.report("Failed to remove empty attribute %s : %s" % (attrname, msg))
143 self.report("Removed empty attribute %s" % attrname)
146 ################################################################
147 # handle normalisation mismatches
148 def err_normalise_mismatch(self, dn, attrname, values):
149 '''fix attribute normalisation errors'''
150 self.report("ERROR: Normalisation error for attribute %s in %s" % (attrname, dn))
153 normalised = self.samdb.dsdb_normalise_attributes(self.samdb_schema, attrname, [val])
154 if len(normalised) != 1:
155 self.report("Unable to normalise value '%s'" % val)
156 mod_list.append((val, ''))
157 elif (normalised[0] != val):
158 self.report("value '%s' should be '%s'" % (val, normalised[0]))
159 mod_list.append((val, normalised[0]))
160 if not self.confirm_all('Fix normalisation for %s from %s?' % (attrname, dn), 'fix_all_normalisation'):
161 self.report("Not fixing attribute %s" % attrname)
166 for i in range(0, len(mod_list)):
167 (val, nval) = mod_list[i]
168 m['value_%u' % i] = ldb.MessageElement(val, ldb.FLAG_MOD_DELETE, attrname)
170 m['normv_%u' % i] = ldb.MessageElement(nval, ldb.FLAG_MOD_ADD, attrname)
173 self.report(self.samdb.write_ldif(m, ldb.CHANGETYPE_MODIFY))
175 self.samdb.modify(m, controls=["relax:0"], validate=False)
176 except Exception, msg:
177 self.report("Failed to normalise attribute %s : %s" % (attrname, msg))
179 self.report("Normalised attribute %s" % attrname)
181 def is_deleted_objects_dn(self, dsdb_dn):
182 '''see if a dsdb_DN is the special Deleted Objects DN'''
183 return dsdb_dn.prefix == "B:32:18E2EA80684F11D2B9AA00C04F79F805:"
186 ################################################################
187 # handle a missing GUID extended DN component
188 def err_incorrect_dn_GUID(self, dn, attrname, val, dsdb_dn, errstr):
189 self.report("ERROR: %s component for %s in object %s - %s" % (errstr, attrname, dn, val))
190 controls=["extended_dn:1:1"]
191 if self.is_deleted_objects_dn(dsdb_dn):
192 controls.append("show_deleted:1")
194 res = self.samdb.search(base=str(dsdb_dn.dn), scope=ldb.SCOPE_BASE,
195 attrs=[], controls=controls)
196 except ldb.LdbError, (enum, estr):
197 self.report("unable to find object for DN %s - cannot fix (%s)" % (dsdb_dn.dn, estr))
199 dsdb_dn.dn = res[0].dn
201 if not self.confirm_all('Change DN to %s?' % str(dsdb_dn), 'fix_all_DN_GUIDs'):
202 self.report("Not fixing %s" % errstr)
206 m['old_value'] = ldb.MessageElement(val, ldb.FLAG_MOD_DELETE, attrname)
207 m['new_value'] = ldb.MessageElement(str(dsdb_dn), ldb.FLAG_MOD_ADD, attrname)
209 self.report(self.samdb.write_ldif(m, ldb.CHANGETYPE_MODIFY))
212 except Exception, msg:
213 self.report("Failed to fix %s on attribute %s : %s" % (errstr, attrname, msg))
215 self.report("Fixed %s on attribute %s" % (errstr, attrname))
218 ################################################################
219 # handle a DN pointing to a deleted object
220 def err_deleted_dn(self, dn, attrname, val, dsdb_dn, correct_dn):
221 self.report("ERROR: target DN is deleted for %s in object %s - %s" % (attrname, dn, val))
222 self.report("Target GUID points at deleted DN %s" % correct_dn)
223 if not self.confirm_all('Remove DN?', 'remove_all_deleted_DN_links'):
224 self.report("Not removing")
228 m['old_value'] = ldb.MessageElement(val, ldb.FLAG_MOD_DELETE, attrname)
230 self.report(self.samdb.write_ldif(m, ldb.CHANGETYPE_MODIFY))
233 except Exception, msg:
234 self.report("Failed to remove deleted DN attribute %s : %s" % (attrname, msg))
236 self.report("Removed deleted DN on attribute %s" % attrname)
239 ################################################################
240 # handle a DN string being incorrect
241 def err_dn_target_mismatch(self, dn, attrname, val, dsdb_dn, correct_dn, errstr):
242 self.report("ERROR: incorrect DN string component for %s in object %s - %s" % (attrname, dn, val))
243 dsdb_dn.dn = correct_dn
245 if not self.confirm_all('Change DN to %s?' % str(dsdb_dn), 'fix_all_target_mismatch'):
246 self.report("Not fixing %s" % errstr)
250 m['old_value'] = ldb.MessageElement(val, ldb.FLAG_MOD_DELETE, attrname)
251 m['new_value'] = ldb.MessageElement(str(dsdb_dn), ldb.FLAG_MOD_ADD, attrname)
253 self.report(self.samdb.write_ldif(m, ldb.CHANGETYPE_MODIFY))
256 except Exception, msg:
257 self.report("Failed to fix incorrect DN string on attribute %s : %s" % (attrname, msg))
259 self.report("Fixed incorrect DN string on attribute %s" % (attrname))
261 ################################################################
262 # handle an unknown attribute error
263 def err_unknown_attribute(self, obj, attrname):
264 '''handle an unknown attribute error'''
265 self.report("ERROR: unknown attribute '%s' in %s" % (attrname, obj.dn))
266 if not self.confirm_all('Remove unknown attribute %s' % attrname, 'remove_all_unknown_attributes'):
267 self.report("Not removing %s" % attrname)
271 m['old_value'] = ldb.MessageElement([], ldb.FLAG_MOD_DELETE, attrname)
273 self.report(self.samdb.write_ldif(m, ldb.CHANGETYPE_MODIFY))
275 self.samdb.modify(m, controls=["relax:0"])
276 except Exception, msg:
277 self.report("Failed to remove unknown attribute %s : %s" % (attrname, msg))
279 self.report("Removed unknown attribute %s" % (attrname))
282 ################################################################
283 # specialised checking for a dn attribute
284 def check_dn(self, obj, attrname, syntax_oid):
285 '''check a DN attribute for correctness'''
287 for val in obj[attrname]:
288 dsdb_dn = dsdb_DN(self.samdb, val, syntax_oid)
290 # all DNs should have a GUID component
291 guid = dsdb_dn.dn.get_extended_component("GUID")
294 self.err_incorrect_dn_GUID(obj.dn, attrname, val, dsdb_dn, "missing GUID")
297 guidstr = str(misc.GUID(guid))
299 # check its the right GUID
301 res = self.samdb.search(base="<GUID=%s>" % guidstr, scope=ldb.SCOPE_BASE,
302 attrs=['isDeleted'], controls=["extended_dn:1:1", "show_deleted:1"])
303 except ldb.LdbError, (enum, estr):
305 self.err_incorrect_dn_GUID(obj.dn, attrname, val, dsdb_dn, "incorrect GUID")
308 # the target DN might be deleted
309 if ((not self.is_deleted_objects_dn(dsdb_dn)) and
310 'isDeleted' in res[0] and
311 res[0]['isDeleted'][0].upper() == "TRUE"):
312 # note that we don't check this for the special wellKnownObjects prefix
313 # for Deleted Objects, as we expect that to be deleted
315 self.err_deleted_dn(obj.dn, attrname, val, dsdb_dn, res[0].dn)
318 # check the DN matches in string form
319 if res[0].dn.extended_str() != dsdb_dn.dn.extended_str():
321 self.err_dn_target_mismatch(obj.dn, attrname, val, dsdb_dn,
322 res[0].dn, "incorrect string version of DN")
329 ################################################################
330 # check one object - calls to individual error handlers above
331 def check_object(self, dn, attrs=['*']):
332 '''check one object'''
334 self.report("Checking object %s" % dn)
335 res = self.samdb.search(base=dn, scope=ldb.SCOPE_BASE, controls=["extended_dn:1:1"], attrs=attrs)
337 self.report("Object %s disappeared during check" % dn)
345 # check for empty attributes
346 for val in obj[attrname]:
348 self.err_empty_attribute(dn, attrname)
352 # get the syntax oid for the attribute, so we can can have
353 # special handling for some specific attribute types
355 syntax_oid = self.samdb_schema.get_syntax_oid_from_lDAPDisplayName(attrname)
356 except Exception, msg:
357 self.err_unknown_attribute(obj, attrname)
361 if syntax_oid in [ dsdb.DSDB_SYNTAX_BINARY_DN, dsdb.DSDB_SYNTAX_OR_NAME,
362 dsdb.DSDB_SYNTAX_STRING_DN, ldb.LDB_SYNTAX_DN ]:
363 # it's some form of DN, do specialised checking on those
364 error_count += self.check_dn(obj, attrname, syntax_oid)
366 # check for incorrectly normalised attributes
367 for val in obj[attrname]:
368 normalised = self.samdb.dsdb_normalise_attributes(self.samdb_schema, attrname, [val])
369 if len(normalised) != 1 or normalised[0] != val:
370 self.err_normalise_mismatch(dn, attrname, obj[attrname])