#!/usr/bin/env python """ This script will email users that their clients haven't been accessed in the number of weeks defined in the weeks variable, and warn them that it will be deleted in one week if they do not use it. """ # Python 2.7/3.3 compatibility. from __future__ import print_function import os import re import time import smtplib import traceback import sys import string import accessdates import platform import sdputils if len(sys.argv) > 1: SDP_INSTANCE = str(sys.argv[1]) else: SDP_INSTANCE = '1' utils = sdputils.SDPUtils(SDP_INSTANCE) p4 = utils.p4 utils.login() ########################################################################## ##### ##### ##### CONFIGURATION VARIABLES: Modify in maintenance.cfg as needed. ##### ##### ##### weeks1warn = int(utils.get('weeks1warn')) weeks2warn = int(utils.get('weeks2warn')) administrator = utils.get('administrator') complain_from = utils.get('complain_from') cc_admin = (utils.get('ccadmin')) mailhost = utils.get('mailhost') repeat = int(utils.get('repeat')) sleeptime = int(utils.get('sleeptime')) message = """ Your workspace, %s will be unloaded in %s unless you use it to get the lastest revision of a file. The sync will update the access time, and your client will not be unloaded. If your workspace is unloaded, you can reload it with the following command: p4 reload -c %s If you need to keep this workspace active: Just login to Perforce using the workspace, right click any file, and choose the option "Get Latest Revision". Thanks for your cooperation, The Perforce Admin Team """ def complain(mailport, complaint): ''' Send a plaintive message to the human looking after this script if we have any difficulties. If no email address for such a human is given, send the complaint to stderr. ''' complaint = complaint + '\n' if administrator: mailport.sendmail(complain_from, [administrator], 'Subject: Perforce Email Client Deletion Review Daemon Problem\n\n' + complaint) else: sys.stderr.write(complaint) def mailit(mailport, sender, recipient, message): ''' Try to mail message from sender to the user using SMTP object mailport. complain() if there are any problems. ''' recipients = [] recipients.append(recipient) if cc_admin: recipients.append(cc_admin) try: failed = mailport.sendmail(sender, recipients, message) except: exc_type, exc_value, exc_tb = sys.exc_info() failed = traceback.format_exception(exc_type, exc_value, exc_tb) if failed: complain(mailport, 'The following errors occurred:\n\n' + repr(failed) + '\n\nwhile trying to email from\n' + repr(sender) + '\nto ' + repr(recipient) + '\nwith body\n\n' + message) def mailwarning(client, warningtime, mailport): os.system('%s client -o "%s" > client.txt' % (p4, client)) clientfile = open("client.txt", "r") for clientline in clientfile.readlines(): m = re.search(r"^Owner:\s(.*)\s", clientline) if m: owner = m.group(1) os.system('%s user -o "%s" > owner.txt' % (p4, owner)) ownerfile = open("owner.txt", "r") email = owner for ownerline in ownerfile.readlines(): m2 = re.search("^Email:\s(.*)\s", ownerline) if m2: email = m2.group(1) ownerfile.close() os.remove("owner.txt") subject = "Subject: Client: %s scheduled for deletion." % client messagebody = 'From: ' + administrator + '\n' + \ 'To: ' + email + '\n' + subject + '\n' + (message % (client, warningtime, client)) mailit(mailport, administrator, email, messagebody) clientfile.close() os.remove("client.txt") def warnusers(weeks1warn, weeks2warn, mailport): clients1warn = [] clients2warn = [] accessdates.createlist("clients", "client", weeks2warn) clientlist = open("clients.txt", "r") for client in clientlist.readlines(): client = client.rstrip() client = re.sub("\$", "\\\$", client) clients2warn.append(client) clientlist.close() os.remove("clients.txt") accessdates.createlist("clients", "client", weeks1warn) clientlist = open("clients.txt", "r") for client in clientlist.readlines(): client = client.rstrip() client = re.sub("\$", "\\\$", client) if client not in clients2warn: clients1warn.append(client) clientlist.close() os.remove("clients.txt") for client in clients1warn: mailwarning(client, "two weeks", mailport) for client in clients2warn: mailwarning(client, "one week", mailport) def loop_body(mailhost): # Note: there's a try: wrapped around everything so that the program won't # halt. Unfortunately, as a result you don't get the full traceback. # If you're debugging this script, remove the special exception handlers # to get the real traceback, or figure out how to get a real traceback, # by importing the traceback module and defining a file object that # will take the output of traceback.print_exc(file=mailfileobject) # and mail it (see the example in cgi.py) try: mailport = smtplib.SMTP(mailhost) except: sys.stderr.write('Unable to connect to SMTP host "' + mailhost + '"!\nWill try again in ' + repr(sleeptime) + ' seconds.\n') else: try: warnusers(weeks1warn, weeks2warn, mailport) except: exc_type, exc_value, exc_tb = sys.exc_info() complain(mailport, 'Client Deletion Review daemon problem:\n\n%s' % \ traceback.format_exception(exc_type, exc_value, exc_tb)) try: mailport.quit() except: sys.stderr.write('Error while doing SMTP quit command (ignore).\n') def main(): while (repeat): loop_body(mailhost) time.sleep(sleeptime) else: loop_body(mailhost) ############################################################################### # main if __name__ == '__main__': main()
# | Change | User | Description | Committed | |
---|---|---|---|---|---|
#7 | 29429 | Russell C. Jackson (Rusty) | Fixed typo. | ||
#6 | 29371 | Russell C. Jackson (Rusty) | Fixed swarm in clientname check. | ||
#5 | 29360 | Russell C. Jackson (Rusty) | Correct swamr typo. | ||
#4 | 29334 | Russell C. Jackson (Rusty) | Check for swarm in warnings | ||
#3 | 26869 | Russell C. Jackson (Rusty) | Added server to subject of pending deletes. | ||
#2 | 24675 | Russell C. Jackson (Rusty) |
Fixed bugs in sdputils.py and scripts using it. Converted to standard 2 space spacing, removed copyright stuff. |
||
#1 | 22693 | Russell C. Jackson (Rusty) |
Branched a Unix only version of the SDP. Removed extra items to create a cleaner tree. Moved a few items around to make more sense without Windows in the mix. |
||
//guest/perforce_software/sdp/dev/Maintenance/email_pending_client_deletes.py | |||||
#6 | 16638 | C. Thomas Tyler |
Routine merge down to dev from main using: p4 merge -b perforce_software-sdp-dev |
||
#5 | 16029 | C. Thomas Tyler |
Routine merge to dev from main using: p4 merge -b perforce_software-sdp-dev |
||
#4 | 13906 | C. Thomas Tyler |
Normalized P4INSTANCE to SDP_INSTANCE to get Unix/Windows implementations in sync. Reasons: 1. Things that interact with SDP in both Unix and Windows environments shoudn't have to account for this obscure SDP difference between Unix and Windows. (I came across this doing CBD work). 2. The Windows and Unix scripts have different variable names for defining the same concept, the SDP instance. Unix uses P4INSTANCE, while Windows uses SDP_INSTANCE. 3. This instance tag, a data set identifier, is an SDP concept. I prefer the SDP_INSTANCE name over P4INSTANCE, so I prpose to normalize to SDP_INSTANCE. 4. The P4INSTANCE name makes it look like a setting that might be recognized by the p4d itself, which it is not. (There are other such things such as P4SERVER that could perhaps be renamed as a separate task; but I'm not sure we want to totally disallow the P4 prefix for variable names. It looks too right to be wrong in same cases, like P4BIN and P4DBIN. That's a discussion for another day, outside the scope of this task). Meanwhile: * Fixed a bug in the Windows 2013.3 upgrade script that was referencing undefined P4INSTANCE, as the Windows environment defined only SDP_INSTANCE. * Had P4INSTANCE been removed completely, this change would likely cause trouble for users doing updates for existing SDP installations. So, though it involves slight technical debt, I opted to keep a redundant definition of P4INSTANCE in p4_vars.template, with comments indicating SDP_INSTANCE should be used in favor of P4INSTANCE, with a warning that P4INSTANCE may go away in a future release. This should avoid unnecessary upgrade pain. * In mkdirs.sh, the varialbe name was INSTANCE rather than SDP_INSTANCE. I changed that as well. That required manual change rather than sub/replace to avoid corrupting other similar varialbe names (e.g. MASTERINSTANCE). This is a trivial change technically (a substitute/replace, plus tweaks in p4_vars.template), but impacts many files. |
||
#3 | 11477 | Russell C. Jackson (Rusty) |
Updated to use /usr/bin/env python Added workshop header. Changed cfg to config. |
||
#2 | 11464 | Russell C. Jackson (Rusty) | Current maintenance scripts. | ||
#1 | 10638 | C. Thomas Tyler | Populate perforce_software-sdp-dev. | ||
//guest/perforce_software/sdp/main/Maintenance/email_pending_client_deletes.py | |||||
#1 | 10148 | C. Thomas Tyler | Promoted the Perforce Server Deployment Package to The Workshop. |