Re: [Pdns-users] Force reload of MySQL-data

2007-02-09 Thread Christian Kuehn


Christian Kuehn wrote:
 Hi,
 
 how can I trigger the pdns_server to re-scan the mysql for new entries??
 

OK, I need to trigger pdns_server to see a new slave-domain in the
domains-table, any idea how to do this?

Best Regards
Christian


-- 
Christian Kühn
(Technical Consultant / Hostmaster)

==
MCS MOORBEK COMPUTER SYSTEME GmbH
Essener Bogen 17 - 22419 Hamburg - Germany
Tel +49 (0)40 53773 0 - Fax: +49 (0)40 53773 200
E-Mail: [EMAIL PROTECTED]
Web: http://www.mcs.de
Eingetragen im Handelsregister Hamburg B62933
Geschäftsführer: Kai Brandes  Eckard Kabel
GPG 8B52 41A1 4B8F 4DE7 9064  2073 6168 137A 3DDA 0F36
==
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users


Re: [Pdns-users] Force reload of MySQL-data

2007-02-09 Thread bert hubert
On Fri, Feb 09, 2007 at 09:42:03AM +0100, Christian Kuehn wrote:
 OK, I need to trigger pdns_server to see a new slave-domain in the
 domains-table, any idea how to do this?

Perhaps pdns_control rediscover will do this. Otherwise, wait 60 seconds, it
should pick up the new domain.

Bert

-- 
http://www.PowerDNS.com  Open source, database driven DNS Software 
http://netherlabs.nl  Open and Closed source services
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users


[Pdns-users] PowerDNS Master/Slave

2007-02-09 Thread Michael Holm

Hi..
Im trying to setup a PowerDNS server, one acting as master and the other 
one acting as slave... im running debian on both computer..


the problem is that.. when i add a domain in the database on my master 
(10.1.1.248), then i expect my slave (10.1.1.249) to get a notify about 
that.. and add it right away.. but nothing happens..
when i make a lookup on the master everything works fine.. but when i 
ask the slave.. i get no return.


i hope that someone can give me some help.. or some hints of what i 
possible can do wrong.


my configuration, database and log is below:

master config:
allow-axfr-ips=10.1.1.249
config-dir=/etc/powerdns
daemon=yes
disable-axfr=yes
guardian=yes
launch=gmysql
lazy-recursion=yes
local-address=10.1.1.248
local-port=53
master=yes
module-dir=/usr/lib/powerdns
recursor=MY ISP
setgid=pdns
setuid=pdns
socket-dir=/var/run
version-string=powerdns
include=/etc/powerdns/pdns.d

mysql select * from domains;
++--+-++++-+-+-+-+
| id | fkuserid | name| master | last_check | type   
| notified_serial | account | reverse | cdatetime   |

++--+-++++-+-+-+-+
|  1 |1 | sarge.lan   | NULL   |   NULL | NATIVE 
|NULL | NULL|   0 | 2007-02-09 14:26:33 |

++--+-++++-+-+-+-+

mysql select * from records where domain_id=3;
++---+---+--+--+---+--+-+-+--+
| id | domain_id | name  | type | 
content  | ttl   | prio | change_date | 
cdatetime   | editable |

++---+---+--+--+---+--+-+-+--+
| 11 | 1 | sarge.lan | SOA  | sarge.lan [EMAIL PROTECTED]  
2007020902 | 86400 | NULL |NULL | 2007-02-09 14:26:33 |0 |
| 12 | 1 | sarge.lan | NS   | 
ns1.example.com  | 86400 | NULL |NULL | 
2007-02-09 14:26:33 |0 |
| 13 | 1 | sarge.lan | NS   | 
ns2.example.com  | 86400 | NULL |NULL | 
2007-02-09 14:26:33 |0 |
| 14 | 1 | sarge.lan | A| 
10.1.1.248   | 86400 | NULL |NULL | 
2007-02-09 14:26:33 |1 |
| 15 | 1 | ns1.sarge.lan | A| 
10.1.1.248   | 86400 | NULL |NULL | 
2007-02-09 14:26:52 |1 |
| 16 | 1 | ns2.sarge.lan | A| 
10.1.1.249   | 86400 | NULL |NULL | 
2007-02-09 14:37:02 |1 |

++---+---+--+--+---+--+-+-+--+


and the slave:

first the configuration file:
config-dir=/etc/powerdns
daemon=yes
disable-axfr=yes
guardian=yes
launch=gmysql
lazy-recursion=yes
local-address=10.1.1.249
local-port=53
module-dir=/usr/lib/powerdns
recursor=62.199.234.11
setgid=pdns
setuid=pdns
slave=yes
socket-dir=/var/run
version-string=powerdns
include=/etc/powerdns/pdns.d


mysql select * from supermasters;
++++-+-+
| id | ip | nameserver | account | cdatetime   |
++++-+-+
|  1 | 10.1.1.248 | sarge.lan  | NULL| 2007-02-09 14:20:31 |
++++-+-+
1 row in set (0.00 sec)

[EMAIL PROTECTED]:~$ host -a sarge.lan
Trying sarge.lan
Host sarge.lan not found: 3(NXDOMAIN)
Received 102 bytes from 10.1.1.249#53 in 3 ms
[EMAIL PROTECTED]:~$ cat /etc/resolv.conf
nameserver 10.1.1.249
nameserver 10.1.1.248

[EMAIL PROTECTED]:~$ host -a sarge.lan
Trying sarge.lan
;; -HEADER- opcode: QUERY, status: NOERROR, id: 5201
;; flags: qr aa rd; QUERY: 1, ANSWER: 4, AUTHORITY: 0, ADDITIONAL: 0

;; QUESTION SECTION:
;sarge.lan. IN  ANY

;; ANSWER SECTION:
sarge.lan.  86400   IN  SOA sarge.lan. 
user.sarge.lan. 2007020902 10800 3600 604800 3600

sarge.lan.  86400   IN  NS  ns2.example.com.
sarge.lan.  86400   IN  NS  ns1.example.com.
sarge.lan.  86400   IN  A   10.1.1.248

Received 140 bytes from 10.1.1.248#53 in 123 ms
[EMAIL PROTECTED]:~$ cat /etc/resolv.conf
nameserver 10.1.1.248
nameserver 10.1.1.249

--
mvh
Michael Holm

___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users


[Pdns-users] Automatic SOA from LDAP backend

2007-02-09 Thread Andy Rabagliati
Folks,

  The SOA serial seems to be changing a lot quicker than my updates.

  Where is this calculated from ?

  A cursory examination of the source did not turn up anything.

  I would like it to change whenever I update anything domain-related in
  my LDAP server, which I share with users, and other stuff.

  I have this as my LDAP entry :-

416 dc=_forward_,ou=Computers,dc=aims,o=ami-net
dc: _forward_
objectClass: dNSDomain
objectClass: domainRelatedObject
mXRecord: 10 smtp.aims.ac.za
mXRecord: 20 wizzy.tuxlab.org.za
nSRecord: disa.tenet.ac.za.
nSRecord: hippo.ru.ac.za.
nSRecord: ns1.aims.ac.za.
nSRecord: ns2.aims.ac.za.
nSRecord: frogfoot.ami-net.org.
associatedDomain: aims.ac.za
businessCategory: Server
sOARecord: ns1.aims.ac.za [EMAIL PROTECTED] 0 1800 3600 1814400 84600

Cheers,  Andy!
___
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users