diff -r 8deedfeb7846 -r 2e039d1e150c misc/scripts/ldap_change_base_dn.py --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/misc/scripts/ldap_change_base_dn.py Tue Jul 13 15:45:42 2010 +0200 @@ -0,0 +1,24 @@ +from base64 import b64decode, b64encode +try: + uri, newdn = __args__ +except ValueError: + print 'USAGE: cubicweb-ctl shell ldap_change_base_dn.py -- ' + print + print 'you should not have updated your sources file yet' + +olddn = repo.config.sources()[uri]['user-base-dn'] + +assert olddn != newdn + +raw_input("Ensure you've stopped the instance, type enter when done.") + +for eid, extid in sql("SELECT eid, extid FROM entities WHERE source='%s'" % uri): + olduserdn = b64decode(extid) + newuserdn = olduserdn.replace(olddn, newdn) + if newuserdn != olduserdn: + print olduserdn, '->', newuserdn + sql("UPDATE entities SET extid='%s' WHERE eid=%s" % (b64encode(newdn), eid)) + +commit() + +print 'you can now update the sources file to the new dn and restart the instance'