6 from monitor.wrapper import plc, plccache
7 from monitor import database
10 from monitor.database.dborm import zab_session as session
11 from monitor.database.zabbixapi.model import confirm_ids, HostGroup
14 plcdb = plccache.l_sites # database.dbLoad("l_plcsites")
15 #netid2ip = plccache.plcdb_netid2ip # database.dbLoad("plcdb_netid2ip")
16 lb2hn = plccache.plcdb_lb2hn # database.dbLoad("plcdb_lb2hn")
18 def get_site_iplist(loginbase):
19 node_list = lb2hn[loginbase]
21 # TODO: ip_list string cannot be longer than 255 characters.
22 # TODO: if it is, then we need to break up the discovery rule.
24 for node in node_list:
25 if len(node['interface_ids']) > 0:
26 ifs = plc.api.GetInterfaces({'interface_id' : node['interface_ids'], 'is_primary' : True})
28 #ip = netid2ip[node['interface_ids'][0]]
30 if len(ip_list) > 0: ip_list += ","
35 def add_loginbase(loginbase):
37 techs = plc.getTechEmails(loginbase)
38 pis = plc.getPIEmails(loginbase)
39 iplist = get_site_iplist(loginbase)
41 os.system("""echo '%s' | tr ',' '\n' >> /usr/share/monitor/nodelist.txt""" % iplist )
43 print "zabbixsite.setup_site('%s', %s, %s, '%s')" % (loginbase,techs, pis, iplist)
44 zabbixsite.setup_site(loginbase, techs, pis, iplist)
46 if __name__=="__main__":
48 from monitor import parser as parsermodule
49 parser = parsermodule.getParser(['cacheset'])
50 parser.set_defaults( setupglobal=False, syncsite=True, site=None, sitelist=None, setupids=False)
51 parser.add_option("", "--setupids", action="store_true", dest="setupids",
52 help="Setup global IDs.")
53 parser.add_option("", "--setupglobal", action="store_true", dest="setupglobal",
54 help="Setup global settings.")
55 parser.add_option("", "--nosite", action="store_false", dest="syncsite",
56 help="Do not sync sites.")
57 parser.add_option("", "--site", dest="site",
58 help="Sync only given site name.")
59 parser.add_option("", "--sitelist", dest="sitelist",
60 help="Sync only given site names in the list.")
61 opts = parsermodule.parse_args(parser)
63 os.system("""echo '' > /usr/share/monitor/nodelist.txt""")
66 # Not sure why, but this doesn't work if we continue. so exit.
67 # This step only needs to be called once, but there is no harm in
68 # calling it multiple times.
74 zabbixsite.setup_global()
78 api = plc.getCachedAuthAPI()
79 query = {'peer_id' : None}
81 query.update({'login_base' : opts.site})
83 l = opts.sitelist.split(",")
84 query.update({'login_base' : l})
87 sites = api.GetSites(query, ['login_base'])
88 site_api_list = [ site['login_base'] for site in sites ]
89 for site in sites: # [:20]:
90 add_loginbase(site['login_base'])
94 # NOTE: for all sites in DB but not API, call zabbixsite.delete_site()
95 hg_list = filter(lambda x: '_hostgroup' in x.name, HostGroup.query.all() )
96 site_db_list = [ hg.name[:-len('_hostgroup')] for hg in hg_list ]
97 in_db_not_plc = set(site_db_list) - set(site_api_list)
98 for login_base in in_db_not_plc:
99 print "Deleting %s" % login_base
100 zabbixsite.delete_site(login_base)