Exemplo n.º 1
0
def build_sysversion(config_registry):
	sysversion = '%s-%s' % (config_registry['version/version'], config_registry['version/patchlevel'], )
	if config_registry.get('version/security-patchlevel'):
		sysversion = "%s-%s" % (sysversion, config_registry['version/security-patchlevel'], )
	if config_registry.get('version/erratalevel'):
		sysversion = "%s errata%s" % (sysversion, config_registry['version/erratalevel'], )
	return sysversion
Exemplo n.º 2
0
def open_database_connection(config_registry, pkgdbu=False, db_server=None):
    connection_info = {  # see <http://www.postgresql.org/docs/8.4/static/libpq-connect.html>
     'dbname': 'pkgdb',
    }
    if config_registry.is_true('pkgdb/requiressl'):
        connection_info['sslmode'] = 'require'
    if pkgdbu:
        # 'host' not specified -> localhost over Unix-domain socket (connection type "local")
        connection_info['user'] = '******'
        password_file = '/etc/postgresql/pkgdb.secret'
    else:
        if db_server is None:
            db_server = get_dbservername(config_registry['domainname'])
            if db_server is None:
                return None
        connection_info['host'] = db_server
        connection_info['user'] = config_registry.get(
            'pkgdb/user', '%s$' % (config_registry['hostname'], ))
        password_file = config_registry.get('pkgdb/pwdfile',
                                            '/etc/machine.secret')
    connection_info['password'] = open(password_file, 'rb').read().rstrip('\n')
    connectstring = ' '.join([
        "%s='%s'" % (
            key,
            value.replace('\\', '\\\\').replace("'", "\\'"),
        ) for (
            key,
            value,
        ) in connection_info.items()
    ])
    connection = pgdb.connect(database=connectstring)
    return connection
Exemplo n.º 3
0
def open_database_connection(config_registry, pkgdbu=False, db_server=None):
	connection_info = { # see <http://www.postgresql.org/docs/8.4/static/libpq-connect.html>
		'dbname': 'pkgdb',
		}
	if config_registry.is_true('pkgdb/requiressl'):
		connection_info['sslmode'] = 'require'
	if pkgdbu:
		# 'host' not specified -> localhost over Unix-domain socket (connection type "local")
		connection_info['user'] = '******'
		password_file = '/etc/postgresql/pkgdb.secret'
	else:
		if db_server is None:
			db_server = get_dbservername(config_registry['domainname'])
			if db_server is None:
				return None
		connection_info['host'] = db_server
		connection_info['user'] = config_registry.get('pkgdb/user', '%s$' % (config_registry['hostname'], ))
		password_file = config_registry.get('pkgdb/pwdfile', '/etc/machine.secret')
	connection_info['password'] = open(password_file, 'rb').read().rstrip('\n')
	connectstring = ' '.join(
		[
			"%s='%s'" % (key,
			             value.replace('\\', '\\\\').replace("'", "\\'"),
			             )
			for (key, value, )
			in connection_info.items()
			]
		)
	connection = pgdb.connect(database=connectstring)
	return connection
def get_dns_server(config_registry, active_services):
    if config_registry.is_true('ad/member'):
        ad_domain_info = univention.lib.admember.lookup_adds_dc()
        server = ad_domain_info.get('DC IP')
    else:
        hostname = config_registry.get('hostname')
        domainname = config_registry.get('domainname')
        if set(active_services) >= {'Samba 4', 'DNS'}:
            server = ".".join([hostname, domainname])
        else:
            ## TODO: Memberserver in Samba 4 domain
            server = None
    return server
def check_nsupdate(config_registry, server):
    hostname = config_registry.get('hostname')
    domainname = config_registry.get('domainname')

    try:
        check_dns_machine_principal(server, hostname, domainname)
    except UpdateError as error:
        yield error

    if config_registry.get('samba4/role') == 'DC':
        try:
            check_dns_server_principal(hostname, domainname)
        except UpdateError as error:
            yield error
Exemplo n.º 6
0
def action_scan(connection, cursor, config_registry):
    '''put systems <sysname> in the database and updates it with the current package state'''
    connection.rollback()
    sysname = config_registry['hostname']
    sysversion = '%s-%s' % (
        config_registry['version/version'],
        config_registry['version/patchlevel'],
    )
    if config_registry.get('version/security-patchlevel'):
        sysversion = "%s-%s" % (
            sysversion,
            config_registry['version/security-patchlevel'],
        )
    sysrole = config_registry['server/role']
    ldaphostdn = config_registry['ldap/hostdn']
    apt_pkg.init()
    architecture = apt_pkg.Config.find("APT::Architecture")
    log('Starting scan of system %r' % (sysname, ))
    try:
        sql_put_sys_in_systems(cursor, sysname, sysversion, sysrole,
                               ldaphostdn, architecture)
        fake_null = False
    except pgdb.DatabaseError:
        # assume we are connected to a univention-pkgdb < 6.0.7-1 (old schema)
        connection.rollback()
        # retry for old schema
        sql_put_sys_in_systems_no_architecture(cursor, sysname, sysversion,
                                               sysrole, ldaphostdn)
        fake_null = True  # old schema has NOT NULL, thus we have to use '' instead of None
    scan_and_store_packages(cursor, sysname, fake_null)
    connection.commit()
    log('end of scan for system %r' % (sysname, ))
    return 0
