From c1d6ad7379cc93c38966faa23ddc76d1f87558fc Mon Sep 17 00:00:00 2001 From: Aki Tuomi Date: Sat, 15 Jun 2013 17:45:58 +0300 Subject: [PATCH] gpgsqlbackend support for TSIG key management --- modules/gpgsqlbackend/gpgsqlbackend.cc | 3 +++ 1 file changed, 3 insertions(+) diff --git a/modules/gpgsqlbackend/gpgsqlbackend.cc b/modules/gpgsqlbackend/gpgsqlbackend.cc index e725d420d8..426bd818cf 100644 --- a/modules/gpgsqlbackend/gpgsqlbackend.cc +++ b/modules/gpgsqlbackend/gpgsqlbackend.cc @@ -121,6 +121,9 @@ public: declare(suffix,"deactivate-domain-key-query","", "update cryptokeys set active=false where domain_id=(select id from domains where name=E'%s') and cryptokeys.id=%d"); declare(suffix,"remove-domain-key-query","", "delete from cryptokeys where domain_id=(select id from domains where name=E'%s') and cryptokeys.id=%d"); declare(suffix,"get-tsig-key-query","", "select algorithm, secret from tsigkeys where name=E'%s'"); + declare(suffix,"set-tsig-key-query","", "insert into tsigkeys (name,algorithm,secret) values('%s','%s','%s')"); + declare(suffix,"delete-tsig-key-query","", "delete from tsigkeys where name='%s'"); + declare(suffix,"get-tsig-keys-query","", "select name,algorithm, secret from tsigkeys"); declare(suffix,"get-all-domains-query", "Retrieve all domains", "select records.domain_id, records.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check from records, domains where records.domain_id=domains.id and records.type='SOA'"); } -- 2.47.3