robin.thoni
/
starter-lumen
Watch 1
Star 0
Fork 0
Code Issues 0 Pull Requests 0 Releases 0 Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
6 Commits
2 Branches
Branch: develop
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'develop'
${ noResults }
starter-lumen/confs/pdns.gpgsql.conf

pdns.gpgsql.conf 7.6KB
Permalink History Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273 
  1. 

  2. 

  3. gpgsql-basic-query = SELECT content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM dns_records WHERE disabled=false and type='%s' and name='%s'

  4. gpgsql-id-query = SELECT content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM dns_records WHERE disabled=false and type='%s' and name='%s' and domain_id='%s'

  5. gpgsql-any-query = SELECT content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM dns_records WHERE disabled=false and name='%s'

  6. gpgsql-any-id-query = SELECT content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM dns_records WHERE disabled=false and name='%s' and domain_id='%s'

  7. 

  8. gpgsql-list-query = SELECT content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM dns_records WHERE (disabled=false OR '%s') and domain_id='%s' order by name, type

  9. gpgsql-list-subzone-query = SELECT content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM dns_records WHERE disabled=false and (name='%s' OR name like '%s') and domain_id='%s'

  10. 

  11. gpgsql-remove-empty-non-terminals-from-zone-query = delete from dns_records where domain_id='%s' and type is null

  12. gpgsql-delete-empty-non-terminal-query = delete from dns_records where domain_id='%s' and name='%s' and type is null

  13. 

  14. gpgsql-master-zone-query = select master from dns_domains where name='%s' and type='SLAVE'

  15. 

  16. gpgsql-info-zone-query = select id,name,master,last_check,notified_serial,type,account from dns_domains where name='%s'

  17. 

  18. gpgsql-info-all-slaves-query = select id,name,master,last_check from dns_domains where type='SLAVE'

  19. gpgsql-supermaster-query = select account from dns_supermasters where ip='%s' and nameserver='%s'

  20. gpgsql-supermaster-name-to-ips = select ip,account from dns_supermasters where nameserver='%s' and account='%s'

  21. 

  22. gpgsql-insert-zone-query = insert into dns_domains (type,name,master,account,last_check, notified_serial) values('%s','%s','%s','%s',null,null)

  23. 

  24. gpgsql-insert-record-query = insert into dns_records (content,ttl,prio,type,domain_id,disabled,name,ordername,auth,change_date) values ('%s','%s','%s','%s','%s','%s','%s','%s','%s',null)

  25. #gpgsql-insert-empty-non-terminal-order-query = insert into dns_records (type,domain_id,disabled,name,ordername,auth,ttl,prio,change_date,content) values (null,'%s',false,'%s','%s','%s',null,null,null,null)

  26. 

  27. gpgsql-get-order-first-query = select ordername from dns_records where disabled=false and domain_id='%s' and ordername is not null order by 1 using ~<~ limit 1

  28. gpgsql-get-order-before-query = select ordername, name from dns_records where disabled=false and ordername ~<=~ '%s' and domain_id='%s' and ordername is not null order by 1 using ~>~ limit 1

  29. gpgsql-get-order-after-query = select ordername from dns_records where disabled=false and ordername ~>~ '%s' and domain_id='%s' and ordername is not null order by 1 using ~<~ limit 1

  30. gpgsql-get-order-last-query = select ordername, name from dns_records where disabled=false and ordername != '' and domain_id='%s' and ordername is not null order by 1 using ~>~ limit 1

  31. 

  32. #gpgsql-update-ordername-and-auth-query = update dns_records set ordername='%s',auth='%s' where domain_id='%s' and name='%s' and disabled=false

  33. #gpgsql-update-ordername-and-auth-type-query = update dns_records set ordername='%s',auth='%s' where domain_id='%s' and name='%s' and type='%s' and disabled=false

  34. #gpgsql-nullify-ordername-and-update-auth-query = update dns_records set ordername=NULL,auth='%s' where domain_id='%s' and name='%s' and disabled=false

  35. #gpgsql-nullify-ordername-and-update-auth-type-query = update dns_records set ordername=NULL,auth='%s' where domain_id='%s' and name='%s' and type='%s' and disabled=false

  36. 

  37. gpgsql-update-master-query = update dns_domains set master='%s' where name='%s'

  38. gpgsql-update-kind-query = update dns_domains set type='%s' where name='%s'

  39. #gpgsql-update-account-query = update dns_domains set account='%s' where name='%s'

  40. gpgsql-update-serial-query = update dns_domains set notified_serial='%s' where id='%s'

  41. gpgsql-update-lastcheck-query = update dns_domains set last_check='%s' where id='%s'

  42. gpgsql-zone-lastchange-query = select max(change_date) from dns_records where domain_id='%s'

  43. gpgsql-info-all-master-query = select id,name,master,last_check,notified_serial,type from dns_domains where type='MASTER'

  44. gpgsql-delete-domain-query = delete from dns_domains where name='%s'

  45. gpgsql-delete-zone-query = delete from dns_records where domain_id='%s'

  46. gpgsql-delete-rrset-query = delete from dns_records where domain_id='%s' and name='%s' and type='%s'

  47. gpgsql-delete-names-query = delete from dns_records where domain_id='%s' and name='%s'

  48. 

  49. gpgsql-add-domain-key-query = insert into dns_cryptokeys (domain_id, flags, active, content) select id, '%s', '%s', '%s' from dns_domains where name='%s'

  50. gpgsql-list-domain-keys-query = select cryptokeys.id, flags, case when active then 1 else 0 end as active, content from dns_domains, cryptokeys where cryptokeys.domain_id=domains.id and name='%s'

  51. gpgsql-get-all-domain-metadata-query = select kind,content from dns_domains, domainmetadata where domainmetadata.domain_id=domains.id and name='%s'

  52. gpgsql-get-domain-metadata-query = select content from dns_domains, domainmetadata where domainmetadata.domain_id=domains.id and name='%s' and domainmetadata.kind='%s'

  53. gpgsql-clear-domain-metadata-query = delete from dns_domainmetadata where domain_id=(select id from dns_domains where name='%s') and domainmetadata.kind='%s'

  54. gpgsql-clear-domain-all-metadata-query = delete from dns_domainmetadata where domain_id=(select id from dns_domains where name='%s')

  55. gpgsql-set-domain-metadata-query = insert into dns_domainmetadata (domain_id, kind, content) select id, '%s', '%s' from dns_domains where name='%s'

  56. gpgsql-activate-domain-key-query = update dns_cryptokeys set active=true where domain_id=(select id from dns_domains where name='%s') and  cryptokeys.id='%s'

  57. gpgsql-deactivate-domain-key-query = update dns_cryptokeys set active=false where domain_id=(select id from dns_domains where name='%s') and  cryptokeys.id='%s'

  58. gpgsql-remove-domain-key-query = delete from dns_cryptokeys where domain_id=(select id from dns_domains where name='%s') and cryptokeys.id='%s'

  59. gpgsql-clear-domain-all-keys-query = delete from dns_cryptokeys where domain_id=(select id from dns_domains where name='%s')

  60. gpgsql-get-tsig-key-query = select algorithm, secret from dns_tsigkeys where name='%s'

  61. gpgsql-set-tsig-key-query = insert into dns_tsigkeys (name,algorithm,secret) values('%s','%s','%s')

  62. gpgsql-delete-tsig-key-query = delete from dns_tsigkeys where name='%s'

  63. gpgsql-get-tsig-keys-query = select name,algorithm, secret from dns_tsigkeys

  64. 

  65. gpgsql-get-all-domains-query = select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account from dns_domains LEFT JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=false OR '%s'

  66. 

  67. gpgsql-list-comments-query = SELECT domain_id,name,type,modified_at,account,comment FROM dns_comments WHERE domain_id='%s'

  68. gpgsql-insert-comment-query = INSERT INTO dns_comments (domain_id, name, type, modified_at, account, comment) VALUES ('%s', '%s', '%s', '%s', '%s', '%s')

  69. gpgsql-delete-comment-rrset-query = DELETE FROM dns_comments WHERE domain_id='%s' AND name='%s' AND type='%s'

  70. gpgsql-delete-comments-query = DELETE FROM dns_comments WHERE domain_id='%s'

  71. #gpgsql-search-records-query = SELECT content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM dns_records WHERE name LIKE '%s' OR content LIKE '%s' LIMIT '%s'

  72. #gpgsql-search-comments-query = SELECT domain_id,name,type,modified_at,account,comment FROM dns_comments WHERE name LIKE '%s' OR comment LIKE '%s' LIMIT '%s'

  73. #gpgsql-is-our-domain-query = SELECT id FROM dns_domains WHERE id = '%s' OR name = '%s'