Exemple #1
0
def application_info_user_add(request):

    vhost_id_req = request.POST.get('vhost_id', '').split(',')
    middleware_req = request.POST.get('middleware', '')
    username_req = request.POST.get('username', '')
    package_req = request.POST.get('package_name', '')
    password = username_req + '#Pass'

    logging.info(vhost_id_req, middleware_req, username_req, package_req,
                 password)
    create_host_user_cmd = 'useradd -g app -md /app/'+ username_req +' -s /bin/csh '+ username_req +';echo '+ password +'|passwd --stdin '+ username_req +';'\
                           'mkdir -p /data;cd /data;mkdir -p '+ username_req +'/logs;chmod 755 '+ username_req +';chown -R '+ username_req +':app '+ username_req +';'
    host_user = []
    for host_id in vhost_id_req[:len(vhost_id_req)]:
        host_user.append(
            app_user(username=username_req,
                     password=password,
                     middleware=middleware_req,
                     package=package_req,
                     host_id=host_id))
        #ip = vhost.objects.all().filter(host_id=host_id).distinct().values('vhost_name');
        hostname = vhost.objects.get(host_id=host_id).vhost_name
        ssh2(hostname, create_host_user_cmd)

    app_user.objects.bulk_create(host_user)

    return HttpResponse('Already created user!')
Exemple #2
0
def nbu_startjob_byhand(request):
    master = request.REQUEST.get('master', '').split()
    client = request.REQUEST.get('client', '').split()
    policy = request.REQUEST.get('policy', '').split()
    status = 'redoing'
    
    if client:
        client = client[0].encode('utf-8')
    if policy:
        policy = policy[0].encode('utf-8')        
    if master:
        master = master[0].encode('utf-8')
        
    cmd_backup = "bpbackup -i -p "+ policy +" -h " + client +" -S " + master +" ;sleep 15;bpdbjobs -report -M "+master+"|awk '/Active/&&/"+policy+"/&&/"+client+"/{print $1}'|head -1;"
    print(cmd_backup)
    jobid = ssh2(cmd_backup)
    
    if jobid:
        jobid = jobid[0].encode('utf-8').strip()
    else:
        cmd_check = "bpdbjobs -report -M "+master+"|awk '/Done/&&/"+policy+"/&&/"+client+"/{print $1}'|head -1;"
        jobid = ssh2(cmd_check)[0].encode('utf-8').strip()
        cmd_status = "bpdbjobs -report -M "+master+" -jobid "+jobid+"|awk '/Done/{print $4}'"        
        status = ssh2(cmd_status)[0].encode('utf-8').strip()
        if status == '0' :
            status = 'success'
        else:
            status = 'failed'

    job = nbu_jobs_byhand(jobid=jobid,client=client,policy=policy,master=master,status=status,start_date=datetime.now().strftime("%Y-%m-%d %H:%M:%S"))
    job.save()
    
    return HttpResponse('update success')
Exemple #3
0
def nbu_jobs_problem():
    
    cmd4zjbjbak_svc = "bpdbjobs -most_columns -M zjbjbak_svc|awk -F , '($2==0)&&($3==3)&&($4 > 0){print $1,$4,$5,$6,$7,$8}'|grep -v test|sort -k 5 |uniq -f 1 -f 2 -f 4"
    cmd4zjdamaster1 = "bpdbjobs -most_columns |awk -F , '($2==0)&&($3==3)&&($4 > 0){print $1,$4,$5,$6,$7,$8}'|grep -v test|sort -k 5 |uniq -f 1 -f 2 -f 4"
    out_zjbjbak_svc = ssh2(cmd4zjbjbak_svc)
    out_zjdamaster1 = ssh2(cmd4zjdamaster1)
    
    return out_zjbjbak_svc, out_zjdamaster1
