Brief description of powerDNS database table records

Source: Internet
Author: User
Tags domain server nslookup vcloud

Database Connection Method

[root@gd02-qa-plxt2-nodomain /]# mysql -u vipdns -pvipdns -h 10.0.3.99mysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || pdns               |+--------------------+2 rows in set (0.00 sec)

Note:
-U specified user name (vipdns)
-P password (vipdns)
-H specifies the host (10.0.3.99)
Default port 3306

Table Information

mysql> show tables;+--------------------+| Tables_in_pdns     |+--------------------+| cryptokeys         || domainmetadata     || domains            || perm_items         || perm_templ         || perm_templ_items   || records            || supermasters       || tsigkeys           || users              || zone_templ         || zone_templ_records || zones              |+--------------------+13 rows in set (0.00 sec)

Important: domain table records table

 

Domain table structure

mysql> desc domains;+-----------------+--------------+------+-----+---------+----------------+| Field           | Type         | Null | Key | Default | Extra          |+-----------------+--------------+------+-----+---------+----------------+| id              | int(11)      | NO   | PRI | NULL    | auto_increment || name            | varchar(255) | NO   | UNI | NULL    |                || master          | varchar(128) | YES  |     | NULL    |                || last_check      | int(11)      | YES  |     | NULL    |                || type            | varchar(6)   | NO   |     | NULL    |                || notified_serial | int(11)      | YES  |     | NULL    |                || account         | varchar(40)  | YES  |     | NULL    |                |+-----------------+--------------+------+-----+---------+----------------+7 rows in set (0.01 sec)

Data in the current domains table

mysql> select * from domains;+----+---------------------+--------+------------+--------+-----------------+---------+| id | name                | master | last_check | type   | notified_serial | account |+----+---------------------+--------+------------+--------+-----------------+---------+|  1 | vclound.com         | NULL   |       NULL | MASTER |            NULL | NULL    ||  2 | 3.0.10.in-addr.arpa | NULL   |       NULL | MASTER |            NULL | NULL    |+----+---------------------+--------+------------+--------+-----------------+---------+2 rows in set (0.00 sec)

Note:

Id-primary key name-domain name (two already added). First, check vclound.com master-unknown last_check-unknown type-whether the MASTER Domain Server is used (generally only one DNS is used as the master) notified_serial-Modify version information account-Unknown

Add a 163.com domain name and call an SQL example

 insert into pdns.domains (name, type) values ( '163.com', 'MASTER');

Update, delete, (omitted)

Records table structure

+-------------+--------------+------+-----+---------+----------------+| Field       | Type         | Null | Key | Default | Extra          |+-------------+--------------+------+-----+---------+----------------+| id          | int(11)      | NO   | PRI | NULL    | auto_increment || domain_id   | int(11)      | YES  | MUL | NULL    |                || name        | varchar(255) | YES  | MUL | NULL    |                || type        | varchar(10)  | YES  |     | NULL    |                || content     | mediumtext   | YES  |     | NULL    |                || ttl         | int(11)      | YES  |     | NULL    |                || prio        | int(11)      | YES  |     | NULL    |                || change_date | int(11)      | YES  |     | NULL    |                || ordername   | varchar(255) | YES  |     | NULL    |                || auth        | tinyint(1)   | YES  |     | NULL    |                |+-------------+--------------+------+-----+---------+----------------+10 rows in set (0.00 sec)

Note: records. domain_id is the foreign key of domains.

Table description

