Bind dlz(mysql) with SRV Record

2010-07-27 Thread ShanyiWan
How to store SRV records in the database(mysql)? 

PRI、weight、port、target can be stored in  data field?
mysql select zone,host,type,data from dns_records where zone='zzz.cn' and 
type='srv'; 
+++--+-+
| zone   | host   | type | data|
+++--+-+
| zzz.cn | _ldap._tcp | SRV  | 5 30 5060 ldap2.zzz.cn. |
| zzz.cn | _ldap._tcp | SRV  | 10 30 5060 ldap.zzz.cn. |
+++--+-+
2 rows in set (0.00 sec)

C:\Users\Administratornslookup
默认服务器:  google-public-dns-a.google.com
Address:  8.8.8.8

 server 192.168.146.155
默认服务器:  [192.168.146.155]
Address:  192.168.146.155   
 set type=srv
 _ldap._tcp.zzz.cn
服务器:  [192.168.146.155]
Address:  192.168.146.155

_ldap._tcp.zzz.cn   SRV service location:
  priority   = 5
  weight = 30
  port   = 5060
  svr hostname   = ldap2.zzz.cn
zzz.cn  nameserver = ns2.mynameserver.com
zzz.cn  nameserver = ns1.mynameserver.com
 _ldap._tcp.zzz.cn
服务器:  [192.168.146.155]
Address:  192.168.146.155

_ldap._tcp.zzz.cn   SRV service location:
  priority   = 10
  weight = 30
  port   = 5060
  svr hostname   = ldap.zzz.cn
_ldap._tcp.zzz.cn   SRV service location:
  priority   = 5
  weight = 30
  port   = 5060
  svr hostname   = ldap2.zzz.cn
zzz.cn  nameserver = ns1.mynameserver.com
zzz.cn  nameserver = ns2.mynameserver.com

C:\Users\Administratordig @192.168.146.155 _ldap._tcp.zzz.cn srv

;  DiG 9.3.2  @192.168.146.155 _ldap._tcp.zzz.cn srv
; (1 server found)
;; global options:  printcmd
;; Got answer:
;; -HEADER- opcode: QUERY, status: NOERROR, id: 1656
;; flags: qr aa rd; QUERY: 1, ANSWER: 2, AUTHORITY: 2, ADDITIONAL: 0

;; QUESTION SECTION:
;_ldap._tcp.zzz.cn. IN  SRV

;; ANSWER SECTION:
_ldap._tcp.zzz.cn.  0   IN  SRV 10 30 5060 ldap.zzz.cn.
_ldap._tcp.zzz.cn.  0   IN  SRV 5 30 5060 ldap2.zzz.cn.

;; AUTHORITY SECTION:
zzz.cn. 0   IN  NS  ns1.mynameserver.com.
zzz.cn. 0   IN  NS  ns2.mynameserver.com.

;; Query time: 49 msec
;; SERVER: 192.168.146.155#53(192.168.146.155)
;; WHEN: Tue Jul 27 14:38:34 2010
;; MSG SIZE  rcvd: 145



Do this correct?

--
ShanyiWan
2010-07-27
___
bind-users mailing list
bind-users@lists.isc.org
https://lists.isc.org/mailman/listinfo/bind-users

bind dlz(mysql)

2010-06-30 Thread ShanyiWan
SOA Record query :

01-Jul-2010 12:00:09.121 dns_rdata_fromtext: buffer-0xbff9b414:1: near 
'20100701000': out of range
01-Jul-2010 12:00:09.121 dns_sdlz_putrr returned error. Error code was: out of 
range

What is the scope of the serial field values?

and data fields(table:dns_records) cannot be empty,which is the value of  
primary name server= in a SOA query?

--
ShanyiWan
2010-07-01

___
bind-users mailing list
bind-users@lists.isc.org
https://lists.isc.org/mailman/listinfo/bind-users


Re: bind dlz(mysql)

2010-06-30 Thread Mark Andrews

In message 201007011210381811...@114.com.cn, ShanyiWan writes:
 SOA Record query :
 
 01-Jul-2010 12:00:09.121 dns_rdata_fromtext: buffer-0xbff9b414:1: near '20100
 701000': out of range
 01-Jul-2010 12:00:09.121 dns_sdlz_putrr returned error. Error code was: out o
 f range
 What is the scope of the serial field values?

[0..4294967295]  (0, 2^32-1)

If you want to encode the date it should be MMDDVV (2V's) not
MMDDVVV (3V's).   MMDDVV is good until the start of 4295.

 and data fields(table:dns_records) cannot be empty,which is the value of  pr
 imary name server= in a SOA query?

Normally it is the name of the machine from which the other nameservers
transfer the zone contents.  As you are using DLZ the nameserver
to which you want update requests sent or use . as a placeholder.

Mark
-- 
Mark Andrews, ISC
1 Seymour St., Dundas Valley, NSW 2117, Australia
PHONE: +61 2 9871 4742 INTERNET: ma...@isc.org
___
bind-users mailing list
bind-users@lists.isc.org
https://lists.isc.org/mailman/listinfo/bind-users


Re: Favorite bind-dlz / mysql web based frontend?

2010-01-22 Thread David Ford
I don't use mysql, I use postgresql.  For web mgt, I use a locally
modified copy of Ant.

-david

On 01/22/10 13:34, da...@from525.com wrote:

 All,

 I was wondering if any of the folks out there using bind-dlz with
 mysql have found a decent web based tool for managing their data?

 Thanks,

 David Porsche


___
bind-users mailing list
bind-users@lists.isc.org
https://lists.isc.org/mailman/listinfo/bind-users