search

PowerDNS / pdns

PowerDNS Authoritative, PowerDNS Recursor, dnsdist
https://www.powerdns.com/
GNU General Public License v2.0
3.63k stars 904 forks source link

pdns[4351]: Query: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=? #7473

Closed lonc3ng closed 5 years ago

lonc3ng commented 5 years ago

Hello

can you help me to my problem transfer from bind to pdns , and error

my pdns.conf

` cat /etc/pdns/pdns.conf

Autogenerated configuration file template

#################################

8bit-dns Allow 8bit dns queries

#

8bit-dns=no

#################################

allow-axfr-ips Allow zonetransfers only to these subnets

#

allow-axfr-ips=127.0.0.0/8,::1

coba tambahin ip ns1-new 202.158.20.2 .01022019

# allow-axfr-ips=127.0.0.0/8,202.158.9.80/29,202.158.40.0/28,202.158.50.80/28,202.158.20.1,202.158.20.2,202.158.20.80/28,::1

#################################

allow-dnsupdate-from A global setting to allow DNS updates from these IP ranges.

#

allow-dnsupdate-from=127.0.0.0/8,::1

#################################

allow-notify-from Allow AXFR NOTIFY from these IP ranges. If empty, drop all incoming notifies.

#

allow-notify-from=0.0.0.0/0,::/0

#

coba tambah allow dari dns-new ,ns1, ns2 dan 3 01022019

allow-notify-from=202.158.20.2,202.158.40.3,202.158.40.1,202.158.20.1 ::1

#################################

allow-recursion List of subnets that are allowed to recurse

#

allow-recursion=0.0.0.0/0

coba untuk allow recursionnya 06022019

allow-recursion=0.0.0.0/0

#################################

allow-unsigned-notify Allow unsigned notifications for TSIG secured domains

#

allow-unsigned-notify=yes

percobaan tamanih untuk allow notificationnnya 01022019

allow-unsigned-notify=yes

#################################

allow-unsigned-supermaster Allow supermasters to create zones without TSIG signed NOTIFY

#

allow-unsigned-supermaster=yes

#

percobaan tambahin untuk allow supermaster

allow-unsigned-supermaster=yes

#################################

also-notify When notifying a domain, also notify these nameservers

#

also-notify=

also-notify= 202.158.20.2,202.158.40.3,202.158.40.2,202.158.40.13,202.158.3.124

#################################

any-to-tcp Answer ANY queries with tc=1, shunting to TCP

#

any-to-tcp=yes

#################################

api Enable/disable the REST API

#

api=no

#################################

api-key Static pre-shared authentication key for access to the REST API

#

api-key=

#################################

api-logfile Location of the server logfile (used by the REST API)

#

api-logfile=/var/log/pdns.log

#################################

api-readonly Disallow data modification through the REST API when set

#

api-readonly=no

#################################

axfr-lower-serial Also AXFR a zone from a master with a lower serial

#

axfr-lower-serial=no

#################################

cache-ttl Seconds to store packets in the PacketCache

#

cache-ttl=20

#################################

carbon-interval Number of seconds between carbon (graphite) updates

#

carbon-interval=30

#################################

carbon-ourname If set, overrides our reported hostname for carbon stats

#

carbon-ourname=

#################################

carbon-server If set, send metrics in carbon (graphite) format to this server IP address

#

carbon-server=

#################################

chroot If set, chroot to this directory for more security

#

chroot=

#################################

config-dir Location of configuration directory (pdns.conf)

#

config-dir=/etc/pdns

tambahin config dir pdnsnya

config-dir=/etc/pdns

#################################

config-name Name of this virtual configuration - will rename the binary image

#

config-name=

#################################

control-console Debugging switch - don't use

#

control-console=no

#################################

daemon Operate as a daemon

#

daemon=no

ubah daemon jadi yes 06022019

daemon=yes

#################################

default-ksk-algorithms Default KSK algorithms

#

default-ksk-algorithms=ecdsa256

#################################

default-ksk-size Default KSK size (0 means default)

#

default-ksk-size=0

#################################

default-soa-edit Default SOA-EDIT value

#

default-soa-edit=

#################################

default-soa-edit-signed Default SOA-EDIT value for signed zones

#

default-soa-edit-signed=

#################################

default-soa-mail mail address to insert in the SOA record if none set in the backend

#

default-soa-mail=

#################################

default-soa-name name to insert in the SOA record if none set in the backend

#

default-soa-name=a.misconfigured.powerdns.server

#################################

default-ttl Seconds a result is valid if not set otherwise

#

default-ttl=3600

#################################

default-zsk-algorithms Default ZSK algorithms

#

default-zsk-algorithms=

#################################

default-zsk-size Default ZSK size (0 means default)

#

default-zsk-size=0

#################################

direct-dnskey Fetch DNSKEY RRs from backend during DNSKEY synthesis

#

direct-dnskey=no

#################################

disable-axfr Disable zonetransfers but do allow TCP queries

#

disable-axfr=no

#################################

disable-axfr-rectify Disable the rectify step during an outgoing AXFR. Only required for regression testing.

#

disable-axfr-rectify=no

#################################

disable-syslog Disable logging to syslog, useful when running inside a supervisor that logs stdout

#

disable-syslog=no

#################################

disable-tcp Do not listen to TCP queries

#

disable-tcp=no

#################################

distributor-threads Default number of Distributor (backend) threads to start

#

distributor-threads=3

#################################

dname-processing If we should support DNAME records

#

dname-processing=no

#################################

dnssec-key-cache-ttl Seconds to cache DNSSEC keys from the database

#

dnssec-key-cache-ttl=30

#################################

dnsupdate Enable/Disable DNS update (RFC2136) support. Default is no.

#

dnsupdate=no

#################################

do-ipv6-additional-processing Do AAAA additional processing

#

do-ipv6-additional-processing=yes

#################################

domain-metadata-cache-ttl Seconds to cache domain metadata from the database

#

domain-metadata-cache-ttl=60

#################################

edns-subnet-processing If we should act on EDNS Subnet options

#

edns-subnet-processing=no

#################################

entropy-source If set, read entropy from this file

#

entropy-source=/dev/urandom

#################################

experimental-lua-policy-script Lua script for the policy engine

#

experimental-lua-policy-script=

#################################

forward-dnsupdate A global setting to allow DNS update packages that are for a Slave domain, to be forwarded to the master.

#

forward-dnsupdate=yes

#################################

guardian Run within a guardian process

#

guardian=no

#################################

include-dir Include *.conf files from this directory

#

include-dir=

include-dir=/etc/pdns

#################################

launch Which backends to launch and order to query them in

#

launch=bind

coba nambahin launch bind tgl 31012019

launch=bind

launch=gmysql gmysql-host=localhost gmysql-user=powerdns gmysql-password=jakarta gmysql-dbname=powerdns

coba tambahin gmysql supermastersnya /percobaan

#################################

load-modules Load this module - supply absolute or relative path

#

load-modules=

#################################

local-address Local IP addresses to which we bind

#

local-address=0.0.0.0

#################################

local-address-nonexist-fail Fail to start if one or more of the local-address's do not exist on this server

#

local-address-nonexist-fail=yes

#################################

local-ipv6 Local IP address to which we bind

#

local-ipv6=::

#################################

local-ipv6-nonexist-fail Fail to start if one or more of the local-ipv6 addresses do not exist on this server

#

local-ipv6-nonexist-fail=yes

#################################

local-port The port on which we listen

#

local-port=53

buka port local 53

local-port=5300

#################################

log-dns-details If PDNS should log DNS non-erroneous details

#

log-dns-details=no

log-dns-details=on

#################################

log-dns-queries If PDNS should log all incoming DNS queries

#

log-dns-queries=no

#################################

logging-facility Log under a specific facility

#

logging-facility=

cba tambahin logging facility nya 01022019

logging-facility=0

#################################

loglevel Amount of logging. Higher is more. Do not set below 3

#

loglevel=4

loglevel=4 #################################

lua-axfr-script Script to be used to edit incoming AXFRs

#

lua-axfr-script=

#################################

lua-prequery-script Lua script with prequery handler (DO NOT USE)

#

lua-prequery-script=

#################################

master Act as a master

#

master=no

coba nambahin master /slave tgl 31012019

master=yes

#################################

max-cache-entries Maximum number of cache entries

#

max-cache-entries=1000000

#################################

max-ent-entries Maximum number of empty non-terminals in a zone

#

max-ent-entries=100000

#################################

max-nsec3-iterations Limit the number of NSEC3 hash iterations

#

max-nsec3-iterations=500

#################################

max-queue-length Maximum queuelength before considering situation lost

#

max-queue-length=5000

#################################

max-signature-cache-entries Maximum number of signatures cache entries

#

max-signature-cache-entries=

#################################

max-tcp-connections Maximum number of TCP connections

#

max-tcp-connections=20

#################################

module-dir Default directory for modules

#

module-dir=/usr/lib64/pdns

module-dir=/usr/lib64/pdns

#################################

negquery-cache-ttl Seconds to store negative query results in the QueryCache

#

negquery-cache-ttl=60

#################################

no-shuffle Set this to prevent random shuffling of answers - for regression testing

#

no-shuffle=off

#################################

non-local-bind Enable binding to non-local addresses by using FREEBIND / BINDANY socket options

#

non-local-bind=no

#################################

only-notify Only send AXFR NOTIFY to these IP addresses or netmasks

#

only-notify=0.0.0.0/0,::/0

coba nambahin untuk notify nya tgl 31012019

only-notify=0.0.0.0/0,::/0

#################################

out-of-zone-additional-processing Do out of zone additional processing

#

out-of-zone-additional-processing=yes

#################################

outgoing-axfr-expand-alias Expand ALIAS records during outgoing AXFR

#

outgoing-axfr-expand-alias=no

#################################

overload-queue-length Maximum queuelength moving to packetcache only

#

overload-queue-length=0

#################################

prevent-self-notification Don't send notifications to what we think is ourself

#

prevent-self-notification=yes

#################################

query-cache-ttl Seconds to store query results in the QueryCache

#

query-cache-ttl=20

#################################

query-local-address Source IP address for sending queries

#

query-local-address=0.0.0.0

#################################

query-local-address6 Source IPv6 address for sending queries

#

query-local-address6=::

#################################

query-logging Hint backends that queries should be logged

#

query-logging=no

dibawah ini coba nambahawin log buat query nya 31012019

query-logging=yes

#################################

queue-limit Maximum number of milliseconds to queue a query

#

queue-limit=1500

#################################

receiver-threads Default number of receiver threads to start

#

receiver-threads=1

#################################

recursive-cache-ttl Seconds to store packets for recursive queries in the PacketCache

#

recursive-cache-ttl=10

#################################

recursor If recursion is desired, IP address of a recursing nameserver

#

recursor=no

#################################

retrieval-threads Number of AXFR-retrieval threads for slave operation

#

retrieval-threads=2

#################################

reuseport Enable higher performance on compliant kernels by using SO_REUSEPORT allowing each receiver thread to open its own socket

#

reuseport=no

#################################

security-poll-suffix Domain name from which to query security update notifications

#

security-poll-suffix=

#################################

server-id Returned when queried for 'server.id' TXT or NSID, defaults to hostname - disabled or custom

#

server-id=

#################################

setgid If set, change group id to this gid for more security

# setgid=pdns

#################################

setuid If set, change user id to this uid for more security

# setuid=pdns

#################################

signing-threads Default number of signer threads to start

#

signing-threads=3

#################################

slave Act as a slave

#

slave=no

coba tambah slave nya di jadikan yes 01022019

slave=yes

#################################

slave-cycle-interval Schedule slave freshness checks once every .. seconds

#

slave-cycle-interval=60

coba tambah interval slave juga default 01022019

slave-cycle-interval=60

#################################

slave-renotify If we should send out notifications for slaved updates

#

slave-renotify=no

#################################

soa-expire-default Default SOA expire

#

soa-expire-default=604800

#################################

soa-minimum-ttl Default SOA minimum ttl

#

soa-minimum-ttl=3600

#################################

soa-refresh-default Default SOA refresh

#

soa-refresh-default=10800

#################################

soa-retry-default Default SOA retry

#

soa-retry-default=3600

#################################

socket-dir Where the controlsocket will live, /var/run when unset and not chrooted

#

socket-dir=

#################################

tcp-control-address If set, PowerDNS can be controlled over TCP on this address

#

tcp-control-address=

#################################

tcp-control-port If set, PowerDNS can be controlled over TCP on this address

#

tcp-control-port=53000

#################################

tcp-control-range If set, remote control of PowerDNS is possible over these networks only

#

tcp-control-range=127.0.0.0/8, 10.0.0.0/8, 192.168.0.0/16, 172.16.0.0/12, ::1/128, fe80::/10

#################################

tcp-control-secret If set, PowerDNS can be controlled over TCP after passing this secret

#

tcp-control-secret=

#################################

traceback-handler Enable the traceback handler (Linux only)

#

traceback-handler=yes

#################################

trusted-notification-proxy IP address of incoming notification proxy

#

trusted-notification-proxy=

#################################

udp-truncation-threshold Maximum UDP response size before we truncate

#

udp-truncation-threshold=1680

#################################

version-string PowerDNS version in packets - full, anonymous, powerdns or custom

#

version-string=full

#

string coba di set jd annonimous

version-string=anonymous

#################################

webserver Start a webserver for monitoring

#

webserver=no

#################################

webserver-address IP Address of webserver to listen on

#

webserver-address=127.0.0.1

#################################

webserver-allow-from Webserver access is only allowed from these subnets

#

webserver-allow-from=0.0.0.0/0,::/0

#################################

webserver-password Password required for accessing the webserver

#

webserver-password=

#################################

webserver-port Port of webserver to listen on

#

webserver-port=8081

#################################

webserver-print-arguments If the webserver should print arguments

#

webserver-print-arguments=no

#################################

write-pid Write a PID file

#

write-pid=yes

#################################

xfr-max-received-mbytes Maximum number of megabytes received from an incoming XFR

#

xfr-max-received-mbytes=100

from log , example

Feb 11 12:46:13 powerdns pdns[4351]: Query: select id,name,master,last_check from domains where type='SLAVE' Feb 11 12:46:13 powerdns pdns[4351]: Query: select id,name,master,last_check,notified_serial,type from domains where type='MASTER' Feb 11 12:46:13 powerdns pdns[4351]: Query: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=? Feb 11 12:46:13 powerdns pdns[4351]: Query: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=? Feb 11 12:46:13 powerdns pdns[4351]: Query: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=? Feb 11 12:46:13 powerdns pdns[4351]: Query: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=? Feb 11 12:46:13 powerdns pdns[4351]: Query: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=? Feb 11 12:46:13 powerdns pdns[4351]: Query: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=?

thansk

pieterlexis commented 5 years ago

I am closing this issue at it appears a support question and not a bug or issue. If you require further support, please post your issue with all configuration information and logs to the pdns-users mailinglist, or join us on IRC.