try:

db = MongoClient(host,int(port))

try:

db.admin.authenticate(user,passwd)

except Exception,e:

pass

#print Exception,":",e

curr_ops = db.admin.current_op()["inprog"]

ops = []

uuid_tag = uuid.uuid1()

for curr_op in curr_ops:

op = []

#if curr_op.get("ns") !="local.oplog.rs" and curr_op.get("desc") != 'rsSync' and 'repl' not in curr_op.get("desc") and curr_op.get("secs_running") > 0:

if curr_op.get("ns") !="local.oplog.rs" and curr_op.get("desc") != 'rsSync' and 'repl' not in curr_op.get("desc") :

op.append(host)

op.append(port)

#print op

op.append(curr_op["desc"])

if curr_op.has_key("secs_running"):

op.append(curr_op["secs_running"])

else:

op.append(0)

op.append(str(curr_op["op"]))

op.append(curr_op["ns"])

if curr_op.has_key("query") and curr_op["query"]:

op.append(str(curr_op["query"]))

else:

op.append("")

if curr_op.has_key("insert") and curr_op["insert"]:

op.append(str(curr_op["insert"]))

else:

op.append("")

if curr_op.has_key("client"):

op.append(curr_op["client"])

else:

op.append("")

if curr_op.has_key("msg"):

op.append(curr_op["msg"])

else:

op.append("")

if curr_op["locks"]:

op.append(str(curr_op["locks"]))

else:

op.append("")

op.append(curr_op["waitingForLock"])

if curr_op["lockStats"]:

op.append(str(curr_op["lockStats"]))

else:

op.append("")

op.append(uuid_tag)

if op:

#print uuid_tag

#print tuple(op)

sql = "insert into mongodb_current_op (host,port,Op_desc ,Secs_running ,Op ,Ns ,Op_query ,Op_insert ,Client ,Msg ,Locks ,WaitingForLock ,LockStats ,uuid) values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)"

#print sql

#print "what the fuck"

func.mysql_exec(sql,tuple(op))

ops.append(op)

except Exception,e:

print Exception,":",e

print "collect mongodb processlist got error"

try:

connect = pymongo.MongoClient(host, int(port))

try:

connect.admin.authenticate(user,passwd)

except Exception,e:

pass

#print Exception,":",e

#print "mongo check"

serverStatus=connect.admin.command(bson.son.SON([('serverStatus', 1), ('repl', 2)]))

time.sleep(1)

serverStatus_2=connect.admin.command(bson.son.SON([('serverStatus', 1), ('repl', 2)]))

connect = 1

ok = int(serverStatus['ok'])

version = serverStatus['version']

uptime = serverStatus['uptime']

connections_current = serverStatus['connections']['current']

connections_available = serverStatus['connections']['available']

#globalLock_activeClients = serverStatus['globalLock']['activeClients']['total'] +

globalLock_activeClients = serverStatus['globalLock']['activeClients']['readers'] + serverStatus['globalLock']['activeClients']['writers']

globalLock_currentQueue = serverStatus['globalLock']['currentQueue']['total']

#indexCounters_accesses = serverStatus['indexCounters']['accesses']

indexCounters_accesses = 0

indexCounters_hits = 0

indexCounters_misses = 0

indexCounters_resets = 0

indexCounters_missRatio = 0

cursors_totalOpen = 0

cursors_timeOut = 0

#indexCounters_hits = serverStatus['indexCounters']['hits']

#indexCounters_misses = serverStatus['indexCounters']['misses']

#indexCounters_resets = serverStatus['indexCounters']['resets']

#indexCounters_missRatio = serverStatus['indexCounters']['missRatio']

#cursors_totalOpen = serverStatus['cursors']['totalOpen']

#cursors_timeOut = serverStatus['cursors']['timeOut']

#dur_commits = serverStatus['dur']['commits']

#dur_journaledMB = serverStatus['dur']['journaledMB']

#dur_writeToDataFilesMB = serverStatus['dur']['writeToDataFilesMB']

#dur_compression = serverStatus['dur']['compression']

#dur_commitsInWriteLock = serverStatus['dur']['commitsInWriteLock']

#dur_earlyCommits = serverStatus['dur']['earlyCommits']

#dur_timeMs_dt = serverStatus['dur']['timeMs']['dt']

#dur_timeMs_prepLogBuffer = serverStatus['dur']['timeMs']['prepLogBuffer']

#dur_timeMs_writeToJournal = serverStatus['dur']['timeMs']['writeToJournal']

#dur_timeMs_writeToDataFiles = serverStatus['dur']['timeMs']['writeToDataFiles']

#dur_timeMs_remapPrivateView = serverStatus['dur']['timeMs']['remapPrivateView']

dur_commits = 0

dur_journaledMB = 0

dur_writeToDataFilesMB = 0

dur_compression = 0

dur_commitsInWriteLock = 0

dur_earlyCommits = 0

dur_timeMs_dt = 0

dur_timeMs_prepLogBuffer = 0

dur_timeMs_writeToJournal = 0

dur_timeMs_writeToDataFiles = 0

dur_timeMs_remapPrivateView = 0