Exemple #4
0
def nbu_device():
    media = {}
    cmd_mediatotal = "ssh -A -t zjbjbak1 \"/usr/openv/volmgr/bin/vmquery -bx -a|grep -v -E 'NONE|CLN'|wc -l\""
    cmd_availmedia = "ssh -A -t zjbjbak1 \"/usr/openv/volmgr/bin/vmquery -bx -a|grep -E '\\-\\-\\-'|grep -v -E 'NONE|CLN'|wc -l\""
    cmd_mediascratch = "ssh -A -t zjbjbak1 \"/usr/openv/volmgr/bin/vmquery -bx -a|grep ScratchPool|grep -v -E 'NONE|CLN'|wc -l\""
    cmd_mediaexpired = "ssh -A -t zjbjbak1 \"/usr/openv/volmgr/bin/vmquery -bx -a|grep Expired_media|grep -v -E 'NONE|CLN'|wc -l\""
    cmd_mediaforzen = "ssh -A -t -v zjbjbak1 \"/usr/openv/netbackup/bin/admincmd/bpmedialist  |grep  -i frozen|wc -l\""
    media['mediatotal'] = ssh2(cmd_mediatotal)[0].strip('\n')
    
    media['availmedia'] = ssh2(cmd_availmedia)[0].strip('\n')
    media['mediascratch'] = ssh2(cmd_mediascratch)[0].strip('\n')
    media['mediaexpired'] = ssh2(cmd_mediaexpired)[0].strip('\n')
    media['mediaforzen'] = ssh2(cmd_mediaforzen)[0].strip('\n')
    return media
Exemple #5
0
def nbu_ajax_jobs(request):
    
    master = request.REQUEST.get('master', '').split()
    jobid = request.REQUEST.get('jobid', '').split()
    client = request.REQUEST.get('client', '').split()
    policy = request.REQUEST.get('policy', '').split()
    redo_jobid = request.REQUEST.get('redo_jobid', '').split()
    jobid = jobid[0]
    redo_jobid = redo_jobid[0].encode('utf-8')

    if redo_jobid !='None':
        jobid = redo_jobid
    print(jobid)    

    error_info = ''
    oracle_type = 'db'
    ploicy_name = policy[0]
    if 'arch' in ploicy_name:
        oracle_type = 'arch'
    print(ploicy_name)    
    if ( 'oracle' in ploicy_name):
        print('hello')
        if (master[0] == 'zjbjbak_svc'):
            cmd = r"ssh -A -t -l root "+master[0]+" \"scp /tmp/nbu_rmanerr.sh root@" + client[0] + ":/tmp/;\" ssh -A -t -l root "+ client[0] + " \"sh /tmp/nbu_rmanerr.sh " + oracle_type + ";\""
            print(cmd)
            error_info = ssh2(cmd)
            if  error_info :           
                print("error_info_zj"+error_info[0])
        else:
            cmd = r"scp /tmp/nbu_rmanerr.sh root@" + client[0] + ":/tmp/;\" ssh -A -t -l root "+ client[0] + " \"sh /tmp/nbu_rmanerr.sh " + oracle_type + ";\""
            #print(cmd)
            error_info = ssh2(cmd)
            if  error_info :           
                print("error_info_master"+error_info[0])
    else:
        cmd = "bperror -problems -backstat -L -M " + master[0] +" -jobid " + jobid
        print(cmd)
        error_info = ssh2(cmd)
    
    line_error_info = ''
    if  len(error_info) > 0 : 
        for error in error_info:
            line_error_info += error +'\n'
        error_info = line_error_info
    else:
        error_info = "Nothing"
        
    return HttpResponse(error_info)
Exemple #6
0
def addprojectauto(request):

    projecthostinfo = getdatafromcmdb()
    putdatatodb(projecthostinfo)

    for host in projecthostinfo:
        host_info = host[1].split('_')
        host_name = host_info[2]
        host_ip = host[2]
        establishtrust(host_ip, host_name)
        if (len(host_info) == 5):
            if (int(host_info[4]) != 0):
                username = host_name[4:len(host_info) - 2] + host_info[3]
                password = username + '#Pass'

                create_deploy_user = r'/usr/sbin/useradd -g app -md /app/'+ username +' -s /bin/csh '+ username +';/bin/echo '+ password +'|/usr/bin/passwd --stdin '+ username +';'\
                           '/bin/mkdir -p /data;cd /data;/bin/mkdir -p '+ username +'/logs;/bin/chmod 755 '+ username +';/bin/chown -R '+ username +':app '+ username +';'

                userexist = ssh2(host_ip, r'grep ' + username + ' /etc/passwd')
                if (userexist):
                    break
                else:
                    logging.info(create_deploy_user)
            #ssh2(host_ip,create_deploy_user)

    return HttpResponse(u'数据获取成功!')
