def database_menu():
ds.datasyncBanner(dsappversion)
print "The database menu will require Mobility to be stopped"
if ds.askYesOrNo("Stop Mobility now"):
ds.datasyncBanner(dsappversion)
ds.rcDS('stop')
menu = ['1. Vacuum Databases', '2. Re-Index Databases', '\n 3. Back up Databases', '4. Restore Databases', '\n 5. Recreate Global Address Book (GAL)', '6. Fix targets/membershipCache', '\n 7. CUSO Clean-Up Start-Over', '\n 0. Back -- Start Mobility']
available = build_avaialbe(menu)
loop = True
while loop:
show_menu(menu)
choice = get_choice(available)
if choice == '1':
ds.datasyncBanner(dsappversion)
print textwrap.fill("The amount of time this takes can vary depending on the last time it was completed. It is recommended that this be run every 6 months.", 80)
print
if ds.askYesOrNo("Do you want to continue"):
ds.vacuumDB(dbConfig)
print
ds.eContinue()
elif choice == '2':
ds.datasyncBanner(dsappversion)
print textwrap.fill("The amount of time this takes can vary depending on the last time it was completed. It is recommended that this be run after a database vacuum.", 80)
print
if ds.askYesOrNo("Do you want to continue"):
ds.indexDB(dbConfig)
print
ds.eContinue()
elif choice == '3':
ds.backupDatabase(dbConfig)
print; ds.eContinue()
elif choice == '4':
ds.restoreDatabase(dbConfig)
print; ds.eContinue()
elif choice == '5':
ds.fix_gal(dbConfig)
print; ds.eContinue()
elif choice == '6':
ds.addGroup(dbConfig, ldapConfig)
print; ds.eContinue()
elif choice == '7':
cuso_menu()
elif choice == '0':
loop = False
ds.datasyncBanner(dsappversion)
ds.rcDS('start')
main_menu()
else:
main_menu()
def autoIssue(self, forced=False):
# Make sure socat is installed
if not self.installSocat():
return
# Make sure acme root is setup
if not os.path.isdir(self.acmeRoot):
print("acme.sh is not installed. Please install")
logger.error("acme.sh is not installed. Please install")
return
if not os.path.isfile(self.acmeRoot + '/acme.sh'):
print("Unable to find %s" % (self.acmeRoot + 'acme.sh'))
print("Reinstall acme.sh")
logger.error("Unable to find %s" % (self.acmeRoot + 'acme.sh'))
logger.error("Reinstall acme.sh")
return
if not int(glb.mobilityConfig['mSecure']):
print(
"Unable to auto issue LetsEncrypt on unsecure connection using port %s"
% glb.mobilityConfig['mPort'])
return
print("This will shutdown mobility to free up port %s" %
glb.mobilityConfig['mPort'])
if not ds.askYesOrNo("Start auto LetsEncrypt now"):
return
ds.rcDS('stop') # Stop mobility to clear TLS port
self.setDNS()
print("Requesting new certificate from LetsEncrypt with DNS: %s" %
self.DNS)
if self.issueCertificate(forced):
self.setCertPath()
self.setCertificates()
self.createPem()
ds.configureMobilityCerts(self.certPath, prompts=False)
else:
print("Problem requesting certificate")
print("See %s" % self.acmeLog)
ds.rcDS('start')
# Show sync status
if args.status:
ds.showStatus(dbConfig)
print; ds.eContinue()
sys.exit(0)
# Update mobility URL
if args.update:
ds.updateMobilityFTP()
ds.eContinue()
sys.exit(0)
# Vacuum db
if args.vacuum:
ds.rcDS('stop')
ds.vacuumDB(dbConfig)
if args.index:
ds.indexDB(dbConfig)
ds.rcDS('start')
ds.eContinue()
sys.exit(0)
# Index db
if args.index:
ds.rcDS('stop')
ds.indexDB(dbConfig)
if args.vacuum:
ds.vacuumDB(dbConfig)
ds.rcDS('start')
ds.eContinue()
def database_menu():
ds.datasyncBanner()
print "The database menu will require Mobility to be stopped"
if ds.askYesOrNo("Stop Mobility now"):
ds.datasyncBanner()
ds.rcDS('stop')
menu = [
'1. Vacuum Databases', '2. Re-Index Databases',
'\n 3. Back up Databases', '4. Restore Databases',
'\n 5. Recreate Global Address Book (GAL)',
'6. Fix targets/membershipCache',
'\n 7. CUSO Clean-Up Start-Over',
'\n 0. Back -- Start Mobility'
]
available = build_avaialbe(menu)
loop = True
while loop:
show_menu(menu)
choice = get_choice(available)
if choice == '1':
ds.datasyncBanner()
print textwrap.fill(
"The amount of time this takes can vary depending on the last time it was completed. It is recommended that this be run every 6 months.",
80)
print
if ds.askYesOrNo("Do you want to continue"):
ds.vacuumDB()
print
ds.eContinue()
elif choice == '2':
ds.datasyncBanner()
print textwrap.fill(
"The amount of time this takes can vary depending on the last time it was completed. It is recommended that this be run after a database vacuum.",
80)
print
if ds.askYesOrNo("Do you want to continue"):
ds.indexDB()
print
ds.eContinue()
elif choice == '3':
ds.backupDatabase()
print
ds.eContinue()
elif choice == '4':
ds.restoreDatabase()
print
ds.eContinue()
elif choice == '5':
ds.fix_gal()
print
ds.eContinue()
elif choice == '6':
ds.addGroup()
print
ds.eContinue()
elif choice == '7':
cuso_menu()
elif choice == '0':
loop = False
ds.datasyncBanner()
ds.rcDS('start')
main_menu()
else:
main_menu()
ds.showStatus()
print
ds.eContinue()
sys.exit(0)
# Update mobility URL
if args.update:
logger.info("Running switch: update")
ds.updateMobilityFTP()
ds.eContinue()
sys.exit(0)
# Vacuum db
if args.vacuum:
logger.info("Running switch: vacuum")
ds.rcDS('stop')
ds.vacuumDB()
if args.index:
logger.info("Running switch: index")
ds.indexDB()
ds.rcDS('start')
ds.eContinue()
sys.exit(0)
# Index db
if args.index:
logger.info("Running switch: index")
ds.rcDS('stop')
ds.indexDB()
if args.vacuum:
logger.info("Running switch: vacuum")
def install_settings():
# TODO : DEV : Prompt to continue
print("This feature is currently under development:\n\nTasks to complete:")
print(
"LDAP settings import\nCertificate check / import\nUsers and group import\n"
)
if not ds.askYesOrNo("Continue with restore"):
return
ds.datasyncBanner()
# Is mobility already installed? Return if YES
if os.path.isfile(glb.installedConnector):
print(
"Mobility already installed\nOnly use 'restore' to install Mobility from backup"
)
logger.warning("Mobility already installed")
return
setupDir = glb.dirOptMobility + '/syncengine/connectors/mobility/cli'
path = getConfig()
if path is None:
return
fileName = ds.file_content(path)[0]
ds.untar_file(path, extractPath=glb.dsapptmp)
readConfigs(glb.dsapptmp + '/' + fileName)
# Validate all needed variabes are NOT None
missingAttribute = False
if glb.dbConfig['pass'] is None:
print(ERROR_MSG)
logger.error("glb.dbConfig['pass'] = None")
missingAttribute = True
if gwConfig['sListenAddress'] is None:
print(ERROR_MSG)
logger.error("gwConfig['sListenAddress'] = None")
missingAttribute = True
if mobilityConfig['galUserName'] is None:
print(ERROR_MSG)
logger.error("mobilityConfig['galUserName'] = None")
missingAttribute = True
if mobilityConfig['mPort'] is None:
print(ERROR_MSG)
logger.error("mobilityConfig['mPort'] = None")
missingAttribute = True
if mobilityConfig['mSecure'] is None:
print(ERROR_MSG)
logger.error("mobilityConfig['mSecure'] = None")
missingAttribute = True
if gwConfig['gport'] is None:
print(ERROR_MSG)
logger.error("gwConfig['gport'] = None")
missingAttribute = True
if gwConfig['gListenAddress'] is None:
print(ERROR_MSG)
logger.error("gwConfig['gListenAddress'] = None")
missingAttribute = True
if gwConfig['sPort'] is None:
print(ERROR_MSG)
logger.error("gwConfig['sPort'] = None")
missingAttribute = True
if gwConfig['sSecure'] is None:
print(ERROR_MSG)
logger.error("gwConfig['sSecure'] = None")
missingAttribute = True
if trustedConfig['name'] is None:
print(ERROR_MSG)
logger.error("trustedConfig['name'] = None")
missingAttribute = True
if trustedConfig['key'] is None:
print(ERROR_MSG)
logger.error("trustedConfig['key'] = None")
missingAttribute = True
if missingAttribute:
return
# Get local IP, and validate IP is NOT 127.0.0.1
local_IP = socket.gethostbyname(socket.gethostname())
logger.debug("Detected local address: %s" % local_IP)
if '127.0.0' in local_IP:
logger.warning(
"Detected address defaulted to localhost. Setting to 'None'")
local_IP = None
if local_IP is None:
print("Unable to detect server address")
logger.warning("Unable to detect server address, or set to None")
if ds.askYesOrNo("Manually enter server address"):
local_IP = raw_input("Server address: ")
else:
return
# Does local_IP match sListenAddress
if local_IP != gwConfig['sListenAddress']:
print(
"\nSever address does not match stored backup address\nLocal: %s\nBackup: %s\n"
% (local_IP, gwConfig['sListenAddress']))
if not ds.askYesOrNo(
"Is detected local server address correct (%s)" % local_IP):
if ds.askYesOrNo("Manually enter server address"):
local_IP = raw_input("Server address: ")
else:
return
if ds.askYesOrNo("Install with local server address (%s)" % local_IP):
gwConfig['sListenAddress'] = local_IP
else:
if not ds.askYesOrNo("Install with backup address (%s)" %
gwConfig['sListenAddress']):
return
# Create a trusted application key
trustedKey = glb.dsapptmp + '/' + fileName + '/trustedKey.key'
with open(trustedKey, 'a') as key:
key.write(trustedConfig['key'])
logger.info("Created trusted key at: %s" % trustedKey)
# Get path / file
isoPath = ds.getMobilityISO()
# Verify ISO is mobility iso
if not ds.checkISO_content(isoPath):
return
# Prompt to run install
ds.datasyncBanner()
print("Mobility Backup: %s" % fileName)
print("Mobility ISO: %s" % os.path.basename(isoPath))
if not ds.askYesOrNo("Install with settings"):
return
# All checks paasses - Add isoPath as 'mobility' repo
print("\nSetting up mobility repository..")
logger.info("Setting up mobility repository")
cmd = "zypper rr mobility"
logger.debug("Running: %s" % cmd)
out = ds.util_subprocess(cmd, True)
cmd = "zypper addrepo 'iso:///?iso=%s&url=file://%s' mobility" % (
os.path.basename(isoPath), os.path.dirname(isoPath))
logger.debug("Running: %s" % cmd)
out = ds.util_subprocess(cmd, True)
# Refresh Repo
print("Refreshing mobility repository")
logger.info("Refreshing mobility repository")
cmd = "zypper --gpg-auto-import-keys ref -f mobility"
logger.debug("Running: %s" % cmd)
out = ds.util_subprocess(cmd, True)
# Install mobility pattern
cmd = "zypper -x pt --repo mobility"
logger.debug("Running: %s" % cmd)
out = ds.util_subprocess(cmd, True)
try:
patternName = out[0].split('pattern name=')[1].split('"')[1]
logger.debug("Found Mobility pattern: %s" % patternName)
except:
print("Unable to find Mobility pattern")
logger.error("Unable to find Mobility pattern")
return
print("Installing Mobility pattern: %s" % patternName)
logger.info("Installing Mobility pattern: %s" % patternName)
cmd = "zypper --non-interactive install -t pattern %s" % patternName
logger.debug("Running: %s" % cmd)
out = ds.util_subprocess(cmd, True)
# Get version of GMS installed
if gwConfig['sSecure'] == 'https':
gwConfig['sSecure'] = 'yes'
elif gwConfig['sSecure'] == 'http':
gwConfig['sSecure'] = 'no'
# Swtich msecure 1 or 0 to true or false
if bool(mobilityConfig['mSecure']):
mobilityConfig['mSecure'] = 'true'
else:
mobilityConfig['mSecure'] = 'false'
# Create variables for gms installs
setup_one = "sh " + setupDir + "/postgres_setup_1.sh"
setup_two = "python " + setupDir + "/odbc_setup_2.pyc"
setup_three = "python " + setupDir + "/mobility_setup_3.pyc --provision 'groupwise' --dbpass '%s'" % glb.dbConfig[
'pass']
setup_four = "sh " + setupDir + "/enable_setup_4.sh"
setup_five = "python " + setupDir + "/mobility_setup_5.pyc --provision 'groupwise' --galuser '%(galUserName)s' --block false --selfsigned true --path '' --lport '%(mPort)s' --secure %(mSecure)s" % mobilityConfig
setup_six = "python " + setupDir + "/groupwise_setup_6.pyc --keypath '%s' --lport '%s' --lip '%s' --version '802' --soap %s --key '%s' --sport %s --psecure '%s'" % (
trustedKey, gwConfig['gport'], gwConfig['sListenAddress'],
gwConfig['gListenAddress'], trustedConfig['name'], gwConfig['sPort'],
gwConfig['sSecure'])
setup_seven = "python " + setupDir + "/start_mobility.pyc"
# Run through install with all setups
print("\nConfiguring and extending database..")
logger.info("Configuring and extending database..")
logger.debug("Running: %s" % setup_one)
out = ds.util_subprocess(setup_one, True)
logger.debug("Running: %s" % setup_two)
out = ds.util_subprocess(setup_two, True)
print("Configuring GroupWise Mobility Service..")
logger.info("Configuring GroupWise Mobility Service..")
logger.debug("Running: %s" % setup_three)
out = ds.util_subprocess(setup_three, True)
print("Enabling and Starting GroupWise Mobility Service..")
logger.info("Enabling and Starting GroupWise Mobility Service..")
logger.debug("Running: %s" % setup_four)
out = ds.util_subprocess(setup_four, True)
# Manually start mobility as the init script will detect a running [p]ython pid, and fail to start
ds.rcDS('start', op='nocron', show_spinner=False, show_print=False)
print("Configuring Device Sync Agent..")
logger.info("Configuring Device Sync Agent..")
logger.debug("Running: %s" % setup_five)
out = ds.util_subprocess(setup_five, True)
print("Configuring GroupWise Sync Agent..")
logger.info("Configuring GroupWise Sync Agent..")
logger.debug("Running: %s" % setup_six)
out = ds.util_subprocess(setup_six, True)
print("Starting Sync Agents..")
logger.info("Starting Sync Agents..")
logger.debug("Running: %s" % setup_seven)
out = ds.util_subprocess(setup_seven, True)
# Build XMLconfigs
logger.info('Building XML trees started')
time1 = time.time()
logger.debug('Building %s tree from: %s' %
('mconfXML', glb.config_files['mconf']))
glb.XMLconfig['mconf'] = ds.getXMLTree(glb.config_files['mconf'])
logger.debug('Building %s tree from: %s' %
('econfXML', glb.config_files['econf']))
glb.XMLconfig['econf'] = ds.getXMLTree(glb.config_files['econf'])
logger.debug('Building %s tree from: %s' %
('ceconfXML', glb.config_files['ceconf']))
glb.XMLconfig['ceconf'] = ds.getXMLTree(glb.config_files['ceconf'])
logger.debug('Building %s tree from: %s' %
('wconfXML', glb.config_files['wconf']))
glb.XMLconfig['wconf'] = ds.getXMLTree(glb.config_files['wconf'])
logger.debug('Building %s tree from: %s' %
('gconfXML', glb.config_files['gconf']))
glb.XMLconfig['gconf'] = ds.getXMLTree(glb.config_files['gconf'])
time2 = time.time()
logger.info('Building XML trees complete')
logger.info("Operation took %0.3f ms" % ((time2 - time1) * 1000))
# Prompt to match backup ldap settings
finalChange = False
if ldapConfig['enabled'] == 'true':
finalChange = True
if ds.askYesOrNo("\nRestore LDAP settings"):
# Restore groups
print("Restoring group container(s)..")
logger.info("Restoring group container(s)..")
if len(ldapConfig['group']) == 1:
ds.setXML('.//configengine/ldap/groupContainer',
glb.XMLconfig['ceconf'], ldapConfig['group'][0],
glb.config_files['ceconf'])
elif len(ldapConfig['group']) > 1:
ds.setXML('.//configengine/ldap/groupContainer',
glb.XMLconfig['ceconf'], ldapConfig['group'][0],
glb.config_files['ceconf'])
groups = iter(ldapConfig['group'])
next(groups, None)
for group in groups:
ds.insertXML(
'.//configengine/ldap/groupContainer',
glb.XMLconfig['ceconf'],
'<groupContainer>' + group + '</groupContainer>',
glb.config_files['ceconf'])
else:
logger.warning("No group container(s)")
# Restore users
print("Restoring user container(s)..")
logger.info("Restoring user container(s)..")
# Create base userContainer to insert into
ds.createXML_tag('.//configengine/ldap',
glb.XMLconfig['ceconf'],
"userContainer",
glb.config_files['ceconf'],
value="o=GroupWise")
if len(ldapConfig['user']) == 1:
ds.setXML('.//configengine/ldap/userContainer',
glb.XMLconfig['ceconf'], ldapConfig['user'][0],
glb.config_files['ceconf'])
elif len(ldapConfig['user']) > 1:
ds.setXML('.//configengine/ldap/userContainer',
glb.XMLconfig['ceconf'], ldapConfig['user'][0],
glb.config_files['ceconf'])
users = iter(ldapConfig['user'])
next(users, None)
for user in users:
ds.insertXML('.//configengine/ldap/userContainer',
glb.XMLconfig['ceconf'],
'<userContainer>' + user + '</userContainer>',
glb.config_files['ceconf'])
else:
logger.warning("No user container(s)")
# Restore admins
print("Restoring admin(s)..")
logger.info("Restoring admin(s)..")
if len(ldapConfig['admins']) == 1:
ds.setXML('.//configengine/ldap/admins/dn',
glb.XMLconfig['ceconf'], ldapConfig['admins'][0],
glb.config_files['ceconf'])
elif len(ldapConfig['admins']) > 1:
ds.setXML('.//configengine/ldap/admins/dn',
glb.XMLconfig['ceconf'], ldapConfig['admins'][0],
glb.config_files['ceconf'])
admins = iter(ldapConfig['admins'])
next(admins, None)
for admin in admins:
ds.insertXML('.//configengine/ldap/admins/dn',
glb.XMLconfig['ceconf'],
'<admins>' + admin + '</admins>',
glb.config_files['ceconf'])
else:
logger.warning("No admin(s)")
# Server settings
print("Restoring server settings..")
logger.info("Restoring server settings..")
ds.setXML('.//configengine/ldap/secure', glb.XMLconfig['ceconf'],
ldapConfig['secure'], glb.config_files['ceconf'])
ds.setXML('.//configengine/ldap/enabled', glb.XMLconfig['ceconf'],
ldapConfig['enabled'], glb.config_files['ceconf'])
ds.setXML('.//configengine/ldap/hostname', glb.XMLconfig['ceconf'],
ldapConfig['host'], glb.config_files['ceconf'])
ds.setXML('.//configengine/ldap/port', glb.XMLconfig['ceconf'],
ldapConfig['port'], glb.config_files['ceconf'])
ds.setXML('.//configengine/ldap/login/dn', glb.XMLconfig['ceconf'],
ldapConfig['login'], glb.config_files['ceconf'])
ds.setXML('.//configengine/source/provisioning',
glb.XMLconfig['ceconf'], authConfig['provisioning'],
glb.config_files['ceconf'])
ds.setXML('.//configengine/source/authentication',
glb.XMLconfig['ceconf'], authConfig['authentication'],
glb.config_files['ceconf'])
hostname = os.popen('echo `hostname -f`').read().rstrip()
ldapPass = ds.getEncrypted(ldapConfig['pass'],
glb.XMLconfig['ceconf'],
'.//configengine/ldap/login/protected',
hostname)
ds.setXML('.//configengine/ldap/login/password',
glb.XMLconfig['ceconf'],
ldapPass,
glb.config_files['ceconf'],
hideValue=True)
# Prompt for users and group to be imported
if ds.askYesOrNo("\nRestore users and groups"):
finalChange = True
sqlPath = glb.dsapptmp + '/' + fileName + '/SQLsettings'
conn = ds.getConn('datasync')
cur = conn.cursor()
print("Restoring users..")
cur.execute(open(sqlPath + '/targets.sql', 'r').read())
logger.info('Imported targets.sql into datasync database')
print("Restoring groups..")
cur.execute(open(sqlPath + '/membershipCache.sql', 'r').read())
logger.info('Imported membershipCache.sql into datasync database')
cur.close()
conn.close()
# Prompt for backup certs to be applied # TODO: Will this be needed?
# if ds.askYesOrNo("\nRestore backup certificates"):
# finalChange = True
if finalChange:
ds.rcDS('restart', show_spinner=False, show_print=False)
print("Restore complete")
logger.info("Restore complete")
