diff options
author | Seung Soo Mun <hamletmun@gmail.com> | 2015-06-07 22:17:42 +0000 |
---|---|---|
committer | Ted Trask <ttrask01@yahoo.com> | 2015-06-08 11:17:01 -0400 |
commit | fc2453e74aabeda50f034f3323118d1546e49909 (patch) | |
tree | 85893139d77ed56e3bed795aef2cbdc6138c403a | |
parent | 48a68193bbe71a28fc61dfeab364637c4a1ccf2b (diff) | |
download | acf-provisioning-fc2453e74aabeda50f034f3323118d1546e49909.tar.bz2 acf-provisioning-fc2453e74aabeda50f034f3323118d1546e49909.tar.xz |
new devices for acf-provisioning: algo, cyberdata, grandstream
Signed-off-by: Ted Trask <ttrask01@yahoo.com>
-rwxr-xr-x | cgi-bin/provisioning.cgi | 7 | ||||
-rw-r--r-- | config/templates/algo8180-template.lua | 49 | ||||
-rw-r--r-- | config/templates/cyberdata-template.lua | 37 | ||||
-rw-r--r-- | config/templates/grandstream-template.lua | 39 | ||||
-rw-r--r-- | provisioning-scripts.lua | 72 |
5 files changed, 203 insertions, 1 deletions
diff --git a/cgi-bin/provisioning.cgi b/cgi-bin/provisioning.cgi index 67381bb..fcad3a1 100755 --- a/cgi-bin/provisioning.cgi +++ b/cgi-bin/provisioning.cgi @@ -113,7 +113,12 @@ if ( request_method == "GET" ) then http_code(302) log:close() os.exit() - end + -- If it's a Grandstream, 404 the cfgMAC without extension + elseif string.match(user_agent, "Grandstream") and (f=="") then + http_code(404) + log:close() + os.exit() + end log:write("Checking PROV Table for results\n") -- Load the ACF mvc diff --git a/config/templates/algo8180-template.lua b/config/templates/algo8180-template.lua new file mode 100644 index 0000000..1b32678 --- /dev/null +++ b/config/templates/algo8180-template.lua @@ -0,0 +1,49 @@ +<% +-- Algo 8180 SIP Audio Alerter Configuration File Template +local values = ... + +local function yesno ( bool ) + if bool then + return "Yes" + else + return "No" + end +end + +local function set_elem(elem,value,i) + local e = elem + if i then e = elem.."_"..tostring(i).."_" end + local output = {e.." = "} + if type(value) == "boolean" then + output[#output+1] = yesno(value) + elseif value then + output[#output+1] = value + end + io.write(table.concat(output).."\n") +end +%> + +<%in /var/www/provisioning/htdocs/Algo/init.cfg %> + +<% +set_elem("admin.pwd", values.device.adminpassword) +set_elem("net.time", values.device.sntpserver) +set_elem("sip.proxy", values.device.registrar) +for pg, pg_t in pairs(values) do + -- Is it of the form regX ? + local num = string.match(pg, 'reg(%d+)') + if tostring(num) < "6" then + if pg_t.extension ~= "" then + set_elem("sip.alert"..num..".auth", pg_t.extension) + set_elem("sip.alert"..num..".pwd", pg_t.password) + set_elem("sip.alert"..num..".user", pg_t.extension) + end + elseif num == "6" then + if pg_t.extension ~= "" then + set_elem("sip.u1.auth", pg_t.extension) + set_elem("sip.u1.pwd", pg_t.password) + set_elem("sip.u1.user", pg_t.extension) + end + end +end +%> diff --git a/config/templates/cyberdata-template.lua b/config/templates/cyberdata-template.lua new file mode 100644 index 0000000..e05bdd9 --- /dev/null +++ b/config/templates/cyberdata-template.lua @@ -0,0 +1,37 @@ +<% +-- CyberData Intercom Configuration File Template +local values = ... + +require 'LuaXml' +local init_cfg = xml.load("/var/www/provisioning/htdocs/CyberData/init.cfg") + +-- <IPSettings> + +-- <SIPSettings> + +for pg, pg_t in pairs(values) do + -- Is it of the form regX ? + local num = string.match(pg, 'reg(%d+)') + if num then + if pg_t.extension ~= "" then + init_cfg[2]:append("SIPServer")[1] = values.device.registrar + init_cfg[2]:append("SIPUserID")[1] = pg_t.extension + init_cfg[2]:append("SIPAuthID")[1] = pg_t.extension + init_cfg[2]:append("SIPAuthPassword")[1] = pg_t.password + init_cfg[2]:append("DialoutExtension0")[1] = pg_t.hotlinedestination + init_cfg[2]:append("DialoutID0")[1] = pg_t.callerid + end + end +end + + +-- <ClockSettings> + +init_cfg[3]:append("NTPServer")[1] = values.device.sntpserver +init_cfg[3]:append("NTPTimezone")[1] = values.device.timezone + +-- init_cfg:save("TEST-cyberdata.xml") + +print("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n") +print(init_cfg) +%> diff --git a/config/templates/grandstream-template.lua b/config/templates/grandstream-template.lua new file mode 100644 index 0000000..cf1e95e --- /dev/null +++ b/config/templates/grandstream-template.lua @@ -0,0 +1,39 @@ +<% +-- Grandstream Configuration File Template +local values = ... + +require 'LuaXml' +local init_cfg = xml.load("/var/www/provisioning/htdocs/Grandstream/init.cfg") + +-- <config> +init_cfg[1]:append("P2")[1] = values.device.adminpassword +init_cfg[1]:append("P30")[1] = values.device.sntpserver +init_cfg[1]:append("P246")[1] = values.device.timezone + +for pg, pg_t in pairs(values) do + -- Is it of the form regX ? + local num = string.match(pg, 'reg(%d+)') + if num == "1" then + if pg_t.extension ~= "" then + init_cfg[1]:append("P47")[1] = values.device.registrar + init_cfg[1]:append("P35")[1] = pg_t.extension + init_cfg[1]:append("P36")[1] = pg_t.extension + init_cfg[1]:append("P34")[1] = pg_t.password + init_cfg[1]:append("P3")[1] = pg_t.callerid + end + elseif num == "2" then + if pg_t.extension ~= "" then + init_cfg[1]:append("P747")[1] = values.device.registrar + init_cfg[1]:append("P735")[1] = pg_t.extension + init_cfg[1]:append("P736")[1] = pg_t.extension + init_cfg[1]:append("P734")[1] = pg_t.password + init_cfg[1]:append("P703")[1] = pg_t.callerid + end + end +end + +-- init_cfg:save("TEST-grandstream.xml") + +print("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n") +print(init_cfg) +%> diff --git a/provisioning-scripts.lua b/provisioning-scripts.lua index 2e3807e..89fe9ae 100644 --- a/provisioning-scripts.lua +++ b/provisioning-scripts.lua @@ -54,6 +54,10 @@ mymodule.provisioning_classes = { "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Cisco 2 Port Phone Adapter SPA112', '200')", "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Snom 300', '300')", "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Snom 320/360/370', '301')", + "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Algo 8180 SIP Audio Alerter', '400')";, + "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'), 'Grandstream HT-502', '600')";, + "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Grandstream HT701', '601')";, "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Unsupported Phone', '999')", -- services "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='services'), 'Office Phone', '1')", @@ -299,6 +303,20 @@ mymodule.classes_to_param_groups = { "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Snom 320/360/370'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 11 (Snom)'))", "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Snom 320/360/370'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 12 (Snom)'))", "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Snom 320/360/370'), (SELECT group_id FROM provisioning_groups WHERE label='Snom Device'))", + "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='Ring Extension 1 (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='Ring Extension 2 (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='Ring Extension 3 (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='Ring Extension 4 (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='Ring Extension 5 (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='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='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'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Grandstream HT701'), (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 HT701'), (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)'))", -- 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'))", @@ -315,23 +333,35 @@ mymodule.provisioning_groups = { "INSERT INTO provisioning_groups VALUES(default, 'device', 'Cisco ATA Device', '1')", "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', 'Grandstream 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')", "INSERT INTO provisioning_groups VALUES(default, 'reg1', 'Registration 1 (Unsupported)', '10')", "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 (Grandstream)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg2', 'Registration 2 (Polycom)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg2', 'Registration 2 (Linksys)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg2', 'Registration 2 (Cisco)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg2', 'Registration 2 (Snom)', '10')", + "INSERT INTO provisioning_groups VALUES(default, 'reg2', 'Ring Extension 2 (Algo)', '10')", + "INSERT INTO provisioning_groups VALUES(default, 'reg2', 'Registration 2 (Grandstream)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg3', 'Registration 3 (Polycom)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg3', 'Registration 3 (Snom)', '10')", + "INSERT INTO provisioning_groups VALUES(default, 'reg3', 'Ring Extension 3 (Algo)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg4', 'Registration 4 (Polycom)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg4', 'Registration 4 (Snom)', '10')", + "INSERT INTO provisioning_groups VALUES(default, 'reg4', 'Ring Extension 4 (Algo)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg5', 'Registration 5 (Polycom)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg5', 'Registration 5 (Snom)', '10')", + "INSERT INTO provisioning_groups VALUES(default, 'reg5', 'Ring Extension 5 (Algo)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg6', 'Registration 6 (Polycom)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg6', 'Registration 6 (Snom)', '10')", + "INSERT INTO provisioning_groups VALUES(default, 'reg6', 'Page Extension (Algo)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg7', 'Registration 7 (Polycom)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg7', 'Registration 7 (Snom)', '10')", "INSERT INTO provisioning_groups VALUES(default, 'reg8', 'Registration 8 (Polycom)', '10')", @@ -428,6 +458,22 @@ mymodule.param_groups_to_params = { "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Snom Device'), (SELECT param_id FROM provisioning_params WHERE name='forwardbusyenable'), null, true)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Snom Device'), (SELECT param_id FROM provisioning_params WHERE name='forwardall'), null, true)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Snom Device'), (SELECT param_id FROM provisioning_params WHERE name='forwardallenable'), 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='template'), '/etc/provisioning/templates/algo8180-template.lua', 'f')" + "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='mac'), 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='registrar'), null, false)" + "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)" + "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)" + "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', 'f')" + "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='Grandstream Device'), (SELECT param_id FROM provisioning_params WHERE name='template'), '/etc/provisioning/templates/grandstream-template.lua', 'f')" + "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)" -- 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)", @@ -464,6 +510,16 @@ mymodule.param_groups_to_params = { "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Snom)'), (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 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Snom)'), (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='Ring Extension 1 (Algo)'), (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='Ring Extension 1 (Algo)'), (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 (CyberData)'), (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)'), (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 (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 (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)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Polycom)'), (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 2 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='forwardnoanswer'), null, true)", @@ -497,6 +553,11 @@ mymodule.param_groups_to_params = { "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Snom)'), (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 2 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Snom)'), (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='Ring Extension 2 (Algo)'), (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='Ring Extension 2 (Algo)'), (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 2 (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 2 (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 2 (Grandstream)'), (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 3 (Polycom)'), (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 3 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 3 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='forwardnoanswer'), null, true)", @@ -512,6 +573,8 @@ mymodule.param_groups_to_params = { "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 3 (Snom)'), (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 3 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 3 (Snom)'), (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='Ring Extension 3 (Algo)'), (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='Ring Extension 3 (Algo)'), (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 4 (Polycom)'), (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 4 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='forwardnoanswer'), null, true)", @@ -527,6 +590,8 @@ mymodule.param_groups_to_params = { "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (Snom)'), (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 4 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (Snom)'), (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='Ring Extension 4 (Algo)'), (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='Ring Extension 4 (Algo)'), (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 5 (Polycom)'), (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 5 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 5 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='forwardnoanswer'), null, true)", @@ -542,6 +607,8 @@ mymodule.param_groups_to_params = { "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 5 (Snom)'), (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 5 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 5 (Snom)'), (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='Ring Extension 5 (Algo)'), (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='Ring Extension 5 (Algo)'), (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 6 (Polycom)'), (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 6 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 6 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='forwardnoanswer'), null, true)", @@ -557,6 +624,8 @@ mymodule.param_groups_to_params = { "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 6 (Snom)'), (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 6 (Snom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 6 (Snom)'), (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='Page Extension (Algo)'), (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='Page Extension (Algo)'), (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 7 (Polycom)'), (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 7 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='password'), null, false)", "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='Registration 7 (Polycom)'), (SELECT param_id FROM provisioning_params WHERE name='forwardnoanswer'), null, true)", @@ -1073,6 +1142,9 @@ mymodule.provisioning_options = { "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='template'), 'Linksys ATA', '/etc/provisioning/templates/linksysata-template.lua', '2')", "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='template'), 'Snom', '/etc/provisioning/templates/snom-template.lua', '3')", "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='template'), 'Cisco ATA', '/etc/provisioning/templates/ciscoata-template.lua', '4')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='template'), 'Algo 8180', '/etc/provisioning/templates/algo8180-template.lua', '5')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='template'), 'CyberData', '/etc/provisioning/templates/cyberdata-template.lua', '6')", + "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='template'), 'Grandstream', '/etc/provisioning/templates/grandstream-template.lua', '7')", "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='polycomringtone'), 'Silent Ring', '1', '1')", "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='polycomringtone'), 'Low Trill', '2', '2')", "INSERT INTO provisioning_options VALUES((SELECT param_id FROM provisioning_params WHERE name='polycomringtone'), 'Low Double Trill', '3', '3')", |