Exemple #7
0
def addprojectauto(request):
    
    projecthostinfo = getdatafromcmdb()
    putdatatodb(projecthostinfo)

    for host in projecthostinfo:
        host_info = host[1].split('_')
        host_name = host_info[2]
        host_ip = host[2]
        establishtrust(host_ip,host_name)
        if(len(host_info)==5):
            if(int(host_info[4])!=0):
                username =  host_name[4:len(host_info)-2] + host_info[3]
                password = username + '#Pass'
        
                create_deploy_user = r'/usr/sbin/useradd -g app -md /app/'+ username +' -s /bin/csh '+ username +';/bin/echo '+ password +'|/usr/bin/passwd --stdin '+ username +';'\
                           '/bin/mkdir -p /data;cd /data;/bin/mkdir -p '+ username +'/logs;/bin/chmod 755 '+ username +';/bin/chown -R '+ username +':app '+ username +';'
                
                
                userexist = ssh2(host_ip,r'grep '+username+' /etc/passwd')
                if(userexist):
                    break;
                else:
                    logging.info(create_deploy_user)
            #ssh2(host_ip,create_deploy_user)
    
    return HttpResponse(u'数据获取成功!')
Exemple #8
0
def application_info_user_add(request):

    vhost_id_req = request.POST.get("vhost_id", "").split(",")
    middleware_req = request.POST.get("middleware", "")
    username_req = request.POST.get("username", "")
    package_req = request.POST.get("package_name", "")
    password = username_req + "#Pass"

    logging.info(vhost_id_req, middleware_req, username_req, package_req, password)
    create_host_user_cmd = (
        "useradd -g app -md /app/"
        + username_req
        + " -s /bin/csh "
        + username_req
        + ";echo "
        + password
        + "|passwd --stdin "
        + username_req
        + ";"
        "mkdir -p /data;cd /data;mkdir -p "
        + username_req
        + "/logs;chmod 755 "
        + username_req
        + ";chown -R "
        + username_req
        + ":app "
        + username_req
        + ";"
    )
    host_user = []
    for host_id in vhost_id_req[: len(vhost_id_req)]:
        host_user.append(
            app_user(
                username=username_req,
                password=password,
                middleware=middleware_req,
                package=package_req,
                host_id=host_id,
            )
        )
        # ip = vhost.objects.all().filter(host_id=host_id).distinct().values('vhost_name');
        hostname = vhost.objects.get(host_id=host_id).vhost_name
        ssh2(hostname, create_host_user_cmd)

    app_user.objects.bulk_create(host_user)

    return HttpResponse("Already created user!")
Exemple #9
0
def check_policy():
    policy_zjbjbak_svc = ssh2("bppllist -M zjbjbak_svc")
    policy_zjdamaster1 = ssh2("bppllist")
    #INSERT_policy = "INSERT INTO daily_nbu_policy (policy,master,active) VALUES (%s,%s,%s)"
    INSERT_client_policy = "INSERT INTO  daily_nbu_client_policy (client,policy,master,active) VALUES (%s,%s,%s,%s)"
    
    try:
        conn = mysql.connector.connect(host='10.70.219.10',user='******',password='******',database='ops')
        cur=conn.cursor()
        
        # For simple bussiness logic ,we trancat table and insert the laster data whcih collect from master server
        cur.execute("truncate daily_nbu_client_policy;")
        
        if policy_zjbjbak_svc :
            for policy in policy_zjbjbak_svc:
                policy = policy.strip('\n')
                result = ssh2("bppllist "+policy+" -M  zjbjbak_svc -L|awk '/^Active|^Client\//{print $2}'")
                print(policy,result[0].strip('\n'))
                if result :   
                    if len(result)>1:
                        client_cmd = result[1:len(result)]
                        for client in client_cmd :
                            cur.execute(INSERT_client_policy,(client.strip('\n'),policy,'zjbjbak_svc',result[0].strip('\n')))
                    else:
                        cur.execute(INSERT_client_policy,('NoClient',policy,'zjbjbak_svc',result[0].strip('\n')))
        
        conn.commit()
                                              
        if policy_zjdamaster1 :
            for policy in policy_zjdamaster1:
                policy = policy.strip('\n')
                result = ssh2("bppllist "+policy+"  -L|awk '/^Active|^Client\//{print $2}'")
                if result :
                    if len(result)>1:
                        client_cmd = result[1:len(result)]
                        for client in client_cmd :
                            cur.execute(INSERT_client_policy,(client.strip('\n'),policy,'zjdamaster1',result[0].strip('\n')))
                    else:
                        cur.execute(INSERT_client_policy,('NoClient',policy,'zjdamaster1',result[0].strip('\n')))
                            
        conn.commit()
        cur.close()
        conn.close()
            
    except mysql.connector.Error,e:
        print "Mysql Error %d: %s" % (e.args[0], e.args[1])    