mem_bits = serverStatus['mem']['bits']

mem_resident = serverStatus['mem']['resident']

mem_virtual = serverStatus['mem']['virtual']

mem_supported = serverStatus['mem']['supported']

mem_mapped = serverStatus['mem']['mapped']

mem_mappedWithJournal = serverStatus['mem']['mappedWithJournal']

network_bytesIn_persecond = int(serverStatus_2['network']['bytesIn']) - int(serverStatus['network']['bytesIn'])

network_bytesOut_persecond = int(serverStatus_2['network']['bytesOut']) - int(serverStatus['network']['bytesOut'])

network_numRequests_persecond = int(serverStatus_2['network']['numRequests']) - int(serverStatus['network']['numRequests'])

opcounters_insert_persecond = int(serverStatus_2['opcounters']['insert']) - int(serverStatus['opcounters']['insert'])

opcounters_query_persecond = int(serverStatus_2['opcounters']['query']) - int(serverStatus['opcounters']['query'])

opcounters_update_persecond = int(serverStatus_2['opcounters']['update']) - int(serverStatus['opcounters']['update'])

opcounters_delete_persecond = int(serverStatus_2['opcounters']['delete']) - int(serverStatus['opcounters']['delete'])

opcounters_command_persecond = int(serverStatus_2['opcounters']['command']) - int(serverStatus['opcounters']['command'])

#replset

try:

repl=serverStatus['repl']

setName=repl['setName']

replset=1

if repl['secondary']==true:

repl_role='secondary'

repl_role_new='s'

else:

repl_role='master'

repl_role_new='m'

except:

replset=0

repl_role='master'

repl_role_new='m'

pass

##################### insert data to mysql server#############################

sql = "insert into mongodb_status(server_id,host,port,tags,connect,replset,repl_role,ok,uptime,version,connections_current,connections_available,globalLock_currentQueue,globalLock_activeClients,indexCounters_accesses,indexCounters_hits,indexCounters_misses,indexCounters_resets,indexCounters_missRatio,dur_commits,dur_journaledMB,dur_writeToDataFilesMB,dur_compression,dur_commitsInWriteLock,dur_earlyCommits,dur_timeMs_dt,dur_timeMs_prepLogBuffer,dur_timeMs_writeToJournal,dur_timeMs_writeToDataFiles,dur_timeMs_remapPrivateView,mem_bits,mem_resident,mem_virtual,mem_supported,mem_mapped,mem_mappedWithJournal,network_bytesIn_persecond,network_bytesOut_persecond,network_numRequests_persecond,opcounters_insert_persecond,opcounters_query_persecond,opcounters_update_persecond,opcounters_delete_persecond,opcounters_command_persecond) values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s);"

param = (server_id,host,port,tags,connect,replset,repl_role,ok,uptime,version,connections_current,connections_available,globalLock_currentQueue,globalLock_activeClients,indexCounters_accesses,indexCounters_hits,indexCounters_misses,indexCounters_resets,indexCounters_missRatio,dur_commits,dur_journaledMB,dur_writeToDataFilesMB,dur_compression,dur_commitsInWriteLock,dur_earlyCommits,dur_timeMs_dt,dur_timeMs_prepLogBuffer,dur_timeMs_writeToJournal,dur_timeMs_writeToDataFiles,dur_timeMs_remapPrivateView,mem_bits,mem_resident,mem_virtual,mem_supported,mem_mapped,mem_mappedWithJournal,network_bytesIn_persecond,network_bytesOut_persecond,network_numRequests_persecond,opcounters_insert_persecond,opcounters_query_persecond,opcounters_update_persecond,opcounters_delete_persecond,opcounters_command_persecond)

func.mysql_exec(sql,param)

role='m'

func.update_db_status_init(repl_role_new,version,host,port,tags)

except Exception, e:

logger_msg="check mongodb %s:%s : %s" %(host,port,e)

logger.warning(logger_msg)

try:

connect=0

sql="insert into mongodb_status(server_id,host,port,tags,connect) values(%s,%s,%s,%s,%s)"

param=(server_id,host,port,tags,connect)

func.mysql_exec(sql,param)

except Exception, e:

logger.error(e)

sys.exit(1)

finally:

sys.exit(1)

finally:

func.check_db_status(server_id,host,port,tags,'mongodb')

func.mysql_exec("insert into mongodb_status_history SELECT *,LEFT(REPLACE(REPLACE(REPLACE(create_time,'-',''),' ',''),':',''),12) from mongodb_status;",'')

func.mysql_exec('delete from mongodb_status;','')

#get mongodb servers list

servers = func.mysql_query('select id,host,port,username,password,tags from db_servers_mongodb where is_delete=0 and monitor=1;')

logger.info("check mongodb controller started.")

if servers:

plist = []

for row in servers:

server_id=row[0]

host=row[1]

port=row[2]

username=row[3]

password=row[4]

tags=row[5]

p = Process(target = check_mongodb, args = (host,port,username,password,server_id,tags))

plist.append(p)

p.start()

for p in plist:

p.join()

else:

logger.warning("check mongodb: not found any servers")