Ejemplo n.º 1
0
def adduser(login="******", name="Majerti", firstname="Admin",
                                                    primary_group="1"):
    """
        Add a user to the database
    """
    password = gen_random_str(10)
    md5_pass = md5(password).hexdigest()
    cmd = "echo \"INSERT INTO egw_accounts (account_lid, account_pwd, account_firstname, \
account_lastname, account_status, account_primary_group, \
account_email) VALUES ('{0}', '{1}', '{2}', '{3}', 'A', '{4}', \
'*****@*****.**');\" | mysql -uroot autonomie" .format(login, md5_pass,
                                                firstname, name, primary_group)
    launch_cmd(cmd)
    print "New password : {0}".format(password)
Ejemplo n.º 2
0
def adduser(login="******",
            name="Majerti",
            firstname="Admin",
            primary_group="1"):
    """
        Add a user to the database
    """
    password = gen_random_str(10)
    md5_pass = md5(password).hexdigest()
    cmd = "echo \"INSERT INTO egw_accounts (account_lid, account_pwd, account_firstname, \
account_lastname, account_status, account_primary_group, \
account_email) VALUES ('{0}', '{1}', '{2}', '{3}', 'A', '{4}', \
'*****@*****.**');\" | mysql -uroot autonomie".format(
        login, md5_pass, firstname, name, primary_group)
    launch_cmd(cmd)
    print "New password : {0}".format(password)
Ejemplo n.º 3
0
def gen_database(dbname="autonomie", user="******"):
    """
        generates a database and a specific user and generates
        a random password
    """
    password = gen_random_str()
    if os.path.isdir("/var/lib/mysql/{0}".format(dbname)):
        print "The database {0} already exists, only modifying password".format(
            dbname)
        sql_cmds = get_sql_grant_cmds(user, password, dbname)
    else:
        sql_cmds = get_sql_create_cmds(user, password, dbname)
        sql_cmds.extend(get_sql_grant_cmds(user, password, dbname))

    for sql_cmd in sql_cmds:
        bash_cmd = get_bash_cmd(sql_cmd)
        launch_cmd(bash_cmd)
    return password
Ejemplo n.º 4
0
def gen_database(dbname="autonomie", user="******"):
    """
        generates a database and a specific user and generates
        a random password
    """
    password = gen_random_str()
    if os.path.isdir("/var/lib/mysql/{0}".format(dbname)):
        print "The database {0} already exists, only modifying password".format(
                                                                        dbname)
        sql_cmds = get_sql_grant_cmds(user, password, dbname)
    else:
        sql_cmds = get_sql_create_cmds(user, password, dbname)
        sql_cmds.extend(get_sql_grant_cmds(user, password, dbname))

    for sql_cmd in sql_cmds:
        bash_cmd = get_bash_cmd(sql_cmd)
        launch_cmd(bash_cmd)
    return password