Exemple #10
0
def application_info_user_add(request):
    
    vhost_id_req = request.POST.get('vhost_id', '').split(',')
    middleware_req = request.POST.get('middleware', '')
    username_req = request.POST.get('username', '')
    package_req = request.POST.get('package_name', '')
    password= username_req + '#Pass'
    
    logging.info(vhost_id_req,middleware_req,username_req,package_req,password)
    create_host_user_cmd = 'useradd -g app -md /app/'+ username_req +' -s /bin/csh '+ username_req +';echo '+ password +'|passwd --stdin '+ username_req +';'\
                           'mkdir -p /data;cd /data;mkdir -p '+ username_req +'/logs;chmod 755 '+ username_req +';chown -R '+ username_req +':app '+ username_req +';'
    host_user = []
    for host_id in vhost_id_req[:len(vhost_id_req)]:
        host_user.append(app_user(username=username_req,password=password,middleware=middleware_req,package=package_req,host_id=host_id))
        #ip = vhost.objects.all().filter(host_id=host_id).distinct().values('vhost_name');
        hostname = vhost.objects.get(host_id=host_id).vhost_name
        ssh2(hostname,create_host_user_cmd)
    
    app_user.objects.bulk_create(host_user)
    
    return HttpResponse('Already created user!') 
Exemple #11
0
def addprojectauto(request):

    projecthostinfo = getdatafromcmdb()
    putdatatodb(projecthostinfo)

    for host in projecthostinfo:
        host_info = host[1].split("_")
        host_name = host_info[2]
        host_ip = host[2]
        establishtrust(host_ip, host_name)
        if len(host_info) == 5:
            if int(host_info[4]) != 0:
                username = host_name[4 : len(host_info) - 2] + host_info[3]
                password = username + "#Pass"

                create_deploy_user = (
                    r"/usr/sbin/useradd -g app -md /app/"
                    + username
                    + " -s /bin/csh "
                    + username
                    + ";/bin/echo "
                    + password
                    + "|/usr/bin/passwd --stdin "
                    + username
                    + ";"
                    "/bin/mkdir -p /data;cd /data;/bin/mkdir -p "
                    + username
                    + "/logs;/bin/chmod 755 "
                    + username
                    + ";/bin/chown -R "
                    + username
                    + ":app "
                    + username
                    + ";"
                )

                userexist = ssh2(host_ip, r"grep " + username + " /etc/passwd")
                if userexist:
                    break
                else:
                    logging.info(create_deploy_user)
            # ssh2(host_ip,create_deploy_user)

    return HttpResponse(u"数据获取成功!")
Exemple #12
0
def check_handjobs(request):
    redoingjobs = nbu_jobs_byhand.objects.all().filter(start_date__range=(yesterday,tomorrow),status='redoing').values();
    if redoingjobs :
        for jobs in redoingjobs:
            master = jobs['master'].encode('utf-8')
            jobid = int(jobs['jobid'])
            cmd_status = "bpdbjobs -report -M "+master+" -jobid "+str(jobid)+"|awk '/Done/{print $4}'"        
            status = ssh2(cmd_status)
            if status :
                status = status[0].encode('utf-8').strip('\n')
            else :
                continue
            
            if status == '0' :
                status = 'success'
            else:
                status = 'failed'        
            
            jobs_byhand = nbu_jobs_byhand.objects.get(jobid=jobid)
            jobs_byhand.status = status
            jobs_byhand.save()
            
    return HttpResponse('已经检查,稍后自动刷新页面!'.decode('gbk'))
