def connect(self, name = None, user = None, passwd = None, flows_path = None, graphs_path = None, crontime = None):
try:
dbinfo = Config()
try:
conn = MySQLdb.connect(user=dbinfo.getUser(), passwd=dbinfo.getPassword(), db=dbinfo.getDBName(), host="localhost")
self.cursor = conn.cursor()
return True
except MySQLdb.Error, e:
pass
sys.exit(0)
print "Error %d: %s" % (e.args[0],e.args[1])
return False
except:
dbinfo = Config(None, name, user, passwd, flows_path, graphs_path, crontime)
try:
conn = MySQLdb.connect(user=dbinfo.getUser(), passwd=dbinfo.getPassword(), db=dbinfo.getDBName(), host="localhost")
self.cursor = conn.cursor()
return True
except MySQLdb.Error, e:
pass
print "Error %d: %s" % (e.args[0],e.args[1])
return False
def checkifexists(unixtime):
config=Config()
DB_NAME=config.getDBName()
DB_HOST='localhost'
DB_USER=config.getUser()
DB_PASS=config.getPassword()
db = MySQLdb.connect(user=DB_USER, passwd=DB_PASS, db=DB_NAME, host=DB_HOST)
c = db.cursor()
c.execute('Select * from rrd_n where time_unix=%s'%(unixtime))
result=c.fetchone()
if result:
return 1;
return 0;
def __init__(self, name = None, user = None, passwd = None, flows_path = None, graphs_path = None, crontime = None): if name == None: try: dbinfo = Config() except: pass try: conn = MySQLdb.connect(user=dbinfo.getUser(), passwd=dbinfo.getPassword(), db=dbinfo.getDBName(), host="localhost") self.cursor = conn.cursor() except MySQLdb.Error, e: pass
#!/usr/bin/python import time import MySQLdb from Config import Config import os config=Config() DB_NAME=config.getDBName(); DB_HOST='localhost' DB_USER=config.getUser(); DB_PASS=config.getPassword(); INCREMENT=config.getCronTime() LOGSPATH=config.getLogsPath() db = MySQLdb.connect(user=DB_USER, passwd=DB_PASS, db=DB_NAME, host=DB_HOST) c = db.cursor() #check if logs path exists, if not create it if not os.path.exists(LOGSPATH): os.makedirs(LOGSPATH) logs=open(LOGSPATH+'/cleanup_log','a+') #maxtime=31536000 year=31536000 #year in seconds maxtime=int(config.getOldesttime())*year
except MySQLdb.Error, e:
pass
print "Error %d: %s" % (e.args[0],e.args[1])
return False
else:
try:
dbinfo = Config()
try:
conn = MySQLdb.connect(user=dbinfo.getUser(), passwd=dbinfo.getPassword(), db=dbinfo.getDBName(), host="localhost")
self.cursor = conn.cursor()
return True
except MySQLdb.Error, e:
sys.exit(0)
print "Error %d: %s" % (e.args[0],e.args[1])
return False
except:
