def activate_domain(translate, output, id_domain, conectionBrain, log):
_ = translate
cursor = conectionBrain.cursor()
cursor.execute("UPDATE dns SET status = '1' WHERE id = '" + str(id_domain) + "'")
conectionBrain.commit()
generate.all(id_domain, conectionBrain)
log.write(_('Activate domain'))
def edit_host(translate, output, id_domain, conectionBrain, log):
cursor = conectionBrain.cursor()
cursor.execute("SELECT * FROM apache WHERE id = '" + id_domain + "'")
for info in cursor:
_ = translate
domain_name = raw_input(_('Domain Name ') + str(info[1]) + ': ')
email = raw_input(_('Email Contact ') + str(info[2]) + ': ')
path_server = raw_input(_('Path Server ') + str(info[3]) + ': ')
rewriteValue = 'y' if str(info[4]) else 'n'
rewrite = raw_input(_('ReWrite ') + str(rewriteValue) + ': ')
indexOfValue = 'y' if str(info[5]) else 'n'
indexOf = raw_input(_('IndexOf ') + str(indexOfValue) + ': ')
control = False
valores = ''
if domain_name != "":
control = True
valores += "domain = '" + str(domain_name) + "', "
if email != "":
control = True
valores += "email = '" + str(email) + "', "
if path_server != "":
control = True
valores += "path_domain = '" + str(path_server) + "', "
if rewrite != "":
control = True
if rewrite == 'y':
r_value = '1'
else:
r_value = '0'
valores += "rewrite = '" + str(r_value) + "', "
if indexOf != "":
control = True
if indexOf == 'y':
i_value = '1'
else:
i_value = '0'
valores += "indexOf = '" + str(i_value) + "', "
if control == True:
final = valores + 'F'
cursor.execute("UPDATE apache SET " + final.split(', F')[0] + " WHERE id = '" + str(info[0]) + "'")
conectionBrain.commit()
generate.all(str(info[0]), conectionBrain)
if domain_name == "":
edit_host = str(info[1])
else:
edit_host = domain_name
log.write(_('Edit host ') + str(edit_host))
def activate_host(translate, output, id_domain, conectionBrain, log):
_ = translate
cursor = conectionBrain.cursor()
cursor.execute("UPDATE apache SET status = '1' WHERE id = '" + str(id_domain) + "'")
conectionBrain.commit()
generate.all(id_domain, conectionBrain)
cursor.execute("SELECT domain FROM apache WHERE id = '" + str(id_domain) + "'")
for info in cursor:
domain_name = info[0]
command_addSite = 'a2ensite ' + str(domain_name)
addSite = subprocess.Popen(command_addSite, stdout=subprocess.PIPE, stderr=subprocess.PIPE, shell=True)
addSite_error = addSite.stderr.read()
if addSite_error != '':
log.write(_('Failed active host'), 1)
else:
log.write(_('Active host ') + str(domain_name))
def delete_domain(translate, output, id_domain, conectionBrain, log):
_ = translate
sentencia = raw_input('disable[0]/delete[1]: [0] ')
while sentencia != '0' and sentencia != '1':
output.error(_('Option not valid'))
sentencia = raw_input('disable[0]/delete[1]: [0] ')
cursor = conectionBrain.cursor()
cursor.execute("SELECT domain FROM dns WHERE id = '" + str(id_domain) + "'")
for info in cursor:
domain = info[0]
if sentencia == '0':
cursor.execute("UPDATE dns SET status = '0' WHERE id = '" + id_domain + "'")
else:
cursor.execute("DELETE FROM dns WHERE id = '" + id_domain + "'")
conectionBrain.commit()
os.system('rm -f /etc/bind/pri.' + domain)
generate.all('all', conectionBrain)
log.write(_('Delete Domain ') + str(domain))
def option5():
generate.all("all", "")
def option5():
generate.all('all', '')
def edit_domain(translate, output, id_domain, conectionBrain, log):
cursor = conectionBrain.cursor()
cursor.execute("SELECT * FROM dns WHERE id = '" + id_domain + "'")
for info in cursor:
_ = translate
domain_name = raw_input('Domain Name [' + info[1] + ']: ')
email = raw_input('Email Contact [' + info[2] + ']: ')
ip_server = raw_input('Ip Server [' + info[3] + ']: ')
ns_primary = raw_input('NS Primary [' + info[4] + ']: ')
ns_secundary = raw_input('NS Secundary [' + info[5] + ']: ')
if str(info[6]) == '1':
valor = 'y'
else:
valor = 'n'
server_mail = raw_input('Server Mail [' + str(valor) + ']: ')
type_zone = raw_input('Type Zone [' + info[9] + ']: ')
ip_transfer = raw_input('Ip transfer [' + info[10] + ']: ')
domain_key = ''
spf = ip_server
control = False
valores = ''
if domain_name != "":
control = True
valores += "domain = '" + str(domain_name) + "', "
if email != "":
control = True
valores += "email = '" + str(email) + "', "
if ip_server != "":
control = True
valores += "ipserver = '" + str(ip_server) + "', "
if ns_primary != "":
control = True
valores += "NS_primary = '" + str(ns_primary) + "', "
if ns_secundary != "":
control = True
valores += "NS_secundary = '" + str(ns_secundary) + "', "
if server_mail !="":
control = True
if server_mail == 'y':
e_server = '1'
else:
e_server = '0'
valores += "email_server = '" + str(e_server) + "', "
if type_zone !="":
control = True
valores += "type_zone = '" + str(type_zone) + "', "
if ip_transfer != "":
control = True
valores += "ip_transfer = '" + str(ip_transfer) + "', "
if control == True:
final = valores + 'F'
cursor.execute("UPDATE dns SET " + final.split(', F')[0] + " WHERE id = '" + str(info[0]) + "'")
conectionBrain.commit()
generate.all(str(info[0]), conectionBrain)
log.write(_('Edit Domain ') + str(domain_name))