Exemple #13
0
def addproject(request):

    projectname_req = request.POST.get('project_name', '')
    package_req = request.POST.get('deploy_package', '')
    middleware_req = request.POST.get('middleware', '')
    hostnames_req = request.POST.get('hostname', '').split(',')
    hostnames_cl = hostnames_req[0:len(hostnames_req) - 1]

    order_name = vhost.objects.filter(
        order_name=projectname_req).values('order_no')
    if (order_name):
        return HttpResponse(u'项目已经存在!')

    logging.info(hostnames_cl)
    vhosts = []
    app_users = []
    order_no = 'DL' + (datetime.now()).strftime('%Y%m%d%H%M%S')
    # hostname like : 10.78.200.062_suse_vq12zdfb01_web01_4
    increatment = 1
    for host in hostnames_cl:
        logging.info(host)
        host_info = host.split('_')
        vhost_ip_tmp = host_info[0].split('.')
        logging.info(vhost_ip_tmp)
        vhost_ip = str(vhost_ip_tmp[0]) + '.' + str(
            vhost_ip_tmp[1]) + '.' + str(vhost_ip_tmp[2]) + '.' + str(
                int(vhost_ip_tmp[3]))
        ip_exist = vhost.objects.filter(host_ip=vhost_ip).values('host_ip')
        if (ip_exist):
            return HttpResponse('Host IP :' + vhost_ip + ' Already exist!')
        vhost_name = host_info[2]

        order_name = projectname_req

        hosted_id_db = vhost.objects.order_by('host_id').values(
            'host_id').last()
        hosted_id = int(hosted_id_db['host_id']) + increatment
        logging.info(hosted_id)
        increatment = increatment + 1

        vhosts.append(
            vhost(host_id=hosted_id,
                  host_name=host,
                  vhost_name=vhost_name,
                  host_ip=vhost_ip,
                  order_no=order_no,
                  order_name=order_name,
                  create_date=today,
                  status='hosted'))

        username = vhost_name[4:len(vhost_name) - 2] + host_info[3]
        password = username + '!Pass'

        app_users.append(
            app_user(username=username,
                     password=password,
                     middleware=middleware_req,
                     host_id=hosted_id,
                     package=package_req,
                     instance_num=host_info[4]))

    vhost.objects.bulk_create(vhosts)
    app_user.objects.bulk_create(app_users)

    #establish trust for deploy server and create deploy user
    for host in vhosts:
        host_name = host.vhost_name
        host_ip = host.host_ip
        establishtrust(host_ip, host_name)
        userinfo = app_user.objects.filter(host_id=host.host_id).values(
            'username', 'password')
        for auser in userinfo:
            username = auser['username']
            if (host_name[4:len(host_name) - 2] in username):
                create_deploy_user = r'/usr/sbin/useradd -g app -md /app/'+ username +' -s /bin/csh '+ username +';/bin/echo '+ auser['password'] +'|/usr/bin/passwd --stdin '+ username +';'\
                           '/bin/mkdir -p /data;cd /data;/bin/mkdir -p '+ username +'/logs;/bin/chmod 755 '+ username +';/bin/chown -R '+ username +':app '+ username +';'
                ssh2(host_ip, create_deploy_user)

    return HttpResponse('Already added project information!')
