def __init__(self, id, host, password, user='******'):
self._user = user
self._password = password
self._host = host
self._id = id
self.pageSize = 100
self.pageIndex = 1
self.skipSave = 11
self.dbHelper = DatabaseHelper('192.168.1.102', 'crack_ssh', 'root',
'123456')
#!/usr/bin/python3
# coding: utf-8
from databaseHelper import DatabaseHelper
import sys
if __name__ == '__main__':
if len(sys.argv) <= 1:
print('usage ' + __file__ + ' <password.txt>')
exit
filename = sys.argv[1]
dbHelper = DatabaseHelper('192.168.1.102', 'crack_ssh', 'root', '123456')
# numCount = dbHelper.queryOne('select count(*) as num from password')['num']
with open(filename, 'r') as f:
for line in f:
'''
if (numCount == 0):
try:
line = line.strip('\n').strip()
dbHelper.nonQuery('insert into password(val) value(%s)', (line,))
except Exception as e:
print(str(e))
else:
numCount -= 1
'''
try:
line = line.strip('\n').strip()
dbHelper.nonQuery('insert into password(val) value(%s)',
(line, ))
except Exception as e:
print(str(e))
def __init__(self):
self.dbHelper = DatabaseHelper('192.168.1.102', 'crack_ssh', 'root',
'123456')
def __init__(self, host, port):
self.host = host
self.port = port
self.dbHelper = DatabaseHelper('192.168.1.102', 'crack_ssh', 'root',
'123456')
import os
import gc
from databaseHelper import DatabaseHelper
offset = 10
breakIntervalInSeconds = 5
dbHelper = DatabaseHelper()
if dbHelper.connectToLocalDatabase():
print "\n\nstarting..."
publications = dbHelper.getQueue(offset)
for publication in publications:
if not dbHelper.findPublication(str(publication[0])):
print "waiting " + str(
breakIntervalInSeconds) + " seconds to collect..."
os.system("sleep " + str(breakIntervalInSeconds))
print "collecting " + str(publication[0])
os.system("python parser.py " + str(publication[0]))
else:
dbHelper.removeFromQueue(str(publication[0]))
if not publications:
print "Empty queue. Adding first publication to collect..."
dbHelper.addToQueue('2000824.2000828') #first to colllect
dbHelper.closeLocalConnection()
gc.collect()
def __init__(self):
self.dbHelper = DatabaseHelper('192.168.1.102', 'crack_ssh', 'root',
'123456')
self.dbHelper.nonQuery(
'update crackResult set crackState = %s where crackState = %s',
(NOSTART, CRACKING))
