From c1c41b75bcee250d50130a3665bb57ae6536bdc7 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Vin=C3=ADcius=20de=20Jesus?= Date: Tue, 5 Jul 2016 10:56:58 -0300 Subject: New device for acf-provisioning: Cyberdata Paging Zone Controller Signed-off-by: Ted Trask --- config/templates/cyberdata-template.lua | 48 ++++++++-- provisioning-scripts.lua | 152 ++++++++++++++++++++++++++++---- upgradeprovisioning | 108 ++++++++++++++++++++++- 3 files changed, 280 insertions(+), 28 deletions(-) diff --git a/config/templates/cyberdata-template.lua b/config/templates/cyberdata-template.lua index 607ccfc..f144af6 100644 --- a/config/templates/cyberdata-template.lua +++ b/config/templates/cyberdata-template.lua @@ -51,7 +51,7 @@ local function yesno(xmlobj, name, value) elseif (value == true) then value = "Yes" end - setValue(xmlobj, ''..name..'', ''..value..'') + setValue(xmlobj, name, value) end end @@ -81,6 +81,14 @@ cfg = mergeXML(cfg, init_cfg) -- +-- + +if values.device then + local clocksettings = findOrAppendSection(cfg, "ClockSettings") + setValue(clocksettings, "NTPServer", values.device.sntpserver) + setValue(clocksettings, "NTPTimezone", values.device.timezone) +end + -- if values.reg1 then @@ -91,6 +99,7 @@ if values.reg1 then setValue(sipsettings, "SIPUserID", values.reg1.extension) setValue(sipsettings, "SIPAuthID", values.reg1.extension) setValue(sipsettings, "SIPAuthPassword", values.reg1.password) + -- These parameters are used by CyberData Intercom setValue(sipsettings, "DialoutExtension0", values.reg1.hotlinedestination) setValue(sipsettings, "DialoutID0", values.reg1.callerid) end @@ -99,8 +108,10 @@ end if values.device then local DeviceSettings = findOrAppendSection(cfg, "DeviceSettings") - setValue(DeviceSettings, "SpeakerVolume", values.device.cyberspeakervolume) + -- These parameters are used by CyberData Intercom and CyberData Paging Zone Controller setValue(DeviceSettings, "AdminPassword", values.device.adminpassword) + -- These parameters are used by CyberData Intercom + setValue(DeviceSettings, "SpeakerVolume", values.device.cyberspeakervolume) setValue(DeviceSettings, "RingVolume", values.device.cyberringvolume) setValue(DeviceSettings, "MicGain", values.device.cybermicgain) yesno (DeviceSettings, "ActivateRelayWithDTMF", values.device.activaterelaywithdtmf) @@ -108,21 +119,40 @@ if values.device then setValue(DeviceSettings, "DTMFActivationDuration", values.device.dtmfactivationduration) yesno (DeviceSettings, "ActivateRelayDuringRing", values.device.activaterelayduringring) yesno (DeviceSettings, "ActivateRelayDuringCall", values.device.activaterelayduringcall) + yesno (DeviceSettings, "AutoAnswerIncomingCalls", values.device.autoanswerincomingcalls) + -- These parameters are used by CyberData Paging Zone Controller + yesno (DeviceSettings, "BypassDTMF", values.device.bypassdtmf) + yesno (DeviceSettings, "BeepOnInitialization", values.device.beeponinitialization) + yesno (DeviceSettings, "BeepBeforePage", values.device.beepbeforepage) end --- +-- +-- These parameters are used by CyberData Paging Zone Controller if values.device then - local ButtonSettings = findOrAppendSection(cfg, "ButtonSettings") - yesno (ButtonSettings, "PlayToneWhileRelayActive", values.device.playtonewhilerelayactive) + local ZoneSettings = findOrAppendSection(cfg, "ZoneSettings") + yesno(ZoneSettings, "BypassDTMF", values.device.bypassdtmf) end --- +-- Loop through Parameter Groups looking for 'zone' params +for pg, pg_t in pairs(values) do + -- Is it of the form zoneXX ? + local num = string.match(pg, 'zone(%d%d)') + if num then + local ZoneSettings = findOrAppendSection(cfg, "ZoneSettings") + yesno(ZoneSettings, 'Zone'..num..'Port1', pg_t.pagingport1) + yesno(ZoneSettings, 'Zone'..num..'Port2', pg_t.pagingport2) + yesno(ZoneSettings, 'Zone'..num..'Port3', pg_t.pagingport3) + yesno(ZoneSettings, 'Zone'..num..'Port4', pg_t.pagingport4) + end +end + +-- +-- These parameters are used by CyberData Intercom if values.device then - local clocksettings = findOrAppendSection(cfg, "ClockSettings") - setValue(clocksettings, "NTPServer", values.device.sntpserver) - setValue(clocksettings, "NTPTimezone", values.device.timezone) + local ButtonSettings = findOrAppendSection(cfg, "ButtonSettings") + yesno (ButtonSettings, "PlayToneWhileRelayActive", values.device.playtonewhilerelayactive) end -- cfg:save("TEST-cyberdata.xml") diff --git a/provisioning-scripts.lua b/provisioning-scripts.lua index 998a8e7..680e8b6 100644 --- a/provisioning-scripts.lua +++ b/provisioning-scripts.lua @@ -60,6 +60,7 @@ mymodule.provisioning_classes = { "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Grandstream HT702', '453')", "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Grandstream HT704', '454')", "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'CyberData Intercom', '500')", + "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'CyberData Paging Zone Controller', '501')", "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Algo 8180 SIP Audio Alerter', '600')", "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Unsupported Phone', '999')", -- services @@ -314,7 +315,7 @@ mymodule.classes_to_param_groups = { "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Algo 8180 SIP Audio Alerter'), (SELECT group_id FROM provisioning_groups WHERE label='Page Extension (Algo)'))", "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Algo 8180 SIP Audio Alerter'), (SELECT group_id FROM provisioning_groups WHERE label='Algo 8180 Device'))", "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Intercom'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Intercom'), (SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Intercom'), (SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'))", "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Grandstream HT-502'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Grandstream)'))", "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Grandstream HT-502'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Grandstream)'))", "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Grandstream HT-502'), (SELECT group_id FROM provisioning_groups WHERE label='Grandstream Device'))", @@ -329,6 +330,23 @@ mymodule.classes_to_param_groups = { "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Grandstream HT704'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (Grandstream)'))", "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Grandstream HT704'), (SELECT group_id FROM provisioning_groups WHERE label='Grandstream Device'))", "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Unsupported Phone'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Unsupported)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData Paging Zone Controller)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'))", -- Services "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Office Phone'), (SELECT group_id FROM provisioning_groups WHERE label='Office Phone'))", "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Residential Phone'), (SELECT group_id FROM provisioning_groups WHERE label='Residential Phone'))", @@ -345,8 +363,9 @@ mymodule.provisioning_groups = { "INSERT INTO provisioning_groups VALUES(default, 'device', 'Polycom Device', '1')", "INSERT INTO provisioning_groups VALUES(default, 'device', 'Snom Device', '1')", "INSERT INTO provisioning_groups VALUES(default, 'device', 'Algo 8180 Device', '1')", - "INSERT INTO provisioning_groups VALUES(default, 'device', 'CyberData Device', '1')", + "INSERT INTO provisioning_groups VALUES(default, 'device', 'CyberData Intercom Device', '1')", "INSERT INTO provisioning_groups VALUES(default, 'device', 'Grandstream Device', '1')", + "INSERT INTO provisioning_groups VALUES(default, 'device', 'CyberData Paging Zone Controller Device', '1')", "INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (Polycom)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (Linksys)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (Cisco)', '10')", @@ -354,6 +373,7 @@ mymodule.provisioning_groups = { "INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (Snom)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Ring Extension 1 (Algo)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (CyberData)', '10')", + "INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (CyberData Paging Zone Controller)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (Grandstream)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg2', 'Registration 2 (Polycom)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg2', 'Registration 2 (Linksys)', '10')", @@ -409,6 +429,21 @@ mymodule.provisioning_groups = { "INSERT INTO provisioning_groups VALUES(default, 'reg32', 'Registration 32 (Polycom)', '13')", "INSERT INTO provisioning_groups VALUES(default, 'reg33', 'Registration 33 (Polycom)', '13')", "INSERT INTO provisioning_groups VALUES(default, 'reg34', 'Registration 34 (Polycom)', '13')", + "INSERT INTO provisioning_groups VALUES(default, 'zone00', 'Zone 00 (CyberData Paging Zone Controller)', '14')", + "INSERT INTO provisioning_groups VALUES(default, 'zone01', 'Zone 01 (CyberData Paging Zone Controller)', '14')", + "INSERT INTO provisioning_groups VALUES(default, 'zone02', 'Zone 02 (CyberData Paging Zone Controller)', '14')", + "INSERT INTO provisioning_groups VALUES(default, 'zone03', 'Zone 03 (CyberData Paging Zone Controller)', '14')", + "INSERT INTO provisioning_groups VALUES(default, 'zone04', 'Zone 04 (CyberData Paging Zone Controller)', '14')", + "INSERT INTO provisioning_groups VALUES(default, 'zone05', 'Zone 05 (CyberData Paging Zone Controller)', '14')", + "INSERT INTO provisioning_groups VALUES(default, 'zone06', 'Zone 06 (CyberData Paging Zone Controller)', '14')", + "INSERT INTO provisioning_groups VALUES(default, 'zone07', 'Zone 07 (CyberData Paging Zone Controller)', '14')", + "INSERT INTO provisioning_groups VALUES(default, 'zone08', 'Zone 08 (CyberData Paging Zone Controller)', '14')", + "INSERT INTO provisioning_groups VALUES(default, 'zone09', 'Zone 09 (CyberData Paging Zone Controller)', '14')", + "INSERT INTO provisioning_groups VALUES(default, 'zone10', 'Zone 10 (CyberData Paging Zone Controller)', '14')", + "INSERT INTO provisioning_groups VALUES(default, 'zone11', 'Zone 11 (CyberData Paging Zone Controller)', '14')", + "INSERT INTO provisioning_groups VALUES(default, 'zone12', 'Zone 12 (CyberData Paging Zone Controller)', '14')", + "INSERT INTO provisioning_groups VALUES(default, 'zone13', 'Zone 13 (CyberData Paging Zone Controller)', '14')", + "INSERT INTO provisioning_groups VALUES(default, 'zone14', 'Zone 14 (CyberData Paging Zone Controller)', '14')", -- services "INSERT INTO provisioning_groups VALUES(default, 'services', 'Office Phone', '21')", "INSERT INTO provisioning_groups VALUES(default, 'services', 'Residential Phone', '31')", @@ -479,27 +514,37 @@ mymodule.param_groups_to_params = { "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Algo 8180 Device'), (SELECT param_id FROM provisioning_params WHERE name='algoringvol'), null, true)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Algo 8180 Device'), (SELECT param_id FROM provisioning_params WHERE name='algopagevol'), null, true)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Algo 8180 Device'), (SELECT param_id FROM provisioning_params WHERE name='algospkmode'), null, true)"; - "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='template'), '/etc/provisioning/templates/cyberdata-template.lua', false)", - "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='mac'), null, true)", - "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='registrar'), null, true)", - "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='sntpserver'), null, false)", - "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='timezone'), null, false)", - "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='cyberspeakervolume'), null, true)", - "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='adminpassword'), null, true)", - "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='cyberringvolume'), null, true)", - "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='cybermicgain'), null, true)", - "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='activaterelaywithdtmf'), null, true)", - "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='dtmfactivationcode'), null, true)", - "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='dtmfactivationduration'), null, true)", - "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='playtonewhilerelayactive'), null, true)", - "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='activaterelayduringring'), null, true)", - "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Device'), (SELECT param_id FROM provisioning_params WHERE name='activaterelayduringcall'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='template'), '/etc/provisioning/templates/cyberdata-template.lua', false)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='mac'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='registrar'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='sntpserver'), null, false)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='timezone'), null, false)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='cyberspeakervolume'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='adminpassword'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='cyberringvolume'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='cybermicgain'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='activaterelaywithdtmf'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='dtmfactivationcode'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='dtmfactivationduration'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='playtonewhilerelayactive'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='activaterelayduringring'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='activaterelayduringcall'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='autoanswerincomingcalls'), null, true)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Grandstream Device'), (SELECT param_id FROM provisioning_params WHERE name='template'), '/etc/provisioning/templates/grandstream-template.lua', false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Grandstream Device'), (SELECT param_id FROM provisioning_params WHERE name='mac'), null, true)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Grandstream Device'), (SELECT param_id FROM provisioning_params WHERE name='registrar'), null, false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Grandstream Device'), (SELECT param_id FROM provisioning_params WHERE name='sntpserver'), null, false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Grandstream Device'), (SELECT param_id FROM provisioning_params WHERE name='timezone'), null, false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Grandstream Device'), (SELECT param_id FROM provisioning_params WHERE name='adminpassword'), null, false)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='registrar'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='sntpserver'), null, false)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='timezone'), null, false)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='mac'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='adminpassword'), null, false)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='template'), '/etc/provisioning/templates/cyberdata-template.lua', 'f')", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='bypassdtmf'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='beeponinitialization'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='beepbeforepage'), null, true)", -- Registrations "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Unsupported)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Unsupported)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, true)", @@ -544,6 +589,9 @@ mymodule.param_groups_to_params = { "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData)'), (SELECT param_id FROM provisioning_params WHERE name='callerid'), null, true)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData)'), (SELECT param_id FROM provisioning_params WHERE name='hotlineenable'), null, true)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData)'), (SELECT param_id FROM provisioning_params WHERE name='hotlinedestination'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='callerid'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, true)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Grandstream)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Grandstream)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, true)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Grandstream)'), (SELECT param_id FROM provisioning_params WHERE name='callerid'), null, true)", @@ -1092,6 +1140,66 @@ mymodule.param_groups_to_params = { "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Hotline'), (SELECT param_id FROM provisioning_params WHERE name='softkey8'), 'false', false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Hotline'), (SELECT param_id FROM provisioning_params WHERE name='softkey9'), 'false', false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Hotline'), (SELECT param_id FROM provisioning_params WHERE name='softkey10'), 'false', false)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)", + "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)", } -- List of each parameter used in any way for any device - mostly for how to display @@ -1125,6 +1233,14 @@ mymodule.provisioning_params = { "INSERT INTO provisioning_params values(default, 'playtonewhilerelayactive', 'boolean', 'Relay Activation Tone Enable', '', 'true', '25', '', null)", "INSERT INTO provisioning_params values(default, 'activaterelayduringring', 'boolean', 'Activate Relay During Ring Enable', '', 'false', '26', '', null)", "INSERT INTO provisioning_params values(default, 'activaterelayduringcall', 'boolean', 'Activate Relay While Call Active Enable', '', 'false', '27', '', null)", + "INSERT INTO provisioning_params values(default, 'bypassdtmf', 'boolean', 'Bypass SIP DTMF Entry', 'Bypassing DTMF will result in all SIP calls being played to Zone 0', 'false', '28', '', null)", + "INSERT INTO provisioning_params values(default, 'beeponinitialization', 'boolean', 'Beep On Initialization', '', 'true', '29', '', null)", + "INSERT INTO provisioning_params values(default, 'beepbeforepage', 'boolean', 'Beep on page', '', 'true', '30', '', null)", + "INSERT INTO provisioning_params values(default, 'pagingport1', 'boolean', 'Paging Port 1 Enable', '', 'true', '31', '', null)", + "INSERT INTO provisioning_params values(default, 'pagingport2', 'boolean', 'Paging Port 2 Enable', '', 'true', '32', '', null)", + "INSERT INTO provisioning_params values(default, 'pagingport3', 'boolean', 'Paging Port 3 Enable', '', 'true', '33', '', null)", + "INSERT INTO provisioning_params values(default, 'pagingport4', 'boolean', 'Paging Port 4 Enable', '', 'true', '34', '', null)", + "INSERT INTO provisioning_params values(default, 'autoanswerincomingcalls', 'boolean', 'Auto Answer Incoming Calls Enable', '', 'true', '35', '', null)", "INSERT INTO provisioning_params VALUES(default, 'extension', 'text', 'Extension', '', '', '101', '^%d*$', null)", "INSERT INTO provisioning_params VALUES(default, 'password', 'text', 'Password', '', '', '102', '', null)", "INSERT INTO provisioning_params VALUES(default, 'forwardnoanswerenable', 'boolean', 'Forward on No-answer Enable', '', 'false', '103', '', null)", @@ -1157,7 +1273,7 @@ mymodule.provisioning_params = { "INSERT INTO provisioning_params VALUES(default, 'softkey8', 'boolean', 'Soft Key 8 Enable', '', 'false', '308', '', null)", "INSERT INTO provisioning_params VALUES(default, 'softkey9', 'boolean', 'Soft Key 9 Enable', '', 'false', '309', '', null)", "INSERT INTO provisioning_params VALUES(default, 'softkey10', 'boolean', 'Soft Key 10 Enable', '', 'false', '310', '', null)", - "INSERT INTO provisioning_params VALUES(default, 'databaseversion', 'text', 'Provisioning Database Version', 'Do not edit or delete!', '9', '999', '', null)", + "INSERT INTO provisioning_params VALUES(default, 'databaseversion', 'text', 'Provisioning Database Version', 'Do not edit or delete!', '10', '999', '', null)", } -- All of the (non-default) parameter values for all devices are stored here diff --git a/upgradeprovisioning b/upgradeprovisioning index 84fb954..3d41489 100755 --- a/upgradeprovisioning +++ b/upgradeprovisioning @@ -481,7 +481,7 @@ if [ "$version" -lt "5" ]; then psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Algo 8180 Device'), (SELECT param_id FROM provisioning_params WHERE name='sntpserver'), null, false)" provisioning psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Algo 8180 Device'), (SELECT param_id FROM provisioning_params WHERE name='adminpassword'), null, false)" provisioning psql -U postgres -c "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='template'), 'Algo 8180', '/etc/provisioning/templates/algo8180-template.lua', '5')" provisioning - + # database psql -U postgres -c "UPDATE provisioning_params SET value='5' WHERE name='databaseversion'" provisioning fi @@ -604,4 +604,110 @@ if [ "$version" -lt "9" ]; then # database psql -U postgres -c "UPDATE provisioning_params SET value='9' WHERE name='databaseversion'" provisioning fi + +if [ "$version" -lt "10" ]; then + echo "Upgrading to database version 10" + + psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'CyberData Paging Zone Controller', '501')" provisioning + psql -U postgres -c "INSERT INTO provisioning_groups VALUES(default, 'device', 'CyberData Paging Zone Controller Device', '1')" provisioning + psql -U postgres -c "INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (CyberData Paging Zone Controller)', '10')" provisioning + psql -U postgres -c "UPDATE provisioning_groups SET label = 'CyberData Intercom Device' where label = 'CyberData Device'" provisioning + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData Paging Zone Controller)'))" provisioning + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'))" provisioning + psql -U postgres -c "INSERT INTO provisioning_params values(default, 'bypassdtmf', 'boolean', 'Bypass SIP DTMF Entry', 'Bypassing DTMF will result in all SIP calls being played to Zone 0', 'false', '28', '', null)" provisioning + psql -U postgres -c "INSERT INTO provisioning_params values(default, 'beeponinitialization', 'boolean', 'Beep On Initialization', '', 'true', '29', '', null)" provisioning + psql -U postgres -c "INSERT INTO provisioning_params values(default, 'beepbeforepage', 'boolean', 'Beep on page', '', 'true', '30', '', null)" provisioning + psql -U postgres -c "INSERT INTO provisioning_params values(default, 'autoanswerincomingcalls', 'boolean', 'Auto Answer Incoming Calls Enable', '', 'true', '35', '', null)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='registrar'), null, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='sntpserver'), null, false)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='timezone'), null, false)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='mac'), null, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='adminpassword'), null, false)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='template'), '/etc/provisioning/templates/cyberdata-template.lua', 'f')" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='bypassdtmf'), null, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='beeponinitialization'), null, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Paging Zone Controller Device'), (SELECT param_id FROM provisioning_params WHERE name='beepbeforepage'), null, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='callerid'), null, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='extension'), null, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='autoanswerincomingcalls'), null, true)" provisioning + + for a in $(seq 1 4); do + psql -U postgres -c "INSERT INTO provisioning_params values(default, 'pagingport$a', 'boolean', 'Paging Port $a Enable', '', 'true', '3$a', '', null)" provisioning + done + + for a in $(seq 0 9); do + psql -U postgres -c "INSERT INTO provisioning_groups VALUES(default, 'zone0$a', 'Zone 0$a (CyberData Paging Zone Controller)', '14')" provisioning + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 0$a (CyberData Paging Zone Controller)'))" provisioning + done + + for a in $(seq 0 4); do + psql -U postgres -c "INSERT INTO provisioning_groups VALUES(default, 'zone1$a', 'Zone 1$a (CyberData Paging Zone Controller)', '14')" provisioning + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='CyberData Paging Zone Controller'), (SELECT group_id FROM provisioning_groups WHERE label='Zone 1$a (CyberData Paging Zone Controller)'))" provisioning + done + + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 00 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 01 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 02 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 03 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 04 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 05 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 06 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 07 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 08 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 09 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 10 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 11 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 12 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 13 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport1'), false, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport2'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport3'), true, true)" provisioning + psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Zone 14 (CyberData Paging Zone Controller)'), (SELECT param_id FROM provisioning_params WHERE name='pagingport4'), true, true)" provisioning + + # database + psql -U postgres -c "UPDATE provisioning_params SET value='10' WHERE name='databaseversion'" provisioning +fi exit 0 -- cgit v1.2.3