Exemple #14
0
def addproject(request):

    projectname_req = request.POST.get("project_name", "")
    package_req = request.POST.get("deploy_package", "")
    middleware_req = request.POST.get("middleware", "")
    hostnames_req = request.POST.get("hostname", "").split(",")
    hostnames_cl = hostnames_req[0 : len(hostnames_req) - 1]

    order_name = vhost.objects.filter(order_name=projectname_req).values("order_no")
    if order_name:
        return HttpResponse(u"项目已经存在!")

    logging.info(hostnames_cl)
    vhosts = []
    app_users = []
    order_no = "DL" + (datetime.now()).strftime("%Y%m%d%H%M%S")
    # hostname like : 10.78.200.062_suse_vq12zdfb01_web01_4
    increatment = 1
    for host in hostnames_cl:
        logging.info(host)
        host_info = host.split("_")
        vhost_ip_tmp = host_info[0].split(".")
        logging.info(vhost_ip_tmp)
        vhost_ip = (
            str(vhost_ip_tmp[0])
            + "."
            + str(vhost_ip_tmp[1])
            + "."
            + str(vhost_ip_tmp[2])
            + "."
            + str(int(vhost_ip_tmp[3]))
        )
        ip_exist = vhost.objects.filter(host_ip=vhost_ip).values("host_ip")
        if ip_exist:
            return HttpResponse("Host IP :" + vhost_ip + " Already exist!")
        vhost_name = host_info[2]

        order_name = projectname_req

        hosted_id_db = vhost.objects.order_by("host_id").values("host_id").last()
        hosted_id = int(hosted_id_db["host_id"]) + increatment
        logging.info(hosted_id)
        increatment = increatment + 1

        vhosts.append(
            vhost(
                host_id=hosted_id,
                host_name=host,
                vhost_name=vhost_name,
                host_ip=vhost_ip,
                order_no=order_no,
                order_name=order_name,
                create_date=today,
                status="hosted",
            )
        )

        username = vhost_name[4 : len(vhost_name) - 2] + host_info[3]
        password = username + "!Pass"

        app_users.append(
            app_user(
                username=username,
                password=password,
                middleware=middleware_req,
                host_id=hosted_id,
                package=package_req,
                instance_num=host_info[4],
            )
        )

    vhost.objects.bulk_create(vhosts)
    app_user.objects.bulk_create(app_users)

    # establish trust for cloudops server and create cloudops user
    for host in vhosts:
        host_name = host.vhost_name
        host_ip = host.host_ip
        establishtrust(host_ip, host_name)
        userinfo = app_user.objects.filter(host_id=host.host_id).values("username", "password")
        for auser in userinfo:
            username = auser["username"]
            if host_name[4 : len(host_name) - 2] in username:
                create_deploy_user = (
                    r"/usr/sbin/useradd -g app -md /app/"
                    + username
                    + " -s /bin/csh "
                    + username
                    + ";/bin/echo "
                    + auser["password"]
                    + "|/usr/bin/passwd --stdin "
                    + username
                    + ";"
                    "/bin/mkdir -p /data;cd /data;/bin/mkdir -p "
                    + username
                    + "/logs;/bin/chmod 755 "
                    + username
                    + ";/bin/chown -R "
                    + username
                    + ":app "
                    + username
                    + ";"
                )
                ssh2(host_ip, create_deploy_user)

    return HttpResponse("Already added project information!")
Exemple #15
0
def addproject(request):
    

    projectname_req = request.POST.get('project_name','')
    package_req = request.POST.get('deploy_package','')
    middleware_req = request.POST.get('middleware','')
    hostnames_req = request.POST.get('hostname','').split(',')  
    hostnames_cl = hostnames_req[0:len(hostnames_req)-1]
    
    order_name = vhost.objects.filter(order_name = projectname_req).values('order_no')
    if(order_name):
        return HttpResponse(u'项目已经存在!')
    
    logging.info(hostnames_cl)
    vhosts = []
    app_users = []
    order_no = 'DL'+(datetime.now()).strftime('%Y%m%d%H%M%S')
    # hostname like : 10.78.200.062_suse_vq12zdfb01_web01_4
    increatment = 1;
    for host in hostnames_cl:
        logging.info(host)
        host_info =  host.split('_')        
        vhost_ip_tmp = host_info[0].split('.')
        logging.info(vhost_ip_tmp)
        vhost_ip = str(vhost_ip_tmp[0])+'.'+str(vhost_ip_tmp[1])+'.'+str(vhost_ip_tmp[2])+'.' +str(int(vhost_ip_tmp[3]))
        ip_exist = vhost.objects.filter(host_ip = vhost_ip).values('host_ip')
        if(ip_exist):
            return HttpResponse('Host IP :'+vhost_ip+' Already exist!')
        vhost_name = host_info[2]
        
        order_name = projectname_req

        hosted_id_db = vhost.objects.order_by('host_id').values('host_id').last()
        hosted_id = int(hosted_id_db['host_id']) + increatment
        logging.info(hosted_id)
        increatment = increatment + 1
        
        vhosts.append(vhost(host_id=hosted_id,host_name=host,vhost_name=vhost_name,host_ip=vhost_ip,order_no=order_no,order_name=order_name,create_date=today,status='hosted'))
        
        username = vhost_name[4:len(vhost_name)-2] + host_info[3]
        password= username + '!Pass'
        
        app_users.append(app_user(username=username,password=password,middleware=middleware_req,host_id=hosted_id,package=package_req,instance_num=host_info[4]))
   
   
    vhost.objects.bulk_create(vhosts)
    app_user.objects.bulk_create(app_users)
    
    #establish trust for deploy server and create deploy user 
    for host in vhosts:
        host_name = host.vhost_name
        host_ip = host.host_ip
        establishtrust(host_ip,host_name)
        userinfo = app_user.objects.filter(host_id=host.host_id).values('username','password')
        for auser in userinfo:
            username = auser['username']
            if(host_name[4:len(host_name)-2] in username):
                create_deploy_user = r'/usr/sbin/useradd -g app -md /app/'+ username +' -s /bin/csh '+ username +';/bin/echo '+ auser['password'] +'|/usr/bin/passwd --stdin '+ username +';'\
                           '/bin/mkdir -p /data;cd /data;/bin/mkdir -p '+ username +'/logs;/bin/chmod 755 '+ username +';/bin/chown -R '+ username +':app '+ username +';'
                ssh2(host_ip,create_deploy_user)
    
    return HttpResponse('Already added project information!')
