def sendmailtest(request):
mailladdress = request.POST.get('mailladdress')
inputmail = request.POST.get('inputmail')
mailpassword = request.POST.get('mailpassword')
mailserver = request.POST.get('mailserver')
try:
username = request.session.get('username')
if username == returnadminusernamevalue:
if mailtest(mailladdress,inputmail,mailpassword,mailserver,mailladdress):
try:
if selectmaildb():
if insert_sendmail(inputmail, encrypt_and_decode().encrypted_text(mailpassword), mailserver, mailladdress)==():
result = {'isSuccess': True, "message": '成功'}
else:
result = {'isSuccess': False, "message": '数据写入失败'}
else:
if crearmaildb()==():
if insert_sendmail(inputmail, encrypt_and_decode().encrypted_text(mailpassword), mailserver, mailladdress)==():
result = {'isSuccess': True, "message": '成功'}
else:
result = {'isSuccess': False, "message": '数据写入失败'}
else:
result = {'isSuccess': False, "message": '表格创建失败'}
except:
result = {'isSuccess': False, "message": '出现异常'}
else:
result = {'isSuccess': False, "message": '连接失败'}
else:
result = {'isSuccess': False, "message": '权限不足'}
except Exception as e:
result = {'isSuccess': False, "message": str(e)}
response = HttpResponse()
response['Content-Type'] = "text/javascript"
response.write(json.dumps(result))
return response
def mysqllinktest(request):
post = request.POST
host = post.get("host")
username = post.get("username")
password = post.get("password")
port = post.get("port")
database = post.get("database")
try:
if dbinfotest(host, username, password, port, database):
# dir_now = os.path.dirname(os.path.abspath("settings.py"))
writeprofile("mysql", "host", host)
writeprofile("mysql", "username", username)
writeprofile("mysql", "password",
encrypt_and_decode().encrypted_text(password))
writeprofile("mysql", "port", port)
writeprofile("mysql", "database", database)
result = {'isSuccess': True, 'message': '修改mysql配置成功'}
else:
result = {'isSuccess': False, 'message': '修改mysql配置失败'}
response = HttpResponse()
response['Content-Type'] = "text/javascript"
response.write(json.dumps(result))
return response
except Exception as e:
result = {'isSuccess': False, 'message': '修改mysql配置失败：' + str(e)}
response = HttpResponse()
response['Content-Type'] = "text/javascript"
response.write(json.dumps(result))
return response
def mysqltest(request):
host = request.POST.get('host')
database = request.POST.get('database')
DBUser = request.POST.get('DBUser')
password = request.POST.get('password')
port = request.POST.get('port')
try:
username = request.session.get('username')
if username == returnadminusernamevalue:
if dbinfotest(host,DBUser, password, port,database):
try:
# dir_now = os.path.dirname(os.path.abspath("settings.py"))
writeprofile("mysql", "host", host)
writeprofile("mysql", "username", DBUser)
writeprofile("mysql", "Password", encrypt_and_decode().encrypted_text(password))
writeprofile("mysql", "Port", port)
writeprofile("mysql", "database", database)
creatmysqltable()# 创建mysql数据库的一些表格
result = {'isSuccess': True, "message": '成功'}
except:
result = {'isSuccess': False, "message": '出现异常'}
else:
result = {'isSuccess': False, "message": '连接失败'}
else:
result = {'isSuccess': False, "message": '连接失败'}
except Exception as e:
result = {'isSuccess': True, "message": str(e)}
response = HttpResponse()
response['Content-Type'] = "text/javascript"
response.write(json.dumps(result))
return response
def exlinktest(request):
post = request.POST
exchangeselect = post.get("exchangeselect")
exinputip = post.get("exinputip")
exinputaccount = post.get("exinputaccount")
exinputpassword = post.get("exinputpassword")
exinputdomain = post.get("exinputdomain")
if exchangeselect=='0':
if insert_exp() == ():
result = {'isSuccess': True, "message": '成功'}
else:
result = {'isSuccess': False, "message": '写入失败'}
else:
password = encrypt_and_decode().encrypted_text(exinputpassword)
exapitestvalue = exservertest(exip=exinputip,exaccount=exinputaccount,expassword=exinputpassword,domain=exinputdomain)
if exapitestvalue and ('isSuccess' in exapitestvalue):
if exapitestvalue['isSuccess']:
if insert_expmessage(exinputip,exinputaccount,password,exinputdomain)==():
result = {'isSuccess': True, "message": '成功'}
else:
result = {'isSuccess': False, "message": '写入失败'}
else:
result = {'isSuccess': False, "message": '测试失败'}
else:
result = {'isSuccess': False, "message": '测试失败'}
response = HttpResponse()
response['Content-Type'] = "text/javascript"
response.write(json.dumps(result))
return response
def adldaptest(request):
adip = request.POST.get('adip')
domian = request.POST.get('domian')
aduser = request.POST.get('aduser')
adpassword = request.POST.get('adpassword')
adserchbase = request.POST.get('adserchbase')
sele = request.POST.get('sele')
try:
username = request.session.get('username')
if username == returnadminusernamevalue:
ldaptests = ldaptest(adip, aduser, adpassword, sele)
if ldaptests['isSuccess']:
try:
if selectldapdb():
if insert_ldapmessage(
domian, adip, aduser,
encrypt_and_decode().encrypted_text(
adpassword), adserchbase, sele) == ():
result = {'isSuccess': True, "message": '成功'}
else:
result = {'isSuccess': False, "message": '数据写入失败'}
else:
if crearldapdb() == ():
if insert_ldapmessage(
domian, adip, aduser,
encrypt_and_decode().encrypted_text(
adpassword), adserchbase, sele) == ():
result = {'isSuccess': True, "message": '成功'}
else:
result = {
'isSuccess': False,
"message": '数据写入失败'
}
else:
result = {'isSuccess': False, "message": '表格创建失败'}
except:
result = {'isSuccess': False, "message": '出现异常'}
else:
result = {'isSuccess': False, "message": ldaptests['message']}
else:
result = {'isSuccess': False, "message": '权限不足'}
except Exception as e:
result = {'isSuccess': False, "message": str(e)}
response = HttpResponse()
response['Content-Type'] = "text/javascript"
response.write(json.dumps(result))
return response
def __init__(self):
# self.wsman = WSMan(server="", port=443, path="/powershell/",ssl=True,username="", password="",auth="basic")
self.wsman = WSMan(server=getskey()['exserver'],
port=80,
path="/powershell/",
ssl=False,
username=getskey()['exdomain'] + "\\" +
getskey()['exuser'],
password=encrypt_and_decode().decrypted_text(
getskey()['expassword']),
auth="basic",
encryption='never')
self.msg, self.message, self.isSuccess, self.code, self.count = str(
), list(), False, 0, 0
def __init__(self,
encode='utf-8',
zabbixurl=None,
zabbixuser=None,
zabbixpassword=None):
"""
构造函数
:param request_id:JSON-RPC请求标识符
"""
getpermsessages = getpermsessage()
if getpermsessages:
self.uri = getpermsessages.get('zabbixurl', '')
self.zabbixuser = getpermsessages.get('zabbixuser', '')
self.zabbixpassword = encrypt_and_decode().decrypted_text(
getpermsessages.get('zabbixpassword', '')) #解密
if zabbixurl:
self.uri = zabbixurl
if zabbixuser:
self.zabbixuser = zabbixuser
if zabbixpassword:
self.zabbixpassword = zabbixpassword
def dbinfo():
try:
host = readprofile('mysql', 'host')
username = readprofile('mysql', 'username')
Port = readprofile('mysql', 'Port')
database = readprofile('mysql', 'database')
password = encrypt_and_decode().decrypted_text(
readprofile('mysql', 'password'))
#测试
conn = pymysql.connect(host=host,
port=int(Port),
user=username,
password=password,
database=database,
charset='utf8',
cursorclass=pymysql.cursors.DictCursor)
cur = conn.cursor()
if cur:
return conn
else:
return False
except Exception as e:
return False
# Database
# https://docs.djangoproject.com/en/1.10/ref/settings/#databases
try:
conn = dbinfo()
if conn:
from dbinfo.Profile import readprofile
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': readprofile('mysql', 'database'),
'USER': readprofile('mysql', 'username'),
'PASSWORD': encrypt_and_decode().decrypted_text(readprofile('mysql', 'password')),
'HOST': readprofile('mysql', 'host'),
'PORT': readprofile('mysql', 'Port'),
}
}
else:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.sqlite3',
'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
}
}
except:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.sqlite3',
# https://docs.djangoproject.com/en/1.10/ref/settings/#databases
try:
mysqlDatabases = mysqlDatabase()
if mysqlDatabases:
from dbinfo.Profile import readprofile
DATABASES = {
'default': {
'ENGINE':
'django.db.backends.mysql',
'NAME':
readprofile('mysql', 'database'),
'USER':
readprofile('mysql', 'username'),
'PASSWORD':
encrypt_and_decode().decrypted_text(
readprofile('mysql', 'password')),
'HOST':
readprofile('mysql', 'host'),
'PORT':
readprofile('mysql', 'Port'),
}
}
else:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.sqlite3',
'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
}
}
except:
DATABASES = {