Id-primary key domain_id-domains table (id) foreign key name-domain name (vclound.com), forward resolution (ddns.vcloudn.com), reverse resolution Host name (105.3.0.10.in-addr. arpa) type-Description of the name field, such as (SOA [dns domain name) A [forward resolution] PTR [reverse resolution], MX [email server], the CNAME [host alias] field must be capitalized. The DNS resolution corresponding to the content-definition name [This is complicated when the type is SOA, however, you can refer to the current variable value as a fixed value] In ttl-cache, it can be used as a fixed value prio-priority level, ignoring change_date-timestamp ordername-ignoring auth-Unknown

Forward parsing data in the current form

mysql> select id, name, type, content, ttl, change_date from records where domain_id=1;+----+---------------------+------+----------------------------------------------------------------------+-------+-------------+| id | name                | type | content                                                              | ttl   | change_date |+----+---------------------+------+----------------------------------------------------------------------+-------+-------------+|  1 | vclound.com         | SOA  | ddns.vclound.com ddns.vclound.com 2014013003 28800 7200 604800 86400 | 86400 |  1391015078 ||  4 | pdnsweb.vclound.com | A    | 10.0.3.103                                                           | 86400 |  1391015359 ||  5 | pdns.vclound.com    | A    | 10.0.3.99                                                            | 86400 |  1391015379 ||  6 | pdnsdb.vclound.com  | A    | 10.0.3.99                                                            | 86400 |  1391015391 |+----+---------------------+------+----------------------------------------------------------------------+-------+-------------+


Reverse parsing data

mysql> select id, name, type, content, ttl, change_date from records where domain_id=2;+----+-------------------------+------+----------------------------------------------------------------------+-------+-------------+| id | name                    | type | content                                                              | ttl   | change_date |+----+-------------------------+------+----------------------------------------------------------------------+-------+-------------+|  2 | 3.0.10.in-addr.arpa     | SOA  | ddns.vclound.com ddns.vclound.com 2014013002 28800 7200 604800 86400 | 86400 |  1391015099 ||  3 | 99.3.0.10.in-addr.arpa  | PTR  | pdnsdb.vclound.com                                                   | 86400 |  1391015270 ||  7 | 103.3.0.10.in-addr.arpa | PTR  | pdnsweb.vcloud.com                                                   | 86400 |  1391018671 |+----+-------------------------+------+----------------------------------------------------------------------+-------+-------------+3 rows in set (0.00 sec)

 

Simulate the forward resolution method for adding 163.com
This is a Domain Name Record

insert into records (name, type, content, ttl, change_date) values ('163.com, 'SOA', 'dns.163.com dns.163.com 2014013002 28800 7200 604800 86400', '86400');

This is the host name record.
insert into records (name, type, content, ttl, change_date) values ('dns.163.com, 'A', '192.168.0.1', '86400');insert into records (name, type, content, ttl, change_date) values ('www.163.com, 'A', '192.168.0.2', '86400');

In this way, you can add two host records.

Similarly, remember that the domain name is 0.168.192.in-addr. arpa.

Verify dns method
/Etc/resolv. conf
Nameserver 10.0.3.99 <-must point to him

[root@gd02-qa-plxt2-nodomain /]# nslookup vclound.comServer:         10.0.3.99Address:        10.0.3.99#53*** Can't find vclound.com: No answer[root@gd02-qa-plxt2-nodomain /]# nslookup pdnsweb.vclound.comServer:         10.0.3.99Address:        10.0.3.99#53Name:   pdnsweb.vclound.comAddress: 10.0.3.103[root@gd02-qa-plxt2-nodomain /]# nslookup pdnsdb.vclound.comServer:         10.0.3.99Address:        10.0.3.99#53Name:   pdnsdb.vclound.comAddress: 10.0.3.99

For more information, see the preceding example. Note: domain names cannot be resolved directly.

Refer to reverse resolution examples

[root@gd02-qa-plxt2-nodomain /]# nslookup 10.0.3.99Server:         10.0.3.99Address:        10.0.3.99#5399.3.0.10.in-addr.arpa  name = pdnsdb.vclound.com.[root@gd02-qa-plxt2-nodomain /]# nslookup 10.0.3.103Server:         10.0.3.99Address:        10.0.3.99#53103.3.0.10.in-addr.arpa name = pdnsweb.vcloud.com.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.