Exemple #16
0
def fixjob_auto():
    try:
        conn = mysql.connector.connect(host='10.70.219.10',user='******',password='******',database='ops')
        cur=conn.cursor()
        
        status = [23,25,48,58,59]
        cur.execute("SELECT jobid,status,policy,master,media,client FROM daily_nbu_jobs WHERE redo_status='' and policy not like '%oracle%' and date_format(check_date,'%Y-%m-%d') = '"+today+"' and status in(" +
        ",".join(("%s",) * len(status)) + ")",tuple(status))
        UPDATE = ("UPDATE daily_nbu_jobs SET redo_status = 'success_auto' WHERE jobid=%s")
        UPDATE_message = ("UPDATE daily_nbu_jobs SET redo_message = %s WHERE jobid=%s")

        if(cur):
        
            for jobid,status,policy,master,media,client in cur.fetchall():
                print(jobid,status,policy,master,media,client)
                master_status = ssh2("bptestbpcd  -M "+master+" -host "+client+" ")
                media_status = ssh2(" ssh -A -t -l root zjbjbak2 ssh -A -t -l root "+ media + " bptestbpcd  -host "+client+" ")                
                print('bptest',master_status,media_status)
                server_check = ssh2(" ssh zjbjbak2 ping "+ client + " -n 1 -m 5|grep -E '100%|0%|unknown' ")
                if(master_status=='' and media_status ==''):
                    cur.execute(UPDATE, (jobid))
                    continue
                if(server_check):
                    server_check = server_check[0]
                    if('100%' in server_check or 'unknown' in server_check):
                        print("please client")
                        cur.execute(UPDATE_message, ('Please check the client.',jobid))
                        continue
                    else:                
                        # add host /etc/hosts
                        if master =='zjbjbak_svc' :
                            master_ip_host = '10.70.213.135 zjbjbak_svc'
                        elif master =='zjdamaster1' :
                            master_ip_host = '10.70.219.11 zjdamaster1'
                            
                        media_ip_host = ssh2("ssh zjbjbak2 \"grep "+media+" /etc/hosts|grep -v '^#'|awk '/10.7/{print \$1,\$2}'|head -1  \"")
                        client_ip_host = ssh2("ssh zjbjbak2 \"grep "+client+" /etc/hosts|grep -v '^#'|awk '/10.7/{print \$1,\$2}'|head -1  \"")
                        print('bk2',media_ip_host,client_ip_host)
                        
                        if media_ip_host :
                            media_ip_host = media_ip_host[0].strip('\n')
                        else:
                            cur.execute(UPDATE_message, ('Please check the media server.',jobid))                            
                            continue
                        
                        if client_ip_host :
                            client_ip_host = client_ip_host[0].strip('\n')
                        else:
                            cur.execute(UPDATE_message, ('Please check the client.',jobid))                            
                            continue
                        
                        #master_server
                        if(not master_status):
                            media_ip_host_master = ssh2("ssh -A -t zjbjbak2  ssh -A -t "+master+" \"grep " + media +" /etc/hosts|grep -v '^#'|head -1 |awk '{print \$0}' \"")
                            client_ip_host_master = ssh2("ssh -A -t zjbjbak2  ssh -A -t "+master+" \"grep " + client +" /etc/hosts|grep -v '^#'|head -1 |awk '{print \$0}' \"")
                            if( not media_ip_host_master):
                                ssh2("ssh -A -t zjbjbak2  ssh -A -t "+master+"  \" echo "+media_ip_host+" \>\>/etc/hosts \" ")
                            if( not client_ip_host_master):
                                ssh2("ssh -A -t zjbjbak2  ssh -A -t "+master+"  \" echo "+client_ip_host+" \>\>/etc/hosts \" ")
                                
                        
                        #media_server
                        if(not media_status):
                            master_ip_host_media = ssh2("ssh -A -t zjbjbak2  ssh -A -t "+media+" \"grep " + master +" /etc/hosts|grep -v '^#'|head -1 |awk '{print \$0}' \"")
                            client_ip_host_media = ssh2("ssh -A -t zjbjbak2  ssh -A -t "+media+" \"grep " + client +" /etc/hosts|grep -v '^#'|head -1 |awk '{print \$0}' \"")
                            if(not client_ip_host_media) :
                                ssh2("ssh -A -t zjbjbak2  ssh -A -t "+media+" \"echo "+client_ip_host+" \>\>/etc/hosts\" ")
                            if(not master_ip_host_media) :       
                                ssh2("ssh -A -t zjbjbak2  ssh -A -t "+media+" \"echo "+master_ip_host+" \>\> /etc/hosts\" ")

                        
                        #client
                        master_ip_host_client = ssh2("ssh -A -t zjbjbak2  ssh -A -t "+client+" \"grep " + master +" /etc/hosts|grep -v '^#'|head -1 |awk '{print \$0}' \"")
                        media_ip_host_client = ssh2("ssh -A -t zjbjbak2  ssh -A -t "+client+" \"grep " + media +" /etc/hosts|grep -v '^#'|head -1 |awk '{print \$0}' \"")
                        master_ip_host_conf = ssh2("ssh -A -t zjbjbak2  ssh -A -t "+client+" \"grep " + master +" /usr/openv/netbackup/bp.conf|grep -v '^#'|head -1 |awk '{print \$0}' \"")
                        media_ip_host_conf = ssh2("ssh -A -t zjbjbak2  ssh -A -t "+client+" \"grep " + media +" /usr/openv/netbackup/bp.conf|grep -v '^#'|head -1 |awk '{print \$0}' \"")
                        
                        print('client check',master_ip_host_client,media_ip_host_client,master_ip_host_conf,media_ip_host_conf)
                        if(not master_ip_host_client):
                            ssh2("ssh -A -t zjbjbak2  ssh -A -t "+client+" \"echo "+master_ip_host+" \>\>/etc/hosts \"")

                        if(not media_ip_host_client):
                            ssh2("ssh -A -t zjbjbak2  ssh -A -t "+client+" \"echo "+media_ip_host+" \>\>/etc/hosts \"") 
                        
                        if(not master_ip_host_conf):
                            ssh2("ssh -A -t zjbjbak2  ssh -A -t "+client+" \"echo SERVER = "+master+ " \>\>/usr/openv/netbackup/bp.conf \"")
                                                                            
                        if(not media_ip_host_conf):
                            ssh2("ssh -A -t zjbjbak2  ssh -A -t "+client+" \"echo SERVER = "+media+ " \>\>/usr/openv/netbackup/bp.conf \"")
                            
                        #clean cache
                        ssh2(" ssh -A -t zjbjbak2 ssh -A -t "+master+" \"/usr/openv/netbackup/bin/bpclntcmd -clear_host_cache\"")
                        ssh2(" ssh -A -t zjbjbak2 ssh -A -t "+media+" \"/usr/openv/netbackup/bin/bpclntcmd -clear_host_cache\"")
                        ssh2(" ssh -A -t zjbjbak2 ssh -A -t "+master+" \"/usr/openv/netbackup/bin/admincmd/bptestbpcd -host  "+client+"\"")
                        ssh2(" ssh -A -t zjbjbak2 ssh -A -t "+media+" \"/usr/openv/netbackup/bin/admincmd/bptestbpcd -host  "+client+"\"")

        conn.commit()
        cur.close()
        conn.close()
    except mysql.connector.Error,e:
        print "Mysql Error %d: %s" % (e.args[0], e.args[1])