def exec_cmd(self,get):
cmd_file = self.rsyn_path + '/sclient/' + get['mName'] + '_cmd'
sclient = self.get_send_byname(get)
public.writeFile(cmd_file,self.__get_send_cmd(sclient))
os.system('echo "【'+public.getDate()+'】" >> ' + self.rsyn_path + "/sclient/"+get.mName+"_exec.log")
public.ExecShell("nohup bash " + cmd_file + " >> " + self.rsyn_path + "/sclient/"+get.mName+"_exec.log 2>&1 &")
self.__write_logs('手动执行同步任务['+get['mName']+']');
return public.returnMsg(True,'同步指令已发送!');
def backup_site_data(self, id):
path_id = ''.join(
random.sample(string.ascii_letters + string.digits, 20))
find = public.M('sites').where("id=?",
(id, )).field('name,path,id').find()
import time
fileName = path_id + 'WEB' + find['name'] + '_' + time.strftime(
'%Y%m%d_%H%M%S', time.localtime()) + '.zip'
backupPath = '/www/server/panel/BTPanel/static' + '/site'
zipName = backupPath + '/' + fileName
if not (os.path.exists(backupPath)): os.makedirs(backupPath)
tmps = '/tmp/panelExec.log'
execStr = "cd '" + find[
'path'] + "' && zip '" + zipName + "' -x .user.ini -r ./ > " + tmps + " 2>&1"
public.ExecShell(execStr)
sql = public.M('backup').add(
'type,name,pid,filename,size,addtime',
(0, fileName, find['id'], zipName, 0, public.getDate()))
public.WriteLog('TYPE_SITE', 'SITE_BACKUP_SUCCESS', (find['name'], ))
return zipName
def backup_site(self, id, log_file):
find = public.M('sites').where("id=?",
(id, )).field('name,path,id').find()
fileName = find['name'] + '_' + time.strftime(
'%Y%m%d_%H%M%S', time.localtime()) + '.zip'
backupPath = public.M('config').where(
'id=?', (1, )).getField('backup_path') + '/site'
zipName = backupPath + '/' + fileName
if not (os.path.exists(backupPath)): os.makedirs(backupPath)
execStr = "cd '" + find[
'path'] + "' && zip '" + zipName + "' -x .user.ini -r ./ &> " + log_file
os.system(execStr)
sql = public.M('backup').add(
'type,name,pid,filename,size,addtime',
(0, fileName, find['id'], zipName, 0, public.getDate()))
public.WriteLog('TYPE_SITE', 'SITE_BACKUP_SUCCESS', (find['name'], ))
return public.returnMsg(True, 'BACKUP_SUCCESS')
def panel2To3():
try:
filename = '/www/server/apache/version.pl'
if os.path.exists(filename):
version = public.readFile(filename)
if version.find('2.2') != -1:
print('BT-Panel 3.x does not support apache2.2')
return
except:
pass
import mysql, db, os, shutil, time
os.system('service mysqld stop')
os.system('pkill -9 mysqld_safe')
os.system('pkill -9 mysqld')
os.system('sleep 2')
os.system('service mysqld start')
os.system('service mysqld stop')
os.system('mysqld_safe --skip-grant-tables&')
time.sleep(3)
sql = mysql.mysql()
sqldb = db.Sql()
#转移配置
arr = sql.query('select * from bt_default.bt_config')[0]
sqldb.table('config').where('id=?', (1, )).save(
'webserver,backup_path,sites_path,mysql_root',
(arr[1], arr[2], arr[3], arr[5]))
webserver = arr[1]
setupPath = '/www/server'
if webserver == 'nginx':
#处理Nginx配置文件
filename = setupPath + "/nginx/conf/nginx.conf"
if os.path.exists(filename):
conf = public.readFile(filename)
if conf.find('include vhost/*.conf;') != -1:
conf = conf.replace(
'include vhost/*.conf;',
'include ' + setupPath + '/panel/vhost/nginx/*.conf;')
public.writeFile(filename, conf)
#处理伪静态文件
dstPath = setupPath + '/panel/vhost/rewrite'
srcPath = setupPath + '/nginx/conf/rewrite'
if os.path.exists(srcPath):
if os.path.exists(dstPath):
os.system('mv -f ' + dstPath + ' ' + dstPath + '_backup_' +
time.strftime('%Y%m%d_%H%M%S', time.localtime()))
os.system('cp -a -r ' + srcPath + ' ' + dstPath)
os.system('chmod -R 644 ' + dstPath)
# else:
# #处理Apache配置文件
# filename = setupPath + "/apache/conf/httpd.conf"
# if os.path.exists(filename):
# conf = public.readFile(filename);
# if conf.find('IncludeOptional conf/vhost/*.conf') != -1:
# conf = conf.replace('IncludeOptional conf/vhost/*.conf','IncludeOptional ' + setupPath + '/panel/vhost/apache/*.conf');
# public.writeFile(filename,conf);
#转移站点
arr = sql.query('select * from bt_default.bt_sites')
for siteArr in arr:
#站点
pid = sqldb.table('sites').add(
'name,path,status,ps,addtime',
(siteArr[1], siteArr[3], siteArr[4], siteArr[6], str(siteArr[7])))
#域名
domains = siteArr[2].split(',')
for domain in domains:
tmp = domain.split(':')
if len(tmp) < 2: tmp.append('80')
sqldb.table('domain').add('pid,name,port,addtime',
(pid, tmp[0], tmp[1], public.getDate()))
#子目录
barr = sql.query("select * from bt_default.bt_binding where pid='" +
str(siteArr[0]) + "'")
for binding in barr:
sqldb.table('binding').add('pid,domain,path,port,addtime',
(pid, binding[2], binding[3],
str(binding[4]), str(binding[5])))
#迁移配置文件
letPath = '/etc/letsencrypt/live'
dstKey = letPath + '/' + siteArr[1] + '/privkey.pem'
dstCsr = letPath + '/' + siteArr[1] + '/fullchain.pem'
if webserver == 'nginx':
confFile = setupPath + '/nginx/conf/vhost/' + siteArr[1] + '.conf'
if os.path.exists(confFile):
conf = public.readFile(confFile)
conf = conf.replace(
'rewrite/', setupPath + '/panel/vhost/rewrite/').replace(
'key/' + siteArr[1] + '/key.key',
dstKey).replace('key/' + siteArr[1] + '/key.csr',
dstCsr)
filename = setupPath + '/panel/vhost/nginx/' + siteArr[
1] + '.conf'
public.writeFile(filename, conf)
os.system('chmod 644 ' + filename)
else:
confFile = setupPath + '/apache/conf/vhost/' + siteArr[1] + '.conf'
if os.path.exists(confFile):
conf = public.readFile(confFile)
conf = conf.replace('conf/key/' + siteArr[1] + '/key.key',
dstKey).replace(
'conf/key/' + siteArr[1] + '/key.csr',
dstCsr)
filename = setupPath + '/panel/vhost/apache/' + siteArr[
1] + '.conf'
public.writeFile(filename, conf)
os.system('chmod 644 ' + filename)
#转移其它配置文件
try:
otherConf = setupPath + '/' + webserver + '/conf/vhost/default.conf'
if os.path.exists(otherConf):
dstOther = setupPath + '/panel/vhost/' + webserver + '/default.conf'
public.ExecShell('\\cp -a -r ' + otherConf + ' ' + dstOther)
otherConf = setupPath + '/' + webserver + '/conf/vhost/phpfpm_status.conf'
if os.path.exists(otherConf):
dstOther = setupPath + '/panel/vhost/' + webserver + '/phpfpm_status.conf'
public.ExecShell('\\cp -a -r ' + otherConf + ' ' + dstOther)
except:
pass
#迁移证书
srcKey = setupPath + '/' + webserver + '/conf/key/' + siteArr[
1] + '/key.key'
if os.path.exists(srcKey):
os.system('mkdir -p ' + letPath + '/' + siteArr[1])
public.ExecShell('\\cp -a -r ' + srcKey + ' ' + dstKey)
srcCsr = setupPath + '/' + webserver + '/conf/key/' + siteArr[
1] + '/key.csr'
if os.path.exists(srcCsr):
public.ExecShell('\\cp -a -r ' + srcCsr + ' ' + dstCsr)
print(siteArr[1] + ' -> done.\n')
#转移数据库
arr = sql.query('select * from bt_default.bt_databases')
for databaseArr in arr:
sqldb.table('databases').add(
'name,username,password,accept,ps,addtime',
(databaseArr[1], databaseArr[2], databaseArr[3], databaseArr[4],
databaseArr[5], str(databaseArr[6])))
#转移FTP
arr = sql.query('select * from bt_default.bt_ftps')
for ftpArr in arr:
sqldb.table('ftps').add('name,password,path,status,ps,addtime',
(ftpArr[1], ftpArr[2], ftpArr[3], ftpArr[4],
ftpArr[5], str(ftpArr[6])))
#转移用户
#arr = sql.query('select * from bt_default.bt_user')[0]
#sqldb.table('users').where('id=?',(1,)).save('username,password,login_ip,login_time',(arr[1],arr[2],arr[3],arr[4]))
#转移日志
arr = sql.query('select * from bt_default.bt_logs')
for log in arr:
sqldb.table('logs').add('type,log,addtime', (log[1], log[2], log[3]))
#转移防火墙记录
arr = sql.query('select * from bt_default.bt_firewall')
ports = ['80', '22', '21', '20', '888', '8888']
for fw in arr:
if str(fw[1]) in ports: continue
sqldb.table('firewall').add('port,ps,addtime', (fw[1], fw[2], fw[3]))
#转移计划任务记录
try:
arr = sql.query('select * from bt_default.bt_crontab')
for cron in arr:
sqldb.table('crontab').add(
'name,type,where1,where_hour,where_minute,echo,addtime',
(cron[1], cron[2], cron[3], cron[4], cron[5], cron[6],
cron[7]))
except:
pass
os.system('/etc/init.d/yunclient stop')
os.system('chkconfig --del yunclient')
os.system('rm -f /etc/init.d/yunclient')
os.system('pkill -9 mysqld_safe')
os.system('pkill -9 mysqld')
os.system('sleep 2 && service mysqld start')
if os.path.exists('/etc/init.d/nginx'):
os.system('/etc/init.d/nginx reload')
if os.path.exists('/etc/init.d/httpd'):
os.system('/etc/init.d/httpd reload')
print('=========================')
print('successful!')
def panel2To3():
try:
filename = '/www/server/apache/version.pl'
if os.path.exists(filename):
version = public.readFile(filename);
if version.find('2.2') != -1:
print 'BT-Panel 3.x does not support apache2.2';
return;
except:
pass
import mysql,db,os,shutil,time
os.system('service mysqld stop')
os.system('pkill -9 mysqld_safe')
os.system('pkill -9 mysqld')
os.system('sleep 2')
os.system('service mysqld start');
os.system('service mysqld stop')
os.system('mysqld_safe --skip-grant-tables&')
time.sleep(3);
sql = mysql.mysql();
sqldb = db.Sql();
#转移配置
arr = sql.query('select * from bt_default.bt_config')[0]
sqldb.table('config').where('id=?',(1,)).save('webserver,backup_path,sites_path,mysql_root',(arr[1],arr[2],arr[3],arr[5]));
webserver = arr[1];
setupPath = '/www/server';
if webserver == 'nginx':
#处理Nginx配置文件
filename = setupPath + "/nginx/conf/nginx.conf"
if os.path.exists(filename):
conf = public.readFile(filename);
if conf.find('include vhost/*.conf;') != -1:
conf = conf.replace('include vhost/*.conf;','include ' + setupPath + '/panel/vhost/nginx/*.conf;');
public.writeFile(filename,conf);
#处理伪静态文件
dstPath = setupPath + '/panel/vhost/rewrite'
srcPath = setupPath + '/nginx/conf/rewrite'
if os.path.exists(srcPath):
if os.path.exists(dstPath): os.system('mv -f ' + dstPath + ' ' + dstPath + '_backup_' + time.strftime('%Y%m%d_%H%M%S',time.localtime()));
os.system('cp -a -r ' + srcPath + ' ' + dstPath);
os.system('chmod -R 644 ' + dstPath);
else:
#处理Apache配置文件
filename = setupPath + "/apache/conf/httpd.conf"
if os.path.exists(filename):
conf = public.readFile(filename);
if conf.find('IncludeOptional conf/vhost/*.conf') != -1:
conf = conf.replace('IncludeOptional conf/vhost/*.conf','IncludeOptional ' + setupPath + '/panel/vhost/apache/*.conf');
public.writeFile(filename,conf);
#转移站点
arr = sql.query('select * from bt_default.bt_sites')
for siteArr in arr:
#站点
pid = sqldb.table('sites').add('name,path,status,ps,addtime',(siteArr[1],siteArr[3],siteArr[4],siteArr[6],str(siteArr[7])))
#域名
domains = siteArr[2].split(',');
for domain in domains:
tmp = domain.split(':');
if len(tmp) < 2: tmp.append('80');
sqldb.table('domain').add('pid,name,port,addtime',(pid,tmp[0],tmp[1],public.getDate()))
#子目录
barr = sql.query("select * from bt_default.bt_binding where pid='"+str(siteArr[0])+"'")
for binding in barr:
sqldb.table('binding').add('pid,domain,path,port,addtime',(pid,binding[2],binding[3],str(binding[4]),str(binding[5])))
#迁移配置文件
letPath = '/etc/letsencrypt/live';
dstKey = letPath + '/' + siteArr[1] + '/privkey.pem';
dstCsr = letPath + '/' + siteArr[1] + '/fullchain.pem';
if webserver == 'nginx':
confFile = setupPath + '/nginx/conf/vhost/' + siteArr[1] + '.conf';
if os.path.exists(confFile):
conf = public.readFile(confFile);
conf = conf.replace('rewrite/',setupPath+'/panel/vhost/rewrite/').replace('key/' + siteArr[1] + '/key.key',dstKey).replace('key/' + siteArr[1] + '/key.csr',dstCsr);
filename = setupPath + '/panel/vhost/nginx/' + siteArr[1] + '.conf';
public.writeFile(filename,conf);
os.system('chmod 644 ' + filename);
else:
confFile = setupPath + '/apache/conf/vhost/' + siteArr[1] + '.conf';
if os.path.exists(confFile):
conf = public.readFile(confFile);
conf = conf.replace('conf/key/' + siteArr[1] + '/key.key',dstKey).replace('conf/key/' + siteArr[1] + '/key.csr',dstCsr);
filename = setupPath + '/panel/vhost/apache/' + siteArr[1] + '.conf';
public.writeFile(filename,conf);
os.system('chmod 644 ' + filename);
#转移其它配置文件
try:
otherConf = setupPath + '/'+webserver+'/conf/vhost/default.conf';
if os.path.exists(otherConf):
dstOther = setupPath + '/panel/vhost/'+webserver+'/default.conf';
public.ExecShell('\\cp -a -r ' + otherConf + ' ' + dstOther)
otherConf = setupPath + '/'+webserver+'/conf/vhost/phpfpm_status.conf';
if os.path.exists(otherConf):
dstOther = setupPath + '/panel/vhost/'+webserver+'/phpfpm_status.conf';
public.ExecShell('\\cp -a -r ' + otherConf + ' ' + dstOther)
except:
pass
#迁移证书
srcKey = setupPath + '/' + webserver + '/conf/key/' + siteArr[1] + '/key.key'
if os.path.exists(srcKey):
os.system('mkdir -p ' + letPath + '/' + siteArr[1]);
public.ExecShell('\\cp -a -r ' + srcKey + ' ' + dstKey)
srcCsr = setupPath + '/' + webserver + '/conf/key/'+ siteArr[1] + '/key.csr'
if os.path.exists(srcCsr):
public.ExecShell('\\cp -a -r ' + srcCsr + ' ' + dstCsr)
print siteArr[1] + ' -> done.\n';
#转移数据库
arr = sql.query('select * from bt_default.bt_databases');
for databaseArr in arr:
sqldb.table('databases').add('name,username,password,accept,ps,addtime',(databaseArr[1],databaseArr[2],databaseArr[3],databaseArr[4],databaseArr[5],str(databaseArr[6])));
#转移FTP
arr = sql.query('select * from bt_default.bt_ftps');
for ftpArr in arr:
sqldb.table('ftps').add('name,password,path,status,ps,addtime',(ftpArr[1],ftpArr[2],ftpArr[3],ftpArr[4],ftpArr[5],str(ftpArr[6])))
#转移用户
#arr = sql.query('select * from bt_default.bt_user')[0]
#sqldb.table('users').where('id=?',(1,)).save('username,password,login_ip,login_time',(arr[1],arr[2],arr[3],arr[4]))
#转移日志
arr = sql.query('select * from bt_default.bt_logs');
for log in arr:
sqldb.table('logs').add('type,log,addtime',(log[1],log[2],log[3]))
#转移防火墙记录
arr = sql.query('select * from bt_default.bt_firewall');
ports = ['80','22','21','20','888','8888']
for fw in arr:
if str(fw[1]) in ports: continue;
sqldb.table('firewall').add('port,ps,addtime',(fw[1],fw[2],fw[3]))
#转移计划任务记录
try:
arr = sql.query('select * from bt_default.bt_crontab');
for cron in arr:
sqldb.table('crontab').add('name,type,where1,where_hour,where_minute,echo,addtime',(cron[1],cron[2],cron[3],cron[4],cron[5],cron[6],cron[7]))
except:
pass
os.system('/etc/init.d/yunclient stop')
os.system('chkconfig --del yunclient')
os.system('rm -f /etc/init.d/yunclient')
os.system('pkill -9 mysqld_safe')
os.system('pkill -9 mysqld')
os.system('sleep 2 && service mysqld start')
if os.path.exists('/etc/init.d/nginx'): os.system('/etc/init.d/nginx reload');
if os.path.exists('/etc/init.d/httpd'): os.system('/etc/init.d/httpd reload');
print '=========================';
print 'successful!'