Exemplo n.º 7
0
def action_fill_testdb(connection, cursor, config_registry):
    '''Fülle Testdatenbank'''
    connection.rollback()
    sysversion = '%s-%s' % (
        config_registry['version/version'],
        config_registry['version/patchlevel'],
    )
    if config_registry.get('version/security-patchlevel'):
        sysversion = "%s-%s" % (
            sysversion,
            config_registry['version/security-patchlevel'],
        )
    sysrole = config_registry['server/role']
    ldaphostdn = config_registry['ldap/hostdn']
    apt_pkg.init()
    architecture = apt_pkg.Config.find("APT::Architecture")
    log('start fill of testdb ')
    for sysname in ['testsystem%04d' % (i, ) for i in xrange(1, 1500)]:
        try:
            sql_put_sys_in_systems(cursor, sysname, sysversion, sysrole,
                                   ldaphostdn, architecture)
            fake_null = False
        except pgdb.DatabaseError:
            # assume we are connected to a univention-pkgdb < 6.0.7-1 (old schema)
            connection.rollback()
            # retry for old schema
            sql_put_sys_in_systems_no_architecture(cursor, sysname, sysversion,
                                                   sysrole, ldaphostdn)
            fake_null = True  # old schema has NOT NULL, thus we have to use '' instead of None
        scan_and_store_packages(cursor, sysname, fake_null)
        connection.commit()
    log('end of fill testdb')
    return 0
Exemplo n.º 8
0
def action_scan(connection, cursor, config_registry):
	'''put systems <sysname> in the database and updates it with the current package state'''
	connection.rollback()
	sysname = config_registry['hostname']
	sysversion = '%s-%s' % (config_registry['version/version'], config_registry['version/patchlevel'], )
	if config_registry.get('version/security-patchlevel'):
		sysversion = "%s-%s" % (sysversion, config_registry['version/security-patchlevel'], )
	sysrole    = config_registry['server/role']
	ldaphostdn = config_registry['ldap/hostdn']
	apt_pkg.init()
	architecture = apt_pkg.Config.find("APT::Architecture")
	log('Starting scan of system %r' % (sysname, ))
	try:
		sql_put_sys_in_systems(cursor, sysname, sysversion, sysrole, ldaphostdn, architecture)
		fake_null = False
	except pgdb.DatabaseError:
		# assume we are connected to a univention-pkgdb < 6.0.7-1 (old schema)
		connection.rollback()
		# retry for old schema
		sql_put_sys_in_systems_no_architecture(cursor, sysname, sysversion, sysrole, ldaphostdn)
		fake_null = True # old schema has NOT NULL, thus we have to use '' instead of None
	scan_and_store_packages(cursor, sysname, fake_null)
	connection.commit()
	log('end of scan for system %r' % (sysname, ))
	return 0
Exemplo n.º 9
0
def action_fill_testdb(connection, cursor, config_registry):
	'''Fülle Testdatenbank'''
	connection.rollback()
	sysversion = '%s-%s' % (config_registry['version/version'], config_registry['version/patchlevel'], )
	if config_registry.get('version/security-patchlevel'):
		sysversion = "%s-%s" % (sysversion, config_registry['version/security-patchlevel'], )
	sysrole    = config_registry['server/role']
	ldaphostdn = config_registry['ldap/hostdn']
	apt_pkg.init()
	architecture = apt_pkg.Config.find("APT::Architecture")
	log('start fill of testdb ')
	for sysname in ['testsystem%04d' % (i, ) for i in xrange(1, 1500)]:
		try:
			sql_put_sys_in_systems(cursor, sysname, sysversion, sysrole, ldaphostdn, architecture)
			fake_null = False
		except pgdb.DatabaseError:
			# assume we are connected to a univention-pkgdb < 6.0.7-1 (old schema)
			connection.rollback()
			# retry for old schema
			sql_put_sys_in_systems_no_architecture(cursor, sysname, sysversion, sysrole, ldaphostdn)
			fake_null = True # old schema has NOT NULL, thus we have to use '' instead of None
		scan_and_store_packages(cursor, sysname, fake_null)
		connection.commit()
	log('end of fill testdb')
	return 0