def install_db(root_login="******", root_password=None, db_name=None, source_sql=None, admin_password=None, verbose=True, force=0, site_config=None, reinstall=False): make_conf(db_name, site_config=site_config) frappe.flags.in_install_db = True if reinstall: frappe.connect(db_name=db_name) dbman = DbManager(frappe.local.db) dbman.create_database(db_name) else: frappe.local.db = get_root_connection(root_login, root_password) frappe.local.session = frappe._dict({'user':'******'}) create_database_and_user(force, verbose) frappe.conf.admin_password = frappe.conf.admin_password or admin_password frappe.connect(db_name=db_name) check_if_ready_for_barracuda() import_db_from_sql(source_sql, verbose) remove_missing_apps() create_auth_table() create_list_settings_table() frappe.flags.in_install_db = False
def install_db(root_login="******", root_password=None, db_name=None, source_sql=None, admin_password='******', verbose=True, force=0, site_config=None, reinstall=False): frappe.flags.in_install_db = True db_name = db_name[:16] if "." in db_name: dn = db_name.split('.') db_name = dn[0] frappe.errprint(db_name) make_conf(db_name, site_config=site_config) if reinstall: frappe.connect(db_name=db_name) dbman = DbManager(frappe.local.db) dbman.create_database(db_name) else: frappe.local.db = make_connection(root_login, root_password) frappe.local.session = frappe._dict({'user': '******'}) create_database_and_user(force, verbose) frappe.conf.admin_password = admin_password frappe.connect(db_name=db_name) import_db_from_sql(source_sql, verbose) create_auth_table() frappe.flags.in_install_db = False
def create_database_and_user(force, verbose): db_name = frappe.local.conf.db_name db_name = db_name[:16] if "." in db_name: dn = db_name.split('.') db_name = dn[0] dbman = DbManager(frappe.local.db) #print db_name #print dbman.get_database_list() if force or (db_name not in dbman.get_database_list()): #print "in if" dbman.delete_user(db_name) dbman.drop_database(db_name) else: raise Exception("Database %s already exists" % (db_name, )) dbman.create_user(db_name, frappe.conf.db_password) if verbose: print "Created user %s" % db_name dbman.create_database(db_name) if verbose: print "Created database %s" % db_name dbman.grant_all_privileges(db_name, db_name) dbman.flush_privileges() if verbose: print "Granted privileges to user %s and database %s" % (db_name, db_name) # close root connection frappe.db.close()
def install_db(root_login="******", root_password=None, db_name=None, source_sql=None, admin_password=None, verbose=True, force=0, site_config=None, reinstall=False): make_conf(db_name, site_config=site_config) frappe.flags.in_install_db = True if reinstall: frappe.connect(db_name=db_name) dbman = DbManager(frappe.local.db) dbman.create_database(db_name) else: frappe.local.db = get_root_connection(root_login, root_password) frappe.local.session = frappe._dict({'user': '******'}) create_database_and_user(force, verbose) frappe.conf.admin_password = frappe.conf.admin_password or admin_password frappe.connect(db_name=db_name) check_if_ready_for_barracuda() import_db_from_sql(source_sql, verbose) remove_missing_apps() create_auth_table() create_list_settings_table() frappe.flags.in_install_db = False
def create_database_and_user(force, verbose, no_mariadb_socket): db_name = frappe.local.conf.db_name dbman = DbManager(frappe.local.db) if force or (db_name not in dbman.get_database_list()): dbman.delete_user(db_name) if no_mariadb_socket: dbman.delete_user(db_name, host="%") dbman.drop_database(db_name) else: raise Exception("Database %s already exists" % (db_name,)) dbman.create_user(db_name, frappe.conf.db_password) if no_mariadb_socket: dbman.create_user(db_name, frappe.conf.db_password, host="%") if verbose: print("Created user %s" % db_name) dbman.create_database(db_name) if verbose: print("Created database %s" % db_name) dbman.grant_all_privileges(db_name, db_name) if no_mariadb_socket: dbman.grant_all_privileges(db_name, db_name, host="%") dbman.flush_privileges() if verbose: print("Granted privileges to user %s and database %s" % (db_name, db_name)) # close root connection frappe.db.close()
def create_database_and_user(force, verbose): db_name = frappe.local.conf.db_name db_name=db_name[:16] if "." in db_name: dn=db_name.split('.') db_name=dn[0] dbman = DbManager(frappe.local.db) #print db_name #print dbman.get_database_list() if force or (db_name not in dbman.get_database_list()): #print "in if" dbman.delete_user(db_name) dbman.drop_database(db_name) else: raise Exception("Database %s already exists" % (db_name,)) dbman.create_user(db_name, frappe.conf.db_password) if verbose: print "Created user %s" % db_name dbman.create_database(db_name) if verbose: print "Created database %s" % db_name dbman.grant_all_privileges(db_name, db_name) dbman.flush_privileges() if verbose: print "Granted privileges to user %s and database %s" % (db_name, db_name) # close root connection frappe.db.close()
def install_db(root_login="******", root_password=None, db_name=None, source_sql=None, admin_password=None, verbose=True, force=0, site_config=None, reinstall=False, no_mariadb_socket=False): make_conf(db_name, site_config=site_config) frappe.flags.in_install_db = True if reinstall: frappe.connect(db_name=db_name) dbman = DbManager(frappe.local.db) dbman.create_database(db_name) else: frappe.local.db = get_root_connection(root_login, root_password) frappe.local.session = frappe._dict({'user':'******'}) create_database_and_user(force, verbose, no_mariadb_socket) frappe.conf.admin_password = frappe.conf.admin_password or admin_password frappe.connect(db_name=db_name) check_if_ready_for_barracuda() import_db_from_sql(source_sql, verbose) if not 'tabDefaultValue' in frappe.db.get_tables(): print('''Database not installed, this can due to lack of permission, or that the database name exists. Check your mysql root password, or use --force to reinstall''') sys.exit(1) remove_missing_apps() create_auth_table() setup_global_search_table() create_user_settings_table() frappe.flags.in_install_db = False
def install_db(root_login="******", root_password=None, db_name=None, source_sql=None, admin_password = '******', verbose=True, force=0, site_config=None, reinstall=False): frappe.flags.in_install_db = True db_name=db_name[:16] if "." in db_name: dn=db_name.split('.') db_name=dn[0] frappe.errprint(db_name) make_conf(db_name, site_config=site_config) if reinstall: frappe.connect(db_name=db_name) dbman = DbManager(frappe.local.db) dbman.create_database(db_name) else: frappe.local.db = make_connection(root_login, root_password) frappe.local.session = frappe._dict({'user':'******'}) create_database_and_user(force, verbose) frappe.conf.admin_password = admin_password frappe.connect(db_name=db_name) import_db_from_sql(source_sql, verbose) create_auth_table() frappe.flags.in_install_db = False
def install_db(root_login="******", root_password=None, db_name=None, source_sql=None, admin_password=None, verbose=True, force=0, site_config=None, reinstall=False): make_conf(db_name, site_config=site_config) frappe.flags.in_install_db = True if reinstall: frappe.connect(db_name=db_name) dbman = DbManager(frappe.local.db) dbman.create_database(db_name) else: frappe.local.db = get_root_connection(root_login, root_password) frappe.local.session = frappe._dict({'user':'******'}) create_database_and_user(force, verbose) frappe.conf.admin_password = frappe.conf.admin_password or admin_password frappe.connect(db_name=db_name) check_if_ready_for_barracuda() import_db_from_sql(source_sql, verbose) if not 'tabDefaultValue' in frappe.db.get_tables(): print('''Database not installed, this can due to lack of permission, or that the database name exists. Check your mysql root password, or use --force to reinstall''') sys.exit(1) remove_missing_apps() create_auth_table() setup_global_search_table() create_user_settings_table() frappe.flags.in_install_db = False
def make_database(self): dbman = DbManager(get_root_connection()) # make database if not help_db_name in dbman.get_database_list(): dbman.create_user(help_db_name, help_db_name) dbman.create_database(help_db_name) dbman.grant_all_privileges(help_db_name, help_db_name) dbman.flush_privileges()
def make_database(self): dbman = DbManager(get_root_connection()) # make database if not help_db_name in dbman.get_database_list(): dbman.create_user(help_db_name, help_db_name) dbman.create_database(help_db_name) dbman.grant_all_privileges(help_db_name, help_db_name) dbman.flush_privileges()
def make_database(self): '''make database for global help setup''' if not self.global_help_setup: return dbman = DbManager(get_root_connection()) dbman.drop_database(self.help_db_name) # make database if not self.help_db_name in dbman.get_database_list(): try: dbman.create_user(self.help_db_name, self.help_db_name) except Exception as e: # user already exists if e.args[0] != 1396: raise dbman.create_database(self.help_db_name) dbman.grant_all_privileges(self.help_db_name, self.help_db_name) dbman.flush_privileges()
def make_database(self): '''make database for global help setup''' if not self.global_help_setup: return dbman = DbManager(get_root_connection()) dbman.drop_database(self.help_db_name) # make database if not self.help_db_name in dbman.get_database_list(): try: dbman.create_user(self.help_db_name, self.help_db_name) except Exception as e: # user already exists if e.args[0] != 1396: raise dbman.create_database(self.help_db_name) dbman.grant_all_privileges(self.help_db_name, self.help_db_name) dbman.flush_privileges()
def create_database_and_user(force, verbose): db_name = frappe.local.conf.db_name dbman = DbManager(frappe.local.db) if force or (db_name not in dbman.get_database_list()): dbman.delete_user(db_name, get_current_host()) dbman.drop_database(db_name) else: raise Exception("Database %s already exists" % (db_name,)) dbman.create_user(db_name, frappe.conf.db_password, get_current_host()) if verbose: print "Created user %s" % db_name dbman.create_database(db_name) if verbose: print "Created database %s" % db_name dbman.grant_all_privileges(db_name, db_name, get_current_host()) dbman.flush_privileges() if verbose: print "Granted privileges to user %s and database %s" % (db_name, db_name) # close root connection frappe.db.close()