From a9abc440cc0c411f9975e1827d71776364bdb659 Mon Sep 17 00:00:00 2001 From: Ken Raffenetti Date: Wed, 27 Sep 2006 22:23:58 +0000 Subject: changes in database models for zone information git-svn-id: https://svn.mcs.anl.gov/repos/bcfg/trunk/bcfg2@2335 ce84e21b-d406-0410-9b95-82705330c041 --- src/lib/Server/Plugins/Hostbase.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src/lib/Server/Plugins/Hostbase.py') diff --git a/src/lib/Server/Plugins/Hostbase.py b/src/lib/Server/Plugins/Hostbase.py index 589d8920b..f4381d4b9 100644 --- a/src/lib/Server/Plugins/Hostbase.py +++ b/src/lib/Server/Plugins/Hostbase.py @@ -137,7 +137,7 @@ class Hostbase(Plugin): WHERE z.zone_id = \'%s\'""" % zone[0]) self.templates['zone'].nameservers = cursor.fetchall() cursor.execute("""SELECT i.ip_addr FROM hostbase_zone_addresses z - INNER JOIN hostbase_ip i ON z.ip_id = i.id + INNER JOIN hostbase_zoneaddress i ON z.zoneaddress_id = i.id WHERE z.zone_id = \'%s\'""" % zone[0]) self.templates['zone'].addresses = cursor.fetchall() cursor.execute("""SELECT m.priority, m.mx FROM hostbase_zone_mxs z -- cgit v1.2.3-1-g7c22